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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

48 COLUMNS | 1 INDEXES | Print definition?920 | 74U | F74U0401 TABLE

74U: United Kingdom Localizations
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F74U0401SA481SPC - Constants - UK - 43Files74U: 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 SACO, SA74USPCA, SA74UAAC, SA74UCB, SA74UFC, SA74UPOC, SA74UPLTD, SA74UPLTF, SA74UAC, SA74UALTD, SA74UALTF, SA74UCC, SA74UCLTD, SA74UCLTF, SA74USRU, SA74UARLTD, SA74UARLTF, SA74UCRLTD, SA74UCRLTF, SA74USMU, SA74UAMLTD, SA74UAMLTF, SA74UCMLTD, SA74UCMLTF, SA74UMCDR, SA74UMRV, SA74UVRB, SA74UAR, SA74UOC, SA74UAPVG, SA74URR, SA74UCE, SA74UPG, SA74UPCC1, SA74UPCC2, SA74UPCC3, SA74UPCC4, SA74UPCC5, SAURAT, SAURCD, SAURDT, SAURAB, SAURRF, SAPID, SAJOBN, SAUSER, SAUPMJ, SAUPMT FROM F74U0401

TOP920 | 74U | F74U0401 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SACOCompanyStringGeneric Edit50 Allow NULL? 
2SA74USPCASPC Activate SystemCharacterGeneric Edit10 Allow NULL? 
3SA74UAACAccounting At Application Or CertificateCharacterGeneric Edit10 Allow NULL? 
4SA74UCBCommitment BasisCharacterGeneric Edit10 Allow NULL? 
5SA74UFCForeign CommitmentsCharacterGeneric Edit10 Allow NULL? 
6SA74UPOCPurchase Order CommitmentCharacterGeneric Edit10 Allow NULL? 
7SA74UPLTDPurchase Order Ledger Type - DomesticStringUDC (09 LT)20 Allow NULL? 
8SA74UPLTFPurchase Order Ledger Type - ForeignStringUDC (09 LT)20 Allow NULL? 
9SA74UACApplicationCommitmentCharacterGeneric Edit10 Allow NULL? 
10SA74UALTDApplication Ledger Type - DomesticStringUDC (09 LT)20 Allow NULL? 
11SA74UALTFApplication Ledger Type - ForeignStringUDC (09 LT)20 Allow NULL? 
12SA74UCCCertificate CommitmentCharacterGeneric Edit10 Allow NULL? 
13SA74UCLTDCertificate Ledger Type - DomesticStringUDC (09 LT)20 Allow NULL? 
14SA74UCLTFCertificate Ledger Type - ForeignStringUDC (09 LT)20 Allow NULL? 
15SA74USRUSeparate Retention UpdateCharacterGeneric Edit10 Allow NULL? 
16SA74UARLTDAppl Retention Ledger Type - DomesticStringUDC (09 LT)20 Allow NULL? 
17SA74UARLTFAppl Retention Ledger Type - ForeignStringUDC (09 LT)20 Allow NULL? 
18SA74UCRLTDCert Retention Ledger Type - DomesticStringUDC (09 LT)20 Allow NULL? 
19SA74UCRLTFCert Retention Ledger Type - ForeignStringUDC (09 LT)20 Allow NULL? 
20SA74USMUSeparate MCD UpdateCharacterGeneric Edit10 Allow NULL? 
21SA74UAMLTDApplication MCD Ledger Type - DomesticStringUDC (09 LT)20 Allow NULL? 
22SA74UAMLTFApplication MCD Ledger Type - ForeignStringUDC (09 LT)20 Allow NULL? 
23SA74UCMLTDCertificate MCD Ledger Type - DomesticStringUDC (09 LT)20 Allow NULL? 
24SA74UCMLTFCertificate MCD Ledger Type - ForeignStringUDC (09 LT)20 Allow NULL? 
25SA74UMCDRMCD RateNumericGeneric Edit52 Allow NULL? 
26SA74UMRVOrder of MCD Retention and VAT CalcCharacterUDC (74U OC)10 Allow NULL? 
27SA74UVRBVAT on A Receipts BasisCharacterGeneric Edit10 Allow NULL? 
28SA74UARApplication RequiredCharacterGeneric Edit10 Allow NULL? 
29SA74UOCOver CertificationCharacterGeneric Edit10 Allow NULL? 
30SA74UAPVGAP Voucher GeneratedStringUDC (74U SS)30 Allow NULL? 
31SA74URRReverse ReceiptStringUDC (74U SS)30 Allow NULL? 
32SA74UCECertificate EnteredStringUDC (74U SS)30 Allow NULL? 
33SA74UPGPayment GeneratedStringUDC (74U SS)30 Allow NULL? 
34SA74UPCC1MCD/RetentionLvlStringGeneric Edit30 Allow NULL? 
35SA74UPCC2RetentionCalcTypeStringGeneric Edit30 Allow NULL? 
36SA74UPCC3Category Code 3StringGeneric Edit100 Allow NULL? 
37SA74UPCC4Category Code 4StringGeneric Edit100 Allow NULL? 
38SA74UPCC5Category Code 5NumericGeneric Edit152 Allow NULL? 
39SAURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
40SAURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
41SAURDTUser Reserved DateDateGeneric Edit60
42SAURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
43SAURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
44SAPIDProgram IDStringGeneric Edit100 Allow NULL? 
45SAJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
46SAUSERUser IDStringGeneric Edit100 Allow NULL? 
47SAUPMJDate - UpdatedDateGeneric Edit60
48SAUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP920 | 74U | F74U0401 INDEXES

NumberDescription
1Company (Primary/Unique)
ElementAliasDescriptionSequence
1COCompanyAscending