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
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

49 COLUMNS | 10 INDEXES | Print definition?812 | 76H | F76H611 TABLE

76H: Chile
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F76H611AL4910Actual Item Ledger File - CHI - 41 - 76HTransaction Files76: Latin American Localization
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 ALNLIN, ALITM, ALLITM, ALAITM, ALMCU, ALLOCN, ALLOTN, ALPLOT, ALSTUN, ALLDSQ, ALTRNO, ALFRTO, ALLMCX, ALLOTS, ALLOTP, ALLOTG, ALKIT, ALMMCU, ALDMCT, ALDMCS, ALBALU, ALKCO, ALDOC, ALDCT, ALSFX, ALJELN, ALICU, ALDGL, ALGLPT, ALDCTO, ALDOCO, ALKCOO, ALLNID, ALIPCD, ALTRDJ, ALTRUM, ALAN8, ALTREX, ALTREF, ALRCD, ALTRQT, ALUNCS, ALPAID, ALTERM, ALUKID, ALTDAY, ALUSER, ALPID, ALCRDJ FROM F76H611

TOP812 | 76H | F76H611 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ALNLINNumber of LinesNumericGeneric Edit50 Allow NULL? 
2ALITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
3ALLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
4ALAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
5ALMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
6ALLOCNLocationStringGeneric Edit200 Allow NULL? 
7ALLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
8ALPLOTParent LotStringGeneric Edit300 Allow NULL? 
9ALSTUNStorage Unit NumberNumericGeneric Edit80 Allow NULL? 
10ALLDSQSequence Number - Location DetailNumericGeneric Edit80 Allow NULL? 
11ALTRNOTransaction Line NumberNumericGeneric Edit50 Allow NULL? 
12ALFRTOFrom/ToCharacterGeneric Edit10 Allow NULL? 
13ALLMCXLot Master Cardex (Y/N)CharacterGeneric Edit10 Allow NULL? 
14ALLOTSLot Status CodeCharacterUDC (41 L)10 Allow NULL? 
15ALLOTPLot PotencyNumericGeneric Edit153 Allow NULL? 
16ALLOTGLot GradeStringUDC (40 LG)30 Allow NULL? 
17ALKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
18ALMMCUBranchStringGeneric Edit120 Allow NULL? 
19ALDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
20ALDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
21ALBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
22ALKCODocument CompanyStringGeneric Edit50 Allow NULL? 
23ALDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
24ALDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
25ALSFXDocument Pay ItemStringGeneric Edit30 Allow NULL? 
26ALJELNJournal Entry Line NumberNumericGeneric Edit70 Allow NULL? 
27ALICUBatch NumberNumericGeneric Edit80 Allow NULL? 
28ALDGLDate - For G/L (and Voucher)DateGeneric Edit60
29ALGLPTCategory - G/LStringUDC (41 9)40 Allow NULL? 
30ALDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
31ALDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
32ALKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
33ALLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
34ALIPCDAs Of Posted CodeCharacterUDC (H41 IP)10 Allow NULL? 
35ALTRDJDate - Order/TransactionDateGeneric Edit60
36ALTRUMUnit of Measure - TransactionStringUDC (00 UM)20 Allow NULL? 
37ALAN8Address NumberNumericUDC80 Allow NULL? 
38ALTREXExplanation - TransactionStringGeneric Edit300 Allow NULL? 
39ALTREFTransaction ReferenceStringGeneric Edit80 Allow NULL? 
40ALRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
41ALTRQTQuantity AvailableNumericGeneric Edit152 Allow NULL? 
42ALUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
43ALPAIDAmount - Extended Cost/PriceNumericGeneric Edit152 Allow NULL? 
44ALTERMterminal identificationStringGeneric Edit100 Allow NULL? 
45ALUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
46ALTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
47ALUSERUser IDStringGeneric Edit100 Allow NULL? 
48ALPIDProgram IDStringGeneric Edit100 Allow NULL? 
49ALCRDJDate - Created (Julian)DateGeneric Edit60

TOP812 | 76H | F76H611 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