JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

613 columns | Print definition?812 | ITM

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Sales/Use/V.A.T. Tax File23TDITMItem Number - ShortNumericGeneric Edit80
2F0039MGenerated Document Media Object History2GHITMItem Number - ShortNumericGeneric Edit80
3F004201Prepayment Transaction Table45PTITMItem Number - ShortNumericGeneric Edit80
4F0911Account Ledger113GLITMItem Number - ShortNumericGeneric Edit80
5F0911TAccount Ledger Tag File26GLITMItem Number - ShortNumericGeneric Edit80
6F4008Tax Areas20TAITMItem Number - ShortNumericGeneric Edit80
TOP03: Accounts Receivable
7F0311Accounts Receivable Ledger137RPITMItem Number - ShortNumericGeneric Edit80
TOP03B: Enhanced Accounts Receivable
8F03B11Customer Ledger95RPITMItem Number - ShortNumericGeneric Edit80
9F03B112Invoice Revisions49RWITMItem Number - ShortNumericGeneric Edit80
10F03B112PInvoice Revisions Purge File49RWITMItem Number - ShortNumericGeneric Edit80
11F03B11PCustomer Ledger Purge File95RPITMItem Number - ShortNumericGeneric Edit80
12F03B11Z1Invoice Transactions - Batch File111VJITMItem Number - ShortNumericGeneric Edit80
13F03B11Z2F03B11 Interoperability Table108SYITMItem Number - ShortNumericGeneric Edit80
14F03B575Auto Debit Invoice Select and Build104RDITMItem Number - ShortNumericGeneric Edit80
TOP04: Accounts Payable
15F0411Accounts Payable Ledger87RPITMItem Number - ShortNumericGeneric Edit80
16F0411AWF - As Of - Accounts Payable Ledger87RPITMItem Number - ShortNumericGeneric Edit80
17F0411PPurge - Accounts Payable Ledger87RPITMItem Number - ShortNumericGeneric Edit80
18F0411Z1Voucher Transactions - Batch File105VLITMItem Number - ShortNumericGeneric Edit80
19F0411Z3F0411 Interoperability Table110SZITMItem Number - ShortNumericGeneric Edit80
20F09UI006Tax (F0018) Replica23TDITMItem Number - ShortNumericGeneric Edit80
TOP05: Time Accounting and HRM Base
21F0618Employee Transaction History25YTITMItem Number - ShortNumericGeneric Edit80
22F069162Job Type/ Item Cross Reference File4JHITMItem Number - ShortNumericGeneric Edit80
TOP05T: Time Entry
23F06116Employee Transaction Detail File25YTITMItem Number - ShortNumericGeneric Edit80
24F06116Z1Employee Transactions - Batch File172VLITMItem Number - ShortNumericGeneric Edit80
25F0623Piecework History File6JLITMItem Number - ShortNumericGeneric Edit80
26F06278Retro Timecard Detail File28YTITMItem Number - ShortNumericGeneric Edit80
27F06916Piecework Item Master1JJITMItem Number - ShortNumericGeneric Edit80
28F069161Item Master Cross Reference File4JEITMItem Number - ShortNumericGeneric Edit80
29F06918PF - Piece Rate File8JNITMItem Number - ShortNumericGeneric Edit80
TOP07: Payroll
30F0716701Employee Assignment T/E Template Information30EAITMItem Number - ShortNumericGeneric Edit80
31F0716709Employee Assignment T/E Template Info History30EAITMItem Number - ShortNumericGeneric Edit80
32F071861Stub Detail Piece Rate History File11Y8ITMItem Number - ShortNumericGeneric Edit80
33F073521Stub Detail Piece Rate File11Y2ITMItem Number - ShortNumericGeneric Edit80
34F07UI200Timecard History Work File28THITMItem Number - ShortNumericGeneric Edit80
TOP09: General Accounting
35F0911PPurge - Account Ledger113GLITMItem Number - ShortNumericGeneric Edit80
36F0911RWF - Acct Ledger File for Reconciliation68GLITMItem Number - ShortNumericGeneric Edit80
37F0911Z1Journal Entry Transactions - Batch File164VNITMItem Number - ShortNumericGeneric Edit80
38F0911Z1TJournal Entry Transactions - Batch Tag File23VNITMItem Number - ShortNumericGeneric Edit80
39F0911Z4F0911 Interoperability Table144SZITMItem Number - ShortNumericGeneric Edit80
TOP13: Plant/Equipment Management
40F13017Equipment Parts List6PLITMItem Number - ShortNumericGeneric Edit80
41F13411PM Projections36RXITMItem Number - ShortNumericGeneric Edit80
TOP13C: Condition-Base Maintenance
42F1316Condition-Based Maintenance Message Rules9CMITMItem Number - ShortNumericGeneric Edit80
43F1318Condition-Based Maintenance Alert Action Rules8ARITMItem Number - ShortNumericGeneric Edit80
TOP16: Profit Management (EPS)
44F1602Cost Analyzer Balances16CBITMItem Number - ShortNumericGeneric Edit80
45F1602Z1External Cost Analyzer Balances - Interoperability Table38CZITMItem Number - ShortNumericGeneric Edit80
46F1610Cost Calculation Definitions39CDITMItem Number - ShortNumericGeneric Edit80
47F1611Cost Calculation Transactions25CTITMItem Number - ShortNumericGeneric Edit80
48F1632Driver Balances16CBITMItem Number - ShortNumericGeneric Edit80
49F1632Z1External Driver Balances-Interoperability Table38CYITMItem Number - ShortNumericGeneric Edit80
50F16421Rate Master Detail File2RDITMItem Number - ShortNumericGeneric Edit80
TOP17: Customer Service Management
51F17113Assessor Defaults5ADITMItem Number - ShortNumericGeneric Edit80
52F1721Contract Detail39CDITMItem Number - ShortNumericGeneric Edit80
53F1771Standard Repair Time3RTITMItem Number - ShortNumericGeneric Edit80
54F1775Claim Temporary Table4TCITMItem Number - ShortNumericGeneric Edit80
55F1791Entitlement Dates3EMITMItem Number - ShortNumericGeneric Edit80
56F4117Item Master - Customer Service Extension1PRITMItem Number - ShortNumericGeneric Edit80
57F41171Item Branch Master - Customer Service Extension1PBITMItem Number - ShortNumericGeneric Edit80
58F4801Z2Warranty Claim/Supplier Recovery processing77WSITMItem Number - ShortNumericGeneric Edit80
TOP17C: Call Management
59F17111Base Warranty Defaults5BCITMItem Number - ShortNumericGeneric Edit80
60F1713ECOs Applied to Equipment6EEITMItem Number - ShortNumericGeneric Edit80
61F1755Customer Call Master71ZAITMItem Number - ShortNumericGeneric Edit80
62F48162Knowledge Base Tree Names7KNITMItem Number - ShortNumericGeneric Edit80
63F48164Knowledge Base Detail28KBITMItem Number - ShortNumericGeneric Edit80
TOP18: Resource Scheduling
64F186602Labor Rules Tag File38TFITMItem Number - ShortNumericGeneric Edit80
TOP30: Product Data Management
65F300210Lean Multi Level Bill of Material Header8EHITMItem Number - ShortNumericGeneric Edit80
66F300211Lean Multi Level Bill of Material Detail10EDITMItem Number - ShortNumericGeneric Edit80
67F3002Z1Bill of Material Transaction File19SZITMItem Number - ShortNumericGeneric Edit80
68F300311Lean Multi Level Routing Detail File46EHITMItem Number - ShortNumericGeneric Edit80
69F3016Kanban Master3KMITMItem Number - ShortNumericGeneric Edit80
70F3016TKanban Master Tag Table11KMITMItem Number - ShortNumericGeneric Edit80
71F30UI008Bill of Material Comparison Work File4IJITMItem Number - ShortNumericGeneric Edit80
72F30UI010Bill Of Material Work File1WFITMItem Number - ShortNumericGeneric Edit80
TOP30A: Product Costing
73F300261Item Cost Component Detail1IEITMItem Number - ShortNumericGeneric Edit80
TOP31: Shop Floor Control
74F3102Production Cost4IGITMItem Number - ShortNumericGeneric Edit80
75F3102SPurge - Production Cost4IGITMItem Number - ShortNumericGeneric Edit80
76F3102TWork Order Variance Tag2IGITMItem Number - ShortNumericGeneric Edit80
77F3109Line/Item Relationship Master1IPITMItem Number - ShortNumericGeneric Edit80
78F31091Schedule Quantity Detail1IQITMItem Number - ShortNumericGeneric Edit80
79F31091SSchedule Quantity Detail Purge1IQITMItem Number - ShortNumericGeneric Edit80
80F3114Rate Schedule Transaction File1IQITMItem Number - ShortNumericGeneric Edit80
81F3115Net Change Transaction table10NCITMItem Number - ShortNumericGeneric Edit80
82F3118Shortage Maintenance Master File2WNITMItem Number - ShortNumericGeneric Edit80
83F31UI002User Index - Variances2IGITMItem Number - ShortNumericGeneric Edit80
84F31UI006Line Scheduling Workbench - Work File34LSITMItem Number - ShortNumericGeneric Edit80
85F31UI802Accumulate Amounts by Account22WGITMItem Number - ShortNumericGeneric Edit80
86F31UI803Work File for Summarizing Journal Entries25SGITMItem Number - ShortNumericGeneric Edit80
87F4801SPurge - Work Order Master file58WAITMItem Number - ShortNumericGeneric Edit80
88F4801Z1Outbound Work Order Header77SYITMItem Number - ShortNumericGeneric Edit80
TOP31B: Blend Management
89F31B031Barrel Profile Table51BPITMItem Number - ShortNumericGeneric Edit80
90F31B04Material Type Master8MTITMItem Number - ShortNumericGeneric Edit80
91F31B051Equipment Consumables3ECITMItem Number - ShortNumericGeneric Edit80
92F31B053Consumable Assignments4CAITMItem Number - ShortNumericGeneric Edit80
93F31B07EUR Master File39EUITMItem Number - ShortNumericGeneric Edit80
94F31B102EUR Item Cross Reference2EUITMItem Number - ShortNumericGeneric Edit80
95F31B318Lot Accumulated Additives3ACITMItem Number - ShortNumericGeneric Edit80
96F31B66Blend Transactions18BTITMItem Number - ShortNumericGeneric Edit80
97F31B84Operation Additives3OAITMItem Number - ShortNumericGeneric Edit80
98F31B85Weigh Tag Master36WTITMItem Number - ShortNumericGeneric Edit80
99F31B85TWeigh Tag Master Tag Table4WTITMItem Number - ShortNumericGeneric Edit80
100F31B99Decant Detail3DDITMItem Number - ShortNumericGeneric Edit80
TOP31P: Engineer To Order
101F31P11Project Quote Detail21QPITMItem Number - ShortNumericGeneric Edit80
TOP32: Configuration Management
102F3212Configurator Routings File5RCITMItem Number - ShortNumericGeneric Edit80
103F3215Configurator Component Table4CCITMItem Number - ShortNumericGeneric Edit80
104F32159Configurator Component History Table4CHITMItem Number - ShortNumericGeneric Edit80
105F3283Rules Table Detail30RDITMItem Number - ShortNumericGeneric Edit80
106F3293Assembly Inclusions Rules8KYITMItem Number - ShortNumericGeneric Edit80
107F3294Configured String History File13KZITMItem Number - ShortNumericGeneric Edit80
108F32943Configured String History - OneWorld14KOITMItem Number - ShortNumericGeneric Edit80
109F3294ZConfigurator Batch Segments6AZITMItem Number - ShortNumericGeneric Edit80
110F3295Segment Value History File10KSITMItem Number - ShortNumericGeneric Edit80
111F32961Configurator Cost/Price Adjustment File1KLITMItem Number - ShortNumericGeneric Edit80
112F329611Configurator Detail Cost/Price Adjustment Table6KBITMItem Number - ShortNumericGeneric Edit80
113F3296TConfigurator Level Sequence File Table9KAITMItem Number - ShortNumericGeneric Edit80
TOP33: Capacity Planning
114F3303Capacity Resource Profile2CTITMItem Number - ShortNumericGeneric Edit80
115F3312Capacity Pegging3CWITMItem Number - ShortNumericGeneric Edit80
TOP34: Requirements Planning
116F34006Forecast Summary Work File1SJITMItem Number - ShortNumericGeneric Edit80
117F3403Branch Relationships Master File3MPITMItem Number - ShortNumericGeneric Edit80
118F3404Co-Products Planning/Costing Table3PMITMItem Number - ShortNumericGeneric Edit80
119F3406Customer Address Relationship2CRITMItem Number - ShortNumericGeneric Edit80
120F3411MPS/MRP/DRP Message File2MMITMItem Number - ShortNumericGeneric Edit80
121F3412MPS/MRP/DRP Lower Level Requirements File1MWITMItem Number - ShortNumericGeneric Edit80
122F3413MPS/MRP/DRP Summary File1MRITMItem Number - ShortNumericGeneric Edit80
123F3430Vendor Schedule Quantity File1MVITMItem Number - ShortNumericGeneric Edit80
124F3435Vendor Schedule Commitment File1MCITMItem Number - ShortNumericGeneric Edit80
125F3440Vendor Schedule History File1MHITMItem Number - ShortNumericGeneric Edit80
126F3450Adhoc Vendor Schedule File2MAITMItem Number - ShortNumericGeneric Edit80
127F3460Forecast File1MFITMItem Number - ShortNumericGeneric Edit80
128F34A70Last Outbound Work Order Table1OWITMItem Number - ShortNumericGeneric Edit80
129F34UI004MPS Net Change User Index3M8ITMItem Number - ShortNumericGeneric Edit80
130F34UI005MRP Orders/Requirements User Index-Process Item4F5ITMItem Number - ShortNumericGeneric Edit80
131F34UI006MRP Co/By Product Net Quantity User Index5W6ITMItem Number - ShortNumericGeneric Edit80
132F43211Supplier Schedule Master File2SSITMItem Number - ShortNumericGeneric Edit80
133F43213SRS Ship Dates8VPITMItem Number - ShortNumericGeneric Edit80
TOP34A: Advanced Planning & Scheduling
134F34A60Last Outbound Purchase Order/Transfer Order1OBITMItem Number - ShortNumericGeneric Edit80
135F34A90Last Outbound Phantom Information3PIITMItem Number - ShortNumericGeneric Edit80
TOP36: Forecasting
136F3400Forecast Summary File14SGITMItem Number - ShortNumericGeneric Edit80
137F34007Forecast Prices2FHITMItem Number - ShortNumericGeneric Edit80
138F3460Z1Forecast Unedited Transactions14FTITMItem Number - ShortNumericGeneric Edit80
139F3470Demand Spreading Template3DSITMItem Number - ShortNumericGeneric Edit80
TOP37: Quality Management
140F37012Test Consumables3TCITMItem Number - ShortNumericGeneric Edit80
141F3703Non-Conforming Material3QEITMItem Number - ShortNumericGeneric Edit80
142F3711Test Results14TRITMItem Number - ShortNumericGeneric Edit80
143F3711Z1Test Results Unedited Transaction Table27SZITMItem Number - ShortNumericGeneric Edit80
144F37900Certificate of Analysis (COA) Extract14TRITMItem Number - ShortNumericGeneric Edit80
145F40318Preference Profile - Quality Management3QCITMItem Number - ShortNumericGeneric Edit80
TOP38: Agreement Management
146F38011Agreement Quantities7DFITMItem Number - ShortNumericGeneric Edit80
147F38012Product Source/Destination Master3DPITMItem Number - ShortNumericGeneric Edit80
148F38014Agreement Formulas and Factors4DRITMItem Number - ShortNumericGeneric Edit80
149F38111Agreements Transaction Ledger6DZITMItem Number - ShortNumericGeneric Edit80
TOP39: Advanced Stock Valuation
150F3904Item Pool Valuation Master3PLITMItem Number - ShortNumericGeneric Edit80
151F39041Valuation Category Master3VCITMItem Number - ShortNumericGeneric Edit80
152F39061Valuation Period Table6SOITMItem Number - ShortNumericGeneric Edit80
153F390619Historical Valuation Period Detail Table6SOITMItem Number - ShortNumericGeneric Edit80
154F39062Valuation Layers Table6STITMItem Number - ShortNumericGeneric Edit80
155F39063Period Additional Quantity Table5SUITMItem Number - ShortNumericGeneric Edit80
156F390639Historical Additional Quantity Table5SUITMItem Number - ShortNumericGeneric Edit80
157F39064Valuation Document Summary Table6DSITMItem Number - ShortNumericGeneric Edit80
158F390649Historical Valuation Document Summary Table6DSITMItem Number - ShortNumericGeneric Edit80
159F3908Item Pool Valuation Cost Master4CSITMItem Number - ShortNumericGeneric Edit80
160F3910G/L Adjustment Table5SCITMItem Number - ShortNumericGeneric Edit80
161F39120Temporary Period Build File for Stock Valuation4TFITMItem Number - ShortNumericGeneric Edit80
162F39120WPeriod Detail Work File1TWITMItem Number - ShortNumericGeneric Edit80
163F39121WAdditional Quantity Work File1AQITMItem Number - ShortNumericGeneric Edit80
TOP40: Inventory/OP Base
164F3002Bill of Material Master File6IXITMItem Number - ShortNumericGeneric Edit80
165F30026Item Cost Component Add-Ons1IEITMItem Number - ShortNumericGeneric Edit80
166F3011Bill of Materials Change File6IZITMItem Number - ShortNumericGeneric Edit80
167F3013ECO Parts List Detail9CYITMItem Number - ShortNumericGeneric Edit80
168F3015Component Locator File2CQITMItem Number - ShortNumericGeneric Edit80
169F30UI002Bill of Material Structure Analysis Work File1IXITMItem Number - ShortNumericGeneric Edit80
170F30UI004Bill of Material Update Work File17WFITMItem Number - ShortNumericGeneric Edit80
171F30UI006Lot Tracking Work File5ILITMItem Number - ShortNumericGeneric Edit80
172F32942Configured String Detail5SGITMItem Number - ShortNumericGeneric Edit80
173F32945Configured String Detail - One World6SIITMItem Number - ShortNumericGeneric Edit80
174F3462Forecast Shipment Summary1MBITMItem Number - ShortNumericGeneric Edit80
175F40051Return Material Authorization29RDITMItem Number - ShortNumericGeneric Edit80
176F40072Item Preference Groups1GIITMItem Number - ShortNumericGeneric Edit80
177F4011ZBatch Receiver File - Order Details49SZITMItem Number - ShortNumericGeneric Edit80
178F4012ZWWF - Destination Quantity14SPITMItem Number - ShortNumericGeneric Edit80
179F4013ZKit Components Batch File5KSITMItem Number - ShortNumericGeneric Edit80
180F4015Order Templates4OTITMItem Number - ShortNumericGeneric Edit80
181F4016Print Messages2TUITMItem Number - ShortNumericGeneric Edit80
182F4017Print Message Report Defaults2TVITMItem Number - ShortNumericGeneric Edit80
183F40301Preference Profile - Payment Terms3PTITMItem Number - ShortNumericGeneric Edit80
184F40301RPreference Resolution Ledger - Payment Terms5PTITMItem Number - ShortNumericGeneric Edit80
185F40302Preference Profile - Unit of Measure3PUITMItem Number - ShortNumericGeneric Edit80
186F40302RPreference Resolution Ledger - Pricing Unit Of Measure5PUITMItem Number - ShortNumericGeneric Edit80
187F40303Preference Profile - Revenue Cost Center3RVITMItem Number - ShortNumericGeneric Edit80
188F40303RPreference Resolution Ledger - Revenue Business Unit5RVITMItem Number - ShortNumericGeneric Edit80
189F40304Preference Profile - End Use3PEITMItem Number - ShortNumericGeneric Edit80
190F40304RPreference Resolution Ledger - End Use5PEITMItem Number - ShortNumericGeneric Edit80
191F40305Preference Profile - Print Messages3RMITMItem Number - ShortNumericGeneric Edit80
192F40305RPreference Resolution Ledger - Print Messages5RMITMItem Number - ShortNumericGeneric Edit80
193F40306Preference Profile - Inventory Sourcing3SRITMItem Number - ShortNumericGeneric Edit80
194F40307Preference Profile - Product Allocations3LAITMItem Number - ShortNumericGeneric Edit80
195F40308Preference Profile - Grade and Potency3GSITMItem Number - ShortNumericGeneric Edit80
196F40308RPreference Resolution Ledger - Grade and Potency5GSITMItem Number - ShortNumericGeneric Edit80
197F40309Preference Profile - Delivery Date3DYITMItem Number - ShortNumericGeneric Edit80
198F40309RPreference Resolution Ledger - Delivery Date5DYITMItem Number - ShortNumericGeneric Edit80
199F40310Preference Profile - Line of Business3LBITMItem Number - ShortNumericGeneric Edit80
200F40310RPreference Resolution Ledger - Line Of Business5LBITMItem Number - ShortNumericGeneric Edit80
201F40311Preference Profile - Price Code 13P1ITMItem Number - ShortNumericGeneric Edit80
202F40311RPreference Resolution Ledger - User Defined Price Code #15P1ITMItem Number - ShortNumericGeneric Edit80
203F40312Preference Profile - Price Code 23P2ITMItem Number - ShortNumericGeneric Edit80
204F40312RPreference Resolution Ledger - User Defined Price Code #25P2ITMItem Number - ShortNumericGeneric Edit80
205F40313Preference Profile - Price Code 33P3ITMItem Number - ShortNumericGeneric Edit80
206F40313RPreference Resolution Ledger - User Defined Price Code #35P3ITMItem Number - ShortNumericGeneric Edit80
207F40314Preference Profile - Price Adjustment Schedule3PJITMItem Number - ShortNumericGeneric Edit80
208F40314RPreference Resolution Ledger - Price Adjustment Schedule5PJITMItem Number - ShortNumericGeneric Edit80
209F40315Preference Profile - Invoice Cycling3PIITMItem Number - ShortNumericGeneric Edit80
210F40315RPreference Resolution Ledger - Invoice Cycle5PIITMItem Number - ShortNumericGeneric Edit80
211F40316Preference Profile - Order Preparation3OPITMItem Number - ShortNumericGeneric Edit80
212F40316RPreference Resolution Ledger - Order Preparation Days5OPITMItem Number - ShortNumericGeneric Edit80
213F40318RPreference Resolution Ledger - Quality Management5QCITMItem Number - ShortNumericGeneric Edit80
214F40320Preference Profile - Multi Shipping/Receiving Locations3LPITMItem Number - ShortNumericGeneric Edit80
215F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations4LPITMItem Number - ShortNumericGeneric Edit80
216F40329Preference Profile - Document Distribution3DDITMItem Number - ShortNumericGeneric Edit80
217F40330Preference Profile - Document Set3DGITMItem Number - ShortNumericGeneric Edit80
218F40331Preference Profile - Options and Equipment3OEITMItem Number - ShortNumericGeneric Edit80
219F40332Preference Profile - Customer Freight3CFITMItem Number - ShortNumericGeneric Edit80
220F40333Preference Profile - Carrier3CAITMItem Number - ShortNumericGeneric Edit80
221F40334Preference Profile - Mode of Transport3MTITMItem Number - ShortNumericGeneric Edit80
222F40338Preference Profile - Payment Terms (Branch)3PTITMItem Number - ShortNumericGeneric Edit80
223F40338RPreference Resolution Ledger - Payment Terms (Branch)5PTITMItem Number - ShortNumericGeneric Edit80
224F40339Preference Profile - Product Allocations (Branch)3LAITMItem Number - ShortNumericGeneric Edit80
225F40341Preference Profile - Next Order Status3NSITMItem Number - ShortNumericGeneric Edit80
226F40341RPreference Resolution Ledger - Next Order Status5NSITMItem Number - ShortNumericGeneric Edit80
227F40344Preference Profile - Sales Commission3SAITMItem Number - ShortNumericGeneric Edit80
228F40344RPreference Resolution Ledger - Sales Commission5SAITMItem Number - ShortNumericGeneric Edit80
229F40345Preference Profile - Customer Currency3CRITMItem Number - ShortNumericGeneric Edit80
230F40345RPreference Resolution Ledger - Customer Currency5CRITMItem Number - ShortNumericGeneric Edit80
231F40347Preference Profile - Pricing UOM (Branch)3RIITMItem Number - ShortNumericGeneric Edit80
232F40347RPreference Resolution Ledger - Pricing UOM (Branch)5RIITMItem Number - ShortNumericGeneric Edit80
233F40349Preference Profile - Revenue Business Unit (Branch)3RVITMItem Number - ShortNumericGeneric Edit80
234F40349RPreference Resolution Ledger - Revenue Bus Unit (Branch)5RVITMItem Number - ShortNumericGeneric Edit80
235F40350Preference Profiles - Conatiner Deposit/Rental3OQITMItem Number - ShortNumericGeneric Edit80
236F40540Item and Commodity Structure Relationship1ICITMItem Number - ShortNumericGeneric Edit80
237F4080Related Order Cross Reference Table16ROITMItem Number - ShortNumericGeneric Edit80
238F40P011Promotion Deal Detail File6PDITMItem Number - ShortNumericGeneric Edit80
239F40UI002Supplier History Rebuild -workfile4UTITMItem Number - ShortNumericGeneric Edit80
240F40UI00TTax Work File16PNITMItem Number - ShortNumericGeneric Edit80
241F40UI17Allocation Work File10ZGITMItem Number - ShortNumericGeneric Edit80
242F40UI74Price Adjustment History Work File19AWITMItem Number - ShortNumericGeneric Edit80
243F41002Item Units of Measure Conversion Factors2UMITMItem Number - ShortNumericGeneric Edit80
244F41011Bulk Item Master1PKITMItem Number - ShortNumericGeneric Edit80
245F41015Item Duplication Work File1BAITMItem Number - ShortNumericGeneric Edit80
246F41022Bulk Depot/Product Information2PNITMItem Number - ShortNumericGeneric Edit80
247F4104Item Cross Reference File3IVITMItem Number - ShortNumericGeneric Edit80
248F4106Item Base Price File1BPITMItem Number - ShortNumericGeneric Edit80
249F4106NCBase Price Extraction14SZITMItem Number - ShortNumericGeneric Edit80
250F4108Lot Master5IOITMItem Number - ShortNumericGeneric Edit80
251F41112Item ASOF File4INITMItem Number - ShortNumericGeneric Edit80
252F41500Tank Master File47PPITMItem Number - ShortNumericGeneric Edit80
253F41508Default Tank Information4PCITMItem Number - ShortNumericGeneric Edit80
254F4171Critical Hold Management8I1ITMItem Number - ShortNumericGeneric Edit80
255F4209Held Orders10HOITMItem Number - ShortNumericGeneric Edit80
256F4211AUSales Order Detail Audit File16AUITMItem Number - ShortNumericGeneric Edit80
257F4211DTSales Order Detail Date Tracking File12DTITMItem Number - ShortNumericGeneric Edit80
258F4211Z1Sales Order Detail Unedited Transaction File46SZITMItem Number - ShortNumericGeneric Edit80
259F4220Basic Serial Numbers1SWITMItem Number - ShortNumericGeneric Edit80
260F46010Item Profile2IPITMItem Number - ShortNumericGeneric Edit80
TOP40G: Grower Management
261F31B77BWWork File for Weigh Tag Summary Report35WSITMItem Number - ShortNumericGeneric Edit80
262F40G02Grower Block59GBITMItem Number - ShortNumericGeneric Edit80
263F40G041Item Spray Information1ISITMItem Number - ShortNumericGeneric Edit80
264F40G042Spray Master EUR Restriction1SEITMItem Number - ShortNumericGeneric Edit80
265F40G043Restricted Spray Style Information - F40G0431SSITMItem Number - ShortNumericGeneric Edit80
266F40G150Crush and Purchase Report Details4CPITMItem Number - ShortNumericGeneric Edit80
267F40G65Farming Operation Header3FOITMItem Number - ShortNumericGeneric Edit80
TOP40R: Demand Scheduling
268F40R10Demand Header5DHITMItem Number - ShortNumericGeneric Edit80
269F40R11Demand Detail7DDITMItem Number - ShortNumericGeneric Edit80
270F40R30WFDemand Work File17DSITMItem Number - ShortNumericGeneric Edit80
271F40R41Demand History12DIITMItem Number - ShortNumericGeneric Edit80
272F47172EDI Demand Detail14EDITMItem Number - ShortNumericGeneric Edit80
273F47UI002ASN Extract Packaging Work File5SPITMItem Number - ShortNumericGeneric Edit80
TOP41: Inventory Management
274F41008Matrix Detail13S0ITMItem Number - ShortNumericGeneric Edit80
275F41008DMatrix Detail Alternate Language5S0ITMItem Number - ShortNumericGeneric Edit80
276F4101Item Master1IMITMItem Number - ShortNumericGeneric Edit80
277F41013Unique Product Number3UNITMItem Number - ShortNumericGeneric Edit80
278F4101AItem File2IMITMItem Number - ShortNumericGeneric Edit80
279F4101BItem Master Bulk Data2IMITMItem Number - ShortNumericGeneric Edit80
280F4101CItem Category Codes2IMITMItem Number - ShortNumericGeneric Edit80
281F4101DItem Master - Alternative Description1IMITMItem Number - ShortNumericGeneric Edit80
282F4101FItem Customer Service Data2IMITMItem Number - ShortNumericGeneric Edit80
283F4101GItem Branch Quantities2IBITMItem Number - ShortNumericGeneric Edit80
284F4101MItem Manufacturing Data2IMITMItem Number - ShortNumericGeneric Edit80
285F4101PItem Master Packaging2IMITMItem Number - ShortNumericGeneric Edit80
286F4101SItem Master Shipping Data2IMITMItem Number - ShortNumericGeneric Edit80
287F4101TItem Master Tag File2IMITMItem Number - ShortNumericGeneric Edit80
288F4101WItem Profile Data2IMITMItem Number - ShortNumericGeneric Edit80
289F4101Z1F4101 Item Master Unedited Transaction Table15SZITMItem Number - ShortNumericGeneric Edit80
290F4101Z1AF4101 Detail Item Master Unedited Transaction16SZITMItem Number - ShortNumericGeneric Edit80
291F4102Item Branch File1IBITMItem Number - ShortNumericGeneric Edit80
292F41021Item Location File1LIITMItem Number - ShortNumericGeneric Edit80
293F410211Project Commitment Detail Table4PCITMItem Number - ShortNumericGeneric Edit80
294F41021AItem Location File - Temporary Upgrade1LIITMItem Number - ShortNumericGeneric Edit80
295F41021WFF41021 Transaction Workfile5LWITMItem Number - ShortNumericGeneric Edit80
296F41021Z1Item Location Unedited Transaction File14SZITMItem Number - ShortNumericGeneric Edit80
297F41023Item Location Definition Table1ILITMItem Number - ShortNumericGeneric Edit80
298F4105Item Cost File1COITMItem Number - ShortNumericGeneric Edit80
299F41051Average Cost Work file1CHITMItem Number - ShortNumericGeneric Edit80
300F4105Z1Unedited Transaction Table - Item Cost14SZITMItem Number - ShortNumericGeneric Edit80
301F41092Item Supplemental Data Base User Defined Codes3T2ITMItem Number - ShortNumericGeneric Edit80
302F4111Item Ledger File2ILITMItem Number - ShortNumericGeneric Edit80
303F41113Lot Ledger3I8ITMItem Number - ShortNumericGeneric Edit80
304F41131Stranded Hard Commitments Table2IUITMItem Number - ShortNumericGeneric Edit80
305F4115Item History1IHITMItem Number - ShortNumericGeneric Edit80
306F4118Container Deposit File3CNITMItem Number - ShortNumericGeneric Edit80
307F41181Container Transaction File2CMITMItem Number - ShortNumericGeneric Edit80
308F41182Container Serial5CSITMItem Number - ShortNumericGeneric Edit80
309F41185Container Reconciliation File1CTITMItem Number - ShortNumericGeneric Edit80
310F4141Cycle Count Transaction File3PJITMItem Number - ShortNumericGeneric Edit80
311F4141Z1F4141 Cycle Count Unedited Transaction Table16SZITMItem Number - ShortNumericGeneric Edit80
312F4160Tag Inventory File3ITITMItem Number - ShortNumericGeneric Edit80
313F41829Item Word Search Table2IWITMItem Number - ShortNumericGeneric Edit80
314F41UI001Inventory Transactions Detail File13ITITMItem Number - ShortNumericGeneric Edit80
315F41UI002Inventory Transactions Batch File2TIITMItem Number - ShortNumericGeneric Edit80
316F41UI003ABC Analysis Detail - Work File4AAITMItem Number - ShortNumericGeneric Edit80
TOP41B: Bulk Stock Management
317F41506Meter Master6PMITMItem Number - ShortNumericGeneric Edit80
318F41509Four-Point Analysis Maintenance File13PGITMItem Number - ShortNumericGeneric Edit80
319F41511Bulk Product Transaction File16PAITMItem Number - ShortNumericGeneric Edit80
320F41512Gain/Loss Transactions File2PTITMItem Number - ShortNumericGeneric Edit80
321F41514Operational Reconciliations History2RHITMItem Number - ShortNumericGeneric Edit80
322F41515Multi-Meter Readings2PQITMItem Number - ShortNumericGeneric Edit80
TOP42: Sales Management
323F4074Price Adjustment Ledger File13ALITMItem Number - ShortNumericGeneric Edit80
324F42005Sales Commission File43SCITMItem Number - ShortNumericGeneric Edit80
325F4211Sales Order Detail File33SDITMItem Number - ShortNumericGeneric Edit80
326F42119Sales Order History File33SDITMItem Number - ShortNumericGeneric Edit80
327F42199S.O. Detail Ledger File33SLITMItem Number - ShortNumericGeneric Edit80
328F4229Sales Summary History File4SSITMItem Number - ShortNumericGeneric Edit80
329F4239Last Customer Shipment2LCITMItem Number - ShortNumericGeneric Edit80
330F42565Invoice Print File16IWITMItem Number - ShortNumericGeneric Edit80
331F42800G1Sales Update G Batch Detail Workfile114DGITMItem Number - ShortNumericGeneric Edit80
332F4290Delivery Note History15SEITMItem Number - ShortNumericGeneric Edit80
333F42UI005Sales Commission File43SCITMItem Number - ShortNumericGeneric Edit80
334F42UI11SO Detail Cache File (MBF)36ZDITMItem Number - ShortNumericGeneric Edit80
335F42UI11CCustomer Self Service Shopping Cart Workfile7SCITMItem Number - ShortNumericGeneric Edit80
336F42UI12Sales Order Detail Cache 2 (MBF)71ZDITMItem Number - ShortNumericGeneric Edit80
337F42UI130Commitment Work File12ZCITMItem Number - ShortNumericGeneric Edit80
338F42UI521Pick Slips Detail File28S9ITMItem Number - ShortNumericGeneric Edit80
339F42UI800Sales Detail Work File - Sales Update12SDITMItem Number - ShortNumericGeneric Edit80
TOP42B: Sales Order Entry
340F42216WFPending Blanket Release Work File - F42216WF10PBITMItem Number - ShortNumericGeneric Edit80
341F42440Customer Segment Items1CSITMItem Number - ShortNumericGeneric Edit80
342F42UI440Customer Segment Items - Work File1CSITMItem Number - ShortNumericGeneric Edit80
TOP43: Procurement
343F41061Supplier Price/Catalog File3CBITMItem Number - ShortNumericGeneric Edit80
344F41291Item Cost Components2IGITMItem Number - ShortNumericGeneric Edit80
345F43080Approvals Fields Constants43PDITMItem Number - ShortNumericGeneric Edit80
346F43090Supplier/Item Relationships2PCITMItem Number - ShortNumericGeneric Edit80
347F43092ZReceipt Routing Work File42PVITMItem Number - ShortNumericGeneric Edit80
348F43092Z1Receipt Routing Unedited Transaction Table36SZITMItem Number - ShortNumericGeneric Edit80
349F43093Inspection/Sample Size Table2PEITMItem Number - ShortNumericGeneric Edit80
350F43094Supplier Item Additional Routes2P5ITMItem Number - ShortNumericGeneric Edit80
351F43099Receipt Routing Ledger File23POITMItem Number - ShortNumericGeneric Edit80
352F4311Purchase Order Detail File35PDITMItem Number - ShortNumericGeneric Edit80
353F4311ZPurchase Order Generator File39PWITMItem Number - ShortNumericGeneric Edit80
354F4311Z1Purchase Order Detail Unedited Transaction Table48SZITMItem Number - ShortNumericGeneric Edit80
355F43121Purchase Order Receiver File14PRITMItem Number - ShortNumericGeneric Edit80
356F43121ZReceiver workfile71PWITMItem Number - ShortNumericGeneric Edit80
357F43121Z1Receipts Unedited Transaction Table31SZITMItem Number - ShortNumericGeneric Edit80
358F4314ZVoucher Match Selection File113PNITMItem Number - ShortNumericGeneric Edit80
359F43199P.O. Detail Ledger File - Flexible Version35OLITMItem Number - ShortNumericGeneric Edit80
360F4322Purchasing Tolerance Rules2PZITMItem Number - ShortNumericGeneric Edit80
361F4342Purchase Inclusion Rules3RKITMItem Number - ShortNumericGeneric Edit80
362F4343Purchase Rebate History11RHITMItem Number - ShortNumericGeneric Edit80
363F4351Supplier Item Hyperlinks2H2ITMItem Number - ShortNumericGeneric Edit80
364F43632ZOpen Purchase Order by Item Work File12OIITMItem Number - ShortNumericGeneric Edit80
365F4371Suggested Reorder Stock Items1PDITMItem Number - ShortNumericGeneric Edit80
366F43E09F43E09 - Approvals Activity Table20AAITMItem Number - ShortNumericGeneric Edit80
367F43UI50DPO Print Detail Work File25PWITMItem Number - ShortNumericGeneric Edit80
TOP43C: Contracts
368F43C10Contract Block78CBITMItem Number - ShortNumericGeneric Edit80
369F43C11Contract Detail5CDITMItem Number - ShortNumericGeneric Edit80
TOP43E: Requisition Self Service
370F43E11Requisition Detail12RDITMItem Number - ShortNumericGeneric Edit80
371F43E20Shopping Cart Detail3SCITMItem Number - ShortNumericGeneric Edit80
372F43E20WFeReq - Shopping Cart Work File7SWITMItem Number - ShortNumericGeneric Edit80
TOP43Q: Strategic Sourcing
373F43Q11Event Detail7EDITMItem Number - ShortNumericGeneric Edit80
374F43Q41Response Line11RBITMItem Number - ShortNumericGeneric Edit80
375F43Q51Analyze Event Detail8EDITMItem Number - ShortNumericGeneric Edit80
376F43Q60Bid Questions3BQITMItem Number - ShortNumericGeneric Edit80
377F43Q61Bid Question List Values3BVITMItem Number - ShortNumericGeneric Edit80
378F43Q62Bid Question Price Component3BCITMItem Number - ShortNumericGeneric Edit80
TOP43S: Supplier Self Service
379F43001Procurement Self-Service Transaction Log11SAITMItem Number - ShortNumericGeneric Edit80
TOP44H: Homebuilder Management
380F4457Takeoff File (World)4JJITMItem Number - ShortNumericGeneric Edit80
381F4458Takeoff (World)4JKITMItem Number - ShortNumericGeneric Edit80
382F4459Material Item Pricing (World)2JLITMItem Number - ShortNumericGeneric Edit80
383F44H4101Item Master HomeBuilder Extension1HIITMItem Number - ShortNumericGeneric Edit80
384F44H602Takeoff Master File10TOITMItem Number - ShortNumericGeneric Edit80
385F44H602HTakeoff History File8THITMItem Number - ShortNumericGeneric Edit80
386F44H602WTake Off Summary Workfile11TSITMItem Number - ShortNumericGeneric Edit80
387F44H603Material Item Pricing2MPITMItem Number - ShortNumericGeneric Edit80
388F44H611Bid Details34BDITMItem Number - ShortNumericGeneric Edit80
389F44H611WBid Details Work File38BWITMItem Number - ShortNumericGeneric Edit80
390F44H711Lot Start Workfile6SWITMItem Number - ShortNumericGeneric Edit80
391F44H711PAfter Start Purchasing19TPITMItem Number - ShortNumericGeneric Edit80
392F44H711ZHB Lot Start Unedited Transaction File19SZITMItem Number - ShortNumericGeneric Edit80
393F44H71W1Lot Start Generation Workfile7GWITMItem Number - ShortNumericGeneric Edit80
394F44H73W1Lot Start - P.O. / Committment Generation Work File7CGITMItem Number - ShortNumericGeneric Edit80
TOP45: Advanced Pricing
395F4072Price Adjustment Detail2ADITMItem Number - ShortNumericGeneric Edit80
396F4072WPrice Adjustment Detail Work File2ADITMItem Number - ShortNumericGeneric Edit80
397F4077Rebate Thresholds3RTITMItem Number - ShortNumericGeneric Edit80
398F4078Rebate Transaction Summary2RHITMItem Number - ShortNumericGeneric Edit80
399F4079Rebate Transaction Detail2SVITMItem Number - ShortNumericGeneric Edit80
400F4511WPricing Structure View39APITMItem Number - ShortNumericGeneric Edit80
401F4551Basket Master Detail2BDITMItem Number - ShortNumericGeneric Edit80
402F45521Price List Detail7PDITMItem Number - ShortNumericGeneric Edit80
403F45522Price List Level-Break Pattern3PLITMItem Number - ShortNumericGeneric Edit80
404F45524Price List Item Selection3PIITMItem Number - ShortNumericGeneric Edit80
405F45715Adjustment Balances6ABITMItem Number - ShortNumericGeneric Edit80
406F4572Live Promotions X-Reference by Cost Type10XRITMItem Number - ShortNumericGeneric Edit80
407F4572Z1Live Promotions Interface - Inbound / Outbound24LPITMItem Number - ShortNumericGeneric Edit80
408F4572ZPPurge Live Promotions Interface24PGITMItem Number - ShortNumericGeneric Edit80
409F4574Key Reference Table5KRITMItem Number - ShortNumericGeneric Edit80
410F4575Ship and Debit History15AHITMItem Number - ShortNumericGeneric Edit80
411F4575TMPShip and Debit History - Temp Table15AHITMItem Number - ShortNumericGeneric Edit80
412F4576Ship and Debit Claims16ACITMItem Number - ShortNumericGeneric Edit80
413F4576TMPShip and Debit Claims- Temp Table16ACITMItem Number - ShortNumericGeneric Edit80
414F4576Z1Ship and Debit Claims Unedited Transaction Table29Z1ITMItem Number - ShortNumericGeneric Edit80
TOP46: Warehouse Management
415F4142Warehouse Count Transactions3CTITMItem Number - ShortNumericGeneric Edit80
416F4600Warehouse Requests14R1ITMItem Number - ShortNumericGeneric Edit80
417F4600PUWarehouse Requests - Purged14R1ITMItem Number - ShortNumericGeneric Edit80
418F46011Item Unit Of Measure Definition3IQITMItem Number - ShortNumericGeneric Edit80
419F46011TItem Unit Of Measure Definition Tag File3IQITMItem Number - ShortNumericGeneric Edit80
420F46012Fixed Locations3ISITMItem Number - ShortNumericGeneric Edit80
421F46013Carton Recommendation Rules2EQITMItem Number - ShortNumericGeneric Edit80
422F460131Standard Pack Recommendation Rules4SPITMItem Number - ShortNumericGeneric Edit80
423F46015Replenishment Information by Random Rule9RRITMItem Number - ShortNumericGeneric Edit80
424F460151Mixed Sequenced Packing Groups1MSITMItem Number - ShortNumericGeneric Edit80
425F4602Location Detail Information1IFITMItem Number - ShortNumericGeneric Edit80
426F46024Location Capacity4LCITMItem Number - ShortNumericGeneric Edit80
427F46025Maximum Putaway Quantity by Zone3MQITMItem Number - ShortNumericGeneric Edit80
428F46091Container and Carton Codes23IDITMItem Number - ShortNumericGeneric Edit80
429F46091TContainer and Carton Codes Tag File3IDITMItem Number - ShortNumericGeneric Edit80
430F46098Container Bill of Material5CBITMItem Number - ShortNumericGeneric Edit80
431F4611Warehouse Suggestions18R2ITMItem Number - ShortNumericGeneric Edit80
432F4611PUWarehouse Suggestions - Purged18R2ITMItem Number - ShortNumericGeneric Edit80
433F4611Z1Unedited Suggestion Table31SZITMItem Number - ShortNumericGeneric Edit80
434F46130Putaway Reservations9R3ITMItem Number - ShortNumericGeneric Edit80
435F46130PUPutaway Reservations - Purged9R3ITMItem Number - ShortNumericGeneric Edit80
436F4615Carton Recommendations7CRITMItem Number - ShortNumericGeneric Edit80
437F4620Carton Detail Information4CDITMItem Number - ShortNumericGeneric Edit80
438F46201Carton Charge Reference Setup3CCITMItem Number - ShortNumericGeneric Edit80
439F46UI15Carton Recommendations - Work File7RCITMItem Number - ShortNumericGeneric Edit80
440F4942Z1Work File for F494226SYITMItem Number - ShortNumericGeneric Edit80
TOP46L: License Plating
441F46L11License Plate Item Detail2IDITMItem Number - ShortNumericGeneric Edit80
442F46L12License Plate Commitment13LCITMItem Number - ShortNumericGeneric Edit80
443F46L42License Plate Cycle and Tag Count3CCITMItem Number - ShortNumericGeneric Edit80
444F46L99License Plate History7LMITMItem Number - ShortNumericGeneric Edit80
445F46LUI01Assign/Remove Items To LP Work File4WFITMItem Number - ShortNumericGeneric Edit80
446F46LUI03Assign/Remove Child LP Work File8WFITMItem Number - ShortNumericGeneric Edit80
TOP46R: RFID Outbound
447F46R030EPC Serial Number3ESITMItem Number - ShortNumericGeneric Edit80
TOP47: Electronic Commerce
448F47012EDI Purchase Order Detail - Inbound49SZITMItem Number - ShortNumericGeneric Edit80
449F47017EDI Purchase Order Detail - Outbound48SZITMItem Number - ShortNumericGeneric Edit80
450F47022EDI P.O. Acknowledgment Detail - Inbound48SZITMItem Number - ShortNumericGeneric Edit80
451F47027EDI P.O. Acknowledgment Detail - Outbound49SZITMItem Number - ShortNumericGeneric Edit80
452F47032EDI Shipping Notice Detail - Inbound47SZITMItem Number - ShortNumericGeneric Edit80
453F47037EDI Shipping Notice Detail - Outbound49SZITMItem Number - ShortNumericGeneric Edit80
454F470371EDI Shipping Notice Detail - Outbound55SZITMItem Number - ShortNumericGeneric Edit80
455F47042EDI Invoice Detail - Inbound28SZITMItem Number - ShortNumericGeneric Edit80
456F47047EDI Invoice Detail (Sales) - Outbound49SZITMItem Number - ShortNumericGeneric Edit80
457F47057EDI Payment Order Remittance Advice - Outbound54D3ITMItem Number - ShortNumericGeneric Edit80
458F47057WEDI Payment Order Remittance Advice - Work54D3ITMItem Number - ShortNumericGeneric Edit80
459F47062EDI Planning Schedule Detail - Inbound15MYITMItem Number - ShortNumericGeneric Edit80
460F47067EDI Planning Schedule Detail - Outbound15MYITMItem Number - ShortNumericGeneric Edit80
461F47072EDI Receiving Advice Detail - Inbound49SZITMItem Number - ShortNumericGeneric Edit80
462F47077EDI Receiving Advice Detail - Outbound49SZITMItem Number - ShortNumericGeneric Edit80
463F47082EDI Price Sales Catalog Detail - Inbound15FYITMItem Number - ShortNumericGeneric Edit80
464F47092EDI Request for Quote Detail - Inbound49SZITMItem Number - ShortNumericGeneric Edit80
465F47097EDI Request for Quote Detail - Outbound48SZITMItem Number - ShortNumericGeneric Edit80
466F47102EDI Response to RFQ Detail - Inbound48SZITMItem Number - ShortNumericGeneric Edit80
467F47107EDI Response to RFQ Detail - Outbound49SZITMItem Number - ShortNumericGeneric Edit80
468F47122EDI Product Activity Data Detail - Inbound22MJITMItem Number - ShortNumericGeneric Edit80
469F47127EDI Product Activity Data Detail - Outbound22MJITMItem Number - ShortNumericGeneric Edit80
470F47132EDI Purchase Order Change Detail - Inbound50SZITMItem Number - ShortNumericGeneric Edit80
471F47137EDI Purchase Order Change Detail - Outbound49SZITMItem Number - ShortNumericGeneric Edit80
472F47142EDI P.O. Change Acknowledgment Detail - Inbound50SZITMItem Number - ShortNumericGeneric Edit80
473F47147EDI P.O. Change Acknowledgment Detail - Outbound51SZITMItem Number - ShortNumericGeneric Edit80
474F47157EDI Shipping Schedule Detail - Outbound51SZITMItem Number - ShortNumericGeneric Edit80
475F4716EDI Item Text - Inbound/Outbound15SZITMItem Number - ShortNumericGeneric Edit80
476F47UI001ASN Extract Work File5SZITMItem Number - ShortNumericGeneric Edit80
TOP48: Work Order Processing
477F4801Work Order Master File58WAITMItem Number - ShortNumericGeneric Edit80
478F48UI001X4801 Master Business Function Workfile61WAITMItem Number - ShortNumericGeneric Edit80
TOP48S: Service Billing
479F4812Billing Detail Workfile157WDITMItem Number - ShortNumericGeneric Edit80
480F4812HBilling Workfile - History157WDITMItem Number - ShortNumericGeneric Edit80
481F4812HSBilling Workfile History Purged Save157WDITMItem Number - ShortNumericGeneric Edit80
482F48S0618Payroll Reclassification Workfile25YTITMItem Number - ShortNumericGeneric Edit80
483F48SUI01Billing Detail Print Workfile157WDITMItem Number - ShortNumericGeneric Edit80
TOP49: Transportation Management
484F49075Product Mix1PMITMItem Number - ShortNumericGeneric Edit80
485F4908Item Shipping Information1IIITMItem Number - ShortNumericGeneric Edit80
486F49110Transportation Bill of Lading Workfile39BWITMItem Number - ShortNumericGeneric Edit80
487F49111Carton Detail Shipment Workfile15CDITMItem Number - ShortNumericGeneric Edit80
488F49141Packing List Workfile19PWITMItem Number - ShortNumericGeneric Edit80
489F4942Shipment Detail11ISITMItem Number - ShortNumericGeneric Edit80
490F49490Document Selection17TQITMItem Number - ShortNumericGeneric Edit80
491F4962Load Compartments5TEITMItem Number - ShortNumericGeneric Edit80
492F49621Load Compartment Detail13TDITMItem Number - ShortNumericGeneric Edit80
493F4963Load In-transit4TIITMItem Number - ShortNumericGeneric Edit80
494F49631Load In-transit Ledger32TOITMItem Number - ShortNumericGeneric Edit80
495F49632Load In-transit Left on Board4LBITMItem Number - ShortNumericGeneric Edit80
TOP52: Contract Billing
496F5212T and M - Unit Price and Lumpsum Cross Reference Accounts22G5ITMItem Number - ShortNumericGeneric Edit80
TOP55: Reserved for Clients
497F554102WWork file F4102_wkf2IBITMItem Number - ShortNumericGeneric Edit80
498F55FR001Storno Bolle15SBITMItem Number - ShortNumericGeneric Edit80
499F55IF120Period Detail Work File Copy1TWITMItem Number - ShortNumericGeneric Edit80
500F55IF421Sales Order per BO39SDITMItem Number - ShortNumericGeneric Edit80
501F55IF425Sales Order per BO - 200539SDITMItem Number - ShortNumericGeneric Edit80
502F55IFLOGhistorical log8HLITMItem Number - ShortNumericGeneric Edit80
503F55IFP01Kit Pricing File5KPITMItem Number - ShortNumericGeneric Edit80
504F55IFQUAWork file per quadrature F41115QUITMItem Number - ShortNumericGeneric Edit80
505F55IFSFVEstrazione del venduto per Sales Force Automation4FSITMItem Number - ShortNumericGeneric Edit80
506F55W0100Correction Invoice Print - WF134SDITMItem Number - ShortNumericGeneric Edit80
507F58LP01Fichero Anexo Interfase de Artículos1IMITMItem Number - ShortNumericGeneric Edit80
508F744008Tax areas - Tag File EMEA - Spain / Italy2TAITMItem Number - ShortNumericGeneric Edit80
509F74H1051Invoicing Workfile - New7IWITMItem Number - ShortNumericGeneric Edit80
510F59I0010P06 PO Receipts Buffer5BFITMItem Number - ShortNumericGeneric Edit80
511F59I0011Purchase Receipt - Buffer7P1ITMItem Number - ShortNumericGeneric Edit80
512F59I0012Purchase Receipt - Template8P1ITMItem Number - ShortNumericGeneric Edit80
513F59I0013Purchase Receipt - Orders8P1ITMItem Number - ShortNumericGeneric Edit80
514F59I0021P07 Shipment Details7PDITMItem Number - ShortNumericGeneric Edit80
515F59I0060Cycle Count Import Table3CCITMItem Number - ShortNumericGeneric Edit80
516F59I0065Cycle Count Summary Report4WFITMItem Number - ShortNumericGeneric Edit80
TOP74: EMEA Localization
517F74093Workfile for Printing IVA Summary - Italy22HCITMItem Number - ShortNumericGeneric Edit80
518F7420033Sales Document Line (Print Info) - COMM - 426PIITMItem Number - ShortNumericGeneric Edit80
519F744102TCommodity Code Additional Inf Tag File - CZE - 742CCITMItem Number - ShortNumericGeneric Edit80
520F7464108Lot Additional Information - COMM - 412LOITMItem Number - ShortNumericGeneric Edit80
TOP74B: Begium Localization
521F74B100Monthly VAT Table Belgium Localisations5BTITMItem Number - ShortNumericGeneric Edit80
TOP74H: Hungary
522F74H1004VAT Declaration Detail11VDITMItem Number - ShortNumericGeneric Edit80
523F74H1007Tax Rate Summary Setup2TSITMItem Number - ShortNumericGeneric Edit80
TOP74R: CIS
524F74R0018Russian Tax File - 74R22TDITMItem Number - ShortNumericGeneric Edit80
525F74R0480Pay Item Differences - RUS - 04 - 74R7RPITMItem Number - ShortNumericGeneric Edit80
TOP75C: China - Reporting System Only
526F75C4106Chinese Free Goods VAT base price - F75C41061IBITMItem Number - ShortNumericGeneric Edit80
TOP75T: Taiwan
527F75T005GUI/VAT Transaction Detail - 75T4TDITMItem Number - ShortNumericGeneric Edit80
528F75T0059GUI/VAT Transaction Detail History - 75T4TDITMItem Number - ShortNumericGeneric Edit80
529F75T005PGUI/VAT Transaction Detail POS - 75T4TDITMItem Number - ShortNumericGeneric Edit80
530F75T005ZGUI/VAT Transaction Detail - Work - 75T10ZDITMItem Number - ShortNumericGeneric Edit80
TOP76A: Argentina
531F764008AAditionals Tax Areas - ARG2TQITMItem Number - ShortNumericGeneric Edit80
532F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A42DLITMItem Number - ShortNumericGeneric Edit80
533F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A42DLITMItem Number - ShortNumericGeneric Edit80
534F76A13Taxes - Tax Values - ARG - 003TVITMItem Number - ShortNumericGeneric Edit80
535F76A18Taxes - Tax Amounts by Sales Order Line - ARG - 009TOITMItem Number - ShortNumericGeneric Edit80
536F76A18PTaxes - Tax Amounts by Sales Order Line Purge - ARG - - 76A9TOITMItem Number - ShortNumericGeneric Edit80
537F76A393Calculated costs detail - 76A6C3ITMItem Number - ShortNumericGeneric Edit80
538F76A394Adjustments - 76A6C4ITMItem Number - ShortNumericGeneric Edit80
539F76A396Item Valuation Cost Master - 76A4CSITMItem Number - ShortNumericGeneric Edit80
540F76A8230Percentages by state / agreement Gross Income - ARG - - 76A8C1ITMItem Number - ShortNumericGeneric Edit80
541F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 0042DLITMItem Number - ShortNumericGeneric Edit80
TOP76B: Brazil - Reporting System Only
542F7608BICMS Tax Rates3TBITMItem Number - ShortNumericGeneric Edit80
543F76111BNota Fiscal - Detail (Fiscal Books) - 425QUITMItem Number - ShortNumericGeneric Edit80
544F76111BTConversion table for CFOP 5 digits - F76111B - 425TAITMItem Number - ShortNumericGeneric Edit80
545F7611BNota Fiscal Detail - Brazil23FDITMItem Number - ShortNumericGeneric Edit80
546F761BAAS Fiscal file book28FBITMItem Number - ShortNumericGeneric Edit80
547F76411Item Master Regional Information - Brazil1ITITMItem Number - ShortNumericGeneric Edit80
548F76412Item Branch Regional Information - Brazil1IJITMItem Number - ShortNumericGeneric Edit80
549F76B18IPI Taxes2FCITMItem Number - ShortNumericGeneric Edit80
550F76B3010Work Table for Item/Part List - 306IPITMItem Number - ShortNumericGeneric Edit80
TOP76C: Colombia
551F76C4008Additionals Tax Areas - COL - 042TAITMItem Number - ShortNumericGeneric Edit80
552F76CI3Tax Areas Tag File - COL - 76C3TAITMItem Number - ShortNumericGeneric Edit80
553F76CUI02Tax Detail - Work File - COL - 76C46TDITMItem Number - ShortNumericGeneric Edit80
554F76CUI04Tax Detail for Distribution - Work File - COL - 76C47TDITMItem Number - ShortNumericGeneric Edit80
TOP76H: Chile
555F76H020Tax rate columns reports set up - CHI - 00 - 76H2NOITMItem Number - ShortNumericGeneric Edit80
556F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H6PIITMItem Number - ShortNumericGeneric Edit80
557F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H6PIITMItem Number - ShortNumericGeneric Edit80
558F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H19I1ITMItem Number - ShortNumericGeneric Edit80
559F76H6003Indirect Costs Selection EPS F1642 - CHI - 41 - 76H11I2ITMItem Number - ShortNumericGeneric Edit80
560F76H6004Item Cost Component WF - CHI - 41 - 76H4ICITMItem Number - ShortNumericGeneric Edit80
561F76H6008Manufactured Items - CHI - 41 - 76H4IPITMItem Number - ShortNumericGeneric Edit80
562F76H6105Item Actual Cost File - CHI - 41 - 76H4ACITMItem Number - ShortNumericGeneric Edit80
563F76H611Actual Item Ledger File - CHI - 41 - 76H2ALITMItem Number - ShortNumericGeneric Edit80
564F76H6112Actual Item ASOF File - CHI - 41 - 76H4ANITMItem Number - ShortNumericGeneric Edit80
565F76H6205Item Replacement Cost - CHI - 414IRITMItem Number - ShortNumericGeneric Edit80
TOP76P: Peru
566F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P5CZITMItem Number - ShortNumericGeneric Edit80
TOP83: Management Reporting - FASTR
567F83UI001Balance Audit Work File - (Financial Reporting)27R1ITMItem Number - ShortNumericGeneric Edit80
TOP89: Conversion Programs
568F07186TPiece Rate History File11Y8ITMItem Number - ShortNumericGeneric Edit80
569F07352TPiece Rate Stub Detail Tag File11Y2ITMItem Number - ShortNumericGeneric Edit80
570F40344ATemporay Preference Profile - Sales Commission3SAITMItem Number - ShortNumericGeneric Edit80
571F4072TEMPrice Adjustment Detail - Temp for Upgrade2ADITMItem Number - ShortNumericGeneric Edit80
572F4101SRMItem Master SRM Tag File1IMITMItem Number - ShortNumericGeneric Edit80
573F4101TTTemp Table Merge Xe F4101T to E9 F41011IXITMItem Number - ShortNumericGeneric Edit80
574F4102SRMItem Branch SRM Tag File1IBITMItem Number - ShortNumericGeneric Edit80
575F4102TTTemp Table Merge Xe F4101T to E9 F41021IYITMItem Number - ShortNumericGeneric Edit80
576F42005ASales Commission File - Temporary43SCITMItem Number - ShortNumericGeneric Edit80
577F43199ATemp F43199 for ERP 9.0 Upgrade35OLITMItem Number - ShortNumericGeneric Edit80
TOP90CA: CRM Foundation
578F4107Item Feature Table1IFITMItem Number - ShortNumericGeneric Edit80
579F90CA05BPartner_Item Table2PBITMItem Number - ShortNumericGeneric Edit80
580F90CA06ACompetitor_KillSheet Table4RAITMItem Number - ShortNumericGeneric Edit80
581F90CA100CRM Item Table1ITITMItem Number - ShortNumericGeneric Edit80
582F90CA10BItem_Item_Hierarchy Table2IIITMItem Number - ShortNumericGeneric Edit80
TOP90CB: CRM Sales Force Automation
583F90CB02IOpportunity_Item Table7OIITMItem Number - ShortNumericGeneric Edit80
584F90CB06COpportunity_Item_For_Forecast Table8OHITMItem Number - ShortNumericGeneric Edit80
TOP90CE: CRM Solution Advisor
585F90CE01DSolution/ Item Intersection2SPITMItem Number - ShortNumericGeneric Edit80
586F90CE03ANumber of Cases with product 'X' solved by Solution2CSITMItem Number - ShortNumericGeneric Edit80
587F90CE03CNumber of Work Orders with product 'X' solved by Solution2WSITMItem Number - ShortNumericGeneric Edit80
TOP90CF: CRM Call Scripting
588F90CF16BScript/Item Table2ISITMItem Number - ShortNumericGeneric Edit80
TOPD3N: dcLINK (data collection) - DSI
589FD3N1611Pallet Tracking Table 22PDITMItem Number - ShortNumericGeneric Edit80
590FD3N161PPallet Tracking Table 44PHITMItem Number - ShortNumericGeneric Edit80
591FD3N4041Pallet Tracking Table 63CDITMItem Number - ShortNumericGeneric Edit80
592FD3N4116dcLINK Interface - Inventory Reclassification24IRITMItem Number - ShortNumericGeneric Edit80
593FD3N421PPallet Tracking Table 32SHITMItem Number - ShortNumericGeneric Edit80
594FD3N4950dcLINK Delivery Confirmation Work File9DCITMItem Number - ShortNumericGeneric Edit80
595FD3N913TranPrint - Default Labels - Table7DLITMItem Number - ShortNumericGeneric Edit80
TOPF31: Lean Transactions
596FF31010Production Master File3EHITMItem Number - ShortNumericGeneric Edit80
597FF31011TransactionID Master File5EHITMItem Number - ShortNumericGeneric Edit80
598FF31011SPurge - TransactionID Master File5ERITMItem Number - ShortNumericGeneric Edit80
599FF31111Lean Transaction Parts List8PLITMItem Number - ShortNumericGeneric Edit80
600FF311114Related Purchase Orders for Lean Pay on Consumption Issues5PCITMItem Number - ShortNumericGeneric Edit80
601FF31111SPurge - Lean Transaction Parts List8PRITMItem Number - ShortNumericGeneric Edit80
602FF31112Routing Transaction Table14EHITMItem Number - ShortNumericGeneric Edit80
603FF31112SPurge - Routing Transaction Table14ETITMItem Number - ShortNumericGeneric Edit80
604FF31113Lean Transaction Labor Detail8LDITMItem Number - ShortNumericGeneric Edit80
605FF31113SPurge - Lean Transaction Labor Detail8LRITMItem Number - ShortNumericGeneric Edit80
606FF31200Production Costs3PCITMItem Number - ShortNumericGeneric Edit80
TOPH90: ONEWORLD TOOLS
607F99DTLWorkflow Demonstration Sales Order Detail2WDITMItem Number - ShortNumericGeneric Edit80
608F99WFITMWorkflow Demonstration Item Table1WIITMItem Number - ShortNumericGeneric Edit80
TOPH91: Design Tools
609F98TC002Table Conversion Normalized 12TNITMItem Number - ShortNumericGeneric Edit80
610F98TC01Table Conversion UnNormalized2TCITMItem Number - ShortNumericGeneric Edit80
611F98TC03Table Conversion Normalized 22TNITMItem Number - ShortNumericGeneric Edit80
612F98TCDTLTable Conversion Detail5CDITMItem Number - ShortNumericGeneric Edit80
TOPH95: Tech Resources/Applications
613F00166Media Object Categories22GTITMItem Number - ShortNumericGeneric Edit80