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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

195 COLUMNS | 1 INDEXES | Print definition?812 | 43 | F43080 TABLE

43: Procurement
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F43080PD1951Approvals Fields ConstantsTransaction Files43: ProcurementBusiness 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 PDDCTO, PDAEXP, PDAID, PDSBL, PDSBLT, PDPDP5, PDPDDJ, PDDRQJ, PDPTC, PDDSPR, PDOMCU, PDKCOO, PDDOCO, PDSFXO, PDLNID, PDMCU, PDCO, PDOKCO, PDOORN, PDOCTO, PDOGNO, PDRKCO, PDRORN, PDRCTO, PDRLLN, PDDMCT, PDDMCS, PDBALU, PDAN8, PDSHAN, PDTRDJ, PDOPDJ, PDADDJ, PDPEFJ, PDCNDJ, PDPPDJ, PDPSDJ, PDDSVJ, PDDGL, PDPN, PDVR01, PDVR02, PDITM, PDLITM, PDAITM, PDLOCN, PDLOTN, PDFRGD, PDTHGD, PDFRMP, PDTHRP, PDDSC1, PDDSC2, PDLNTY, PDNXTR, PDLTTR, PDRLIT, PDPDS1, PDPDS2, PDPDS3, PDPDS4, PDPDS5, PDPDP1, PDPDP2, PDPDP3, PDPDP4, PDUOM, PDUORG, PDUCHG, PDUOPN, PDUREC, PDCREC, PDURLV, PDOTQY, PDPRRC, PDACHG, PDAOPN, PDAREC, PDARLV, PDFTN1, PDTRLV, PDPROV, PDAMC3, PDECST, PDCSTO, PDCSMP, PDINMG, PDASN, PDPRGR, PDCLVL, PDCATN, PDTX, PDEXR1, PDTXA1, PDATXT, PDCNID, PDCDCD, PDNTR, PDFRTH, PDFRTC, PDZON, PDFRAT, PDRATT, PDANBY, PDANCR, PDMOT, PDCOT, PDSHCM, PDSHCN, PDUOM1, PDPQOR, PDUOM2, PDSQOR, PDUOM3, PDITWT, PDWTUM, PDITVL, PDVLUM, PDGLC, PDCTRY, PDFY, PDSTTS, PDRCD, PDFUF1, PDFUF2, PDGRWT, PDGWUM, PDLT, PDANI, PDOBJ, PDSUB, PDASID, PDCCMP, PDTAG, PDWR01, PDPL, PDELEV, PDR001, PDRTNR, PDLCOD, PDPURG, PDPROM, PDFNLP, PDAVCH, PDPRPY, PDUNCD, PDMATY, PDRTGC, PDRCPF, PDPS01, PDPS02, PDPS03, PDPS04, PDPS05, PDPS06, PDPS07, PDPS08, PDPS09, PDPS10, PDCRMD, PDARTG, PDCORD, PDCHDT, PDDOCC, PDCHLN, PDCRCD, PDCRR, PDFRRC, PDFEA, PDFUC, PDFEC, PDFCHG, PDFAP, PDFREC, PDURCD, PDURDT, PDURAT, PDURAB, PDURRF, PDTORG, PDUSER, PDPID, PDJOBN, PDUPMJ, PDTDAY, PDSHPN, PDPRJM, PDOSFX, PDMCLN, PDDUAL, PDDLEJ, PDVR03, PDPMTN, PDUKID, PDSPR FROM F43080

TOP812 | 43 | F43080 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1PDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
2PDAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
3PDAIDAccount IDStringGeneric Edit80 Allow NULL? 
4PDSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
5PDSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
6PDPDP5Reporting Code 5 - PurchasingStringUDC (41 P5)30 Allow NULL? 
7PDPDDJDate - Scheduled PickDateGeneric Edit60
8PDDRQJDate - RequestedDateGeneric Edit60
9PDPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
10PDDSPRDiscount FactorNumericGeneric Edit74 Allow NULL? 
11PDOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
12PDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
13PDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
14PDSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
15PDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
16PDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
17PDCOCompanyStringGeneric Edit50 Allow NULL? 
18PDOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
19PDOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
20PDOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
21PDOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
22PDRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
23PDRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
24PDRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
25PDRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
26PDDMCTAgreement Number - DistributionStringGeneric Edit120 Allow NULL? 
27PDDMCSAgreement Supplement - DistributionNumericGeneric Edit30 Allow NULL? 
28PDBALUContract Balances Updated Y/NCharacterGeneric Edit10 Allow NULL? 
29PDAN8Address NumberNumericUDC80 Allow NULL? 
30PDSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
31PDTRDJDate - Order/TransactionDateGeneric Edit60
32PDOPDJDate - Original Promised DeliveryDateGeneric Edit60
33PDADDJDate - Actual Ship DateDateGeneric Edit60
34PDPEFJDate - Price Effective DateDateGeneric Edit60
35PDCNDJDate - CancelDateGeneric Edit60
36PDPPDJDate - Promised ShipmentDateGeneric Edit60
37PDPSDJDate - Future Date 2DateGeneric Edit60
38PDDSVJDate - Service/TaxDateGeneric Edit60
39PDDGLDate - For G/L (and Voucher)DateGeneric Edit60
40PDPNPeriod Number - General LedgerNumericGeneric Edit20 Allow NULL? 
41PDVR01ReferenceStringGeneric Edit250 Allow NULL? 
42PDVR02Reference 2StringGeneric Edit250 Allow NULL? 
43PDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
44PDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
45PDAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
46PDLOCNLocationStringGeneric Edit200 Allow NULL? 
47PDLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
48PDFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
49PDTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
50PDFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
51PDTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
52PDDSC1DescriptionStringGeneric Edit300 Allow NULL? 
53PDDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
54PDLNTYLine TypeStringGeneric Edit20 Allow NULL? 
55PDNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
56PDLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
57PDRLITItem Number - Related (Kit)StringGeneric Edit80 Allow NULL? 
58PDPDS1Reporting Code 1 - SalesStringGeneric Edit30 Allow NULL? 
59PDPDS2Reporting Code 2 - SalesStringGeneric Edit30 Allow NULL? 
60PDPDS3Reporting Code 3 - SalesStringGeneric Edit30 Allow NULL? 
61PDPDS4Reporting Code 4 - SalesStringGeneric Edit30 Allow NULL? 
62PDPDS5Reporting Code 5 - SalesStringGeneric Edit30 Allow NULL? 
63PDPDP1Reporting Code 1 - PurchasingStringUDC (41 P1)30 Allow NULL? 
64PDPDP2Reporting Code 2 - PurchasingStringUDC (41 P2)30 Allow NULL? 
65PDPDP3Reporting Code 3 - PurchasingStringUDC (41 P3)30 Allow NULL? 
66PDPDP4Reporting Code 4 - PurchasingStringUDC (41 P4)30 Allow NULL? 
67PDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
68PDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152 Allow NULL? 
69PDUCHGUnits - On HoldNumericGeneric Edit152 Allow NULL? 
70PDUOPNUnits - OpenNumericGeneric Edit152 Allow NULL? 
71PDURECUnits - ReceivedNumericGeneric Edit152 Allow NULL? 
72PDCRECUnits - Cumulative ReceivedNumericGeneric Edit152 Allow NULL? 
73PDURLVUnits - RelievedNumericGeneric Edit152 Allow NULL? 
74PDOTQYOther Quantity (1/2)CharacterUDC10 Allow NULL? 
75PDPRRCAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
76PDACHGAmount - On HoldNumericGeneric Edit152 Allow NULL? 
77PDAOPNAmount - OpenNumericGeneric Edit152 Allow NULL? 
78PDARECAmount - ReceivedNumericGeneric Edit152 Allow NULL? 
79PDARLVAmount - RelievedNumericGeneric Edit152 Allow NULL? 
80PDFTN1Amount - Tax CommitmentNumericGeneric Edit152 Allow NULL? 
81PDTRLVAmount - Tax RelievedNumericGeneric Edit152 Allow NULL? 
82PDPROVPrice Override CodeCharacterGeneric Edit10 Allow NULL? 
83PDAMC3Unit Cost - PurchasingNumericGeneric Edit154 Allow NULL? 
84PDECSTAmount - Extended CostNumericGeneric Edit152 Allow NULL? 
85PDCSTOCost Override CodeCharacterGeneric Edit10 Allow NULL? 
86PDCSMPCosting Method - PurchasingCharacterGeneric Edit10 Allow NULL? 
87PDINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
88PDASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
89PDPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
90PDCLVLPricing Category LevelStringGeneric Edit30 Allow NULL? 
91PDCATNCatalogStringUDC (40 CN)80 Allow NULL? 
92PDTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
93PDEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
94PDTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
95PDATXTAssociated TextCharacterGeneric Edit10 Allow NULL? 
96PDCNIDContainer I.D.StringGeneric Edit200 Allow NULL? 
97PDCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
98PDNTRNature of TransactionStringUDC (00 NT)20 Allow NULL? 
99PDFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
100PDFRTCFreight Calculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
101PDZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
102PDFRATRate Code - Frieght/MiscStringUDC (41 RT)100 Allow NULL? 
103PDRATTRate Type - Freight/MiscCharacterGeneric Edit10 Allow NULL? 
104PDANBYBuyer NumberNumericGeneric Edit80 Allow NULL? 
105PDANCRCarrier NumberNumericGeneric Edit80 Allow NULL? 
106PDMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
107PDCOTConditions of TransportStringUDC (00 TC)30 Allow NULL? 
108PDSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
109PDSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
110PDUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
111PDPQORUnits - Primary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
112PDUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
113PDSQORUnits - Secondary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
114PDUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
115PDITWTUnit WeightNumericGeneric Edit154 Allow NULL? 
116PDWTUMWeight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
117PDITVLUnit VolumeNumericGeneric Edit154 Allow NULL? 
118PDVLUMVolume Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
119PDGLCG/L OffsetStringGeneric Edit40 Allow NULL? 
120PDCTRYCenturyNumericGeneric Edit20 Allow NULL? 
121PDFYFiscal YearNumericGeneric Edit20 Allow NULL? 
122PDSTTSLine StatusStringGeneric Edit20 Allow NULL? 
123PDRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
124PDFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
125PDFUF2Post QuantitiesCharacterGeneric Edit10 Allow NULL? 
126PDGRWTGross WeightNumericGeneric Edit154 Allow NULL? 
127PDGWUMGross Weight Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
128PDLTLedger TypesStringUDC (09 LT)20 Allow NULL? 
129PDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290 Allow NULL? 
130PDOBJObject AccountStringGeneric Edit60 Allow NULL? 
131PDSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
132PDASIDSerial NumberStringGeneric Edit250 Allow NULL? 
133PDCCMPCost Component NumberNumericGeneric Edit30 Allow NULL? 
134PDTAGTag - ReferenceStringGeneric Edit80 Allow NULL? 
135PDWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
136PDPLPlan NumberStringGeneric Edit40 Allow NULL? 
137PDELEVElevationStringGeneric Edit30 Allow NULL? 
138PDR001Category Code - G/L1StringUDC (09 01)30 Allow NULL? 
139PDRTNRRetainage RuleStringGeneric Edit30 Allow NULL? 
140PDLCODCode - Location Tax StatusStringUDC (46 LT)20 Allow NULL? 
141PDPURGPurge CodeCharacterGeneric Edit10 Allow NULL? 
142PDPROMProcessing ModeCharacterUDC (H40 PQ)10 Allow NULL? 
143PDFNLPClosed Item - As Of ProcessingCharacterGeneric Edit10 Allow NULL? 
144PDAVCHCode - Evaluated Receipt SettlementCharacterUDC (40 ER)10 Allow NULL? 
145PDPRPYPre-Payment (Y/N)CharacterGeneric Edit10 Allow NULL? 
146PDUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
147PDMATYType - Match TypeCharacterUDC (H40 MB)10 Allow NULL? 
148PDRTGCRouting Process (Y/N)CharacterGeneric Edit10 Allow NULL? 
149PDRCPFLeadtime Recalculated (Y/N)CharacterGeneric Edit10 Allow NULL? 
150PDPS01Transfer/Direct Ship FlagCharacterGeneric Edit10 Allow NULL? 
151PDPS02Purchase Order Status 02CharacterGeneric Edit10 Allow NULL? 
152PDPS03Purchase Order Status 03CharacterGeneric Edit10 Allow NULL? 
153PDPS04Purchase Order Status 04CharacterGeneric Edit10 Allow NULL? 
154PDPS05Purchase Order Status 05CharacterGeneric Edit10 Allow NULL? 
155PDPS06Purchase Order Status 06CharacterGeneric Edit10 Allow NULL? 
156PDPS07Purchase Order Status 07CharacterGeneric Edit10 Allow NULL? 
157PDPS08Purchase Order Status 08CharacterGeneric Edit10 Allow NULL? 
158PDPS09Purchase Order Status 09CharacterGeneric Edit10 Allow NULL? 
159PDPS10Purchase Order Status 10CharacterUDC (00 XS)10 Allow NULL? 
160PDCRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
161PDARTGCode - Approval RoutingStringGeneric Edit120 Allow NULL? 
162PDCORDChange Order NumberNumericGeneric Edit30 Allow NULL? 
163PDCHDTChange Order TypeStringUDC (00 DT)20 Allow NULL? 
164PDDOCCDocument (Change Order #)NumericGeneric Edit80 Allow NULL? 
165PDCHLNChange Order Line NumberNumericGeneric Edit73 Allow NULL? 
166PDCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
167PDCRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
168PDFRRCAmount - Foreign Unit PriceNumericGeneric Edit154 Allow NULL? 
169PDFEAAmount - Foreign Extended PriceNumericGeneric Edit152 Allow NULL? 
170PDFUCAmount - Foreign Unit CostNumericGeneric Edit154 Allow NULL? 
171PDFECAmount - Foreign Extended CostNumericGeneric Edit152 Allow NULL? 
172PDFCHGAmount - Foreign Changed AmountNumericGeneric Edit152 Allow NULL? 
173PDFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
174PDFRECAmount - Received ForeignNumericGeneric Edit152 Allow NULL? 
175PDURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
176PDURDTUser Reserved DateDateGeneric Edit60
177PDURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
178PDURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
179PDURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
180PDTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
181PDUSERUser IDStringGeneric Edit100 Allow NULL? 
182PDPIDProgram IDStringGeneric Edit100 Allow NULL? 
183PDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
184PDUPMJDate - UpdatedDateGeneric Edit60
185PDTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
186PDSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
187PDPRJMProject NumberNumericGeneric Edit80 Allow NULL? 
188PDOSFXDocument Pay Item - OriginalStringGeneric Edit30 Allow NULL? 
189PDMCLNMatrix Control Line NumberNumericGeneric Edit63 Allow NULL? 
190PDDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
191PDDLEJLot Effectivity DateDateGeneric Edit60
192PDVR03ReferenceStringGeneric Edit250 Allow NULL? 
193PDPMTNPromotion IDStringGeneric Edit120 Allow NULL? 
194PDUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
195PDSPRLabor Premium SearchCharacterGeneric Edit10 Allow NULL? 

TOP812 | 43 | F43080 INDEXES

NumberDescription
1Doc No Order Type + 1 (Primary/Unique)
ElementAliasDescriptionSequence
1DCTOOrder TypeAscending