biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Tax Invoice - History - Rows
API ATX1
ATX1 - Tax Invoice - History - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BaseEntry KEY UNIQUEBase Document Internal IDInt
11
PRIMARYYes
LineNumRow NumberInt
11
CanceledCanceledVarChar
Y) Yes
N) No
1
N
DocTypeDocument TypeVarChar
I) Invoice
P) Payment
J) Journal Entry
C) Correction Invoice
L) Landed Cost
1
I
RefEntry1Ref.1 Document KeyInt
11
RefEntry2Ref.1 Document KeyInt
11
ObjTypeObject TypeInt
6ADP1
Object Settings - History
LogInstancLog InstanceInt
11
0
RefTypeRef. Object TypeInt
-1)
13) A/R Invoice
18) A/P Invoice
30) Journal Entry
24) Incoming Payment
204) A/P Down Payment
165) A/R Correction Invoice
163) A/P Correction Invoice
69) Landed Cost
11
-1

SELECT statement

SELECT ATX1.BaseEntry AS 'Base Document Internal ID', ATX1.LineNum AS 'Row Number', ATX1.Canceled AS 'Canceled', ATX1.DocType AS 'Document Type', ATX1.RefEntry1 AS 'Ref.1 Document Key', ATX1.RefEntry2 AS 'Ref.1 Document Key', ATX1.ObjType AS 'Object Type', ATX1.LogInstanc AS 'Log Instance', ATX1.RefType AS 'Ref. Object Type' FROM ATX1 AS ATX1

Related information


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