| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP40: Inventory/OP Base |
1 | F4001Z | Batch Receiver File - Order Headings | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
2 | F4011Z | Batch Receiver File - Order Details | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
TOP40R: Demand Scheduling |
3 | F47171 | EDI Demand Header | 7 | EH | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
4 | F47172 | EDI Demand Detail | 7 | ED | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
5 | F471721 | EDI Demand Supplemental Data | 7 | EU | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
6 | F471722 | EDI Demand Addresses | 7 | EA | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
7 | F471723 | EDI Demand Contact Names | 7 | EC | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
8 | F471724 | EDI Demand Contact Numbers | 7 | EN | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
9 | F47173 | EDI Demand Scheduling Detail | 7 | ES | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
10 | F471731 | EDI Demand Packaging | 7 | EP | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
11 | F47800 | EDI Transmission Values | 5 | FF | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
TOP42: Sales Management |
12 | F47027T | Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound | 17 | UZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
13 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 28 | UZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
14 | F47047T | Tag for F47047- EDI Invoice Detail (Sales) - Outbound | 17 | UZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
15 | F47107T | Tag for F47107- EDI Response to RFQ Detail - Outbound | 17 | UZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
16 | F47147T | Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound | 17 | UZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
TOP42B: Sales Order Entry |
17 | F4011ZT | Batch Receiver File - Order Details Tag | 7 | UZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
18 | F47012T | EDI Purchase Order Detail Tag - Inbound | 7 | UZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
19 | F47092T | EDI Request for Quote Detail Tag - Inbound | 7 | UZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
20 | F47132T | EDI Purchase Order Change Detail Tag - Inbound | 7 | UZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
TOP45: Advanced Pricing |
21 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 105 | Z1 | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
TOP47: Electronic Commerce |
22 | F47003 | EDI Discrepancy Report Work File | 9 | SX | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
23 | F47006 | EDI Order Header - Outbound Tax Table | 7 | ST | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
24 | F47007 | EDI Order Detail - Outbound Tax Table | 7 | DT | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
25 | F47011 | EDI Purchase Order Header - Inbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
26 | F47011TX | EDI Purchase Order Header Tax - Inbound | 7 | ST | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
27 | F47012 | EDI Purchase Order Detail - Inbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
28 | F47012TX | EDI Purchase Order Detail Tax - Inbound | 7 | DT | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
29 | F47016 | EDI Purchase Order Header - Outbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
30 | F470161 | EDI Purchase Order Additional Header - Outbound | 72 | S3 | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
31 | F47017 | EDI Purchase Order Detail - Outbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
32 | F470171 | EDI Purchase Order Additional Detail - Outbound | 53 | S4 | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
33 | F47021 | EDI P.O. Acknowledgment Header - Inbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
34 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
35 | F47026 | EDI P.O. Acknowledgment Header - Outbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
36 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
37 | F47031 | EDI Shipping Notice Header - Inbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
38 | F47032 | EDI Shipping Notice Detail - Inbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
39 | F47036 | EDI Shipping Notice Header - Outbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
40 | F47036X | EDI Shipping Notice Header Tax - Outbound | 7 | ST | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
41 | F47037 | EDI Shipping Notice Detail - Outbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
42 | F470371 | EDI Shipping Notice Detail - Outbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
43 | F470371X | EDI Shipping Notice Detail Tax - Outbound | 10 | DT | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
44 | F470372 | EDI ASN Demand Scheduling Detail | 7 | AI | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
45 | F470373 | EDI ASN Shipping | 6 | AG | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
46 | F470374 | EDI ASN Demand Addresses | 8 | AM | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
47 | F470375 | EDI ASN Packaging Detail | 7 | AK | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
48 | F47041 | EDI Invoice Header - Inbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
49 | F47042 | EDI Invoice Detail - Inbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
50 | F47044 | EDI Invoice Summary - Inbound | 7 | SW | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
51 | F47046 | EDI Invoice Header (Sales) - Outbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
52 | F47047 | EDI Invoice Detail (Sales) - Outbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
53 | F47056 | EDI Payment Order Header - Outbound | 7 | D1 | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
54 | F47056W | EDI Payment Order Header - Work | 7 | D1 | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
55 | F47057 | EDI Payment Order Remittance Advice - Outbound | 7 | D3 | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
56 | F47057W | EDI Payment Order Remittance Advice - Work | 7 | D3 | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
57 | F47061 | EDI Planning Schedule Header - Inbound | 7 | MJ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
58 | F47062 | EDI Planning Schedule Detail - Inbound | 7 | MY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
59 | F47066 | EDI Planning Schedule Header - Outbound | 7 | MJ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
60 | F47067 | EDI Planning Schedule Detail - Outbound | 7 | MY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
61 | F47071 | EDI Receiving Advice Header - Inbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
62 | F47072 | EDI Receiving Advice Detail - Inbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
63 | F47076 | EDI Receiving Advice Header - Outbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
64 | F47077 | EDI Receiving Advice Detail - Outbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
65 | F47081 | EDI Price Sales Catalog Header - Inbound | 7 | FV | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
66 | F47082 | EDI Price Sales Catalog Detail - Inbound | 7 | FY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
67 | F47091 | EDI Request for Quote Header - Inbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
68 | F47091TX | EDI Request for Quote Header Tax - Inbound | 7 | ST | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
69 | F47092 | EDI Request for Quote Detail - Inbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
70 | F47096 | EDI Request for Quote Header - Outbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
71 | F47097 | EDI Request for Quote Detail - Outbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
72 | F47101 | EDI Response to RFQ Header - Inbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
73 | F47102 | EDI Response to RFQ Detail - Inbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
74 | F47106 | EDI Response to RFQ Header - Outbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
75 | F47107 | EDI Response to RFQ Detail - Outbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
76 | F47111 | EDI Lockbox/Payment Header - Transaction | 7 | Z1 | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
77 | F47112 | EDI Lockbox Header - Transaction | 7 | Z2 | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
78 | F47121 | EDI Product Activity Data Header - Inbound | 7 | M1 | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
79 | F47122 | EDI Product Activity Data Detail - Inbound | 7 | MJ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
80 | F47126 | EDI Product Activity Data Header - Outbound | 7 | M1 | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
81 | F47127 | EDI Product Activity Data Detail - Outbound | 7 | MJ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
82 | F47131 | EDI Purchase Order Change Header - Inbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
83 | F47131TX | EDI Purchase Order Change Header Tax - Inbound | 7 | ST | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
84 | F47132 | EDI Purchase Order Change Detail - Inbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
85 | F47132TX | EDI Purchase Order Change Detail Tax - Inbound | 7 | DT | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
86 | F47136 | EDI Purchase Order Change Header - Outbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
87 | F47137 | EDI Purchase Order Change Detail - Outbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
88 | F47141 | EDI P.O. Change Acknowledgment Header - Inbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
89 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
90 | F47146 | EDI P.O. Change Acknowledgment Header - Outbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
91 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
92 | F47156 | EDI Shipping Schedule Header - Outbound | 7 | SY | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
93 | F47157 | EDI Shipping Schedule Detail - Outbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
94 | F4716 | EDI Item Text - Inbound/Outbound | 7 | SZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
95 | F47181 | EDI Consumption Header (FUTURE) | 13 | EH | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
96 | F47182 | EDI Consumption Detail (FUTURE) | 22 | ED | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
97 | F47191 | EDI Acknowledgement Header | 7 | AH | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
98 | F47192 | EDI Acknowledgement Error Detail | 7 | AE | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
99 | F47194 | EDI Acknowledgement References | 7 | AR | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
100 | F47196 | EDI Acknowledgement Name And Address | 7 | AA | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
101 | F47198 | EDI Acknowledgement Notes | 7 | AN | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
102 | F4722 | EDI Tolerance Rules | 1 | PZ | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
103 | F47CTL | EDI Lockbox/Payment Work File | 11 | Z5 | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
104 | F47HL | Hierarchical Configuration | 1 | HL | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |
TOP49: Transportation Management |
105 | F47092TX | EDI Request for Quote Detail Tax - Inbound | 7 | DT | EDST | EDI - Transaction Set Number | String | UDC | 6 | 0 |