📚 SAP Business One SDK Help

Table Name: OGRS

Table Description: G/L Account Advanced Rules for Resources

Field Description Type Size Related Default Value Constraints
AbsEntry Internal Number Int 11 -      
PeriodCat Period Category nVarChar 10 -      
FinancYear Beginning of Financial Year Date 8 -      
Year Financial Year Int 6 -      
PeriodName Period Name nVarChar 20 -      
SubType Sub-Period Type VarChar 1 - Y Y Year
            Q Quarters
            M Months
            D Days
PeriodNum Number of Periods Int 11 -      
F_RefDate Posting Date From Date 8 -      
T_RefDate Posting Date To Date 8 -      
F_DueDate Due Date From Date 8 -      
T_DueDate Due Date To Date 8 -      
F_TaxDate Document Date From Date 8 -      
T_TaxDate Document Date To Date 8 -      
LogInstanc Log Instance Int 11 -      
UpdateDate Date of Update Date 8 -      
UserSign User Signature Int 6 OUSR      
UserSign2 Updating User Int 6 OUSR      
ResCode Resource No. nVarChar 50 ORSC      
ResGrpCod Resource Group Int 6 ORSB      
WhsCode Warehouse Code nVarChar 8 -      
BPGrpCod BP Group Int 6 -      
LicTradNum Federal Tax ID nVarChar 32 - !^| !^| All
            !^|E Empty
            !^|F Filled
            Enter Tax ID Enter Tax ID
ShipCountr Ship-to Country/Region nVarChar 3 -      
ShipState Ship-To State nVarChar 3 -      
Comments Remarks nVarChar 254 -      
CreateDate Creation Date Date 8 -      
RuleCode Advanced Rule Code nVarChar 20 -      
GLMethod Get G/L Account By VarChar 1 - A A General
            W Warehouse
            C Resource Group
Transfered Year Transfer [Y/N] VarChar 1 - N Y Yes
            N No
FromDate From Date Date 8 -      
ToDate To Date Date 8 -      
ResRevAct Resource Revenue Account nVarChar 15 OACT      
ResExpAct Resource Expense Account nVarChar 15 OACT      
ResSaleAct Resource Sales Credit Account nVarChar 15 OACT      
ResPurAct Resource Purchase Credit Acct nVarChar 15 OACT      
ResNInvAct Resource Received Not Inv. Acct nVarChar 15 OACT      
ResStdExp1 Resource Std. Cost Expense 1 nVarChar 15 OACT      
ResStdExp2 Resource Std. Cost Expense 2 nVarChar 15 OACT      
ResStdExp3 Resource Std. Cost Expense 3 nVarChar 15 OACT      
ResStdExp4 Resource Std. Cost Expense 4 nVarChar 15 OACT      
ResStdExp5 Resource Std. Cost Expense 5 nVarChar 15 OACT      
ResStdExp6 Resource Std. Cost Expense 6 nVarChar 15 OACT      
ResStdExp7 Resource Std. Cost Expense 7 nVarChar 15 OACT      
ResStdExp8 Resource Std. Cost Expense 8 nVarChar 15 OACT      
ResStdExp9 Resource Std. Cost Expense 9 nVarChar 15 OACT      
ResStdEx10 Resource Std. Cost Expense 10 nVarChar 15 OACT      
ResWipAct Resource WIP Account nVarChar 15 OACT      
ResScrapAc Scrap Account nVarChar 15 OACT      
WipOffPlAc WIP Offset P&L Account nVarChar 15 OACT      
ResOffPlAc Resource Offset P&L Account nVarChar 15 OACT      
Active Is Rule Active VarChar 1 - Y Y Yes
            N No
CmpPrivate Company/Private VarChar 1 - A A All
            C Company
            I Private
VatGroup Tax Definition nVarChar 8 OVTG      
CardCode Customer/Vendor Code nVarChar 15 OCRD      
Usage Usage Code for Document Int 11 OUSG      
Key Unique Field
PRIMARY Yes AbsEntry