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

155 COLUMNS | 11 INDEXES | Print definition?920 | 53 | F5311 TABLE

53: Change Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F5311DK15511Change Request Details TableMaster Files53: Change 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 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, 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, 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, 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 F5311

TOP920 | 53 | F5311 COLUMNS

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

TOP920 | 53 | F5311 INDEXES

NumberDescription
1Bus.Unit Chg.Order No. + (Primary/Unique)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2CONOChange Request NumberAscending
3LNIDLine NumberAscending
4REQBNumber - RequoteAscending
2Cost Status Code
ElementAliasDescriptionSequence
1SCOSStatus Code CostAscending
3Revenue Status Code
ElementAliasDescriptionSequence
1SREVStatus Code RevenueAscending
4Subcontract Status Code
ElementAliasDescriptionSequence
1SSUBStatus Code SubcontractAscending
5Owner Addr. No. Chg. Order +
ElementAliasDescriptionSequence
1AN8OAddress Number - Job A/RAscending
2CONOChange Request NumberAscending
3REQBNumber - RequoteDescending
6Bus.Unit Chg. Order No. +
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2CONOChange Request NumberAscending
3REQBNumber - RequoteAscending
4LNIDLine NumberAscending
7Owner Doc. Doc. Type +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCODocument CompanyAscending
4CONOChange Request NumberAscending
5REQBNumber - RequoteDescending
8Vendor Chg.Order No. +
ElementAliasDescriptionSequence
1AN8VAddress Number - SupplierAscending
2CONOChange Request NumberAscending
3REQBNumber - RequoteDescending
9Subcontract Doc. Doc. Type +
ElementAliasDescriptionSequence
1DOCMDocument - Matching(Payment or Item)Ascending
2DCTMDocument Type - MatchingAscending
3KCOOOrder Company (Order Number)Ascending
4CONOChange Request NumberAscending
5REQBNumber - RequoteDescending
10Bus.Unit Chg.Ord Req# Lin# (D)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2CONOChange Request NumberAscending
3REQBNumber - RequoteAscending
4LNIDLine NumberDescending
11Bus.Unit Chg.Order Req (D)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2CONOChange Request NumberAscending
3REQBNumber - RequoteDescending