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
4F4211SDSales Order Detail File
5F4311PDPurchase 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

72 COLUMNS | 13 INDEXES | Print definition?910 | 41 | F4111 TABLE

41: Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F4111IL7213Item Ledger FileTransaction Files41: Inventory ManagementBusiness 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 ILNLIN, ILITM, ILLITM, ILAITM, ILMCU, ILLOCN, ILLOTN, ILPLOT, ILSTUN, ILLDSQ, ILTRNO, ILFRTO, ILLMCX, ILLOTS, ILLOTP, ILLOTG, ILKIT, ILMMCU, ILDMCT, ILDMCS, ILKCO, ILDOC, ILDCT, ILSFX, ILJELN, ILICU, ILDGL, ILGLPT, ILDCTO, ILDOCO, ILKCOO, ILLNID, ILIPCD, ILTRDJ, ILTRUM, ILAN8, ILTREX, ILTREF, ILRCD, ILTRQT, ILUNCS, ILPAID, ILTERM, ILUKID, ILTDAY, ILUSER, ILPID, ILCRDJ, ILAID, ILASID, ILMCUZ, ILOBJ, ILSBL, ILSUB, ILUOM2, ILCMOO, ILRE, ILSBLT, ILSQOR, ILVPEJ, ILHDGJ, ILSHAN, ILOPSQ, ILRFLN, ILTGN, ILLOTC, ILSVDT, ILLRCD, ILRLOT, ILLPNU, ILPMPN, ILPNS FROM F4111

TOP910 | 41 | F4111 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ILNLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
2ILITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
3ILLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
4ILAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
5ILMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
6ILLOCNLocationStringGeneric Edit200 Allow NULL? 
7ILLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
8ILPLOTParent LotStringGeneric Edit300 Allow NULL? 
9ILSTUNStorage Unit NumberNumericGeneric Edit80 Allow NULL? 
10ILLDSQSequence Number - Location DetailNumericGeneric Edit80 Allow NULL? 
11ILTRNOTransaction Line NumberNumericGeneric Edit50 Allow NULL? 
12ILFRTOFrom/ToCharacterGeneric Edit10 Allow NULL? 
13ILLMCXLot Master Cardex (Y/N)CharacterGeneric Edit10 Allow NULL? 
14ILLOTSLot Status CodeCharacterUDC (41 L)10 Allow NULL? 
15ILLOTPLot PotencyNumericGeneric Edit153 Allow NULL? 
16ILLOTGLot GradeStringUDC (40 LG)30 Allow NULL? 
17ILKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
18ILMMCUBranchStringGeneric Edit120 Allow NULL? 
19ILDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
20ILDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
21ILKCODocument CompanyStringGeneric Edit50 Allow NULL? 
22ILDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
23ILDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
24ILSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
25ILJELNJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
26ILICUBatch NumberNumericGeneric Edit80 Allow NULL? 
27ILDGLDate - For G/L (and Voucher)DateGeneric Edit60
28ILGLPTCategory - G/LStringUDC (41 9)40 Allow NULL? 
29ILDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
30ILDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
31ILKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
32ILLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
33ILIPCDAs Of Posted CodeCharacterUDC (H41 IP)10 Allow NULL? 
34ILTRDJDate - Order/TransactionDateGeneric Edit60
35ILTRUMUnit of Measure - TransactionStringUDC (00 UM)20 Allow NULL? 
36ILAN8Address NumberNumericUDC80 Allow NULL? 
37ILTREXExplanation - TransactionStringGeneric Edit300 Allow NULL? 
38ILTREFTransaction ReferenceStringGeneric Edit80 Allow NULL? 
39ILRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
40ILTRQTQuantity AvailableNumericGeneric Edit152 Allow NULL? 
41ILUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
42ILPAIDAmount - Extended Cost/PriceNumericGeneric Edit152 Allow NULL? 
43ILTERMterminal identificationStringGeneric Edit100 Allow NULL? 
44ILUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
45ILTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
46ILUSERUser IDStringGeneric Edit100 Allow NULL? 
47ILPIDProgram IDStringGeneric Edit100 Allow NULL? 
48ILCRDJDate - Created (Julian)DateGeneric Edit60
49ILAIDAccount IDStringGeneric Edit80 Allow NULL? 
50ILASIDSerial NumberStringGeneric Edit250 Allow NULL? 
51ILMCUZBusiness Unit - AltStringGeneric Edit120 Allow NULL? 
52ILOBJObject AccountStringGeneric Edit60 Allow NULL? 
53ILSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
54ILSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
55ILUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
56ILCMOOCommingled Other OwnerCharacterGeneric Edit10 Allow NULL? 
57ILREReverse or Void (R/V)CharacterUDC (H09 RE)10 Allow NULL? 
58ILSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
59ILSQORUnits - Secondary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
60ILVPEJValuation Period Ending DateDateGeneric Edit60
61ILHDGJHistorical Date - JulianDateGeneric Edit60
62ILSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
63ILOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
64ILRFLNRelated From Line NumberNumericGeneric Edit73 Allow NULL? 
65ILTGNTransaction Group NumberNumericGeneric Edit73 Allow NULL? 
66ILLOTCLot Status Code ExpandedStringGeneric Edit30 Allow NULL? 
67ILSVDTReconciliation DateDateGeneric Edit60
68ILLRCDLot Status Reason CodeStringUDC (41 RE)30 Allow NULL? 
69ILRLOTSupplier Lot NumberStringGeneric Edit300 Allow NULL? 
70ILLPNULicense Plate NumberStringGeneric Edit400 Allow NULL? 
71ILPMPNProduction NumberStringGeneric Edit300 Allow NULL? 
72ILPNSProduction Number ShortNumericGeneric Edit100 Allow NULL? 

TOP910 | 41 | F4111 INDEXES

NumberDescription
1Unique Key ID (Primary/Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
2Document No Type +A
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
4DGLDate - For G/L (and Voucher)Ascending
5JELNJournal Entry Line NumberAscending
3Document No Type +B
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3KCODocument CompanyAscending
4LNIDLine NumberAscending
5DGLDate - For G/L (and Voucher)Ascending
4Type Order No +C
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5DGLDate - For G/L (and Voucher)Ascending
5Item No Branch +D
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MMCUBranchAscending
3TRDJDate - Order/TransactionAscending
6Branch Plant Item N Loc Lot
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3LOCNLocationAscending
4LOTNLot/Serial NumberAscending
7Document No Type +C
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
2DCTDocument TypeAscending
3ITMItem Number - ShortAscending
4MCUBusiness UnitAscending
5LOTNLot/Serial NumberAscending
8Unique Key Id Descending
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Descending
9Document Type
ElementAliasDescriptionSequence
1DCTDocument TypeAscending
10Company Date Unique Key
ElementAliasDescriptionSequence
1KCODocument CompanyAscending
2DGLDate - For G/L (and Voucher)Descending
3UKIDUnique Key ID (Internal)Ascending
11Parent Lot
ElementAliasDescriptionSequence
1PLOTParent LotAscending
12SupplierID Supplier Lot
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2RLOTSupplier Lot NumberAscending
3ITMItem Number - ShortAscending
4MCUBusiness UnitAscending
5LOCNLocationAscending
6LOTNLot/Serial NumberAscending
13Lot Number
ElementAliasDescriptionSequence
1LOTNLot/Serial NumberAscending