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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
74U: United Kingdom Localizations
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F74U0425SF1044SPC - Certificate Master - UK - 43Master Files74U: United Kingdom Localizations
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 SFUKCENM, SFUKCEDT, SF74UACR, SFDOCO, SFDCTO, SFKCOO, SFSFXO, SF74UCLN, SFMATC, SFLNID, SF74USPCS, SFUKAPNM, SF74UALN, SFAN8, SFCO, SFMCU, SFOBJ, SFSUB, SFSBL, SFSBLT, SFGLC, SFDGL, SFDDJ, SFDSVJ, SFCTRY, SFFY, SFPN, SFDOC, SFICU, SFICUT, SFDOCZ, SFDCTI, SFKCOI, SFSFX, SFTXA1, SFEXR1, SFPTC, SFAG, SF74UNT, SFUKCEAM, SFATXA, SF74UCVAT, SFADSC, SFUKCEQT, SFUKCEPE, SF74UCG, SF74UCN, SFUKCECA, SF74UCCVAT, SFUKCECQ, SFUKCECP, SFCRRM, SFCRCD, SFCRCF, SFCRR, SFACR, SF74UFNT, SFUKCEFA, SFCTXA, SF74UFVAT, SFCDS, SF74UFCG, SF74UFCN, SFUKCEFC, SF74UFCVAT, SF74UPRET, SFRTNG, SF74UCR, SFFTNG, SF74UFCR, SF74UMCDR, SF74UMCDA, SF74UMCDCA, SF74UFMCDA, SF74UFMCDC, SFRMK, SFUKCEPD, SF74UARP, SF74UARR, SF74UCCC1, SF74UCCC2, SF74UCCC3, SF74UCCC4, SF74UCCC5, SFURAT, SFURCD, SFURDT, SFURAB, SFURRF, SFPID, SFJOBN, SFUSER, SFUPMJ, SFUPMT, SFOMCU, SFANI, SFAID, SFNLIN, SF74UPLAD, SF74UPMAD, SF74UPLAF, SF74UPMAF, SF74ULMSP, SF74UMLMS FROM F74U0425

TOP920 | 74U | F74U0425 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SFUKCENMCertificate NumberNumericGeneric Edit60 Allow NULL? 
2SFUKCEDTCertificate DateDateGeneric Edit60
3SF74UACRAlternate Certificate ReferenceStringGeneric Edit150 Allow NULL? 
4SFDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
5SFDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
6SFKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
7SFSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
8SF74UCLNCertificate Line NumberNumericGeneric Edit63 Allow NULL? 
9SFMATCType - Match Record TypeCharacterGeneric Edit10 Allow NULL? 
10SFLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
11SF74USPCSSPC StatusStringUDC (74U SS)30 Allow NULL? 
12SFUKAPNMApplication NumberNumericGeneric Edit60 Allow NULL? 
13SF74UALNApplication Line NumberNumericGeneric Edit63 Allow NULL? 
14SFAN8Address NumberNumericGeneric Edit80 Allow NULL? 
15SFCOCompanyStringGeneric Edit50 Allow NULL? 
16SFMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
17SFOBJObject AccountStringGeneric Edit60 Allow NULL? 
18SFSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
19SFSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
20SFSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
21SFGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
22SFDGLDate - For G/L (and Voucher)DateGeneric Edit60
23SFDDJDate - Net DueDateGeneric Edit60
24SFDSVJDate - Service/TaxDateGeneric Edit60
25SFCTRYCenturyNumericGeneric Edit20 Allow NULL? 
26SFFYFiscal YearNumericGeneric Edit20 Allow NULL? 
27SFPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
28SFDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
29SFICUBatch NumberNumericGeneric Edit80 Allow NULL? 
30SFICUTBatch TypeStringUDC (98 IT)20 Allow NULL? 
31SFDOCZDocument (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
32SFDCTIDocument Type - Invoice OnlyStringUDC (00 DI)20 Allow NULL? 
33SFKCOIDocument Company (Invoice)StringGeneric Edit50 Allow NULL? 
34SFSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
35SFTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
36SFEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
37SFPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
38SFAGAmount - GrossNumericGeneric Edit152 Allow NULL? 
39SF74UNTNet AmountNumericGeneric Edit152 Allow NULL? 
40SFUKCEAMCertificate AmountNumericGeneric Edit152 Allow NULL? 
41SFATXAAmount - TaxableNumericGeneric Edit152 Allow NULL? 
42SF74UCVATCertified VATNumericGeneric Edit152 Allow NULL? 
43SFADSCDiscount AvailableNumericGeneric Edit152 Allow NULL? 
44SFUKCEQTCertificate QuantityNumericGeneric Edit150 Allow NULL? 
45SFUKCEPECertificate PercentageNumericGeneric Edit52 Allow NULL? 
46SF74UCGCumulative Gross AmountNumericGeneric Edit152 Allow NULL? 
47SF74UCNCumulative Net AmountNumericGeneric Edit152 Allow NULL? 
48SFUKCECACertificate Cumulative AmountNumericGeneric Edit152 Allow NULL? 
49SF74UCCVATCumulative Certified VATNumericGeneric Edit152 Allow NULL? 
50SFUKCECQCertificate Cumulative QuantityNumericGeneric Edit150 Allow NULL? 
51SFUKCECPCertificate Cumulative PercentageNumericGeneric Edit52 Allow NULL? 
52SFCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
53SFCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
54SFCRCFCurrency Code - OriginStringGeneric Edit30 Allow NULL? 
55SFCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
56SFACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
57SF74UFNTCurrency Net AmountNumericGeneric Edit152 Allow NULL? 
58SFUKCEFACertificate Foreign Currency ( Period )NumericGeneric Edit152 Allow NULL? 
59SFCTXAAmount - Foreign TaxableNumericGeneric Edit152 Allow NULL? 
60SF74UFVATForeign Certified VATNumericGeneric Edit152 Allow NULL? 
61SFCDSAmount - Foreign Discount AvailableNumericGeneric Edit152 Allow NULL? 
62SF74UFCGCurrency Cumulative Gross AmountNumericGeneric Edit152 Allow NULL? 
63SF74UFCNCurrency Cumulative Net AmountNumericGeneric Edit152 Allow NULL? 
64SFUKCEFCCertificate Foreign Currency CumulativeNumericGeneric Edit152 Allow NULL? 
65SF74UFCVATForeign Cumulative Certified VATNumericGeneric Edit152 Allow NULL? 
66SF74UPRETRetention PercentageNumericGeneric Edit52 Allow NULL? 
67SFRTNGRetainageNumericGeneric Edit152 Allow NULL? 
68SF74UCRCumulative RetentionNumericGeneric Edit152 Allow NULL? 
69SFFTNGRetainage - ForeignNumericGeneric Edit152 Allow NULL? 
70SF74UFCRForeign Cumulative RetentionNumericGeneric Edit152 Allow NULL? 
71SF74UMCDRMCD RateNumericGeneric Edit52 Allow NULL? 
72SF74UMCDAMCD AmountNumericGeneric Edit152 Allow NULL? 
73SF74UMCDCAMCD Amount CumulativeNumericGeneric Edit152 Allow NULL? 
74SF74UFMCDAMCD Foreign AmountNumericGeneric Edit152 Allow NULL? 
75SF74UFMCDCForeign Cumulative MCD AmountNumericGeneric Edit152 Allow NULL? 
76SFRMKName - RemarkStringGeneric Edit300 Allow NULL? 
77SFUKCEPDCertificate Print DateDateGeneric Edit60
78SF74UARPAuthenticated Receipt Print DateDateGeneric Edit60
79SF74UARRDate Authenticated Receipt ReturnedDateGeneric Edit60
80SF74UCCC1Certificate Catagory Code 1StringGeneric Edit30 Allow NULL? 
81SF74UCCC2Certificate Catagory Code 2StringGeneric Edit30 Allow NULL? 
82SF74UCCC3Certificate Catagory Code 3StringGeneric Edit100 Allow NULL? 
83SF74UCCC4Certificate Catagory Code 4StringGeneric Edit100 Allow NULL? 
84SF74UCCC5Certificate Catagory Code 5NumericGeneric Edit152 Allow NULL? 
85SFURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
86SFURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
87SFURDTUser Reserved DateDateGeneric Edit60
88SFURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
89SFURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
90SFPIDProgram IDStringGeneric Edit100 Allow NULL? 
91SFJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
92SFUSERUser IDStringGeneric Edit100 Allow NULL? 
93SFUPMJDate - UpdatedDateGeneric Edit60
94SFUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
95SFOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
96SFANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
97SFAIDAccount IDStringGeneric Edit80 Allow NULL? 
98SFNLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
99SF74UPLADSPC Period Labour Amount DomesticNumericGeneric Edit152 Allow NULL? 
100SF74UPMADSPC Period Materials Amount DomesticNumericGeneric Edit152 Allow NULL? 
101SF74UPLAFSPC Period Labour Amount ForeignNumericGeneric Edit152 Allow NULL? 
102SF74UPMAFSPC Period Materials Amount ForeignNumericGeneric Edit152 Allow NULL? 
103SF74ULMSPLabour Materials Split PercentageNumericGeneric Edit52 Allow NULL? 
104SF74UMLMSSPC Mandatory Labour Materials SplitCharacterGeneric Edit10 Allow NULL? 

TOP920 | 74U | F74U0425 INDEXES

NumberDescription
1Cert No Ord No A+ (Primary/Unique)
ElementAliasDescriptionSequence
1UKCENMCertificate NumberAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
5SFXOOrder SuffixAscending
674UCLNCertificate Line NumberAscending
7MATCType - Match Record TypeAscending
3Doc No Co No A+
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SFXOOrder SuffixAscending
4Co No Doc No A+
ElementAliasDescriptionSequence
1KCOOOrder Company (Order Number)Ascending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4UKCENMCertificate NumberAscending
574UCLNCertificate Line NumberAscending
5Cert No Ord No B+
ElementAliasDescriptionSequence
1UKCENMCertificate NumberAscending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4KCOOOrder Company (Order Number)Ascending
5SFXOOrder SuffixAscending
674UCLNCertificate Line NumberAscending