JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

42 COLUMNS | 1 INDEXES | Print definition?910 | 74U | F74U0201 TABLE

74U: United Kingdom Localizations
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F74U0201P1421Property Company Constants - 15Files74: EMEA LocalizationBusiness Data
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT P1CO, P174ULYR, P174UNYC, P174UFMOD, P174UFMID, P174UCCM, P174UPNF, P174UVATOE, P174UVOO, P174UMTC, P174UTCOO, P174UTAOO, P174URBC, P174UCBC, P174UUA, P174UAIDC, P174UAJM, P174UWA, P174USSBU, P174UPBD, P174UPW1, P174UPW2, P174UPW3, P174UPW4, P174UPW5, P174UPW6, P174UPW7, P174UPW8, P174UPW9, P174UPW10, P174UPW11, P174UPW12, P174UNNP, P1URCD, P1URDT, P1URAB, P1URRF, P1USER, P1PID, P1UPMJ, P1UPMT, P1JOBN FROM F74U0201

TOP910 | 74U | F74U0201 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1P1COCompanyStringGeneric Edit50 Allow NULL? 
2P174ULYRLeap Year RecognitionCharacterGeneric Edit10 Allow NULL? 
3P174UNYCNumber Years to Create Payment ProfileNumericGeneric Edit30 Allow NULL? 
4P174UFMODFree Move Out DayCharacterGeneric Edit10 Allow NULL? 
5P174UFMIDFree Move In DayCharacterGeneric Edit10 Allow NULL? 
6P174UCCMCredit Calculation MethodStringGeneric Edit30 Allow NULL? 
7P174UPNFProperty Number From ( Purchasing )StringUDC (74U PN)30 Allow NULL? 
8P174UVATOEVAT Override Error MessageCharacterGeneric Edit10 Allow NULL? 
9P174UVOOApply Tax Codes To InterestStringGeneric Edit30 Allow NULL? 
10P174UMTCMandatory Tax CodeCharacterGeneric Edit10 Allow NULL? 
11P174UTCOOTax Exempt CodeStringUDC (00 EX)20 Allow NULL? 
12P174UTAOOTax Exempt AreaStringUDC100 Allow NULL? 
13P174URBCResidential Billing CodeStringGeneric Edit100 Allow NULL? 
14P174UCBCCommercial Billing CodeStringGeneric Edit100 Allow NULL? 
15P174UUAUnit AccountingStringGeneric Edit30 Allow NULL? 
16P174UAIDCAllow Interest Date ChangeCharacterGeneric Edit10 Allow NULL? 
17P174UAJMAccounting Journal MethodStringUDC (74U AJ)20 Allow NULL? 
18P174UWAWeekly AccountingCharacterGeneric Edit10 Allow NULL? 
19P174USSBUShow Security BUCharacterGeneric Edit10 Allow NULL? 
20P174UPBDPayment Balance DistributionCharacterGeneric Edit10 Allow NULL? 
21P174UPW1Period Weeks 1CharacterUDC (74U PW)10 Allow NULL? 
22P174UPW2Period Weeks 2CharacterUDC (74U PW)10 Allow NULL? 
23P174UPW3Period Weeks 3CharacterUDC (74U PW)10 Allow NULL? 
24P174UPW4Period Weeks 4CharacterUDC (74U PW)10 Allow NULL? 
25P174UPW5Period Weeks 5CharacterUDC (74U PW)10 Allow NULL? 
26P174UPW6Period Weeks 6CharacterUDC (74U PW)10 Allow NULL? 
27P174UPW7Period Weeks 7CharacterUDC (74U PW)10 Allow NULL? 
28P174UPW8Period Weeks 8CharacterUDC (74U PW)10 Allow NULL? 
29P174UPW9Period Weeks 9CharacterUDC (74U PW)10 Allow NULL? 
30P174UPW10Period Weeks 10CharacterUDC (74U PW)10 Allow NULL? 
31P174UPW11Period Weeks 11CharacterUDC (74U PW)10 Allow NULL? 
32P174UPW12Period Weeks 12CharacterUDC (74U PW)10 Allow NULL? 
33P174UNNPNumber Of Accounting WeeksNumericGeneric Edit20 Allow NULL? 
34P1URCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
35P1URDTUser Reserved DateDateGeneric Edit60
36P1URABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
37P1URRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
38P1USERUser IDStringGeneric Edit100 Allow NULL? 
39P1PIDProgram IDStringGeneric Edit100 Allow NULL? 
40P1UPMJDate - UpdatedDateGeneric Edit60
41P1UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
42P1JOBNWork Station IDStringGeneric Edit100 Allow NULL? 

TOP910 | 74U | F74U0201 INDEXES

NumberDescription
1Company (Primary/Unique)
ElementAliasDescriptionSequence
1COCompanyAscending