| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | TOUR_ID | DSD Route Settlement: Tour ID | nvarchar | 32 | 0 | CHAR | (N' ') | No | /DSD/HH_RAHD | /DSD/HH_TOUR_ID | Allow NULL? |
| 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | NUMC | (N'000000') | No | /DSD/HH_RACVHD | /DSD/HH_VISIT_ID | Allow NULL? |
| 4 | HH_DELVRY | DSD Route Settlement: External Delivery/Order Number | nvarchar | 35 | 0 | CHAR | (N' ') | No | | /DSD/HH_HH_DELVRY | Allow NULL? |
| 5 | BE_DELVRY | Delivery | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | VBUK | VBELN_VL | Allow NULL? |
| 6 | OBJ_TYP | DSD - RA: Delivery Execution Document type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /DSD/HH_DEL_DOCTYP | Allow NULL? |
| 7 | PLANT | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | WERKS_D | Allow NULL? |
| 8 | CRE_TSTAMP | DSD - RA: Time Stamp of the Creation | decimal | 15 | 0 | DEC | ((0)) | Yes | | /DSD/HH_TIMESTAMP | |
| 9 | TZONE | DSD - RA: Time Zone | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | /DSD/HH_TZONE | Allow NULL? |
| 10 | TA_STATUS | DSD - RA: Status of the Customer Transaction | char | 1 | 0 | NUMC | (N'0') | Yes | | /DSD/HH_STATUS | Allow NULL? |
| 11 | REASON | DSD - RA: Reasons for Unscheduled Outbound Delivery | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | /DSD/HH_RAREASON | /DSD/HH_REASON | Allow NULL? |
| 12 | STATUS | DSD - RA: Processing Status of the Data Record | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /DSD/HH_RECSTAT | Allow NULL? |
| 13 | NOK | DSD - RA: Data Record is Incorrect | char | 1 | 0 | CHAR | (N' ') | Yes | | /DSD/HH_INVALID_DATA | Allow NULL? |
| 14 | BSTKD | Customer purchase order number | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | BSTKD | Allow NULL? |
| 15 | BSTDK | Customer purchase order date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BSTDK | Allow NULL? |