|
|
API OVRT
OVRT - Tax Invoice Report Table
OVRT SQL Table
E-Tax Web Site OTWS SQL Table
Tax Report Type OKRT SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | TxInvRptNo KEY UNIQUE | Tax Invoice Rpt Number | nVarChar | 10 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| TxInvRptDt | Tax Invoice Rpt Create Date | Date | 8 | |||||
| SupBPLId | Supplier BPL ID | Int | 11 | |||||
| CardCode | Receipt BP Code | nVarChar | 15 | |||||
| BaseAmt | Total Base Amount(LC) | Num | 20 | |||||
| BlankNo | Blank Before Total Base Amount | Int | 11 | |||||
| TaxAmt | Total Tax Amount(LC) | Num | 20 | |||||
| Total | Total Base + Total Tax | Num | 20 | |||||
| BPAddress | Customer Pay to Address | nVarChar | 127 | |||||
| version | Report Generation Version | nVarChar | 50 | |||||
| ReportType | VAT: Tax Report Type ID | Int | 11 | OKRT Tax Report Type | ||||
| NTSApprov | NTS Approved | VarChar | N) No Y) Yes | 1 | N | |||
| NTSWebSite | E-Tax Web Site | Int | 6 | OTWS E-Tax Web Site | -1 | |||
| NTSeTaxNo | E-Tax Number | nVarChar | 50 | |||||
| NTSApprNo | NTS Approval Number | nVarChar | 50 | |||||
| Remarks | Remarks | nVarChar | 127 | |||||
| OriNTSAppr | Original NTS Approval Number | nVarChar | 50 | |||||
| CardName | Receipt BP Code | nVarChar | 100 | |||||
| RptStatus | Tax Invoice Report Status | VarChar | S) Saved C) Canceled R) Reversed | 1 | S | |||
| OriTaxInvN | Original Tax Invoice Number | nVarChar | 10 | |||||
| TxInvPrint | Tax Invoice Report Print Type | VarChar | A) Aggregated I) Individual | 1 | I | |||
| Canceled | Tax Invoice Report is Canceled or Not | VarChar | Y) Yes N) No | 1 | N |
Table relationship map
SELECT statement
SELECT
OVRT.TxInvRptNo AS 'Tax Invoice Rpt Number',
OVRT.TxInvRptDt AS 'Tax Invoice Rpt Create Date',
OVRT.SupBPLId AS 'Supplier BPL ID',
OVRT.CardCode AS 'Receipt BP Code',
OVRT.BaseAmt AS 'Total Base Amount(LC)',
OVRT.BlankNo AS 'Blank Before Total Base Amount',
OVRT.TaxAmt AS 'Total Tax Amount(LC)',
OVRT.Total AS 'Total Base + Total Tax',
OVRT.BPAddress AS 'Customer Pay to Address',
OVRT.version AS 'Report Generation Version',
OVRT.ReportType AS 'VAT: Tax Report Type ID',
OVRT.NTSApprov AS 'NTS Approved',
OVRT.NTSWebSite AS 'E-Tax Web Site',
OVRT.NTSeTaxNo AS 'E-Tax Number',
OVRT.NTSApprNo AS 'NTS Approval Number',
OVRT.Remarks AS 'Remarks',
OVRT.OriNTSAppr AS 'Original NTS Approval Number',
OVRT.CardName AS 'Receipt BP Code',
OVRT.RptStatus AS 'Tax Invoice Report Status',
OVRT.OriTaxInvN AS 'Original Tax Invoice Number',
OVRT.TxInvPrint AS 'Tax Invoice Report Print Type',
OVRT.Canceled AS 'Tax Invoice Report is Canceled or Not'
FROM OVRT AS OVRT
Related information
OVRT SQL Table
E-Tax Web Site OTWS SQL Table
Tax Report Type OKRT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
