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

73 COLUMNS | 5 INDEXES | Print definition?812 | F31 | FF31111 TABLE

F31: Lean Transactions
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812FF31111PL735Lean Transaction Parts ListFilesF31: Lean Transactions
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 PLUKID, PLMTID, PLPRODF31, PLTRSID, PLDFMLINE, PLKIT, PLMMCU, PLITM, PLCMCU, PLCPNB, PLTRQTY, PLLTRQT, PLSOCN, PLUOM, PLUM, PLFORQ, PLITC, PLRORN, PLRCTO, PLRLLN, PLRKCO, PLOPSQ, PLBSEQ, PLRSCP, PLSCRP, PLREWP, PLASIP, PLCPYP, PLSTPP, PLLITM, PLAITM, PLDSC1, PLDSC2, PLLOCN, PLLOTN, PLAN8, PLLNTY, PLSERN, PLLTDATE, PLUCNDJ, PLLRDATE, PLCTS1, PLCTS4, PLCTS8, PLCTS7, PLEA, PLDCT, PLMCU, PLOMCU, PLOBJ, PLSUB, PLCMRV, PLVEND, PLPOC, PLLGLDATE, PLPSN, PLLLEDATE, PLTRQT, PLTRSTS, PLCOST, PLCHPP, PLBSEQAN, PLTUSER, PLCUSER, PLURCD, PLURDT, PLURAT, PLURRF, PLURAB, PLUSER, PLUUPMJ, PLMKEY, PLPID FROM FF31111

TOP812 | F31 | FF31111 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1PLUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
2PLMTIDMaster Transaction IDNumericGeneric Edit150 Allow NULL? 
3PLPRODF31Production Plan IDNumericGeneric Edit80 Allow NULL? 
4PLTRSIDTransaction IDNumericGeneric Edit80 Allow NULL? 
5PLDFMLINEDFM Line IdentifierStringGeneric Edit120 Allow NULL? 
6PLKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
7PLMMCUBranchStringGeneric Edit120 Allow NULL? 
8PLITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
9PLCMCUComponent BranchStringGeneric Edit120 Allow NULL? 
10PLCPNBComponent Line Number BOMNumericGeneric Edit82 Allow NULL? 
11PLTRQTYUnits - Transaction Quantity PrimaryNumericGeneric Edit150 Allow NULL? 
12PLLTRQTLean Transaction QuantityNumericGeneric Edit150 Allow NULL? 
13PLSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit152 Allow NULL? 
14PLUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
15PLUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
16PLFORQFixed or Variable QuantityCharacterUDC (H40 FO)10 Allow NULL? 
17PLITCIssue Type CodeCharacterUDC (41 IT)10 Allow NULL? 
18PLRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
19PLRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
20PLRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
21PLRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
22PLOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
23PLBSEQSorszám - Buborék sorszámNumericGeneric Edit50 Allow NULL? 
24PLRSCPResource PercentNumericGeneric Edit52 Allow NULL? 
25PLSCRPPercent - Percent of ScrapNumericGeneric Edit52 Allow NULL? 
26PLREWPPercent - ReworkNumericGeneric Edit52 Allow NULL? 
27PLASIPPercent - As isNumericGeneric Edit52 Allow NULL? 
28PLCPYPPercent - Cumulative Planned YieldNumericGeneric Edit52 Allow NULL? 
29PLSTPPOperation Scrap PercentNumericGeneric Edit52 Allow NULL? 
30PLLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
31PLAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
32PLDSC1DescriptionStringGeneric Edit300 Allow NULL? 
33PLDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
34PLLOCNLocationStringGeneric Edit200 Allow NULL? 
35PLLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
36PLAN8Address NumberNumericUDC80 Allow NULL? 
37PLLNTYLine TypeStringGeneric Edit20 Allow NULL? 
38PLSERNSerial Number - LotStringGeneric Edit300 Allow NULL? 
39PLLTDATETransaction Date LeanJDE UTimeGeneric Edit110
40PLUCNDJDate - CancelJDE UTimeGeneric Edit110
41PLLRDATERequested Date LeanJDE UTimeGeneric Edit110
42PLCTS1Hours - Unaccounted Direct LaborNumericGeneric Edit152 Allow NULL? 
43PLCTS4Amount - Unaccounted Direct LaborNumericGeneric Edit152 Allow NULL? 
44PLCTS8Units - Unaccounted ScrapNumericGeneric Edit152 Allow NULL? 
45PLCTS7Amount - Unaccounted ScrapNumericGeneric Edit152 Allow NULL? 
46PLEAAmount - Estimated CostNumericGeneric Edit152 Allow NULL? 
47PLDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
48PLMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
49PLOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
50PLOBJObject AccountStringGeneric Edit60 Allow NULL? 
51PLSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
52PLCMRVComponent Revision LevelStringGeneric Edit30 Allow NULL? 
53PLVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
54PLPOCIssue and ReceiptCharacterUDC (43 IR)10 Allow NULL? 
55PLLGLDATEG/L Date LeanJDE UTimeGeneric Edit110
56PLPSNPick Slip NumberNumericGeneric Edit80 Allow NULL? 
57PLLLEDATELot Effective Date LeanJDE UTimeGeneric Edit110
58PLTRQTQuantity AvailableNumericGeneric Edit152 Allow NULL? 
59PLTRSTSTransaction StatusStringUDC (F31 TS)20 Allow NULL? 
60PLCOSTCost ComponentStringUDC (30 CA)30 Allow NULL? 
61PLCHPPCritical Hold PropagationCharacterGeneric Edit10 Allow NULL? 
62PLBSEQANBubble Sequence Alpha NumericStringGeneric Edit50 Allow NULL? 
63PLTUSERTransaction User IDStringGeneric Edit100 Allow NULL? 
64PLCUSERCancellation User IDStringGeneric Edit100 Allow NULL? 
65PLURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
66PLURDTUser Reserved DateDateGeneric Edit60
67PLURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
68PLURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
69PLURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
70PLUSERUser IDStringGeneric Edit100 Allow NULL? 
71PLUUPMJUniversal Date UpdatedJDE UTimeGeneric Edit110
72PLMKEYMachine KeyStringGeneric Edit150 Allow NULL? 
73PLPIDProgram IDStringGeneric Edit100 Allow NULL? 

TOP812 | F31 | FF31111 INDEXES

NumberDescription
1UKID (Primary/Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
2ITM CMCU LTRQT
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2CMCUComponent BranchAscending
3LTRQTLean Transaction QuantityAscending
3MTID PRODF31 +
ElementAliasDescriptionSequence
1MTIDMaster Transaction IDAscending
2PRODF31Production Plan IDAscending
3TRSIDTransaction IDAscending
4PRODF31 TRSID +
ElementAliasDescriptionSequence
1PRODF31Production Plan IDAscending
2TRSIDTransaction IDAscending
3OPSQSequence Number - OperationsAscending
5ITM CMCU +
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2CMCUComponent BranchAscending
3LOCNLocationAscending
4LOTNLot/Serial NumberAscending