|
|
SAP Business One SDK 10.0 - Database Tables Reference |
GTS Mapping Object
Table Name: OGTM
Table Description: GTS Mapping Object
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| CreateDate | Create Date | Date | 8 | - | Â | Â | Â |
| GtsMapNum | GTS Mapping No. | nVarChar | 20 | - | Â | Â | Â |
| InvMapEnty | Link to Invoice Mapping ID | Int | 11 | OIVM | Â | Â | Â |
| GtsInvNum | Link to GTS Invoice Object | Int | 11 | OGTI | Â | Â | Â |
| BpCode | BP Code | nVarChar | 15 | OCRD | Â | Â | Â |
| BpName | BP Name | nVarChar | 200 | - | Â | Â | Â |
| BpTaxRegNo | BP Tax Registration No. | nVarChar | 20 | - | Â | Â | Â |
| BpAddrTel | BP Address and Telephone | nVarChar | 80 | - | Â | Â | Â |
| BpBankNum | BP Bank Number | nVarChar | 80 | - | Â | Â | Â |
| Remark | Remarks | nVarChar | 254 | - | Â | Â | Â |
| Checker | Checker | nVarChar | 80 | - | Â | Â | Â |
| Payee | Payee | nVarChar | 80 | - | Â | Â | Â |
| DocAmount | Document Net Amount | Num | 19.6 | - | Â | Â | Â |
| AmtAftDsct | Amount After Discount | Num | 19.6 | - | Â | Â | Â |
| TaxAmount | Tax Amount | Num | 19.6 | - | Â | Â | Â |
| GtsStatus | GTS Status | VarChar | 1 | - | 1 | 1 | Exported |
| Â | Â | Â | Â | Â | Â | 2 | Voided |
| Â | Â | Â | Â | Â | Â | 3 | Imported |
| ExportDate | Export Date | Date | 8 | - | Â | Â | Â |
| VoidDate | Void Date | Date | 8 | - | Â | Â | Â |
| ImportDate | Import Date | Date | 8 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |