|
|
SAP Business One SDK 10.0 - Database Tables Reference |
GTS Mapping Object Details
Table Name: GTM1
Table Description: GTS Mapping Object Details
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | OGTM | Â | Â | Â |
| LineNum | Line Number | Int | 11 | - | Â | Â | Â |
| ItemCode | Item Code | nVarChar | 50 | OITM | Â | Â | Â |
| ItemName | Item Name | nVarChar | 200 | - | Â | Â | Â |
| ItemUoM | Item UoM | nVarChar | 100 | - | Â | Â | Â |
| ItemSpec | Item Spec. | nVarChar | 30 | - | Â | Â | Â |
| ItemTaxCat | Item Tax Category | nVarChar | 4 | - | Â | Â | Â |
| Quantity | Quantity | Num | 19.6 | - | Â | Â | Â |
| Amount | Amount | Num | 19.6 | - | Â | Â | Â |
| VatPercent | VAT Percent | Num | 19.6 | - | Â | Â | Â |
| DiscRate | Discount Rate | Num | 19.6 | - | Â | Â | Â |
| DiscAmount | Discount Amount | Num | 19.6 | - | Â | Â | Â |
| VatAmount | VAT Amount | Num | 19.6 | - | Â | Â | Â |
| DiscVatAmt | Discount VAT Amount | Num | 19.6 | - | Â | Â | Â |
| UnitPrice | Unit Price | Num | 19.6 | - | Â | Â | Â |
| UPirceType | Unit Price Type | VarChar | 1 | - | 0 | 0 | Net |
| Â | Â | Â | Â | Â | Â | 1 | Gross |
| TaxCatCode | Item Tax Category Code | nVarChar | 50 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |
| Â | Â | LineNum |