Other tables & objects
461 Object
Other tables & objects — 461 object in the standard vanilla Ross ERP 8.0 modules with fewer than 10 objects.
| Object | Name | Description |
|---|---|---|
| ACCOUNT_TYPES | General Ledger Account Types | table · FIN · 9 columns |
| ACTION_PARAMETERS | Action Parameters | table · FIN · 15 columns |
| ACTIVE_JOBS | ACTIVE VXL JOBS | table · MAN · 7 columns |
| AGGREGATION_FIELDS | table · FIN · 8 columns | |
| AMENDABLE_CHECK_RUNS | Joins AP_CONTROLS_CHECK_RUNS, CHECKS | view · FIN |
| ASN_HEADERS | ASN Headers | table · FIN · 37 columns |
| ASN_LINES | ASN Lines | table · FIN · 110 columns |
| ASN_LOAD_CARRIERS | ASN Load Carriers | table · FIN · 34 columns |
| AUDIT_REASON_CODES | table · FIN · 5 columns | |
| AUDIT_TRAIL | Metadata audit trail | table · FIN · 10 columns |
| A_BANK_STATEMENT_DETAILS | Bank Statement Details Archive | table · FIN · 22 columns |
| A_BANK_STATEMENT_HEADER | Bank Statement Header Archive | table · FIN · 16 columns |
| A_BATCH_TIME_CARDS | Archived Labour Time Cards | table · MAN · 44 columns |
| A_BIN_MOVEMENT_HISTORY | Archive Bin Movements History | table · FIN · 35 columns |
| A_CHARGE_ACCOUNT_EXPENSE_HIST | ARCHIVED CHARGE ACCOUNT EXPENSE HISTORY | table · MAN · 22 columns |
| A_CHARGE_ACCOUNT_MASTER | ARCHIVED CHARGE ACCOUNT MODULE - MASTER DATABASE TABLE | table · MAN · 41 columns |
| A_DESPATCH_HEADERS | Archived Despatch Note Headers | table · FIN · 24 columns |
| A_DESPATCH_NOTES | Archived Despatch Notes | table · FIN · 123 columns |
| A_DESPATCH_NOTE_QTYS | Archived Despatch Note QTYS | table · FIN · 19 columns |
| A_INVENTORY_MOVEMENTS | Archive Inventory Movements | table · FIN · 53 columns |
| A_INVOICE_PICK_LIST | Archived Picking List Produced By SOP Invoicing | table · FIN · 25 columns |
| A_INV_TRANSACTIONS | Archived Inventory Transactions | table · FIN · 25 columns |
| A_INV_TRANSACTION_DETAILS | Archived Inventory Transaction Details | table · FIN · 27 columns |
| A_INV_TRANSACTION_LINES | Archived Inventory Transaction Lines | table · FIN · 64 columns |
| A_JOBS | Archived Jobs | table · MAN · 73 columns |
| A_LINK_INV_GRN | Archived Link Purchase invoices to Goods Received Notes | table · FIN · 22 columns |
| A_LINK_INV_PO | Archived Link Purchase invoices to Purchase Orders | table · FIN · 24 columns |
| A_LINK_PO_GRN | Archived Link Goods Received to Purchase Orders | table · FIN · 25 columns |
| A_MACHINE_TIME_INPUT | table · MAN · 30 columns | |
| A_MANUAL_PAYMENTS | Archive Manual Payments | table · FIN · 26 columns |
| A_MANUAL_PAYMENT_LINES | Archive Manual Payment Batch Lines | table · FIN · 55 columns |
| A_MISCELLANEOUS_CHARGES | Archived Miscellaneous Charges | table · MAN · 29 columns |
| A_MM_MAINTENANCE_COSTS | Maintenance Cost Table | table · MAN · 47 columns |
| A_PERIOD_USAGE | Archived Part Period Usage | table · FIN · 11 columns |
| A_PICK_LISTS | Archived Picking Lists | table · FIN · 80 columns |
| A_REORDERS | Archived Recommended Inventory Reorders | table · FIN · 21 columns |
| A_RETURNS | Archived Returned goods | table · FIN · 43 columns |
| A_STOCK_SPLIT_DETAILS | Archived Stock Split Details | table · FIN · 21 columns |
| A_STOCK_SPLIT_HEADER | Archived Stock Splits Header | table · FIN · 16 columns |
| A_STOCK_SPLIT_LINES | Archived Stock Split Lines | table · FIN · 18 columns |
| A_TAX_TRANSACTIONS | Archive Tax Transactions | table · FIN · 42 columns |
| A_TIME_CARD_COMMENTS | Archived Time Card Comment Codes | table · MAN · 11 columns |
| A_VENDOR_BALANCES | Archive Vendor Balances | table · FIN · 19 columns |
| A_YIELD_JOB_HEADERS | Archived Yield Code Headers for Jobs | table · MAN · 16 columns |
| A_YIELD_JOB_LINES | Archived Yield Job Lines | table · MAN · 18 columns |
| BANK_CODES | Bank Account Codes | table · FIN · 73 columns |
| BANK_RECONCILIATION_SORT_CODES | Bank Reconcilliation Sort code descriptions | table · FIN · 3 columns |
| BANK_STATEMENT_DETAILS | Bank Statement Details | table · FIN · 19 columns |
| BANK_STATEMENT_HEADER | Bank Statement Header | table · FIN · 13 columns |
| BARCODE_FORMATS | Barcode Print Formats | table · FIN · 10 columns |
| BARCODE_LABEL_FORMAT_CODES | Barcode Label Format Codes | table · FIN · 5 columns |
| BARCODE_LABEL_FORMAT_DETAILS | Barcode label format details | table · FIN · 4 columns |
| BATCH_BIN_ISSUE | Batch Material Inputs Bin Issue | table · MAN · 18 columns |
| BATCH_MATERIAL_INPUTS | Batch Material Inputs | table · MAN · 31 columns |
| BATCH_PART_ISSUE | Batch Material Inputs Part Issue | table · MAN · 17 columns |
| BATCH_TIME_CARDS | Labour Time Cards | table · MAN · 44 columns |
| BILLBACKS_WORK | Billbacks Work | table · FIN · 15 columns |
| BILLBACK_REASON_CODES | Billback Reason Codes | table · FIN · 8 columns |
| BILL_OF_MATERIAL_LINE_ITEMS | BILL OF MATERIAL LINE ITEM TABLE | table · MAN · 25 columns |
| BILL_OF_MATERIAL_MASTER | BILL OF MATERIAL MASTER TABLE | table · MAN · 11 columns |
| BIN_CAPACITY | Joins BIN_LOCATIONS, BIN_LOCATION_DETAILS | view · FIN |
| BIN_DETAILS | Bin Location Summary | view · FIN |
| BIN_LOCATIONS | Bin Locations | table · FIN · 46 columns |
| BIN_LOCATION_DETAILS | Bin Location Qty Details | table · FIN · 26 columns |
| BIN_TYPES | Bin Location Types | table · FIN · 4 columns |
| BIN_TYPE_CAPACITY_BY_PART | Bin Type Capacity By Part | table · FIN · 7 columns |
| BOM_STRUCTURES | Bill of Material Structures | table · MAN · 13 columns |
| BOM_WORK_TABLE | Bill of Materials Work table | table · MAN · 9 columns |
| BROKER_CODES | Broker Data for Pricing and Promotion Management | table · FIN · 26 columns |
| BUDGET_FORMATS | Budget Formats | table · FIN · 19 columns |
| BUYER_CODES | Buyer Codes | table · FIN · 5 columns |
| CAMPAIGN_CODES | info of campaign codes | table · MAN · 5 columns |
| CAMPAIGN_LIST | info of campaign list | table · MAN · 9 columns |
| CAMPAIGN_PICK_LIST | Planning Specification Allocation Factories | view · MAN |
| CARRIER_CODES | Carrier Codes | table · FIN · 7 columns |
| CARRIER_ID_LOV | Carrier IDs LOV. | view · FIN |
| CARRIER_INFO_CODES_LOV | Carrier Info Codes LOV. | view · FIN |
| CARRIER_INFO_XREF | Reference table across CARRIER_CODES and SHIPPING_INFO_CODES | table · FIN · 7 columns |
| CART_ITEM | Cart Item Detail | table · FIN · 9 columns |
| CART_MASTER | Cart Master | table · FIN · 6 columns |
| CHANGEOVER_SPECIFICATIONS | Changeover Specifications | table · MAN · 10 columns |
| CHARACTERISTIC_CODES | Characteristic Codes | table · FIN · 6 columns |
| CHARGE_ACCOUNT_CATEGORY_CODES | CHARGE ACCOUNT CATEGORY CODES | table · MAN · 8 columns |
| CHARGE_ACCOUNT_CLASS_CODES | Charge Account Classification Codes | table · MAN · 8 columns |
| CHARGE_ACCOUNT_EXPENSE_HISTORY | CHARGE ACCOUNT EXPENSE HISTORY | table · MAN · 18 columns |
| CHARGE_ACCOUNT_MASTER | CHARGE ACCOUNT MODULE - MASTER DATABASE TABLE | table · MAN · 37 columns |
| CHECKS | Checks | table · FIN · 25 columns |
| CHECK_LINES | Check Lines | table · FIN · 55 columns |
| CHECK_PRINT_CONTROL | Check Print Control (for continuous stationery) | table · FIN · 7 columns |
| CHECK_SUM_CODES | Check Sum Codes Table | table · FIN · 3 columns |
| CLOSED_JOB_OUTPUTS | Closed Job Output Lines | view · MAN |
| CM_REFERENCE_FIELDS | Reference fields for CM | table · FIN · 7 columns |
| COA_REPORT_FORMAT_CODES | Formats for Cetificate of Analysis | table · FIN · 5 columns |
| CODE39 | Code 39 Bar Code Table | table · FIN · 5 columns |
| COMPANIES | Joins GL_ENTITIES | view · FIN |
| COMPANY_CONTROLS | Company Controls | table · FIN · 157 columns |
| COMPANY_CURRENCY_RATES | Company currency exchange rates | table · FIN · 10 columns |
| COMPANY_PERIOD_CONTROLS | Company Period Dates by Year | table · FIN · 34 columns |
| CONFIRMED_DESPATCH_NOTES | Confirmed Despatch Notes awaiting Inventory Update | table · FIN · 7 columns |
| CONFIRM_EXPIRED_SHIPMENT_AUDIT | Confirm Expired Shipment Audit | table · FIN · 20 columns |
| CONTRACT_INVOICE_DETAILS | View for Contract Invoices | view · FIN |
| CORPORATE_ADDRESSES | Corporate Addresses | table · FIN · 29 columns |
| COST_CATEGORIES | Manufacturing Cost Categories | table · MAN · 12 columns |
| COST_CATEGORY_GROUPS | Cost Category Groups | table · MAN · 4 columns |
| COST_CENTERS | Joins COMPANY_CONTROLS, GL_ENTITIES, GL_STRUCTURE | view · FIN |
| COST_CENTER_CODES | Cost Center Codes | table · FIN · 6 columns |
| COST_DEFAULT_CODES | Inventory Cost Default Codes | table · FIN · 3 columns |
| COST_TYPES | Cost Types | table · FIN · 5 columns |
| COST_UPDATE_CODES | Inventory Cost Update Codes | table · FIN · 3 columns |
| CPANEL_CONTROLS | Cpanel Configuration Table | table · FIN · 24 columns |
| CREDIT_HOLD_STATUS_CODES | Credit Hold Status Codes | table · FIN · 4 columns |
| CREDIT_LIMIT_CONTROLS | Credit Limit Controls | table · FIN · 41 columns |
| CREDIT_STATUS | Credit Status | table · FIN · 4 columns |
| CREDIT_TERMS | Credit Terms Codes | table · FIN · 14 columns |
| CREDIT_TERMS_DISCOUNTS | Credit Terms Cash Discounts | table · FIN · 6 columns |
| CREDIT_TERMS_LINES | Credit Terms Lines | table · FIN · 14 columns |
| CRITERIA_CODES | Picking Criteria Codes | table · FIN · 27 columns |
| CUSTOMERS | Customers | table · FIN · 184 columns |
| CUSTOMERS_PART_CODE_VW | Customer Part Code alongside Part Code | view · FIN |
| DATA_ZONE_CONTROLS | Data Zone Controls | table · FIN · 6 columns |
| DATE_PAYMENT_TYPES | Date Payment Types | table · FIN · 3 columns |
| DEBT_LETTERS | Debt Letter Codes | table · FIN · 7 columns |
| DEBT_LETTER_LEVELS | Debt Letter Levels | table · FIN · 7 columns |
| DESCRIPTION_CODES | Description Codes | table · MAN · 13 columns |
| DESPATCH_HEADERS | Despatch Note Headers | table · FIN · 43 columns |
| DESPATCH_NOTES | Despatch Notes | table · FIN · 154 columns |
| DESPATCH_NOTES_AUDIT | Despatch Notes Audit | table · FIN · 11 columns |
| DESPATCH_NOTES_NOTE_QTYS | Despatch Note and Despatch Note Qtys | view · FIN |
| DESPATCH_NOTE_QTYS | Despatch Note QTYS | table · FIN · 17 columns |
| DESPATCH_NOTE_SEALS | Shipping Note Seal Information | table · FIN · 8 columns |
| DESTINATION_TYPES | Material Destination Types | table · MAN · 3 columns |
| DIARY_STATUS | Diary Status Codes | table · FIN · 4 columns |
| DIARY_TYPES | Diary Type Codes | table · FIN · 4 columns |
| DISTRIBUTION_CALENDAR | Planning Distribution Days Calendar | table · MAN · 5 columns |
| DIVISIONS | Joins COMPANY_CONTROLS, GL_ENTITIES, GL_STRUCTURE | view · FIN |
| DIVISION_CODES | Divisions and Matching GL Elements | table · FIN · 6 columns |
| DL_DEFAULT_LETTERS | Debt Letters Default Letters | table · FIN · 5 columns |
| EDI_CUST_ADDR_DATA | table · FIN · 9 columns | |
| EDI_PMBC_DATA | table · FIN · 13 columns | |
| EDI_USER_DEFINED_FIELDS | table · FIN · 30 columns | |
| EMPLOYEES | Employee Codes | table · MAN · 14 columns |
| ENVIRONMENTAL_CODES | EPA Codes | table · FIN · 3 columns |
| EOQ_UPDATE_CODES | Economic Order Qty Update Codes | table · FIN · 3 columns |
| EQM_BOM_XREF | EQUIPMENT-TO-BOM CROSS_REFERENCE | table · MAN · 8 columns |
| EQUIP_BUILDING_LOCATION_CODES | EQUIPMENT BUILDING LOCATIONS | table · MAN · 9 columns |
| EQUIP_SPECIFICATION_DATA_SHEET | Equip Specification Items | table · MAN · 7 columns |
| EQUIP_SPECIFICATION_DATA_XREF | EQUIPMENT SPECIFICATION DATA CROSS-REFERENCES | table · MAN · 9 columns |
| EQUIP_SPECIFICATION_MASTER | EQUIPMENT SPECIFICATION MASTER TABLE | table · MAN · 8 columns |
| ES_DEFAULT_FACILITIES | e-Signature Default Facilities | table · FIN · 4 columns |
| ES_FACILITY_SECURITY | e-Signature Facility Security | table · FIN · 8 columns |
| ES_REASON_CODES | e-Signature Reason Codes | table · FIN · 5 columns |
| ES_USER_SECURITY | e-Signature User Security | table · FIN · 8 columns |
| EV_USER_DEFAULTS | EV user's default option | table · FIN · 3 columns |
| EV_USER_LAYOUT_PANELS | layout for EV, with multi view support | table · FIN · 7 columns |
| EV_USER_LAYOUT_PANEL_DETAILS | layout detail for EV, with multi view support | table · FIN · 7 columns |
| EV_WIDGET_GROUPS | table · FIN · 5 columns | |
| FACTORIES | Factories | table · MAN · 51 columns |
| FACTORY_LOCATIONS | Factory Locations | table · MAN · 5 columns |
| FACTORY_THRESHOLDS | Factory Thresholds | table · MAN · 9 columns |
| FILTER_EXPRESSIONS | the detail expression of filters | table · FIN · 10 columns |
| FILTER_HEADERS | table · FIN · 3 columns | |
| FOF_CONTROLS | Forms Output Formatter Controls | table · FIN · 8 columns |
| FOOD_ALLERGENS | Food allergens | table · FIN · 3 columns |
| FORECAST_ITERATIONS | Planning Forecast Iteration Codes | table · MAN · 5 columns |
| FREIGHT_CLASSES | Freight Classes | table · FIN · 4 columns |
| FS_INPUTS | Finite Scheduler Inputs | table · MAN · 10 columns |
| FS_OUTPUTS | Finite Scheduler Material Inputs | table · MAN · 8 columns |
| FYE_CONTROLS | Fiscal Year End Controls | table · FIN · 35 columns |
| GENERIC_PRODUCTS | Generic Products | table · MAN · 18 columns |
| GENERIC_PRODUCT_FACTORIES | Generic Product Factories | view · MAN |
| GENERIC_PRODUCT_SPECS | Production Flow LOV. | view · MAN |
| GENERIC_SCM_PROD_FACTORIES | SCM Product Warehouse Factory allocation | view · MAN |
| GENERIC_STRUCTURE_CODES | Generic Structure Codes | table · FIN · 3 columns |
| GRN_NUMBERS_TO_INVOICE | List GRN's with quantities to invoice for a part | view · FIN |
| GRN_WITH_LINES_TO_INVOICE | List GRN's with Part Code to invoice | view · FIN |
| GRN_WITH_PO_NUMBERS_TO_INVOICE | List GRN's with PO's with quantities to invoice for a part | view · FIN |
| HOLD_STATUS_CODES | Sales Order Hold Status Codes | table · FIN · 4 columns |
| HORIZONTAL_FORMATS | Column Formats | table · FIN · 4 columns |
| HORIZONTAL_FORMAT_DETAILS | GL Report Column Format Details | table · FIN · 21 columns |
| IAF_EVENT_PARAMETERS | Parameters of a stored event | table · FIN · 4 columns |
| IAF_EVENT_STORE_FORWARD | Event storage when Event Engine is down | table · FIN · 5 columns |
| INTERCOMPANY_ACCOUNTS | GL Control Accounts for Intercompany Postings | table · FIN · 6 columns |
| INTERCOMPANY_ENTITY_CODES | Intercompany Entity Code Mappings | table · FIN · 7 columns |
| INTERCOMPANY_ORDERS_XREF | Intercompany orders cross reference | table · FIN · 13 columns |
| INTERCOMPANY_PART_CODES | Intercompany part code details | table · FIN · 5 columns |
| INTERELEMENT_ACCOUNTS | Inter Element Accounts | table · FIN · 9 columns |
| INTERFACE_PROCESS_LOGS | table · FIN · 34 columns | |
| INTERFACE_PROCESS_LOG_DETAILS | table · FIN · 10 columns | |
| INVENTORY_FORECASTS | Inventory Forecasts | table · MAN · 10 columns |
| INVENTORY_FORECAST_CODES | Inventory Forecast Codes | table · MAN · 4 columns |
| INVENTORY_MOVEMENTS_CONTROL | IC Movement Control | table · FIN · 48 columns |
| INVENTORY_TAGS | Inventory Counting Tags | table · FIN · 16 columns |
| INVOICE_APPROVAL_CODES | Purchase Invoice Approval Codes | table · FIN · 5 columns |
| INVOICE_PICK_LIST | Picking List Produced By SOP Invoicing | table · FIN · 22 columns |
| INV_TRANSACTIONS | Inventory Transactions | table · FIN · 22 columns |
| INV_TRANSACTION_DESN | Inventory Transaction Destination Details | table · FIN · 21 columns |
| INV_TRANSACTION_DETAILS | Inventory Transaction Details | table · FIN · 24 columns |
| INV_TRANSACTION_LINES | Inventory Transaction Lines | table · FIN · 69 columns |
| INV_TRANSACTION_SOURCE | Inventory Transactions Source Details | table · FIN · 20 columns |
| INV_VALUATION_METHODS | Inventory Valuation Methods | table · FIN · 3 columns |
| ISSUE_INSTRUCTIONS | Data Capture Issue Instructions | table · FIN · 14 columns |
| ISSUE_SEQUENCE_NUMBERS | Data Capture Issue Sequence Numbers | table · FIN · 2 columns |
| JOBS | Archived Jobs | table · MAN · 90 columns |
| JOBS_DESC_LIST | Job Description List | view · MAN |
| JOBS_UNRELEASED_SCHED_RUNS | UNRELEASED SCHEDULED JOBS | view · MAN |
| LABEL_PRINTERS | Barcode Label Printers | table · FIN · 7 columns |
| LABOUR_CLASSES | Labor Classes | table · MAN · 38 columns |
| LABOUR_CLASS_COSTS | Labour Class Costs | table · MAN · 15 columns |
| LABOUR_TYPES | Labor Types | table · MAN · 10 columns |
| LANDED_COST_CALC_METHODS | Landed Cost Calculation Method | table · FIN · 3 columns |
| LANDED_COST_GROUPS | Landed Cost Groups | table · FIN · 4 columns |
| LANDED_COST_STANDARDS | Landed Cost Standard | table · FIN · 18 columns |
| LANDED_COST_TYPES | Landed Cost Type | table · FIN · 8 columns |
| LETTERS | Letters | table · FIN · 11 columns |
| LETTER_LINES | Letter Selection Criteria | table · FIN · 7 columns |
| LINE_DISCOUNT_CUST_FLAGS | Line Discount Customer Flags | table · FIN · 3 columns |
| LINE_DISCOUNT_INV_FLAGS | Line Discount Inventory Flags | table · FIN · 3 columns |
| LINK_INV_GRN | Link Purchase invoices to Goods Received Notes | table · FIN · 19 columns |
| LINK_INV_PO | Link Purchase invoices to Purchase Orders | table · FIN · 21 columns |
| LINK_PO_DEL_GRN | Link of POP_LINE_DELIVERY_DETAILS to GRN_LINES | table · FIN · 14 columns |
| LINK_PO_GRN | Link Goods Received to Purchase Orders | table · FIN · 22 columns |
| LINK_RETURN_CREDITS | Link supplier returns and associated credits | table · FIN · 6 columns |
| LOCATIONS | Customer Locations | table · FIN · 5 columns |
| LPN_LINES_VIEW | LPN and LPN lines view | view · FIN |
| LS_STATE_LICENSES | Stored State License and expiration | table · FIN · 9 columns |
| MACHINES | Machines | table · MAN · 39 columns |
| MACHINE_COSTS | Machine Costs | table · MAN · 16 columns |
| MACHINE_NUMBERS | Multiple Identical Machines | table · MAN · 8 columns |
| MACHINE_TIME_INPUT | Machine Time Input | table · MAN · 38 columns |
| MANUAL_PAYMENTS | Manual Payments | table · FIN · 24 columns |
| MANUAL_PAYMENT_LINES | Manual Payment Batch Lines | table · FIN · 50 columns |
| MANUAL_PAYMENT_TAX_DETAILS | Payment Tax Details | table · FIN · 19 columns |
| MANUAL_PUSH | table · FIN · 9 columns | |
| MASTER_PRODUCTION_SCHEDULE | Master Production Schedule | table · MAN · 51 columns |
| MATERIAL_INPUT_PROFILES | Raw Material Input Profile Details | table · MAN · 13 columns |
| MATERIAL_OUTPUT_PROFILES | Planning Spec Material Output Profiles | table · MAN · 13 columns |
| MATERIAL_REQUISITION_APPROVALS | Requisition Approvals, Authorizers from Group and Approve Dt | table · FIN · 6 columns |
| MCP_CONTROL | Monitor Control Program Control | table · FIN · 5 columns |
| MESSAGE_CODES | Message Codes | table · FIN · 6 columns |
| MISCELLANEOUS_ADJUSTMENTS | Miscellaneous Adjustments | table · FIN · 17 columns |
| MISCELLANEOUS_CHARGES | Miscellaneous Charges | table · MAN · 26 columns |
| MISC_RESOURCES | Miscellaneous Resources | table · MAN · 17 columns |
| MISC_RESOURCE_COSTS | Miscellaneous Resource Costs | table · MAN · 14 columns |
| MM_MAINTENANCE_COSTS | Maintenance Cost Table | table · MAN · 43 columns |
| MM_METER_READINGS | Maintenance Meter readings | table · MAN · 10 columns |
| MM_REPET_TASK_TRIGGERS | MM Repetitive Task Triggers | table · MAN · 17 columns |
| MM_ROLLING_METER_READINGS | MM Rolling Meter Readings | table · MAN · 10 columns |
| MPS_INPUT_FORECASTS | table · MAN · 9 columns | |
| MPS_INPUT_OPTIONS | table · MAN · 8 columns | |
| MPS_INPUT_PHASES | table · MAN · 12 columns | |
| NETTING_TRANSACTION_HEADERS | table · FIN · 17 columns | |
| NETTING_TRANSACTION_LINES | table · FIN · 22 columns | |
| NOTEBOOK_MASTER | Notebook Master | table · MAN · 7 columns |
| ORDER_DISCOUNT_GROUPS | Order Discount Groups | table · FIN · 8 columns |
| ORDER_TYPE_CODES | Order Type Codes | table · FIN · 4 columns |
| OUTPUT_LEN | Output Length Fields | table · MAN · 45 columns |
| PAEXTR | table · FIN · 56 columns | |
| PART_BATCHES | Lots | table · FIN · 42 columns |
| PART_BY_CUSTOMER_EXP_NOTES | Notes for Porduct customer details | table · FIN · 9 columns |
| PART_MANU_COSTS | Part Manufacturing Costs | table · MAN · 14 columns |
| PART_MANU_FUTURE_COSTS | Future Cost per costing unit and cost category | table · MAN · 14 columns |
| PART_MANU_PRELIM_COSTS | Preliminary Cost per costing unit and cost category | table · MAN · 13 columns |
| PART_MASTER_BY_CUSTOMER | table · FIN · 36 columns | |
| PART_MASTER_M | Manufacturing Part Master | table · MAN · 59 columns |
| PART_PERIOD_END_CONTROLS | Part Period End Controls | table · FIN · 22 columns |
| PART_UOM_CONVERSIONS | Part Code Unit of Measure Conversions | table · FIN · 14 columns |
| PAYEES | Payees | table · FIN · 53 columns |
| PAYEE_BANKS | Payee Banks | table · FIN · 26 columns |
| PAYMENT_CODES | Payment Method Codes | table · FIN · 3 columns |
| PAYMENT_CUSTOMERS_INFO | Payment Customer Information | view · FIN |
| PAYMENT_CUSTOMERS_INFO_1 | Payment Customer Information 1 | view · FIN |
| PAYMENT_FREQUENCIES | Payment Frequency Codes | table · FIN · 3 columns |
| PAYMENT_TYPES | Payment Form Types | table · FIN · 4 columns |
| PC_EXPORT | PC Export | table · FIN · 14 columns |
| PC_EXPORT_LINES | PC Export Lines | table · FIN · 7 columns |
| PC_IMPORT | PC Import Header | table · FIN · 12 columns |
| PC_IMPORT_FIELDS | PC Import Fields | table · FIN · 8 columns |
| PERIOD_USAGE | Part Period Usage | table · FIN · 7 columns |
| PICK_LISTS | Picking Lists | table · FIN · 78 columns |
| PLANNER_CODES | Planner Codes | table · FIN · 4 columns |
| PLAN_DIRECTORY | MPS Plan Directory | table · MAN · 24 columns |
| PLM_ERP_XREF | ERP Product/PLM Material Cross Reference table | table · FIN · 8 columns |
| PLM_INTERFACE_CONTROLS | PLM Interface controls table | table · FIN · 5 columns |
| PLM_MATERIAL_TYPES | PLM Material Type Code Definition table | table · FIN · 3 columns |
| PLM_XREF_LOAD_AUDIT | Load PLM-ERP Cross Reference audit log | table · FIN · 7 columns |
| POINT_DATATYPES | Point datatypes | table · MAN · 5 columns |
| POSTING_FORMATS | Posting Formats | table · FIN · 6 columns |
| POSTING_FORMAT_LINES | Posting Format Lines | table · FIN · 9 columns |
| PO_NUMBERS_TO_INVOICE | List PO's with quantities to invoice for a part | view · FIN |
| PO_TYPES | Purchase Order Types | table · FIN · 4 columns |
| PP_CALENDAR | Process Planning Calendar | table · MAN · 16 columns |
| PP_CALENDAR_WORK_CENTERS | Planning Calendar Work Centers | view · MAN |
| PP_FS_ALLOCATIONS | Finite Scheduler Intermediate Product Allocations | table · MAN · 11 columns |
| PP_PRODUCTION_FORECAST | PP Production Forecast | table · MAN · 11 columns |
| PP_PRODUCTION_FORECAST_CODES | ATP Production Forecast Codes | table · MAN · 5 columns |
| PP_TRANSACTION_TYPES | PP Transaction Types | table · MAN · 7 columns |
| PRICE_CODES | Price Codes | table · FIN · 6 columns |
| PRICING_CODES | Pricing Codes | table · FIN · 4 columns |
| PRINT_STATEMENTS | Print Statement Codes | table · FIN · 3 columns |
| PRODUCTION_PROFILES | Production Profiles | table · MAN · 12 columns |
| PROMOTION_PRICES | Promotion Prices | table · FIN · 13 columns |
| PROMOTION_PRICE_LINES | Promotion Price Lines | table · FIN · 15 columns |
| PT_INSTANCE_CONTROLS | Planet Together Instance List | table · MAN · 11 columns |
| PT_INTERFACE_CONTROLS | table · MAN · 13 columns | |
| PT_STAGING_JOBS | table · MAN · 22 columns | |
| PT_STAGING_JOBS_XREF | table · MAN · 22 columns | |
| PT_STAGING_JOB_STAGE | Planet Together Staging Job Stages | table · MAN · 21 columns |
| PT_STAGING_JOB_STAGE_LINES | Planet Together Staging Job Lines | table · MAN · 18 columns |
| QDOC_PART_LOV_VW | Joins IC_QUALITY_DOCS, IC_QUALITY_DOC_LINES, PRODUCT_MASTER | view · FIN |
| QDOC_WH_LOV_VW | Joins IC_QUALITY_DOCS, IC_QUALITY_DOC_LINES, WAREHOUSE_CONTROLS | view · FIN |
| QUALITY_CONTROL_CODES | Quality Control Codes | table · FIN · 5 columns |
| QUALITY_TEST_GROUPS | Quality Test Results Groups | table · FIN · 44 columns |
| QUALITY_TEST_GROUP_LOTS | Quality Test Group Lots | table · FIN · 5 columns |
| QUALITY_TEST_LIMITS | Quality Test Results Limits | table · FIN · 32 columns |
| QUALITY_TEST_RESULTS | Quality Test Results | table · FIN · 17 columns |
| QUALITY_TEST_SAMPLES | Quality Test Sample Headers | table · FIN · 20 columns |
| QUALITY_WORK_AREAS | table · FIN · 6 columns | |
| QUARANTINE_CODES | Quarantine Codes | table · FIN · 5 columns |
| RCCP_DETAILS | Rough Cut Capacity Planning Details | table · MAN · 29 columns |
| RCCP_DETAILS_RESOURCE_GROUPS | RCCP Details Resource Groups | view · MAN |
| RCCP_HEADERS | Rough Cut Capacity Planning Headers | table · MAN · 13 columns |
| RCS_DATA_CONVERSION_AUDIT | Audit trail for data conversions | table · FIN · 17 columns |
| RCS_EURO_CONVERT_HEADER | General information for Euro Conversion | table · FIN · 12 columns |
| RCS_EURO_CONVERT_MODULE | Details for Euro conversion by module | table · FIN · 8 columns |
| RECEIVED_CONFIRMATION_DATA | Received Data Capture Information | table · FIN · 10 columns |
| RECEIVED_QTYS_TO_LOCATE | GRN Numbers with quantities to locate | view · FIN |
| RECEIVED_SEQUENCE_NUMBERS | Received Data Capture Sequence Numbers | table · FIN · 2 columns |
| RECIPES | Product Recipes | table · MAN · 32 columns |
| RECIPE_INSTRUCTION_LINES | Recipe instruction line details | table · MAN · 11 columns |
| RECIPE_LINES | Recipe Lines | table · MAN · 101 columns |
| RECIPE_LINE_TAGS | Recipe Line TAGS | table · MAN · 19 columns |
| RECIPE_MACH_RES | Recipe Specific Machine Resource Codes | table · MAN · 11 columns |
| RECURRING_CHARGES | Recurring Charges | table · FIN · 52 columns |
| RECURRING_CHARGES_GL_POSTINGS | Recurring Charges GL Postings | table · FIN · 31 columns |
| RECURRING_CHARGE_LINES | Recurring Charges Detail Lines | table · FIN · 39 columns |
| RECURRING_CHARGE_TAX | Tax analysis for recurring charge | table · FIN · 19 columns |
| RECURRING_TEN99_DETAILS | Recurring Charge 1099 Details | table · FIN · 13 columns |
| REJECTION_CODES | Rejection Codes | table · FIN · 4 columns |
| REORDERS | Recommended Inventory Reorders | table · FIN · 18 columns |
| REPET_TASK_EQUIP_LINE_ITEM | Repetitive Task Line Item Master | table · MAN · 33 columns |
| REPET_TASK_EQUIP_TASK_MASTER | Equipment Repetitive Task Master | table · MAN · 52 columns |
| REPET_TASK_FREQUENCY_MASTER | REPETITIVE TASKING FREQUENCY MASTER | table · MAN · 12 columns |
| REPET_TASK_METER_MASTER | REPETITIVE TASKING METER MASTER | table · MAN · 23 columns |
| REPET_TASK_SAFETY_REQUIRE_XREF | REPETITIVE TASKING SAFETY REQUIREMENTS | table · MAN · 11 columns |
| REPORT_PRINT_CONTROLS | Report Print Controls | table · FIN · 28 columns |
| REQUESTOR_CODES | Requester Codes | table · FIN · 4 columns |
| REQUISITION_TYPES | Inventory Requisition Types | table · FIN · 5 columns |
| RESOURCE_FAMILIES | Resource Group Family Structure | table · MAN · 6 columns |
| RESOURCE_GROUPS | Planning Resource Groups | table · MAN · 10 columns |
| RETURNS | Returned goods | table · FIN · 44 columns |
| REV_REC_DESPATCH_NOTES | Revenue Recognition Shipping Notes | view · FIN |
| RF_EXPORTED_JOBS | Ross Factory need exported jobs | table · MAN · 35 columns |
| RF_EXPORTED_JOB_STAGES | Job Stages that are exported to Factory MES | view · MAN |
| RF_EXPORTED_TEST_REQS | Quality Test Requirements ready for export | table · FIN · 18 columns |
| RF_FACTORY_CONTROLS | Ross Factory Factory Controls | table · MAN · 17 columns |
| RF_PO_DIVISION_CONTROLS | table · FIN · 7 columns | |
| RRS_CONTROL_FLAG_DESCRIPTIONS | RRS Control Flag Description | table · FIN · 5 columns |
| RRS_JOB_STAGE_LINES | RRS Reports | view · MAN |
| SALESPERSONS | Sales Persons | table · FIN · 30 columns |
| SALESPERSON_GROUPS | Salesperson Groups | table · FIN · 4 columns |
| SCHEDULE_RUNS | Scheduling run header | table · MAN · 16 columns |
| SCHEDULE_RUN_DETAILS | Scheduling run Details | table · MAN · 14 columns |
| SCHEDULE_RUN_LABOUR | Scheduling Labour allocation records | table · MAN · 20 columns |
| SCHEDULE_RUN_MACHINES | Scheduling Machine Allocation | table · MAN · 23 columns |
| SCM_APS_DP_FACTORY_ALLOCATIONS | Warehouse to Factory Allocations | table · MAN · 9 columns |
| SCM_APS_DP_SPEC_ALLOCATIONS | Factory to Specification Allocations | table · MAN · 9 columns |
| SCM_APS_JOB_XREF | SCM APS job cross reference Data | table · MAN · 7 columns |
| SCM_APS_SPEC_DATA | SCM APS Specification Data | table · MAN · 18 columns |
| SCM_FORMAT_XREF | Record the execution of SCM Formats | table · FIN · 7 columns |
| SCM_KEYS | iRenaissance SMC keys | table · MAN · 7 columns |
| SCM_KEY_LINES | iRenaissance SMC key lines | table · MAN · 11 columns |
| SCM_SPEC_ALLOC_FACTORIES | SCM Planning Specification Allocation Factories | view · MAN |
| SCM_SPEC_ALLOC_PRODUCTS | SCM Planning Specification Allocation Products | view · MAN |
| SECURITY_ACCESS_MODES | Valid access modes | table · FIN · 3 columns |
| SECURITY_ACCOUNT_CODES | Accessible GL Account Codes by Transaction Type | table · FIN · 15 columns |
| SECURITY_DIVISION_ACCESS | Division Access by Security Group | table · FIN · 12 columns |
| SECURITY_GROUPS | User Security Groups | table · FIN · 4 columns |
| SECURITY_GROUP_ACCOUNTS | Accessible GL Account Codes by Security Group | table · FIN · 15 columns |
| SECURITY_PERIOD_ACCESS | Accessible Divisions/Factories/Warehouses | table · FIN · 11 columns |
| SECURITY_TRANSACTION_TYPES | Accessible Transaction Types | table · FIN · 8 columns |
| SELECTION_CRITERIA | Selection Criteria | table · FIN · 6 columns |
| SEND_TO_EXT_PROCESS_LOGS | table · FIN · 22 columns | |
| SEQUENCING_CALENDAR | Manufacturing Process Sequencing Calendar | table · MAN · 9 columns |
| SHIPMENT_DESPATCH_INF | Shipment Despatch Information | view · FIN |
| SHIPMENT_DESPATCH_INFO | Shipment Despatch Information | view · FIN |
| SHIPMENT_DETAILS | table · FIN · 9 columns | |
| SHIPMENT_HEADERS | Shipping Load Header Information | table · FIN · 9 columns |
| SHIPPING_INFO_CODES | Carrier Information Codes | table · FIN · 9 columns |
| SII_OPERATION_CODES | Operation codes for SII | table · FIN · 6 columns |
| SII_REGISTRO_DETAIL | table · FIN · 27 columns | |
| SII_REGISTRO_HEADER | table · FIN · 85 columns | |
| SII_TAX_LOG | SII TAX log data | table · FIN · 18 columns |
| SII_TAX_RETURN_ERROR | Identify SII tax to return error data for Web Service | table · FIN · 13 columns |
| SII_VALIDATION_CODES | Validation codes for SII master data | table · FIN · 5 columns |
| SOURCE_MODULES | Source Modules | table · FIN · 8 columns |
| SOURCE_TYPES | Material Source Types | table · MAN · 4 columns |
| SOURCE_TYPE_CODES | Available To Promise Source Type Codes | table · FIN · 3 columns |
| SPECIFICATION_CODES | Batch Characteristic Specification Codes | table · FIN · 5 columns |
| SPEC_FAMILIES | Specification Allocation Family | table · MAN · 11 columns |
| STANDARD_COST_HISTORY | table · FIN · 5 columns | |
| STATEMENT_LANGUAGE | Joins CUSTOMERS | view · FIN |
| STATEMENT_TRANSACTION_TYPES | Statement Transaction type descriptions | table · FIN · 3 columns |
| STATIONERY_CODES | Preprinted Stationery Codes | table · FIN · 7 columns |
| STATUS_CODES | Available To Promise Status Codes | table · FIN · 3 columns |
| STATUS_FLAGS | Status Flags | table · MAN · 4 columns |
| STOCK_SPLIT_DETAILS | Stock Split Details | table · FIN · 18 columns |
| STOCK_SPLIT_HEADER | Stock Splits Header | table · FIN · 13 columns |
| STOCK_SPLIT_LINES | Stock Split Lines | table · FIN · 16 columns |
| STOP_CODES | Stop Codes | table · FIN · 4 columns |
| SUPPLIER_PERFORMANCE_AGED | Supplier Performance Aged Data, Prices and Lead Times | table · FIN · 14 columns |
| SUPPLIER_PERFORMANCE_CONTROLS | Supplier Performance Control Flags | table · FIN · 20 columns |
| SUPPLIER_PERFORMANCE_DETAIL | Supplier Performance Details | table · FIN · 25 columns |
| SUPPLIER_PERFORMANCE_PERIODS | Supplier Performance Period Dates | table · FIN · 7 columns |
| SUPPLIER_PERFORMANCE_SUMMARY | Summary Supplier Performance Data | table · FIN · 26 columns |
| TAG_TABLE | PLC TAG Table | table · MAN · 6 columns |
| TAX_CODES | Tax Codes | table · FIN · 6 columns |
| TAX_RATES | Tax Rates | table · FIN · 46 columns |
| TAX_RETAINERS | Tax Retainers Transactions | table · FIN · 19 columns |
| TAX_TRANSACTIONS | Tax Transactions | table · FIN · 50 columns |
| TEMP_TAX_TRANSACTIONS | Temp Tax Transactions Table - Used with Tax on Cash | table · FIN · 46 columns |
| TEN99_CODES | US 1099 Codes | table · FIN · 3 columns |
| TEN99_TRANSACTIONS | U.S. 1099 Transactions | table · FIN · 33 columns |
| TEST_VALIDATION | UCC/EAN-128 Input Table | table · FIN · 2 columns |
| TIME_CARDS | Time Cards | table · MAN · 17 columns |
| TIME_CARD_COMMENTS | Time Card Comment Codes | table · MAN · 7 columns |
| TIME_CARD_MASTER | TIMECARD MASTER | table · MAN · 25 columns |
| TIME_CARD_OT_PAY_FACTOR_CODES | TIMECARD OVERTIME PAY FACTOR CODE | table · MAN · 7 columns |
| TIME_UNITS | Time Units | table · MAN · 4 columns |
| TRANS | text, length and translated text. | table · FIN · 7 columns |
| TRANSACTION_TYPES | Transaction Types | table · MAN · 8 columns |
| TRANSFER_ORDER_ENTITY_VIEW | View for Transfer Orders | view · FIN |
| UNITS_OF_MEASURE | Units of Measure | table · FIN · 8 columns |
| UNPROCESSED_PO_FOR_DELETE | Unprocessed PO for available for deletion. | view · FIN |
| USER_COMPANY_ID | System Security - User IDs | table · FIN · 18 columns |
| USER_DEFINED_WIDGET_FIELDS | table · FIN · 15 columns | |
| USER_FILTERS | user's filters | table · FIN · 5 columns |
| USER_FILTER_EXPRESSIONS | the detail composition of filters | table · FIN · 8 columns |
| USER_WIDGET_INSTANCES | ALL AVAILABLE WIDGETS INSTANCES | table · FIN · 5 columns |
| USER_WIDGET_SETTINGS | WIDGET'S SETTINGS BY USER | table · FIN · 6 columns |
| VALID_PUT_AWAY_FIELDS | Valid Fields for use as Put Away Fields | table · FIN · 4 columns |
| VENDORS | Vendors | table · FIN · 121 columns |
| VENDOR_ADDRESSES | Vendor Addresses | table · FIN · 48 columns |
| VENDOR_ADDRESS_BY_TP | Vendor Address by Trading Partner | table · FIN · 6 columns |
| VENDOR_BALANCES | Vendor Balances | table · FIN · 15 columns |
| VERTICAL_FORMATS | GL Report Writer Row Formats | table · FIN · 25 columns |
| VERTICAL_FORMAT_DETAILS | Row Format Details | table · FIN · 57 columns |
| VXL_ERROR | VXL Interface error messages | table · MAN · 7 columns |
| WAREHOUSE_CONTROLS | Warehouse Controls | table · FIN · 158 columns |
| WAREHOUSE_DESC | View for Warehouse in LOV | view · FIN |
| WAREHOUSE_FACTORY_ALLOCATIONS | Warehouse to Factory Distribution Profile | table · MAN · 7 columns |
| WAREHOUSE_PRODUCT_DESC | View for Warehouse LOV | view · FIN |
| WAREHOUSE_ZONES | Warehouse Zones | table · FIN · 5 columns |
| WIDGET_DRILLINS | table · FIN · 5 columns | |
| WMS_SYS_MESSAGES_HST | Messages returned during WMS data processing | table · FIN · 9 columns |
| WORKFLOW_EVENTS | Workflow Event Definitions | table · FIN · 16 columns |
| WORKFLOW_TRACKING | Workflow tracking data | table · FIN · 19 columns |
| WORKFLOW_TYPES | Workflow Types | table · FIN · 3 columns |
| YIELD_HEADERS | Yield Headers | table · MAN · 13 columns |
| YIELD_JOB_HEADERS | Yield Code Headers for Jobs | table · MAN · 19 columns |
| YIELD_JOB_LINES | Yield Job Lines | table · MAN · 24 columns |
| YIELD_LINES | Yield Lines | table · MAN · 17 columns |