|
|
SAP Business One SDK 10.0 - Database Tables Reference |
GTS Invoice
Table Name: OGTI
Table Description: GTS Invoice
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AbsEntry | Internal Number | Int | 11 | - | Â | Â | Â |
| CreateDate | Create Date | Date | 8 | - | Â | Â | Â |
| MappingNum | GTS Mapping No. | nVarChar | 20 | - | Â | Â | Â |
| Voiding | Voiding Flag | VarChar | 1 | - | 0 | 0 | Normal |
| Â | Â | Â | Â | Â | Â | 1 | Voided |
| ItemList | Item List | VarChar | 1 | - | Â | 0 | Without Item List |
| Â | Â | Â | Â | Â | Â | 1 | With Item List |
| CategNum | GTS Cat. No. | nVarChar | 20 | - | Â | Â | Â |
| GtsInvNum | GTS Invoice No. | nVarChar | 30 | - | Â | Â | Â |
| ItemRowNum | Item List Row Number | Int | 11 | - | Â | Â | Â |
| DocDate | Document Date | Date | 8 | - | Â | Â | Â |
| FiscaMonth | Fiscal Month | Int | 6 | - | Â | Â | Â |
| DocAmount | Document Amount | Num | 19.6 | - | Â | Â | Â |
| VatPercent | VAT Percent | Num | 19.6 | - | Â | Â | Â |
| VatAmount | VAT Amount | Num | 19.6 | - | Â | Â | Â |
| BpName | BP Name | nVarChar | 200 | - | Â | Â | Â |
| BpTaxRgNum | BP Tax Registration No. | nVarChar | 20 | - | Â | Â | Â |
| BpAddrTel | BP Address and Telephone | nVarChar | 80 | - | Â | Â | Â |
| BpBankNum | BP Bank Number | nVarChar | 60 | - | Â | Â | Â |
| SellerName | Seller Name | nVarChar | 80 | - | Â | Â | Â |
| SelTaxReg | Seller Tax Registration No. | nVarChar | 80 | - | Â | Â | Â |
| SelAddTel | Seller Address and Tel. | nVarChar | 80 | - | Â | Â | Â |
| SelBankAct | Seller Bank Account | nVarChar | 80 | - | Â | Â | Â |
| Remarks | Remarks | nVarChar | 160 | - | Â | Â | Â |
| Issuer | Issuer | nVarChar | 8 | - | Â | Â | Â |
| Checker | Checker | nVarChar | 8 | - | Â | Â | Â |
| Payee | Payee | nVarChar | 8 | - | Â | Â | Â |
| InBndFile | Inbound File: Full Name | nVarChar | 254 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AbsEntry |