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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
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
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

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