ERPRef.com
is JDE Date
2 COLUMNS 812 | MRPL
0 COLUMNS | TOP 812 | 00 | Foundation Environment
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 01 | Address Book
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 01RS | Rapid Start
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 02 | Electronic Mail
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 03 | Accounts Receivable
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 03B | Enhanced Accounts Receivable
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 04 | Accounts Payable
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 05 | Time Accounting and HRM Base
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 05A | OW HR & PR Foundation
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 05T | Time Entry
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 05U | OW HR & PR Foundation US
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 06 | Payroll (old) - Obsolete-do not reuse
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 07 | Payroll
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 07S | Payroll SUI
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 08 | Human Resources
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 08A | eRecruit
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 08AD | ADP Integration
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 08B | Benefits Administration
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 08C | OW HR Canadian
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 08H | Health and Safety
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 08LM | HCM Learning Management Integr
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 08P | Position Control
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 08R | Recruitment Management - (Appl. Track. & Req.)
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 08U | OW HR US
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 08W | Wage and Salary
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 09 | General Accounting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 09E | Expense Reimbursment
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 10 | Financial Reporting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 11 | Multi Currency
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 11C | Cash Basis
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 12 | Fixed Assets
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 13 | Plant/Equipment Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 13C | Condition-Base Maintenance
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 13E | Equipment Cost Analysis
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 13R | Resource Assignments
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 14 | Modeling - Planning & Budgeting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 15 | Property Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 15L | Adv Real Estate Forecasting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 16 | Profit Management (EPS)
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 17 | Customer Service Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 17C | Call Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 18 | Resource Scheduling
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 30 | Product Data Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 30A | Product Costing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 31 | Shop Floor Control
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 31B | Blend Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 31P | Engineer To Order
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 32 | Configuration Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 33 | Capacity Planning
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 34 | Requirements Planning
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 34A | Advanced Planning & Scheduling
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 35 | Enterprise Facility Planning
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 36 | Forecasting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 37 | Quality Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 38 | Agreement Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 39 | Advanced Stock Valuation
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 40 | Inventory/OP Base
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 40G | Grower Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 40P | Promotions Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 40R | Demand Scheduling
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 40S | Supply Chain Self Service
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 41 | Inventory Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 41B | Bulk Stock Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 42 | Sales Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 42B | Sales Order Entry
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 43 | Procurement
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 43A | Purchase Order Receipt/Routing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 43B | Voucher Match and Landed Cost
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 43C | Contracts
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 43E | Requisition Self Service
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 43Q | Strategic Sourcing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 43S | Supplier Self Service
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 44H | Homebuilder Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 45 | Advanced Pricing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
2 COLUMNS | TOP 812 | 46 | Warehouse Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 46L | License Plating
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 46R | RFID Outbound
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 47 | Electronic Commerce
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 48 | Work Order Processing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 48S | Service Billing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 49 | Transportation Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 51 | Job Costing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 52 | Contract Billing
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 53 | Change Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 55 | Reserved for Clients
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 57 | Reserved for Clients
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 58 | Reserved for Clients
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 73 | M & D complementary products
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 74 | EMEA Localization
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 74B | Begium Localization
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 74D | Germany - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 74F | France - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 74H | Hungary
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 74P | Poland
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 74R | CIS
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 74S | Spain
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 74U | United Kingdom Localizations
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 74W | Sweden - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 74Y | Italy - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 75A | Australia - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 75C | China - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 75J | Japan - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 75T | Taiwan
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 75Z | New Zealand - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 76A | Argentina
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 76B | Brazil - Reporting System Only
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 76C | Colombia
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 76E | Ecuador
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 76H | Chile
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 76M | Mexico
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 76P | Peru
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 76V | Venezuela
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 77 | Payroll (Canadian)
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 77Y | Canada Payroll Year End
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 80 | COBOL Translator - obsolete-do not reuse
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 81 | DREAM Writer
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 81A | DREAMWriter Conversion Tool
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 83 | Management Reporting - FASTR
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 87 | JDE Internal
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 89 | Conversion Programs
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 90CA | CRM Foundation
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 90CB | CRM Sales Force Automation
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 90CC | CRM Marketing Automation
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 90CD | CRM Service Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 90CE | CRM Solution Advisor
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 90CF | CRM Call Scripting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 90CG | CRM Case Management
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 98 | Technical Tools
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 98SA | Sample Application
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | D3N | dcLINK (data collection) - DSI
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H79 | CS - Forecasting
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H90 | ONEWORLD TOOLS
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H91 | Design Tools
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H92 | Interactive Engine/OL
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H93 | Data Base and Communications
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H94 | Batch Engine
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H95 | Tech Resources/Applications
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H96 | Deployment
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H96B | Package Build
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H96P | Product Packaging Tools
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H96U | Upgrade
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H97 | Benchmarking/Performance
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | H98 | Internet
| Schema | Table | Table Description | Column# | Prefix | Alias | Description | Data Type | Edit Type | Length | Decimals |
|---|
0 COLUMNS | TOP 812 | 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 46 / IT (INSTRUCTION TABLE) STOCK VALUES
| Value | Description | Special Handling Code | Hard Coded | |
|---|---|---|---|---|
| 1 | PREPA | Order Preparation | N | |
| 2 | STOCK | Putaway Instruction-All Items | N | |
| 3 | SC1 | Type 1 Secured Items-HiVal | N | |
| 4 | SC2 | Type 2 Secured Items-Narcotic | N | |
| 5 | SC3 | Type 3 Secured Items-Metals | N | |
| 6 | SH | Shoes | ||
| 7 | S1 | Shoes | ||
| 8 | TAPE | Tape Instruction Table | ||
| 9 | UFO | Unidentified Foreign Objects | N | |
| 10 | V | Vitamins | ||
| 11 | V1 | Vitamins 100 count | ||
| 12 | V2 | Vitamins 250 count | ||
| 13 | V3 | Vitamins | N | |
| 14 | W1 | Water | ||
| 15 | W2 | Water - Picking | N | |
| 16 | HI | High Rack Zone | ||
| 17 | HI2 | High Rack Zone | ||
| 18 | HI3 | High Rack Zone | ||
| 19 | ICE | Frozen Products Fast Item | N | |
| 20 | KIT | Stereo Wiring Kit | ||
| 21 | NON | Non-Inventory Items | N | |
| 22 | OFC1 | Office Products #1 | ||
| 23 | OFC2 | Office Products #2 | ||
| 24 | OFC3 | Office Products #3 | ||
| 25 | OFC4 | Office Products #4 | ||
| 26 | OG | Office Group | ||
| 27 | PA | Paper | ||
| 28 | PH1 | Paper - Heavy | N | |
| 29 | PICK | Picking Instruction Table | ||
| 30 | PK1 | Pick Rule #1 | ||
| 31 | PK2 | Pick Rule #2 | ||
| 32 | PK3 | Pick Rule #3 | ||
| 33 | PL | Pallet Zone | ||
| 34 | PROMO | Promo Items | N | |
| 35 | PUT | Putaway Instruction Table | ||
| 36 | P1 | Paper | ||
| 37 | REPL | Replenishment Instruction Tabl | ||
| 38 | RET | Returned Items | N | |
| 39 | ADV | Advertising Instruction Table | ||
| 40 | BIKE | Bicycles | N | |
| 41 | BM1 | Explosive Products (boomer) | N | |
| 42 | BM2 | Explosive Products (boomer) | N | |
| 43 | BU | Bulk Zone | ||
| 44 | COLD | Cold Type Items | N | |
| 45 | CS | Case Rule | ||
| 46 | C1 | CD Type Items | N | |
| 47 | ELEC | Electronics | ||
| 48 | E1 | Envelopes | N | |
| 49 | GD1 | Precious Metal Products | N | |
| 50 | HAZD | Hazardous materials | N |