| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | TxInvRptNo | Tax Invoice Rpt Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 2 | TxInvRptDt | Tax Invoice Rpt Create Date | date | 8 | 0 | | | | |
| 3 | SupBPLId | Supplier BPL ID | int | 11 | 0 | | | | Allow NULL? |
| 4 | CardCode | Receipt BP Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 5 | BaseAmt | Total Base Amount(LC) | num | 19 | 6 | | | | Allow NULL? |
| 6 | BlankNo | Blank Before Total Base Amount | int | 11 | 0 | | | | Allow NULL? |
| 7 | TaxAmt | Total Tax Amount(LC) | num | 19 | 6 | | | | Allow NULL? |
| 8 | Total | Total Base + Total Tax | num | 19 | 6 | | | | Allow NULL? |
| 9 | BPAddress | Customer Pay to Address | nvarchar | 254 | 0 | | | | Allow NULL? |
| 10 | version | Report Generation Version | nvarchar | 50 | 0 | | | | Allow NULL? |
| 11 | ReportType | VAT: Tax Report Type ID | int | 11 | 0 | OKRT | | | Allow NULL? |
| 12 | NTSApprov | NTS Approved | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 13 | NTSWebSite | E-Tax Web Site | int | 6 | 0 | OTWS | -1 | | Allow NULL? |
| 14 | NTSeTaxNo | E-Tax Number | nvarchar | 50 | 0 | | | | Allow NULL? |
| 15 | NTSApprNo | NTS Approval Number | nvarchar | 50 | 0 | | | | Allow NULL? |
| 16 | Remarks | Remarks | nvarchar | 254 | 0 | | | | Allow NULL? |
| 17 | OriNTSAppr | Original NTS Approval Number | nvarchar | 50 | 0 | | | | Allow NULL? |
| 18 | CardName | Receipt BP Code | nvarchar | 100 | 0 | | | | Allow NULL? |
| 19 | RptStatus | Tax Invoice Report Status | char | 1 | 0 | | S | C=Canceled, R=Reversed, S=Saved | Allow NULL? |
| 20 | OriTaxInvN | Original Tax Invoice Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 21 | TxInvPrint | Tax Invoice Report Print Type | char | 1 | 0 | | I | A=Aggregated, I=Individual | Allow NULL? |
| 22 | Canceled | Tax Invoice Report is Canceled or Not | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |