ERPRef.com
is JDE Date
3 COLUMNS 920 | CTR4
0 COLUMNS | TOP 920 | 00 | Foundation Environment
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 01 | Address Book
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 02 | Electronic Mail
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 03 | Accounts Receivable
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 03B | Enhanced Accounts Receivable
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 04 | Accounts Payable
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 05 | Time Accounting and HRM Base
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 05A | OW HR & PR Foundation
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 05T | Time Entry
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 05U | OW HR & PR Foundation US
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 06 | Payroll (old) - Obsolete-do not reuse
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
2 COLUMNS | TOP 920 | 07 | Payroll
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 08 | Human Resources
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 08A | eRecruit
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 08AD | ADP Integration
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 08B | Benefits Administration
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 08C | OW HR Canadian
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 08H | Health and Safety
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 08LM | HCM Learning Management Integr
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 08P | Position Control
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 08R | Recruitment Management - (Appl. Track. & Req.)
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 08U | OW HR US
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 08W | Wage and Salary
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 09 | General Accounting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 09E | Expense Reimbursment
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 10 | Financial Reporting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 11 | Multi Currency
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 11C | Cash Basis
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 12 | Fixed Assets
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 13 | Plant/Equipment Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 13C | Condition-Base Maintenance
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 13E | Equipment Cost Analysis
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 13R | Resource Assignments
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 14 | Modeling - Planning & Budgeting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 15 | Property Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 15L | Adv Real Estate Forecasting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 16 | Profit Management (EPS)
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 17 | Customer Service Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 17C | Call Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 18 | Resource Scheduling
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 30 | Product Data Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 30A | Product Costing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 31 | Shop Floor Control
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 31A | Manufacturing Accounting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 31B | Blend Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 31P | Engineer To Order
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 32 | Configuration Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 33 | Capacity Planning
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 34 | Requirements Planning
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 34A | Advanced Planning & Scheduling
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 34X | In-Memory Planning Advisor
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 35 | Enterprise Facility Planning
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 36 | Forecasting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 37 | Quality Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 38 | Agreement Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 39 | Advanced Stock Valuation
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 40 | Inventory/OP Base
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 40G | Grower Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 40P | Promotions Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 40R | Demand Scheduling
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 40S | Supply Chain Self Service
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 41 | Inventory Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 41B | Bulk Stock Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 41F | Apparel Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 42 | Sales Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 42B | Sales Order Entry
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 42I | Outbound Inventory Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 42W | Fulfillment Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 42X | Exa Order Processing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 43 | Procurement
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 43A | Purchase Order Receipt/Routing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 43B | Voucher Match and Landed Cost
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 43C | Contracts
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 43E | Requisition Self Service
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 43Q | Strategic Sourcing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 43S | Supplier Self Service
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 44H | Homebuilder Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 45 | Advanced Pricing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 46 | Warehouse Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 46L | License Plating
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 46R | RFID Outbound
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 47 | Electronic Commerce
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 48 | Work Order Processing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 48S | Service Billing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 49 | Transportation Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 51 | Job Costing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 51F | Advanced Job Forecasting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 51X | Exa Construction
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 52 | Contract Billing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 52G | Government Contracting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 53 | Change Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 54HS | Health & Safety Incident Mgt
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 54R | Rental Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 70 | Multi-National Products - obsolete-do not reuse
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 73 | M & D complementary products
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74 | EMEA Localization
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74B | Begium Localization
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74D | Germany - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74F | France - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74H | Hungary
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74L | Portugal
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74P | Poland
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74R | CIS
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74S | Spain
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74U | United Kingdom Localizations
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74W | Sweden - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74Y | Italy - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 74Z | Czech Republic
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 75A | Australia - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 75C | China - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 75I | India
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 75J | Japan - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 75T | Taiwan
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 75Z | New Zealand - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 76A | Argentina
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 76B | Brazil - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 76C | Colombia
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 76E | Ecuador
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
1 COLUMNS | TOP 920 | 76H | Chile
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 76M | Mexico
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 76P | Peru
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 76V | Venezuela
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 77 | Payroll (Canadian)
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 77Y | Canada Payroll Year End
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 79A | Greenhouse Gas Accounting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 81 | DREAM Writer
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 81A | DREAMWriter Conversion Tool
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 83 | Management Reporting - FASTR
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 87 | JDE Internal
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 89 | Conversion Programs
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 90CA | CRM Foundation
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 90CB | CRM Sales Force Automation
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 90CC | CRM Marketing Automation
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 90CD | CRM Service Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 90CE | CRM Solution Advisor
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 90CF | CRM Call Scripting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 90CG | CRM Case Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 98 | Technical Tools
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | 98SA | Sample Application
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | F31 | Lean Transactions
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H79 | CS - Forecasting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H90 | ONEWORLD TOOLS
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H91 | Design Tools
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H92 | Interactive Engine/OL
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H93 | Data Base and Communications
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H94 | Batch Engine
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H95 | Tech Resources/Applications
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H96 | Deployment
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H96B | Package Build
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H96I | Installation
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H96P | Product Packaging Tools
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H96U | Upgrade
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H97 | Benchmarking/Performance
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H98 | Internet
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 920 | H99 | Product Version Control
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 00 / CN (COUNTRY CODES) STOCK VALUES
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | Default Country | N | ||
| 2 | * | All Countries | N | |
| 3 | AD | Andorra | 020 | N |
| 4 | AE | United Arab Emirates (UAE) | 784 | N |
| 5 | AF | Afghanistan | 004 | N |
| 6 | AG | Antigua and Barbuda | 028 | N |
| 7 | AI | Anguilla | 660 | N |
| 8 | AL | Albania | 008 | N |
| 9 | AM | Armenia | 051 | N |
| 10 | AN | Netherlands Antilles | 530 | N |
| 11 | AO | Angola | 024 | N |
| 12 | AQ | Antarctica | 010 | N |
| 13 | AR | Argentina | 032 | N |
| 14 | AS | American Samoa | 016 | N |
| 15 | AT | Austria | 040 | N |
| 16 | AU | Australia | 036 | N |
| 17 | AW | Aruba | 533 | N |
| 18 | AZ | Azerbaijan | 031 | N |
| 19 | BA | Bosnia and Herzegovina | 070 | N |
| 20 | BB | Barbados | 052 | N |
| 21 | BD | Bangladesh | 050 | N |
| 22 | BE | Belgium | 056 | N |
| 23 | BF | Burkina Faso | 854 | N |
| 24 | BG | Bulgaria | 100 | N |
| 25 | BH | Bahrain | 048 | N |
| 26 | BI | Burundi | 108 | N |
| 27 | BJ | Benin | 204 | N |
| 28 | BM | Bermuda | 060 | N |
| 29 | BN | Brunei | 096 | N |
| 30 | BO | Bolivia | 068 | N |
| 31 | BR | Brazil | 076 | N |
| 32 | BS | Bahamas | 044 | N |
| 33 | BT | Bhutan | 064 | N |
| 34 | BV | Bouvet Island | 074 | N |
| 35 | BW | Botswana | 072 | N |
| 36 | BY | Byelorussian SSR | 112 | N |
| 37 | BZ | Belize | 084 | N |
| 38 | CA | Canada | 124 | N |
| 39 | CC | Cocos (Keeling) Islands | 166 | N |
| 40 | CD | Democratic Republic of Congo | 180 | N |
| 41 | CF | Central African Republic | 140 | N |
| 42 | CG | Congo | 178 | N |
| 43 | CH | Switzerland | 756 | N |
| 44 | CI | Ivory Coast | 384 | N |
| 45 | CK | Cook Islands | 184 | N |
| 46 | CL | Chile | 152 | N |
| 47 | CM | Cameroon | 120 | N |
| 48 | CN | China | 156 | N |
| 49 | CO | Colombia | 170 | N |
| 50 | CR | Costa Rica | 188 | N |
| 51 | CS | Serbia and Montenegro | 891 | N |
| 52 | CU | Cuba | 192 | N |
| 53 | CV | Cape Verde | 132 | N |
| 54 | CX | Christmas Island | 162 | N |
| 55 | CY | Cyprus | 196 | N |
| 56 | CZ | Czech Republic | 203 | N |
| 57 | DE | Germany | 276 | N |
| 58 | DJ | Djibouti | 262 | N |
| 59 | DK | Denmark | 208 | N |
| 60 | DM | Dominica | 212 | N |
| 61 | DO | Dominican Republic | 214 | N |
| 62 | DZ | Algeria | 012 | N |
| 63 | EC | Ecuador | 218 | N |
| 64 | EE | Estonia | 233 | N |
| 65 | EG | Egypt | 818 | N |
| 66 | EH | Western Sahara | 732 | N |
| 67 | ER | Eritrea | 232 | N |
| 68 | ES | Spain | 724 | N |
| 69 | ET | Ethiopia | 231 | N |
| 70 | FI | Finland | 246 | N |
| 71 | FJ | Fiji | 242 | N |
| 72 | FK | Falkland Islands | 238 | N |
| 73 | FM | Micronesia | 583 | N |
| 74 | FO | Faroe Islands | 234 | N |
| 75 | FR | France | 250 | N |
| 76 | GA | Gabon | 266 | N |
| 77 | GB | United Kingdom | 826 | N |
| 78 | GD | Grenada | 308 | N |
| 79 | GE | Georgia | 268 | N |
| 80 | GF | French Guiana | 254 | N |
| 81 | GH | Ghana | 288 | N |
| 82 | GI | Gibraltar | 292 | N |
| 83 | GL | Greenland | 304 | N |
| 84 | GM | Gambia | 270 | N |
| 85 | GN | Guinea | 324 | N |
| 86 | GP | Guadeloupe | 312 | N |
| 87 | GQ | Equatorial Guinea | 226 | N |
| 88 | GR | Greece | 300 | N |
| 89 | GS | South Georgia and the South Sa | 239 | N |
| 90 | GT | Guatemala | 320 | N |
| 91 | GU | Guam | 316 | N |
| 92 | GW | Guinea-Bissau | 624 | N |
| 93 | GY | Guyana | 328 | N |
| 94 | HK | Hong Kong | 344 | N |
| 95 | HM | Heard Island and McDonald Isla | 334 | N |
| 96 | HN | Honduras | 340 | N |
| 97 | HR | Croatia | 191 | N |
| 98 | HT | Haiti | 332 | N |
| 99 | HU | Hungary | 348 | N |
| 100 | ID | Indonesia | 360 | N |
| 101 | IE | Ireland | 372 | N |
| 102 | IL | Israel | 376 | N |
| 103 | IN | India | 356 | N |
| 104 | IO | British Indian Ocean Territory | 086 | N |
| 105 | IQ | Iraq | 368 | N |
| 106 | IR | Iran | 364 | N |
| 107 | IS | Iceland | 352 | N |
| 108 | IT | Italy | 380 | N |
| 109 | JM | Jamaica | 388 | N |
| 110 | JO | Jordan | 400 | N |
| 111 | JP | Japan | 392 | N |
| 112 | KE | Kenya | 404 | N |
| 113 | KG | Kyrgyzstan | 417 | N |
| 114 | KH | Cambodia | 116 | N |
| 115 | KI | Kiribati | 296 | N |
| 116 | KM | Comoros | 174 | N |
| 117 | KN | Saint Kitts and Nevis | 659 | N |
| 118 | KP | North Korea | 408 | N |
| 119 | KR | South Korea | 410 | N |
| 120 | KW | Kuwait | 414 | N |
| 121 | KY | Cayman Islands | 136 | N |
| 122 | KZ | Kazakhstan | 398 | N |
| 123 | LA | Laos | 418 | N |
| 124 | LB | Lebanon | 422 | N |
| 125 | LC | Saint Lucia | 662 | N |
| 126 | LI | Liechtenstein | 438 | N |
| 127 | LK | Sri Lanka | 144 | N |
| 128 | LR | Liberia | 430 | N |
| 129 | LS | Lesotho | 426 | N |
| 130 | LT | Lithuania | 440 | N |
| 131 | LU | Luxembourg | 442 | N |
| 132 | LV | Latvia | 428 | N |
| 133 | LY | Libya | 434 | N |
| 134 | MA | Morocco | 504 | N |
| 135 | MC | Monaco | 492 | N |
| 136 | MD | Moldova, Republic of | 498 | N |
| 137 | MG | Madagascar | 450 | N |
| 138 | MH | Marshall Islands | 584 | N |
| 139 | MK | Macedonia, The Former Yugoslav | 807 | N |
| 140 | ML | Mali | 466 | N |
| 141 | MM | Myanmar | 104 | N |
| 142 | MN | Mongolia | 496 | N |
| 143 | MO | Macau | 446 | N |
| 144 | MP | Northern Mariana Islands | 580 | N |
| 145 | MQ | Martinique | 474 | N |
| 146 | MR | Mauritania | 478 | N |
| 147 | MS | Montserrat | 500 | N |
| 148 | MT | Malta | 470 | N |
| 149 | MU | Mauritius | 480 | N |
| 150 | MV | Maldives | 462 | N |
| 151 | MW | Malawi | 454 | N |
| 152 | MX | Mexico | 484 | N |
| 153 | MY | Malaysia | 458 | N |
| 154 | MZ | Mozambique | 508 | N |
| 155 | NA | Namibia | 516 | N |
| 156 | NC | New Caledonia | 540 | N |
| 157 | NE | Niger | 562 | N |
| 158 | NF | Norfolk Island | 574 | N |
| 159 | NG | Nigeria | 566 | N |
| 160 | NI | Nicaragua | 558 | N |
| 161 | NL | Netherlands | 528 | N |
| 162 | NN | None | N | |
| 163 | NO | Norway | 578 | N |
| 164 | NP | Nepal | 524 | N |
| 165 | NR | Nauru | 520 | N |
| 166 | NU | Niue | 570 | N |
| 167 | NZ | New Zealand | 554 | N |
| 168 | OM | Oman | 512 | N |
| 169 | PA | Panama | 591 | N |
| 170 | PE | Peru | 604 | N |
| 171 | PF | French Polynesia | 258 | N |
| 172 | PG | Papua New Guinea | 598 | N |
| 173 | PH | Phillippines | 608 | N |
| 174 | PK | Pakistan | 586 | N |
| 175 | PL | Poland | 616 | N |
| 176 | PM | St. Pierre and Miquelon | 666 | N |
| 177 | PN | Pitcairn | 612 | N |
| 178 | PR | Puerto Rico | 630 | N |
| 179 | PS | Palestinian Territory, Occupie | 275 | N |
| 180 | PT | Portugal | 620 | N |
| 181 | PW | Palau | 585 | N |
| 182 | PY | Paraguay | 600 | N |
| 183 | QA | Qatar | 634 | N |
| 184 | RE | Reunion | 638 | N |
| 185 | RO | Romania | 642 | N |
| 186 | RU | Russia | 643 | N |
| 187 | RW | Rwanda | 646 | N |
| 188 | SA | Saudi Arabia | 682 | N |
| 189 | SB | Solomon Islands | 090 | N |
| 190 | SC | Seychelles | 690 | N |
| 191 | SD | Sudan | 736 | N |
| 192 | SE | Sweden | 752 | N |
| 193 | SG | Singapore | 702 | N |
| 194 | SH | Saint Helena | 654 | N |
| 195 | SI | Slovenia | 705 | N |
| 196 | SJ | Svalbard and Jan Mayen | 744 | N |
| 197 | SK | Slovakia | 703 | N |
| 198 | SL | Sierra Leone | 694 | N |
| 199 | SM | San Marino | 674 | N |
| 200 | SN | Senegal | 686 | N |
| 201 | SO | Somalia | 706 | N |
| 202 | SR | Suriname | 740 | N |
| 203 | ST | Sao Tome and Principe | 678 | N |
| 204 | SV | El Salvador | 222 | N |
| 205 | SY | Syria | 760 | N |
| 206 | SZ | Swaziland | 748 | N |
| 207 | TC | Turks and Caicos Islands | 796 | N |
| 208 | TD | Chad | 148 | N |
| 209 | TF | French Southern Territories | 260 | N |
| 210 | TG | Togo | 768 | N |
| 211 | TH | Thailand | 764 | N |
| 212 | TJ | Tajikistan | 762 | N |
| 213 | TK | Tokelau | 772 | N |
| 214 | TL | Timor-Leste | 626 | N |
| 215 | TM | Turkmenistan | 795 | N |
| 216 | TN | Tunisia | 788 | N |
| 217 | TO | Tonga | 776 | N |
| 218 | TR | Turkey | 792 | Y |
| 219 | TT | Trinidad and Tobago | 780 | N |
| 220 | TV | Tuvalu | 798 | N |
| 221 | TW | Taiwan | 158 | N |
| 222 | TZ | Tanzania | 834 | N |
| 223 | UA | Ukrainian SSR | 804 | N |
| 224 | UG | Uganda | 800 | N |
| 225 | UM | United States Minor Outlying I | 581 | N |
| 226 | US | United States | 840 | N |
| 227 | UY | Uruguay | 858 | N |
| 228 | UZ | Uzbekistan | 860 | N |
| 229 | VA | Vatican City | 336 | N |
| 230 | VC | Saint Vincent & the Grenadines | 670 | N |
| 231 | VE | Venezuela | 862 | N |
| 232 | VG | British Virgin Islands | 092 | N |
| 233 | VI | US Virgin Islands | 850 | N |
| 234 | VN | Vietnam | 704 | N |
| 235 | VU | Vanuatu | 548 | N |
| 236 | WF | Wallis and Futuna Islands | 876 | N |
| 237 | WS | Samoa | 882 | N |
| 238 | YE | Yemen | 887 | N |
| 239 | YT | Mayotte | 175 | N |
| 240 | ZA | South Africa | 710 | N |
| 241 | ZM | Zambia | 894 | N |
| 242 | ZW | Zimbabwe | 716 | N |