|
|
SAP Business One SDK 10.0 - Database Tables Reference |
A/R Down Payment - Import Process
Table Name: DPI17
Table Description: A/R Down Payment - Import Process
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | ODPI | Â | Â | Â |
| LineNum | Row Number | Int | 11 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| ObjectType | Object Type | nVarChar | 20 | ADP1 | 203 | Â | Â |
| ImpDocType | Type of Importation Document | VarChar | 1 | OBSI | Â | Â | Â |
| ImpDocNum | Importation Document Number | nVarChar | 10 | - | Â | Â | Â |
| DateOfReg | Date of Registry DI/DSI/DA | Date | 8 | - | Â | Â | Â |
| CustClrDat | Date of Customs Clearance | Date | 8 | - | Â | Â | Â |
| ConcActNum | Drawback Concession Acct No. | nVarChar | 30 | - | Â | Â | Â |
| AdditNum | Additional Number | nVarChar | 30 | - | Â | Â | Â |
| AddItmDV | Additional Item Discount Value | Num | 19.6 | - | Â | Â | Â |
| tpVTransp | Overland Transport Route | Int | 6 | - | Â | 1 | Maritime |
| Â | Â | Â | Â | Â | Â | 2 | Waterway |
| Â | Â | Â | Â | Â | Â | 3 | Lakeside |
| Â | Â | Â | Â | Â | Â | 4 | Air |
| Â | Â | Â | Â | Â | Â | 5 | Post |
| Â | Â | Â | Â | Â | Â | 6 | Train |
| Â | Â | Â | Â | Â | Â | 7 | Road |
| Â | Â | Â | Â | Â | Â | 8 | Network Transmission |
| Â | Â | Â | Â | Â | Â | 9 | Own Means |
| Â | Â | Â | Â | Â | Â | 10 | Input/Output Fictitious |
| Â | Â | Â | Â | Â | Â | 11 | Courier |
| Â | Â | Â | Â | Â | Â | 12 | Hand Carry |
| DrawSReg | Drawback - Suspension Regime | nVarChar | 11 | - | Â | Â | Â |
| AddFrNavyA | Additional Freight to Navy Authority | Num | 19.6 | - | Â | Â | Â |
| TypeOfImp | Type of Import | VarChar | 1 | - | Â | Â | Â |
| nSeqAdic | Additional Item Sequential Number | Int | 6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |
| Â | Â | LineNum |