biuan SAP® BUSINESS ONE SDK
API AGAR
AGAR - G/L Account Advanced Rules - History 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
ItemCodeItem No.nVarChar
20OITM
Items
ItmsGrpCodItem GroupInt
6OITB
Item Groups
WhsCodeWarehouse CodenVarChar
8OWHS
Warehouses
BPGrpCodBP GroupInt
6OCRG
Card Groups
LicTradNumFederal Tax IDnVarChar
!^|) All
!^|E) Empty
!^|F) Filled
Enter Tax ID) Enter Tax ID
32
!^|
ShipCountrShip-to CountrynVarChar
3OCRY
Countries
ShipStateShip-To StatenVarChar
3OCST
States
CommentsRemarksnVarChar
127
CreateDateCreation DateDate
8
RuleCodeAdvanced Rule CodenVarChar
20
GLMethodGet G/L Account ByVarChar
A) General
W) Warehouse
C) Item Group
1
A
TransferedYear Transfer [Y/N]VarChar
Y) Yes
N) No
1
N
FromDateFrom DateDate
8
ToDateTo DateDate
8
DfltExpnExpense AccountnVarChar
15OACT
G/L Accounts
DfltIncomRevenue AccountnVarChar
15OACT
G/L Accounts
ExmptIncomTax Exempt Revenue AccountnVarChar
15OACT
G/L Accounts
StockActInventory AccountnVarChar
15OACT
G/L Accounts
COGM_ActCost of Goods Sold AccountnVarChar
15OACT
G/L Accounts
AlocCstActAllocation AccountnVarChar
15OACT
G/L Accounts
VariancActVariance AccountnVarChar
15OACT
G/L Accounts
PricDifActPrice Difference AccountnVarChar
15OACT
G/L Accounts
NegStckActNegative Inventory Adj. AcctnVarChar
15OACT
G/L Accounts
DfltLossInventory Offset - Decr. AcctnVarChar
15OACT
G/L Accounts
DfltProfitInventory Offset - Incr. AcctnVarChar
15OACT
G/L Accounts
RturnngActSales Returns AccountnVarChar
15OACT
G/L Accounts
ECIncomeRevenue Account - EUnVarChar
15OACT
G/L Accounts
ECExepnsesExpense Account - EUnVarChar
15OACT
G/L Accounts
ForgnIncmRevenue Account - ForeignnVarChar
15OACT
G/L Accounts
ForgnExpnExpense Account - ForeignnVarChar
15OACT
G/L Accounts
PurchseActPurchase AccountnVarChar
15OACT
G/L Accounts
PaReturnAcPurchase Return AccountnVarChar
15OACT
G/L Accounts
PaOffsetAcPurchase Offset AccountnVarChar
15OACT
G/L Accounts
ExDiffActExchange Rate Differences AcctnVarChar
15OACT
G/L Accounts
BalanceActGoods Clearing AccountnVarChar
15OACT
G/L Accounts
DecresGlAcG/L Decrease AccountnVarChar
15OACT
G/L Accounts
IncresGlAcG/L Increase AccountnVarChar
15OACT
G/L Accounts
WipAcctWIP Inventory AccountnVarChar
15OACT
G/L Accounts
WipVarAcctWIP Inventory Variance AccountnVarChar
15OACT
G/L Accounts
WipOffsetWIP Offset P&L AccountnVarChar
15OACT
G/L Accounts
StockOffstInventory Offset P&L AccountnVarChar
15OACT
G/L Accounts
StockRvActInventory Revaluation AccountnVarChar
15OACT
G/L Accounts
StkRvOfActInventory Reval. Offset AcctnVarChar
15OACT
G/L Accounts
CostRevActCOGS Revaluation AcctnVarChar
15OACT
G/L Accounts
CostOffActCOGS Revaluation Offset AcctnVarChar
15OACT
G/L Accounts
ExpClrActExpense Clearing AccountnVarChar
15OACT
G/L Accounts
ExpOfstActExpense Offset AccountnVarChar
15OACT
G/L Accounts
StkInTnActStock In Transit AccountnVarChar
15OACT
G/L Accounts
ShpdGdsActShipped Goods AccountnVarChar
15OACT
G/L Accounts
VatRevActVAT in Revenue AccountnVarChar
15OACT
G/L Accounts
ARCMActSales Credit AccountnVarChar
15OACT
G/L Accounts
APCMActPurchase Credit AccountnVarChar
15OACT
G/L Accounts
ARCMExpActTax Exempt Credit AccountnVarChar
15OACT
G/L Accounts
ARCMFrnActSales Credit Account - ForeignnVarChar
15OACT
G/L Accounts
APCMFrnActPurchase Credit Acct - ForeignnVarChar
15OACT
G/L Accounts
ARCMEUActSales Credit Account - EUnVarChar
15OACT
G/L Accounts
APCMEUActPurchase Credit Account - EUnVarChar
15OACT
G/L Accounts
PurBalActPurchase Balance AccountnVarChar
15OACT
G/L Accounts
WhICenActIncoming CENVAT Account (WH)nVarChar
15OACT
G/L Accounts
WhOCenActOutgoing CENVAT Account (WH)nVarChar
15OACT
G/L Accounts
ActiveIs Rule ActiveVarChar
Y) Yes
N) No
1
Y
CmpPrivateCompany/Private/GovernmentVarChar
A) All
C) Company
I) Private
G) Government
1
A
VatGroupTax DefinitionnVarChar
8OVTG
Tax Definition
CardCodeCustomer/Vendor CodenVarChar
15OCRD
Business Partner
UsageUsage Code for DocumentInt
11OUSG
Usage of Nota Fiscal
FreeChrgSAFree of Charge Sales AccountnVarChar
15OACT
G/L Accounts
FreeChrgPUFree of Charge Purchase AccountnVarChar
15OACT
G/L Accounts

Table relationship map

SELECT statement

SELECT AGAR.AbsEntry AS 'Internal Number', AGAR.PeriodCat AS 'Period Category', AGAR.FinancYear AS 'Beginning of Financial Year', AGAR.Year AS 'Financial Year', AGAR.PeriodName AS 'Period Name', AGAR.SubType AS 'Sub-Period Type', AGAR.PeriodNum AS 'Number of Periods', AGAR.F_RefDate AS 'Posting Date From', AGAR.T_RefDate AS 'Posting Date To', AGAR.F_DueDate AS 'Due Date From', AGAR.T_DueDate AS 'Due Date To', AGAR.F_TaxDate AS 'Document Date From', AGAR.T_TaxDate AS 'Document Date To', AGAR.LogInstanc AS 'Log Instance', AGAR.UpdateDate AS 'Date of Update', AGAR.UserSign AS 'User Signature', AGAR.UserSign2 AS 'Updating User', AGAR.ItemCode AS 'Item No.', AGAR.ItmsGrpCod AS 'Item Group', AGAR.WhsCode AS 'Warehouse Code', AGAR.BPGrpCod AS 'BP Group', AGAR.LicTradNum AS 'Federal Tax ID', AGAR.ShipCountr AS 'Ship-to Country', AGAR.ShipState AS 'Ship-To State', AGAR.Comments AS 'Remarks', AGAR.CreateDate AS 'Creation Date', AGAR.RuleCode AS 'Advanced Rule Code', AGAR.GLMethod AS 'Get G/L Account By', AGAR.Transfered AS 'Year Transfer [Y/N]', AGAR.FromDate AS 'From Date', AGAR.ToDate AS 'To Date', AGAR.DfltExpn AS 'Expense Account', AGAR.DfltIncom AS 'Revenue Account', AGAR.ExmptIncom AS 'Tax Exempt Revenue Account', AGAR.StockAct AS 'Inventory Account', AGAR.COGM_Act AS 'Cost of Goods Sold Account', AGAR.AlocCstAct AS 'Allocation Account', AGAR.VariancAct AS 'Variance Account', AGAR.PricDifAct AS 'Price Difference Account', AGAR.NegStckAct AS 'Negative Inventory Adj. Acct', AGAR.DfltLoss AS 'Inventory Offset - Decr. Acct', AGAR.DfltProfit AS 'Inventory Offset - Incr. Acct', AGAR.RturnngAct AS 'Sales Returns Account', AGAR.ECIncome AS 'Revenue Account - EU', AGAR.ECExepnses AS 'Expense Account - EU', AGAR.ForgnIncm AS 'Revenue Account - Foreign', AGAR.ForgnExpn AS 'Expense Account - Foreign', AGAR.PurchseAct AS 'Purchase Account', AGAR.PaReturnAc AS 'Purchase Return Account', AGAR.PaOffsetAc AS 'Purchase Offset Account', AGAR.ExDiffAct AS 'Exchange Rate Differences Acct', AGAR.BalanceAct AS 'Goods Clearing Account', AGAR.DecresGlAc AS 'G/L Decrease Account', AGAR.IncresGlAc AS 'G/L Increase Account', AGAR.WipAcct AS 'WIP Inventory Account', AGAR.WipVarAcct AS 'WIP Inventory Variance Account', AGAR.WipOffset AS 'WIP Offset P&L Account', AGAR.StockOffst AS 'Inventory Offset P&L Account', AGAR.StockRvAct AS 'Inventory Revaluation Account', AGAR.StkRvOfAct AS 'Inventory Reval. Offset Acct', AGAR.CostRevAct AS 'COGS Revaluation Acct', AGAR.CostOffAct AS 'COGS Revaluation Offset Acct', AGAR.ExpClrAct AS 'Expense Clearing Account', AGAR.ExpOfstAct AS 'Expense Offset Account', AGAR.StkInTnAct AS 'Stock In Transit Account', AGAR.ShpdGdsAct AS 'Shipped Goods Account', AGAR.VatRevAct AS 'VAT in Revenue Account', AGAR.ARCMAct AS 'Sales Credit Account', AGAR.APCMAct AS 'Purchase Credit Account', AGAR.ARCMExpAct AS 'Tax Exempt Credit Account', AGAR.ARCMFrnAct AS 'Sales Credit Account - Foreign', AGAR.APCMFrnAct AS 'Purchase Credit Acct - Foreign', AGAR.ARCMEUAct AS 'Sales Credit Account - EU', AGAR.APCMEUAct AS 'Purchase Credit Account - EU', AGAR.PurBalAct AS 'Purchase Balance Account', AGAR.WhICenAct AS 'Incoming CENVAT Account (WH)', AGAR.WhOCenAct AS 'Outgoing CENVAT Account (WH)', AGAR.Active AS 'Is Rule Active', AGAR.CmpPrivate AS 'Company/Private/Government', AGAR.VatGroup AS 'Tax Definition', AGAR.CardCode AS 'Customer/Vendor Code', AGAR.Usage AS 'Usage Code for Document', AGAR.FreeChrgSA AS 'Free of Charge Sales Account', AGAR.FreeChrgPU AS 'Free of Charge Purchase Account' FROM AGAR AS AGAR

Related information


G/L Accounts OACT SQL Table

Card Groups OCRG SQL Table

Business Partner OCRD SQL Table

Items OITM SQL Table

Item Groups OITB SQL Table

Countries OCRY SQL Table

States OCST SQL Table

Usage of Nota Fiscal OUSG SQL Table

Users OUSR SQL Table

Tax Definition OVTG SQL Table

Warehouses OWHS 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