|
|
API TRT1
TRT1 - Posting Templates - Rows Table
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | TrtCode KEY UNIQUE | Template Code | nVarChar | 8 | OTRT Posting Templates | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Sequence | Sequence Row No. | Int | 11 | |||||
| AcctCode | Account Code | nVarChar | 15 | |||||
| Line_Descr | Account Description | nVarChar | 100 | |||||
| Debit | Debit | Num | 20 | |||||
| Credit | Credit | Num | 20 | |||||
| VatGroup | Tax Group | nVarChar | 8 | OVTG Tax Definition | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| VatLine | Vat Line | VarChar | Y) Yes N) No | 1 | N | |||
| CtrlAcct | Control Account | nVarChar | 15 | |||||
| OcrCode | Distr. Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| TaxType | Tax Type | Int | 6 | 0 | ||||
| TaxPostAcc | Tax Posting Account | VarChar | N) R) Sales Tax Account P) Purchasing Tax Account | 1 | N | |||
| StaCode | Authority Code | nVarChar | 8 | OSTA Sales Tax Authorities | ||||
| StaType | Authority Type | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| TaxCode | Tax Code | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| OcrCode1 | Costing Code 1 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode2 | Costing Code 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Costing Code 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Costing Code 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Costing Code 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| WtLiable | WTax-Liable | VarChar | Y) Yes N) No | 1 | ||||
| WTaxLine | WTax Row | VarChar | Y) Yes N) No | 1 | N | |||
| GrossValue | Gross Value | Num | 20 | |||||
| Project | Project Code | nVarChar | 20 | OPRJ 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
