| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ORD_NO | DSD Connector: Order Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | TOUR_ID | DSD Connecter: Tour ID | nvarchar | 11 | 0 | | | | Allow NULL? |
| 4 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | | | Allow NULL? |
| 5 | ACT_ID | DSD connector : Activity ID | nvarchar | 6 | 0 | | | | Allow NULL? |
| 6 | HH_CREATE | DSD Connector: HH Create flag | char | 1 | 0 | | | | Allow NULL? |
| 7 | DOCTYP | DSD Connector: Shipment Type (Doc Type) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | CUST_NO | DSD Connector: Customer Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 9 | DELV_DATE | DSD Connector: date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | PO_NO | DSD Connector: Customer Purchase Order Number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 11 | DAT | DSD Connector: date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | TIME | DSD Connector: Time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 13 | STATUS | DSD Connector: Status of Download or Upload Procedure | char | 1 | 0 | | | | Allow NULL? |
| 14 | CANCEL | DSD Connector: Cancel flag | char | 1 | 0 | | | | Allow NULL? |
| 15 | CAN_REAS | DSD Connector: Cancel Reason Indicator | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | MOD | DSD Connector: Modification Flag | char | 1 | 0 | | | | Allow NULL? |
| 17 | PRICED | DSD Connector: Document Priced Flag | char | 1 | 0 | | | | Allow NULL? |
| 18 | TOT_AMT | DSD Connector: Total Amount | decimal | 23 | 4 | | | | |
| 19 | OFFICIAL_ORD_NO | DSD Connector: Official Document Number | nvarchar | 35 | 0 | | | | Allow NULL? |
| 20 | CURRCY | DSD Connector: Currency | nvarchar | 3 | 0 | | | | Allow NULL? |
| 21 | EXTFLD1 | DSD Connector: Extension field(30Char) | nvarchar | 30 | 0 | | | | Allow NULL? |
| 22 | EXTFLD2 | DSD Connector: Extension field(60Char) | nvarchar | 60 | 0 | | | | Allow NULL? |
| 23 | EXTFLD3 | DSD Connector: Extension field(60Char) | nvarchar | 60 | 0 | | | | Allow NULL? |
| 24 | EXTFLD4 | DSD Connector: Extension field(60Char) | nvarchar | 60 | 0 | | | | Allow NULL? |
| 25 | EXTFLD5 | DSD Connector: Extension field(60Char) | nvarchar | 60 | 0 | | | | Allow NULL? |
| 26 | EXTFLD6 | DSD Connector: Extension field(60Char) | nvarchar | 60 | 0 | | | | Allow NULL? |
| 27 | ME_ACTION | DSD Connector: ME Action | char | 1 | 0 | | | | Allow NULL? |
| 28 | BSTDK | Customer purchase order date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | DOC_ID | DSD Connector: Document Number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 30 | SPEC_RETURN | Control Parameters | char | 1 | 0 | | | | Allow NULL? |
