|
|
API VRT2
VRT2 - Tax Invoice Report Grid Info Table
Tax Invoice Report OVRT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | TxInvRptNo KEY UNIQUE | Tax Invoice Report No. | nVarChar | 10 | OVRT Tax Invoice Report | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| GridRow | Grid Row Number | Int | 11 | |||||
| BPLId | Business Place ID | Int | 11 | |||||
| BPCode | BP Code | nVarChar | 15 | |||||
| BPName | BP Name | nVarChar | 100 | |||||
| DocDate | Doc. Date | Date | 8 | |||||
| ItemNo | Item Number | nVarChar | 20 | |||||
| ItemDes | Item Description | nVarChar | 100 | |||||
| TaxCode | Tax Code | nVarChar | 8 | |||||
| ItemQty | Item Quantity | Num | 20 | |||||
| ItemPrice | Item Price | Num | 20 | |||||
| BaseAmt | Base Amount | Num | 20 | |||||
| TaxAmt | Tax Amount | Num | 20 | |||||
| LineType | Row Type | Int | 11 | |||||
| DocEntry | Unique Document ID | Int | 11 | |||||
| DocType | Document Type | Int | 0 13) A/R Invoice 14) A/R Credit Memo 203) A/R Down Payment | 11 | ||||
| LineNum | Item Row Number | Int | 11 | |||||
| Currency | Currency | nVarChar | 3 | |||||
| Remark | Remarks | nVarChar | 100 | |||||
| LegacyData | Legacy Data | VarChar | Y) Yes N) No | 1 | N | |||
| Quantity | Quantity | Num | 20 |
SELECT statement
SELECT
VRT2.TxInvRptNo AS 'Tax Invoice Report No.',
VRT2.GridRow AS 'Grid Row Number',
VRT2.BPLId AS 'Business Place ID',
VRT2.BPCode AS 'BP Code',
VRT2.BPName AS 'BP Name',
VRT2.DocDate AS 'Doc. Date',
VRT2.ItemNo AS 'Item Number',
VRT2.ItemDes AS 'Item Description',
VRT2.TaxCode AS 'Tax Code',
VRT2.ItemQty AS 'Item Quantity',
VRT2.ItemPrice AS 'Item Price',
VRT2.BaseAmt AS 'Base Amount',
VRT2.TaxAmt AS 'Tax Amount',
VRT2.LineType AS 'Row Type',
VRT2.DocEntry AS 'Unique Document ID',
VRT2.DocType AS 'Document Type',
VRT2.LineNum AS 'Item Row Number',
VRT2.Currency AS 'Currency',
VRT2.Remark AS 'Remarks',
VRT2.LegacyData AS 'Legacy Data',
VRT2.Quantity AS 'Quantity'
FROM VRT2 AS VRT2
Related information
Tax Invoice Report OVRT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
