| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP17: Customer Service Management |
| 1 | F3112Z2 | Warranty Claim/Supplier Recovery processing | 61 | WL | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 2 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 85 | WS | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP31: Shop Floor Control |
| 3 | F3112 | Work Order Routing | 49 | WL | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 4 | F31122 | Work Order Time Transactions | 28 | WT | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 5 | F31122S | Purge Work Order Time Transactions | 28 | WT | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 6 | F31122Z1 | Work Order Time Transactions Unedited Transaction Table | 42 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 7 | F3112S | Purge Shop Floor Control Routing Instructions | 49 | WL | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 8 | F3112Z1 | Outbound Work Order Routings | 61 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 9 | F3114 | Rate Schedule Transaction File | 7 | IQ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 10 | F31UI002 | User Index - Variances | 16 | IG | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP31A: Manufacturing Accounting |
| 11 | F30UI003 | WIP Revaluation Work File | 24 | WR | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP34X: In-Memory Planning Advisor |
| 12 | F34X200W | Planning Details Supply/Demand Work Table | 36 | SD | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP37: Quality Management |
| 13 | F37900 | Certificate of Analysis (COA) Extract | 76 | TR | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP40: Inventory/OP Base |
| 14 | F4011Z | Batch Receiver File - Order Details | 82 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 15 | F4012ZW | WF - Destination Quantity | 41 | SP | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 16 | F4013Z | Kit Components Batch File | 8 | KS | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 17 | F4211AU | Sales Order Detail Audit File | 38 | AU | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 18 | F4211DT | Sales Order Detail Date Tracking File | 26 | DT | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 19 | F4211Z1 | Sales Order Detail Unedited Transaction File | 79 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP40R: Demand Scheduling |
| 20 | F40R41 | Demand History | 76 | DI | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 21 | F47UI002 | ASN Extract Packaging Work File | 36 | SP | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP41F: Apparel Management |
| 22 | FCW105 | Fair Share Sprinkling Rate | 5 | WF | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 23 | FCW21 | Work File Confirm Shipments | 11 | WK | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 24 | FCW31 | Proposal Order Line Details | 16 | LV | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 25 | FCW68 | Style Work Order Routings | 52 | WL | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 26 | FCW963 | Adjustment Calculation | 9 | AC | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP42: Sales Management |
| 27 | F420UI55 | Kit Balance Work File | 13 | UI | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 28 | F4211 | Sales Order Detail File | 66 | SD | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 29 | F42119 | Sales Order History File | 66 | SD | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 30 | F42199 | S.O. Detail Ledger File | 66 | SL | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 31 | F42565 | Invoice Print File | 23 | IW | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 32 | F4290 | Delivery Note History | 18 | SE | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 33 | F42UI11 | SO Detail Cache File (MBF) | 54 | ZD | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 34 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 75 | ZD | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 35 | F42UI130 | Commitment Work File | 16 | ZC | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 36 | F42UI521 | Pick Slips Detail File | 62 | S9 | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 37 | F42UI800 | Sales Detail Work File - Sales Update | 45 | SD | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP42B: Sales Order Entry |
| 38 | F4211SW | Sales Order Detail Summary Work File | 9 | SS | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 39 | F42420 | Audit Log Transaction | 30 | AL | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP42I: Outbound Inventory Management |
| 40 | F42I02 | Outbound Inventory Agreement Acknowledge | 42 | OI | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP42W: Fulfilment Management |
| 41 | F427UI01 | Release Fulfillment Work File | 9 | RF | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP42X: In-Memory Sales Advisor |
| 42 | F42X060W | Supply Monitor Chart Work File | 28 | DC | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP43: Procurement |
| 43 | F43121Z | Receiver workfile | 48 | PW | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP43S: JSSS/Supplier Self Service |
| 44 | F43001 | Procurement Self-Service Transaction Log | 18 | SA | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP45: Advanced Pricing |
| 45 | F4573 | Free Goods Reference File | 7 | RF | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 46 | F4576 | Ship and Debit Claims | 49 | AC | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 47 | F4576TMP | Ship and Debit Claims- Temp Table | 49 | AC | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 48 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 62 | Z1 | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP46: Warehouse Management |
| 49 | F4942Z1 | Work File for F4942 | 27 | SY | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP47: Electronic Commerce |
| 50 | F47012 | EDI Purchase Order Detail - Inbound | 83 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 51 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 83 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 52 | F47037 | EDI Shipping Notice Detail - Outbound | 80 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 53 | F470371 | EDI Shipping Notice Detail - Outbound | 90 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 54 | F47047 | EDI Invoice Detail (Sales) - Outbound | 83 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 55 | F47092 | EDI Request for Quote Detail - Inbound | 83 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 56 | F47107 | EDI Response to RFQ Detail - Outbound | 83 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 57 | F47132 | EDI Purchase Order Change Detail - Inbound | 84 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 58 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 85 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 59 | F47UI001 | ASN Extract Work File | 35 | SZ | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP48: Work Order Processing |
| 60 | F4801 | Work Order Master File | 66 | WA | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 61 | F4801S | Purge - Work Order Master file | 66 | WA | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 62 | F4801Z1 | Outbound Work Order Header | 85 | SY | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 63 | F48UI001 | X4801 Master Business Function Workfile | 69 | WA | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP49: Transportation Management |
| 64 | F49110 | Transportation Bill of Lading Workfile | 40 | BW | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 65 | F4942 | Shipment Detail | 12 | IS | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 66 | F49621 | Load Compartment Detail | 28 | TD | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 67 | F49634 | Load In-Transit Confirmed Quantities Detail | 10 | QD | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 68 | F49T10 | Sales Order Release Staging Table | 24 | OR | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 69 | F49T20 | Shipment Staging Table | 16 | SS | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 70 | F49T30 | Sales Confirm Staging Table | 16 | SO | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP74: EMEA Localization |
| 71 | F7420033 | Sales Document Line (Print Info) - COMM - 42 | 10 | PI | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP75I: India |
| 72 | F75I2213 | Setoff Temp Table | 11 | TT | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 73 | F75I309 | Personal Consumption - CENVAT setoff - IND - 41 | 30 | CS | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 74 | F75I322 | Excise - Work File for F04211 & F4101 | 17 | Q3 | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 75 | F75I322E | Excise - Work File for F04211 & F4101(Based on F75I322) | 17 | Q3 | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 76 | F75I3451 | Excise - ARE3 Form Detail-IND-00 | 16 | QD | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 77 | F75I346 | Excise - D3-Form Table | 16 | Q9 | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 78 | F75I385 | RG23D Register - Issues - IND - 42 | 15 | ED | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 79 | F75I401 | Sales Form Information-IND-42 | 31 | QA | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 80 | F75I401C | Sales Form Information- Secondary | 23 | QA | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 81 | F75I403 | Stock Transfer Details | 18 | AB | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 82 | F75I403T | Temp Data for F75i403 | 21 | AB | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 83 | F75I4213 | Setoff Report Data -IND -00 | 25 | SO | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 84 | F75I4223 | Sales Tax Summary/Detail | 14 | SD | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 85 | F75I601 | TCS Register Details-IND-42 | 21 | TR | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP75T: Taiwan |
| 86 | F75T42W | Work file with union of F4211 and F42119 | 35 | SW | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP76A: Argentina |
| 87 | F76A0219 | Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A | 12 | DL | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 88 | F76A021P | Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A | 12 | DL | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 89 | F76AUI21 | Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A | 12 | DL | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOP76H: Chile |
| 90 | F76H3B34 | Sales Document Line (Print Info) - CHI - 03B - 76H | 7 | PI | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 91 | F76H3B38 | Shipment Guide Line (Print Info) - CHI - 03B - 76H | 7 | PI | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 92 | F76H6008 | Manufactured Items - CHI - 41 - 76H | 8 | IP | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| TOPF31: Lean Transactions |
| 93 | FF31011 | TransactionID Master File | 8 | EH | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 94 | FF31011S | Purge - TransactionID Master File | 8 | ER | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 95 | FF31112 | Routing Transaction Table | 71 | EH | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 96 | FF31112S | Purge - Routing Transaction Table | 71 | ET | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 97 | FF31113 | Lean Transaction Labor Detail | 26 | LD | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
| 98 | FF31113S | Purge - Lean Transaction Labor Detail | 26 | LR | SOQS | Quantity Shipped | Numeric | Generic Edit | 15 | 0 |
