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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
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

160 COLUMNS | 2 INDEXES | Print definition?920 | 53 | F5311Z1 TABLE

53: Change Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F5311Z1DK1602Change Request Details Table WorkfileMaster Files53: Change Management
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 DKJOBS, DKACTN, DKMCU, DKCONO, DKLNID, DKREQB, DKCO, DKRQBD, DKDL01, DKPROC, DKSCOS, DKLTC, DKCOAM, DKCQAM, DKCFAM, DKBCAM, DKPTYC, DKCURO, DKCURQ, DKFURC, DKBURC, DKUOCM, DKOQTC, DKQQTC, DKCQTF, DKCBTF, DKANIC, DKCAID, DKMCU5, DKOBJC, DKSUB7, DKDL05, DKCPY, DKSBLC, DKSBTC, DKCDTG, DKR01C, DKDTOC, DKDTQC, DKDTFC, DKCWFF, DKCFB0, DKCOFA, DKCQFA, DKCFFA, DKCBFA, DKSREV, DKLTO, DKTRMO, DKROAM, DKRQAM, DKFRAM, DKBRAM, DKPTYR, DKRURO, DKRURQ, DKFURR, DKFURB, DKUOMR, DKRQTO, DKRQTQ, DKRQTF, DKRQTB, DKMCU6, DKANIR, DKRAID, DKOBJ8, DKSUB8, DKDL06, DKCO3, DKSBLR, DKSBTR, DKDGCG, DKR01R, DKDTOR, DKDTQR, DKFRDT, DKRWFF, DKRFB0, DKROFA, DKRQFA, DKRFFA, DKRBFA, DKSSUB, DKLTS, DKTRM1, DKSOAM, DKSQAM, DKSFAM, DKBSAM, DKPTYS, DKSURO, DKSURQ, DKFURS, DKBURS, DKUOMS, DKSQTO, DKSQTQ, DKSQTF, DKSQTB, DKANIS, DKAIDS, DKMCU7, DKSOBJ, DKSUB9, DKDL07, DKCO4, DKSBL, DKSBTS, DKDCGS, DKR01S, DKFUF2, DKDTOS, DKDTQS, DKDTFS, DKSWFF, DKSFB0, DKSOFA, DKSQFA, DKSFFA, DKSBFA, DKEXTD, DKRQDD, DKQTDD, DKQTRD, DKDOCM, DKDCTM, DKSFXO, DKKCOO, DKLINN, DKAN8V, DKSMSF, DKDSBP, DKDOCO, DKDCTO, DKCOCH, DKLNCT, DKKCO, DKAN8O, DKOPIM, DKDL03, DKCBSF, DKDRVP, DKCRCL, DKCRRM, DKCRCD, DKCRR, DKCRCF, DKCRRD, DKRB01, DKRB02, DKRB03, DKF1A, DKF3T, DKCMDT, DKUSER, DKPID, DKJOBN, DKUPMJ, DKUPMT FROM F5311Z1

TOP920 | 53 | F5311Z1 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1DKJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
2DKACTNAction CodeCharacterGeneric Edit10 Allow NULL? 
3DKMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
4DKCONOChange Request NumberNumericGeneric Edit80 Allow NULL? 
5DKLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
6DKREQBNumber - RequoteNumericGeneric Edit80 Allow NULL? 
7DKCOCompanyStringGeneric Edit50 Allow NULL? 
8DKRQBDDate - Requote (Julian)DateGeneric Edit60
9DKDL01DescriptionStringGeneric Edit300 Allow NULL? 
10DKPROCNotice to ProceedCharacterUDC (53 PS)10 Allow NULL? 
11DKSCOSStatus Code CostStringGeneric Edit20 Allow NULL? 
12DKLTCCost Ledger TypeStringUDC (09 LT)20 Allow NULL? 
13DKCOAMAmount - Original for CostNumericGeneric Edit152 Allow NULL? 
14DKCQAMAmount Quoted for CostNumericGeneric Edit152 Allow NULL? 
15DKCFAMAmount Final for CostNumericGeneric Edit152 Allow NULL? 
16DKBCAMAmount Best for CostNumericGeneric Edit152 Allow NULL? 
17DKPTYCPricing Type CostCharacterGeneric Edit10 Allow NULL? 
18DKCUROUnit Rate - Original CostNumericGeneric Edit154 Allow NULL? 
19DKCURQUnit Rate - Quoted CostNumericGeneric Edit154 Allow NULL? 
20DKFURCUnit Rate - Final CostNumericGeneric Edit154 Allow NULL? 
21DKBURCUnit Rate - Best CostNumericGeneric Edit154 Allow NULL? 
22DKUOCMUnit of Measure - CostStringUDC (00 UM)20 Allow NULL? 
23DKOQTCQuantity - Original CostNumericGeneric Edit152 Allow NULL? 
24DKQQTCQuantity - Quoted CostNumericGeneric Edit152 Allow NULL? 
25DKCQTFQuantity - Final CostNumericGeneric Edit152 Allow NULL? 
26DKCBTFQuantity - Best CostNumericGeneric Edit152 Allow NULL? 
27DKANICAccount Number - CostStringGeneric Edit290 Allow NULL? 
28DKCAIDAccount ID - CostStringGeneric Edit80 Allow NULL? 
29DKMCU5Business Unit - CostStringGeneric Edit120 Allow NULL? 
30DKOBJCObject Account - CostStringGeneric Edit60 Allow NULL? 
31DKSUB7Subsidiary - CostStringGeneric Edit80 Allow NULL? 
32DKDL05Description 05StringGeneric Edit300 Allow NULL? 
33DKCPYCompanyStringGeneric Edit50 Allow NULL? 
34DKSBLCSubledger - G/L CostStringGeneric Edit80 Allow NULL? 
35DKSBTCSubledger Type - CostCharacterUDC (00 ST)10 Allow NULL? 
36DKCDTGDate - ChangeDateGeneric Edit60
37DKR01CCategory Code - G/L 001 CostStringUDC (09 01)30 Allow NULL? 
38DKDTOCDate - Original CostDateGeneric Edit60
39DKDTQCDate - Quoted CostDateGeneric Edit60
40DKDTFCDate - Final CostDateGeneric Edit60
41DKCWFFWorkFlowCostFlagCharacterGeneric Edit10 Allow NULL? 
42DKCFB0Force Best To Zero CostCharacterGeneric Edit10 Allow NULL? 
43DKCOFAForeignAmount - Original for CostNumericGeneric Edit152 Allow NULL? 
44DKCQFAForeignAmount - Quoted for CostNumericGeneric Edit152 Allow NULL? 
45DKCFFAForeignAmount - Final for CostNumericGeneric Edit152 Allow NULL? 
46DKCBFAForeignAmount - Best for CostNumericGeneric Edit152 Allow NULL? 
47DKSREVStatus Code RevenueStringGeneric Edit20 Allow NULL? 
48DKLTORevenue Ledger TypeStringUDC (09 LT)20 Allow NULL? 
49DKTRMOTerms OnlyCharacterUDC (H00 TR)10 Allow NULL? 
50DKROAMAmount - Original for RevenueNumericGeneric Edit152 Allow NULL? 
51DKRQAMAmount Quoted for RevenueNumericGeneric Edit152 Allow NULL? 
52DKFRAMAmount Final for RevenueNumericGeneric Edit152 Allow NULL? 
53DKBRAMAmount Best for RevenueNumericGeneric Edit152 Allow NULL? 
54DKPTYRPricing Type RevenueCharacterGeneric Edit10 Allow NULL? 
55DKRUROUnit Rate - Original RevenueNumericGeneric Edit154 Allow NULL? 
56DKRURQUnit Rate - Quoted RevenueNumericGeneric Edit154 Allow NULL? 
57DKFURRUnit Rate - Final RevenueNumericGeneric Edit154 Allow NULL? 
58DKFURBUnit Rate - Best RevenueNumericGeneric Edit154 Allow NULL? 
59DKUOMRUnit of Measure - RevenueStringUDC (00 UM)20 Allow NULL? 
60DKRQTOQuantity - Original RevenueNumericGeneric Edit152 Allow NULL? 
61DKRQTQQuantity - Quoted RevenueNumericGeneric Edit152 Allow NULL? 
62DKRQTFQuantity - Final RevenueNumericGeneric Edit152 Allow NULL? 
63DKRQTBQuantity - Best RevenueNumericGeneric Edit152 Allow NULL? 
64DKMCU6Business Unit - RevenueStringGeneric Edit120 Allow NULL? 
65DKANIRAccount Number - RevenueStringGeneric Edit290 Allow NULL? 
66DKRAIDAccount ID - RevenueStringGeneric Edit80 Allow NULL? 
67DKOBJ8Object Account - RevenueStringGeneric Edit60 Allow NULL? 
68DKSUB8Subsidiary - RevenueStringGeneric Edit80 Allow NULL? 
69DKDL06Description 06StringGeneric Edit300 Allow NULL? 
70DKCO3CompanyStringGeneric Edit50 Allow NULL? 
71DKSBLRSubledger - G/L RevenueStringGeneric Edit80 Allow NULL? 
72DKSBTRSubledger Type - RevenueCharacterUDC (00 ST)10 Allow NULL? 
73DKDGCGDate - ChangeDateGeneric Edit60
74DKR01RCategory Code - G/L 001 RevenueStringUDC (09 01)30 Allow NULL? 
75DKDTORDate - Original RevenueDateGeneric Edit60
76DKDTQRDate - Quoted RevenueDateGeneric Edit60
77DKFRDTDate - Final RevenueDateGeneric Edit60
78DKRWFFWorkFlowRevenueFlagCharacterGeneric Edit10 Allow NULL? 
79DKRFB0Force Best To Zero RevenueCharacterGeneric Edit10 Allow NULL? 
80DKROFAForeignAmount - Original for RevenueNumericGeneric Edit152 Allow NULL? 
81DKRQFAForeignAmount - Quoted for RevenueNumericGeneric Edit152 Allow NULL? 
82DKRFFAForeignAmount - Final for RevenueNumericGeneric Edit152 Allow NULL? 
83DKRBFAForeignAmount - Best for RevenueNumericGeneric Edit152 Allow NULL? 
84DKSSUBStatus Code SubcontractStringGeneric Edit20 Allow NULL? 
85DKLTSSubcontract Ledger TypeStringUDC (09 LT)20 Allow NULL? 
86DKTRM1Terms OnlyCharacterGeneric Edit10 Allow NULL? 
87DKSOAMAmount - Original for SubcontractNumericGeneric Edit152 Allow NULL? 
88DKSQAMAmount Quoted for SubcontractNumericGeneric Edit152 Allow NULL? 
89DKSFAMAmount Final for SubcontractNumericGeneric Edit152 Allow NULL? 
90DKBSAMAmount Best for SubcontractNumericGeneric Edit152 Allow NULL? 
91DKPTYSPricing Type SubcontractCharacterGeneric Edit10 Allow NULL? 
92DKSUROUnit Rate - Original SubcontractNumericGeneric Edit154 Allow NULL? 
93DKSURQUnit Rate - Quoted SubcontractNumericGeneric Edit154 Allow NULL? 
94DKFURSUnit Rate - Final SubcontractNumericGeneric Edit154 Allow NULL? 
95DKBURSUnit Rate - Best SubcontractNumericGeneric Edit154 Allow NULL? 
96DKUOMSUnit of Measure - SubcontractStringUDC (00 UM)20 Allow NULL? 
97DKSQTOQuantity - Original SubcontractNumericGeneric Edit152 Allow NULL? 
98DKSQTQQuantity - Quoted SubcontractNumericGeneric Edit152 Allow NULL? 
99DKSQTFQuantity - Final SubcontractNumericGeneric Edit152 Allow NULL? 
100DKSQTBQuantity - Best SubcontractNumericGeneric Edit152 Allow NULL? 
101DKANISAccount Number - SubcontractStringGeneric Edit290 Allow NULL? 
102DKAIDSAccount ID - SubcontractStringGeneric Edit80 Allow NULL? 
103DKMCU7Business Unit - SubcontractStringGeneric Edit120 Allow NULL? 
104DKSOBJObject Account - SubcontractStringGeneric Edit60 Allow NULL? 
105DKSUB9Subsidiary - SubcontractStringGeneric Edit80 Allow NULL? 
106DKDL07Description 07StringGeneric Edit300 Allow NULL? 
107DKCO4CompanyStringGeneric Edit50 Allow NULL? 
108DKSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
109DKSBTSSubledger Type - SubcontractCharacterUDC (00 ST)10 Allow NULL? 
110DKDCGSDate - Change SubcontractDateGeneric Edit60
111DKR01SCategory Code - G/L 001 SubcontractStringUDC (09 01)30 Allow NULL? 
112DKFUF2Post QuantitiesCharacterGeneric Edit10 Allow NULL? 
113DKDTOSDate - Original SubcontractDateGeneric Edit60
114DKDTQSDate - Quoted SubcontractDateGeneric Edit60
115DKDTFSDate - Final SubcontractDateGeneric Edit60
116DKSWFFWorkFlowSubcontractFlagCharacterGeneric Edit10 Allow NULL? 
117DKSFB0Force Best To Zero SubcontractCharacterGeneric Edit10 Allow NULL? 
118DKSOFAForeignAmount - Original for SubcontractNumericGeneric Edit152 Allow NULL? 
119DKSQFAForeignAmount - Quoted for SubcontractNumericGeneric Edit152 Allow NULL? 
120DKSFFAForeignAmount - Final for SubcontractNumericGeneric Edit152 Allow NULL? 
121DKSBFAForeignAmount - Best for SubcontractNumericGeneric Edit152 Allow NULL? 
122DKEXTDDays - ExtendNumericGeneric Edit90 Allow NULL? 
123DKRQDDDays - RequiredNumericGeneric Edit90 Allow NULL? 
124DKQTDDDate - Quote DueDateGeneric Edit60
125DKQTRDDate - Quote ReceivedDateGeneric Edit60
126DKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80 Allow NULL? 
127DKDCTMDocument Type - MatchingStringUDC (00 DT)20 Allow NULL? 
128DKSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
129DKKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
130DKLINNLine NumberNumericGeneric Edit73 Allow NULL? 
131DKAN8VAddress Number - SupplierNumericGeneric Edit80 Allow NULL? 
132DKSMSFSubcontract Send FlagCharacterGeneric Edit10 Allow NULL? 
133DKDSBPDate - Subcontract PushedDateGeneric Edit60
134DKDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
135DKDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
136DKCOCHContract Change NumberStringGeneric Edit30 Allow NULL? 
137DKLNCTLine Number - ContractNumericGeneric Edit73 Allow NULL? 
138DKKCODocument CompanyStringGeneric Edit50 Allow NULL? 
139DKAN8OAddress Number - Job A/RNumericGeneric Edit80 Allow NULL? 
140DKOPIMOwner Pay ItemStringGeneric Edit150 Allow NULL? 
141DKDL03Description 03StringGeneric Edit300 Allow NULL? 
142DKCBSFContract Billing Send FlagCharacterGeneric Edit10 Allow NULL? 
143DKDRVPDate - Revenue PushedDateGeneric Edit60
144DKCRCLClose FlagCharacterGeneric Edit10 Allow NULL? 
145DKCRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
146DKCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
147DKCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
148DKCRCFCurrency Code - OriginStringGeneric Edit30 Allow NULL? 
149DKCRRDCurrency Conversion Rate - DivisorNumericGeneric Edit150 Allow NULL? 
150DKRB01Initiated ByStringUDC (53 01)30 Allow NULL? 
151DKRB02AreaStringUDC (53 02)30 Allow NULL? 
152DKRB03Category Code - Change Orders 03StringUDC (53 03)30 Allow NULL? 
153DKF1AFuture 1 AmountNumericGeneric Edit150 Allow NULL? 
154DKF3TFuture 3 TextStringGeneric Edit300 Allow NULL? 
155DKCMDTFuture Use DateDateGeneric Edit60
156DKUSERUser IDStringGeneric Edit100 Allow NULL? 
157DKPIDProgram IDStringGeneric Edit100 Allow NULL? 
158DKJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
159DKUPMJDate - UpdatedDateGeneric Edit60
160DKUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP920 | 53 | F5311Z1 INDEXES

NumberDescription
1Bus.Unit Chg.Order No. + (Primary/Unique)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2CONOChange Request NumberAscending
3LNIDLine NumberAscending
4REQBNumber - RequoteAscending
12JobNumber Line Number(D)
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
2LNIDLine NumberDescending