📚 SAP Business One SDK Help

Table Name: TRT1

Table Description: Posting Templates - Rows

Field Description Type Size Related Default Value Constraints
TrtCode Template Code nVarChar 8 OTRT      
Sequence Sequence Row No. Int 11 -      
AcctCode Account Code nVarChar 15 -      
Line_Descr Account Description nVarChar 200 -      
Debit Debit Num 19.6 -      
Credit Credit Num 19.6 -      
VatGroup Tax Group nVarChar 8 OVTG      
UserSign User Signature Int 6 OUSR      
VatLine Vat Line VarChar 1 - N Y Yes
            N No
CtrlAcct Control Account nVarChar 15 -      
OcrCode Distr. Rule nVarChar 8 OOCR      
TaxType Tax Type Int 6 - 0    
TaxPostAcc Tax Posting Account VarChar 1 - N N  
            R Sales Tax Account
            P Purchasing Tax Account
StaCode Authority Code nVarChar 8 OSTA      
StaType Authority Type Int 11 OSTT      
TaxCode Tax Code nVarChar 8 OSTC      
OcrCode1 Costing Code 1 nVarChar 8 OOCR      
OcrCode2 Costing Code 2 nVarChar 8 OOCR      
OcrCode3 Costing Code 3 nVarChar 8 OOCR      
OcrCode4 Costing Code 4 nVarChar 8 OOCR      
OcrCode5 Costing Code 5 nVarChar 8 OOCR      
WtLiable WTax-Liable VarChar 1 -   Y Yes
            N No
WTaxLine WTax Row VarChar 1 - N Y Yes
            N No
GrossValue Gross Value Num 19.6 -      
Project Project Code nVarChar 20 OPRJ      
CemCode Cost Element Code nVarChar 20 OCEM      
Key Unique Field
PRIMARY Yes TrtCode
    Sequence