| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPDownloadUpload |
1 | /DSD/HH_RACAD | DSD Route Settlement: Customer Address Data (One-Time Only) | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
2 | /DSD/HH_RACL | DSD Route Settlement: Clearing | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
3 | /DSD/HH_RACVHD | DSD Route Settlement: Customer Visit - Header | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
4 | /DSD/HH_RADELCD | DSD Route Settlement: Delivery Execution Conditions | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
5 | /DSD/HH_RADELCND | DSD Route Settlement: Delivery Execution Conditions | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
6 | /DSD/HH_RADELES | DSD RA: Delivery/Order Signatures | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
7 | /DSD/HH_RADELHD | DSD Route Settlement: Delivery Execution - Header | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
8 | /DSD/HH_RADELIT | DSD Route Settlement: Delivery Execution Items | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
9 | /DSD/HH_RADS | DSD Route Settlement: Tour Distance Sheet | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
10 | /DSD/HH_RADXHD | DSD Route Accounting: DEX Header Data | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
11 | /DSD/HH_RAEC | DSD Route Settlement: Receipts/Expenditures | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
12 | /DSD/HH_RAECA | DS Route Settlement: Collection Settlement | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
13 | /DSD/HH_RAERRIDX | DSD - RA: Error Index Table | 4 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
14 | /DSD/HH_RAIVCD | DSD Route Settlement: HH Invoice Header Conditions | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
15 | /DSD/HH_RAIVCND | DSD Route Settlement: HH Invoice Header Conditions | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
16 | /DSD/HH_RAIVES | DSD RA: Invoice Signatures | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
17 | /DSD/HH_RAIVHD | DSD Route Settlement: HH Billing Document Header | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
18 | /DSD/HH_RAIVIT | DSD Route Settlement: HH Billing Document Items | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
19 | /DSD/HH_RAIVPRT | DSD Route Settlement: HH Billing Document Print | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
20 | /DSD/HH_RATS | DSD Route Settlement: Tour Time Sheet | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
TOPDSD Connector |
21 | /DSD/ME_CLR_HD | DSD CN: Clearing header data | 3 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
22 | /DSD/ME_CUST_CPD | DSD CN: One-time Customer | 3 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
23 | /DSD/ME_DEL_CND | Pricing: Manual discount condition for deliveries | 3 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
24 | /DSD/ME_DEL_HD | DSD CN: Delivery Header Data | 4 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
25 | /DSD/ME_DX_HD | DSD CN: DEX Header Interface structure | 3 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
26 | /DSD/ME_ES_HD | DSD CN: Signatures Header Data | 3 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
27 | /DSD/ME_INV_HD | DSD CN: Billing Doc. Header Data | 3 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
28 | /DSD/ME_MSG_HD | DSD CN: Message header data | 10 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
29 | /DSD/ME_ORD_CND | Pricing: Manual discount condition for orders | 3 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
30 | /DSD/ME_ORD_HD | DSD CN: Order Header Data | 4 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
31 | /DSD/ME_PAYM_HD | DSD CN: Payments or Cash Collection received from Customer | 3 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
32 | /DSD/ME_REVN_HD | DSD CN: Payments or Cash Collection received from Customer | 3 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
33 | /DSD/ME_VIST_ACT | DSD CN: Activities during the Customer Visit | 3 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
34 | /DSD/ME_VIST_HD | DSD CN: Customer Visit Header | 3 | VISIT_ID | DSD connecter : Visit ID | nvarchar | 6 | 0 | | |
TOPRoute Settlement |
35 | /DSD/SL_SLD_DOCS | Settlement: Merging of Back-End Documents | 3 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |
36 | /DSD/SL_SLD_FLOW | Settlement: Document Flow | 9 | VISIT_ID | DSD - RA: Visit ID | nvarchar | 6 | 0 | | |