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

188 COLUMNS | 1 INDEXES | Print definition?910 | 89 | F43199A TABLE

89: Conversion Programs
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F43199AOL1881Temp F43199 for ERP 9.0 UpgradeHistory Files43: Procurement
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 OLKCOO, OLDOCO, OLDCTO, OLSFXO, OLLNID, OLMCU, OLCO, OLOKCO, OLOORN, OLOCTO, OLOGNO, OLRKCO, OLRORN, OLRCTO, OLRLLN, OLDMCT, OLDMCS, OLBALU, OLAN8, OLSHAN, OLDRQJ, OLTRDJ, OLPDDJ, OLOPDJ, OLADDJ, OLCNDJ, OLPEFJ, OLPPDJ, OLPSDJ, OLDSVJ, OLDGL, OLPN, OLVR01, OLVR02, OLITM, OLLITM, OLAITM, OLLOCN, OLLOTN, OLFRGD, OLTHGD, OLFRMP, OLTHRP, OLDSC1, OLDSC2, OLLNTY, OLNXTR, OLLTTR, OLRLIT, OLPDS1, OLPDS2, OLPDS3, OLPDS4, OLPDS5, OLPDP1, OLPDP2, OLPDP3, OLPDP4, OLPDP5, OLUOM, OLUORG, OLUCHG, OLUOPN, OLUREC, OLCREC, OLURLV, OLOTQY, OLPRRC, OLAEXP, OLACHG, OLAOPN, OLAREC, OLARLV, OLFTN1, OLTRLV, OLPROV, OLAMC3, OLECST, OLCSTO, OLCSMP, OLINMG, OLASN, OLPRGR, OLCLVL, OLCATN, OLDSPR, OLPTC, OLTX, OLEXR1, OLTXA1, OLATXT, OLCNID, OLCDCD, OLNTR, OLFRTH, OLFRTC, OLZON, OLFRAT, OLRATT, OLANBY, OLANCR, OLMOT, OLCOT, OLSHCM, OLSHCN, OLUOM1, OLPQOR, OLUOM2, OLSQOR, OLUOM3, OLITWT, OLWTUM, OLITVL, OLVLUM, OLGLC, OLCTRY, OLFY, OLSTTS, OLRCD, OLFUF1, OLFUF2, OLGRWT, OLGWUM, OLLT, OLANI, OLAID, OLOMCU, OLOBJ, OLSUB, OLSBLT, OLSBL, OLASID, OLCCMP, OLTAG, OLWR01, OLPL, OLELEV, OLR001, OLRTNR, OLLCOD, OLPURG, OLPROM, OLFNLP, OLAVCH, OLPRPY, OLUNCD, OLMATY, OLRTGC, OLRCPF, OLPS01, OLPS02, OLPS03, OLPS04, OLPS05, OLPS06, OLPS07, OLPS08, OLPS09, OLPS10, OLCRMD, OLARTG, OLCORD, OLCHDT, OLDOCC, OLCHLN, OLCRCD, OLCRR, OLFRRC, OLFEA, OLFUC, OLFEC, OLFCHG, OLFAP, OLFREC, OLURCD, OLURDT, OLURAT, OLURAB, OLURRF, OLTORG, OLUSER, OLPID, OLJOBN, OLUPMJ, OLTDAY, OLUKID, OLOSFX, OLSHPN FROM F43199A

TOP910 | 89 | F43199A COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1OLKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
2OLDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3OLDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
4OLSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
5OLLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
6OLMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
7OLCOCompanyStringGeneric Edit50 Allow NULL? 
8OLOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
9OLOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
10OLOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
11OLOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
12OLRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
13OLRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
14OLRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
15OLRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
16OLDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
17OLDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
18OLBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
19OLAN8Address NumberNumericUDC80 Allow NULL? 
20OLSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
21OLDRQJDate - RequestedDateGeneric Edit60
22OLTRDJDate - Order/TransactionDateGeneric Edit60
23OLPDDJDate - Scheduled PickDateGeneric Edit60
24OLOPDJDate - Original Promised DeliveryDateGeneric Edit60
25OLADDJDate - Actual Ship DateDateGeneric Edit60
26OLCNDJDate - CancelDateGeneric Edit60
27OLPEFJDate - Price Effective DateDateGeneric Edit60
28OLPPDJDate - Promised ShipmentDateGeneric Edit60
29OLPSDJDate - Future Date 2DateGeneric Edit60
30OLDSVJDate - Service/TaxDateGeneric Edit60
31OLDGLDate - For G/L (and Voucher)DateGeneric Edit60
32OLPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
33OLVR01ReferenceStringGeneric Edit250 Allow NULL? 
34OLVR02Reference 2StringGeneric Edit250 Allow NULL? 
35OLITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
36OLLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
37OLAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
38OLLOCNLocationStringGeneric Edit200 Allow NULL? 
39OLLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
40OLFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
41OLTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
42OLFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
43OLTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
44OLDSC1DescriptionStringGeneric Edit300 Allow NULL? 
45OLDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
46OLLNTYLine TypeStringGeneric Edit20 Allow NULL? 
47OLNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
48OLLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
49OLRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
50OLPDS1Reporting Code 1 - SalesStringGeneric Edit30 Allow NULL? 
51OLPDS2Reporting Code 2 - SalesStringGeneric Edit30 Allow NULL? 
52OLPDS3Reporting Code 3 - SalesStringGeneric Edit30 Allow NULL? 
53OLPDS4Reporting Code 4 - SalesStringGeneric Edit30 Allow NULL? 
54OLPDS5Reporting Code 5 - SalesStringGeneric Edit30 Allow NULL? 
55OLPDP1Reporting Code 1 - PurchasingStringUDC (41 P1)30 Allow NULL? 
56OLPDP2Reporting Code 2 - PurchasingStringUDC (41 P2)30 Allow NULL? 
57OLPDP3Reporting Code 3 - PurchasingStringUDC (41 P3)30 Allow NULL? 
58OLPDP4Reporting Code 4 - PurchasingStringUDC (41 P4)30 Allow NULL? 
59OLPDP5Reporting Code 5 - PurchasingStringUDC (41 P5)30 Allow NULL? 
60OLUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
61OLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152 Allow NULL? 
62OLUCHGUnits - On HoldNumericGeneric Edit152 Allow NULL? 
63OLUOPNUnits - OpenNumericGeneric Edit152 Allow NULL? 
64OLURECUnits - ReceivedNumericGeneric Edit152 Allow NULL? 
65OLCRECUnits - Cumulative ReceivedNumericGeneric Edit152 Allow NULL? 
66OLURLVUnits - RelievedNumericGeneric Edit152 Allow NULL? 
67OLOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
68OLPRRCAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
69OLAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
70OLACHGAmount - On HoldNumericGeneric Edit152 Allow NULL? 
71OLAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
72OLARECAmount - ReceivedNumericGeneric Edit152 Allow NULL? 
73OLARLVAmount - RelievedNumericGeneric Edit152 Allow NULL? 
74OLFTN1Amount - Tax CommitmentNumericGeneric Edit152 Allow NULL? 
75OLTRLVAmount - Tax RelievedNumericGeneric Edit152 Allow NULL? 
76OLPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
77OLAMC3Unit Cost - PurchasingNumericGeneric Edit154 Allow NULL? 
78OLECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
79OLCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
80OLCSMPCosting Method - PurchasingCharacterGeneric Edit10 Allow NULL? 
81OLINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
82OLASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
83OLPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
84OLCLVLPricing Category LevelStringGeneric Edit30 Allow NULL? 
85OLCATNCatalogStringUDC (40 CN)80 Allow NULL? 
86OLDSPRDiscount FactorNumericGeneric Edit74 Allow NULL? 
87OLPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
88OLTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
89OLEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
90OLTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
91OLATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
92OLCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
93OLCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
94OLNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
95OLFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
96OLFRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
97OLZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
98OLFRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
99OLRATTRate Type - Freight/MiscCharacterGeneric Edit10 Allow NULL? 
100OLANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
101OLANCRCarrier NumberNumericGeneric Edit80 Allow NULL? 
102OLMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
103OLCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
104OLSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
105OLSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
106OLUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
107OLPQORUnits - Primary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
108OLUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
109OLSQORUnits - Secondary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
110OLUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
111OLITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
112OLWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
113OLITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
114OLVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
115OLGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
116OLCTRYCenturyNumericGeneric Edit20 Allow NULL? 
117OLFYFiscal YearNumericGeneric Edit20 Allow NULL? 
118OLSTTSLine StatusStringGeneric Edit20 Allow NULL? 
119OLRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
120OLFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
121OLFUF2Post QuantitiesCharacterGeneric Edit10 Allow NULL? 
122OLGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
123OLGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
124OLLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
125OLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
126OLAIDAccount IDStringGeneric Edit80 Allow NULL? 
127OLOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
128OLOBJObject AccountStringGeneric Edit60 Allow NULL? 
129OLSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
130OLSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
131OLSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
132OLASIDSerial NumberStringGeneric Edit250 Allow NULL? 
133OLCCMPCost Component NumberNumericGeneric Edit30 Allow NULL? 
134OLTAGTag - ReferenceStringGeneric Edit80 Allow NULL? 
135OLWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
136OLPLPlan NumberStringGeneric Edit40 Allow NULL? 
137OLELEVElevationStringGeneric Edit30 Allow NULL? 
138OLR001Category Code - G/L1StringUDC (09 01)30 Allow NULL? 
139OLRTNRRetainage RuleStringGeneric Edit30 Allow NULL? 
140OLLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
141OLPURGPurge CodeCharacterGeneric Edit10 Allow NULL? 
142OLPROMProcessing ModeCharacterUDC (H40 PQ)10 Allow NULL? 
143OLFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
144OLAVCHCode - Evaluated Receipt SettlementCharacterUDC (40 ER)10 Allow NULL? 
145OLPRPYPre-Payment (Y/N)CharacterGeneric Edit10 Allow NULL? 
146OLUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
147OLMATYType - Match TypeCharacterUDC (H40 MB)10 Allow NULL? 
148OLRTGCRouting Process (Y/N)CharacterGeneric Edit10 Allow NULL? 
149OLRCPFLeadtime Recalculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
150OLPS01Transfer/Direct Ship FlagCharacterGeneric Edit10 Allow NULL? 
151OLPS02Purchase Order Status 02CharacterGeneric Edit10 Allow NULL? 
152OLPS03Purchase Order Status 03CharacterGeneric Edit10 Allow NULL? 
153OLPS04Purchase Order Status 04CharacterGeneric Edit10 Allow NULL? 
154OLPS05Purchase Order Status 05CharacterGeneric Edit10 Allow NULL? 
155OLPS06Purchase Order Status 06CharacterGeneric Edit10 Allow NULL? 
156OLPS07Purchase Order Status 07CharacterGeneric Edit10 Allow NULL? 
157OLPS08Purchase Order Status 08CharacterGeneric Edit10 Allow NULL? 
158OLPS09Purchase Order Status 09CharacterGeneric Edit10 Allow NULL? 
159OLPS10Purchase Order Status 10CharacterUDC (00 XS)10 Allow NULL? 
160OLCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
161OLARTGCode - Approval RoutingStringGeneric Edit120 Allow NULL? 
162OLCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
163OLCHDTChange Order TypeStringUDC (00 DT)20 Allow NULL? 
164OLDOCCDocument (Change Order #)NumericGeneric Edit80 Allow NULL? 
165OLCHLNChange Order Line NumberNumericGeneric Edit73 Allow NULL? 
166OLCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
167OLCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
168OLFRRCAmount - Foreign Unit PriceNumericGeneric Edit154 Allow NULL? 
169OLFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
170OLFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
171OLFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
172OLFCHGAmount - Foreign Changed AmountNumericGeneric Edit152 Allow NULL? 
173OLFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
174OLFRECAmount - Received ForeignNumericGeneric Edit152 Allow NULL? 
175OLURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
176OLURDTUser Reserved DateDateGeneric Edit60
177OLURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
178OLURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
179OLURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
180OLTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
181OLUSERUser IDStringGeneric Edit100 Allow NULL? 
182OLPIDProgram IDStringGeneric Edit100 Allow NULL? 
183OLJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
184OLUPMJDate - UpdatedDateGeneric Edit60
185OLTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
186OLUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
187OLOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
188OLSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 

TOP910 | 89 | F43199A INDEXES

NumberDescription
1Doc Company Order No + A (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4SFXOOrder SuffixAscending
5LNIDLine NumberAscending
6LTLedger TypesAscending
7CORDChange Order NumberAscending
8UPMJDate - UpdatedAscending
9TDAYTime of DayAscending