biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Sales Tax Invoice / Sales Tax Invoice - Rows1
DTW Sales Tax Invoice - Rows1
API Tax Invoices / Tax Invoice Lines
TXD1 - Tax Invoice Drafts - 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
R) Payment Request
L) Landed Cost
1
I
RefEntry1Ref.1 Document KeyInt
11
RefEntry2Ref. 2 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 TXD1.BaseEntry AS 'Base Document Internal ID', TXD1.LineNum AS 'Row Number', TXD1.Canceled AS 'Canceled', TXD1.DocType AS 'Document Type', TXD1.RefEntry1 AS 'Ref.1 Document Key', TXD1.RefEntry2 AS 'Ref. 2 Document Key', TXD1.ObjType AS 'Object Type', TXD1.LogInstanc AS 'Log Instance', TXD1.RefType AS 'Ref. Object Type' FROM TXD1 AS TXD1

Related information


Tax Invoice Lines TaxInvoice_Lines Object· Table: TSI1
TaxInvoice_Lines is a child object of the TaxInvoices object that represents the line entries of each tax invoice document. Source table: TSI1 for sales invoices, TPI1 for purchase invoices, or TXD1 for journal entry.
   Parent: Tax Invoices TaxInvoices Object· Table: OTSI
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