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
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

104 columns | Print definition?920 | ADDS | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Business Unit Master9MCADDSStateStringUDC30
2F0006SDate Effective Business Unit Master11MCADDSStateStringUDC30
3F0006Z1Cost Center Unedited Transaction Table22SZADDSStateStringUDC30
4F0006Z2Business Unit Master Z File22SZADDSStateStringUDC30
5F004201Prepayment Transaction Table27PTADDSStateStringUDC30
TOP01: Address Book
6F0101Z2Address Book - Interoperability94SZADDSStateStringUDC30
7F0116Address by Date11ALADDSStateStringUDC30
8F01161Alternate Address12WLADDSStateStringUDC30
9F01161DWCustomer Alternate Address Export13DWADDSStateStringUDC30
10F01161Z1Batch - Alternative Address25LBADDSStateStringUDC30
11F0117Postal Codes2A8ADDSStateStringUDC30
TOP05: Time Accounting and HRM Base
12F054101Employee Personal Profile Information History Table19EHADDSStateStringUDC30
13F054101WEmployee Personal Profile Information Work Table19EPADDSStateStringUDC30
14F054111Employee Emergency Contact History Table10CHADDSStateStringUDC30
15F054111WEmployee Emergency Contact Work Table10ECADDSStateStringUDC30
TOP05A: PeopleSoft HR & PR Foundation
16F05003Verification of Employment Data16EVADDSStateStringUDC30
17F060116ZUnedited Quick Hire Transaction File74SZADDSStateStringUDC30
TOP07: Payroll
18F074001New Hire Reporting Workfile - OneWorld Only16NHADDSStateStringUDC30
19F07880SUI Magnetic Media Workfile12YWADDSStateStringUDC30
20F8907422New Hire Detail File - Massachusetts (22)7MAADDSStateStringUDC30
21F8907427New Hire Detail File - Montana (27)37MTADDSStateStringUDC30
22F8907428New Hire Detail File - Nebraska(28)14NEADDSStateStringUDC30
23F8907444New Hire Detail File Transfer - Texas (44)12TXADDSStateStringUDC30
TOP08: Human Resources
24F083305Mail Merge Header/Detail13MMADDSStateStringUDC30
TOP08AD: ADP Integration
25F05137ADP Employee Master Information58ADADDSStateStringUDC30
TOP08B: Benefits Administration
26F0833WFBenefit Statement Work file10WFADDSStateStringUDC30
TOP12: Fixed Assets
27F1201Asset Master File62FAADDSStateStringUDC30
28F1201PAsset Master Purge Table62FAADDSStateStringUDC30
29F1201Z1Unedited Asset Master Transactions74FAADDSStateStringUDC30
TOP13: Plant/Equipment Management
30F1206Equipment License Master3FHADDSStateStringUDC30
31F1206PEquipment License Master Purge Table3FHADDSStateStringUDC30
TOP13C: Condition-Base Maintenance
32F1310Condition-Based Alerts52CAADDSStateStringUDC30
33F1310Z1Unedited Condition-Based Alerts66CBADDSStateStringUDC30
TOP15: Real Estate Management
34F1507Unit Master19NHADDSStateStringUDC30
TOP17C: Call Management
35F17311Equipment Master Location Details19LDADDSStateStringUDC30
TOP31B: Blend Management
36F31B01Winery Master7WIADDSStateStringUDC30
TOP40: Inventory/OP Base
37F4006Order Address Information13OAADDSStateStringUDC30
38F4006ZBatch Order Receiver - Order Address Information13OYADDSStateStringUDC30
39F40333Preference Profile - Carrier17CAADDSStateStringUDC30
40F40334Preference Profile - Mode of Transport16MTADDSStateStringUDC30
41F4215Shipment Header36XHADDSStateStringUDC30
TOP40G: Grower Management
42F40G03Grower Harvest32GHADDSStateStringUDC30
43F40G0300Grower Harvest Update Profile48HUADDSStateStringUDC30
TOP44H: Homebuilder Management
44F44H201Lot Master5LMADDSStateStringUDC30
45F44H201HLot Master History6LMADDSStateStringUDC30
46F44H201ZHB Lot Master Unedited Transaction File18SZADDSStateStringUDC30
47F44H501HLot Sales History171LSADDSStateStringUDC30
TOP47: Electronic Commerce
48F47037EDI Shipping Notice Detail - Outbound211SZADDSStateStringUDC30
49F470561EDI Payment Order Bank N & A - Outbound12D2ADDSStateStringUDC30
50F470561WEDI Payment Order Bank N & A - Work11D2ADDSStateStringUDC30
51F470562EDI Payment Order Vendor N & A - Outbound30D4ADDSStateStringUDC30
52F470562WEDI Payment Order Vendor N & A - Work30D4ADDSStateStringUDC30
53F470563EDI Payment Order Payee N & A - Outbound30D5ADDSStateStringUDC30
54F470563WEDI Payment Order Payee N & A - Work30D5ADDSStateStringUDC30
55F4706EDI Order Address Information23ZAADDSStateStringUDC30
56F47081EDI Price Sales Catalog Header - Inbound26FVADDSStateStringUDC30
TOP49: Transportation Management
57F4950Routing Entries10RTADDSStateStringUDC30
58F4951Carrier Zone Definitions6ZNADDSStateStringUDC30
59F4960Load Header10TMADDSStateStringUDC30
60F4981Freight Audit History55FHADDSStateStringUDC30
61F49T50Order Release Location Staging19LOADDSStateStringUDC30
62F49T80Locations Staging Table15LCADDSStateStringUDC30
TOP51X: In-Memory Project Management
63F51X10Project Advisor Console Worktable63EXADDSStateStringUDC30
TOP54HS: Health & Safety Incident Mgt
64F54HS01Incident Master29S1ADDSStateStringUDC30
65F54HS01MIncident Master Change History32I1ADDSStateStringUDC30
66F54HS02Incident People44S2ADDSStateStringUDC30
67F54HS02MIncident People Change History47I2ADDSStateStringUDC30
68F54HS03Incident Equipment19S4ADDSStateStringUDC30
69F54HS03MIncident Equipment Change History22I4ADDSStateStringUDC30
TOP74: EMEA Localization
70F74030Bank ID - Italy11BAADDSStateStringUDC30
71F7430031Legal Document Address (Print Info) - COMM - 03B14PIADDSStateStringUDC30
TOP74Y: Italy
72F74YUI01Italy Legal Company WF - ITA - 74Y12LCADDSStateStringUDC30
TOP75A: Australia
73F75A0010Australian Employee Termination Details60A0ADDSStateStringUDC30
74F75A0220Payment Summary Workfile11PSADDSStateStringUDC30
TOP75I: India
75F75I100QTDS Form 26Q - WorkFile (Quarterly)21EFADDSStateStringUDC30
76F75I100WTDS Form 26 - WorkFile21EFADDSStateStringUDC30
77F75I403Stock Transfer Details35ABADDSStateStringUDC30
78F75I403TTemp Data for F75i40335ABADDSStateStringUDC30
TOP76A: Argentina
79F76A8002SICORE RG738 Withholding Entity - ARG - 04 - 76A5V3ADDSStateStringUDC30
80F76A82A/P Payment Control Group File - ARG - 04 - 76A30C6ADDSStateStringUDC30
TOP76B: Brazil
81F76011Address Book Brazilian Tag Table - 0414AIADDSStateStringUDC30
82F76011PArchive Address Book Brazilian Tag Table - 0414PRADDSStateStringUDC30
83F7601BNota Fiscal Header - BRA - 4224FHADDSStateStringUDC30
84F7608BICMS Tax Rates - 402TBADDSStateStringUDC30
85F76101BNota Fiscal - Header (Fiscal Books) - 4225QXADDSStateStringUDC30
86F7611BNota Fiscal Detail - BRA - 4251FDADDSStateStringUDC30
87F761BAAS Fiscal file book - 0954FBADDSStateStringUDC30
88F76B0770ICMS Period Balance by State and Company2ICADDSStateStringUDC30
89F76B105GNRE Table - 427QCADDSStateStringUDC30
90F76B132GIA City Code - 421TCADDSStateStringUDC30
91F76B19IBPT Tax information -76B4TFADDSStateStringUDC30
92F76B70Physical and Legal Person Table - IN68 - 4214FJADDSStateStringUDC30
93F76B8601IN86-Work Table for Individuals and Legal Entities - 0410FJADDSStateStringUDC30
TOP76H: Chile
94F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H14PIADDSStateStringUDC30
TOP79A: Greenhouse Gas Accounting
95F79A09GHG Energy Rates26ERADDSStateStringUDC30
96F79A10GHG Rates30ERADDSStateStringUDC30
97F79A11GHG Ledger33GRADDSStateStringUDC30
98F79A11Z1GHG Ledger - Batch File51GLADDSStateStringUDC30
99F79A12GHG Ledger Audit34GRADDSStateStringUDC30
100F79A75GHG Organization Name10GOADDSStateStringUDC30
101F79AU11GHG Ledger Work Table36GRADDSStateStringUDC30
TOPH90: EnterpriseOne TOOLS
102F012504Focus Registration11FOADDSStateStringUDC30
TOPH91: Design Tools
103F9801NEWEmployee Information - New Version6AAADDSStateStringUDC30
104F9801OLDEmployee Information - Old Version5AAADDSStateStringUDC30

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 00 / S (State & Province Codes) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1  . N
2       *All States N
3       ABAlberta
4       AIArctic Islands
5       AKAlaska
6       ALAlabama
7       AMAmazonas N
8       ARArkansas
9       AUAustralia
10       AZArizona
11       BCBritish Columbia
12       CACalifornia
13       CNCanada
14       COColorado
15       CTConnecticut
16       CZCanal Zone
17       DCDistrict of Columbia
18       DEDelaware
19       DFDistrito Federal N
20       FLFlorida
21       GAGeorgia
22       HIHawaii
23       IAIowa
24       IDIdaho
25       ILIllinois
26       INIndiana
27       KSKansas
28       KYKentucky
29       LALouisiana
30       MAMassachusetts
31       MBManitoba
32       MDMaryland
33       MEMaine
34       MIMichigan
35       MNMinnesota
36       MOMissouri
37       MSMississippi
38       MTMontana
39       MXEstado de Mexico N
40       NBNew Brunswick
41       NCNorth Carolina
42       NDNorth Dakota
43       NENebraska
44       NFNewfoundland
45       NHNew Hampshire
46       NJNew Jersey
47       NLNuevo Leon N
48       NMNew Mexico
49       NSNova Scotia
50       NSWNew South Wales Y
51       NTNorthwest Territory
52       NUNunavut N
53       NVNevada
54       NYNew York
55       NZNew Zealand
56       OHOhio
57       OKOklahoma
58       ONOntario
59       OROregon
60       PAPennsylvania
61       PEPrince Edward Island
62       PRPuerto Rico
63       QCQuebec N
64       RIRhode Island
65       RJRio de Janiero N
66       RSRio Grande do Sul N
67       SASouth Australia Y
68       SCSouth Carolina
69       SDSouth Dakota
70       SKSaskatchewan
71       SPSao Paulo N
72       TASTasmania Y
73       TNTennessee
74       TXTexas
75       UTUtah
76       VAVirginia
77       VIVirgin Islands
78       VICVictoria Y
79       VTVermont
80       WAWashington
81       WIWisconsin
82       WVWest Virginia
83       WYWyoming
84       YTYukon Territory
85       ZZOther Areas