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
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

160 COLUMNS | 2 INDEXES | Print definition?920 | 17 | F3111Z2 TABLE

17: Customer Service Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F3111Z2WP1602Warranty Claim/Supplier Recovery processingBatch Input Files17: Customer Service 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 WPEDUS, WPEDBT, WPEDTN, WPEDLN, WPEDCT, WPTYTN, WPEDFT, WPEDDT, WPDRIN, WPEDDL, WPEDSP, WPPNID, WPTNAC, WPDOCO, WPDCTO, WPSFXO, WPTBM, WPFORQ, WPITC, WPCOBY, WPCOTY, WPCPNT, WPFRMP, WPTHRP, WPFRGD, WPTHGD, WPRKCO, WPRORN, WPRCTO, WPRLLN, WPOPSQ, WPBSEQ, WPRSCP, WPSCRP, WPREWP, WPASIP, WPCPYP, WPSTPP, WPLOVD, WPCPIT, WPCPIL, WPCPIA, WPCMCU, WPDSC1, WPDSC2, WPLOCN, WPLOTN, WPAN8, WPLNTY, WPSERN, WPTRDJ, WPDRQJ, WPUORG, WPTRQT, WPSOCN, WPSOBK, WPCTS1, WPQNTA, WPUM, WPEA, WPRTG, WPMTST, WPDCT, WPSHNO, WPMCU, WPOMCU, WPOBJ, WPSUB, WPCMRV, WPSTRX, WPPARS, WPCOMM, WPUKID, WPURCD, WPURDT, WPURAT, WPURAB, WPURRF, WPTORG, WPPOC, WPVEND, WPCTS4, WPCTS7, WPCTS8, WPUSER, WPPID, WPJOBN, WPUPMJ, WPTDAY, WPGLD, WPSBFL, WPAING, WPSSTQ, WPUOM2, WPAPSC, WPPSN, WPDLEJ, WPCOST, WPCHPP, WPCPNB, WPBSEQAN, WPESUNC, WPESUNB, WPESUNP, WPEPAAP, WPAMTO, WPEBILL, WPACUNC, WPACUNB, WPACUNP, WPAMTA, WPTOTB, WPPAAP, WPCLAMT, WPPAYAB, WPBILL, WPDTPAY, WPDTBIL, WPGLCNC, WPGLCCV, WPENTCK, WPVR02, WPASN4, WPASN2, WPPCOVR, WPMTHPR, WPSAID, WPPRODF, WPPRODM, WPCOVGR, WPPMTHP, WPPYPRT, WPCRDC, WPBCRCD, WPBCRR, WPBCRRM, WPFESUNB, WPFEBILL, WPFACUNB, WPFTOTB, WPPCRCD, WPPCRR, WPPCRRM, WPFESUNP, WPFEPAAP, WPFACUNP, WPFPAAP, WPFAILCD, WPRETPOL, WPDTSUB, WPTMSUB, WPCSLPRT, WPMCUCSL, WPSRVEND, WPRLOT, WPTAX1, WPUKIDP, WPVMRS31, WPVMRS32, WPVMRS33 FROM F3111Z2

TOP920 | 17 | F3111Z2 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WPEDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2WPEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
3WPEDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
4WPEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
5WPEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6WPTYTNType - TransactionStringUDC (00 TT)80 Allow NULL? 
7WPEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
8WPEDDTEDI - Transmission DateDateGeneric Edit60
9WPDRINDirection IndicatorCharacterUDC (00 DN)10 Allow NULL? 
10WPEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
11WPEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
12WPPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
13WPTNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
14WPDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
15WPDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
16WPSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
17WPTBMType Bill of MaterialStringUDC (40 TB)30 Allow NULL? 
18WPFORQFixed or Variable QuantityCharacterUDC (H40 FO)10 Allow NULL? 
19WPITCIssue Type CodeCharacterUDC (41 IT)10 Allow NULL? 
20WPCOBYCo-Products/By-Products/IntermediateCharacterUDC (H40 CO)10 Allow NULL? 
21WPCOTYComponent TypeCharacterUDC (H40 CP)10 Allow NULL? 
22WPCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
23WPFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
24WPTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
25WPFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
26WPTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
27WPRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
28WPRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
29WPRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
30WPRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
31WPOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
32WPBSEQSequence - Bubble SequenceNumericGeneric Edit50 Allow NULL? 
33WPRSCPResource PercentNumericGeneric Edit52 Allow NULL? 
34WPSCRPPercent - Percent of ScrapNumericGeneric Edit52 Allow NULL? 
35WPREWPPercent - ReworkNumericGeneric Edit52 Allow NULL? 
36WPASIPPercent - As isNumericGeneric Edit52 Allow NULL? 
37WPCPYPPercent - Cumulative Planned YieldNumericGeneric Edit52 Allow NULL? 
38WPSTPPOperation Scrap PercentNumericGeneric Edit52 Allow NULL? 
39WPLOVDLeadtime Offset DaysNumericGeneric Edit60 Allow NULL? 
40WPCPITComponent Item Number - ShortNumericGeneric Edit80 Allow NULL? 
41WPCPILComponent 2nd Item NumberStringGeneric Edit250 Allow NULL? 
42WPCPIAComponent 3rd Item NumberStringGeneric Edit250 Allow NULL? 
43WPCMCUComponent BranchStringGeneric Edit120 Allow NULL? 
44WPDSC1DescriptionStringGeneric Edit300 Allow NULL? 
45WPDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
46WPLOCNLocationStringGeneric Edit200 Allow NULL? 
47WPLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
48WPAN8Address NumberNumericGeneric Edit80 Allow NULL? 
49WPLNTYLine TypeStringGeneric Edit20 Allow NULL? 
50WPSERNSerial Number - LotStringGeneric Edit300 Allow NULL? 
51WPTRDJDate - Order/TransactionDateGeneric Edit60
52WPDRQJDate - RequestedDateGeneric Edit60
53WPUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
54WPTRQTQuantity AvailableNumericGeneric Edit150 Allow NULL? 
55WPSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
56WPSOBKUnits - Qty Backordered/HeldNumericGeneric Edit150 Allow NULL? 
57WPCTS1Hours - Unaccounted Direct LaborNumericGeneric Edit152 Allow NULL? 
58WPQNTAUnits - Quantity CommitedNumericGeneric Edit150 Allow NULL? 
59WPUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
60WPEAAmount - Estimated CostNumericGeneric Edit152 Allow NULL? 
61WPRTGRoute Sheet (N)CharacterGeneric Edit10 Allow NULL? 
62WPMTSTMaterial Status Code W.O.StringUDC (31 MS)20 Allow NULL? 
63WPDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
64WPSHNOMessage NumberStringGeneric Edit100 Allow NULL? 
65WPMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
66WPOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
67WPOBJObject AccountStringGeneric Edit60 Allow NULL? 
68WPSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
69WPCMRVComponent Revision LevelStringGeneric Edit30 Allow NULL? 
70WPSTRXDate - Completion (Julian)DateGeneric Edit60
71WPPARSNumber - Parent WO NumberStringGeneric Edit80 Allow NULL? 
72WPCOMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
73WPUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
74WPURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
75WPURDTUser Reserved DateDateGeneric Edit60
76WPURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
77WPURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
78WPURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
79WPTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
80WPPOCIssue and ReceiptCharacterUDC (43 IR)10 Allow NULL? 
81WPVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
82WPCTS4Amount - Unaccounted Direct LaborNumericGeneric Edit152 Allow NULL? 
83WPCTS7Amount - Unaccounted ScrapNumericGeneric Edit152 Allow NULL? 
84WPCTS8Units - Unaccounted ScrapNumericGeneric Edit150 Allow NULL? 
85WPUSERUser IDStringGeneric Edit100 Allow NULL? 
86WPPIDProgram IDStringGeneric Edit100 Allow NULL? 
87WPJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
88WPUPMJDate - UpdatedDateGeneric Edit60
89WPTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
90WPGLDG/L DateDateGeneric Edit60
91WPSBFLParts List Substitute FlagCharacterGeneric Edit10 Allow NULL? 
92WPAINGActive Ingredient FlagCharacterGeneric Edit10 Allow NULL? 
93WPSSTQSecondary Quantity Issued/CompletedNumericGeneric Edit150 Allow NULL? 
94WPUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
95WPAPSCConstraints FlagCharacterUDC (42 AC)10 Allow NULL? 
96WPPSNPick Slip NumberNumericGeneric Edit80 Allow NULL? 
97WPDLEJLot Effectivity DateDateGeneric Edit60
98WPCOSTCost ComponentStringUDC (30 CA)30 Allow NULL? 
99WPCHPPCritical Hold PropagationCharacterGeneric Edit10 Allow NULL? 
100WPCPNBComponent Line Number BOMNumericGeneric Edit82 Allow NULL? 
101WPBSEQANBubble Sequence Alpha NumericStringGeneric Edit50 Allow NULL? 
102WPESUNCEstimated Unit CostNumericGeneric Edit154 Allow NULL? 
103WPESUNBEstimated Unit BillableNumericGeneric Edit154 Allow NULL? 
104WPESUNPEstimated Unit PayableNumericGeneric Edit154 Allow NULL? 
105WPEPAAPEstimated Payment AmountNumericGeneric Edit152 Allow NULL? 
106WPAMTOAmount - EstimatedNumericGeneric Edit152 Allow NULL? 
107WPEBILLEstimated AmountNumericGeneric Edit152 Allow NULL? 
108WPACUNCActual Unit CostNumericGeneric Edit154 Allow NULL? 
109WPACUNBActual Unit BillableNumericGeneric Edit154 Allow NULL? 
110WPACUNPActual Unit PayableNumericGeneric Edit154 Allow NULL? 
111WPAMTAAmount - ActualNumericGeneric Edit152 Allow NULL? 
112WPTOTBTotal BilledNumericGeneric Edit152 Allow NULL? 
113WPPAAPPayment AmountNumericGeneric Edit152 Allow NULL? 
114WPCLAMTClaim AmountNumericGeneric Edit152 Allow NULL? 
115WPPAYABPayable (Y/N)CharacterUDC (17 YN)10 Allow NULL? 
116WPBILLBillable (Y/N)CharacterUDC (H00 BI)10 Allow NULL? 
117WPDTPAYDate - PaidDateGeneric Edit60
118WPDTBILDate - BilledDateGeneric Edit60
119WPGLCNCCategory - G/L Non-CoveredStringUDC (41 9)40 Allow NULL? 
120WPGLCCVCategory - G/L CoveredStringUDC (41 9)40 Allow NULL? 
121WPENTCKEntitlement CheckStringUDC (17 ER)30 Allow NULL? 
122WPVR02Reference 2StringGeneric Edit250 Allow NULL? 
123WPASN4Price and Adjustment Schedule-FourStringUDC (40 AS)80 Allow NULL? 
124WPASN2Price and Adjustment Schedule-ServiceStringUDC (40 AS)80 Allow NULL? 
125WPPCOVRPercent CoveredNumericGeneric Edit52 Allow NULL? 
126WPMTHPRMethod of PricingCharacterUDC (17 MP)10 Allow NULL? 
127WPSAIDService Address NumberNumericGeneric Edit80 Allow NULL? 
128WPPRODFProduct FamilyStringUDC (17 PA)80 Allow NULL? 
129WPPRODMProduct ModelStringUDC (17 PM)80 Allow NULL? 
130WPCOVGRCoverage GroupStringUDC (17 CG)80 Allow NULL? 
131WPPMTHPPay Pricing MethodCharacterUDC (17 MP)10 Allow NULL? 
132WPPYPRTPay Service Provider for PartsCharacterUDC (17 YN)10 Allow NULL? 
133WPCRDCCurrency Code - ToStringGeneric Edit30 Allow NULL? 
134WPBCRCDBillable CurrencyStringGeneric Edit30 Allow NULL? 
135WPBCRRBillable Exchange RateNumericGeneric Edit150 Allow NULL? 
136WPBCRRMBillable Currency ModeCharacterUDC (H00 CY)10 Allow NULL? 
137WPFESUNBForeign Estimated Billable Unit RateNumericGeneric Edit154 Allow NULL? 
138WPFEBILLForeign Estimated Billable AmountNumericGeneric Edit152 Allow NULL? 
139WPFACUNBForeign Actual Billable Unit RateNumericGeneric Edit154 Allow NULL? 
140WPFTOTBForeign Actual Billable AmountNumericGeneric Edit152 Allow NULL? 
141WPPCRCDPayable CurrencyStringGeneric Edit30 Allow NULL? 
142WPPCRRPayable Exchange RateNumericGeneric Edit150 Allow NULL? 
143WPPCRRMPayable Currency ModeCharacterUDC (H00 CY)10 Allow NULL? 
144WPFESUNPForeign Estimated Payable Unit RateNumericGeneric Edit154 Allow NULL? 
145WPFEPAAPForeign Estimated Payable AmountNumericGeneric Edit152 Allow NULL? 
146WPFACUNPForeign Actual Payable Unit RateNumericGeneric Edit154 Allow NULL? 
147WPFPAAPForeign Actual Payable AmountNumericGeneric Edit152 Allow NULL? 
148WPFAILCDDefect CodeStringUDC (17 DC)80 Allow NULL? 
149WPRETPOLReturn PolicyCharacterUDC (17 RT)10 Allow NULL? 
150WPDTSUBDate SubmittedDateGeneric Edit60
151WPTMSUBTime SubmittedNumericGeneric Edit60 Allow NULL? 
152WPCSLPRTCausal PartNumericGeneric Edit80 Allow NULL? 
153WPMCUCSLCausal Part Business UnitStringGeneric Edit120 Allow NULL? 
154WPSRVENDSupplier Recovery Vendor NumberNumericGeneric Edit80 Allow NULL? 
155WPRLOTSupplier Lot NumberStringGeneric Edit300 Allow NULL? 
156WPTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
157WPUKIDPUnique Key PricingNumericGeneric Edit150 Allow NULL? 
158WPVMRS31Component Code - SystemStringUDC (17 C6)20 Allow NULL? 
159WPVMRS32Component Code - AssemblyStringUDC (17 C7)80 Allow NULL? 
160WPVMRS33Component Code - PartStringUDC (17 C8)100 Allow NULL? 

TOP920 | 17 | F3111Z2 INDEXES

NumberDescription
1User ID Batch Transaction +A (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending
5UKIDUnique Key ID (Internal)Ascending
2User ID Batch Transaction +B
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending
5OPSQSequence Number - OperationsAscending