|
|
SAP Business One SDK 10.0 - Database Tables Reference |
GTS Invoice Details
Table Name: GTI1
Table Description: GTS Invoice Details
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | OGTI | Â | Â | Â |
| LineNum | Line Number | Int | 11 | - | Â | Â | Â |
| DisctLine | Discount Flag | VarChar | 1 | - | 0 | 0 | Normal |
| Â | Â | Â | Â | Â | Â | 1 | Discount Line |
| ItemName | Item Name | nVarChar | 60 | - | Â | Â | Â |
| ItemSpec | Item Specification | nVarChar | 30 | - | Â | Â | Â |
| Uom | Unit of Measurement | nVarChar | 16 | - | Â | Â | Â |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| NetAmount | Net Amount | Num | 19.6 | - | Â | Â | Â |
| VatPercent | VAT Percent | Num | 19.6 | - | Â | Â | Â |
| VatAmount | VAT Amount | Num | 19.6 | - | Â | Â | Â |
| UnitPrice | Unit Price | Num | 19.6 | - | Â | Â | Â |
| UnitPricTp | Unit Price Type | VarChar | 1 | - | 0 | 0 | Net |
| Â | Â | Â | Â | Â | Â | 1 | Gross |
| ItemTaxCat | Item Tax Category | nVarChar | 30 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineNum |