| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0006Z1 | Cost Center Unedited Transaction Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
2 | F0401Z1 | Supplier Master - Batch File | 12 | VO | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP01: Address Book |
3 | F0101Z2 | Address Book - Interoperability | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
4 | F01111Z1 | Batch - Contact Information | 12 | CB | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
5 | F01112Z1 | Batch - Related Person | 12 | PB | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
6 | F0111Z1 | Batch Who's Who Information | 12 | BW | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
7 | F01151Z1 | Batch - Electronic Address | 12 | EB | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
8 | F0115Z1 | Phones - Interoperability | 13 | PI | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
9 | F01161Z1 | Batch - Alternative Address | 12 | LB | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP03: Accounts Receivable |
10 | F03012Z1 | Customer Master LOB-Batch File | 12 | VO | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP03B: Enhanced Accounts Receivable |
11 | F03B11Z2 | F03B11 Interoperability Table | 12 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
12 | F03B13Z2 | F03B13 Interoperability Table | 12 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
13 | F03B14Z2 | F03B14 Interoperability Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
14 | F03B41Z1 | Inteoperability - Deductions Management | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP04: Accounts Payable |
15 | F0411Z3 | F0411 Interoperability Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
16 | F0413Z1 | F0413 Interoperability Table | 12 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
17 | F0414Z1 | F0414 Interoperability Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP05A: OW HR & PR Foundation |
18 | F060116Z | Unedited Quick Hire Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP09: General Accounting |
19 | F0911Z4 | F0911 Interoperability Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP10: Financial Reporting |
20 | F1001Z1 | Unedited MSC Interoperability Header Table | 12 | IA | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
21 | F1002Z1 | Unedited MSC Interoperability Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP11: Multi Currency |
22 | F0015Z1 | External Currency Exchange Rates | 12 | ZE | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP12: Fixed Assets |
23 | F1201Z1 | Unedited Asset Master Transactions | 12 | FA | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
24 | F1217Z1 | Unedited Equipment Tag Transactions | 12 | WR | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
25 | F1217Z2 | Unedited Equipment Tag Transactions | 12 | WR | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP13: Plant/Equipment Management |
26 | F12120Z1 | Unedited Meter Reading Transactions | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP13C: Condition-Base Maintenance |
27 | F1310Z1 | Unedited Condition-Based Alerts | 12 | CB | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP16: Profit Management (EPS) |
28 | F1602Z1 | External Cost Analyzer Balances - Interoperability Table | 12 | CZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
29 | F1632Z1 | External Driver Balances-Interoperability Table | 12 | CY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP17: Customer Service Management |
30 | F3111Z2 | Warranty Claim/Supplier Recovery processing | 12 | WP | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
31 | F3112Z2 | Warranty Claim/Supplier Recovery processing | 12 | WL | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
32 | F4801TZ2 | Warranty Claim/Supplier Recovery processing | 12 | WQ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
33 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 12 | WS | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP30: Product Data Management |
34 | F0007Z1 | Work Day Calendar Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
35 | F30006Z1 | Work Center Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
36 | F3002Z1 | Bill of Material Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
37 | F3003Z1 | Routing Transactions File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP31: Shop Floor Control |
38 | F30161Z1 | Inbound Kanban Card Detail | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
39 | F3111Z1 | Outbound Work Order Parts List | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
40 | F31122Z1 | Work Order Time Transactions Unedited Transaction Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
41 | F3112Z1 | Outbound Work Order Routings | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
42 | F4801Z1 | Outbound Work Order Header | 12 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP31B: Blend Management |
43 | F31B17Z1 | Operation EUR Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
44 | F31B18Z1 | VBT Barrel Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
45 | F31B19Z1 | Instructed Attributes Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
46 | F31B31Z1 | Operations Composition Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
47 | F31B34Z1 | Operations Style Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
48 | F31B3CZ1 | Operations Cost Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
49 | F31B52Z1 | Operations Equipment Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
50 | F31B53Z1 | Operations Consumables Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
51 | F31B65Z1 | Operations Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
52 | F31B93Z1 | WIM Work Order Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
53 | F31B97Z1 | Operations Resource Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
54 | F31BQAZ1 | Operations Quality Test Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP36: Forecasting |
55 | F3460Z1 | Forecast Unedited Transactions | 12 | FT | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP37: Quality Management |
56 | F3711Z1 | Test Results Unedited Transaction Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP40: Inventory/OP Base |
57 | F4001Z | Batch Receiver File - Order Headings | 13 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
58 | F4011Z | Batch Receiver File - Order Details | 13 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
59 | F4106NC | Base Price Extraction | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
60 | F4201Z1 | Sales Order Header Unedited Transaction File | 12 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
61 | F4211Z1 | Sales Order Detail Unedited Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
62 | F4215 | Shipment Header | 3 | XH | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
63 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 12 | S1 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP41: Inventory Management |
64 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
65 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
66 | F41021Z1 | Item Location Unedited Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
67 | F4105Z1 | Unedited Transaction Table - Item Cost | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
68 | F4141Z1 | F4141 Cycle Count Unedited Transaction Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP42: Sales Management |
69 | F47027T | Tag for F47027 - EDI P.O. Acknowledgment Detail - Outbound | 29 | UZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
70 | F47047T | Tag for F47047- EDI Invoice Detail (Sales) - Outbound | 29 | UZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
71 | F47107T | Tag for F47107- EDI Response to RFQ Detail - Outbound | 29 | UZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
72 | F47147T | Tag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound | 29 | UZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP42B: Sales Order Entry |
73 | F4011ZT | Batch Receiver File - Order Details Tag | 14 | UZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
74 | F47012T | EDI Purchase Order Detail Tag - Inbound | 14 | UZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
75 | F47092T | EDI Request for Quote Detail Tag - Inbound | 14 | UZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
76 | F47132T | EDI Purchase Order Change Detail Tag - Inbound | 14 | UZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP43: Procurement |
77 | F4301Z1 | Purchase Order Header Unedited Transaction Table | 12 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
78 | F43092Z1 | Receipt Routing Unedited Transaction Table | 13 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
79 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
80 | F43121Z1 | Receipts Unedited Transaction Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP44H: Homebuilder Management |
81 | F44H101Z | HB Community Master Unedited Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
82 | F44H201Z | HB Lot Master Unedited Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
83 | F44H501Z | HB Sales Master Unedited Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
84 | F44H604Z | HB Vendor Assignment Unedited Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
85 | F44H711Z | HB Lot Start Unedited Transaction File | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP45: Advanced Pricing |
86 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 12 | Z1 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP46: Warehouse Management |
87 | F4611Z1 | Unedited Suggestion Table | 12 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
88 | F4942Z1 | Work File for F4942 | 12 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
TOP47: Electronic Commerce |
89 | F47011 | EDI Purchase Order Header - Inbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
90 | F47012 | EDI Purchase Order Detail - Inbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
91 | F47016 | EDI Purchase Order Header - Outbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
92 | F470161 | EDI Purchase Order Additional Header - Outbound | 71 | S3 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
93 | F47017 | EDI Purchase Order Detail - Outbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
94 | F470171 | EDI Purchase Order Additional Detail - Outbound | 52 | S4 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
95 | F47021 | EDI P.O. Acknowledgment Header - Inbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
96 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
97 | F47026 | EDI P.O. Acknowledgment Header - Outbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
98 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
99 | F47031 | EDI Shipping Notice Header - Inbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
100 | F47032 | EDI Shipping Notice Detail - Inbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
101 | F47036 | EDI Shipping Notice Header - Outbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
102 | F47037 | EDI Shipping Notice Detail - Outbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
103 | F470371 | EDI Shipping Notice Detail - Outbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
104 | F47041 | EDI Invoice Header - Inbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
105 | F47042 | EDI Invoice Detail - Inbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
106 | F47044 | EDI Invoice Summary - Inbound | 14 | SW | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
107 | F47046 | EDI Invoice Header (Sales) - Outbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
108 | F47047 | EDI Invoice Detail (Sales) - Outbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
109 | F47056 | EDI Payment Order Header - Outbound | 14 | D1 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
110 | F47056W | EDI Payment Order Header - Work | 14 | D1 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
111 | F47057 | EDI Payment Order Remittance Advice - Outbound | 14 | D3 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
112 | F47057W | EDI Payment Order Remittance Advice - Work | 14 | D3 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
113 | F47061 | EDI Planning Schedule Header - Inbound | 14 | MJ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
114 | F47062 | EDI Planning Schedule Detail - Inbound | 14 | MY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
115 | F47066 | EDI Planning Schedule Header - Outbound | 14 | MJ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
116 | F47067 | EDI Planning Schedule Detail - Outbound | 14 | MY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
117 | F47071 | EDI Receiving Advice Header - Inbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
118 | F47072 | EDI Receiving Advice Detail - Inbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
119 | F47076 | EDI Receiving Advice Header - Outbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
120 | F47077 | EDI Receiving Advice Detail - Outbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
121 | F47081 | EDI Price Sales Catalog Header - Inbound | 14 | FV | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
122 | F47082 | EDI Price Sales Catalog Detail - Inbound | 14 | FY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
123 | F47091 | EDI Request for Quote Header - Inbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
124 | F47092 | EDI Request for Quote Detail - Inbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
125 | F47096 | EDI Request for Quote Header - Outbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
126 | F47097 | EDI Request for Quote Detail - Outbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
127 | F47101 | EDI Response to RFQ Header - Inbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
128 | F47102 | EDI Response to RFQ Detail - Inbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
129 | F47106 | EDI Response to RFQ Header - Outbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
130 | F47107 | EDI Response to RFQ Detail - Outbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
131 | F47111 | EDI Lockbox/Payment Header - Transaction | 14 | Z1 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
132 | F47112 | EDI Lockbox Header - Transaction | 14 | Z2 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
133 | F47121 | EDI Product Activity Data Header - Inbound | 14 | M1 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
134 | F47122 | EDI Product Activity Data Detail - Inbound | 14 | MJ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
135 | F47126 | EDI Product Activity Data Header - Outbound | 14 | M1 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
136 | F47127 | EDI Product Activity Data Detail - Outbound | 14 | MJ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
137 | F47131 | EDI Purchase Order Change Header - Inbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
138 | F47132 | EDI Purchase Order Change Detail - Inbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
139 | F47136 | EDI Purchase Order Change Header - Outbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
140 | F47137 | EDI Purchase Order Change Detail - Outbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
141 | F47141 | EDI P.O. Change Acknowledgment Header - Inbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
142 | F471411 | Purchase Order Edit Object Log Table | 5 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
143 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
144 | F47146 | EDI P.O. Change Acknowledgment Header - Outbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
145 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
146 | F47156 | EDI Shipping Schedule Header - Outbound | 14 | SY | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
147 | F47157 | EDI Shipping Schedule Detail - Outbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
148 | F4716 | EDI Item Text - Inbound/Outbound | 14 | SZ | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |
149 | F47CTL | EDI Lockbox/Payment Work File | 18 | Z5 | PNID | Trading Partner ID | String | Generic Edit | 15 | 0 |