|
|
API VRT1
VRT1 - Tax Invoice Report - Rows 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 |
|---|---|---|---|---|---|---|---|---|
| SeqNo | Sequence No. | Int | 11 | |||||
| MD | Original Date of Line Item | Date | 8 | |||||
| ItemDesc | Description of Line Item | nVarChar | 100 | |||||
| Unit | Unit of Line Item | nVarChar | 100 | |||||
| Quantity | Quantity | Num | 20 | |||||
| UnitPrice | Unit Price | Num | 20 | |||||
| BaseAmt | Base Amount | Num | 20 | |||||
| TaxAmt | Tax Amount | Num | 20 | |||||
| Remark | Remarks | nVarChar | 100 |
SELECT statement
SELECT
VRT1.TxInvRptNo AS 'Tax Invoice Report No.',
VRT1.SeqNo AS 'Sequence No.',
VRT1.MD AS 'Original Date of Line Item',
VRT1.ItemDesc AS 'Description of Line Item',
VRT1.Unit AS 'Unit of Line Item',
VRT1.Quantity AS 'Quantity',
VRT1.UnitPrice AS 'Unit Price',
VRT1.BaseAmt AS 'Base Amount',
VRT1.TaxAmt AS 'Tax Amount',
VRT1.Remark AS 'Remarks'
FROM VRT1 AS VRT1
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
