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

50 COLUMNS | 8 INDEXES | Print definition?910 | 76C | F76C575 TABLE

76C: Colombia
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F76C575Q1508Work File Magnetic Media - COL - 04Transaction Files76C: Colombia
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 Q1ICU, Q1ICUT, Q1CTRY, Q1FY, Q1CO, Q1LT, Q1DCT, Q1DOC, Q1SFX, Q1VINV, Q1AN8, Q1PN, Q1DGJ, Q1DSVJ, Q1JELN, Q1MCU, Q1OBJ, Q1SUB, Q1SBL, Q1SBLT, Q1C76JCN, Q1C76JCD, Q1C76JCB, Q1C76JCI, Q1C76RT, Q1C76JCS, Q1C76JCA, Q1ALT6, Q1TAXC, Q1C76TPF, Q1C76PRF, Q1C76FT1, Q1C76FT2, Q1C76NOE, Q1CBNK, Q1C76MPO, Q1C76CN1, Q1MATH10, Q1USER, Q1PID, Q1JOBN, Q1UPMJ, Q1C76DIR, Q1COGR, Q1CAEC, Q1ODOC, Q1ODCT, Q1TXA1, Q1EXR1, Q1UPMT FROM F76C575

TOP910 | 76C | F76C575 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1Q1ICUBatch NumberNumericGeneric Edit80 Allow NULL? 
2Q1ICUTBatch TypeStringUDC (98 IT)20 Allow NULL? 
3Q1CTRYCenturyNumericGeneric Edit20 Allow NULL? 
4Q1FYFiscal YearNumericGeneric Edit20 Allow NULL? 
5Q1COCompanyStringGeneric Edit50 Allow NULL? 
6Q1LTLedger TypesStringUDC (09 LT)20 Allow NULL? 
7Q1DCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
8Q1DOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
9Q1SFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
10Q1VINVSupplier Invoice NumberStringGeneric Edit250 Allow NULL? 
11Q1AN8Address NumberNumericUDC80 Allow NULL? 
12Q1PNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
13Q1DGJDate - For G/L (and Voucher) - JulianDateGeneric Edit60
14Q1DSVJDate - Service/TaxDateGeneric Edit60
15Q1JELNJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
16Q1MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
17Q1OBJObject AccountStringGeneric Edit60 Allow NULL? 
18Q1SUBSubsidiaryStringGeneric Edit80 Allow NULL? 
19Q1SBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
20Q1SBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
21Q1C76JCNTributary Identification NumberNumericGeneric Edit110 Allow NULL? 
22Q1C76JCDCheck DigitCharacterGeneric Edit10 Allow NULL? 
23Q1C76JCBFirst Informed ValueNumericGeneric Edit150 Allow NULL? 
24Q1C76JCISecond Informed ValueNumericGeneric Edit150 Allow NULL? 
25Q1C76RTTributary CodeStringGeneric Edit30 Allow NULL? 
26Q1C76JCSTributary Sub CodeStringGeneric Edit30 Allow NULL? 
27Q1C76JCATrade NameStringGeneric Edit600 Allow NULL? 
28Q1ALT6G/L Posting Code - Cash Basis AcctCharacterGeneric Edit10 Allow NULL? 
29Q1TAXCPerson/Corporation CodeCharacterUDC (H00 TA)10 Allow NULL? 
30Q1C76TPFInvoicing TypeNumericGeneric Edit20 Allow NULL? 
31Q1C76PRFInvoice PrefixStringGeneric Edit90 Allow NULL? 
32Q1C76FT1Initial Invoice RangeNumericGeneric Edit150 Allow NULL? 
33Q1C76FT2Final Invoice RangeNumericGeneric Edit150 Allow NULL? 
34Q1C76NOEEstablishment NameStringGeneric Edit150 Allow NULL? 
35Q1CBNKBank Account Number - CustomerStringGeneric Edit200 Allow NULL? 
36Q1C76MPODepartament - Municipio CodeNumericGeneric Edit50 Allow NULL? 
37Q1C76CN1Nit Control CompanyNumericGeneric Edit150 Allow NULL? 
38Q1MATH10Math Numeric 10NumericGeneric Edit150 Allow NULL? 
39Q1USERUser IDStringGeneric Edit100 Allow NULL? 
40Q1PIDProgram IDStringGeneric Edit100 Allow NULL? 
41Q1JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
42Q1UPMJDate - UpdatedDateGeneric Edit60
43Q1C76DIRInformant DirectionStringGeneric Edit400 Allow NULL? 
44Q1COGRAgrupation CodeStringGeneric Edit20 Allow NULL? 
45Q1CAECEconomy ActivityNumericGeneric Edit40 Allow NULL? 
46Q1ODOCDocument - OriginalNumericGeneric Edit80 Allow NULL? 
47Q1ODCTDocument Type - OriginalStringUDC (00 DT)20 Allow NULL? 
48Q1TXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
49Q1EXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
50Q1UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP910 | 76C | F76C575 INDEXES

NumberDescription
1L1 (Primary/Unique)
ElementAliasDescriptionSequence
1COCompanyAscending
2ICUTBatch TypeAscending
3ICUBatch NumberAscending
4JELNJournal Entry Line NumberAscending
5DCTDocument TypeAscending
6DOCDocument (Voucher Invoice etc.)Ascending
7DGJDate - For G/L (and Voucher) - JulianAscending
8C76RTTributary CodeAscending
9C76JCSTributary Sub CodeAscending
2L2
ElementAliasDescriptionSequence
1COCompanyAscending
2C76JCNTributary Identification NumberAscending
3DCTDocument TypeAscending
4DOCDocument (Voucher Invoice etc.)Ascending
5JELNJournal Entry Line NumberAscending
3L3
ElementAliasDescriptionSequence
1COCompanyAscending
2C76JCNTributary Identification NumberAscending
3COGRAgrupation CodeAscending
4C76RTTributary CodeAscending
5C76JCSTributary Sub CodeAscending
4L4
ElementAliasDescriptionSequence
1COGRAgrupation CodeAscending
2C76JCNTributary Identification NumberAscending
6L5
ElementAliasDescriptionSequence
1OBJObject AccountAscending
2SUBSubsidiaryAscending
3ICUTBatch TypeAscending
4DCTDocument TypeAscending
7L6
ElementAliasDescriptionSequence
1ICUBatch NumberAscending
2ICUTBatch TypeAscending
3COCompanyAscending
4DCTDocument TypeAscending
5DOCDocument (Voucher Invoice etc.)Ascending
6DGJDate - For G/L (and Voucher) - JulianAscending
7JELNJournal Entry Line NumberAscending
8AN8Address NumberAscending
8L7
ElementAliasDescriptionSequence
1ICUBatch NumberAscending
2ICUTBatch TypeAscending
3COCompanyAscending
4DCTDocument TypeAscending
5DOCDocument (Voucher Invoice etc.)Ascending
6DGJDate - For G/L (and Voucher) - JulianAscending
7JELNJournal Entry Line NumberAscending
9L8
ElementAliasDescriptionSequence
1COGRAgrupation CodeAscending
2C76JCNTributary Identification NumberAscending
3C76RTTributary CodeAscending