biuan SAP® BUSINESS ONE SDK
DTW Sales Tax Invoice - Rows1
API Tax Invoices / Tax Invoice Lines
TPI1 - Purchase Tax Invoice - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BaseEntry KEY UNIQUEBase Document Internal IDInt
11OTPI
Purchase Tax Invoice
PRIMARYYes
LineNumRow NumberInt
11
CanceledCanceledVarChar
Y) Yes
N) No
1
N
DocTypeDocument TypeVarChar
I) Invoice
P) Payment
J) Journal Entry
C) Correction Invoice
D) Down Payment
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

Table relationship map

SELECT statement

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

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
Purchase Tax Invoice OTPI 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