JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides |  920 VMs | 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
10F4111ILItem Ledger File

812: Top 10 requests

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

187 columns | Print definition?920 | SEQ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00021Next Numbers by Company/Fiscal Year - Automatic10NLSEQSequence NumberNumericGeneric Edit60
2F00023Distributed Next Number Table22DNSEQSequence NumberNumericGeneric Edit60
3F004201Prepayment Transaction Table6PTSEQSequence NumberNumericGeneric Edit60
4F0046Processing Log7PLSEQSequence NumberNumericGeneric Edit60
5F0047Data Export Control3DESEQSequence NumberNumericGeneric Edit60
6F5194Inquiry Paths4JESEQSequence NumberNumericGeneric Edit60
7F80D309Metric Series Cross Ref2MSSEQSequence NumberNumericGeneric Edit60
8F80D322UI Metric Group Detail2MDSEQSequence NumberNumericGeneric Edit60
TOP05: Time Accounting and HRM Base
9F05005Generic UBE File2GFSEQSequence NumberNumericGeneric Edit60
10F05111Training/Development5CTSEQSequence NumberNumericGeneric Edit60
11F05112Skills/Resources4STSEQSequence NumberNumericGeneric Edit60
12F05113Accomplishments3ATSEQSequence NumberNumericGeneric Edit60
13F05114Certifications4CTSEQSequence NumberNumericGeneric Edit60
14F05115Education3ETSEQSequence NumberNumericGeneric Edit60
15F05116Languages4LTSEQSequence NumberNumericGeneric Edit60
16F05400Self-Service Process Flow Settings5PFSEQSequence NumberNumericGeneric Edit60
TOP07: Payroll
17F055011WAuto Deposit Instructions Work File22ADSEQSequence NumberNumericGeneric Edit60
18F065016Automatic Bank Deposit Master6YGSEQSequence NumberNumericGeneric Edit60
19F065016TAutomatic Bank Deposit Master (Additional)2YGSEQSequence NumberNumericGeneric Edit60
20F07811Negative Amount Workfile12JESEQSequence NumberNumericGeneric Edit60
21F07823Year-End Report Table4YFSEQSequence NumberNumericGeneric Edit60
22F07885SUI Payments for Quarterly Reporting5YWSEQSequence NumberNumericGeneric Edit60
TOP08AD: ADP Integration
23F051373ADP Employee Auto Deposit Instructions7ADSEQSequence NumberNumericGeneric Edit60
TOP08B: Benefits Administration
24F08372FSA - Pay Instruction File3BMSEQSequence NumberNumericGeneric Edit60
TOP08R: Recruitment Management - (Appl. Track. & Req.)
25F06018Date Parameter Extension4YFSEQSequence NumberNumericGeneric Edit60
TOP09: General Accounting
26F0917Bank Statement Detail7GDSEQSequence NumberNumericGeneric Edit60
27F48S80Segment Definition6SDSEQSequence NumberNumericGeneric Edit60
28F52G11Burdening Detail Ledger51BDSEQSequence NumberNumericGeneric Edit60
29F52G11WFTemporary Burdened Detail Ledger Workfile54BWSEQSequence NumberNumericGeneric Edit60
30F52G31WFReburdening Transactions Workfile16RBSEQSequence NumberNumericGeneric Edit60
31F52G60Burden Rate Calculations Workfile6BWSEQSequence NumberNumericGeneric Edit60
TOP12: Fixed Assets
32F1201Asset Master File6FASEQSequence NumberNumericGeneric Edit60
33F1201PAsset Master Purge Table6FASEQSequence NumberNumericGeneric Edit60
34F1201Z1Unedited Asset Master Transactions19FASEQSequence NumberNumericGeneric Edit60
TOP13: Plant/Equipment Management
35F12122Equipment Template Listing3ELSEQSequence NumberNumericGeneric Edit60
TOP13E: Equipment Cost Analysis
36F1382Equipment Analysis Listing3ELSEQSequence NumberNumericGeneric Edit60
37F1383Equipment Analysis Costs3ECSEQSequence NumberNumericGeneric Edit60
TOP15: Real Estate Management
38F15110BExpense Participation Class Account16OBSEQSequence NumberNumericGeneric Edit60
39F1514Area Master9NWSEQSequence NumberNumericGeneric Edit60
40F1514DArea Master - Alternate Description7NWSEQSequence NumberNumericGeneric Edit60
41F1514WArea Work File4NWSEQSequence NumberNumericGeneric Edit60
42F15151Building E.P. Caps3CDSEQSequence NumberNumericGeneric Edit60
43F15221Unit Attribute Template Fields4UFSEQSequence NumberNumericGeneric Edit60
44F159071Market/Potential/Renewal Rent Master6NYSEQSequence NumberNumericGeneric Edit60
45F159071DMarket/Potential/Renewal Rent Master - Alternate Description4NYSEQSequence NumberNumericGeneric Edit60
TOP15L: Adv Real Estate Forecasting
46F15L114AREF E.P. Rules Detail4EDSEQSequence NumberNumericGeneric Edit60
47F15L403AREF Gross Up Processing Audit39SHSEQSequence NumberNumericGeneric Edit60
TOP16: Profit Management (EPS)
48F1610Cost Calculation Definitions3CDSEQSequence NumberNumericGeneric Edit60
49F1611Cost Calculation Transactions4CTSEQSequence NumberNumericGeneric Edit60
TOP18: Timecard Automation
50F186203Employee Select Group Lines2SGSEQSequence NumberNumericGeneric Edit60
51F186405Overtime Change Rule Lines2OCSEQSequence NumberNumericGeneric Edit60
52F186410Overtime Time Card Select Lines2OTSEQSequence NumberNumericGeneric Edit60
53F186704Retropay Time Card Select Lines2RPSEQSequence NumberNumericGeneric Edit60
TOP34X: In-Memory Planning Advisor
54F34X101WItem Summary Work Table5ISSEQSequence NumberNumericGeneric Edit60
TOP38: Agreement Management
55F38011Agreement Quantities8DFSEQSequence NumberNumericGeneric Edit60
56F38012Product Source/Destination Master7DPSEQSequence NumberNumericGeneric Edit60
57F38013Agreement Quantities Schedule3DQSEQSequence NumberNumericGeneric Edit60
58F38111Agreements Transaction Ledger31DZSEQSequence NumberNumericGeneric Edit60
59F38112Agreements Committed Quantities8DXSEQSequence NumberNumericGeneric Edit60
TOP40: Inventory/OP Base
60F40320Preference Profile - Multi Shipping/Receiving Locations12LPSEQSequence NumberNumericGeneric Edit60
61F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations13LPSEQSequence NumberNumericGeneric Edit60
62F40711Preference Values Definition4PDSEQSequence NumberNumericGeneric Edit60
63F40721Preference Values Detail4PVSEQSequence NumberNumericGeneric Edit60
64F40741Preference Adjustment History7PHSEQSequence NumberNumericGeneric Edit60
65F40UI00TTax Work File1PNSEQSequence NumberNumericGeneric Edit60
66F49190Document Definition File (Conversion from World File)5DSSEQSequence NumberNumericGeneric Edit60
TOP40G: Grower Management
67F40G023Block Coordinates3BCSEQSequence NumberNumericGeneric Edit60
68F40G104Grower Action Dates3ADSEQSequence NumberNumericGeneric Edit60
TOP41: Inventory Management
69F41291ZLanded Cost Cache Table19IGSEQSequence NumberNumericGeneric Edit60
TOP42: Sales Management
70F40UI16Preference Print Message Work File7DSSEQSequence NumberNumericGeneric Edit60
71F42UI11SO Detail Cache File (MBF)144ZDSEQSequence NumberNumericGeneric Edit60
72F42UI130Commitment Work File10ZCSEQSequence NumberNumericGeneric Edit60
73F42UI520Pick Slips Header File1S8SEQSequence NumberNumericGeneric Edit60
74F42UI521Pick Slips Detail File1S9SEQSequence NumberNumericGeneric Edit60
75F42UI800Sales Detail Work File - Sales Update92SDSEQSequence NumberNumericGeneric Edit60
TOP42I: Outbound Inventory Management
76F42I011Outbound Inventory Agreement Details3OQSEQSequence NumberNumericGeneric Edit60
77F42I015Outbound Inventory Agreement Transaction File11OISEQSequence NumberNumericGeneric Edit60
78F42I02Outbound Inventory Agreement Acknowledge9OISEQSequence NumberNumericGeneric Edit60
79F42I021Outbound Inventory Item Balance3OQSEQSequence NumberNumericGeneric Edit60
80F42I03Outbound Order Consumption Report File8OISEQSequence NumberNumericGeneric Edit60
81F42I07Outbound Inventory Agreement Details Change History9OQSEQSequence NumberNumericGeneric Edit60
82F42I08Replenishment Quantity and Price Override Table4PRSEQSequence NumberNumericGeneric Edit60
83F42I09Outbound Hold and Return Transactions3OISEQSequence NumberNumericGeneric Edit60
TOP43: Procurement
84F4311ZPurchase Order Generator File199PWSEQSequence NumberNumericGeneric Edit60
85F43121ZReceiver workfile108PWSEQSequence NumberNumericGeneric Edit60
86F43UI50CPO Print Clauses Table1WCSEQSequence NumberNumericGeneric Edit60
87F43UI50DPO Print Detail Work File1PWSEQSequence NumberNumericGeneric Edit60
88F43UI50HPO Print Header Work File1PASEQSequence NumberNumericGeneric Edit60
TOP44H: Homebuilder Management
89F44H711Lot Start Workfile7SWSEQSequence NumberNumericGeneric Edit60
90F44H711ZHB Lot Start Unedited Transaction File20SZSEQSequence NumberNumericGeneric Edit60
91F44H712Lot Start Workfile Takeoff Detail7STSEQSequence NumberNumericGeneric Edit60
92F44H71W1Lot Start Generation Workfile8GWSEQSequence NumberNumericGeneric Edit60
93F44H73W1Lot Start - P.O. / Committment Generation Work File8CGSEQSequence NumberNumericGeneric Edit60
TOP45: Advanced Pricing
94F4574Key Reference Table77KRSEQSequence NumberNumericGeneric Edit60
TOP46: Warehouse Management
95F46014Replenishment Groups3RGSEQSequence NumberNumericGeneric Edit60
96F46027Available Space Tiebreaker2AVSEQSequence NumberNumericGeneric Edit60
97F46029Proximity Tiebreaker2LPSEQSequence NumberNumericGeneric Edit60
98F46051Fixed Replenisment Zones4LYSEQSequence NumberNumericGeneric Edit60
99F46095Movement Instructions6ETSEQSequence NumberNumericGeneric Edit60
100F46095TMovement Instructions Tag Table6TDSEQSequence NumberNumericGeneric Edit60
101F4611Warehouse Suggestions89R2SEQSequence NumberNumericGeneric Edit60
102F4611PUWarehouse Suggestions - Purged88R2SEQSequence NumberNumericGeneric Edit60
103F4611Z1Unedited Suggestion Table100SZSEQSequence NumberNumericGeneric Edit60
104F46130Putaway Reservations6R3SEQSequence NumberNumericGeneric Edit60
105F46130PUPutaway Reservations - Purged6R3SEQSequence NumberNumericGeneric Edit60
106F46821Random Locations4LXSEQSequence NumberNumericGeneric Edit60
TOP48: Work Order Processing
107F4827Work Order Approval Routing5W5SEQSequence NumberNumericGeneric Edit60
TOP48S: Service Billing
108F4861Component Table Detail4AFSEQSequence NumberNumericGeneric Edit60
TOP49: Transportation Management
109F49141Packing List Workfile34PWSEQSequence NumberNumericGeneric Edit60
110F49191Document Definition5DSSEQSequence NumberNumericGeneric Edit60
111F49490Document Selection9TQSEQSequence NumberNumericGeneric Edit60
112F49591Document Print - Batch Selection6DBSEQSequence NumberNumericGeneric Edit60
113F49592Document Print Batch Document Header2DHSEQSequence NumberNumericGeneric Edit60
114F4960Load Header18TMSEQSequence NumberNumericGeneric Edit60
TOP51X: In-Memory Project Management
115F51X100Project Advisor Account RangeTable4ARSEQSequence NumberNumericGeneric Edit60
TOP52: Contract Billing
116F5216Milestone/Progress Billing Information27A6SEQSequence NumberNumericGeneric Edit60
TOP52G: Proj & Gov Contract Accounting
117F52G05ACRN Detail Table7ADSEQSequence NumberNumericGeneric Edit60
118F52G05HACRN History Table14AHSEQSequence NumberNumericGeneric Edit60
119F52G20WLabor Category Work File2LWSEQSequence NumberNumericGeneric Edit60
TOP70: Multi-National Products
120F702018Taxes by Sales Order Line - COMM - 425TASEQSequence NumberNumericGeneric Edit60
121F702033Sales Document Line Tag File - COMM - 424D1SEQSequence NumberNumericGeneric Edit60
TOP74: EMEA Localization
122F7420033Sales Document Line (Print Info) - COMM - 424PISEQSequence NumberNumericGeneric Edit60
123F7420034Price Adjustment (Print Info) - COMM - 424PISEQSequence NumberNumericGeneric Edit60
124F7420035Item Cross-Reference (Print Info) - COMM - 424PISEQSequence NumberNumericGeneric Edit60
125F7430032Legal Document Detail (Print Info) - COMM - 03B4PISEQSequence NumberNumericGeneric Edit60
126F7430033A/R Document Line (Print Info) - COMM - 03B4PISEQSequence NumberNumericGeneric Edit60
127F7430034Legal Document Attachment (Print Info) - COMM - 03B4PISEQSequence NumberNumericGeneric Edit60
128F7430035Taxes by Legal Document Line - COMM - 03B4PISEQSequence NumberNumericGeneric Edit60
129F743035Display Taxes by Legal Document Line - COMM - 03B4DTSEQSequence NumberNumericGeneric Edit60
130F749111Account Group Detail- EMEA - 742AGSEQSequence NumberNumericGeneric Edit60
TOP74L: Portugal
131F74L3035Tax Details by Legal Document - POR - 74L4TDSEQSequence NumberNumericGeneric Edit60
TOP74P: Poland
132F74P3B24Processed Documents in Finance Charge Processing - POL - 03B5PDSEQSequence NumberNumericGeneric Edit60
TOP74R: Russia
133F74R0007Legal Document Footer Signature Setup - RUS - 00 - 74R7FSSEQSequence NumberNumericGeneric Edit60
134F74R3033Line additional info (Print Info) - RUS - 03B4DFSEQSequence NumberNumericGeneric Edit60
135F74R9011Correspondence Rules - RUS -09 - 74R8CRSEQSequence NumberNumericGeneric Edit60
TOP74U: United Kingdom Localizations
136F74U03BTLease Master Alternative UOM Tag File - 1511PFSEQSequence NumberNumericGeneric Edit60
TOP75I: India
137F75I035Display Taxes by Legal Document Line Tag File - IND - 03B4DGSEQSequence NumberNumericGeneric Edit60
TOP76A: Argentina
138F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A6DLSEQSequence NumberNumericGeneric Edit60
139F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A6DLSEQSequence NumberNumericGeneric Edit60
140F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A6DLSEQSequence NumberNumericGeneric Edit60
141F76AUI22WF - Legal Reports Errors - ARG - 03B - 76A6WFSEQSequence NumberNumericGeneric Edit60
142F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A3WFSEQSequence NumberNumericGeneric Edit60
TOP76B: Brazil
143F7602BFiscal Book Next Number Control - Brazil - 095NJSEQSequence NumberNumericGeneric Edit60
144F76121BNota Fiscal Print Message Header - Brazil - 426FZSEQSequence NumberNumericGeneric Edit60
145F7612BNota Fiscal Print Message - BRA - 425FYSEQSequence NumberNumericGeneric Edit60
146F76B02TENFe Header History - 76B5FHSEQSequence NumberNumericGeneric Edit60
TOP76C: Colombia
147F76C0F11DIAN Output Format Detail - COL - 003FDSEQSequence NumberNumericGeneric Edit60
148F76C4F01DIAN Formats File by Payment - COL - 0412FPSEQSequence NumberNumericGeneric Edit60
149F76C4F02DIAN Formats File by Invoice - COL - 0415FISEQSequence NumberNumericGeneric Edit60
150F76C9F02DIAN Formats by AccountID - COL - 0933DFSEQSequence NumberNumericGeneric Edit60
151F76C9F11DIAN Formats File by Account Id - COL - 0916DFSEQSequence NumberNumericGeneric Edit60
TOP76H: Chile
152F76H3B32Legal Document Detail (Print Info) - CHI - 03B - 76H4PISEQSequence NumberNumericGeneric Edit60
153F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H4PISEQSequence NumberNumericGeneric Edit60
154F76H3B35Price Adjustment (Print Info) - CHI - 03B - 76H4PISEQSequence NumberNumericGeneric Edit60
155F76H3B36Legal Document Attachment (Print Info) - CHI - 03B - 76H4PISEQSequence NumberNumericGeneric Edit60
156F76H3B37A/R Document Line (Print Info) - CHI - 03B - 76H4PISEQSequence NumberNumericGeneric Edit60
157F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H4PISEQSequence NumberNumericGeneric Edit60
158F76H3B40A/P Document Line (Print Info) - CHI - 044PISEQSequence NumberNumericGeneric Edit60
TOP76P: Peru
159F76P3B70PDT Sales Operations with Third - PER - 03B - 76P1PDSEQSequence NumberNumericGeneric Edit60
TOP76V: Venezuela
160F76V305A/R Fiscal Operation Codification - VEN - 03B3ROSEQSequence NumberNumericGeneric Edit60
161F76V405A/P Fiscal Operation Codification - VEN - 043POSEQSequence NumberNumericGeneric Edit60
TOP77: Payroll (Canadian)
162F77101Canadian Year-End Print4JASEQSequence NumberNumericGeneric Edit60
TOP89: Conversion Programs
163F98950TTC Temporary table for AQ, CAFE19WOSEQSequence NumberNumericGeneric Edit60
164F99302Processing Options Text Table9POSEQSequence NumberNumericGeneric Edit60
165F993022Processing Options Error Table9POSEQSequence NumberNumericGeneric Edit60
166F993023Translated Processing Options Text Table9POSEQSequence NumberNumericGeneric Edit60
TOP90CA: CRM Foundation
167F90CA23AWizard Process Flow Settings3WPSEQSequence NumberNumericGeneric Edit60
TOP98: Technical Tools
168F98BLOBDB2 Blob Support3KSSEQSequence NumberNumericGeneric Edit60
TOPH79: Translation Tools
169F989501User Override Language Translation Table8LSSEQSequence NumberNumericGeneric Edit60
TOPH91: Design Tools
170F91410Report Director Templates Sequence Items2DSSEQSequence NumberNumericGeneric Edit60
171F91430Smart Field Template Criteria4SCSEQSequence NumberNumericGeneric Edit60
TOPH92: Interactive Engine/OL
172F98950User Overrides Table9UOSEQSequence NumberNumericGeneric Edit60
TOPH95: Object and Environment Tech
173F952420OneCenter Watchlists Detail18WLSEQSequence NumberNumericGeneric Edit60
174F952430Advance Query9AQSEQSequence NumberNumericGeneric Edit60
175F952440Grid Formats Detail7GFSEQSequence NumberNumericGeneric Edit60
176F952450CafeOne Layout Table11WOSEQSequence NumberNumericGeneric Edit60
177F95401Application Failure Recovery Detail3ADSEQSequence NumberNumericGeneric Edit60
178F95410Application Failure Administration2TOSEQSequence NumberNumericGeneric Edit60
179F98881CFDSS Specification Logging File5CFSEQSequence NumberNumericGeneric Edit60
180F98881CUSpecification Logging File5SMSEQSequence NumberNumericGeneric Edit60
181F98950DUser Overrides Language Table9LOSEQSequence NumberNumericGeneric Edit60
TOPH96I: EnterpriseOne Installs
182F99410OneWorld System Control File1OCSEQSequence NumberNumericGeneric Edit60
TOPH96U: Upgrade
183F9887Install Package Build History4IPSEQSequence NumberNumericGeneric Edit60
184F98881Specification Merge Logging File6SMSEQSequence NumberNumericGeneric Edit60
185F98892Package Deployment Scheduling10MTSEQSequence NumberNumericGeneric Edit60
TOPH98: Internet
186F986150Server Transfer Package Contents2SPSEQSequence NumberNumericGeneric Edit60
TOPH99: Product Version Control
187F0093Library List Control3LLSEQSequence NumberNumericGeneric Edit60