| 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) | 19 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
2 | /DSD/HH_RACL | DSD Route Settlement: Clearing | 16 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
3 | /DSD/HH_RACOCICI | DSD Route Settlement: Check-Out/Check-In - Money Item | 9 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
4 | /DSD/HH_RACOCIHD | DSD Route Settlement: Check-Out / Check-In - Header data | 10 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
5 | /DSD/HH_RACOCIMI | DSD Route Settlement: Check-Out Check-In - Items | 15 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
6 | /DSD/HH_RACTR | DSD Route Settlement: Transmission Control | 8 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
7 | /DSD/HH_RACVHD | DSD Route Settlement: Customer Visit - Header | 16 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
8 | /DSD/HH_RADELCD | DSD Route Settlement: Delivery Execution Conditions | 10 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
9 | /DSD/HH_RADELCND | DSD Route Settlement: Delivery Execution Conditions | 11 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
10 | /DSD/HH_RADELHD | DSD Route Settlement: Delivery Execution - Header | 13 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
11 | /DSD/HH_RADELIT | DSD Route Settlement: Delivery Execution Items | 17 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
12 | /DSD/HH_RADS | DSD Route Settlement: Tour Distance Sheet | 10 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
13 | /DSD/HH_RAEC | DSD Route Settlement: Receipts/Expenditures | 20 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
14 | /DSD/HH_RAECA | DS Route Settlement: Collection Settlement | 7 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
15 | /DSD/HH_RAHD | DSD Route Settlement: Tour Header Data | 25 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
16 | /DSD/HH_RAIVCD | DSD Route Settlement: HH Invoice Header Conditions | 9 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
17 | /DSD/HH_RAIVCND | DSD Route Settlement: HH Invoice Header Conditions | 10 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
18 | /DSD/HH_RAIVHD | DSD Route Settlement: HH Billing Document Header | 11 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
19 | /DSD/HH_RAIVIT | DSD Route Settlement: HH Billing Document Items | 8 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
20 | /DSD/HH_RAIVPRT | DSD Route Settlement: HH Billing Document Print | 11 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
21 | /DSD/HH_RATS | DSD Route Settlement: Tour Time Sheet | 12 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
TOPStock Visibility |
22 | /DSD/SV_RACOCICI | DSD SV: Check-Out / Check-In - Money Item | 9 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
23 | /DSD/SV_RACOCIHD | DSD SV: Check-Out/Check-In - Header Data | 10 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
24 | /DSD/SV_RACOCIMI | DSD SV: Check-Out / Check-In - Items | 15 | NOK | DSD - RA: Data Record is Incorrect | nvarchar | 1 | 0 | | |
TOPStructure |
25 | DPR_CHECKLIST_I | Checklist Items | 14 | NOK | Not OK | nvarchar | 1 | 0 | | |