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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

155 columns | Print definition?920 | VR01

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03: Accounts Receivable
1F0311Accounts Receivable Ledger89RPVR01ReferenceStringGeneric Edit250
2F0312A/R Batch Cash Application52RUVR01ReferenceStringGeneric Edit250
TOP03B: Enhanced Accounts Receivable
3F03B11Customer Ledger86RPVR01ReferenceStringGeneric Edit250
4F03B11PCustomer Ledger Purge File86RPVR01ReferenceStringGeneric Edit250
5F03B11Z1Batch Invoices102VJVR01ReferenceStringGeneric Edit250
6F03B11Z2F03B11 Interoperability Table99SYVR01ReferenceStringGeneric Edit250
7F03B13Z1Electronic Receipts Input13RUVR01ReferenceStringGeneric Edit250
8F03B14Receipts Detail104RZVR01ReferenceStringGeneric Edit250
9F03B14PReceipts Detail Purge File104RZVR01ReferenceStringGeneric Edit250
10F03B14Z2F03B14 Interoperability Table117SZVR01ReferenceStringGeneric Edit250
11F03B40A/R Deduction Management24RBVR01ReferenceStringGeneric Edit250
12F03B465A/R Netting Workfile8ROVR01ReferenceStringGeneric Edit250
13F03B575Auto Debit Invoice Select and Build95RDVR01ReferenceStringGeneric Edit250
TOP04: Accounts Payable
14F0411Accounts Payable Ledger68RPVR01ReferenceStringGeneric Edit250
15F0411AWF - 'As Of' Accounts Payable Ledger68RPVR01ReferenceStringGeneric Edit250
16F0411PPurge - Accounts Payable Ledger68RPVR01ReferenceStringGeneric Edit250
17F0411Z1Voucher Transactions - Batch Upload86VLVR01ReferenceStringGeneric Edit250
18F0411Z3F0411 Interoperability Table91SZVR01ReferenceStringGeneric Edit250
TOP13C: Condition-Base Maintenance
19F1310Condition-Based Alerts42CAVR01ReferenceStringGeneric Edit250
20F1310Z1Unedited Condition-Based Alerts56CBVR01ReferenceStringGeneric Edit250
TOP17: Customer Service Management
21F1721Contract Detail116CDVR01ReferenceStringGeneric Edit250
22F4801Z2Warranty Claim/Supplier Recovery processing66WSVR01ReferenceStringGeneric Edit250
TOP17C: Call Management
23F1755Case Master187ZAVR01ReferenceStringGeneric Edit250
24F1760Time Entry66ZBVR01ReferenceStringGeneric Edit250
TOP40: Inventory/OP Base
25F4001ZBatch Receiver File - Order Headings48SYVR01ReferenceStringGeneric Edit250
26F40051Return Material Authorization64RDVR01ReferenceStringGeneric Edit250
27F4011ZBatch Receiver File - Order Details47SZVR01ReferenceStringGeneric Edit250
28F4201Z1Sales Order Header Unedited Transaction File37SYVR01ReferenceStringGeneric Edit250
29F4211DTSales Order Detail Date Tracking File9DTVR01ReferenceStringGeneric Edit250
30F4211Z1Sales Order Detail Unedited Transaction File44SZVR01ReferenceStringGeneric Edit250
TOP41: Inventory Management
31F4130Consignment Master Header (FUTURE)10MHVR01ReferenceStringGeneric Edit250
32F4133Usage Detail (FUTURE)6UDVR01ReferenceStringGeneric Edit250
TOP41F: Apparel Management
33FCW65Work Order Header for Style Items48OFVR01ReferenceStringGeneric Edit250
TOP42: Sales Management
34F4201Sales Order Header File24SHVR01ReferenceStringGeneric Edit250
35F42019Sales Order Header History File24SHVR01ReferenceStringGeneric Edit250
36F4211Sales Order Detail File31SDVR01ReferenceStringGeneric Edit250
37F42119Sales Order History File31SDVR01ReferenceStringGeneric Edit250
38F42199S.O. Detail Ledger File31SLVR01ReferenceStringGeneric Edit250
39F42UI01SO Header Cache File (MBF)29ZHVR01ReferenceStringGeneric Edit250
40F42UI11SO Detail Cache File (MBF)34ZDVR01ReferenceStringGeneric Edit250
41F42UI520Pick Slips Header File37S8VR01ReferenceStringGeneric Edit250
42F42UI521Pick Slips Detail File27S9VR01ReferenceStringGeneric Edit250
TOP43: Procurement
43F4301Purchase Order Header23PHVR01ReferenceStringGeneric Edit250
44F4301ZPO Header Work File27PAVR01ReferenceStringGeneric Edit250
45F4301Z1Purchase Order Header Unedited Transaction Table36SYVR01ReferenceStringGeneric Edit250
46F43080Approvals Fields Constants41PDVR01ReferenceStringGeneric Edit250
47F43092Z1Receipt Routing Unedited Transaction Table54SZVR01ReferenceStringGeneric Edit250
48F4311Purchase Order Detail File33PDVR01ReferenceStringGeneric Edit250
49F4311ZPurchase Order Generator File37PWVR01ReferenceStringGeneric Edit250
50F4311Z1Purchase Order Detail Unedited Transaction Table46SZVR01ReferenceStringGeneric Edit250
51F43121Purchase Order Receiver File119PRVR01ReferenceStringGeneric Edit250
52F43121ZReceiver workfile141PWVR01ReferenceStringGeneric Edit250
53F43121Z1Receipts Unedited Transaction Table116SZVR01ReferenceStringGeneric Edit250
54F43199P.O. Detail Ledger File - Flexible Version33OLVR01ReferenceStringGeneric Edit250
55F4371Suggested Reorder Stock Items24PDVR01ReferenceStringGeneric Edit250
56F43UI50DPO Print Detail Work File51PWVR01ReferenceStringGeneric Edit250
57F43UI50HPO Print Header Work File42PAVR01ReferenceStringGeneric Edit250
TOP43Q: Strategic Sourcing
58F43Q11Event Detail31EDVR01ReferenceStringGeneric Edit250
TOP43S: JSSS/Supplier Self Service
59F43001Procurement Self-Service Transaction Log23SAVR01ReferenceStringGeneric Edit250
TOP44H: Homebuilder Management
60F44H611Bid Details32BDVR01ReferenceStringGeneric Edit250
61F44H611WBid Details Work File36BWVR01ReferenceStringGeneric Edit250
62F44H711Lot Start Workfile40SWVR01ReferenceStringGeneric Edit250
63F44H711PAfter Start Purchasing29TPVR01ReferenceStringGeneric Edit250
64F44H711ZHB Lot Start Unedited Transaction File53SZVR01ReferenceStringGeneric Edit250
65F44H71W1Lot Start Generation Workfile40GWVR01ReferenceStringGeneric Edit250
66F44H73W1Lot Start - P.O. / Committment Generation Work File35CGVR01ReferenceStringGeneric Edit250
TOP46: Warehouse Management
67F4600Warehouse Requests59R1VR01ReferenceStringGeneric Edit250
68F4600PUWarehouse Requests - Purged57R1VR01ReferenceStringGeneric Edit250
69F4611Warehouse Suggestions67R2VR01ReferenceStringGeneric Edit250
70F4611PUWarehouse Suggestions - Purged66R2VR01ReferenceStringGeneric Edit250
71F4611Z1Unedited Suggestion Table79SZVR01ReferenceStringGeneric Edit250
72F46201Carton Charge Reference Setup4CCVR01ReferenceStringGeneric Edit250
TOP47: Electronic Commerce
73F47011EDI Purchase Order Header - Inbound43SYVR01ReferenceStringGeneric Edit250
74F47012EDI Purchase Order Detail - Inbound47SZVR01ReferenceStringGeneric Edit250
75F47016EDI Purchase Order Header - Outbound38SYVR01ReferenceStringGeneric Edit250
76F47017EDI Purchase Order Detail - Outbound46SZVR01ReferenceStringGeneric Edit250
77F47021EDI P.O. Acknowledgment Header - Inbound38SYVR01ReferenceStringGeneric Edit250
78F47022EDI P.O. Acknowledgment Detail - Inbound46SZVR01ReferenceStringGeneric Edit250
79F47026EDI P.O. Acknowledgment Header - Outbound39SYVR01ReferenceStringGeneric Edit250
80F47027EDI P.O. Acknowledgment Detail - Outbound47SZVR01ReferenceStringGeneric Edit250
81F47031EDI Shipping Notice Header - Inbound36SYVR01ReferenceStringGeneric Edit250
82F47032EDI Shipping Notice Detail - Inbound45SZVR01ReferenceStringGeneric Edit250
83F47037EDI Shipping Notice Detail - Outbound47SZVR01ReferenceStringGeneric Edit250
84F470371EDI Shipping Notice Detail - Outbound52SZVR01ReferenceStringGeneric Edit250
85F47041EDI Invoice Header - Inbound53SYVR01ReferenceStringGeneric Edit250
86F47042EDI Invoice Detail - Inbound91SZVR01ReferenceStringGeneric Edit250
87F47046EDI Invoice Header (Sales) - Outbound39SYVR01ReferenceStringGeneric Edit250
88F47047EDI Invoice Detail (Sales) - Outbound47SZVR01ReferenceStringGeneric Edit250
89F47057EDI Payment Order Remittance Advice - Outbound55D3VR01ReferenceStringGeneric Edit250
90F47057WEDI Payment Order Remittance Advice - Work55D3VR01ReferenceStringGeneric Edit250
91F47061EDI Planning Schedule Header - Inbound16MJVR01ReferenceStringGeneric Edit250
92F47066EDI Planning Schedule Header - Outbound16MJVR01ReferenceStringGeneric Edit250
93F47071EDI Receiving Advice Header - Inbound39SYVR01ReferenceStringGeneric Edit250
94F47072EDI Receiving Advice Detail - Inbound47SZVR01ReferenceStringGeneric Edit250
95F47076EDI Receiving Advice Header - Outbound39SYVR01ReferenceStringGeneric Edit250
96F47077EDI Receiving Advice Detail - Outbound47SZVR01ReferenceStringGeneric Edit250
97F47091EDI Request for Quote Header - Inbound43SYVR01ReferenceStringGeneric Edit250
98F47092EDI Request for Quote Detail - Inbound47SZVR01ReferenceStringGeneric Edit250
99F47096EDI Request for Quote Header - Outbound38SYVR01ReferenceStringGeneric Edit250
100F47097EDI Request for Quote Detail - Outbound46SZVR01ReferenceStringGeneric Edit250
101F47101EDI Response to RFQ Header - Inbound38SYVR01ReferenceStringGeneric Edit250
102F47102EDI Response to RFQ Detail - Inbound46SZVR01ReferenceStringGeneric Edit250
103F47106EDI Response to RFQ Header - Outbound39SYVR01ReferenceStringGeneric Edit250
104F47107EDI Response to RFQ Detail - Outbound47SZVR01ReferenceStringGeneric Edit250
105F47112EDI Lockbox Header - Transaction18Z2VR01ReferenceStringGeneric Edit250
106F47121EDI Product Activity Data Header - Inbound19M1VR01ReferenceStringGeneric Edit250
107F47122EDI Product Activity Data Detail - Inbound20MJVR01ReferenceStringGeneric Edit250
108F47126EDI Product Activity Data Header - Outbound19M1VR01ReferenceStringGeneric Edit250
109F47127EDI Product Activity Data Detail - Outbound20MJVR01ReferenceStringGeneric Edit250
110F47131EDI Purchase Order Change Header - Inbound40SYVR01ReferenceStringGeneric Edit250
111F47132EDI Purchase Order Change Detail - Inbound48SZVR01ReferenceStringGeneric Edit250
112F47136EDI Purchase Order Change Header - Outbound38SYVR01ReferenceStringGeneric Edit250
113F47137EDI Purchase Order Change Detail - Outbound47SZVR01ReferenceStringGeneric Edit250
114F47141EDI P.O. Change Acknowledgment Header - Inbound39SYVR01ReferenceStringGeneric Edit250
115F47142EDI P.O. Change Acknowledgment Detail - Inbound48SZVR01ReferenceStringGeneric Edit250
116F47146EDI P.O. Change Acknowledgment Header - Outbound40SYVR01ReferenceStringGeneric Edit250
117F47147EDI P.O. Change Acknowledgment Detail - Outbound49SZVR01ReferenceStringGeneric Edit250
118F47156EDI Shipping Schedule Header - Outbound40SYVR01ReferenceStringGeneric Edit250
119F47157EDI Shipping Schedule Detail - Outbound48SZVR01ReferenceStringGeneric Edit250
TOP48: Work Order Processing
120F4801Work Order Master File47WAVR01ReferenceStringGeneric Edit250
121F4801SPurge - Work Order Master file47WAVR01ReferenceStringGeneric Edit250
122F4801Z1Outbound Work Order Header66SYVR01ReferenceStringGeneric Edit250
123F48710Work Order Mass Update Template Table95WTVR01ReferenceStringGeneric Edit250
124F48UI001X4801 Master Business Function Workfile50WAVR01ReferenceStringGeneric Edit250
TOP49: Transportation Management
125F4960Load Header53TMVR01ReferenceStringGeneric Edit250
126F49T10Sales Order Release Staging Table36ORVR01ReferenceStringGeneric Edit250
127F49T100Procurement Freight Request staging table23OBVR01ReferenceStringGeneric Edit250
TOP54HS: Health & Safety Incident Mgt
128F54HS02Incident People38S2VR01ReferenceStringGeneric Edit250
129F54HS02MIncident People Change History41I2VR01ReferenceStringGeneric Edit250
130F54HS04Incident Agencies9S5VR01ReferenceStringGeneric Edit250
131F54HS04MIncident Agencies Change History12I5VR01ReferenceStringGeneric Edit250
TOP54R: Rental Management
132F54R099Rental Contract Header Ledger41HLVR01ReferenceStringGeneric Edit250
133F54R10Rental Contract Header39CHVR01ReferenceStringGeneric Edit250
134F54R11Rental Contract Detail52CDVR01ReferenceStringGeneric Edit250
135F54R199Rental Contract Detail Ledger48DLVR01ReferenceStringGeneric Edit250
TOP70: Multi-National Products
136F703030Legal Document Header Tag File - COMM - 03B5H1VR01ReferenceStringGeneric Edit250
137F704001Payment WH Info TEMP - COMM - 0442PTVR01ReferenceStringGeneric Edit250
138F704002Payment WH Info - COMM - 0441PFVR01ReferenceStringGeneric Edit250
139F704002PPayment WH Info Purge - COMM - 0441PFVR01ReferenceStringGeneric Edit250
TOP74R: Russia
140F74R4500Paymet Order Supplemental Data - RU - 04 - 74R7POVR01ReferenceStringGeneric Edit250
TOP75C: China
141F75C015Cash Flow Data - China23CFVR01ReferenceStringGeneric Edit250
142F75C09Z1GUI cancel printing invoice-Jinsui - China - 03B4FFVR01ReferenceStringGeneric Edit250
TOP76A: Argentina
143F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A20IEVR01ReferenceStringGeneric Edit250
144F76A30HEDI Batch Input Localization File - ARG - 04 - 76A8V6VR01ReferenceStringGeneric Edit250
145F76A411HAP Header Tag File - ARG - 04 - 76A8B0VR01ReferenceStringGeneric Edit250
146F76A411RVoucher Localization Purge Header File - ARG - 04 - 76A8B4VR01ReferenceStringGeneric Edit250
147F76A8011Supplier Information RG 726 - ARG - 04 - 76A9PAVR01ReferenceStringGeneric Edit250
148F76AUI04A/P Legel Tax Tag Table - ARG - 04 - 76A42WCVR01ReferenceStringGeneric Edit250
149F76AUI81Draft - Invoices Work File - ARG - 03B - 76A40WFVR01ReferenceStringGeneric Edit250
150F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A10WFVR01ReferenceStringGeneric Edit250
TOP76B: Brazil
151F7601BNota Fiscal Header - BRA - 4219FHVR01ReferenceStringGeneric Edit250
TOP76C: Colombia
152F76C0003VAT Certificates Retention - COL - 76C2CRVR01ReferenceStringGeneric Edit250
153F76C034AA/R Check Detail file As Of - COL - 03B104RZVR01ReferenceStringGeneric Edit250
TOP87: PeopleSoft Internal
154F87SARSAR/Object Cross Reference10WSVR01ReferenceStringGeneric Edit250
TOP89: Conversion Programs
155F43199ATemp F43199 for ERP 9.0 Upgrade33OLVR01ReferenceStringGeneric Edit250