| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPContract Accounts Receivable and Payable |
1 | FKK_JLRPHD_SHORT | Item Data for IS-M/SD Home Delivery Settlement - Extracts | 15 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
TOPPeriodical Sales and Distribution |
2 | JITSTAT | IS-M/SD: Daily IVW Statistics | 3 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
3 | JKGIFT | Sales Order: Promotional Gifts for Introduction Record | 10 | VERSANDDAT | IS-M/SD: Gift Shipping Date | nvarchar | 8 | 0 | | |
4 | JLRP | IS-M/SD: Item Data for Settlement | 61 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
5 | JRENQABLG | IS | 6 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
6 | JRTABLG | IS-M: Drop-Off | 19 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
7 | JVTANNSTAT | IS-M/SD: Status Table for Order Finalization Deadline | 7 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
8 | JVTASTAT01 | IS-M/SD: Supplements to Shipping Status | 7 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
9 | JVTLFNG | IS-M/SD: Delivery/Home Delivery | 23 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
10 | JVTNOTICE | IS-M/SD: Carrier Change Notifications | 4 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
11 | JVTPROD | IS-M/SD: Production Units | 9 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
12 | JVTVGRPDAT | IS-M/SD: Shipping Date for a Shipping Group | 3 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
13 | JVTVSPDIR | IS-M/SD: Shipping Document Directory | 2 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
14 | JVTVSPTXT | Shipping Document Printing of User-Defined Texts | 2 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
15 | JVTZAEM1 | IS-M/SD: Carrier Change Notification - Order Change | 2 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
16 | JVTZAEM2 | Sales Order Header Data | 2 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
17 | JVTZAEM3 | IS-M/SD: Carrier Change Notification - Pre-Fetch Messages | 2 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
18 | JVTZAEM4 | IS-M/SD: Carrier Change Notification - Excl.Orders | 2 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
TOPSAP Media |
19 | J_1SFSPED | IS-M/SD CH/V: Addresses, Orders for Third-Party Shipping | 4 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |
20 | J_1SWEMF00 | IS-M/SD CH/W: Daily WEMF Statistics | 3 | VERSANDDAT | IS-M: Shipping Date | nvarchar | 8 | 0 | | |