| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP30: Product Data Management |
1 | F300210 | Lean Multi Level Bill of Material Header | 7 | EH | STKT | Stocking Type | Character | UDC | 1 | 0 |
2 | F300211 | Lean Multi Level Bill of Material Detail | 19 | ED | STKT | Stocking Type | Character | UDC | 1 | 0 |
3 | F30UI008 | Bill of Material Comparison Work File | 8 | IJ | STKT | Stocking Type | Character | UDC | 1 | 0 |
4 | F30UI014 | BOM Header Work File for BI | 6 | BH | STKT | Stocking Type | Character | UDC | 1 | 0 |
5 | F30UI016 | BOM Explosion Work File for BI | 17 | BE | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP30A: Product Costing |
6 | F30UI011 | Work File for Cost Component | 11 | CC | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP31: Shop Floor Control |
7 | F3118 | Shortage Maintenance Master File | 15 | WN | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP31A: Manufacturing Accounting |
8 | F30UI003 | WIP Revaluation Work File | 21 | WR | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP34: Requirements Planning |
9 | F34UI004 | MPS Net Change User Index | 12 | M8 | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP34X: In-Memory Planning Advisor |
10 | F34X101W | Item Summary Work Table | 32 | IS | STKT | Stocking Type | Character | UDC | 1 | 0 |
11 | F34X110W | Item List Work Table | 8 | IL | STKT | Stocking Type | Character | UDC | 1 | 0 |
12 | F34X310W | Planning Advisor BOM Component Detail Table | 21 | PD | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP40: Inventory/OP Base |
13 | F4211AU | Sales Order Detail Audit File | 7 | AU | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP41: Inventory Management |
14 | F4101 | Item Master | 72 | IM | STKT | Stocking Type | Character | UDC | 1 | 0 |
15 | F4101A | Item File | 43 | IM | STKT | Stocking Type | Character | UDC | 1 | 0 |
16 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 87 | SZ | STKT | Stocking Type | Character | UDC | 1 | 0 |
17 | F4102 | Item Branch File | 67 | IB | STKT | Stocking Type | Character | UDC | 1 | 0 |
18 | F41UI001 | Inventory Transactions Detail File | 79 | IT | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP41F: Apparel Management |
19 | FCW09 | Item Revisions Work File | 8 | WR | STKT | Stocking Type | Character | UDC | 1 | 0 |
20 | FCW10 | Item Branch Work File | 4 | WB | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP42: Sales Management |
21 | F42565 | Invoice Print File | 186 | IW | STKT | Stocking Type | Character | UDC | 1 | 0 |
22 | F42UI11 | SO Detail Cache File (MBF) | 121 | ZD | STKT | Stocking Type | Character | UDC | 1 | 0 |
23 | F42UI130 | Commitment Work File | 40 | ZC | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP42X: In-Memory Sales Advisor |
24 | F42X050W | Order Level Upsell Candidate Items | 28 | CI | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP43: Procurement |
25 | F4311Z | Purchase Order Generator File | 193 | PW | STKT | Stocking Type | Character | UDC | 1 | 0 |
26 | F43121Z | Receiver workfile | 29 | PW | STKT | Stocking Type | Character | UDC | 1 | 0 |
27 | F4314Z | Voucher Match Selection File | 15 | PN | STKT | Stocking Type | Character | UDC | 1 | 0 |
28 | F4371 | Suggested Reorder Stock Items | 21 | PD | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP43Q: Strategic Sourcing |
29 | F43Q92 | Adhoc Item Definition | 3 | AI | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP46L: License Plating |
30 | F46LUI01 | Assign/Remove Items To LP Work File | 32 | WF | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP48: Work Order Processing |
31 | F48UI001 | X4801 Master Business Function Workfile | 136 | WA | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOP75I: India |
32 | F75I314Y | Excise - RG23A - II Item Wise Transaction File | 18 | Q1 | STKT | Stocking Type | Character | UDC | 1 | 0 |
33 | F75I316Y | Excise - PLA Item Wise Transaction File | 17 | Q2 | STKT | Stocking Type | Character | UDC | 1 | 0 |
34 | F75I318Y | Excise - RG23C - II Item Wise Transaction File | 17 | Q3 | STKT | Stocking Type | Character | UDC | 1 | 0 |
35 | F75I319Y | Excise - Consolidated Excise Duty Payment | 12 | Q1 | STKT | Stocking Type | Character | UDC | 1 | 0 |
36 | F75I322 | Excise - Work File for F04211 & F4101 | 15 | Q3 | STKT | Stocking Type | Character | UDC | 1 | 0 |
37 | F75I322E | Excise - Work File for F04211 & F4101(Based on F75I322) | 15 | Q3 | STKT | Stocking Type | Character | UDC | 1 | 0 |
38 | F75I395A | ER - 5 (1) | 5 | ER | STKT | Stocking Type | Character | UDC | 1 | 0 |
39 | F75I395B | ER - 5 (2) | 15 | ER | STKT | Stocking Type | Character | UDC | 1 | 0 |
40 | F75I395T | ER - 5 (temp) | 15 | ER | STKT | Stocking Type | Character | UDC | 1 | 0 |
41 | F75I396A | ER-6 - List of Finished goods manufactured | 5 | ES | STKT | Stocking Type | Character | UDC | 1 | 0 |
42 | F75I396B | ER-6 | 15 | SE | STKT | Stocking Type | Character | UDC | 1 | 0 |
43 | F75I396T | ER-6 Temp | 16 | SE | STKT | Stocking Type | Character | UDC | 1 | 0 |
44 | F75I397 | ER-6 Scrap | 10 | SC | STKT | Stocking Type | Character | UDC | 1 | 0 |
45 | F75I397B | ER-6 Scrap | 6 | ES | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOPF30L: DFM Line Design |
46 | FF30L501 | DFM Item Definition Master | 46 | IB | STKT | Stocking Type | Character | UDC | 1 | 0 |
TOPH91: Design Tools |
47 | F98TC002 | Table Conversion Normalized 1 | 6 | TN | STKT | Stocking Type | Character | UDC | 1 | 0 |
48 | F98TC01 | Table Conversion UnNormalized | 10 | TC | STKT | Stocking Type | Character | UDC | 1 | 0 |