ERPRef.com
is JDE Date
66 COLUMNS 920 | UM
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 |
|---|
1 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 |
|---|
1 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 |
|---|
0 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 |
|---|
3 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 |
|---|
6 COLUMNS | TOP 920 | 42 | Sales Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
1 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 |
|---|
5 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 |
|---|
1 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 |
|---|
1 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 |
|---|
19 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 |
|---|
19 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 |
|---|
2 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 |
|---|
3 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 |
|---|
2 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 |
|---|
2 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 / UM (UNIT OF MEASURE) STOCK VALUES
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | . | Y | ||
| 2 | % | Percent | N | |
| 3 | 12 | Twelve Pack | N | |
| 4 | AC | Acre | N | |
| 5 | AS | Annual Salary(rounded)xmult. | N | |
| 6 | AT | Annual Salary(truncated)xmult. | N | |
| 7 | BA | Bar Absolute (Pressure) | N | |
| 8 | BC | Bag | N | |
| 9 | BG | Bar Gauge (Pressure) | N | |
| 10 | BK | Bucket | N | |
| 11 | BL | Barrels | N | |
| 12 | BT | Bottles | N | |
| 13 | BU | Bushel | N | |
| 14 | BX | Box | N | |
| 15 | CA | Case | N | |
| 16 | CC | Cubic Centimeter | V | N |
| 17 | CF | Hundred Feet | N | |
| 18 | CI | Cubic Inches | V | N |
| 19 | CL | Centiliters | V | N |
| 20 | CM | Centimeters | N | |
| 21 | CN | Can | N | |
| 22 | CO | Container | N | |
| 23 | CR | Carton | N | |
| 24 | CS | Hundred Square Feet | N | |
| 25 | CT | Carat | Y | |
| 26 | CU | Cubic Meter | Y | |
| 27 | CW | Hundredweight | W | N |
| 28 | CY | Cubic Yard | V | N |
| 29 | DC | Decimeters | N | |
| 30 | DL | Deciliter | N | |
| 31 | DR | drums | N | |
| 32 | DW | Penny Weight | ||
| 33 | DY | Days | N | |
| 34 | DZ | Dozen | N | |
| 35 | EA | Each | N | |
| 36 | FC | Cubic Feet | V | N |
| 37 | FF | Feet/Inches/16th | N | |
| 38 | FO | Fluid Ounce | Y | |
| 39 | FT | Feet | N | |
| 40 | G1 | 100 Gallons | N | |
| 41 | GA | Gallons | V | N |
| 42 | GJ | Giga Joule | Y | |
| 43 | GM | Grams | W | N |
| 44 | GP | Potent Gallons | VP | N |
| 45 | GR | Gross | N | |
| 46 | H1 | Half Hour Calculations | N | |
| 47 | HA | Average Hourly Rate | N | |
| 48 | HE | Head Count | N | |
| 49 | HH | Hours X Hours Worked | N | |
| 50 | HL | Hectoliter | V | N |
| 51 | HQ | Hours per period (zero $) | N | |
| 52 | HR | Hour | N | |
| 53 | HT | Hectare | N | |
| 54 | HZ | Hours x Hrs worked (zero $) | N | |
| 55 | IC | Cubic Inches | V | N |
| 56 | IG | Imperial Gallons | V | N |
| 57 | IN | Inches | N | |
| 58 | JT | Joints | N | |
| 59 | KG | Kilograms | W | N |
| 60 | KL | Kiloliter . | N | |
| 61 | KM | Kilometers | N | |
| 62 | KT | Karat | N | |
| 63 | KW | Kilowatt Hour | Y | |
| 64 | L3 | Pounds per square inch | N | |
| 65 | LB | Pounds | W | N |
| 66 | LC | Cubic Liters | V | N |
| 67 | LF | Linear Feet | N | |
| 68 | LG | Log | N | |
| 69 | LP | Potent Liters | VP | N |
| 70 | LS | Lump Sum | N | |
| 71 | LT | Liters | V | N |
| 72 | M3 | Cubic Meters | V | N |
| 73 | MF | Thousand Feet | N | |
| 74 | MG | Milligrams | W | N |
| 75 | MH | Man Hour | N | |
| 76 | MI | Miles | N | |
| 77 | MK | Micrograms | W | N |
| 78 | ML | Milliliter | V | N |
| 79 | MM | Millimeters . | N | |
| 80 | MN | Minutes | Y | |
| 81 | MO | Months | N | |
| 82 | MP | Thousand Pieces | N | |
| 83 | MS | Thousand Square Feet | N | |
| 84 | MT | Meters | N | |
| 85 | MW | Thousand Pounds | W | N |
| 86 | OP | Potent Ounces | P | N |
| 87 | OT | Troy Ounces | N | |
| 88 | OZ | Ounces | W | N |
| 89 | PC | Pieces | N | |
| 90 | PD | Pad | N | |
| 91 | PK | Package | N | |
| 92 | PL | Pallet | N | |
| 93 | PR | Pair | N | |
| 94 | PT | Pint | V | N |
| 95 | QT | Quart | V | N |
| 96 | RD | Rental Deposit | N | |
| 97 | RL | Roll | N | |
| 98 | RM | Ream | N | |
| 99 | RT | $1000s of Salary | N | |
| 100 | SC | Square Centimeters | N | |
| 101 | SE | Seconds | Y | |
| 102 | SF | Square Feet | N | |
| 103 | SI | Square Inches | N | |
| 104 | SK | Skein | N | |
| 105 | SL | Sleeve | N | |
| 106 | SM | Square Meters | N | |
| 107 | SP | Spaces | ||
| 108 | ST | Eaches | N | |
| 109 | SX | Six Pack | N | |
| 110 | SY | Square Yard | N | |
| 111 | TK | Tank | N | |
| 112 | TL | Long Ton (English) | W | N |
| 113 | TM | Metric Ton | W | N |
| 114 | TN | Ton (U.S.) | W | N |
| 115 | TS | Short Ton (U.S.) | W | N |
| 116 | UN | Units | N | |
| 117 | WK | Weeks | N | |
| 118 | WU | Weld Units | N | |
| 119 | XL | Excess Life | N | |
| 120 | YD | Yards | N | |
| 121 | YR | Year | N | |
| 122 | Z | Set (3-PW) | N |