biuan SAP® BUSINESS ONE SDK
API TRT1
TRT1 - Posting Templates - Rows Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
TrtCode KEY UNIQUETemplate CodenVarChar
8OTRT
Posting Templates
PRIMARYYes
SequenceSequence Row No.Int
11
AcctCodeAccount CodenVarChar
15
Line_DescrAccount DescriptionnVarChar
100
DebitDebitNum
20
CreditCreditNum
20
VatGroupTax GroupnVarChar
8OVTG
Tax Definition
UserSignUser SignatureInt
6OUSR
Users
VatLineVat LineVarChar
Y) Yes
N) No
1
N
CtrlAcctControl AccountnVarChar
15
OcrCodeDistr. RulenVarChar
8OOCR
Distribution Rule
TaxTypeTax TypeInt
6
0
TaxPostAccTax Posting AccountVarChar
N)
R) Sales Tax Account
P) Purchasing Tax Account
1
N
StaCodeAuthority CodenVarChar
8OSTA
Sales Tax Authorities
StaTypeAuthority TypeInt
11OSTT
Sales Tax Authorities Type
TaxCodeTax CodenVarChar
8OSTC
Sales Tax Codes
OcrCode1Costing Code 1nVarChar
8OOCR
Distribution Rule
OcrCode2Costing Code 2nVarChar
8OOCR
Distribution Rule
OcrCode3Costing Code 3nVarChar
8OOCR
Distribution Rule
OcrCode4Costing Code 4nVarChar
8OOCR
Distribution Rule
OcrCode5Costing Code 5nVarChar
8OOCR
Distribution Rule
WtLiableWTax-LiableVarChar
Y) Yes
N) No
1
WTaxLineWTax RowVarChar
Y) Yes
N) No
1
N
GrossValueGross ValueNum
20
ProjectProject CodenVarChar
20OPRJ
Project Codes

Table relationship map

SELECT statement

SELECT TRT1.TrtCode AS 'Template Code', TRT1.Sequence AS 'Sequence Row No.', TRT1.AcctCode AS 'Account Code', TRT1.Line_Descr AS 'Account Description', TRT1.Debit AS 'Debit', TRT1.Credit AS 'Credit', TRT1.VatGroup AS 'Tax Group', TRT1.UserSign AS 'User Signature', TRT1.VatLine AS 'Vat Line', TRT1.CtrlAcct AS 'Control Account', TRT1.OcrCode AS 'Distr. Rule', TRT1.TaxType AS 'Tax Type', TRT1.TaxPostAcc AS 'Tax Posting Account', TRT1.StaCode AS 'Authority Code', TRT1.StaType AS 'Authority Type', TRT1.TaxCode AS 'Tax Code', TRT1.OcrCode1 AS 'Costing Code 1', TRT1.OcrCode2 AS 'Costing Code 2', TRT1.OcrCode3 AS 'Costing Code 3', TRT1.OcrCode4 AS 'Costing Code 4', TRT1.OcrCode5 AS 'Costing Code 5', TRT1.WtLiable AS 'WTax-Liable', TRT1.WTaxLine AS 'WTax Row', TRT1.GrossValue AS 'Gross Value', TRT1.Project AS 'Project Code' FROM TRT1 AS TRT1

Related information


Distribution Rule OOCR SQL Table

Project Codes OPRJ SQL Table

Sales Tax Authorities OSTA SQL Table

Sales Tax Authorities Type OSTT SQL Table

Sales Tax Codes OSTC SQL Table

Posting Templates OTRT SQL Table

Users OUSR SQL Table

Tax Definition OVTG 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