biuan SAP® BUSINESS ONE SDK
API OGRS
OGRS - G/L Account Advanced Rules for Resources Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
PeriodCatPeriod CategorynVarChar
10
FinancYearBeginning of Financial YearDate
8
YearFinancial YearInt
6
PeriodNamePeriod NamenVarChar
20
SubTypeSub-Period TypeVarChar
Y) Year
Q) Quarters
M) Months
D) Days
1
Y
PeriodNumNumber of PeriodsInt
11
F_RefDatePosting Date FromDate
8
T_RefDatePosting Date ToDate
8
F_DueDateDue Date FromDate
8
T_DueDateDue Date ToDate
8
F_TaxDateDocument Date FromDate
8
T_TaxDateDocument Date ToDate
8
LogInstancLog InstanceInt
11
UpdateDateDate of UpdateDate
8
UserSignUser SignatureInt
6OUSR
Users
UserSign2Updating UserInt
6OUSR
Users
ResCodeResource No.nVarChar
20ORSC
Resources
ResGrpCodResource GroupInt
6ORSB
Resource Groups
WhsCodeWarehouse CodenVarChar
8
BPGrpCodBP GroupInt
6
LicTradNumFederal Tax IDnVarChar
!^|) All
!^|E) Empty
!^|F) Filled
Enter Tax ID) Enter Tax ID
32
!^|
ShipCountrShip-To CountrynVarChar
3
ShipStateShip-To StatenVarChar
3
CommentsRemarksnVarChar
127
CreateDateCreation DateDate
8
RuleCodeAdvanced Rule CodenVarChar
20
GLMethodGet G/L Account ByVarChar
A) General
W) Warehouse
C) Resource Group
1
A
TransferedYear Transfer [Y/N]VarChar
Y) Yes
N) No
1
N
FromDateFrom DateDate
8
ToDateTo DateDate
8
ResRevActResource Revenue AccountnVarChar
15OACT
G/L Accounts
ResExpActResource Expense AccountnVarChar
15OACT
G/L Accounts
ResSaleActResource Sales Credit AccountnVarChar
15OACT
G/L Accounts
ResPurActResource Purchase Credit AcctnVarChar
15OACT
G/L Accounts
ResNInvActResource Received Not Inv. AcctnVarChar
15OACT
G/L Accounts
ResStdExp1Resource Std. Cost Expense 1nVarChar
15OACT
G/L Accounts
ResStdExp2Resource Std. Cost Expense 2nVarChar
15OACT
G/L Accounts
ResStdExp3Resource Std. Cost Expense 3nVarChar
15OACT
G/L Accounts
ResStdExp4Resource Std. Cost Expense 4nVarChar
15OACT
G/L Accounts
ResStdExp5Resource Std. Cost Expense 5nVarChar
15OACT
G/L Accounts
ResStdExp6Resource Std. Cost Expense 6nVarChar
15OACT
G/L Accounts
ResStdExp7Resource Std. Cost Expense 7nVarChar
15OACT
G/L Accounts
ResStdExp8Resource Std. Cost Expense 8nVarChar
15OACT
G/L Accounts
ResStdExp9Resource Std. Cost Expense 9nVarChar
15OACT
G/L Accounts
ResStdEx10Resource Std. Cost Expense 10nVarChar
15OACT
G/L Accounts
ResWipActResource WIP AccountnVarChar
15OACT
G/L Accounts
ResScrapAcScrap AccountnVarChar
15OACT
G/L Accounts
WipOffPlAcWIP Offset P&L AccountnVarChar
15OACT
G/L Accounts
ResOffPlAcResource Offset P&L AccountnVarChar
15OACT
G/L Accounts
ActiveIs Rule ActiveVarChar
Y) Yes
N) No
1
Y
CmpPrivateCompany/PrivateVarChar
A) All
C) Company
I) Private
1
A
VatGroupTax DefinitionnVarChar
8OVTG
Tax Definition
CardCodeCustomer/Vendor CodenVarChar
15OCRD
Business Partner
UsageUsage Code for DocumentInt
11OUSG
Usage of Nota Fiscal

Table relationship map

SELECT statement

SELECT OGRS.AbsEntry AS 'Internal Number', OGRS.PeriodCat AS 'Period Category', OGRS.FinancYear AS 'Beginning of Financial Year', OGRS.Year AS 'Financial Year', OGRS.PeriodName AS 'Period Name', OGRS.SubType AS 'Sub-Period Type', OGRS.PeriodNum AS 'Number of Periods', OGRS.F_RefDate AS 'Posting Date From', OGRS.T_RefDate AS 'Posting Date To', OGRS.F_DueDate AS 'Due Date From', OGRS.T_DueDate AS 'Due Date To', OGRS.F_TaxDate AS 'Document Date From', OGRS.T_TaxDate AS 'Document Date To', OGRS.LogInstanc AS 'Log Instance', OGRS.UpdateDate AS 'Date of Update', OGRS.UserSign AS 'User Signature', OGRS.UserSign2 AS 'Updating User', OGRS.ResCode AS 'Resource No.', OGRS.ResGrpCod AS 'Resource Group', OGRS.WhsCode AS 'Warehouse Code', OGRS.BPGrpCod AS 'BP Group', OGRS.LicTradNum AS 'Federal Tax ID', OGRS.ShipCountr AS 'Ship-To Country', OGRS.ShipState AS 'Ship-To State', OGRS.Comments AS 'Remarks', OGRS.CreateDate AS 'Creation Date', OGRS.RuleCode AS 'Advanced Rule Code', OGRS.GLMethod AS 'Get G/L Account By', OGRS.Transfered AS 'Year Transfer [Y/N]', OGRS.FromDate AS 'From Date', OGRS.ToDate AS 'To Date', OGRS.ResRevAct AS 'Resource Revenue Account', OGRS.ResExpAct AS 'Resource Expense Account', OGRS.ResSaleAct AS 'Resource Sales Credit Account', OGRS.ResPurAct AS 'Resource Purchase Credit Acct', OGRS.ResNInvAct AS 'Resource Received Not Inv. Acct', OGRS.ResStdExp1 AS 'Resource Std. Cost Expense 1', OGRS.ResStdExp2 AS 'Resource Std. Cost Expense 2', OGRS.ResStdExp3 AS 'Resource Std. Cost Expense 3', OGRS.ResStdExp4 AS 'Resource Std. Cost Expense 4', OGRS.ResStdExp5 AS 'Resource Std. Cost Expense 5', OGRS.ResStdExp6 AS 'Resource Std. Cost Expense 6', OGRS.ResStdExp7 AS 'Resource Std. Cost Expense 7', OGRS.ResStdExp8 AS 'Resource Std. Cost Expense 8', OGRS.ResStdExp9 AS 'Resource Std. Cost Expense 9', OGRS.ResStdEx10 AS 'Resource Std. Cost Expense 10', OGRS.ResWipAct AS 'Resource WIP Account', OGRS.ResScrapAc AS 'Scrap Account', OGRS.WipOffPlAc AS 'WIP Offset P&L Account', OGRS.ResOffPlAc AS 'Resource Offset P&L Account', OGRS.Active AS 'Is Rule Active', OGRS.CmpPrivate AS 'Company/Private', OGRS.VatGroup AS 'Tax Definition', OGRS.CardCode AS 'Customer/Vendor Code', OGRS.Usage AS 'Usage Code for Document' FROM OGRS AS OGRS

Related information


Business Partner OCRD SQL Table

Resources ORSC SQL Table

G/L Accounts OACT SQL Table

Resource Groups ORSB SQL Table

Usage of Nota Fiscal OUSG SQL Table

Users OUSR SQL Table

Tax Definition OVTG SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates