|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Tax Invoice Report Grid Info
Table Name: VRT2
Table Description: Tax Invoice Report Grid Info
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| TxInvRptNo | Tax Invoice Report No. | nVarChar | 10 | OVRT | Â | Â | Â |
| GridRow | Grid Row Number | Int | 11 | - | Â | Â | Â |
| BPLId | Business Place ID | Int | 11 | - | Â | Â | Â |
| BPCode | BP Code | nVarChar | 15 | - | Â | Â | Â |
| BPName | BP Name | nVarChar | 200 | - | Â | Â | Â |
| DocDate | Doc. Date | Date | 8 | - | Â | Â | Â |
| ItemNo | Item Number | nVarChar | 50 | - | Â | Â | Â |
| ItemDes | Item Description | nVarChar | 200 | - | Â | Â | Â |
| TaxCode | Tax Code | nVarChar | 8 | - | Â | Â | Â |
| ItemQty | Item Quantity | Num | 19.6 | - | Â | Â | Â |
| ItemPrice | Item Price | Num | 19.6 | - | Â | Â | Â |
| BaseAmt | Base Amount | Num | 19.6 | - | Â | Â | Â |
| TaxAmt | Tax Amount | Num | 19.6 | - | Â | Â | Â |
| LineType | Row Type | Int | 11 | - | Â | Â | Â |
| DocEntry | Unique Document ID | Int | 11 | - | Â | Â | Â |
| DocType | Document Type | Int | 11 | - | Â | 0 | Â |
| Â | Â | Â | Â | Â | Â | 13 | A/R Invoice |
| Â | Â | Â | Â | Â | Â | 14 | A/R Credit Memo |
| Â | Â | Â | Â | Â | Â | 203 | A/R Down Payment |
| LineNum | Item Row Number | Int | 11 | - | Â | Â | Â |
| Currency | Currency | nVarChar | 3 | - | Â | Â | Â |
| Remark | Remarks | nVarChar | 100 | - | Â | Â | Â |
| LegacyData | Legacy Data | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | TxInvRptNo |
| Â | Â | GridRow |