JDE TABLES
JD Edwards Enterprise One table definition reference
jde.erpref.com
Implementation Guides
|
920 VMs
|
Schema:
920
910
812
System
Select system...
00 : Foundation Environment
01 : Address Book
02 : Electronic Mail
03 : Accounts Receivable
03B : Enhanced Accounts Receivable
04 : Accounts Payable
05 : Time Accounting and HRM Base
05A : PeopleSoft HR & PR Foundation
05T : Time Entry
05U : E1 HR & PR Foundation US
06 : Payroll (old) - Obsolete-do not reuse
07 : Payroll
08 : Human Resources
08A : eRecruit
08AD: ADP Integration
08B : Benefits Administration
08C : PeopleSoft HR Canadian
08H : Health and Safety
08LM: HCM Learning Management Integr
08P : Position Control
08R : Recruitment Management - (Appl. Track. & Req.)
08U : PeopleSoft HR US
08W : Wage and Salary
09 : General Accounting
09E : Expense Reimbursment
10 : Financial Reporting
11 : Multi Currency
11C : Cash Basis
12 : Fixed Assets
13 : Plant/Equipment Management
13C : Condition-Base Maintenance
13E : Equipment Cost Analysis
13R : Resource Assignments
14 : Modeling - Planning & Budgeting
15 : Real Estate Management
15L : Adv Real Estate Forecasting
16 : Profit Management (EPS)
17 : Customer Service Management
17C : Call Management
18 : Timecard Automation
30 : Product Data Management
30A : Product Costing
31 : Shop Floor Control
31A : Manufacturing Accounting
31B : Blend Management
31P : Engineer To Order
32 : Configuration Management
33 : Capacity Planning
34 : Requirements Planning
34A : Advanced Planning & Scheduling
34X : In-Memory Planning Advisor
35 : Enterprise Facility Planning
36 : Forecasting
37 : Quality Management
38 : Agreement Management
39 : Advanced Stock Valuation
40 : Inventory/OP Base
40G : Grower Management
40P : Promotions Management
40R : Demand Scheduling
40S : Supply Chain Self Service
41 : Inventory Management
41B : Bulk Stock Management
41F : Apparel Management
42 : Sales Management
42B : Sales Order Entry
42I : Outbound Inventory Management
42W : Fulfilment Management
42X : In-Memory Sales Advisor
43 : Procurement
43A : Purchase Order Receipt/Routing
43B : Voucher Match and Landed Cost
43C : Contracts
43E : Requisition Self Service
43Q : Strategic Sourcing
43S : JSSS/Supplier Self Service
44H : Homebuilder Management
45 : Advanced Pricing
46 : Warehouse Management
46L : License Plating
46R : RFID Outbound
47 : Electronic Commerce
48 : Work Order Processing
48S : Service Billing
49 : Transportation Management
51 : Job Costing
51F : Advanced Job Forecasting
51X : In-Memory Project Management
52 : Contract Billing
52G : Proj & Gov Contract Accounting
53 : Change Management
54HS: Health & Safety Incident Mgt
54R : Rental Management
70 : Multi-National Products
73 : M & D complementary products
74 : EMEA Localization
74B : Begium Localization
74D : Germany
74F : France
74H : Hungary
74L : Portugal
74P : Poland
74R : Russia
74S : Spain
74U : United Kingdom Localizations
74W : Sweden
74Y : Italy
74Z : Czech Republic
75A : Australia
75C : China
75I : India
75J : Japan
75T : Taiwan
75Z : New Zealand
76A : Argentina
76B : Brazil
76C : Colombia
76E : Ecuador
76H : Chile
76M : Mexico
76P : Peru
76V : Venezuela
77 : Payroll (Canadian)
77Y : Canada Payroll Year End
79A : Greenhouse Gas Accounting
81 : DREAM Writer
81A : DREAMWriter Conversion Tool
83 : Management Reporting - FASTR
87 : PeopleSoft Internal
89 : Conversion Programs
90CA: CRM Foundation
90CB: CRM Sales Force Automation
90CC: CRM Marketing Automation
90CD: CRM Service Management
90CE: CRM Solution Advisor
90CF: CRM Call Scripting
90CG: CRM Case Management
98 : Technical Tools
98SA: Sample Application
F30L: DFM Line Design
F31 : Lean Transactions
F31K: DFM Kanban Management
F34R: DFM Resource Management
F34S: DFM Production Sequencing
H79 : Translation Tools
H90 : EnterpriseOne TOOLS
H91 : Design Tools
H92 : Interactive Engine/OL
H93 : Data Base and Communications
H94 : Batch Engine
H95 : Object and Environment Tech
H96 : Deployment
H96B: Package Build
H96I: EnterpriseOne Installs
H96P: Product Packaging Tools
H96U: Upgrade
H97 : Benchmarking/Performance
H98 : Internet
H99 : Product Version Control
Table
Column
Search
beta
JDE TABLES
v3
is JDE Date
Home
|
920
920: Top 10 requests
Table
Prefix
Description
1
F4211
SD
Sales Order Detail File
2
F0101
AB
Address Book Master
3
F4101
IM
Item Master
4
F0911
GL
Account Ledger
5
F4311
PD
Purchase Order Detail File
6
F9671
SD
Software Update Detail Table
7
F4102
IB
Item Branch File
8
F0411
RP
Accounts Payable Ledger
9
F0006
MC
Business Unit Master
10
F41021
LI
Item Location File
910: Top 10 requests
Table
Prefix
Description
1
F0011W
IC
F0011W - WF - Batch To Detail
2
F76AUI46
WF
CERG A/R -Work File - ARG - 03B - 76A
3
F4211
SD
Sales Order Detail File
4
F4101
IM
Item Master
5
F0101
AB
Address Book Master
6
F0911
GL
Account Ledger
7
F4102
IB
Item Branch File
8
F03B11
RP
Customer Ledger
9
F4311
PD
Purchase Order Detail File
10
F4111
IL
Item Ledger File
812: Top 10 requests
Table
Prefix
Description
1
F0911
GL
Account Ledger
2
F4311
PD
Purchase Order Detail File
3
F0101
AB
Address Book Master
4
F0006
MC
Business Unit Master
5
F0411
RP
Accounts Payable Ledger
6
F4211
SD
Sales Order Detail File
7
F42119
SD
Sales Order History File
8
F03012
AI
Customer Master by Line of Business
9
F0902
GB
Account Balances
10
F4801
WA
Work Order Master File
1 column |
920
|
SBTY
Table
Table Description
Column#
Prefix
Alias
Column Description
Data Type
Edit Type
Length
Decimals
TOP
09: General Accounting
1
F0907
Chart of Accounts Format
2
GY
SBTY
Record Subtype-Structured Chart of Accts
Numeric
Generic Edit
3
0