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

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
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
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

71 COLUMNS | 1 INDEXES | Print definition?920 | 17 | F31172 TABLE

17: Customer Service Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F31172WS711Routing Instructions - ExtensionSecondary Master 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 WSDOCO, WSOPSQ, WSOPSC, WSMCU, WSPAYAB, WSBILL, WSACRTB, WSACRTP, WSEBILL, WSAMTA, WSAMTO, WSESRTB, WSESRTP, WSEPAAP, WSTOTB, WSCLAMT, WSDTBIL, WSDTPAY, WSPAAP, WSLBR1, WSD2J, WSSTTI, WSEPETM, WSCOST, WSENTCK, WSGLCNC, WSGLCCV, WSUSER, WSPID, WSJOBN, WSUPMJ, WSTDAY, WSASN4, WSASN2, WSPCOVR, WSMTHPR, WSSAID, WSPRODF, WSPRODM, WSCOVGR, WSPMTHP, WSPYPRT, WSCRDC, WSBCRCD, WSBCRR, WSBCRRM, WSFESUNB, WSFEBILL, WSFACUNB, WSFTOTB, WSPCRCD, WSPCRR, WSPCRRM, WSFESUNP, WSFEPAAP, WSFACUNP, WSFPAAP, WSDTSUB, WSTMSUB, WSCSLPRT, WSINVREQ, WSINVREC, WSVMRS32, WSMCUCSL, WSRLOT, WSSRVEND, WSUKIDP, WSFAILCD, WSVMRS31, WSVMRS33, WSLSRCE FROM F31172

TOP920 | 17 | F31172 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WSDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2WSOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
3WSOPSCType Operation CodeStringUDC (30 OT)20 Allow NULL? 
4WSMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
5WSPAYABPayable (Y/N)CharacterUDC (17 YN)10 Allow NULL? 
6WSBILLBillable (Y/N)CharacterUDC (H00 BI)10 Allow NULL? 
7WSACRTBActual Billable RateNumericGeneric Edit154 Allow NULL? 
8WSACRTPActual Payable RateNumericGeneric Edit94 Allow NULL? 
9WSEBILLEstimated AmountNumericGeneric Edit152 Allow NULL? 
10WSAMTAAmount - ActualNumericGeneric Edit152 Allow NULL? 
11WSAMTOAmount - EstimatedNumericGeneric Edit152 Allow NULL? 
12WSESRTBEstimated Billable RateNumericGeneric Edit154 Allow NULL? 
13WSESRTPEstimated Payable RateNumericGeneric Edit154 Allow NULL? 
14WSEPAAPEstimated Payment AmountNumericGeneric Edit152 Allow NULL? 
15WSTOTBTotal BilledNumericGeneric Edit152 Allow NULL? 
16WSCLAMTClaim AmountNumericGeneric Edit152 Allow NULL? 
17WSDTBILDate - BilledDateGeneric Edit60
18WSDTPAYDate - PaidDateGeneric Edit60
19WSPAAPPayment AmountNumericGeneric Edit152 Allow NULL? 
20WSLBR1Rate - Labor Per HourNumericGeneric Edit152 Allow NULL? 
21WSD2JDate - Actual StartDateGeneric Edit60
22WSSTTITime - Start (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
23WSEPETMEstimate Time - Ending (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
24WSCOSTCost ComponentStringUDC (30 CA)30 Allow NULL? 
25WSENTCKEntitlement CheckStringUDC (17 ER)30 Allow NULL? 
26WSGLCNCCategory - G/L Non-CoveredStringUDC (41 9)40 Allow NULL? 
27WSGLCCVCategory - G/L CoveredStringUDC (41 9)40 Allow NULL? 
28WSUSERUser IDStringGeneric Edit100 Allow NULL? 
29WSPIDProgram IDStringGeneric Edit100 Allow NULL? 
30WSJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
31WSUPMJDate - UpdatedDateGeneric Edit60
32WSTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
33WSASN4Price and Adjustment Schedule-FourStringUDC (40 AS)80 Allow NULL? 
34WSASN2Price and Adjustment Schedule-ServiceStringUDC (40 AS)80 Allow NULL? 
35WSPCOVRPercent CoveredNumericGeneric Edit52 Allow NULL? 
36WSMTHPRMethod of PricingCharacterUDC (17 MP)10 Allow NULL? 
37WSSAIDService Address NumberNumericGeneric Edit80 Allow NULL? 
38WSPRODFProduct FamilyStringUDC (17 PA)80 Allow NULL? 
39WSPRODMProduct ModelStringUDC (17 PM)80 Allow NULL? 
40WSCOVGRCoverage GroupStringUDC (17 CG)80 Allow NULL? 
41WSPMTHPPay Pricing MethodCharacterUDC (17 MP)10 Allow NULL? 
42WSPYPRTPay Service Provider for PartsCharacterUDC (17 YN)10 Allow NULL? 
43WSCRDCCurrency Code - ToStringGeneric Edit30 Allow NULL? 
44WSBCRCDBillable CurrencyStringGeneric Edit30 Allow NULL? 
45WSBCRRBillable Exchange RateNumericGeneric Edit150 Allow NULL? 
46WSBCRRMBillable Currency ModeCharacterUDC (H00 CY)10 Allow NULL? 
47WSFESUNBForeign Estimated Billable Unit RateNumericGeneric Edit154 Allow NULL? 
48WSFEBILLForeign Estimated Billable AmountNumericGeneric Edit152 Allow NULL? 
49WSFACUNBForeign Actual Billable Unit RateNumericGeneric Edit154 Allow NULL? 
50WSFTOTBForeign Actual Billable AmountNumericGeneric Edit152 Allow NULL? 
51WSPCRCDPayable CurrencyStringGeneric Edit30 Allow NULL? 
52WSPCRRPayable Exchange RateNumericGeneric Edit150 Allow NULL? 
53WSPCRRMPayable Currency ModeCharacterUDC (H00 CY)10 Allow NULL? 
54WSFESUNPForeign Estimated Payable Unit RateNumericGeneric Edit154 Allow NULL? 
55WSFEPAAPForeign Estimated Payable AmountNumericGeneric Edit152 Allow NULL? 
56WSFACUNPForeign Actual Payable Unit RateNumericGeneric Edit154 Allow NULL? 
57WSFPAAPForeign Actual Payable AmountNumericGeneric Edit152 Allow NULL? 
58WSDTSUBDate SubmittedDateGeneric Edit60
59WSTMSUBTime SubmittedNumericGeneric Edit60 Allow NULL? 
60WSCSLPRTCausal PartNumericGeneric Edit80 Allow NULL? 
61WSINVREQInvoice RequiredCharacterUDC (17 YN)10 Allow NULL? 
62WSINVRECInvoice ReceivedCharacterUDC (17 YN)10 Allow NULL? 
63WSVMRS32Component Code - AssemblyStringUDC (17 C7)80 Allow NULL? 
64WSMCUCSLCausal Part Business UnitStringGeneric Edit120 Allow NULL? 
65WSRLOTSupplier Lot NumberStringGeneric Edit300 Allow NULL? 
66WSSRVENDSupplier Recovery Vendor NumberNumericGeneric Edit80 Allow NULL? 
67WSUKIDPUnique Key PricingNumericGeneric Edit150 Allow NULL? 
68WSFAILCDDefect CodeStringUDC (17 DC)80 Allow NULL? 
69WSVMRS31Component Code - SystemStringUDC (17 C6)20 Allow NULL? 
70WSVMRS33Component Code - PartStringUDC (17 C8)100 Allow NULL? 
71WSLSRCESource for Labor LineCharacterUDC (17 LS)10 Allow NULL? 

TOP920 | 17 | F31172 INDEXES

NumberDescription
1OrderNo OperationSeqNo +A (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2OPSQSequence Number - OperationsAscending
3OPSCType Operation CodeAscending
4MCUBusiness UnitAscending