| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TOUR_ID | DSD Route Settlement: Tour ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | | | Allow NULL? |
| 4 | HH_DELVRY | DSD Route Settlement: External Delivery/Order Number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 5 | BE_DELVRY | Delivery | nvarchar | 10 | 0 | | | | Allow NULL? |
| 6 | OBJ_TYP | DSD - RA: Delivery Execution Document type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 7 | PLANT | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | CRE_TSTAMP | DSD - RA: Time Stamp of the Creation | decimal | 15 | 0 | | | | |
| 9 | TZONE | DSD - RA: Time Zone | nvarchar | 6 | 0 | | | | Allow NULL? |
| 10 | TA_STATUS | DSD - RA: Status of the Customer Transaction | char | 1 | 0 | | | | Allow NULL? |
| 11 | REASON | DSD - RA: Reasons for Unscheduled Outbound Delivery | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | STATUS | DSD - RA: Processing Status of the Data Record | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | NOK | DSD - RA: Data Record is Incorrect | char | 1 | 0 | | | | Allow NULL? |
| 14 | BSTKD | Customer purchase order number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 15 | BSTDK | Customer purchase order date | nvarchar | 8 | 0 | | | | Allow NULL? |