📚 SAP Business One SDK Help

Table Name: TPI1

Table Description: Purchase Tax Invoice - Rows

Field Description Type Size Related Default Value Constraints
BaseEntry Base Document Internal ID Int 11 OTPI      
LineNum Row Number Int 11 -      
Canceled Canceled VarChar 1 - N Y Yes
            N No
DocType Document Type VarChar 1 - I I Invoice
            P Payment
            J Journal Entry
            C Correction Invoice
            D Down Payment
            L Landed Cost
RefEntry1 Ref.1 Document Key Int 11 -      
RefEntry2 Ref.1 Document Key Int 11 -      
ObjType Object Type Int 6 ADP1      
LogInstanc Log Instance Int 11 - 0    
RefType Ref. Object Type Int 11 - -1 -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
EncryptIV Encrypt IV nVarChar 100 -      
Key Unique Field
PRIMARY Yes BaseEntry
    LineNum