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

103 columns | Print definition?812 | RCTO | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00092Supplemental Data13T3RCTORelated PO/SO/WO Order TypeStringUDC20
TOP12: Fixed Assets
2F1217Equipment Master Extension17WRRCTORelated PO/SO/WO Order TypeStringUDC20
3F1217PEquipment Master Extension Purge Table17WRRCTORelated PO/SO/WO Order TypeStringUDC20
4F1217Z1Unedited Equipment Tag Transactions30WRRCTORelated PO/SO/WO Order TypeStringUDC20
5F1217Z2Unedited Equipment Tag Transactions30WRRCTORelated PO/SO/WO Order TypeStringUDC20
TOP17: Customer Service Management
6F3111Z2Warranty Claim/Supplier Recovery processing29WPRCTORelated PO/SO/WO Order TypeStringUDC20
7F3112Z2Warranty Claim/Supplier Recovery processing78WLRCTORelated PO/SO/WO Order TypeStringUDC20
8F4801Z2Warranty Claim/Supplier Recovery processing23WSRCTORelated PO/SO/WO Order TypeStringUDC20
TOP17C: Call Management
9F1755Customer Call Master77ZARCTORelated PO/SO/WO Order TypeStringUDC20
TOP31: Shop Floor Control
10F3111Work Order Parts List16WMRCTORelated PO/SO/WO Order TypeStringUDC20
11F3111SPurge - Shop Floor Parts List16WMRCTORelated PO/SO/WO Order TypeStringUDC20
12F3111Z1Outbound Work Order Parts List29SZRCTORelated PO/SO/WO Order TypeStringUDC20
13F3112Work Order Routing66WLRCTORelated PO/SO/WO Order TypeStringUDC20
14F3112SPurge Shop Floor Control Routing Instructions66WLRCTORelated PO/SO/WO Order TypeStringUDC20
15F3112Z1Outbound Work Order Routings78SZRCTORelated PO/SO/WO Order TypeStringUDC20
16F3118Shortage Maintenance Master File12WNRCTORelated PO/SO/WO Order TypeStringUDC20
17F31UI006Line Scheduling Workbench - Work File38LSRCTORelated PO/SO/WO Order TypeStringUDC20
18F4801SPurge - Work Order Master file4WARCTORelated PO/SO/WO Order TypeStringUDC20
19F4801Z1Outbound Work Order Header23SYRCTORelated PO/SO/WO Order TypeStringUDC20
TOP31P: Engineer To Order
20F31P10Project Quote Header22PQRCTORelated PO/SO/WO Order TypeStringUDC20
21F31P11Project Quote Detail31QPRCTORelated PO/SO/WO Order TypeStringUDC20
TOP34: Requirements Planning
22F3412MPS/MRP/DRP Lower Level Requirements File12MWRCTORelated PO/SO/WO Order TypeStringUDC20
TOP37: Quality Management
23F3711Test Results5TRRCTORelated PO/SO/WO Order TypeStringUDC20
24F3711Z1Test Results Unedited Transaction Table18SZRCTORelated PO/SO/WO Order TypeStringUDC20
25F37900Certificate of Analysis (COA) Extract5TRRCTORelated PO/SO/WO Order TypeStringUDC20
TOP40: Inventory/OP Base
26F4001ZBatch Receiver File - Order Headings35SYRCTORelated PO/SO/WO Order TypeStringUDC20
27F40051Return Material Authorization2RDRCTORelated PO/SO/WO Order TypeStringUDC20
28F40052Return Material Authorization Defaults1RVRCTORelated PO/SO/WO Order TypeStringUDC20
29F4011ZBatch Receiver File - Order Details27SZRCTORelated PO/SO/WO Order TypeStringUDC20
30F4201Z1Sales Order Header Unedited Transaction File25SYRCTORelated PO/SO/WO Order TypeStringUDC20
31F4211Z1Sales Order Detail Unedited Transaction File27SZRCTORelated PO/SO/WO Order TypeStringUDC20
TOP41: Inventory Management
32F4118Container Deposit File10CNRCTORelated PO/SO/WO Order TypeStringUDC20
33F41181Container Transaction File21CMRCTORelated PO/SO/WO Order TypeStringUDC20
TOP42: Sales Management
34F4201Sales Order Header File12SHRCTORelated PO/SO/WO Order TypeStringUDC20
35F42019Sales Order Header History File12SHRCTORelated PO/SO/WO Order TypeStringUDC20
36F4211Sales Order Detail File14SDRCTORelated PO/SO/WO Order TypeStringUDC20
37F42119Sales Order History File14SDRCTORelated PO/SO/WO Order TypeStringUDC20
38F42199S.O. Detail Ledger File14SLRCTORelated PO/SO/WO Order TypeStringUDC20
39F42565Invoice Print File39IWRCTORelated PO/SO/WO Order TypeStringUDC20
40F42UI01SO Header Cache File (MBF)17ZHRCTORelated PO/SO/WO Order TypeStringUDC20
41F42UI11SO Detail Cache File (MBF)18ZDRCTORelated PO/SO/WO Order TypeStringUDC20
42F42UI520Pick Slips Header File36S8RCTORelated PO/SO/WO Order TypeStringUDC20
43F42UI521Pick Slips Detail File14S9RCTORelated PO/SO/WO Order TypeStringUDC20
TOP43: Procurement
44F4301Purchase Order Header11PHRCTORelated PO/SO/WO Order TypeStringUDC20
45F4301ZPO Header Work File15PARCTORelated PO/SO/WO Order TypeStringUDC20
46F4301Z1Purchase Order Header Unedited Transaction Table24SYRCTORelated PO/SO/WO Order TypeStringUDC20
47F43080Approvals Fields Constants24PDRCTORelated PO/SO/WO Order TypeStringUDC20
48F4311Purchase Order Detail File14PDRCTORelated PO/SO/WO Order TypeStringUDC20
49F4311ZPurchase Order Generator File18PWRCTORelated PO/SO/WO Order TypeStringUDC20
50F4311Z1Purchase Order Detail Unedited Transaction Table27SZRCTORelated PO/SO/WO Order TypeStringUDC20
51F43199P.O. Detail Ledger File - Flexible Version14OLRCTORelated PO/SO/WO Order TypeStringUDC20
52F43UI50DPO Print Detail Work File46PWRCTORelated PO/SO/WO Order TypeStringUDC20
53F43UI50HPO Print Header Work File41PARCTORelated PO/SO/WO Order TypeStringUDC20
TOP43E: Requisition Self Service
54F43E121eRequisition Receiver file10ERRCTORelated PO/SO/WO Order TypeStringUDC20
TOP43Q: Strategic Sourcing
55F43Q50Analyze Event Header14AVRCTORelated PO/SO/WO Order TypeStringUDC20
TOP45: Advanced Pricing
56F4079Rebate Transaction Detail21SVRCTORelated PO/SO/WO Order TypeStringUDC20
57F4576Z1Ship and Debit Claims Unedited Transaction Table131Z1RCTORelated PO/SO/WO Order TypeStringUDC20
TOP47: Electronic Commerce
58F47011EDI Purchase Order Header - Inbound30SYRCTORelated PO/SO/WO Order TypeStringUDC20
59F47012EDI Purchase Order Detail - Inbound28SZRCTORelated PO/SO/WO Order TypeStringUDC20
60F47016EDI Purchase Order Header - Outbound26SYRCTORelated PO/SO/WO Order TypeStringUDC20
61F47017EDI Purchase Order Detail - Outbound28SZRCTORelated PO/SO/WO Order TypeStringUDC20
62F47021EDI P.O. Acknowledgment Header - Inbound26SYRCTORelated PO/SO/WO Order TypeStringUDC20
63F47022EDI P.O. Acknowledgment Detail - Inbound28SZRCTORelated PO/SO/WO Order TypeStringUDC20
64F47026EDI P.O. Acknowledgment Header - Outbound27SYRCTORelated PO/SO/WO Order TypeStringUDC20
65F47027EDI P.O. Acknowledgment Detail - Outbound28SZRCTORelated PO/SO/WO Order TypeStringUDC20
66F47031EDI Shipping Notice Header - Inbound27SYRCTORelated PO/SO/WO Order TypeStringUDC20
67F47032EDI Shipping Notice Detail - Inbound31SZRCTORelated PO/SO/WO Order TypeStringUDC20
68F47037EDI Shipping Notice Detail - Outbound31SZRCTORelated PO/SO/WO Order TypeStringUDC20
69F470371EDI Shipping Notice Detail - Outbound31SZRCTORelated PO/SO/WO Order TypeStringUDC20
70F47046EDI Invoice Header (Sales) - Outbound27SYRCTORelated PO/SO/WO Order TypeStringUDC20
71F47047EDI Invoice Detail (Sales) - Outbound28SZRCTORelated PO/SO/WO Order TypeStringUDC20
72F47071EDI Receiving Advice Header - Inbound27SYRCTORelated PO/SO/WO Order TypeStringUDC20
73F47072EDI Receiving Advice Detail - Inbound29SZRCTORelated PO/SO/WO Order TypeStringUDC20
74F47076EDI Receiving Advice Header - Outbound27SYRCTORelated PO/SO/WO Order TypeStringUDC20
75F47077EDI Receiving Advice Detail - Outbound29SZRCTORelated PO/SO/WO Order TypeStringUDC20
76F47091EDI Request for Quote Header - Inbound30SYRCTORelated PO/SO/WO Order TypeStringUDC20
77F47092EDI Request for Quote Detail - Inbound28SZRCTORelated PO/SO/WO Order TypeStringUDC20
78F47096EDI Request for Quote Header - Outbound26SYRCTORelated PO/SO/WO Order TypeStringUDC20
79F47097EDI Request for Quote Detail - Outbound28SZRCTORelated PO/SO/WO Order TypeStringUDC20
80F47101EDI Response to RFQ Header - Inbound26SYRCTORelated PO/SO/WO Order TypeStringUDC20
81F47102EDI Response to RFQ Detail - Inbound28SZRCTORelated PO/SO/WO Order TypeStringUDC20
82F47106EDI Response to RFQ Header - Outbound27SYRCTORelated PO/SO/WO Order TypeStringUDC20
83F47107EDI Response to RFQ Detail - Outbound28SZRCTORelated PO/SO/WO Order TypeStringUDC20
84F47131EDI Purchase Order Change Header - Inbound27SYRCTORelated PO/SO/WO Order TypeStringUDC20
85F47132EDI Purchase Order Change Detail - Inbound29SZRCTORelated PO/SO/WO Order TypeStringUDC20
86F47136EDI Purchase Order Change Header - Outbound26SYRCTORelated PO/SO/WO Order TypeStringUDC20
87F47137EDI Purchase Order Change Detail - Outbound29SZRCTORelated PO/SO/WO Order TypeStringUDC20
88F47141EDI P.O. Change Acknowledgment Header - Inbound27SYRCTORelated PO/SO/WO Order TypeStringUDC20
89F47142EDI P.O. Change Acknowledgment Detail - Inbound30SZRCTORelated PO/SO/WO Order TypeStringUDC20
90F47146EDI P.O. Change Acknowledgment Header - Outbound28SYRCTORelated PO/SO/WO Order TypeStringUDC20
91F47147EDI P.O. Change Acknowledgment Detail - Outbound30SZRCTORelated PO/SO/WO Order TypeStringUDC20
92F47156EDI Shipping Schedule Header - Outbound27SYRCTORelated PO/SO/WO Order TypeStringUDC20
93F47157EDI Shipping Schedule Detail - Outbound28SZRCTORelated PO/SO/WO Order TypeStringUDC20
TOP48: Work Order Processing
94F4801Work Order Master File4WARCTORelated PO/SO/WO Order TypeStringUDC20
95F48092WO Supplemental DB User Defined11W8RCTORelated PO/SO/WO Order TypeStringUDC20
96F48UI001X4801 Master Business Function Workfile7WARCTORelated PO/SO/WO Order TypeStringUDC20
TOP89: Conversion Programs
97F43199ATemp F43199 for ERP 9.0 Upgrade14OLRCTORelated PO/SO/WO Order TypeStringUDC20
TOPF31: Lean Transactions
98FF31111Lean Transaction Parts List19PLRCTORelated PO/SO/WO Order TypeStringUDC20
99FF31111SPurge - Lean Transaction Parts List19PRRCTORelated PO/SO/WO Order TypeStringUDC20
100FF31112Routing Transaction Table63EHRCTORelated PO/SO/WO Order TypeStringUDC20
101FF31112SPurge - Routing Transaction Table63ETRCTORelated PO/SO/WO Order TypeStringUDC20
102FF31113Lean Transaction Labor Detail36LDRCTORelated PO/SO/WO Order TypeStringUDC20
103FF31113SPurge - Lean Transaction Labor Detail36LRRCTORelated PO/SO/WO Order TypeStringUDC20

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 00 / DT (Document Type - All Documents) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1        $PSecurity WithholdingsY
2        $QGeneral SUSSY
3        % Percentage Journal EntryN
4        AJService Billing AdjustmentsY
5        ARAsset RevaluationY
6        ASAsset SplitN
7        ATAsset TransferN
8        BABilling AdjustmentsY
9        BFBalance Forward/SummarizeN
10        CACredit Note for AftercareN
11        CCCredit-Contract & Loyalty SuppN
12        CGLot Grade ChangeN
13        CPLot Potency ChangeN
14        CQCredit Note - Quarterly BonusN
15        CTCredit Note - Targeted BonusN
16        CWCredit Note for WarrantyN
17        DPDepreciation JournalN
18        DRJob Cost Draw SplitsY
19        EUService Billing RevenueY
20        EXCurrency Conversion OffsetsN
21        IQInventory Quantity OnlyY
22        IXRecalculate Average CostN
23        IZLot Hold/ReleaseN
24        JABudget or Cost AllocationN
25        JBJoint Interest BillingN
26        JCJob Cost % CompleteN
27        JDJIB Detail Owner EntriesN
28        JEJournal EntryN
29        JFJournals Brought ForwardN
30        JKA/P Redistribute PaymentsY
31        JMAR VAT RedistributionY
32        JPSubscription SalesN
33        JQSub. Sales Net LedgerN
34        JRSubscription Sales CommissionsN
35        JTAccrued Property TaxesN
36        JVA/P Redistribute PrepaymentsY
37        JXForeign Currency RevaluationN
38        JZCash Basis Journal EntryN
39        NPPartial NSFY
40        O Ordering Document TypesN
41        O4Purchase Order -TransportationN
42        OADo Not UseY
43        OBBlanket OrderN
44        OCConstruction Work OrderN
45        ODDirect Ship OrderN
46        OEDo Not Use--Exchange Rate Var.N
47        OIInteroperability Direct P.O.N
48        OKPurchase Intercompany OrderN
49        OMPurchase Order RMAN
50        OOOutside Operations
51        OPPurchase OrderN
52        OQPurchase Quote or BidN
53        OSSubcontractN
54        OURequisition Self ServiceY
55        OYEDI Purchase Order Quote
56        P1A/P DraftsN
57        P7Alternate Currency PaymentN
58        PACredit Note ReimbursementsN
59        PBBACS Electronic Funds TransferN
60        PEChange to Voucher AmountN
61        PGGain/Loss on Exchange RateN
62        PIPhysical InventoryN
63        PKAutomated CheckN
64        PLVoucher LoggingN
65        PMManual VoucherN
66        PNManual CheckN
67        POVoid CheckN
68        PRRecurring VoucherN
69        PTElectronic Funds TransferN
70        PWWithholding
71        PYPayment Order - EDI Only
72        R ReceivablesN
73        R1A/R DraftsN
74        R2Contract BillingN
75        R5DeductionY
76        R6RMA - Sales OrderY
77        R7Alternate Currency ReceiptN
78        RAAdjustmentN
79        RBChargebackN
80        RCCash ReceiptsN
81        REChange to Invoice AmountN
82        RFFinance ChargeN
83        RGGain/Loss on Exchange RateN
84        RKCash Receipts CheckN
85        ROReversing or Void EntryN
86        RQChargeback Amount CreatedN
87        RRRecurring InvoiceN
88        RSSpread AdjustmentsN
89        RUUnapplied CashN
90        RVNon-sufficient FundsN
91        RWBalance ForwardN
92        RYCash Receipts - EDI Only
93        SBBlanket Sales OrderN
94        SCActual Rate ScheduleN
95        SDDirect ShipN
96        SFFree GoodsN
97        SIInterbranch SalesN
98        SQSales QuoteN
99        SSDo Not Use--Summary RecordsN
100        SYEDI Sales Order QuoteN
101        SZEDI Sales OrderN
102        TMEnterprise Treasury ManagementY