biuan SAP® BUSINESS ONE SDK
SQL Banking / Incoming Payment - Account List - History
API ARC4
ARC4 - Incoming Payment - Account List - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11ORCT
Incoming Payment		PRIMARYYes
LineIdRow NumberInt
11
AcctCodeAccountnVarChar
15OACT
G/L Accounts
SumAppliedPaidNum
20
AppliedFCPaid (FC)Num
20
AppliedSysPaid (SC)Num
20
DescripDetailsnVarChar
127
VatGroupTax DefinitionnVarChar
8OVTG
Tax Definition
VatPrcntTax %Num
20
AcctNameAccount NamenVarChar
100
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History		24
LogInstancLog InstanceInt
11
0
OcrCodeDistribution RulenVarChar
8OOCR
Distribution Rule
ProjectProject CodenVarChar
20OPRJ
Project Codes
GrossAmntGross AmountNum
20
GrssAmntFCGross Amount (FC)Num
20
GrssAmntSCGross Amount (SC)Num
20
AmntBaseBase AmountVarChar
E) Exclude Tax
I) Include Tax
1
VatAmntVAT AmountNum
20
VatAmntFCVAT Amount (FC)Num
20
VatAmntSCVAT Amount (SC)Num
20
UserChaVatUser Changed VATVarChar
N) No
Y) Yes
1
N
TaxTypeIDTax Type Component IDInt
11OSTT
Sales Tax Authorities Type
OcrCode2Distribution Rule2nVarChar
8OOCR
Distribution Rule
OcrCode3Distribution Rule3nVarChar
8OOCR
Distribution Rule
OcrCode4Distribution Rule4nVarChar
8OOCR
Distribution Rule
OcrCode5Distribution Rule5nVarChar
8OOCR
Distribution Rule
SectionSectionInt
11OSEC
Sections
AsseTypeAssessee TypeVarChar
C) Company
P) Others
1
LocCodeLocation CodeInt
11OLCT
Location
MatTypeMaterial TypeInt
11
0
EquVatPerEqualization Tax RateNum
20
EquVatSumEqualization VAT AmountNum
20
EquVatSumFEqualization VAT Amount (FC)Num
20
EquVatSumSEqualization VAT Amount (SC)Num
20

Table relationship map

SELECT statement

SELECT ARC4.DocNum AS 'Document Number', ARC4.LineId AS 'Row Number', ARC4.AcctCode AS 'Account', ARC4.SumApplied AS 'Paid', ARC4.AppliedFC AS 'Paid (FC)', ARC4.AppliedSys AS 'Paid (SC)', ARC4.Descrip AS 'Details', ARC4.VatGroup AS 'Tax Definition', ARC4.VatPrcnt AS 'Tax %', ARC4.AcctName AS 'Account Name', ARC4.ObjType AS 'Object Type', ARC4.LogInstanc AS 'Log Instance', ARC4.OcrCode AS 'Distribution Rule', ARC4.Project AS 'Project Code', ARC4.GrossAmnt AS 'Gross Amount', ARC4.GrssAmntFC AS 'Gross Amount (FC)', ARC4.GrssAmntSC AS 'Gross Amount (SC)', ARC4.AmntBase AS 'Base Amount', ARC4.VatAmnt AS 'VAT Amount', ARC4.VatAmntFC AS 'VAT Amount (FC)', ARC4.VatAmntSC AS 'VAT Amount (SC)', ARC4.UserChaVat AS 'User Changed VAT', ARC4.TaxTypeID AS 'Tax Type Component ID', ARC4.OcrCode2 AS 'Distribution Rule2', ARC4.OcrCode3 AS 'Distribution Rule3', ARC4.OcrCode4 AS 'Distribution Rule4', ARC4.OcrCode5 AS 'Distribution Rule5', ARC4.Section AS 'Section', ARC4.AsseType AS 'Assessee Type', ARC4.LocCode AS 'Location Code', ARC4.MatType AS 'Material Type', ARC4.EquVatPer AS 'Equalization Tax Rate', ARC4.EquVatSum AS 'Equalization VAT Amount', ARC4.EquVatSumF AS 'Equalization VAT Amount (FC)', ARC4.EquVatSumS AS 'Equalization VAT Amount (SC)' FROM ARC4 AS ARC4

Related information


G/L Accounts OACT SQL Table

Incoming Payment ORCT SQL Table

Location OLCT SQL Table

Object Settings - History ADP1 SQL Table

Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Sections OSEC SQL Table

Sales Tax Authorities Type OSTT 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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates