|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Down Payment - E-Way Bill Information
Table Name: DPO26
Table Description: Down Payment - E-Way Bill Information
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| DocEntry | Document Internal ID | Int | 11 | ODPO | Â | Â | Â |
| SuplyType | EWB Transaction Type | nVarChar | 20 | - | Â | O | Outward |
| Â | Â | Â | Â | Â | Â | I | Inward |
| SubSplyTyp | EWB Sub-Type | Int | 11 | OEST | Â | Â | Â |
| DocType | EWB Doc. Type | nVarChar | 3 | OEDT | Â | Â | Â |
| TransMode | EWB Transportation Mode | Int | 11 | OETM | Â | Â | Â |
| Distance | EWB Transport Distance | Num | 19.6 | - | Â | Â | Â |
| TransDocNo | EWB Transporter Doc. No. | nVarChar | 16 | - | Â | Â | Â |
| TransDate | EWB Transportation Date | Date | 8 | - | Â | Â | Â |
| VehicleTyp | EWB Vehicle Type | nVarChar | 2 | OEVT | Â | Â | Â |
| VehicleNo | EWB Vehicle Number | nVarChar | 15 | - | Â | Â | Â |
| EWayBillNo | EWB No. | nVarChar | 20 | - | Â | Â | Â |
| EwbDate | E-Way Bill Date | Date | 8 | - | Â | Â | Â |
| FrmTraName | EWB Consignor Name | nVarChar | 200 | - | Â | Â | Â |
| FrmAddres1 | EWB Consignor Address 1 | nVarChar | 120 | - | Â | Â | Â |
| FrmAddres2 | EWB Consignor Address 2 | nVarChar | 120 | - | Â | Â | Â |
| FrmZipCode | EWB Consignor Zip Code | nVarChar | 20 | - | Â | Â | Â |
| ActFrmStat | Dispatch State of EWB Consignor | nVarChar | 2 | - | Â | Â | Â |
| ToTraName | EWB Consignee Name | nVarChar | 200 | - | Â | Â | Â |
| ToAddres1 | EWB Consignee Address 1 | nVarChar | 120 | - | Â | Â | Â |
| ToAddres2 | EWB Consignee Address 2 | nVarChar | 120 | - | Â | Â | Â |
| ToZipCode | EWB Consignee Zip Code | nVarChar | 20 | - | Â | Â | Â |
| ActToState | Ship-To State of EWB Consignee | nVarChar | 2 | - | Â | Â | Â |
| FrmGSTN | EWB Consignor GSTN | nVarChar | 15 | - | Â | Â | Â |
| FrmState | Bill-To State of EWB Consignor | nVarChar | 2 | - | Â | Â | Â |
| ToGSTN | EWB Consignee GSTN | nVarChar | 15 | - | Â | Â | Â |
| ToState | Bill-To State of EWB Consignee | nVarChar | 2 | - | Â | Â | Â |
| MainHsnEnt | EWB Main HSN Entry | Int | 11 | OCHP | Â | Â | Â |
| FrmPlace | EWB Consignor Place | nVarChar | 50 | - | Â | Â | Â |
| ToPlace | EWB Consignee Place | nVarChar | 50 | - | Â | Â | Â |
| TransID | EWB Transporter ID | nVarChar | 15 | - | Â | Â | Â |
| TransName | EWB Transporter Name | nVarChar | 25 | - | Â | Â | Â |
| ExpireDate | EWB Expiration Date | Date | 8 | - | Â | Â | Â |
| ObjectType | Object Type | nVarChar | 20 | ADP1 | 204 | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| TspEntry | Transporter Abs. Entry | Int | 11 | OTSP | Â | Â | Â |
| TspLine | Transportation Line | Int | 11 | - | Â | Â | Â |
| TransType | Transaction Type | Int | 11 | - | Â | 1 | Regular |
| Â | Â | Â | Â | Â | Â | 2 | Bill To-Ship To |
| Â | Â | Â | Â | Â | Â | 3 | Bill From-Dispatch From |
| Â | Â | Â | Â | Â | Â | 4 | Combination of 2 and 3 |
| Key | Unique | Field |
| PRIMARY | Yes | DocEntry |