Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 90 views

    Bom Tables4

    Uploaded by

    KrishnaChaitanyaChalavadi
    This document contains tables related to bills of materials (BOM), engineering changes, work-in-process (WIP), and interfaces between these systems. It lists over 50 tables used for BOM data like bills of materials, routes, resources, and configurations. It also includes tables for engineering changes like change orders, revisions, and approvals. Finally it lists WIP tables for jobs, schedules, resources, and transactions.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    Bom Tables4

    Uploaded by

    KrishnaChaitanyaChalavadi
    90 views2 pages
    This document contains tables related to bills of materials (BOM), engineering changes, work-in-process (WIP), and interfaces between these systems. It lists over 50 tables used for BOM data like bills of materials, routes, resources, and configurations. It also includes tables for engineering changes like change orders, revisions, and approvals. Finally it lists WIP tables for jobs, schedules, resources, and transactions.

    Original Title

    BOM_TABLES4.doc

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains tables related to bills of materials (BOM), engineering changes, work-in-process (WIP), and interfaces between these systems. It lists over 50 tables used for BOM data like bills of materials, routes, resources, and configurations. It also includes tables for engineering changes like change orders, revisions, and approvals. Finally it lists WIP tables for jobs, schedules, resources, and transactions.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    90 views2 pages

    Bom Tables4

    Uploaded by

    KrishnaChaitanyaChalavadi
    This document contains tables related to bills of materials (BOM), engineering changes, work-in-process (WIP), and interfaces between these systems. It lists over 50 tables used for BOM data like bills of materials, routes, resources, and configurations. It also includes tables for engineering changes like change orders, revisions, and approvals. Finally it lists WIP tables for jobs, schedules, resources, and transactions.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    You are on page 1of 2

    BOM tables

    BOM_ALTERNATE_DESIGNATORS Alternate designators


    BOM_ATO_CONFIGURATIONS Unique configuration definition
    BOM_BILL_OF_MATERIALS Bills of material
    BOM_CALENDARS Workday calendars
    BOM_CALENDAR_DATES Workday calendar dates
    BOM_CALENDAR_EXCEPTIONS Workday calendar exceptions
    BOM_CALENDAR_SHIFTS Workday calendar shifts
    BOM_DELETE_ENTITIES Deleted entities in BOM and INV
    BOM_DELETE_ERRORS Errors occurring when deleting entities
    BOM_DELETE_GROUPS Delete groups of BOM and INV entities
    BOM_DELETE_SQL_STATEMENTS SQL statements used to check and delete entities
    BOM_DELETE_SUB_ENTITIES Component and operations to be deleted
    BOM_DEPARTMENTS Departments
    BOM_DEPARTMENT_CLASSES Department classes
    BOM_DEPARTMENT_RESOURCES Resources associated with departments
    BOM_EXCEPTION_SETS Exception sets
    BOM_EXPLOSIONS Pre–exploded model bills for use by Order Entry
    BOM_EXPLOSION_TEMP Temporary data for indented bills of materialprocesses)
    BOM_INVENTORY_COMPONENTS Bill of material components
    BOM_LISTS Temporary list of data about reporting entities
    BOM_OPERATIONAL_ROUTINGS Routings
    BOM_OPERATION_RESOURCES Resources on operations
    BOM_OPERATION_SEQUENCES Routing operations
    BOM_OP_RESOURCES_ARCHIVE Archive of deleted resources on operations
    BOM_OP_SEQUENCES_ARCHIVE Routing operations
    BOM_PARAMETERS Bills of material parameters
    BOM_REFERENCE_DESIGNATORS Component reference designators
    BOM_RESOURCES Resources, overheads, material cost codes, and material
    overheads
    BOM_RESOURCE_SETUPS Resource Setups
    BOM_RESOURCE_SHIFTS Resource shift information
    BOM_SETUP_TRANSITIONS Setup Transitions
    BOM_SETUP_TYPES Setup Types
    BOM_SHIFT_DATES Workday calendar shift dates
    BOM_SHIFT_EXCEPTIONS Workday calendar shift exceptions
    BOM_SHIFT_TIMES Workday calendar shift times
    BOM_STANDARD_OPERATIONS Standard operations
    BOM_STD_OP_RESOURCES Standard operation resources
    BOM_SUBSTITUTE_COMPONENTS Substitute components
    BOM_WORKDAY_PATTERNS On/Off workday patterns for calendars and shifts

    Interface tables

    BOM_BILL_OF_MTLS_INTERFACE Bills of material interface table


    BOM_INTERFACE_DELETE_GROUPS Delete group names for Bill, Routing and Engineering
    change order Open Interface
    BOM_INVENTORY_COMPS_INTERFACE Bill of material components interface data
    BOM_OP_RESOURCES_INTERFACE Operation resources interface data
    BOM_OP_ROUTINGS_INTERFACE Routing interface data
    BOM_OP_SEQUENCES_INTERFACE Routing operation interface data
    BOM_REF_DESGS_INTERFACE Reference designator interface data
    BOM_SUB_COMPS_INTERFACE Substitute component interface data
    Engineering:
    ENG_AUTO_NUMBER_ECN Holds the prefix and numbers for auto numbering an
    engineering change order (ECO)
    ENG_CHANGE_ORDER_REVISIONS Engineering change order (ECO) reasons
    ENG_CHANGE_ORDER_TYPES Engineering change order types
    ENG_CHANGE_PRIORITIES Engineering change order priorities
    ENG_CHANGE_REASONS Engineering change order reasons
    ENG_CURRENT_SCHEDULED_DATES Current and historical ECO scheduled implementation dates
    ENG_ECN_APPROVAL_LISTS Engineering change order approval lists
    ENG_ECN_APPROVERS Engineering change order approvers
    ENG_ENGINEERING_CHANGES Engineering change orders
    ENG_ENG_CHANGES_INTERFACE Mass change orders
    ENG_REVISED_COMPONENTS Implemented and cancelled revised components
    ENG_REVISED_ITEMS Pending and implemented revised items
    ENG_REVISED_ITEMS_INTERFACE Mass change details

    WIP
    WIP_COST_TXN_INTERFACE Requests to process cost transactions
    WIP_DISCRETE_JOBS Discrete jobs
    WIP_ENTITIES Information common to jobs and schedules
    WIP_FLOW_SCHEDULES Work order–less flow schedules
    WIP_LINES Production lines
    WIP_MOVE_TRANSACTIONS Shop floor move transactions
    WIP_MOVE_TXN_INTERFACE Requests to process shop floor move transactions
    WIP_OPERATIONS Operations necessary for jobs and schedules
    WIP_OPERATION_RESOURCES Resources necessary for operations
    WIP_PARAMETERS WIP specific organization level parameters
    WIP_PERIOD_BALANCES Job and schedule charges, by accounting period
    WIP_REPETITIVE_ITEMS Line/assembly associations
    WIP_REPETITIVE_SCHEDULES Repetitive schedules
    WIP_REQUIREMENT_OPERATIONS Components required by jobs and schedules
    WIP_SHOP_FLOOR_STATUSES Statuses assigned to particular jobs and schedules
    WIP_SHOP_FLOOR_STATUS_CODES Statuses that a job or schedule may assume
    WIP_TRANSACTIONS WIP resource transactions
    WIP_TRANSACTION_ACCOUNTS Debits and credits due to resource transactions

    You might also like