| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | SCENARIO | DSD CN: DSD Tour Scenario | nvarchar | 2 | 0 | | | | Allow NULL? |
| 3 | SHTYP | DSD CN: Shipment / Visit Plan Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | INV_ES_CUST | Invoice signed by customer | char | 1 | 0 | | | | Allow NULL? |
| 5 | INV_ES_DRV | Invoice signed by driver | char | 1 | 0 | | | | Allow NULL? |
| 6 | ORD_ES_CUST | Order signed by customer | char | 1 | 0 | | | | Allow NULL? |
| 7 | ORD_ES_DRV | Order signed by driver | char | 1 | 0 | | | | Allow NULL? |
| 8 | DEL_ES_CUST | Delivery signed by customer | char | 1 | 0 | | | | Allow NULL? |
| 9 | DEL_ES_DRV | Delivery signed by driver | char | 1 | 0 | | | | Allow NULL? |
| 10 | CI_ES_DRV | Check-In signed by driver | char | 1 | 0 | | | | Allow NULL? |
| 11 | CO_ES_DRV | Check-Out signed by driver | char | 1 | 0 | | | | Allow NULL? |
| 12 | CI_ES_CHK | Check-In signed by checker | char | 1 | 0 | | | | Allow NULL? |
| 13 | CO_ES_CHK | Check-Out signed by checker | char | 1 | 0 | | | | Allow NULL? |
| 14 | CI_RL_ES_DRV | Reload Check-In signed by driver | char | 1 | 0 | | | | Allow NULL? |
| 15 | CO_RL_ES_DRV | Reload Check-Out signed by driver | char | 1 | 0 | | | | Allow NULL? |
| 16 | CI_RL_ES_CHK | Reload Check-In signed by checker | char | 1 | 0 | | | | Allow NULL? |
| 17 | CO_RL_ES_CHK | Reload Check-Out signed by checker | char | 1 | 0 | | | | Allow NULL? |
| 18 | COCI_PASSWORD | Flag for password support | char | 1 | 0 | | | | Allow NULL? |