biuan SAP® BUSINESS ONE SDK
API ARC5
ARC5 - Reciept log vat adjustment-History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument No. - HistoryInt
11ORCT
Incoming Payment
PRIMARYYes
InvEntryInvoice Key - HistoryInt
11OINV
A/R Invoice
LineNumRow Number - HistoryInt
11
ObjTypeObject Type - HistorynVarChar
20ADP1
Object Settings - History
LogInstancLog Instance - HistoryInt
11
0
VatGroupTax Group - HistorynVarChar
8OVTG
Tax Definition
VatPrcntTax % - HistoryNum
20
VatSumTax Amount - HistoryNum
20
BaseSumBase Amount - HistoryNum
20
NoDedSumNon-Deductible AmountNum
20
BaseSumFcBase Amount (FC)Num
20
VatSumFcTax Amount (FC)Num
20
NoDedSumFcNon-Deductible Amount (FC)Num
20
BaseSumScBase Amount (SC)Num
20
NoDedSumScNon-Deductible Amount (SC)Num
20
VatSumScVAT Amount (SC)Num
20
CashDiscAcCash Discount AccountnVarChar
15
BaseObjArrBase Object Array NumberInt
6
1
BaseObjBase ObjectInt
11
13
InstlmntIdInstallment IDInt
6
0
GroupNumGroup NumberInt
11
0
LineSeqRow SequenceInt
11
-1
EquVatPerEqualization Tax %Num
20
EquVatSumTotal Equalization TaxNum
20
EquVatSumFTotal Equalization Tax (FC)Num
20
EquVatSumSTotal Equalization Tax (SC)Num
20

Table relationship map

SELECT statement

SELECT ARC5.DocNum AS 'Document No. - History', ARC5.InvEntry AS 'Invoice Key - History', ARC5.LineNum AS 'Row Number - History', ARC5.ObjType AS 'Object Type - History', ARC5.LogInstanc AS 'Log Instance - History', ARC5.VatGroup AS 'Tax Group - History', ARC5.VatPrcnt AS 'Tax % - History', ARC5.VatSum AS 'Tax Amount - History', ARC5.BaseSum AS 'Base Amount - History', ARC5.NoDedSum AS 'Non-Deductible Amount', ARC5.BaseSumFc AS 'Base Amount (FC)', ARC5.VatSumFc AS 'Tax Amount (FC)', ARC5.NoDedSumFc AS 'Non-Deductible Amount (FC)', ARC5.BaseSumSc AS 'Base Amount (SC)', ARC5.NoDedSumSc AS 'Non-Deductible Amount (SC)', ARC5.VatSumSc AS 'VAT Amount (SC)', ARC5.CashDiscAc AS 'Cash Discount Account', ARC5.BaseObjArr AS 'Base Object Array Number', ARC5.BaseObj AS 'Base Object', ARC5.InstlmntId AS 'Installment ID', ARC5.GroupNum AS 'Group Number', ARC5.LineSeq AS 'Row Sequence', ARC5.EquVatPer AS 'Equalization Tax %', ARC5.EquVatSum AS 'Total Equalization Tax', ARC5.EquVatSumF AS 'Total Equalization Tax (FC)', ARC5.EquVatSumS AS 'Total Equalization Tax (SC)' FROM ARC5 AS ARC5

Related information


Incoming Payment ORCT SQL Table

A/R Invoice OINV SQL Table

Object Settings - History ADP1 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