biuan SAP® BUSINESS ONE SDK
SQL Banking / Incoming Payments - Tax Amount per Document - History
API ARC7
ARC7 - Incoming Payments - Tax Amount per Document - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocNum KEY UNIQUEDocument NumberInt
11ORCT
Incoming Payment		PRIMARYYes
LineSeqRow SequenceInt
11
InvoiceSeqInvoice Sequence NumberInt
11
ValueDateDue DateDate
8
Inv4SeqINV4 Sequence NumberInt
11
TaxSumTax AmountNum
20
TaxSumFrgnTax Amount (FC)Num
20
TaxSumSysTax Amount (SC)Num
20
BaseSumBase AmountNum
20
BaseSumFrgBase Amount (FC)Num
20
BaseSumSysBase Amount (SC)Num
20
ObjectTypeObject TypenVarChar
20ADP1
Object Settings - History		24
LogInstancLog InstanceInt
11
0

Table relationship map

SELECT statement

SELECT ARC7.DocNum AS 'Document Number', ARC7.LineSeq AS 'Row Sequence', ARC7.InvoiceSeq AS 'Invoice Sequence Number', ARC7.ValueDate AS 'Due Date', ARC7.Inv4Seq AS 'INV4 Sequence Number', ARC7.TaxSum AS 'Tax Amount', ARC7.TaxSumFrgn AS 'Tax Amount (FC)', ARC7.TaxSumSys AS 'Tax Amount (SC)', ARC7.BaseSum AS 'Base Amount', ARC7.BaseSumFrg AS 'Base Amount (FC)', ARC7.BaseSumSys AS 'Base Amount (SC)', ARC7.ObjectType AS 'Object Type', ARC7.LogInstanc AS 'Log Instance' FROM ARC7 AS ARC7

Related information


Incoming Payment ORCT SQL Table

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