📚 SAP Business One SDK Help

Table Name: AGAR

Table Description: G/L Account Advanced Rules - History

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      
ItemCode Item No. nVarChar 50 OITM      
ItmsGrpCod Item Group Int 6 OITB      
WhsCode Warehouse Code nVarChar 8 OWHS      
BPGrpCod BP Group Int 6 OCRG      
LicTradNum Federal Tax ID nVarChar 32 - !^| !^| All
            !^|E Empty
            !^|F Filled
            Enter Tax ID Enter Tax ID
ShipCountr Ship-to Country/Region nVarChar 3 OCRY      
ShipState Ship-To State nVarChar 3 OCST      
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 Item Group
Transfered Year Transfer [Y/N] VarChar 1 - N Y Yes
            N No
FromDate From Date Date 8 -      
ToDate To Date Date 8 -      
DfltExpn Expense Account nVarChar 15 OACT      
DfltIncom Revenue Account nVarChar 15 OACT      
ExmptIncom Tax Exempt Revenue Account nVarChar 15 OACT      
StockAct Inventory Account nVarChar 15 OACT      
COGM_Act Cost of Goods Sold Account nVarChar 15 OACT      
AlocCstAct Allocation Account nVarChar 15 OACT      
VariancAct Variance Account nVarChar 15 OACT      
PricDifAct Price Difference Account nVarChar 15 OACT      
NegStckAct Negative Inventory Adj. Acct nVarChar 15 OACT      
DfltLoss Inventory Offset - Decr. Acct nVarChar 15 OACT      
DfltProfit Inventory Offset - Incr. Acct nVarChar 15 OACT      
RturnngAct Sales Returns Account nVarChar 15 OACT      
ECIncome Revenue Account - EU nVarChar 15 OACT      
ECExepnses Expense Account - EU nVarChar 15 OACT      
ForgnIncm Revenue Account - Foreign nVarChar 15 OACT      
ForgnExpn Expense Account - Foreign nVarChar 15 OACT      
PurchseAct Purchase Account nVarChar 15 OACT      
PaReturnAc Purchase Return Account nVarChar 15 OACT      
PaOffsetAc Purchase Offset Account nVarChar 15 OACT      
ExDiffAct Exchange Rate Differences Acct nVarChar 15 OACT      
BalanceAct Goods Clearing Account nVarChar 15 OACT      
DecresGlAc G/L Decrease Account nVarChar 15 OACT      
IncresGlAc G/L Increase Account nVarChar 15 OACT      
WipAcct WIP Inventory Account nVarChar 15 OACT      
WipVarAcct WIP Inventory Variance Account nVarChar 15 OACT      
WipOffset WIP Offset P&L Account nVarChar 15 OACT      
StockOffst Inventory Offset P&L Account nVarChar 15 OACT      
StockRvAct Inventory Revaluation Account nVarChar 15 OACT      
StkRvOfAct Inventory Reval. Offset Acct nVarChar 15 OACT      
CostRevAct COGS Revaluation Acct nVarChar 15 OACT      
CostOffAct COGS Revaluation Offset Acct nVarChar 15 OACT      
ExpClrAct Expense Clearing Account nVarChar 15 OACT      
ExpOfstAct Expense Offset Account nVarChar 15 OACT      
StkInTnAct Stock In Transit Account nVarChar 15 OACT      
ShpdGdsAct Shipped Goods Account nVarChar 15 OACT      
VatRevAct VAT in Revenue Account nVarChar 15 OACT      
ARCMAct Sales Credit Account nVarChar 15 OACT      
APCMAct Purchase Credit Account nVarChar 15 OACT      
ARCMExpAct Tax Exempt Credit Account nVarChar 15 OACT      
ARCMFrnAct Sales Credit Account - Foreign nVarChar 15 OACT      
APCMFrnAct Purchase Credit Acct - Foreign nVarChar 15 OACT      
ARCMEUAct Sales Credit Account - EU nVarChar 15 OACT      
APCMEUAct Purchase Credit Account - EU nVarChar 15 OACT      
PurBalAct Purchase Balance Account nVarChar 15 OACT      
WhICenAct Incoming CENVAT Account (WH) nVarChar 15 OACT      
WhOCenAct Outgoing CENVAT Account (WH) nVarChar 15 OACT      
Active Is Rule Active VarChar 1 - Y Y Yes
            N No
CmpPrivate Company/Private/Government VarChar 1 - A A All
            C Company
            I Private
            G Government
VatGroup Tax Definition nVarChar 8 OVTG      
CardCode Customer/Vendor Code nVarChar 15 OCRD      
Usage Usage Code for Document Int 11 OUSG      
FreeChrgSA Free of Charge Sales Account nVarChar 15 OACT      
FreeChrgPU Free of Charge Purchase Account nVarChar 15 OACT      
UDF1 User Defined Field 1 nVarChar 254 -      
UDF2 User Defined Field 2 nVarChar 254 -      
UDF3 User Defined Field 3 nVarChar 254 -      
UDF4 User Defined Field 4 nVarChar 254 -      
UDF5 User Defined Field 5 nVarChar 254 -      
Key Unique Field
PRIMARY Yes AbsEntry
    LogInstanc