My Bills of Material Table Descriptions hand book (I have big hands) part1

Bills of Material - BOM_BILL_OF_MATERIALS	Bills of material
Column Name	Descritpion
ASSEMBLY_ITEM_ID	Inventory item identifier of manufactured assembly
SPECIFIC_ASSEMBLY_COMMENT	Specific bill of material comment
PENDING_FROM_ECN	Change notice that created this bill of material
ORGANIZATION_ID	Organization identifier
ALTERNATE_BOM_DESIGNATOR	Alternate designator code
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ASSEMBLY_TYPE	Assembly type: 1=Manufacturing bill 2=Engineering bill
COMMON_BILL_SEQUENCE_ID	Identifier of common bill
LAST_UPDATED_BY	Standard Who column
BILL_SEQUENCE_ID	Bill of material unique identifier
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
CREATION_DATE	Standard Who column
COMMON_ORGANIZATION_ID	Organization identifier of common bill
NEXT_EXPLODE_DATE	Next date when pre-explosion will be refreshed
PROJECT_ID	Project Identifier for Project Manufacturing
TASK_ID	Task identifier for Project Manufacturing
CREATED_BY	Standard Who column
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from.
LAST_UPDATE_LOGIN	Standard Who column
COMMON_ASSEMBLY_ITEM_ID	Assembly item identifier of common bill

Bills of Material - BOM_INVENTORY_COMPONENTS	Bill of material components
Column Name	Descritpion
OPERATION_SEQ_NUM	Operation sequence number
ATTRIBUTE11	Descriptive flexfield segment
COMPONENT_ITEM_ID	Component item identifier
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE14	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE15	Descriptive flexfield segment
CREATION_DATE	Standard Who column
PLANNING_FACTOR	Factor used to multiply component quantity with to obtain planning quantity
QUANTITY_RELATED	Identifier to indicate if this component has quantity related reference designators
SO_BASIS	Quantity basis used by Oracle Order Management to determine how many units of component to put on an order
OPTIONAL	Flag indicating if component is optional in bill
MUTUALLY_EXCLUSIVE_OPTIONS	Flag indicating if one or more children of component can be picked when taking an order
CREATED_BY	Standard Who column
INCLUDE_IN_COST_ROLLUP	Flag indicating if this component is to be used when rolling up costs
CHECK_ATP	Flag indicating if ATP check is required
SHIPPING_ALLOWED	Flag indicating if component is allowed to ship
REQUIRED_TO_SHIP	Flag indicating if component is required to ship
REQUIRED_FOR_REVENUE	Flag indicating if component is required for revenue
LAST_UPDATE_LOGIN	Standard Who column
INCLUDE_ON_SHIP_DOCS	Flag indicating if component is displayed on shipping documents
INCLUDE_ON_BILL_DOCS	(not currently used)
LOW_QUANTITY	Minimum quantity allowed on an order
HIGH_QUANTITY	Maximum quantity allowed on an order
ACD_TYPE	Add, change, or disable code for component on an engineering change order
OLD_COMPONENT_SEQUENCE_ID	Identifier of original component row an ECO effects
COMPONENT_SEQUENCE_ID	Component unique identifier
BILL_SEQUENCE_ID	Bill of material unique identifier
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
WIP_SUPPLY_TYPE	WIP supply type code
PICK_COMPONENTS	(not currently used)
ITEM_NUM	Item sequence within bill of material structure
SUPPLY_SUBINVENTORY	Supply subinventory
SUPPLY_LOCATOR_ID	Supply locator identifier
OPERATION_LEAD_TIME_PERCENT	Operation offset from first operation in routing (denormalized from corresponding column in BOM_OPERATION_SEQUNCES)
REVISED_ITEM_SEQUENCE_ID	Engineering change order revised item identifier
COST_FACTOR	(not currently used)
COMPONENT_QUANTITY	Quantity of component in bill of material
BOM_ITEM_TYPE	Type of item (denormalized from BOM Item Type in MTL_SYSTEM_ITEMS)
FROM_END_ITEM_UNIT_NUMBER	From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER	To End Item Unit Number
COMPONENT_ITEM_REVISION_ID	Item revision Identifier
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from
ECO_FOR_PRODUCTION	Indicates if this component on an Engineering Change Order is only for WIP jobs
DELETE_GROUP_NAME	Delete group name for the entity type you are deleting
DG_DESCRIPTION	Description of the delete group
ENFORCE_INT_REQUIREMENTS	Enforce Integer Requirements
OPTIONAL_ON_MODEL	Flag indicating if component is optional on model bill (for ATO)
PARENT_BILL_SEQ_ID	Common bill sequence id of the model bill (for ATO)
COMPONENT_YIELD_FACTOR	Factor used to multiply component quantity with to obtain required component quantity
MODEL_COMP_SEQ_ID	Component sequence identifier from model bill (for ATO)
PLAN_LEVEL	Plan level based on model bill (for ATO)
FROM_BILL_REVISION_ID
TO_BILL_REVISION_ID
AUTO_REQUEST_MATERIAL
COMPONENT_REMARKS	Component remarks
EFFECTIVITY_DATE	Effective date
CHANGE_NOTICE	Engineering change order number
IMPLEMENTATION_DATE	Date on which engineering change order was implemented
DISABLE_DATE	Disable date
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment

Bills of Material - BOM_REFERENCE_DESIGNATORS	Component reference designators
Column Name	Descritpion
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REF_DESIGNATOR_COMMENT	Reference designator comment
CHANGE_NOTICE	Engineering change order number
COMPONENT_SEQUENCE_ID	Component unique identifier
ACD_TYPE	Add or delete code from an engineering change order
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from
COMMON_COMPONENT_SEQUENCE_ID	Common Component Sequence Id
COMPONENT_REFERENCE_DESIGNATOR	Component reference designator
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Bills of Material - BOM_SUBSTITUTE_COMPONENTS	Substitute components
Column Name	Descritpion
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SUBSTITUTE_ITEM_QUANTITY	Substitute component quantity
COMPONENT_SEQUENCE_ID	Component unique identifier
ACD_TYPE	Type to indicate add or delete on an engineering change order
CHANGE_NOTICE	Engineering change order number
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
SUBSTITUTE_COMPONENT_ID	Substitute component inventory item
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from
ENFORCE_INT_REQUIREMENTS	Enforce Integer Requirements
LAST_UPDATE_DATE	Standard Who column
COMMON_COMPONENT_SEQUENCE_ID	Common Component Sequence Id
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Bills of Material - BOM_RESOURCES	Resources, overheads, material cost codes, and material overheads
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
BATCH_CAPACITY_UOM	Batch capacity Unit of Measure
BATCH_WINDOW	Batch Window
CREATION_DATE	Standard Who column
BATCH_WINDOW_UOM	Batch Window UOM
COMPETENCE_ID	Competence for people resources
CREATED_BY	Standard Who column
RATING_LEVEL_ID	Rating scale for people resources
QUALIFICATION_TYPE_ID	Qualification for people resources
LAST_UPDATE_LOGIN	Standard Who column
BILLABLE_ITEM_ID	Item ID for the resource that is billable
SUPPLY_SUBINVENTORY	Supply subinventory for a machine type resource
DESCRIPTION	Description
SUPPLY_LOCATOR_ID	Supply locator id for resource type machine
BATCHING_PENALTY	Batching Penalty
RESOURCE_ID	Resource unique identifier
DISABLE_DATE	Disable date
COST_ELEMENT_ID	Cost element identifier
PURCHASE_ITEM_ID	Purchase item identifier
COST_CODE_TYPE	Cost code type
FUNCTIONAL_CURRENCY_FLAG	Unit of measure is functional currency
UNIT_OF_MEASURE	Unit of measure
DEFAULT_ACTIVITY_ID	Default activity identifier
RESOURCE_TYPE	Resource type
AUTOCHARGE_TYPE	Autocharge for shopfloor transaction
STANDARD_RATE_FLAG	Use standard rate for shopfloor transaction
RESOURCE_CODE	Resource code
DEFAULT_BASIS_TYPE	Default basis
ABSORPTION_ACCOUNT	Absorption account
ALLOW_COSTS_FLAG	Allow costs to be defined
RATE_VARIANCE_ACCOUNT	Rate variance account
EXPENDITURE_TYPE	Expenditure type
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
LAST_UPDATE_DATE	Standard Who column
BATCHABLE	Batchable
MAX_BATCH_CAPACITY	Maximum batch capacity
MIN_BATCH_CAPACITY	Minimum batch capacity

Bills of Material - BOM_PARAMETERS	Bills of material parameters
Column Name	Descritpion
ORGANIZATION_ID	Organization identifier
GLOBAL_ATTRIBUTE17	Descriptive flexfield segment
GLOBAL_ATTRIBUTE18	Descriptive flexfield segment
GLOBAL_ATTRIBUTE19	Descriptive flexfield segment
GLOBAL_ATTRIBUTE20	Descriptive flexfield segment
USE_PHANTOM_ROUTINGS	Specifies whether phantom routing should be used.
INHERIT_PHANTOM_OP_SEQ	Specifies whether component of a phantom should inherit operation sequence of the parent
ENABLE_LOWER_LEVEL_SUPPLY	Specifies whether supply should be automatically created for lower level configurations
CREATE_CONFIG_BOM	Allow Config BOM Creation
INCLUDE_MODELS_IN_ROLLUP	Allow Config BOM Creation
MAXIMUM_BOM_LEVEL	Maximum bill of material levels allowed
LAST_UPDATE_DATE	Standard Who column
CONFIG_SEGMENT_NAME	Item segment to use when creating configuration item numbers
BOM_DELETE_STATUS_CODE	Status code to indicate an item is ready for deletion
CONFIG_NUMBER_METHOD_TYPE	The method that is used to create configuration item numbers
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
CREATION_DATE	Standard Who column
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
CREATED_BY	Standard Who column
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
LAST_UPDATE_LOGIN	Standard Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
GLOBAL_ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
GLOBAL_ATTRIBUTE1	Descriptive flexfield segment
GLOBAL_ATTRIBUTE2	Descriptive flexfield segment
GLOBAL_ATTRIBUTE3	Descriptive flexfield segment
GLOBAL_ATTRIBUTE4	Descriptive flexfield segment
GLOBAL_ATTRIBUTE5	Descriptive flexfield segment
GLOBAL_ATTRIBUTE6	Descriptive flexfield segment
GLOBAL_ATTRIBUTE7	Descriptive flexfield segment
GLOBAL_ATTRIBUTE8	Descriptive flexfield segment
GLOBAL_ATTRIBUTE9	Descriptive flexfield segment
GLOBAL_ATTRIBUTE10	Descriptive flexfield segment
GLOBAL_ATTRIBUTE11	Descriptive flexfield segment
GLOBAL_ATTRIBUTE12	Descriptive flexfield segment
GLOBAL_ATTRIBUTE13	Descriptive flexfield segment
GLOBAL_ATTRIBUTE14	Descriptive flexfield segment
GLOBAL_ATTRIBUTE15	Descriptive flexfield segment
GLOBAL_ATTRIBUTE16	Descriptive flexfield segment

Bills of Material - BOM_STANDARD_OPERATIONS	Standard operations
Column Name	Descritpion
STANDARD_OPERATION_ID	Standard operation unique identifier
OPERATION_CODE	Standard operation code
SEQUENCE_NUM	Operation sequence number, showing the sequences of processes and line operations
MINIMUM_TRANSFER_QUANTITY	Minimum operation transfer quantity
ORGANIZATION_ID	Organization identifier
COUNT_POINT_TYPE	Count point
OPERATION_DESCRIPTION	Specific operation description
OPTION_DEPENDENT_FLAG	Indicates whether to use this operation in all configuration routings, even if no components of the configuration are used in this operation
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
DEPARTMENT_ID	Department unique identifier
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
BACKFLUSH_FLAG	Backflush at this operation
WMS_TASK_TYPE	WMS Task Type
OPERATION_YIELD_ENABLED	Indicates whether operation yield is to be considered during costing
YIELD	Operation yield for an operation
SHUTDOWN_TYPE	Shutdown type
ACTUAL_IPK	Actual In-Process Kanbans
CRITICAL_TO_QUALITY	Critical to quality
VALUE_ADDED	Value added
DEFAULT_SUBINVENTORY	Default subinventory
CREATION_DATE	Standard Who column
DEFAULT_LOCATOR_ID	Default locator identifier
INCLUDE_IN_ROLLUP	Include In Rollup
LOWEST_ACCEPTABLE_YIELD	Lowest Yield acceptable at this operation
USE_ORG_SETTINGS	User Organization Settings
QUEUE_MANDATORY_FLAG	Flag to set Queue intra-operation step mandatory
RUN_MANDATORY_FLAG	Flag to set Run intra-operation step mandatory
TO_MOVE_MANDATORY_FLAG	Flag to set Run intra-operation step mandatory
SHOW_NEXT_OP_BY_DEFAULT	Show next operation by default
SHOW_SCRAP_CODE	Show Scrap Code
SHOW_LOT_ATTRIB	Show Lot Attributes
CREATED_BY	Standard Who column
TRACK_MULTIPLE_RES_USAGE_DATES	Track Multiple Resource Usage Dates
CHECK_SKILL	Check Skill
LINE_ID	WIP line identifier
LAST_UPDATE_LOGIN	Standard Who column
OPERATION_TYPE	Operation Type: 1. Standard Operation/Event 2. Process 3. Line Operation

Bills of Material - BOM_OPERATION_SEQUENCES	Routing operations
Column Name	Descritpion
STANDARD_OPERATION_ID	Standard operation unique identifier
ROUTING_SEQUENCE_ID	Routing unique identifier
DEPARTMENT_ID	Department unique identifier
OPERATION_LEAD_TIME_PERCENT	Indicates the amount of overlap its lead time has with the parent's lead time
MINIMUM_TRANSFER_QUANTITY	Minimum operation transfer quantity
COUNT_POINT_TYPE	Count point
OPERATION_DESCRIPTION	Description of operation
EFFECTIVITY_DATE	Date operation is effective
OPERATION_SEQ_NUM	Operation sequence number
DISABLE_DATE	Date operation is no longer effective - effectivity lasts until the end of the disable date
BACKFLUSH_FLAG	Indicates whether operation requires backflushing
OPTION_DEPENDENT_FLAG	Indicates whether to use this operation in all configuration routings, even if no components of the configuration are used in this operation
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
OPERATION_SEQUENCE_ID	Routing operation unique identifier
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
OPERATION_TYPE	Process, Line Operation or Event
REFERENCE_FLAG	If the Standard Operation is referenced or copied then the operation can not be updated.
PROCESS_OP_SEQ_ID	Operation sequence identifier of parent process (applies only to events)
LINE_OP_SEQ_ID	Operation sequence identifier of the parent line operation - only applies to events
YIELD	Process yield at this operation
CUMULATIVE_YIELD	Cumulative process yield from begining of routing to this operation
REVERSE_CUMULATIVE_YIELD	Cumulative process yield from end of routing to comparable operation
LABOR_TIME_CALC	System calculated run time attributable to labor
MACHINE_TIME_CALC	System calculated run time attributable to machines
TOTAL_TIME_CALC	System calculated run time attributable to both labor and machines
LABOR_TIME_USER	User calculated run time attributable to labor
MACHINE_TIME_USER	User calculated run time attributable to machines
TOTAL_TIME_USER	User calculated run time attributable to both labor and machines
NET_PLANNING_PERCENT	Cumulative planning percents derived from the operation network
X_COORDINATE	X coordinate of the operation
Y_COORDINATE	Y coordinate of the operation
CREATION_DATE	Standard Who column
INCLUDE_IN_ROLLUP	Indicates whether operation yield is to be considered in cost rollup
OPERATION_YIELD_ENABLED	Indicates whether operation yield is to be considered during costing.
OLD_OPERATION_SEQUENCE_ID	Old Operation Sequence Id
ACD_TYPE	Acd Type
REVISED_ITEM_SEQUENCE_ID	Revised Item Sequence Id
ORIGINAL_SYSTEM_REFERENCE	Original System Reference
CHANGE_NOTICE	Engineering change notice code (not currently used)
IMPLEMENTATION_DATE	Date on which engineering change will be implemented (no longer used)
ECO_FOR_PRODUCTION	Indicates if this operation on an Engineering Change Order is only for WIP jobs
SHUTDOWN_TYPE	Shutdown type
ACTUAL_IPK	Actual In-Process Kanbans
CRITICAL_TO_QUALITY	Critical to quality
VALUE_ADDED	Value Added
MACHINE_PROCESS_EFFICIENCY	Used by Flow manufacturing for Process Efficiency calculations
CREATED_BY	Standard Who column
LABOR_PROCESS_EFFICIENCY	Used by Flow manufacturing for Process Efficiency calculations
TOTAL_PROCESS_EFFICIENCY	Used by Flow manufacturing for Process Efficiency calculations
LONG_DESCRIPTION	Used by EAM routings
CONFIG_ROUTING_ID	this columns denotes the corresponding model routing that this configuration routing operation is derrived from
MODEL_OP_SEQ_ID	this columns denotes the corresponding model routing operation that this configuration routing operation is derrived from
LOWEST_ACCEPTABLE_YIELD	Lowest Acceptable Yield
USE_ORG_SETTINGS	Use Organization Settings
QUEUE_MANDATORY_FLAG	Flag to set Queue intra-operation step mandatory.
RUN_MANDATORY_FLAG	Run mandatory flag
TO_MOVE_MANDATORY_FLAG	Move mandatory flag
SHOW_NEXT_OP_BY_DEFAULT	Show next operation by default.
SHOW_SCRAP_CODE	Show Scrap Code
SHOW_LOT_ATTRIB	Show lot attributes.
TRACK_MULTIPLE_RES_USAGE_DATES	Track Multiple Resource Usage Dates
CHECK_SKILL	CHECK SKILL
LAST_UPDATE_LOGIN	Standard Who column

Bills of Material - BOM_STD_OP_RESOURCES	Standard operation resources
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RESOURCE_SEQ_NUM	Resource sequence number
USAGE_RATE_OR_AMOUNT	Resource usage rate
USAGE_RATE_OR_AMOUNT_INVERSE	Resource usage rate inverse
BASIS_TYPE	Basis type
AUTOCHARGE_TYPE	Charging for shop floor transactions
STANDARD_RATE_FLAG	Use standard rate for shopfloor transaction
ASSIGNED_UNITS	Resource units assigned
SCHEDULE_FLAG	Schedule this resource
STANDARD_OPERATION_ID	Standard operation unique identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
RESOURCE_ID	Resource unique identifier
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
SUBSTITUTE_GROUP_NUM	Substitue group number
ACTIVITY_ID	Activity identifier

Bills of Material - BOM_OPERATION_RESOURCES	Resources on operations
Column Name	Descritpion
ACTIVITY_ID	Activity identifier
STANDARD_RATE_FLAG	Use standard rate for shopfloor transactions
ASSIGNED_UNITS	Resource units assigned
USAGE_RATE_OR_AMOUNT	Resource usage rate
OPERATION_SEQUENCE_ID	Routing operation unique identifier
USAGE_RATE_OR_AMOUNT_INVERSE	Resource usage rate inverse
BASIS_TYPE	Basis type identifier
SCHEDULE_FLAG	Schedule the resource
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RESOURCE_OFFSET_PERCENT	Resource offset percent from the start of the routing
AUTOCHARGE_TYPE	Autocharge type for shopfloor moves
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
RESOURCE_SEQ_NUM	Resource sequence number
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
SCHEDULE_SEQ_NUM	Scheduling sequence number
SUBSTITUTE_GROUP_NUM	Substitute group number
PRINCIPLE_FLAG	Principle Flag
RESOURCE_ID	Resource unique identifier
SETUP_ID	Setup Type unque identifier
CHANGE_NOTICE	Change Notice
ACD_TYPE	Acd Type
ORIGINAL_SYSTEM_REFERENCE	Original System Reference

Bills of Material - BOM_OPERATIONAL_ROUTINGS	Routings
Column Name	Descritpion
ASSEMBLY_ITEM_ID	Inventory item identifier of manufactured assembly
ROUTING_TYPE	Routing type: 2=Engineering routing 1=Manufacturing routing
COMMON_ASSEMBLY_ITEM_ID	Inventory item identifier of common assembly
COMMON_ROUTING_SEQUENCE_ID	Routing identifier of common routing
ROUTING_COMMENT	Specific comment about routing
COMPLETION_SUBINVENTORY	Destination subinventory for assembly
COMPLETION_LOCATOR_ID	Destination location for assembly
ORGANIZATION_ID	Organization identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ALTERNATE_ROUTING_DESIGNATOR	Alternate designator code
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
LINE_ID	Unique identifier from WIP Lines used in Flow Manufacturing
CFM_ROUTING_FLAG	Continous flow or traditional routing
MIXED_MODEL_MAP_FLAG	Use this routing in Mixed Model Map calculation
PRIORITY	For information only
TOTAL_PRODUCT_CYCLE_TIME	Total time that an assembly takes along the primary path in the operation network, calculated by Flow Manufacturing
CTP_FLAG	Flag indicating capacity must be checked when item is ordered
PROJECT_ID	Project identifier for Project Manufacturing
TASK_ID	Task identifier for Project Manufacturing
PENDING_FROM_ECN	Pending From Ecn
ORIGINAL_SYSTEM_REFERENCE	Original System Reference
SERIALIZATION_START_OP	Serialization Starting Operation Sequence Number for standard routings
ROUTING_SEQUENCE_ID	Routing unique identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Bills of Material - BOM_DEPARTMENT_CLASSES	Department classes
Column Name	Descritpion
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
DEPARTMENT_CLASS_CODE	Department class code
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
ORGANIZATION_ID	Organization identifier
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Bills of Material - BOM_DEPARTMENTS	Departments
Column Name	Descritpion
DEPARTMENT_ID	Department unique identifier
DISABLE_DATE	Disable date
DEPARTMENT_CLASS_CODE	Department class code
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
DEPARTMENT_CODE	Department code
ATTRIBUTE8	Descriptive flexfield segment
ESTIMATED_SCRAP_ABS_ACCOUNT
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
LOCATION_ID	Location identifier
PA_EXPENDITURE_ORG_ID	Organization identifier for the expenditure organization
SCRAP_ACCOUNT	Scrap account of department
ORGANIZATION_ID	Organization identifier
EST_ABSORPTION_ACCOUNT	Estimated scrap absorption account
MAINT_COST_CATEGORY	Maintenance Cost category
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description

Bills of Material - BOM_DEPARTMENT_RESOURCES	Resources associated with departments
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
CREATION_DATE	Standard Who column
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
CREATED_BY	Standard Who column
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
LAST_UPDATE_LOGIN	Standard Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
CTP_FLAG	Flag indicating capacity must be checked when resource is ordered
EXCEPTION_SET_NAME	Name of the exception set
ATP_RULE_ID	Identifier of the available to promise rule used
UTILIZATION	Resource Utilization
EFFICIENCY	Resource Efficiency
SCHEDULE_TO_INSTANCE	Schedule To Instance
SEQUENCING_WINDOW	Sequencing Window
SHARE_CAPACITY_FLAG	Allow sharing of capacity
IDLE_TIME_TOLERANCE	Idle Time Tolerance
SHARE_FROM_DEPT_ID	Share capacity from department identifier
CAPACITY_UNITS	Resource capacity
RESOURCE_GROUP_NAME	Resource use category
AVAILABLE_24_HOURS_FLAG	Resource is available 24 hours or by shifts
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
DEPARTMENT_ID	Department unique identifier
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
RESOURCE_ID	Resource unique identifier
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment

Bills of Material - BOM_RESOURCE_SHIFTS	Resource shift information
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
DEPARTMENT_ID	Department unique identifier
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
CAPACITY_UNITS	Resource Capacity
RESOURCE_ID	Resource unique identifier
SHIFT_NUM	Shift number

Bills of Material - BOM_RESOURCE_CHANGES	Resource capacity modifications
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FROM_DATE	Capacity exception from date
TO_DATE	Capacity exception to date
FROM_TIME	Capacity exception from time
TO_TIME	Capacity exception to time
CAPACITY_CHANGE	Capacity change
SIMULATION_SET	Simulation set identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
DEPARTMENT_ID	Department unique identifier
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ACTION_TYPE	Type of capacity modification
RESOURCE_ID	Resource unique identifier
REASON_CODE	Reason code for the reason in the common lookups table which has the reason
DOWNTIME_GROUP_ID	Unique batch identifier of the Load Production Equipment Downtime Process
SHIFT_NUM	Shift number

Bills of Material - BOM_ALTERNATE_DESIGNATORS	Alternate designators
Column Name	Descritpion
ALTERNATE_DESIGNATOR_CODE	Alternate designator code
ORGANIZATION_ID	Organization identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
STRUCTURE_TYPE_ID	Structure Type Identifier
CREATED_BY	Standard Who column
IS_PREFERRED	Preferred Structure Name
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description
DISABLE_DATE	Disable date

Bills of Material - BOM_CALENDARS	Workday calendars
Column Name	Descritpion
CALENDAR_CODE	Workday calendar identifier
CALENDAR_START_DATE	Beginning date for the calendar
CALENDAR_END_DATE	Ending date for the calendar
DESCRIPTION	Description
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who Column
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who Column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
DATABASE_IN_SYNC	Compiled calendar is up to date with the database (yes/no)
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
QUARTERLY_CALENDAR_TYPE	Quarterly Calendar Type Code
DAYS_ON	Number of consecutive working days
DAYS_OFF	Number of consecutive non-working days

Bills of Material - BOM_CALENDAR_SHIFTS	Workday calendar shifts
Column Name	Descritpion
CALENDAR_CODE	Workday calendar identifier
DESCRIPTION	Description
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
SHIFT_NUM	Shift number
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
LAST_UPDATE_DATE	Standard Who Column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
DAYS_ON	Number of consecutive working days
DAYS_OFF	Number of consecutive non-working days

Bills of Material - BOM_SHIFT_EXCEPTIONS	Workday calendar shift exceptions
Column Name	Descritpion
CALENDAR_CODE	Workday calendar identifier
EXCEPTION_TYPE	Exception type (On and Off)
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
SHIFT_NUM	Shift number
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
EXCEPTION_SET_ID	Exception set unique identifier
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
EXCEPTION_DATE	Exception Date
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Bills of Material - BOM_CALENDAR_EXCEPTIONS	Workday calendar exceptions
Column Name	Descritpion
CALENDAR_CODE	Workday calendar identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
EXCEPTION_SET_ID	Exception set unique identifier
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
EXCEPTION_DATE	Exception date
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
EXCEPTION_TYPE	Exception type (1 for On and 2 for Off)

Bills of Material - BOM_SHIFT_TIMES	Workday calendar shift times
Column Name	Descritpion
CALENDAR_CODE	Workday calendar identifier
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
SHIFT_NUM	Shift number
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
FROM_TIME	Shift start time
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
TO_TIME	Shift end time
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LAST_UPDATE_DATE	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Bills of Material - BOM_EXPLOSION_TEMP	Temporary data for indented bills of material (batch processes)
Column Name	Descritpion
PROGRAM_APPLICATION_ID	Concurrent Who column
PLANNING_FACTOR	Factor used to multiply component quantity with to obtain planning quantity
OPERATION_SEQ_NUM	Operation sequence number
PARENT_BOM_ITEM_TYPE	Parent item's bom item type
WIP_SUPPLY_TYPE	Supply type
ITEM_NUM	Item sequence within bill of material structure
EFFECTIVITY_DATE	Effective date
DISABLE_DATE	Disable date
IMPLEMENTATION_DATE	Date on which engineering change order was implemented
SUPPLY_SUBINVENTORY	Supply subinventory
SUPPLY_LOCATOR_ID	Supply locator identifier
PROGRAM_ID	Concurrent Who column
COMPONENT_REMARKS	Component remarks
CHANGE_NOTICE	Engineering change order number
OPERATION_LEAD_TIME_PERCENT	Operation offset from first operation in routing
REXPLODE_FLAG	Flag indicating whether to re-explode
COMMON_BILL_SEQUENCE_ID	Common bill of material unique identifier
COMMON_ORGANIZATION_ID
PRIMARY_PATH_FLAG	Primary path flag
AUTO_REQUEST_MATERIAL	Auomatically create move order for the material at work order release
EXPLOSION_TYPE
CREATION_DATE
PROGRAM_UPDATE_DATE	Concurrent Who column
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
COMP_BILL_SEQ_ID
COMP_COMMON_BILL_SEQ_ID
NUM_COL1
NUM_COL2
NUM_COL3
DATE_COL1
DATE_COL2
DATE_COL3
CHAR_COL1
CHAR_COL2
CHAR_COL3
INCLUDE_IN_COST_ROLLUP
PARENT_SORT_ORDER
STRUCTURE_TYPE_ID
OBJ_NAME
PK1_VALUE
PK2_VALUE
PK3_VALUE
PK4_VALUE
PK5_VALUE
HGRID_FLAG
OPERATION_OFFSET
CURRENT_REVISION
LOCATOR
SUGGESTED_VENDOR_NAME	Used by direct items in EAM BOMs
UNIT_PRICE	Unit Price for direct items used by EAM BOMs
VENDOR_ID	Used by direct items in EAM BOMs
SELECT_FLAG	Whether this component has been ordered
FROM_END_ITEM_UNIT_NUMBER
TO_END_ITEM_UNIT_NUMBER
FROM_END_ITEM_REV_ID
FROM_END_ITEM_MINOR_REV_ID
TO_END_ITEM_REV_ID
TO_END_ITEM_MINOR_REV_ID
NEW_COMPONENT_CODE
FROM_BILL_REVISION_ID
TO_BILL_REVISION_ID
REVISION_ID
SELECT_QUANTITY	Order quantity
REVISION_LABEL
EFFECTIVITY_CONTROL
ACCESS_FLAG
ENG_ITEM_FLAG
ASSEMBLY_TYPE
FROM_OBJECT_REVISION_ID
FROM_MINOR_REVISION_ID
TO_OBJECT_REVISION_ID
TO_MINOR_REVISION_ID
OBJECT_REVISION_ID
EXTEND_COST_FLAG	Whether to extend cost for this item
MINOR_REVISION_ID
MINOR_REVISION_CODE
COMPONENT_ITEM_REVISION_ID
COMPONENT_MINOR_REVISION_ID
BOM_IMPLEMENTATION_DATE
GTIN_NUMBER
GTIN_DESCRIPTION
TRADE_ITEM_DESCRIPTOR
TRADE_ITEM_DESCRIPTOR_DESC
GTIN_PUBLICATION_STATUS
TOP_GTIN_NUMBER
TOP_GTIN_DESCRIPTION
TOP_TRADE_ITEM_DESCRIPTOR
PARENT_GTIN_NUMBER
PARENT_GTIN_DESCRIPTION
PARENT_TRADE_ITEM_DESCRIPTOR
QUANTITY_OF_CHILDREN
TOTAL_QTY_AT_NEXT_LEVEL
CHANGE_ID
ACD_TYPE
TOP_ITEM_ID	Item identifier of level 0 item
QUANTITY_RELATED
CHANGE_POLICY_VALUE
EXPLODED_DATE
EXPLODED_UNIT_NUMBER
EXPLODED_END_ITEM_REV
EXPLODED_OPTION
BASIS_TYPE
BILL_SEQUENCE_ID	Bill of material unique identifier
CONTEXT	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
PRICING_CONTEXT	Descriptive flexfield structure defining column
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
GROUP_ID	Explosion identifier
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
HEADER_ID	System-generated identifier of order header
LINE_ID	System-generated identifier of order, configuration or shipment schedule line
LIST_PRICE	The price of the item on the price list
SELLING_PRICE	Actual price charged to customer
COMPONENT_SEQUENCE_ID	Component unique identifier
COMPONENT_YIELD_FACTOR	Component yield
ITEM_COST	Item unit cost
INCLUDE_IN_ROLLUP_FLAG	Flag indicating if component is to be used when rolling up costs
BASED_ON_ROLLUP_FLAG	Flag indicating whether cost will be rolled up
ACTUAL_COST_TYPE_ID	Actual cost type identifier
COMPONENT_QUANTITY	Quantity of component in bill of material
SHRINKAGE_RATE	Planned shrinkage rate
SO_BASIS	Quantity basis used by Oracle Order Management to determine how many units of component to put on an order
OPTIONAL	Flag indicating if component is optional in bill of material
MUTUALLY_EXCLUSIVE_OPTIONS	Flag indicating if one or more children of component can be picked when taking an order
COMPONENT_ITEM_ID	Component item identifier
CHECK_ATP	Flag indicating if ATP check is required
SHIPPING_ALLOWED	Flag indicating if component is allowed to ship
REQUIRED_TO_SHIP	Flag indicating if component is required to ship
TOP_ALTERNATE_DESIGNATOR	Alternate designator for level 0
REQUIRED_FOR_REVENUE	Flag indicating if component is required for revenue
INCLUDE_ON_SHIP_DOCS	Flag indicating if component is included on shipping documents
INCLUDE_ON_BILL_DOCS	Flag indicating if component is included on billing documents
LOW_QUANTITY	Minimum quantity allowed on an order
ORGANIZATION_ID	Organization identifier
HIGH_QUANTITY	Maximum quantity allowed on an order
PICK_COMPONENTS	(not currently used)
TOP_BILL_SEQUENCE_ID	Bill identifier of level 0 items
PLAN_LEVEL	Level in bill
BASE_ITEM_ID	Base item identifier
ATP_COMPONENTS_FLAG	Flag indicating whether item may have components requiring ATP check
ATP_FLAG	Flag indicating ATP must be checked when item is ordered
BOM_ITEM_TYPE	Type of item
PRIMARY_UNIT_OF_MEASURE	Unit of measure of component
PICK_COMPONENTS_FLAG	Flag indicating all shippable components should be picked
REPLENISH_TO_ORDER_FLAG	Assemble to order flag
SHIPPABLE_ITEM_FLAG	Flag indicating shippable item
CUSTOMER_ORDER_FLAG	Flag indicating customer orderable item
INTERNAL_ORDER_FLAG	Flag indicating item has been internally ordered
EXTENDED_QUANTITY	Extended quantity including quantity per, yield, and shrinkage
CUSTOMER_ORDER_ENABLED_FLAG	Flag indicating item is customer orderable
SORT_ORDER	Sorting sequence for the explosion
INTERNAL_ORDER_ENABLED_FLAG	Flag indicating item can be internally ordered
SO_TRANSACTIONS_FLAG	Sales order transactions flag
MTL_TRANSACTIONS_ENABLED_FLAG	Flag indicating item is transactable
STOCK_ENABLED_FLAG	Flag indicating item is stockable
DESCRIPTION	Description
ASSEMBLY_ITEM_ID	Assembly item identifier
SESSION_ID	Session identifier
ALTERNATE_BOM_DESIGNATOR
CONFIGURATOR_FLAG	Flag indicating if component is used by the configurator form
PRICE_LIST_ID	System-generated identifier of price list
ROUNDING_FACTOR	Rounding factor used to determine order quantity
PRIMARY_UOM_CODE	Unit of measure code of component
PRICING_ATTRIBUTE1	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE2	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE3	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE4	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE5	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE6	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE7	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE8	User defined attribute that adjusts the list price of an item
REQUEST_ID	Concurrent Who column
PRICING_ATTRIBUTE9	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE10	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE11	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE12	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE13	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE14	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE15	User defined attribute that adjusts the list price of an item
COMPONENT_CODE	Concatenation of component item identifiers
LOOP_FLAG	Indicates whether a loop is detected
INVENTORY_ASSET_FLAG	Flag indicating item is an inventory asset

Bills of Material - BOM_EXCEPTION_SETS	Exception sets
Column Name	Descritpion
EXCEPTION_SET_ID	Exception set unique identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
EXCEPTION_SET_NAME	Exception set name
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
LAST_UPDATE_DATE	Standard Who Column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
DESCRIPTION	Description
DISABLE_DATE	Disable date

Bills of Material - BOM_INVENTORY_COMPS_INTERFACE	Bill of material components interface data
Column Name	Descritpion
COMPONENT_ITEM_ID	Component item identifier
INCLUDE_IN_COST_ROLLUP	Flag indicating if this component is to be used when rolling up costs
CHECK_ATP	Flag indicating if ATP check is required
SHIPPING_ALLOWED	Flag indicating if component is allowed to ship
REQUIRED_TO_SHIP	Flag indicating if component is required to ship
REQUIRED_FOR_REVENUE	Flag indicating if component is required for revenue
INCLUDE_ON_SHIP_DOCS	Flag indicating if component is displayed on shipping documents
LOW_QUANTITY	Minimum quantity allowed on an order
HIGH_QUANTITY	Maximum quantity allowed on an order
LAST_UPDATE_DATE	Standard Who column
ACD_TYPE	Add, change, or disable code for component on an engineering change order
OLD_COMPONENT_SEQUENCE_ID	Identifier of original component row that an ECO affects
COMPONENT_SEQUENCE_ID	Component unique identifier
BILL_SEQUENCE_ID	Bill of material unique identifier
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
WIP_SUPPLY_TYPE	WIP supply type code
LAST_UPDATED_BY	Standard Who column
SUPPLY_SUBINVENTORY	Supply subinventory
SUPPLY_LOCATOR_ID	Supply locator identifier
REVISED_ITEM_SEQUENCE_ID	Engineering change order revised item identifier
MODEL_COMP_SEQ_ID	Component sequence identifier from model bill (for ATO)
ASSEMBLY_ITEM_ID	Inventory item identifier of manufactured assembly
CREATION_DATE	Standard Who column
ALTERNATE_BOM_DESIGNATOR	Alternate designator code
ORGANIZATION_ID	Organization identifier
ORGANIZATION_CODE	Abbreviation for organization name
COMPONENT_ITEM_NUMBER	Concatenated component item segments
ASSEMBLY_ITEM_NUMBER	Concatenated bill item segments
REVISED_ITEM_NUMBER	Concatenated revised item segments
LOCATION_NAME	Supply location name
CREATED_BY	Standard Who column
REFERENCE_DESIGNATOR	Component reference designator
SUBSTITUTE_COMP_ID	Inventory item identifier of the substitute component
SUBSTITUTE_COMP_NUMBER	Concatenated item segments of the substitute component
TRANSACTION_ID	Row identifier
PROCESS_FLAG	Row status
BOM_ITEM_TYPE	Type of item (denormalized from BOM Item Type in MTL_SYSTEM_ITEMS)
OPERATION_LEAD_TIME_PERCENT	Operation offset from first operation in routing (Denormalized from corresponding column in BOM_OPERATION_SEQUNCES)
COST_FACTOR	(not currently used)
INCLUDE_ON_BILL_DOCS	(not currently used)
PICK_COMPONENTS	(not currently used)
LAST_UPDATE_LOGIN	Standard Who column
DDF_CONTEXT1	Used by Mass Change
DDF_CONTEXT2	Used by Mass Change
NEW_OPERATION_SEQ_NUM	Updated value for the operation_seq_num
OLD_OPERATION_SEQ_NUM	Operation sequence number in the original component record that an ECO affects
NEW_EFFECTIVITY_DATE	Updated value for the effectivity_date
OLD_EFFECTIVITY_DATE	Value of effective date in the original component record that an ECO affects
ASSEMBLY_TYPE	Assembly type of the parent bill
INTERFACE_ENTITY_TYPE	Record used for Bill or ECO Open Interface: BILL, ECO
ITEM_NUM	Item sequence within bill of material structure
TRANSACTION_TYPE	Type of action: CREATE, UPDATE or DELETE
FROM_END_ITEM_UNIT_NUMBER	From End Item Unit Number
NEW_FROM_END_ITEM_UNIT_NUMBER	From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER	To End Item Unit Number
ENG_REVISED_ITEMS_IFCE_KEY	User defined identifier for linking rows pertaining to the same business object
BOM_INVENTORY_COMPS_IFCE_KEY	User defined identifier that links rows pertaining to the same business object
ENG_CHANGES_IFCE_KEY	User defined identifier to link rows corresponding to the same business object
DELETE_GROUP_NAME	Delete group name for the entity type you are deleting
DG_DESCRIPTION	Description of the delete group
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from
ENFORCE_INT_REQUIREMENTS	Enforce Integer Requirements
OPTIONAL_ON_MODEL	Flag indicating if component is optional on model bill (for ATO)
PARENT_BILL_SEQ_ID	Common bill sequence id of the model bill (for ATO)
PLAN_LEVEL	Plan level based on model bill (for ATO)
AUTO_REQUEST_MATERIAL	Auomatically create move order for the material at work order release
BASIS_TYPE	Basis type identifier
SUGGESTED_VENDOR_NAME	Suggested vendor name will be used for direct items for EAM BOMs
UNIT_PRICE	Unit Price for direct items used by EAM BOMs
NEW_REVISED_ITEM_REVISION	New Revised Item Revision is one of the unique keys to identify a revised item of a change
COMPONENT_QUANTITY	Quantity of component in bill of material
OBJ_NAME
PK1_VALUE
PK2_VALUE
PK3_VALUE
PK4_VALUE
PK5_VALUE
FROM_OBJECT_REVISION_CODE
FROM_OBJECT_REVISION_ID
TO_OBJECT_REVISION_CODE
TO_OBJECT_REVISION_ID
INVERSE_QUANTITY	Inverse Quantity of component in bill of material
FROM_MINOR_REVISION_CODE
FROM_MINOR_REVISION_ID
COMPONENT_YIELD_FACTOR	Factor used to multiply component quantity to obtain required component quantity
TO_MINOR_REVISION_CODE
TO_MINOR_REVISION_ID
FROM_END_ITEM_MINOR_REV_CODE
FROM_END_ITEM_MINOR_REV_ID
TO_END_ITEM_MINOR_REV_CODE
TO_END_ITEM_MINOR_REV_ID
RETURN_STATUS
FROM_END_ITEM	End Item Name
FROM_END_ITEM_ID	End Item ID
FROM_END_ITEM_REV_CODE	From end item revision code
FROM_END_ITEM_REV_ID	From end item revision id
TO_END_ITEM_REV_CODE	To end item revision code
TO_END_ITEM_REV_ID	To end item revision id
COMPONENT_REVISION_CODE	Holds the value of componnet revision code. This value will be used for adding fixed revision components.
COMPONENT_REVISION_ID	Holds the value of componnet revision id. This value will be used for adding fixed revision components.
COMPONENT_REMARKS	Component remarks
BATCH_ID	Batch Identifier for Data Load
COMP_SOURCE_SYSTEM_REFERENCE	Component Source System Item Name
COMP_SOURCE_SYSTEM_REFER_DESC
PARENT_SOURCE_SYSTEM_REFERENCE	Parent Source System Item Name
CATALOG_CATEGORY_NAME	Item Catalog Category Name
ITEM_CATALOG_GROUP_ID	Item Catalog Category Identifier
CHANGE_ID	Change Identifier
TEMPLATE_NAME	Item Template Name
EFFECTIVITY_DATE	Effective date
PRIMARY_UNIT_OF_MEASURE
ITEM_DESCRIPTION
COMMON_COMPONENT_SEQUENCE_ID
CHANGE_TRANSACTION_TYPE	Change Management Transaction Type for Change Orders
CHANGE_NOTICE	Engineering change order number
INTERFACE_TABLE_UNIQUE_ID	Interface Table Unique Id for Merge
PARENT_REVISION_CODE
PARENT_REVISION_ID
BUNDLE_ID
IMPLEMENTATION_DATE	Date on which engineering change order was implemented
DISABLE_DATE	Disable date
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
OPERATION_SEQ_NUM	Operation sequence number
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
PLANNING_FACTOR	Factor used to multiply component quantity with to obtain planning quantity
QUANTITY_RELATED	Identifier to indicate if this component has quantity related reference designators
SO_BASIS	Quantity basis used by Oracle Order Management to determine how many units of component to put on an order
OPTIONAL	Flag indicating if component is optional in bill
MUTUALLY_EXCLUSIVE_OPTIONS	Flag indicating if one or more children of component can be picked when taking an order

Bills of Material - BOM_BILL_OF_MTLS_INTERFACE	Bills of material interface table
Column Name	Descritpion
BUNDLE_ID
LAST_UPDATED_BY	Standard Who column
TRANSACTION_TYPE	Type of action: CREATE, UPDATE, or DELETE
DELETE_GROUP_NAME	Delete group name for the entity type you are deleting
DG_DESCRIPTION	Description of the delete group
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from.
IMPLEMENTATION_DATE	Implementation Date
OBJ_NAME	Object name
CREATION_DATE	Standard Who column
PK1_VALUE	Primary key of the object
PK2_VALUE	Primary key of the object
PK3_VALUE	Primary key of the object
PK4_VALUE	Primary key of the object
CREATED_BY	Standard Who column
PK5_VALUE	Primary key of the object
STRUCTURE_TYPE_NAME	Structure type name
STRUCTURE_TYPE_ID	Structure type identifier
EFFECTIVITY_CONTROL	Effectivity control
LAST_UPDATE_LOGIN	Standard Who column
RETURN_STATUS	Return status
IS_PREFERRED	Determines whether this structure is preferred or not.
SOURCE_SYSTEM_REFERENCE	Source system item name for import
COMMON_ASSEMBLY_ITEM_ID	Inventory item identifier of common assembly
SOURCE_SYSTEM_REFERENCE_DESC	Source system reference description
BATCH_ID	Batch Identifier for Data Load
CHANGE_ID	Change Identifier
CATALOG_CATEGORY_NAME	Item Catalog Category Name
SPECIFIC_ASSEMBLY_COMMENT	Specific bill of material comment
ITEM_CATALOG_GROUP_ID	Item Catalog Category Identifier
PRIMARY_UNIT_OF_MEASURE	Primary unit of measure
ITEM_DESCRIPTION	Item description
TEMPLATE_NAME	Item Template Name
PENDING_FROM_ECN	Change notice that created this bill
SOURCE_BILL_SEQUENCE_ID	Source bill sequence id
ENABLE_ATTRS_UPDATE	Indicates whether attributes of a Common BOM need to be updated. Possible values are 'Y'/'N'.
INTERFACE_TABLE_UNIQUE_ID	Interface Table Unique Id for Merge
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ASSEMBLY_ITEM_ID	Inventory item identifier of manufactured assembly
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ASSEMBLY_TYPE	Assembly Type: 1=Manufacturing bill 2=Engineering bill
COMMON_BILL_SEQUENCE_ID	Unique bill identifier for common bill
BILL_SEQUENCE_ID	Bill of material unique identifier
REQUEST_ID	Concurrent Who column
ALTERNATE_BOM_DESIGNATOR	Alternate designator code
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
DEMAND_SOURCE_LINE	Demand source line - used for ATO
SET_ID	Set identifier - used for ATO
COMMON_ORGANIZATION_ID	Organization identifier of common organization
LAST_UPDATE_DATE	Standard Who column
DEMAND_SOURCE_TYPE	Demand source type - used for ATO
DEMAND_SOURCE_HEADER_ID	Demand source header identifier - used for ATO
TRANSACTION_ID	Row identifier
PROCESS_FLAG	Row status
ORGANIZATION_CODE	Abbreviation of organization name
COMMON_ORG_CODE	Abbreviation of common organization name
ITEM_NUMBER	Concatenated bill item segments
COMMON_ITEM_NUMBER	Concatenated common bill item segments
NEXT_EXPLODE_DATE	Next date when pre-explosion will be refreshed
REVISION	Bill revision

Bills of Material - BOM_CALENDAR_DATES	Workday calendar dates
Column Name	Descritpion
CALENDAR_CODE	Workday calendar identifier
NEXT_SEQ_NUM	Next sequence number
PRIOR_SEQ_NUM	Prior sequence number
NEXT_DATE	Date corresponding to next sequence number
PRIOR_DATE	Date corresponding to prior sequence number
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
EXCEPTION_SET_ID	Exception set unique identifier
PROGRAM_UPDATE_DATE	Concurrent Who column
CALENDAR_DATE	Calendar date
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
SEQ_NUM	Sequence number (for working days only)

Bills of Material - BOM_CAL_WEEK_START_DATES	Workday calendar weekly start dates
Column Name	Descritpion
CALENDAR_CODE	Workday calendar identifier
PRIOR_DATE	Date corresponding to the prior working date
SEQ_NUM	Sequence number (for working days)
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
EXCEPTION_SET_ID	Exception set unique identifier
WEEK_START_DATE	Week start date
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
NEXT_DATE	Date corresponding to the next working date

Bills of Material - BOM_CAL_YEAR_START_DATES	Workday calendar yearly start dates
Column Name	Descritpion
CALENDAR_CODE	Workday calendar identifier
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
EXCEPTION_SET_ID	Exception set unique identifier
YEAR_START_DATE	Calendar year start date
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column

Bills of Material - BOM_COMPARISON_TEMP	Temporary data for bill of material comparisons
Column Name	Descritpion
ASSEMBLY_ID1	First assembly identifier
DISABLE_DATE	Disable date
IMPLEMENTATION_DATE	Date on which engineering change will be implemented
PLANNING_FACTOR	Planning factor
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
OPTIONAL	Optional (yes or no)
COMPONENT_SEQUENCE_ID1	Component sequence ID in first bill of material
COMPONENT_SEQUENCE_ID2	Component sequence ID in second bill of material
FROM_END_ITEM_UNIT_NUMBER	Current end item unit number
TO_END_ITEM_UNIT_NUMBER	New end item unit number
COMPONENT_NAME	Component name
ASSEMBLY_ID2	Second assembly identifier
SEQUENCE_ID	Unique ID used to identify the results of a comparison of two bills of material
ITEM_NUM	Item sequence within bill of material structure, which overrides operation sequence number as basis for BOM sorts
COMPONENT_QUANTITY	Quantity of component in parent assembly
OPERATION_SEQ_NUM	Operation sequence number
COMPONENT_YIELD_FACTOR	Factor by which a quantity is multiplied to obtain component yield
EFFECTIVITY_DATE	Effective date

Bills of Material - BOM_DELETE_ENTITIES	Deleted entities in BOM and INV
Column Name	Descritpion
ROUTING_SEQUENCE_ID	Routing unique identifier
INVENTORY_ITEM_ID	Item unique identifier
ORGANIZATION_ID	Organization identifier
ALTERNATE_DESIGNATOR	Alternate designator of bom or routing being deleted
ITEM_DESCRIPTION	Item description
DELETE_ENTITY_SEQUENCE_ID	Delete entity unique identifier
ITEM_CONCAT_SEGMENTS	Item concatenated key flexfield segments
DELETE_STATUS_TYPE	Delete entity status
DELETE_DATE	Date entity was deleted
PRIOR_PROCESS_FLAG	Indicates whether this row has been exploded into its bill or routings for child organizations
PRIOR_COMMIT_FLAG	Indicates if the row is user entered or loaded automatically
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DELETE_GROUP_SEQUENCE_ID	Delete group unique identifier
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
COL_27030828	Standard Who column
DELETE_ENTITY_TYPE	Type of delete entity
BILL_SEQUENCE_ID	Bill of material unique identifier

Bills of Material - BOM_DELETE_ERRORS	Errors occurring when deleting entities
Column Name	Descritpion
ERROR_SEQUENCE_NUMBER	Error sequence number
SQL_STATEMENT_NAME	Name of failed sql statement
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
DELETE_ENTITY_SEQUENCE_ID	Delete entity unique identifier
COMPONENT_SEQUENCE_ID	Component unique identifier
OPERATION_SEQUENCE_ID	Routing operation unique identifier

Bills of Material - BOM_DELETE_GROUPS	Delete groups of BOM and INV entities
Column Name	Descritpion
ACTION_TYPE	Type of action
DATE_LAST_SUBMITTED	Date the concurrent program was last submitted
DESCRIPTION	Description
ENGINEERING_FLAG	Whether the delete group is for engineering or manufacturing entities
DELETE_GROUP_SEQUENCE_ID	Group unique identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
DELETE_COMMON_BILL_FLAG	Common Bill Flag
DELETE_GROUP_NAME	Name of the delete group
DELETE_ORG_TYPE	Organization Type
ORGANIZATION_HIERARCHY	Organization Hierarchy Name
ORGANIZATION_ID	Organization identifier
DELETE_TYPE	Type of delete

Bills of Material - BOM_DELETE_SQL_STATEMENTS	SQL statements used to check and delete entities
Column Name	Descritpion
DELETE_ENTITY_TYPE	Type of delete entity
MESSAGE_NAME	Name of the message to be produced when the sql statement fails
DESCRIPTION	Description
SQL_STATEMENT	Sql statement
SEQUENCE_NUMBER	Number that identifies the sequence in which the constraints or deletes for this delete entity type will execute
SQL_STATEMENT_NAME	Name that uniquely identifies a sql statement
ARCHIVE_TABLE_NAME	For delete statements, name of table to archive deleted rows
PREDEFINED_FLAG	Indicates if constraint is seeded or user defined
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
SQL_STATEMENT_TYPE	Type of sql statement
PRODUCT_NAME	Name of the product, in which this delere statement record will be used. Ex: "MFG" or "PLM"
ACTIVE_FLAG	Indicates whether this sql statement is active
DELETE_ON_SUCCESS_FLAG	For a constraint, indicate whether delete should occur when sql statement succeeds (returns rows) or whether delete should occur when sql statement fails (returns no rows)

Bills of Material - BOM_DELETE_SUB_ENTITIES	Component and operations to be deleted
Column Name	Descritpion
EFFECTIVITY_DATE	Effective date
FROM_END_ITEM_UNIT_NUMBER	From End Item Unit Number
COMPONENT_ITEM_ID	Component item identifier
COMPONENT_CONCAT_SEGMENTS	Component item concatenated key flexfield segments
ITEM_NUM	Sequence number of the component within the bill
DISABLE_DATE	Disable date
TO_END_ITEM_UNIT_NUMBER	To End Item Unit Number
DELETE_ENTITY_SEQUENCE_ID	Delete entity unique identifier
DESCRIPTION	Description
OPERATION_DEPARTMENT_CODE	Department in which the operation takes place
DELETE_STATUS_TYPE	Delete status
DELETE_DATE	Date the sub-entity was deleted
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
COMPONENT_SEQUENCE_ID	Component unique identifier
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
OPERATION_SEQUENCE_ID	Routing operation unique identifier
OPERATION_SEQ_NUM	Operation sequence number

Bills of Material - BOM_DEPENDENT_DESC_ELEMENTS	Descriptive elements assigned to model/option bills
Column Name	Descritpion
CREATION_DATE	Creation date
CREATED_BY	Created by
LAST_UPDATE_LOGIN	Last update login
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
BILL_SEQUENCE_ID	Bill of material unique identifier
PROGRAM_UPDATE_DATE	Concurrent Who column
REQUEST_ID	Concurrent Who column
ELEMENT_NAME	Descriptive element name
LAST_UPDATE_DATE	Last update date
LAST_UPDATED_BY	Last updated by

Bills of Material - BOM_IMPLOSION_TEMP	Temporary data for item usage (Item Where Used Report)
Column Name	Descritpion
ALTERNATE_DESIGNATOR	Alternate bom designator
CURRENT_LEVEL	Implosion level
SORT_CODE	Sort sequence
LOWEST_ALTERNATE_DESIGNATOR	Alternate bom designator of level 1 items
CURRENT_ASSEMBLY_TYPE	Assembly type
SEQUENCE_ID	Implosion identifier
COMPONENT_SEQUENCE_ID	Component unique identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
LOWEST_ITEM_ID	Identifier of item to implode
ORGANIZATION_ID	Organization identifier
OPERATION_SEQ_NUM	Operation sequence number
EFFECTIVITY_DATE	Effective date
DISABLE_DATE	Disable date
BASIS_TYPE	Basis type identifier
COMPONENT_QUANTITY	Component quantity
REVISED_ITEM_SEQUENCE_ID	Revised item unique identifier
CHANGE_NOTICE	Engineering change order number
IMPLEMENTED_FLAG	Indicator if component row is implemented or pending
SUGGESTED_VENDOR_NAME	Used by direct items in EAM BOMs
VENDOR_ID	Used by direct items in EAM BOMs
CURRENT_ITEM_ID	Item identifier of current component
UNIT_PRICE	Unit Price for direct items used by EAM BOMs
PARENT_ITEM_ID	Assembly item identifier

Bills of Material - BOM_LISTS	Temporary list of data about reporting entities
Column Name	Descritpion
CONC_FLEX_STRING	Concatenated item flex segments
ORGANIZATION_ID	Organization identifier
SEQUENCE_ID	List identifier
ASSEMBLY_ITEM_ID	Assembly item identifier
ALTERNATE_DESIGNATOR	Alternate bill/routing designator
ASSEMBLY_TYPE	Indicates whether manufacturing or engineering assembly

Bills of Material - BOM_LOW_LEVEL_CODES	Temporary data for low level item codes
Column Name	Descritpion
CUM_MANUFACTURING_LEAD_TIME	Cumulative manufacturing lead time
PLANNING_MAKE_BUY_CODE	Planning Make buy code
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
ROLLUP_ID	Rollup identifier
PROGRAM_UPDATE_DATE	Concurrent Who column
INVENTORY_ITEM_ID	Item identifier
LOW_LEVEL_CODE	Low Level Code
CUMULATIVE_TOTAL_LEAD_TIME	Cumulative total lead time

Bills of Material - BOM_OP_RESOURCES_INTERFACE	Operation resources interface data
Column Name	Descritpion
OPERATION_SEQUENCE_ID	Routing operation unique identifier
RESOURCE_SEQ_NUM	Resource sequence number
RESOURCE_ID	Resource unique identifier
BATCH_ID	BATCH_ID
ACTIVITY_ID	Activity identifier
OPERATION_TYPE
STANDARD_RATE_FLAG	Use standard rate for shop floor transactions
ASSIGNED_UNITS	Resource units assigned
USAGE_RATE_OR_AMOUNT	Resource usage rate
USAGE_RATE_OR_AMOUNT_INVERSE	Resource usage rate inverse
BASIS_TYPE	Basis type identifier
SCHEDULE_FLAG	Schedule the resource
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RESOURCE_OFFSET_PERCENT	Resource offset percent from the start of the routing
AUTOCHARGE_TYPE	Autocharge type for shop floor moves
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ASSEMBLY_ITEM_ID	Inventory item identifier of manufactured assembly
ALTERNATE_ROUTING_DESIGNATOR	Alternate designator code
ORGANIZATION_ID	Organization identifier
OPERATION_SEQ_NUM	Operation sequence number
EFFECTIVITY_DATE	Effective date
ROUTING_SEQUENCE_ID	Routing unique identifier
ORGANIZATION_CODE	Abbreviation of organization name
ASSEMBLY_ITEM_NUMBER	Concatenated item segments
RESOURCE_CODE	Resource name
ACTIVITY	Activity name
TRANSACTION_ID	Row identifier
PROCESS_FLAG	Row status
TRANSACTION_TYPE	Create, Update, or Delete
NEW_RESOURCE_SEQ_NUM	New resource sequence number. This column was added to facilitate updates because it's part of the primary key.
PRINCIPLE_FLAG	Principal flag
SCHEDULE_SEQ_NUM	Schedule sequence number
ORIGINAL_SYSTEM_REFERENCE
SETUP_CODE
ECO_NAME
NEW_ROUTING_REVISION
ACD_TYPE
ENG_CHANGES_IFCE_KEY
ENG_REVISED_ITEMS_IFCE_KEY
BOM_REV_OP_IFCE_KEY
BOM_REV_OP_RES_IFCE_KEY
NEW_REVISED_ITEM_REVISION	This column is used by the ECO BO for holding the information about the new revised item revision
SUBSTITUTE_GROUP_NUM	Substitute Group Number

Bills of Material - BOM_OP_ROUTINGS_INTERFACE	Routing interface data
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
MIXED_MODEL_MAP_FLAG	Use this routing in mixed model map calculation
PRIORITY	For information only
CFM_ROUTING_FLAG	Continous flow or traditional routing
TOTAL_PRODUCT_CYCLE_TIME	Total time that an assembly takes along the primary path in the operation network calculated by Flow Manufacturing
CTP_FLAG	Flag indicating capacity must be checked when item is ordered
ORIGINAL_SYSTEM_REFERENCE	Original system reference
LAST_UPDATED_BY	Standard Who column
SERIALIZATION_START_OP	Serialization Starting Operation Sequence Number for standard routings
DELETE_GROUP_NAME	Delete group name
DG_DESCRIPTION	Delete group description
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ROUTING_SEQUENCE_ID	Routing unique identifier
ROUTING_TYPE	Routing type: 2=Engineering routing 1=Manufacturing routing
COMMON_ASSEMBLY_ITEM_ID	Inventory item identifier for common assembly
COMMON_ROUTING_SEQUENCE_ID	Routing unique identifier of common routing
ROUTING_COMMENT	Specific comment about routing
COMPLETION_SUBINVENTORY	Destination subinventory for assembly
COMPLETION_LOCATOR_ID	Destination location for assembly
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ASSEMBLY_ITEM_ID	Inventory item identifier for manufactured assembly
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
BATCH_ID	BATCH_ID
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
DEMAND_SOURCE_LINE	Demand source line - used for ATO
SET_ID	Set identifier - used for ATO
PROCESS_REVISION	Routing revision
DEMAND_SOURCE_TYPE	Demand source type - used for ATO
DEMAND_SOURCE_HEADER_ID	Demand source header identifier - used for ATO
ALTERNATE_ROUTING_DESIGNATOR	Alternate designator code
ORGANIZATION_CODE	Abbreviation of organization name
ASSEMBLY_ITEM_NUMBER	Concatenated item segments
COMMON_ITEM_NUMBER	Concatenated item segments of the common routing
LOCATION_NAME	Concatenated location segments
TRANSACTION_ID	Row identifier
PROCESS_FLAG	Row status
TRANSACTION_TYPE	Insert, Update or Delete Routing
LINE_ID	Unique identifier from WIP Lines used in Flow Manufacturing
LINE_CODE	Name of WIP Line

Bills of Material - BOM_OP_SEQUENCES_INTERFACE	Routing operation interface data
Column Name	Descritpion
ROUTING_SEQUENCE_ID	Routing unique identifier
ASSEMBLY_ITEM_NUMBER	Concatenated item segments
DEPARTMENT_CODE	Department name
OPERATION_CODE	Standard operation code
RESOURCE_ID1	First resource identifier
RESOURCE_ID2	Second resource identifier
RESOURCE_ID3	Third resource identifier
RESOURCE_CODE1	First resource name
RESOURCE_CODE2	Second resource name
RESOURCE_CODE3	Third resource name
INSTRUCTION_CODE1	First standard instruction code
OPERATION_SEQ_NUM	Operation sequence number
INSTRUCTION_CODE2	Second standard instruction code
INSTRUCTION_CODE3	Third standard instruction code
TRANSACTION_ID	Row identifier
PROCESS_FLAG	Row status
TRANSACTION_TYPE	Create, Update or Delete
NEW_OPERATION_SEQ_NUM	Added to facilitate updates because it's part of the primary key
NEW_EFFECTIVITY_DATE	Added to facilitate updates because it's part of the primary key
ASSEMBLY_TYPE	Not used in open interface
OPERATION_TYPE	Operation Type: process, line operation, or event
REFERENCE_FLAG	If the Standard Operation is referenced or copied then the operation can not be updated
LAST_UPDATE_DATE	Standard Who column
PROCESS_OP_SEQ_ID	Operation sequence identifier of parent process (only applies to events)
LINE_OP_SEQ_ID	Operation sequence identifier of the parent line operation (only applies to events)
YIELD	Process yield at this operation
CUMULATIVE_YIELD	Cumulative process yield from begining of routing to this operation
REVERSE_CUMULATIVE_YIELD	Cumulative process yield from end of routing to comparable operation. For example, if this is the second operation out of 10 operations, the reverse cumulative yield would be the total yield from the tenth down to the ninth operation
LABOR_TIME_CALC	System calculated run time attributable to labor
MACHINE_TIME_CALC	System calculated run time attributable to machines
TOTAL_TIME_CALC	System calculated run time attributable to both labor and machines
LABOR_TIME_USER	User calculated run time attributable to labor
MACHINE_TIME_USER	User calculated run time attributable to machines
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
BATCH_ID	BATCH_ID
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
STANDARD_OPERATION_ID	Standard operation unique identifier
DEPARTMENT_ID	Department unique identifier
OPERATION_LEAD_TIME_PERCENT	Indicates the amount of overlap lead time this has with the parent's lead time
RUN_TIME_OVERLAP_PERCENT	Not currently used
MINIMUM_TRANSFER_QUANTITY	Minimum operation transfer quantity
COUNT_POINT_TYPE	Count point
OPERATION_DESCRIPTION	Description of operation
EFFECTIVITY_DATE	Date operation is effective
CHANGE_NOTICE	Not currently used
IMPLEMENTATION_DATE	Not currently used
DISABLE_DATE	Date operation is no longer effective - effectivity lasts until the end of the disable date
BACKFLUSH_FLAG	Indicates whether operation requires backflushing
OPTION_DEPENDENT_FLAG	Indicates whether to use this operation in all configuration routings, even if no components of the configuration are used in this routing
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
TOTAL_TIME_USER	User calculated run time attributable to both labor and machines
NET_PLANNING_PERCENT	Cumulative planning percents derived from the operation network
ATTRIBUTE9	Descriptive flexfield segment
INCLUDE_IN_ROLLUP	Indicates whether operation yield is to be considered in cost rollup
OPERATION_YIELD_ENABLED	Indicates whether operation yield is to be considered during costing.
PROCESS_SEQ_NUMBER	Operation sequence identifier of parent process (applies only to events)
ATTRIBUTE10	Descriptive flexfield segment
PROCESS_CODE	Parent process code (applies only to events)
LINE_OP_SEQ_NUMBER	Operation sequence identifier of the parent line operation - only applies to events
LINE_OP_CODE	Code of the parent line operation - only applies to events
ORIGINAL_SYSTEM_REFERENCE	Original System Reference for the current record has come from
ATTRIBUTE11	Descriptive flexfield segment
SHUTDOWN_TYPE	Shutdown type
LONG_DESCRIPTION	Used by EAM routings
DELETE_GROUP_NAME	Delete Group Name
DG_DESCRIPTION	Delete Group Description
ATTRIBUTE12	Descriptive flexfield segment
NEW_ROUTING_REVISION	New Routing Revision
ACD_TYPE	ACD type
OLD_START_EFFECTIVE_DATE	Old Effectivity Date
CANCEL_COMMENTS	Cancellation Comment
ATTRIBUTE13	Descriptive flexfield segment
ENG_CHANGES_IFCE_KEY	Engineering changes IFCE key
ENG_REVISED_ITEMS_IFCE_KEY	Engineering revised item IFCE key
BOM_REV_OP_IFCE_KEY	BOM Rev operation IFCE key
NEW_REVISED_ITEM_REVISION	This column is used by the ECO BO for holding the information about the new revised item revision
ATTRIBUTE14	Descriptive flexfield segment
OPERATION_SEQUENCE_ID	Routing operation unique identifier
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
MODEL_OP_SEQ_ID	Operation sequence identifier from model bill
ASSEMBLY_ITEM_ID	Inventory item identifier of manufactured assembly
ORGANIZATION_ID	Organization identifier
ALTERNATE_ROUTING_DESIGNATOR	Alternate designator code
ORGANIZATION_CODE	Abbreviation of organization name

Bills of Material - BOM_PERIOD_START_DATES	Workday calendar period start dates
Column Name	Descritpion
CALENDAR_CODE	Workday calendar identifier
PERIOD_NAME	Period Name (depends on quarterly calendar type chosen)
NEXT_DATE	Next calendar date corresponding to next sequence number
PRIOR_DATE	Prior date corresponding to prior sequence number
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
EXCEPTION_SET_ID	Exception set unique identifier
PERIOD_START_DATE	Period start date
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LAST_UPDATE_DATE	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
PERIOD_SEQUENCE_NUM	Sequence number

Bills of Material - BOM_REF_DESGS_INTERFACE	Reference designator interface data
Column Name	Descritpion
CREATED_BY	Standard Who column
BOM_REF_DESGS_IFCE_KEY	User defined identifier for linking rows of the same business object
BOM_INVENTORY_COMPS_IFCE_KEY	User defined identifier to link rows pertaining to the same business object
ENG_REVISED_ITEMS_IFCE_KEY	User defined identifier to link rows pertaining to the same business object
ENG_CHANGES_IFCE_KEY	User defined identifier to link rows pertaining to the same business object
FROM_END_ITEM_UNIT_NUMBER	From End Item Unit Number
LAST_UPDATE_LOGIN	Standard Who column
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from
NEW_REVISED_ITEM_REVISION	New Revised Item Revision is one of the unique keys to identify a revised item of a change
RETURN_STATUS
BATCH_ID	Batch Identifier for Data Load
REF_DESIGNATOR_COMMENT	Reference designator comment
COMP_SOURCE_SYSTEM_REFERENCE	Component Source System Item Name
PARENT_SOURCE_SYSTEM_REFERENCE	Parent Source System Item Name
CHANGE_ID	Change Identifier
CHANGE_TRANSACTION_TYPE	Change Management Transaction Type for Change Orders
CHANGE_NOTICE	Engineering change order number
INTERFACE_TABLE_UNIQUE_ID	InterfaceTable Unique Id for Merge
ASSEMBLY_ITEM_REVISION_CODE
ASSEMBLY_ITEM_REVISION_ID
COMPONENT_SEQUENCE_ID	Component unique identifier
COMPONENT_REFERENCE_DESIGNATOR	Component reference designator
ACD_TYPE	Add or delete code from an ECO
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
NEW_DESIGNATOR	Updated value for the old reference designator.
PROGRAM_UPDATE_DATE	Concurrent Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
BILL_SEQUENCE_ID	Bill of material unique identifier
ASSEMBLY_ITEM_ID	Inventory item identifier of the bill
ALTERNATE_BOM_DESIGNATOR	Alternate designator code
ORGANIZATION_ID	Organization identifier
COMPONENT_ITEM_ID	Component item identifier
OPERATION_SEQ_NUM	Operation sequence number
EFFECTIVITY_DATE	Effective date
CREATION_DATE	Standard Who column
ORGANIZATION_CODE	Abbreviation of organization name
ASSEMBLY_ITEM_NUMBER	Concatenated item segments of the bill
COMPONENT_ITEM_NUMBER	Concatenated item segments of the component
TRANSACTION_ID	Row identifier
PROCESS_FLAG	Row status
INTERFACE_ENTITY_TYPE	Record used for Bill or ECO Open Interface: BILL, ECO
TRANSACTION_TYPE	Type of action: CREATE, UPDATE or DELETE

Bills of Material - BOM_SHIFT_DATES	Workday calendar shift dates
Column Name	Descritpion
CALENDAR_CODE	Workday calendar identifier
SEQ_NUM	Sequence number for shift date (only for working dates)
NEXT_SEQ_NUM	Next sequence number for calendar date (working day)
PRIOR_SEQ_NUM	Prior sequence number for calendar date (working day)
NEXT_DATE	Next date corresponding to next sequence number
PRIOR_DATE	Prior date corresponding to prior sequence number
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
EXCEPTION_SET_ID	Exception set unique identifier
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
SHIFT_NUM	Shift number
SHIFT_DATE	Calendar date
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LAST_UPDATE_DATE	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Bills of Material - BOM_SUB_COMPS_INTERFACE	Substitute component interface data
Column Name	Descritpion
CREATED_BY	Standard Who column
BOM_INVENTORY_COMPS_IFCE_KEY	User defined identifier to link rows pertaining to the same business object
ENG_REVISED_ITEMS_IFCE_KEY	User defined identifier to link rows pertaining to the same business object
ENG_CHANGES_IFCE_KEY	User defined identifier to link rows pertaining to the same business object
NEW_REVISED_ITEM_REVISION	New Revised Item Revision is one of the unique keys to identify a revised item of a change
RETURN_STATUS
LAST_UPDATE_LOGIN	Standard Who column
BATCH_ID	Batch Identifier for Data Load
COMP_SOURCE_SYSTEM_REFERENCE	Component Source System Item Name
PARENT_SOURCE_SYSTEM_REFERENCE	Parent Source System Item Name
SUBCOM_SOURCE_SYSTEM_REFERENCE	Subcomponent Source System Item Name
CHANGE_ID	Change Identifier
SUB_COMP_INVERSE_QUANTITY	Inverse Quantity of substitute component in bill of material
CHANGE_TRANSACTION_TYPE	Change Management Transaction Type for Change Orders
INTERFACE_TABLE_UNIQUE_ID	Interface Table Unique Id for Merge
SUBSTITUTE_ITEM_QUANTITY	Substitute component quantity
ASSEMBLY_ITEM_REVISION_CODE	Assembly item revision code
ASSEMBLY_ITEM_REVISION_ID	Assembly item revision id
COMPONENT_SEQUENCE_ID	Component unique identifier
SUBSTITUTE_COMPONENT_ID	Inventory item identifier of substitute component
ACD_TYPE	Add or delete code from an engineering change order
CHANGE_NOTICE	Engineering change order number
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
NEW_SUB_COMP_ID	Updated value for the SUBSTITUTE_COMPONENT_ID
PROGRAM_UPDATE_DATE	Concurrent Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
BILL_SEQUENCE_ID	Bill of material unique identifier
ASSEMBLY_ITEM_ID	Inventory item identifier of the bill
ALTERNATE_BOM_DESIGNATOR	Alternate designator code
ORGANIZATION_ID	Organization identifier
COMPONENT_ITEM_ID	Component item identifier
OPERATION_SEQ_NUM	Operation sequence number
EFFECTIVITY_DATE	Effective date
TRANSACTION_ID	Row identifier
CREATION_DATE	Standard Who column
PROCESS_FLAG	Row status
ORGANIZATION_CODE	Abbreviation of organization name
SUBSTITUTE_COMP_NUMBER	Concatenated item segments of the substitute component
NEW_SUB_COMP_NUMBER	Updated value for the SUBSTITUTE_COMP_NUMBER
COMPONENT_ITEM_NUMBER	Concatenated item segments of the component
ASSEMBLY_ITEM_NUMBER	Concatenated item segments of the bill
FROM_END_ITEM_UNIT_NUMBER	From End Item Unit Number
INTERFACE_ENTITY_TYPE	Record used for Bill or ECO Open Interface: BILL, ECO
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from
TRANSACTION_TYPE	Type of action: CREATE, UPDATE or DELETE
ENFORCE_INT_REQUIREMENTS	Enforce Integer Requirements
BOM_SUB_COMPS_IFCE_KEY	User defined identifier to link rows pertaining to the same business object

Bills of Material - BOM_SMALL_EXPL_TEMP	Temporary data for indented bills of material (on-line processes)
Column Name	Descritpion
COMPONENT_ITEM_ID	Component item identifier
CHECK_ATP	Flag indicating if ATP check is required
SHIPPING_ALLOWED	Flag indicating if component is allowed to ship
REQUIRED_TO_SHIP	Flag indicating if component is required to ship
REQUIRED_FOR_REVENUE	Flag indicating if component is required for revenue
INCLUDE_ON_SHIP_DOCS	Flag indicating if component is included on shipping documents
INCLUDE_ON_BILL_DOCS	Flag indicating if component is included on billing documents
LOW_QUANTITY	Minimum quantity allowed on an order
HIGH_QUANTITY	Maximum quantity allowed on an order
PICK_COMPONENTS	(not currently used)
PRIMARY_UOM_CODE	Unit of measure code of component
PLAN_LEVEL	Level in bill
PRIMARY_UNIT_OF_MEASURE	Unit of measure of component
BASE_ITEM_ID	Base item identifier
ATP_COMPONENTS_FLAG	Flag indicating whether item may have components requiring ATP check
ATP_FLAG	Flag indicating ATP must be checked when item is ordered
BOM_ITEM_TYPE	Type of item
PICK_COMPONENTS_FLAG	Flag indicating all shippable components of should be picked
REPLENISH_TO_ORDER_FLAG	Assemble to order flag
SHIPPABLE_ITEM_FLAG	Flag indicating shippable item
CUSTOMER_ORDER_FLAG	Flag indicating customer orderable item
INTERNAL_ORDER_FLAG	Flag indicating internal order
EXTENDED_QUANTITY	Extended quantity including quantity per, yield, and shrinkage
CUSTOMER_ORDER_ENABLED_FLAG	Flag indicating item is customer orderable
INTERNAL_ORDER_ENABLED_FLAG	Flag indicating item can be internally ordered
SO_TRANSACTIONS_FLAG	Sales order transactions flag
MTL_TRANSACTIONS_ENABLED_FLAG	Flag indicating item is transactable
STOCK_ENABLED_FLAG	Flag indicating item is stockable
DESCRIPTION	Description
ASSEMBLY_ITEM_ID	Assembly item identifier
CONFIGURATOR_FLAG	Flag indicating if component is used by the configurator form
PRICE_LIST_ID	System-generated identifier of price list
ROUNDING_FACTOR	Rounding factor used to determine order quantity
SORT_ORDER	Sorting sequence for the explosion
PRICING_CONTEXT	Descriptive flexfield structure defining column
PRICING_ATTRIBUTE1	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE2	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE3	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE4	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE5	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE6	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE7	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE8	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE9	User defined attribute that adjusts the list price of an item
REQUEST_ID	Concurrent Who column
PRICING_ATTRIBUTE10	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE11	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE12	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE13	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE14	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE15	User defined attribute that adjusts the list price of an item
COMPONENT_CODE	Concatenation of component item identifiers
LOOP_FLAG	Indicates whether a loop is detected
INVENTORY_ASSET_FLAG	Flag indicating item is an inventory asset
PLANNING_FACTOR	Factor used to multiply component quantity with to obtain planning quantity
TOP_BILL_SEQUENCE_ID	Bill identifier of level 0 items
PROGRAM_APPLICATION_ID	Concurrent Who column
OPERATION_SEQ_NUM	Operation sequence number
PARENT_BOM_ITEM_TYPE	Parent item's bom item type
WIP_SUPPLY_TYPE	Supply type
ITEM_NUM	Item sequence within bill of material structure
EFFECTIVITY_DATE	Effective date
DISABLE_DATE	Disable date
IMPLEMENTATION_DATE	Date on which engineering change order was implemented
SUPPLY_SUBINVENTORY	Supply subinventory
SUPPLY_LOCATOR_ID	Supply locator identifier
COMPONENT_REMARKS	Component remarks
PROGRAM_ID	Concurrent Who column
CHANGE_NOTICE	Engineering change order number
OPERATION_LEAD_TIME_PERCENT	Operation offset from first operation in routing
REXPLODE_FLAG	Flag indicating whether to re-explode
COMMON_BILL_SEQUENCE_ID	Common bill of material unique identifier
OPERATION_OFFSET	Component's lead time
CURRENT_REVISION	Component's item revision
LOCATOR	Component's supply locator
FROM_END_ITEM_UNIT_NUMBER	Indicates the first unit number of an item to be included
PROGRAM_UPDATE_DATE	Concurrent Who column
TO_END_ITEM_UNIT_NUMBER	Indicates the last unit number of an item to be included
SUGGESTED_VENDOR_NAME	Used by direct items in EAM BOMs
VENDOR_ID	Used by direct items in EAM BOMs
UNIT_PRICE	Unit Price for direct items used by EAM BOMs
GROUP_ID	Explosion identifier
SESSION_ID	Session identifier
SELECT_FLAG	Whether this component has been ordered
SELECT_QUANTITY	Order quantity
EXTEND_COST_FLAG	Whether to extend cost for this item
TOP_ALTERNATE_DESIGNATOR	Alternate designator for level 0
TOP_ITEM_ID	Item identifier of level 0 item
BILL_SEQUENCE_ID	Bill of material unique identifier
CONTEXT	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
HEADER_ID	System-generated identifier of order header
LINE_ID	System-generated identifier of order, configuration, or shipment schedule line
LIST_PRICE	The price of the item on the price list
SELLING_PRICE	Actual price charged to customer
COMPONENT_SEQUENCE_ID	Component unique identifier
COMPONENT_YIELD_FACTOR	Component yield
ITEM_COST	Item unit cost
INCLUDE_IN_ROLLUP_FLAG	Flag indicating if component is to be used when rolling up costs
BASED_ON_ROLLUP_FLAG	Flag indicating whether cost will be rolled up
ACTUAL_COST_TYPE_ID	Actual cost type identifier
BASIS_TYPE	Basis type identifier
COMPONENT_QUANTITY	Quantity of component in bill of material
SHRINKAGE_RATE	Planned shrinkage rate
SO_BASIS	Quantity basis used by Oracle Order Entry to determine how many units of component to put on an order
OPTIONAL	Flag indicating if component is optional in bill of material
MUTUALLY_EXCLUSIVE_OPTIONS	Flag indicating if one or more children of component can be picked when taking an order

Bills of Material - BOM_SMALL_IMPL_TEMP	Temporary data for item usage (View Item Usage window)
Column Name	Descritpion
ALTERNATE_DESIGNATOR	Alternate bom designator
CURRENT_LEVEL	Implosion level
SORT_CODE	Sort sequence
LOWEST_ALTERNATE_DESIGNATOR	Alternate bom designator of level 1 items
CURRENT_ASSEMBLY_TYPE	Assembly type
SEQUENCE_ID	Implosion identifier
COMPONENT_SEQUENCE_ID	Component unique identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LOWEST_PK5_VALUE
CREATED_BY	Standard Who column
CURRENT_GTIN_DESCRIPTION
LAST_UPDATE_LOGIN	Standard Who column
LOWEST_OBJ_NAME
CURRENT_PK1_VALUE
REQUEST_ID	Concurrent Who column
CURRENT_PK3_VALUE
PROGRAM_APPLICATION_ID	Concurrent Who column
CURRENT_PK5_VALUE
PROGRAM_ID	Concurrent Who column
PARENT_PK1_VALUE
PROGRAM_UPDATE_DATE	Concurrent Who column
PARENT_PK3_VALUE
LOWEST_ITEM_ID	Identifier of item to implode
ORGANIZATION_ID	Organization identifier
PARENT_PK5_VALUE
OPERATION_SEQ_NUM	Operation sequence number
LOWEST_PK4_VALUE
LOWEST_PK1_VALUE
EFFECTIVITY_DATE	Effective date
LOWEST_PK2_VALUE
LOWEST_PK3_VALUE
DISABLE_DATE	Disable date
LOWEST_TRADE_ITEM_DESCRIPTOR
BASIS_TYPE	Basis type identifier
COMPONENT_QUANTITY	Component quantity
PARENT_GTIN_NUMBER
TOP_ITEM_FLAG
REVISED_ITEM_SEQUENCE_ID	Revised item unique identifier
PARENT_SORT_CODE
CURRENT_GTIN_NUMBER
CHANGE_NOTICE	ECO Identifier
CURRENT_TRADE_ITEM_DESCRIPTOR
IMPLEMENTED_FLAG	Indicator if component row is implemented or pending
PARENT_GTIN_DESCRIPTION
PARENT_TRADE_ITEM_DESCRIPTOR
PARENT_OBJ_NAME
LOWEST_GTIN_NUMBER
LOWEST_GTIN_DESCRIPTION
PARENT_PK4_VALUE
FROM_END_ITEM_UNIT_NUMBER	Indicates the first unit number to be included
CURRENT_ITEM_ID	Item identifier of current component
CURRENT_PK4_VALUE
GTIN_PUBLICATION_STATUS
CURRENT_OBJ_NAME
ACCESS_FLAG
TO_END_ITEM_UNIT_NUMBER	Indicates the first unit number to be included
PARENT_PK2_VALUE
COMPONENT_ITEM_REVISION_ID
CURRENT_PK2_VALUE
FROM_END_ITEM_REVISION
TO_END_ITEM_REVISION
IMPLOSION_DATE
SUGGESTED_VENDOR_NAME	Used by direct items in EAM BOMs
IS_EXCLUDED_BY_RULE
EFFECTIVITY_CONTROL
COMPONENT_PATH
VENDOR_ID	Used by direct items in EAM BOMs
UNIT_PRICE	Unit Price for direct items used by EAM BOMs
PARENT_ITEM_ID	Assembly item identifier
PRIMARY_UOM_DESCRIPTOR
STRUCTURE_TYPE_ID

Bills of Material - BOM_WORKDAY_PATTERNS	On/Off workday patterns for calendars and shifts
Column Name	Descritpion
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
DAYS_ON	Number of days on
DAYS_OFF	Number of days off
CALENDAR_CODE	Workday calendar identifier
DESCRIPTION	Description
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
SHIFT_NUM	Shift number
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
SEQ_NUM	Sequence number
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
LAST_UPDATE_DATE	Standard Who Column
PROGRAM_UPDATE_DATE	Concurrent Who column
LAST_UPDATED_BY	Standard Who Column

Bills of Material - BOM_ATO_CONFIGURATIONS	Unique configuration definition
Column Name	Descritpion
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
CONFIG_ITEM_ID	Configuration item identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COMPONENT_QUANTITY	Quantity per of component
LAST_REFERENCED_DATE	Last referenced date of the configured item
ORGANIZATION_ID	Organization identifier
REQUEST_ID	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
CFM_ROUTING_FLAG	CFM_ROUTING_FLAG
BASE_MODEL_ID	Base model identifier
COMPONENT_ITEM_ID	Component item identifier
COMPONENT_CODE	Concatenated string of item identifiers

Bills of Material - BOM_EXCEPTION_SET_DATES	Used for workday exception templates
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
EXCEPTION_SET_ID	Exception set unique identifier
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
EXCEPTION_DATE	Specifies the date for the exception
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
EXCEPTION_TYPE	Specifies whether the exception is an off day or an on day
LAST_UPDATE_DATE	Standard Who Column

Bills of Material - BOM_CONFIG_EXPLOSIONS	Temporary data for ATO configurator window
Column Name	Descritpion
TOP_BILL_SEQUENCE_ID	Top Bill Sequence Identifier
CREATION_DATE	Who column
COMMON_BILL_SEQUENCE_ID	Common bill of material unique identifier
COMP_BILL_SEQ_ID	Bill Sequence identifier of component
COMP_COMMON_BILL_SEQ_ID	Common bill sequence id of component
NUM_COL1	Updatable column for Configurator
NUM_COL2	Updatable column for Configurator
CREATED_BY	Who Column
NUM_COL3	Updatable column for Configurator
DATE_COL1	Updatable column for Configurator
LAST_UPDATE_DATE	Who column
DATE_COL2	Updatable column for Configurator
DATE_COL3	Updatable column for Configurator
CHAR_COL1	Updatable column for Configurator
CHAR_COL2	Updatable column for Configurator
LAST_UPDATED_BY	Who column
CHAR_COL3	Updatable column for Configurator
PREVIOUS_SELECTED_QTY	This column is no longer used.
AUTO_SELECTED_QUANTITY	This column is no longer used.
GROUP_ID	Explosion identifier
SELECTED_LINE_ID	This column is no longer used.
CONFIG_HEADER_ID	This column is no longer used.
SESSION_ID	Session identifier
CONFIG_REV_NBR	This column is no longer used.
SELECT_FLAG	Whether this component has been ordered
SELECT_QUANTITY	Order quantity
TOP_ITEM_ID	Item identifier of level 0 item
CONTEXT	Descriptive flexfield structure defining column
BILL_SEQUENCE_ID	Bill of material unique identifier
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
SYSTEM_ID	System-generated identifier of order header
HEADER_ID	System-generated identifier of order header
LINE_ID	System-generated identifier of order, configuration or shipment schedule line
EXPLOSION_TYPE	Optional, Included or All components
ITEM_SVRID	System-generated identifier of order header
LIST_PRICE	The price of the item on the price list
SELLING_PRICE	Actual price charged to customer
COMPONENT_QUANTITY	Quantity of component in bill of material
SO_BASIS	Quantity basis used by Oracle Order Entry to determine how many units of component to put on an order
OPTIONAL	Flag indicating if component is optional in bill of material
MUTUALLY_EXCLUSIVE_OPTIONS	Flag indicating if one or more children of component can be picked when taking an order
CHECK_ATP	Flag indicating if ATP check is required
SHIPPING_ALLOWED	Flag indicating if component is allowed to ship
REQUIRED_TO_SHIP	Flag indicating if component is required to ship
COMPONENT_SEQUENCE_ID	Component unique identifier
REQUIRED_FOR_REVENUE	Flag indicating if component is required for revenue
INCLUDE_ON_SHIP_DOCS	Flag indicating if component is included on shipping documents
INCLUDE_ON_BILL_DOCS	Flag indicating if component is included on billing documents
LOW_QUANTITY	Minimum quantity allowed on an order
HIGH_QUANTITY	Maximum quantity allowed on an order
PICK_COMPONENTS	(not currently used)
PRIMARY_UOM_CODE	Unit of measure code of component
PRIMARY_UNIT_OF_MEASURE	Unit of measure of component
BASE_ITEM_ID	Base item identifier
ATP_COMPONENTS_FLAG	Flag indicating whether item may have components requiring ATP check
COMPONENT_ITEM_ID	Component item identifier
ATP_FLAG	Flag indicating ATP must be checked when item is ordered
BOM_ITEM_TYPE	Type of item
PICK_COMPONENTS_FLAG	Flag indicating all shippable components of should be picked
REPLENISH_TO_ORDER_FLAG	Assemble to order flag
SHIPPABLE_ITEM_FLAG	Flag indicating shippable item
CUSTOMER_ORDER_FLAG	Flag indicating customer orderable item
INTERNAL_ORDER_FLAG	Flag indicating internally orderable item
CUSTOMER_ORDER_ENABLED_FLAG	Flag indicating item is customer orderable
INTERNAL_ORDER_ENABLED_FLAG	Flag indicating item is internally orderable
SO_TRANSACTIONS_FLAG	Sales order transactions flag
PLAN_LEVEL	Level in bill
DESCRIPTION	Description
ASSEMBLY_ITEM_ID	Assembly item identifier
CONFIGURATOR_FLAG	Flag indicating if component is used by the configurator form
PRICE_LIST_ID	System-generated identifier of price list
ROUNDING_FACTOR	Rounding factor used to determine order quantity
PRICING_CONTEXT	Descriptive flexfield structure defining column
PRICING_ATTRIBUTE1	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE2	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE3	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE4	User defined attribute that adjusts the list price of an item
EXTENDED_QUANTITY	Extended quantity including quantity per, yield, and shrinkage
PRICING_ATTRIBUTE5	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE6	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE7	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE8	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE9	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE10	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE11	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE12	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE13	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE14	User defined attribute that adjusts the list price of an item
SORT_ORDER	Sorting sequence for the explosion
PRICING_ATTRIBUTE15	User defined attribute that adjusts the list price of an item
COMPONENT_CODE	Concatenation of component item identifiers
LOOP_FLAG	Indicates whether a loop is detected
PARENT_BOM_ITEM_TYPE	Parent item's bom item type
OPERATION_SEQ_NUM	Operation sequence number
ITEM_NUM	Item unit cost
EFFECTIVITY_DATE	Effective date
DISABLE_DATE	Disable date
IMPLEMENTATION_DATE	Date on which engineering change order was implemented
REXPLODE_FLAG	Flag indicating whether to re-explode

Bills of Material - BOM_EXPLOSIONS	Pre-exploded model bills for use by Order Entry
Column Name	Descritpion
TOP_BILL_SEQUENCE_ID	Bill identifier of level 0 items
CREATION_DATE	Who column
INCLUDE_IN_COST_ROLLUP	Flag indicating if this component is to be used when rolling up costs
CREATED_BY	Who column
COMPONENT_YIELD_FACTOR	Factor used to multiply component quantity with to obtain required component quantity
PLANNING_FACTOR	Factor used to multiply component quantity with to obtain planning quantity
LAST_UPDATE_DATE	Who column
CHANGE_NOTICE	Engineering change order number
PARENT_SORT_ORDER	Parent Sorting sequence for the explosion
LAST_UPDATED_BY	Who column
SUGGESTED_VENDOR_NAME	Suggested vendor name
VENDOR_ID	Suggested Vendor ID column
TOP_ITEM_ID	Item identifier of level 0 item
UNIT_PRICE	Unit Price for direct items used by EAM BOMs
REQUEST_ID	Request id
CONTEXT	Descriptive flexfield structure defining column
SOURCE_BILL_SEQUENCE_ID	Source bill sequence id
COMMON_COMPONENT_SEQUENCE_ID	Common component sequence id
ATTRIBUTE1	Descriptive flexfield segment
COMP_SOURCE_BILL_SEQ_ID	Component source bill sequence id
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
BILL_SEQUENCE_ID	Bill of material unique identifier of parent
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
ATTRIBUTE15	Descriptive flexfield segment
COMPONENT_QUANTITY	Quantity of component in bill of material
SO_BASIS	Quantity basis used by Oracle Order Management to determine how many units of component to put on an order
OPTIONAL	Flag indicating if component is optional in bill of material
MUTUALLY_EXCLUSIVE_OPTIONS	Flag indicating if one or more children of component can be picked when taking an order
CHECK_ATP	Flag indicating if ATP check is required
SHIPPING_ALLOWED	Flag indicating if component is allowed to ship
REQUIRED_TO_SHIP	Flag indicating if component is required to ship
REQUIRED_FOR_REVENUE	Flag indicating if component is required for revenue
INCLUDE_ON_SHIP_DOCS	Flag indicating if component is included on shipping documents
EXPLOSION_TYPE	Optional, included or all components
INCLUDE_ON_BILL_DOCS	Flag indicating if component is included on billing documents
LOW_QUANTITY	Minimum quantity allowed on an order
HIGH_QUANTITY	Maximum quantity allowed on an order
PICK_COMPONENTS	(not currently used)
PRIMARY_UOM_CODE	Unit of measure code of component
PRIMARY_UNIT_OF_MEASURE	Unit of measure of component
BASE_ITEM_ID	Base item identifier
ATP_COMPONENTS_FLAG	Flag indicating whether item may have components requiring ATP check
ATP_FLAG	Flag indicating ATP must be checked when item is ordered
BOM_ITEM_TYPE	Type of item
COMPONENT_SEQUENCE_ID	Component unique identifier
PICK_COMPONENTS_FLAG	Flag indicating all shippable components should be picked
REPLENISH_TO_ORDER_FLAG	Assemble to order flag
SHIPPABLE_ITEM_FLAG	Flag indicating shippable item
CUSTOMER_ORDER_FLAG	Flag indicating customer orderable item
INTERNAL_ORDER_FLAG	Flag indicating internally orderable item
CUSTOMER_ORDER_ENABLED_FLAG	Flag indicating item is customer orderable
INTERNAL_ORDER_ENABLED_FLAG	Flag indicating item is internally orderable
SO_TRANSACTIONS_FLAG	Sales order transactions flag
DESCRIPTION	Description
ASSEMBLY_ITEM_ID	Assembly item identifier
COMPONENT_ITEM_ID	Component item identifier
COMPONENT_CODE	Concatenation of component item identifiers
LOOP_FLAG	Indicates whether a loop is detected
PARENT_BOM_ITEM_TYPE	Parent item's bom item type
OPERATION_SEQ_NUM	Operation sequence number
ITEM_NUM	Item sequence within bill of material structure
EFFECTIVITY_DATE	Effective date
DISABLE_DATE	Disable date
IMPLEMENTATION_DATE	Date on which engineering change order was implemented
REXPLODE_FLAG	Flag indicating whether to re-explode
COMMON_BILL_SEQUENCE_ID	Common bill of material unique identifier of parent
PLAN_LEVEL	Level in bill
COMP_BILL_SEQ_ID	Component's bill sequence identifier
COMP_COMMON_BILL_SEQ_ID	Component's common bill sequence identifier
EXPLODE_GROUP_ID	(not used)
BASIS_TYPE	Basis type identifier
NUM_COL1	(not used)
NUM_COL2	(not used)
NUM_COL3	(not used)
EXTENDED_QUANTITY	Extended quantity including quantity per, yield, and shrinkage
DATE_COL1	(not used)
DATE_COL2	(not used)
DATE_COL3	(not used)
CHAR_COL1	(not used)
CHAR_COL2	(not used)
SORT_ORDER	Sorting sequence for the explosion
CHAR_COL3	(not used)
AUTO_REQUEST_MATERIAL	Auomatically create move order for the material at work order release

Bills of Material - BOM_INTERFACE_DELETE_GROUPS	Delete group names for Bill, Routing and Engineering change order Open Interface
Column Name	Descritpion
ENTITY_NAME	Name of the entity the delete group name is used for.The values in this column can only be: BOM_BILL_OF_MTLS_INTERFACE, BOM_INVENTORY_COMPS_INTERFACE, BOM_OP_ ROUTINGS_INTERFACE, or BOM_OP_SEQUENCES_INTERFACE
DELETE_GROUP_NAME	Delete group name for the entity type you are deleting
DESCRIPTION	Description of the delete group

Bills of Material - BOM_INVENTORY_COMPS_ARCHIVE	Bill of material components
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ITEM_NUM	Item sequence within bill of material structure
ATTRIBUTE14	Descriptive flexfield segment
BASIS_TYPE	Basis type identifier
ATTRIBUTE15	Descriptive flexfield segment
PLANNING_FACTOR	Factor used to multiply component quantity with to obtain planning quantity
QUANTITY_RELATED	Identifier to indicate if this component has quantity related reference designators
SO_BASIS	Quantity basis used by Oracle Order Management to determine how many units of component to put on an order
OPTIONAL	Flag indicating if component is optional in bill
COMPONENT_QUANTITY	Quantity of component in bill of material
MUTUALLY_EXCLUSIVE_OPTIONS	Flag indicating if one or more children of component can be picked when taking an order
INCLUDE_IN_COST_ROLLUP	Flag indicating if this component is to be used when rolling up costs
CHECK_ATP	Flag indicating if ATP check is required
SHIPPING_ALLOWED	Flag indicating if component is allowed to ship
REQUIRED_TO_SHIP	Flag indicating if component is required to ship
COMPONENT_YIELD_FACTOR	Factor used to multiply component quantity with to obtain required component quantity
REQUIRED_FOR_REVENUE	Flag indicating if component is required for revenue
INCLUDE_ON_SHIP_DOCS	Flag indicating if component is displayed on shipping documents
INCLUDE_ON_BILL_DOCS	(not currently used)
LOW_QUANTITY	Minimum quantity allowed on an order
HIGH_QUANTITY	Maximum quantity allowed on an order
ACD_TYPE	Add, change, or disable code for component on an engineering change order
OLD_COMPONENT_SEQUENCE_ID	Identifier of original component row an ECO affects
COMPONENT_SEQUENCE_ID	Component unique identifier
BILL_SEQUENCE_ID	Bill of material unique identifier
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
WIP_SUPPLY_TYPE	WIP supply type code
PICK_COMPONENTS	(not currently used)
SUPPLY_SUBINVENTORY	Supply subinventory
SUPPLY_LOCATOR_ID	Supply locator identifier
OPERATION_LEAD_TIME_PERCENT	Operation offset from first operation in routing (Denormalized from corresponding column in BOM_OPERATION_SEQUNCES)
REVISED_ITEM_SEQUENCE_ID	Engineering change order revised item identifier
COST_FACTOR	(not currently used)
COMPONENT_REMARKS	Component remarks
BOM_ITEM_TYPE	Type of item (denormalized from BOM Item Type in MTL_SYSTEM_ITEMS)
FROM_END_ITEM_UNIT_NUMBER	From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER	To End Item Unit Number
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from
COMPONENT_ITEM_REVISION_ID	Item revision Identifier
EFFECTIVITY_DATE	Effective date
ECO_FOR_PRODUCTION	Indicates if this component on an Engineering Change Order is only for WIP jobs
DELETE_GROUP_NAME	Delete group name for the entity type you are deleting
DG_DESCRIPTION	Description of the delete group
ENFORCE_INT_REQUIREMENTS	Enforce Integer Requirements
OPTIONAL_ON_MODEL	Flag indicating if component is optional on model bill (for ATO)
PARENT_BILL_SEQ_ID	Common bill sequence id of the model bill (for ATO)
CHANGE_NOTICE	Engineering change order number
MODEL_COMP_SEQ_ID	Component sequence identifier from model bill (for ATO)
PLAN_LEVEL	Plan level based on model bill (for ATO)
IMPLEMENTATION_DATE	Date on which engineering change order was implemented
FROM_BILL_REVISION_ID
DISABLE_DATE	Disable date
TO_BILL_REVISION_ID
AUTO_REQUEST_MATERIAL
SUGGESTED_VENDOR_NAME	Suggested vendor name will be used for direct items for EAM BOMs
VENDOR_ID	Suggested Vendor ID column
UNIT_PRICE	Unit Price for direct items used by EAM BOMs
OBJ_NAME
PK1_VALUE
PK2_VALUE
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
PK3_VALUE
PK4_VALUE
ATTRIBUTE1	Descriptive flexfield segment
PK5_VALUE
FROM_END_ITEM_REV_ID
ATTRIBUTE2	Descriptive flexfield segment
TO_END_ITEM_REV_ID
FROM_END_ITEM_STRC_REV_ID
ATTRIBUTE3	Descriptive flexfield segment
TO_END_ITEM_STRC_REV_ID
OVERLAPPING_CHANGES
FROM_END_ITEM_STRC_REV_CODE
TO_END_ITEM_STRC_REV_CODE
ATTRIBUTE4	Descriptive flexfield segment
FROM_STRUCTURE_REVISION_CODE
TO_STRUCTURE_REVISION_CODE
FROM_MINOR_REVISION_ID	From Minor Revision Id
TO_OBJECT_REVISION_ID	To Object Revision Id
TO_MINOR_REVISION_ID	To Minor Revision Id
FROM_END_ITEM_MINOR_REV_ID	From End Item Minor Rev Id
TO_END_ITEM_MINOR_REV_ID	To End Item Minor Rev Id
OPERATION_SEQ_NUM	Operation sequence number
ATTRIBUTE5	Descriptive flexfield segment
FROM_OBJECT_REVISION_ID	From Object Revision Id
COMPONENT_MINOR_REVISION_ID
COMMON_COMPONENT_SEQUENCE_ID
COMPONENT_ITEM_ID	Component item identifier
ATTRIBUTE6	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE7	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE8	Descriptive flexfield segment
CREATION_DATE	Standard Who column
ATTRIBUTE9	Descriptive flexfield segment
CREATED_BY	Standard Who column
ATTRIBUTE10	Descriptive flexfield segment

Bills of Material - BOM_BILL_OF_MATERIALS_ARCHIVE	Bills of material archive
Column Name	Descritpion
ASSEMBLY_ITEM_ID	Inventory item identifier of manufactured assembly
SPECIFIC_ASSEMBLY_COMMENT	Specific bill of material comment
PK3_VALUE	Primary key of the object
PK4_VALUE	Primary key of the object
PENDING_FROM_ECN	Change notice that created this bill of material
PK5_VALUE	Primary key of the object
EFFECTIVITY_CONTROL	Effectivity control
IS_PREFERRED	Flag to indicate if it is a preferrred bill
SOURCE_BILL_SEQUENCE_ID	Source bill sequence id
ORGANIZATION_ID	Organization identifier
ALTERNATE_BOM_DESIGNATOR	Alternate designator code
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ASSEMBLY_TYPE	Assembly Type: 1=Manufacturing bill 2=Engineering bill
COMMON_BILL_SEQUENCE_ID	Identifier of common bill
LAST_UPDATED_BY	Standard Who column
BILL_SEQUENCE_ID	Bill of material unique identifier
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
CREATION_DATE	Standard Who column
COMMON_ORGANIZATION_ID	Organization identifier of common bill
NEXT_EXPLODE_DATE	Next date when pre-explosion will be refreshed
PROJECT_ID	Project identifier for Project Manufacturing
TASK_ID	Task_identifier for Project Manufacturing
CREATED_BY	Standard Who column
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from
STRUCTURE_TYPE_ID	Structure Type Id
LAST_UPDATE_LOGIN	Standard Who column
IMPLEMENTATION_DATE	Implementation date
OBJ_NAME	Object name
COMMON_ASSEMBLY_ITEM_ID	Assembly item identifier of common bill
PK1_VALUE	Primary key of the object
PK2_VALUE	Primary key of the object

Bills of Material - BOM_DEPEND_DESC_ELEM_ARCHIVE	Descriptive elements assigned to model/option bills
Column Name	Descritpion
CREATION_DATE	Creation date
CREATED_BY	Created by
LAST_UPDATE_LOGIN	Last update login
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
BILL_SEQUENCE_ID	Bill of material unique identifier
PROGRAM_UPDATE_DATE	Concurrent Who column
REQUEST_ID	Concurrent Who column
ELEMENT_NAME	Descriptive element name
LAST_UPDATE_DATE	Last update date
LAST_UPDATED_BY	Last updated by

Bills of Material - BOM_OP_RESOURCES_ARCHIVE	Archive of deleted resources on operations
Column Name	Descritpion
ACTIVITY_ID	Activity identifier
CHANGE_NOTICE	Change Notice
ACD_TYPE	ACD Type
ORIGINAL_SYSTEM_REFERENCE	Original System Reference
STANDARD_RATE_FLAG	Use standard rate for shopfloor transactions
ASSIGNED_UNITS	Resource units assigned
USAGE_RATE_OR_AMOUNT	Resource usage rate
OPERATION_SEQUENCE_ID	Routing operation unique identifier
USAGE_RATE_OR_AMOUNT_INVERSE	Resource usage rate inverse
BASIS_TYPE	Basis type identifier
SCHEDULE_FLAG	Schedule the resource
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RESOURCE_OFFSET_PERCENT	Resource offset percent from the start of the routing
AUTOCHARGE_TYPE	Autocharge type for shopfloor moves
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
RESOURCE_SEQ_NUM	Resource sequence number
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
RESOURCE_ID	Resource unique identifier
SCHEDULE_SEQ_NUM	Schedule Sequence Number
SUBSTITUTE_GROUP_NUM	Substitute Group Number
PRINCIPLE_FLAG	Principal Flag
SETUP_ID

Bills of Material - BOM_MIXED_MODEL_MAP_HEADER	Header information for a mixed model map
Column Name	Descritpion
DEMAND_TYPE	Type of demand. Options include Forecast, MPS or MDS.
DEMAND_CODE	Name of the Forecast, MDS or MPS
START_DATE	Beginning date used in the Mixed Model Map generation
END_DATE	End date used in the Mixed Model Map generation
DEMAND_DAYS	Number of working days available
MIXED_MODEL_MAP_ID	Unique identifier for a mixed model map
HOURS_PER_DAY	Number of hours available per day
BOOST_PERCENT	Boost percentage
PROCESS_OR_LINEOP	Option to view either processes or line operations. One represents Process and two represents Line Operation.
SORT_ORDER	Option to order processes or line operations. One represents By Display Sequence and two represents By Code.
TIME_TYPE	Option which determines what Labor, Machine, and Total Times to pick up from the flow routing. One represents Rolled-Up Time and two represents User Entered.
IPK_VALUE	Option which determines how IPKs needed is calculated. One represents Total and two represents By Machine.
TIME_UOM	Option which determines what unit of measure to display the time values in. One represents Hour, two represents Minute, and three represents Second.
SAVE_FLAG	Determines whether header is saved to the database. One represents Yes and two represents No.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LINE_ID	Line identifier
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
FAMILY_ITEM_ID	Product Family item identifier
ORGANIZATION_ID	Organization identifier

Bills of Material - BOM_OP_ROUTINGS_ARCHIVE	Archive of deleted routings
Column Name	Descritpion
ASSEMBLY_ITEM_ID	Inventory item identifier of manufactured assembly
ROUTING_TYPE	Routing Type: 2=Engineering routing 1=Manufacturing routing
COMMON_ASSEMBLY_ITEM_ID	Inventory item identifier of common assembly
COMMON_ROUTING_SEQUENCE_ID	Routing identifier of common routing
ROUTING_COMMENT	Specific comment about routing
COMPLETION_SUBINVENTORY	Destination subinventory for assembly
COMPLETION_LOCATOR_ID	Destination location for assembly
ORGANIZATION_ID	Organization identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ALTERNATE_ROUTING_DESIGNATOR	Alternate designator code
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
LINE_ID	Unique identifier from WIP Lines used in Flow Manufacturing
CFM_ROUTING_FLAG	Continous flow or traditional routing
MIXED_MODEL_MAP_FLAG	Use this routing in Mixed Model Map calculations
PRIORITY	For information only
TOTAL_PRODUCT_CYCLE_TIME	Total time that an assembly takes along the primary path in the operation network calculated by Flow Manufacturing
CTP_FLAG	Flag indicating capacity must be checked when item is ordered
PROJECT_ID	Project identifier for Project Manufacturing
TASK_ID	Task identifier for Project Manufacturing
PENDING_FROM_ECN	Pending from ECN
ORIGINAL_SYSTEM_REFERENCE	Original system reference
SERIALIZATION_START_OP	Serialization starting operation sequence number for standard routings
ROUTING_SEQUENCE_ID	Routing unique identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Bills of Material - BOM_OP_SEQUENCES_ARCHIVE	Routing operations
Column Name	Descritpion
STANDARD_OPERATION_ID	Standard operation unique identifier
ROUTING_SEQUENCE_ID	Routing unique identifier
DEPARTMENT_ID	Department unique identifier
OPERATION_LEAD_TIME_PERCENT	Indicates the amount of overlap its lead time has with the parent's lead time
MINIMUM_TRANSFER_QUANTITY	Minimum operation transfer quantity
COUNT_POINT_TYPE	Count point
OPERATION_DESCRIPTION	Description of operation
EFFECTIVITY_DATE	Date operation is effective
OPERATION_SEQ_NUM	Operation sequence number
DISABLE_DATE	Date operation is no longer effective - effectivity lasts until the end of the disable date
BACKFLUSH_FLAG	Indicates whether operation requires backflushing
OPTION_DEPENDENT_FLAG	Indicates whether to use this operation in all configuration routings, even if no components of the configuration are used in this operation
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
OPERATION_SEQUENCE_ID	Routing operation unique identifier
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
OPERATION_TYPE	Process, line operation, or event
REFERENCE_FLAG	If Standard Operation is referenced, then the operation can not be updated.
PROCESS_OP_SEQ_ID	Operation sequence id of parent process (applies only to events)
LINE_OP_SEQ_ID	Operation sequence id of the parent line operation Only applies to events
YIELD	Process yield at this operation
CUMULATIVE_YIELD	Cumulative process yield from begining of routing to this operation
REVERSE_CUMULATIVE_YIELD	Cumulative process yield from end of routing to comparable operation
LABOR_TIME_CALC	System calculated run time attributable to labor
MACHINE_TIME_CALC	System calculated run time attributable to machines
TOTAL_TIME_CALC	System calculated run time attributable to both labor and machines
LABOR_TIME_USER	User calculated run time attributable to labor
MACHINE_TIME_USER	User calculated run time attributable to machines
TOTAL_TIME_USER	User calculated run time attributable to both labor and machines
NET_PLANNING_PERCENT	Cumulative planning percents derived from the operation network
X_COORDINATE	X coordinate of the operation
Y_COORDINATE	Y coordinate of the operation
INCLUDE_IN_ROLLUP	Indicates whether operation yield is to be considered in cost rollup
OPERATION_YIELD_ENABLED	Indicates whether operation yield is to be considered during costing.
CREATION_DATE	Standard Who column
OLD_OPERATION_SEQUENCE_ID	Old operation sequence Id
ACD_TYPE	ACD type
REVISED_ITEM_SEQUENCE_ID	Revised Item Sequence Id
ORIGINAL_SYSTEM_REFERENCE	Original System Reference
CHANGE_NOTICE	Engineering change notice code
IMPLEMENTATION_DATE	Date on which engineering change will be implemented
ECO_FOR_PRODUCTION	Indicates if this operation on an Engineering Change Order is only for WIP jobs
SHUTDOWN_TYPE	Shutdown type
ACTUAL_IPK	Actual In-Process Kanbans
CRITICAL_TO_QUALITY	Critical To Quality
VALUE_ADDED	Value Added
MACHINE_PROCESS_EFFICIENCY	Used by flow manufacturing for process efficiency calculations
LABOR_PROCESS_EFFICIENCY	Used by flow manufacturing for process efficiency calculations
TOTAL_PROCESS_EFFICIENCY	Used by flow manufacturing for process efficiency calculations
LONG_DESCRIPTION	Used by EAM routings
CREATED_BY	Standard Who column
CONFIG_ROUTING_ID	This column denotes the corresponding model routing that this configuration routing operation is derived from
MODEL_OP_SEQ_ID	This column denotes the corresponding model routing operation that this configuration routing operation is derived from
LOWEST_ACCEPTABLE_YIELD	Lowest Acceptable Yield
USE_ORG_SETTINGS	Use Org Settings
QUEUE_MANDATORY_FLAG	Queue Mandatory Flag
RUN_MANDATORY_FLAG	Run Mandatory Flag
TO_MOVE_MANDATORY_FLAG	To Move Mandatory Flag
SHOW_NEXT_OP_BY_DEFAULT	Show Next Op By Default
SHOW_SCRAP_CODE	Show Scrap Code
SHOW_LOT_ATTRIB	Show Lot Attrib
TRACK_MULTIPLE_RES_USAGE_DATES	Track Multiple Res Usage Dates
LAST_UPDATE_LOGIN	Standard Who column

Bills of Material - BOM_MIXED_MODEL_MAP_PROCESSES	Processes or line operations and summary information for mixed model maps
Column Name	Descritpion
MACHINE_WEIGHTED_TIME	Weighted machine time for a process
LABOR_WEIGHTED_TIME	Weighted labor time for a process
TOTAL_WEIGHTED_TIME	Weighted total time for a process
MACHINES_NEEDED	Number of machines needed in a process
MACHINES_ASSIGNED	Number of machines assigned to a process
MACHINES_NEEDED_DELTA	The difference between the Machines Needed for the current map and the baseline map
MIXED_MODEL_MAP_ID	Mixed Model Map identifier
LABOR_NEEDED	Number of labor resources needed
LABOR_ASSIGNED	Number of labor resources assigned
LABOR_NEEDED_DELTA	The change between the labor needed for the current map and the baseline map
TAKT_TIME	Calculated time for a process or line operation
TAKT_TIME_FOR_ASSIGNED	Time calculated from assigned machines or labor for a process or line operation
IN_PROCESS_KANBAN	IPKs needed for a process
IN_PROCESS_KANBAN_DELTA	The change between the IPKs needed in the current map and the baseline map
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
GROUP_NUMBER	Processes in a Mixed Model Map are grouped together in sets of 5. This group number represents in which set the process exists.
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
SEQUENCE_ID	Specifies whether process is displayed in position 1, 2, 3, 4 or 5 within the group
OPERATION_CODE	Either the Process or Line Op name

Bills of Material - BOM_MIXED_MODEL_MAP_CELLS	Matrix cell values for mixed model maps
Column Name	Descritpion
DEMAND	Amount of demand for the product
MACHINE_TIME	Amount of machine time used in a process
LABOR_TIME	Amount of labor time used in a process
TOTAL_TIME	Amount of total time used in a process
PROCESS_VOLUME	Process volume in a process
MIXED_MODEL_MAP_ID	Mixed Model Map identifier
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
GROUP_NUMBER	Processes in a Mixed Model Map are grouped together in sets of 5. This column shows in which set the process exists.
SEQUENCE_ID	Specifies whether process is displayed in position 1, 2, 3, 4 or 5 within the group
PRODUCT_ITEM_ID	Product item identifier

Bills of Material - BOM_REFERENCE_DESGS_ARCHIVE	Component reference designators
Column Name	Descritpion
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REF_DESIGNATOR_COMMENT	Reference designator comment
CHANGE_NOTICE	Engineering change order number
COMPONENT_SEQUENCE_ID	Component unique identifier
ACD_TYPE	Add or delete code from an engineering change order
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from
COMMON_COMPONENT_SEQUENCE_ID	Common component sequence id
COMPONENT_REFERENCE_DESIGNATOR	Component reference designator
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Bills of Material - BOM_SUBSTITUTE_COMPS_ARCHIVE	Substitute components
Column Name	Descritpion
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SUBSTITUTE_ITEM_QUANTITY	Substitute component quantity
COMPONENT_SEQUENCE_ID	Component unique identifier
ACD_TYPE	Type to indicate add or delete on an engineering change order
CHANGE_NOTICE	Engineering change order number
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
SUBSTITUTE_COMPONENT_ID	Substitute component inventory item
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from
ENFORCE_INT_REQUIREMENTS	Enforce Integer Requirements
LAST_UPDATE_DATE	Standard Who column
COMMON_COMPONENT_SEQUENCE_ID	Common component sequence id
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Bills of Material - BOM_RTG_ITEM_REVISIONS_ARCHIVE	Routing revisions archive
Column Name	Descritpion
INVENTORY_ITEM_ID	Inventory item identifier
CHANGE_NOTICE	Engineering change order number
ECN_INITIATION_DATE	ECO initiation date
IMPLEMENTATION_DATE	ECO implementation date
IMPLEMENTED_SERIAL_NUMBER	(no longer used)
EFFECTIVITY_DATE	Revision effectivity date
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
PROCESS_REVISION	Routing revision code
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column
REVISED_ITEM_SEQUENCE_ID	Revised item sequence identifier
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Bills of Material - BOM_OPERATION_NETWORKS	Routing operation networks
Column Name	Descritpion
FROM_OP_SEQ_ID	From routing operation identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
TO_OP_SEQ_ID	To routing operation identifier
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
TRANSITION_TYPE	Primary, Alternate or Rework connection
ORIGINAL_SYSTEM_REFERENCE	Original system reference
PLANNING_PCT	Planning Percentage
REQUEST_ID
PROGRAM_APPLICATION_ID
EFFECTIVITY_DATE	Effective Date
PROGRAM_ID
PROGRAM_UPDATE_DATE
DISABLE_DATE	Disable Date
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Bills of Material - BOM_ITEM_BACKFLUSH_SUBINV	Not currently used - to be used in future releases
Column Name	Descritpion
ORGANIZATION_ID	Organization identifier
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
INVENTORY_ITEM_ID	Inventory item identifier
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
LOCATION_TYPE	Physical location type code
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LOCATION_ID	Location code
SUBINVENTORY_NAME	Subinventory name
LOCATOR_ID	Stock locator identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Bills of Material - ACTIVITY_COSTS
Column Name	Descritpion
ACTVTYCOST_ID

Bills of Material - BOM_FORM_QUERY	Retrofitted
Column Name	Descritpion
QUERY_ID	- Retrofitted
DATE4	- Retrofitted
DATE5	- Retrofitted
DATE6	- Retrofitted
DATE7	- Retrofitted
DATE8	- Retrofitted
NUMBER1	- Retrofitted
NUMBER2	- Retrofitted
NUMBER3	- Retrofitted
NUMBER4	- Retrofitted
NUMBER5	- Retrofitted
LAST_UPDATE_DATE	- Retrofitted
NUMBER6	- Retrofitted
NUMBER7	- Retrofitted
NUMBER8	- Retrofitted
NUMBER9	- Retrofitted
NUMBER10	- Retrofitted
NUMBER11	- Retrofitted
NUMBER12	- Retrofitted
NUMBER13	- Retrofitted
NUMBER14	- Retrofitted
NUMBER15	- Retrofitted
LAST_UPDATED_BY	- Retrofitted
REQUEST_ID	- Retrofitted
CHAR1	- Retrofitted
CHAR2	- Retrofitted
CHAR3	- Retrofitted
CHAR4	- Retrofitted
CHAR5	- Retrofitted
CHAR6	- Retrofitted
CHAR7	- Retrofitted
CHAR8	- Retrofitted
CHAR9	- Retrofitted
CREATION_DATE	- Retrofitted
PROGRAM_UPDATE_DATE	- Retrofitted
PROGRAM_APPLICATION_ID	- Retrofitted
PROGRAM_ID	- Retrofitted
CREATED_BY	- Retrofitted
LAST_UPDATE_LOGIN	- Retrofitted
DATE1	- Retrofitted
DATE2	- Retrofitted
DATE3	- Retrofitted

Bills of Material - BOM_RESOURCE_FLEX_FENCES	Tolerance percentage by which the present capacity of a particular resource or a line can be increased
Column Name	Descritpion
DEPARTMENT_ID	Department unique identifier
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
RESOURCE_ID	Unique resource identifier
FENCE_DAYS	Days included in time fence
TOLERANCE_PERCENTAGE	Percentage of tolerance beyond time fence
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LAST_UPDATE_DATE	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column

Bills of Material - BOM_RESOURCE_EMPLOYEES	Bom employee resources
Column Name	Descritpion
RESOURCE_ID	Resource unique identifier
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PERSON_ID	Person identifier
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
INSTANCE_ID	Instance Id
EFFECTIVE_START_DATE	Effective Start Date
EFFECTIVE_END_DATE	Effective End Date
INTERLEAVE	Interleave
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Bills of Material - BOM_RESOURCE_EQUIPMENTS	Bom equipment resources
Column Name	Descritpion
RESOURCE_ID	Resource unique identifier
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
INSTANCE_ID	Instance identifier
INVENTORY_ITEM_ID	Inventory item identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column

Bills of Material - BOM_CTO_ORDER_LINES	bom cto order lines
Column Name	Descritpion
ATO_LINE_ID	ATO_LINE_ID
LINK_TO_LINE_ID	LINK_TO_LINE_ID
ORDERED_QUANTITY	ORDERED_QUANTITY
ORDER_QUANTITY_UOM	ORDER_QUANTITY_UOM
PARENT_ATO_LINE_ID	PARENT_ATO_LINE_ID
PERFORM_MATCH	PERFORM_MATCH
PLAN_LEVEL	PLAN_LEVEL
SCHEDULE_SHIP_DATE	SCHEDULE_SHIP_DATE
SHIP_FROM_ORG_ID	SHIP_FROM_ORG_ID
TOP_MODEL_LINE_ID	TOP_MODEL_LINE_ID
WIP_SUPPLY_TYPE	WIP_SUPPLY_TYPE
BATCH_ID	BATCH_ID
HEADER_ID	HEADER_ID
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
BOM_ITEM_TYPE	BOM_ITEM_TYPE
REUSE_CONFIG	Reuse Config Flag
OPTION_SPECIFIC	Option Specific Flag
QTY_PER_PARENT_MODEL	Qty Per parent model
CONFIG_CREATION	config creation attribute
COMPONENT_CODE	COMPONENT_CODE
COMPONENT_SEQUENCE_ID	COMPONENT_SEQUENCE_ID
CONFIG_ITEM_ID	CONFIG_ITEM_ID
INVENTORY_ITEM_ID	INVENTORY_ITEM_ID
ITEM_TYPE_CODE	ITEM_TYPE_CODE
LINE_ID	LINE_ID

Bills of Material - BOM_CTO_SRC_ORGS	BOM_CTO_SRC_ORGS
Column Name	Descritpion
CONFIG_ITEM_ID	CONFIG_ITEM_ID
RCV_ORG_ID	RCV_ORG_ID
TOP_MODEL_LINE_ID	TOP_MODEL_LINE_ID
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
COST_ROLLUP	COST_ROLLUP
LAST_UPDATE_DATE	Standard Who column
CREATE_BOM	CREATE_BOM
CREATE_SRC_RULES	CREATE_SRC_RULES
LINE_ID	LINE_ID
MODEL_ITEM_ID	MODEL_ITEM_ID
ORGANIZATION_ID	ORGANIZATION_ID
ORGANIZATION_TYPE	ORGANIZATION_TYPE
RANK	RANK

Bills of Material - BOM_SUB_OPERATION_RESOURCES	Substitue Resources
Column Name	Descritpion
SUBSTITUTE_GROUP_NUM	Substitue group number
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
RESOURCE_ID	Resource unique identifier
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
SCHEDULE_SEQ_NUM	Scheduling sequence number
PRINCIPLE_FLAG	Principal Flag
SETUP_ID	Setup Type unique identifier
CHANGE_NOTICE	Change Notice
ACD_TYPE	Acd Type
ORIGINAL_SYSTEM_REFERENCE	Original System Reference
REPLACEMENT_GROUP_NUM	Substitute group number
ACTIVITY_ID	Activity identifier
STANDARD_RATE_FLAG	Use standard rate for shopfloor transactions
ASSIGNED_UNITS	Resource units assigned
USAGE_RATE_OR_AMOUNT	Resource usage rate
OPERATION_SEQUENCE_ID	Operation unique identifier
USAGE_RATE_OR_AMOUNT_INVERSE	Resource usage rate inverse
BASIS_TYPE	Basis type identifier
SCHEDULE_FLAG	Schedule the resource
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RESOURCE_OFFSET_PERCENT	Resource offset percent from the start of the routing
AUTOCHARGE_TYPE	Autocharge type for shopfloor moves

Bills of Material - BOM_OPERATION_RESOURCES_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
USAGE_RATE_OR_AMOUNT	Resource usage rate
OPERATION_SEQUENCE_ID	Sequence indicator
USAGE_RATE_OR_AMOUNT_INVERSE	Inverse resource usage rate
RESOURCE_SEQ_NUM	Resource Sequence Number
SET_OF_BOOKS_ID	Set of Books Identifier

Bills of Material - BOM_RESOURCES_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
RESOURCE_ID	Resource Identifier
UNIT_OF_MEASURE	Unit Of Measure
SET_OF_BOOKS_ID	Set of Books Identifier

Bills of Material - BOM_SUB_OPERATION_RESOURCE_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
USAGE_RATE_OR_AMOUNT	Resource Rate Amount
OPERATION_SEQUENCE_ID	Operation Sequence Identifier
USAGE_RATE_OR_AMOUNT_INVERSE	Inverse Resource Rate Amount
RESOURCE_SEQ_NUM	Resource Sequence Number
SET_OF_BOOKS_ID	Set Of Books Identifier

Bills of Material - BOM_CTO_ORDER_DEMAND	BCOD
Column Name	Descritpion
OE_LINE_ID	OE_Order_lines_all line identifier
ATO_LINE_ID	ATO_LINE_ID
INVENTORY_ITEM_ID	INVENTORY Item Identifier
ORGANIZATION_ID	ORGANIZATION_ID
REQUIRED_DATE	REQUIRED_DATE
REQUIRED_QTY	REQUIRED_QTY
ORDER_QUANTITY_UOM	ORDER_QUANTITY_UOM
HEADER_ID	HEADER_ID
PARENT_DEMAND_TYPE	PARENT_DEMAND_TYPE
BCOD_LINE_ID	Bom cto order demand Line Identifier
FORECAST_VISIBLE	FORECAST VISIBLE Flag
DEMAND_VISIBLE	DEMAND_VISIBLE Flag
CREATED_BY	CREATED_BY
LAST_UPDATED_BY	LAST_UPDATE_BY
LAST_UPDATED_DATE	LAST_UPDATED_DATE
LAST_UPDATE_LOGIN	LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID	PROGRAM_APPLICATION_ID
PROGRAM_UPDATE_DATE	PROGRAM_UPDATE_DATE

Bills of Material - BOM_SETUP_TYPES	Setup Types
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ORGANIZATION_ID	Organization Identifier
SETUP_ID	Setup Type unique identifier
SETUP_CODE	Setup code
DESCRIPTION	Description
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Bills of Material - BOM_SETUP_TRANSITIONS	Setup Transitions
Column Name	Descritpion
RESOURCE_ID	Resource unique identifier
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
FROM_SETUP_ID	Setup Type unique identifier
TO_SETUP_ID	Setup Type unique identifier
TRANSITION_TIME	Transition Time
TRANSITION_UOM	Transition UOM
TRANSITION_PENALTY	Transition Penalty
OPERATION_ID	Operation identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Bills of Material - BOM_RESOURCE_SETUPS	Resource Setups
Column Name	Descritpion
RESOURCE_ID	Resource unique identifier
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ORGANIZATION_ID	Organization identifier
SETUP_ID	Setup Type unique identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

Bills of Material - BOM_RES_INSTANCE_CHANGES	Resource Instances modifications
Column Name	Descritpion
DEPARTMENT_ID	Department unique identifier
TO_TIME	Capacity exception to time
INSTANCE_ID	Instance identifier of the department resource
SERIAL_NUMBER	Serial number of the equipment type resource
ACTION_TYPE	Type of capacity modification
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
RESOURCE_ID	Resource unique identifier
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
SHIFT_NUM	Shift number
ATTRIBUTE15	Descriptive flexfield segment
CAPACITY_CHANGE	Capacity change
REASON_CODE	Reason code
DOWNTIME_SOURCE_CODE	Code to identify source of the maintenance downtime
WIP_ENTITY_ID	Unique identifier of Maintenance Work Order
OPERATION_SEQ_NUM	Operation Sequence Number of the maintenance work order
MAINTENANCE_ORGANIZATION_ID	Organization performing maintenance work order
DOWNTIME_GROUP_ID	Unique batch identifier of the Load Production Equipment Downtime Process
DOWNTIME_NEGOTIABLE_FLAG	Downtime negotiable flag
SIMULATION_SET	Simulation set identifier
FROM_DATE	Capacity exception from date
FROM_TIME	Capacity exception from time
TO_DATE	Capacity exception to date

Bills of Material - BOM_DEPT_RES_INSTANCES	Department Resource Instances
Column Name	Descritpion
INSTANCE_ID	Instance Identifier
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
DEPARTMENT_ID	Department unique identifier
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
RESOURCE_ID	Resource unique identifier
SERIAL_NUMBER	Serial Number
LAST_UPDATE_DATE	Standard Who column

Bills of Material - BOM_COMPONENT_OPERATIONS	Additional operations for a Bill of Material Component
Column Name	Descritpion
OPERATION_SEQ_NUM	Operation Sequence Number, showing the sequences of process and line operations
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
OPERATION_SEQUENCE_ID	Operation sequence identifier
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
COMMON_COMPONENT_SEQUENCE_ID	Common Component Sequence Id
REQUEST_ID	Concurrent WHO columns
PROGRAM_APPLICATION_ID	Concurrent WHO columns
PROGRAM_ID	Concurrent WHO columns
PROGRAM_UPDATE_DATE	Concurrent WHO columns
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COMPONENT_SEQUENCE_ID	Component unique identifier
COMP_OPERATION_SEQ_ID	Component operation unique identifier
BILL_SEQUENCE_ID	Bill of material unique identifier
CONSUMING_OPERATION_FLAG	Consuming operation indicator
CONSUMPTION_QUANTITY	Consumption quantity
SUPPLY_SUBINVENTORY	Supply subinventory
SUPPLY_LOCATOR_ID	Supply locator identifier
WIP_SUPPLY_TYPE	WIP supply type code
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment

Bills of Material - BOM_MIXED_MODEL_MAP_RES	Resources information of all the resources at a line operation/process for mixed model maps
Column Name	Descritpion
MIXED_MODEL_MAP_ID	Mixed model map internal identifier
RESOURCE_NEEDED	Resource needed for the operation
RESOURCE_ID	Resource unique identifier
RESOURCE_CODE	Resouce code
ACTIVITY_ID	Activity identifier
ACTIVITY	Activity name
STANDARD_OPERATION_ID	Standard operation unique identifier
OPERATION_CODE	Operation code
ORGANIZATION_ID	Organization identifier
RESOURCE_TYPE	Resource type

Bills of Material - BOM_BILLS_HEADER_TEMP	Bills of material Header Temporary Table
Column Name	Descritpion
TRANSACTION_GROUP_ID	Transaction group identifier
TRANSACTION_ID	Transaction identifier
ASSEMBLY_ITEM_NAME	Concatenated bill item segments
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ORGANIZATION_CODE	Organization code
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ALTERNATE_BOM_CODE	Alternate designator code
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
DELETE_GROUP_NAME	Delete group name
DG_DESCRIPTION	Delete group description
COMMON_ASSEMBLY_ITEM_NAME	Assembly item name of common bill
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from.
COMMON_ORGANIZATION_CODE	Organization code of common bill
ASSEMBLY_TYPE	Assembly type: 1=Manufacturing bill 2=Engineering bill
ASSEMBLY_COMMENT	Specific bill of material comment
TRANSACTION_TYPE	Transaction Type which specifies what oeration is to be performed on a record.
RETURN_STATUS	Return Status

Bills of Material - BOM_INV_COMPONENTS_TEMP	Bill of material components temporary table
Column Name	Descritpion
TRANSACTION_GROUP_ID	Transaction group identifier
ITEM_SEQUENCE_NUMBER	Item sequence within bill of material structure
DISABLE_DATE	Disable date
SUPPLY_SUBINVENTORY	Supply subinventory
LOCATION_NAME	Supply location name
PLANNING_PERCENT	Factor used to multiply component quantity with to obtain planning quantity
REQUIRED_FOR_REVENUE	Flag indicating if component is required for revenue
REQUIRED_TO_SHIP	Flag indicating if component is required to ship
MINIMUM_ALLOWED_QUANTITY	Minimum quantity allowed on an order
MAXIMUM_ALLOWED_QUANTITY	Maximum quantity allowed on an order
WIP_SUPPLY_TYPE	WIP supply type code
QUANTITY_PER_ASSEMBLY	Quantity of component in bill of material
PROJECTED_YIELD	Factor used to multiply component quantity to obtain required component quantity
COMMENTS	Component remarks
QUANTITY_RELATED	Identifier to indicate if this component has quantity related reference designators
TRANSACTION_ID	Transaction identifier
SO_BASIS	Quantity basis used by Oracle Order Management to determine how many units of component to put on an order
OPTIONAL	Flag indicating if component is optional in bill
MUTUALLY_EXCLUSIVE	Flag indicating if one or more children of component can be picked when taking an order
INCLUDE_IN_COST_ROLLUP	Flag indicating if this component is to be used when rolling up costs
CHECK_ATP	Flag indicating if ATP check is required
SHIPPING_ALLOWED	Flag indicating if component is allowed to ship
INCLUDE_ON_SHIP_DOCS	Flag indicating if component is displayed on shipping documents
NEW_EFFECTIVITY_DATE	Updated value for the effectivity_date
NEW_OPERATION_SEQUENCE_NUMBER	Updated value for the operation_seq_num
FROM_END_ITEM_UNIT_NUMBER	From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER	To End Item Unit Number
TRANSACTION_TYPE	Type of action: CREATE, UPDATE or DELETE
RETURN_STATUS	Return Status
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ASSEMBLY_ITEM_NAME	Concatenated bill item segments
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ORGANIZATION_CODE	Organization code
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
DELETE_GROUP_NAME	Delete group name
DG_DESCRIPTION	Delete group description
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from.
ALTERNATE_BOM_CODE	Alternate designator code
START_EFFECTIVE_DATE	Effective date
COMPONENT_ITEM_NAME	Concatenated component item segments
OPERATION_SEQUENCE_NUMBER	Operation sequence number

Bills of Material - BOM_COMP_OPTCLASS_TEMP	Bill of material components interface data
Column Name	Descritpion
TRANSACTION_GROUP_ID	Transaction group identifier
ITEM_SEQUENCE_NUMBER	Item sequence within bill of material structure
DISABLE_DATE	Disable date
SUPPLY_SUBINVENTORY	Supply subinventory
LOCATION_NAME	Supply location name
PLANNING_PERCENT	Factor used to multiply component quantity with to obtain planning quantity
REQUIRED_FOR_REVENUE	Flag indicating if component is required for revenue
REQUIRED_TO_SHIP	Flag indicating if component is required to ship
MINIMUM_ALLOWED_QUANTITY	Minimum quantity allowed on an order
MAXIMUM_ALLOWED_QUANTITY	Maximum quantity allowed on an order
WIP_SUPPLY_TYPE	WIP supply type code
QUANTITY_PER_ASSEMBLY	Quantity of component in bill of material
PROJECTED_YIELD	Factor used to multiply component quantity to obtain required component quantity
COMMENTS	Component remarks
QUANTITY_RELATED	Identifier to indicate if this component has quantity related reference designators
TRANSACTION_ID	Transaction identifier
SO_BASIS	Quantity basis used by Oracle Order Management to determine how many units of component to put on an order
OPTIONAL	Flag indicating if component is optional in bill
MUTUALLY_EXCLUSIVE	Flag indicating if one or more children of component can be picked when taking an order
INCLUDE_IN_COST_ROLLUP	Flag indicating if this component is to be used when rolling up costs
CHECK_ATP	Flag indicating if ATP check is required
SHIPPING_ALLOWED	Flag indicating if component is allowed to ship
INCLUDE_ON_SHIP_DOCS	Flag indicating if component is displayed on shipping documents
NEW_EFFECTIVITY_DATE	Updated value for the effectivity_date
NEW_OPERATION_SEQUENCE_NUMBER	Updated value for the operation_seq_num
FROM_END_ITEM_UNIT_NUMBER	From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER	To End Item Unit Number
TRANSACTION_TYPE	Type of action: CREATE, UPDATE or DELETE
RETURN_STATUS	Return Status
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ASSEMBLY_ITEM_NAME	Concatenated bill item segments
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ORGANIZATION_CODE	Organization code
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
DELETE_GROUP_NAME	Delete group name
DG_DESCRIPTION	Delete group description
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from.
ALTERNATE_BOM_CODE	Alternate designator code
START_EFFECTIVE_DATE	Effective date
COMPONENT_ITEM_NAME	Concatenated component item segments
OPERATION_SEQUENCE_NUMBER	Operation sequence number

Bills of Material - BOM_COMP_OPTIONS_TEMP	Bill of material components interface data
Column Name	Descritpion
TRANSACTION_GROUP_ID	Transaction group identifier
ITEM_SEQUENCE_NUMBER	Item sequence within bill of material structure
DISABLE_DATE	Disable date
SUPPLY_SUBINVENTORY	Supply subinventory
LOCATION_NAME	Supply location name
PLANNING_PERCENT	Factor used to multiply component quantity with to obtain planning quantity
REQUIRED_FOR_REVENUE	Flag indicating if component is required for revenue
REQUIRED_TO_SHIP	Flag indicating if component is required to ship
MINIMUM_ALLOWED_QUANTITY	Minimum quantity allowed on an order
MAXIMUM_ALLOWED_QUANTITY	Maximum quantity allowed on an order
WIP_SUPPLY_TYPE	WIP supply type code
QUANTITY_PER_ASSEMBLY	Quantity of component in bill of material
PROJECTED_YIELD	Factor used to multiply component quantity to obtain required component quantity
COMMENTS	Component remarks
QUANTITY_RELATED	Identifier to indicate if this component has quantity related reference designators
TRANSACTION_ID	Transaction identifier
SO_BASIS	Quantity basis used by Oracle Order Management to determine how many units of component to put on an order
OPTIONAL	Flag indicating if component is optional in bill
MUTUALLY_EXCLUSIVE	Flag indicating if one or more children of component can be picked when taking an order
INCLUDE_IN_COST_ROLLUP	Flag indicating if this component is to be used when rolling up costs
CHECK_ATP	Flag indicating if ATP check is required
SHIPPING_ALLOWED	Flag indicating if component is allowed to ship
INCLUDE_ON_SHIP_DOCS	Flag indicating if component is displayed on shipping documents
NEW_EFFECTIVITY_DATE	Updated value for the effectivity_date
NEW_OPERATION_SEQUENCE_NUMBER	Updated value for the operation_seq_num
FROM_END_ITEM_UNIT_NUMBER	From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER	To End Item Unit Number
TRANSACTION_TYPE	Type of action: CREATE, UPDATE or DELETE
RETURN_STATUS	Return Status
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ASSEMBLY_ITEM_NAME	Concatenated bill item segments
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ORGANIZATION_CODE	Organization code
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
DELETE_GROUP_NAME	Delete group name
DG_DESCRIPTION	Delete group description
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from.
ALTERNATE_BOM_CODE	Alternate designator code
START_EFFECTIVE_DATE	Effective date
COMPONENT_ITEM_NAME	Concatenated component item segments
OPERATION_SEQUENCE_NUMBER	Operation sequence number

Bills of Material - BOM_RTGHEADER_TEMP	Used in XML Routing Header import process
Column Name	Descritpion
ASSEMBLY_ITEM_NAME	Assembly item name
CFM_ROUTING_FLAG	CFM routing flag
MIXED_MODEL_MAP_FLAG	Mixed model map flag
PRIORITY	Priority
TOTAL_CYCLE_TIME	Total cycle time
CTP_FLAG	CTP flag
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ORGANIZATION_CODE	Organization code
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ALTERNATE_ROUTING_CODE	Alternate routing code
ATTRIBUTE15	Descriptive flexfield segment
RETURN_STATUS	Return status
ORIGINAL_SYSTEM_REFERENCE	Original system reference
TRANSACTION_TYPE	Transaction type
DELETE_GROUP_NAME	Delete group name
DG_DESCRIPTION	Delete group description
REVISION_NAME	Revision name
REVISION_START_EFF_DATE	Revision start effective date
REVISION_ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
REVISION_ATTRIBUTE1	Descriptive flexfield segment
ENG_ROUTING_FLAG	Engineering routing flag
REVISION_ATTRIBUTE2	Descriptive flexfield segment
REVISION_ATTRIBUTE3	Descriptive flexfield segment
REVISION_ATTRIBUTE4	Descriptive flexfield segment
REVISION_ATTRIBUTE5	Descriptive flexfield segment
REVISION_ATTRIBUTE6	Descriptive flexfield segment
REVISION_ATTRIBUTE7	Descriptive flexfield segment
REVISION_ATTRIBUTE8	Descriptive flexfield segment
REVISION_ATTRIBUTE9	Descriptive flexfield segment
REVISION_ATTRIBUTE10	Descriptive flexfield segment
REVISION_ATTRIBUTE11	Descriptive flexfield segment
COMMON_ASSEMBLY_ITEM_NAME	Common assembly item name
REVISION_ATTRIBUTE12	Descriptive flexfield segment
REVISION_ATTRIBUTE13	Descriptive flexfield segment
REVISION_ATTRIBUTE14	Descriptive flexfield segment
REVISION_ATTRIBUTE15	Descriptive flexfield segment
REVISION_RETURN_STATUS	Revision return status
REVISION_TRANSACTION_TYPE	Revision transaction type
REVISION_ORIG_SYS_REFERENCE	Revision original system reference
TRANSACTION_ID	Transaction identifier
TRANSACTION_GROUP_ID	Transaction group identifier
ROUTING_COMMENT	Routing comment
COMPLETION_SUBINVENTORY	Completion subinventory
COMPLETION_LOCATION_NAME	Completion location name
LINE_CODE	Line code

Bills of Material - BOM_RTG_NETWORK_TEMP	Used in XML Routing Network import Process
Column Name	Descritpion
ASSEMBLY_ITEM_NAME	Inventory item name of manufactured assembly
NEW_TO_OP_SEQ_NUMBER	New to routing operation sequence number
TO_START_EFFECTIVE_DATE	To routing operation sequence effective start date
NEW_TO_START_EFFECTIVE_DATE	New to routing operation sequence effective start date
CONNECTION_TYPE	Connection type
PLANNING_PERCENT	Planning percentage
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ORGANIZATION_CODE	Organization code
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ALTERNATE_ROUTING_CODE	Alternate routing code
ATTRIBUTE15	Descriptive flexfield segment
RETURN_STATUS	Return status
ORIGINAL_SYSTEM_REFERENCE	Original system reference
TRANSACTION_TYPE	Transaction type
TRANSACTION_ID	Transaction identifier
TRANSACTION_GROUP_ID	Transaction group identifier
FROM_X_COORDINATE	X-coordinate of from operation
FROM_Y_COORDINATE	Y-coordinate of from operation
TO_X_COORDINATE	X-coordinate of to operation
TO_Y_COORDINATE	Y-coordinate of to operation
OPERATION_TYPE	Operation type
FROM_OP_SEQ_NUMBER	From routing operation sequence number
NEW_FROM_OP_SEQ_NUMBER	New from routing operation sequence number
FROM_START_EFFECTIVE_DATE	From routing operation sequence effective start date
NEW_FROM_START_EFFECTIVE_DATE	New from routing operation sequence effective start date
TO_OP_SEQ_NUMBER	To routing operation sequence number

Bills of Material - BOM_RTG_OPERATION_TEMP	Used in XML Routing Import Process
Column Name	Descritpion
ASSEMBLY_ITEM_NAME	Assembly item name
DEPARTMENT_CODE	Department code
OP_LEAD_TIME_PERCENT	Lead time percent
MINIMUM_TRANSFER_QUANTITY	Minimum transfer quantity
COUNT_POINT_TYPE	Count point type
OPERATION_DESCRIPTION	Operation description
DISABLE_DATE	Disable date
BACKFLUSH_FLAG	Backflush flag
OPTION_DEPENDENT_FLAG	Option dependent flag
REFERENCE_FLAG	Reference flag
PROCESS_SEQ_NUMBER	Process sequence number
ORGANIZATION_CODE	Organization code
PROCESS_CODE	Process code
LINE_OP_SEQ_NUMBER	Line operation sequence number
LINE_OP_CODE	Line operation code
YIELD	Process yield at this operation
CUMULATIVE_YIELD	Cumulative process yield from begining of routing to this operation
REVERSE_CUM_YIELD	Cumulative process yield from end of routing to comparable operation
USER_LABOR_TIME	User calculated run time attributable to labor
USER_MACHINE_TIME	User calculated run time attributable to machines
NET_PLANNING_PERCENT	Cumulative planning percents derived from the operation network
INCLUDE_IN_ROLLUP	Indicates whether operation yield is to be considered in cost rollup
ALTERNATE_ROUTING_CODE	Alternate routing code
OP_YIELD_ENABLED_FLAG	Indicates whether operation yield is to be considered during costing.
SHUTDOWN_TYPE	Shutdown type
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
OPERATION_SEQUENCE_NUMBER	Operation sequence number
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
RETURN_STATUS	Return status
ORIGINAL_SYSTEM_REFERENCE	Original system reference
OPERATION_TYPE	Operation type
TRANSACTION_TYPE	Transaction type
DELETE_GROUP_NAME	Delete group name
DG_DESCRIPTION	Delete group description
TRANSACTION_ID	Transaction identifier
TRANSACTION_GROUP_ID	Transaction group identifier
START_EFFECTIVE_DATE	Effective start date
NEW_OPERATION_SEQUENCE_NUMBER	New operation sequence number
NEW_START_EFFECTIVE_DATE	New effective start date
STANDARD_OPERATION_CODE	Standard operation code

Bills of Material - BOM_RTG_RESOURCE_TEMP	Used in XML Routing Resource Import Process
Column Name	Descritpion
ASSEMBLY_ITEM_NAME	Assembly item name
STANDARD_RATE_FLAG	Standard rate flag
ASSIGNED_UNITS	Assigned units
USAGE_RATE_OR_AMOUNT	Usage rate or amount
USAGE_RATE_OR_AMOUNT_INVERSE	Inverse of usage rate or amount
BASIS_TYPE	Basis type
SCHEDULE_FLAG	Schedule flag
RESOURCE_OFFSET_PERCENT	Resource offset percent
AUTOCHARGE_TYPE	Autocharge type
SCHEDULE_SEQUENCE_NUMBER	Schedule sequence number
PRINCIPLE_FLAG	Principal flag
ORGANIZATION_CODE	Organization code
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ALTERNATE_ROUTING_CODE	Alternate routing code
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
RETURN_STATUS	Return status
ORIGINAL_SYSTEM_REFERENCE	Original system reference
TRANSACTION_TYPE	Transaction type
SETUP_TYPE	Setup Type
OPERATION_SEQUENCE_NUMBER	Operation sequence number
TRANSACTION_ID	Transaction identifier
TRANSACTION_GROUP_ID	Transaction group identifier
OPERATION_TYPE	Operation type
OP_START_EFFECTIVE_DATE	Operation effective start date
RESOURCE_SEQUENCE_NUMBER	Resource sequence number
RESOURCE_CODE	Resource code
ACTIVITY	Activity

Bills of Material - BOM_RTG_SUB_RESOURCE_TEMP	Used in XML Routing substitute resource import process
Column Name	Descritpion
ASSEMBLY_ITEM_NAME	Assembly item name
REPLACEMENT_GROUP_NUMBER	Replacement group number
ACTIVITY	Activity
STANDARD_RATE_FLAG	Standard rate flag
ASSIGNED_UNITS	Assigned units
USAGE_RATE_OR_AMOUNT	Usage rate or amount
USAGE_RATE_OR_AMOUNT_INVERSE	Inverse of usage rate or amount
BASIS_TYPE	Basis type
SCHEDULE_FLAG	Schedule flag
RESOURCE_OFFSET_PERCENT	Resource offset percent
AUTOCHARGE_TYPE	Autocharge type
ORGANIZATION_CODE	Organization code
PRINCIPLE_FLAG	Principal flag
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ALTERNATE_ROUTING_CODE	Alternate routing code
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
RETURN_STATUS	Return status
ORIGINAL_SYSTEM_REFERENCE	Original system reference
TRANSACTION_TYPE	Transaction type
OPERATION_SEQUENCE_NUMBER	Operation sequence number
SETUP_TYPE	Setup type
TRANSACTION_ID	Transaction identifier
TRANSACTION_GROUP_ID	Transaction group identifier
OPERATION_TYPE	Operation type
OP_START_EFFECTIVE_DATE	Operation effective start date
SUB_RESOURCE_CODE	Substitute resource code
NEW_SUB_RESOURCE_CODE	New substitute resource code
SCHEDULE_SEQUENCE_NUMBER	Schedule sequence number

Bills of Material - BOM_EAM_DEPT_APPROVERS	Department Approvers
Column Name	Descritpion
DEPT_ID	Internal identifier of the department
ORGANIZATION_ID	Manufacturing Organization
LAST_UPDATE_DATE	Standard WHO Columns
LAST_UPDATED_BY	Standard WHO Columns
CREATION_DATE	Standard WHO Columns
CREATED_BY	Standard WHO Columns
LAST_UPDATE_LOGIN	Standard WHO Columns
RESPONSIBILITY_APPLICATION_ID	Internal identifier of the appliation with which the responsibility is tied to
RESPONSIBILITY_ID	Internal identifier of the responsibility associated with a department
PRIMARY_APPROVER_ID	Primary approver id

Bills of Material - BOM_SUB_OP_RESOURCES_INTERFACE	Substitute resources interface data for routing operations
Column Name	Descritpion
OPERATION_SEQUENCE_ID	Routing operation unique identifier
SUBSTITUTE_GROUP_NUM	Resource sequence number
SCHEDULE_SEQ_NUM	Schedule sequence number
REPLACEMENT_GROUP_NUM	Replacement group number
BATCH_ID	BATCH_ID
RESOURCE_ID	Resource unique identifier
ACTIVITY_ID	Activity identifier
OPERATION_TYPE	Process, Line Operation or Event
STANDARD_RATE_FLAG	Use standard rate for shop floor transactions
ASSIGNED_UNITS	Resource units assigned
USAGE_RATE_OR_AMOUNT	Resource usage rate
USAGE_RATE_OR_AMOUNT_INVERSE	Resource usage rate inverse
BASIS_TYPE	Basis type identifier
SCHEDULE_FLAG	Schedule the resource
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RESOURCE_OFFSET_PERCENT	Resource offset percent from the start of the routing
AUTOCHARGE_TYPE	Autocharge type for shop floor moves
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ASSEMBLY_ITEM_ID	Inventory item identifier of manufactured assembly
ALTERNATE_ROUTING_DESIGNATOR	Alternate designator code
ORGANIZATION_ID	Organization identifier
OPERATION_SEQ_NUM	Operation sequence number
EFFECTIVITY_DATE	Effective date
ROUTING_SEQUENCE_ID	Routing unique identifier
ORGANIZATION_CODE	Abbreviation of organization name
ASSEMBLY_ITEM_NUMBER	Concatenated item segments
SUB_RESOURCE_CODE	Resource name
ACTIVITY	Activity name
TRANSACTION_ID	Row identifier
PROCESS_FLAG	Row status
TRANSACTION_TYPE	Create, Update, or Delete
NEW_SUB_RESOURCE_CODE	New resource sequence number. This column was added to facilitate updates because it's part of the primary key.
PRINCIPLE_FLAG	Principal flag
ORIGINAL_SYSTEM_REFERENCE	Original system reference
SETUP_CODE	Setup type code
ECO_NAME	Used by Engineering Change Order Process
NEW_REVISED_ITEM_REVISION	New revised item revision
NEW_ROUTING_REVISION	New routing revision
ACD_TYPE	ACD type
NEW_REPLACEMENT_GROUP_NUM	The new value the user would want to update the replacement group number with
ENG_CHANGES_IFCE_KEY	Engineering changes IFCE key
NEW_BASIS_TYPE	New basis type

Bills of Material - BOM_OP_NETWORKS_INTERFACE	Operation networks interface data
Column Name	Descritpion
FROM_OP_SEQ_ID	From operation network unique identifier
TO_OP_SEQ_ID	To operation network unique identifier
BATCH_ID	BATCH_ID
TRANSITION_TYPE	Primary, Alternate or Rework connection
PLANNING_PCT	Planning percentage
OPERATION_TYPE	Process, Line Operation or Event
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
FROM_X_COORDINATE	From X coordinate of Operation
TO_X_COORDINATE	To X coordinate of Operation
FROM_Y_COORDINATE	From Y coordinate of Operation
TO_Y_COORDINATE	To Y coordinate of Operation
FROM_OP_SEQ_NUMBER
TO_OP_SEQ_NUMBER	To routing operation identifier
FROM_START_EFFECTIVE_DATE	Effectivity Date for from operation
TO_START_EFFECTIVE_DATE	Effectivity Date for to operation
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
NEW_FROM_OP_SEQ_NUMBER	New From Operation Sequence Number
NEW_TO_OP_SEQ_NUMBER	New To Operation Sequence Number
NEW_FROM_START_EFFECTIVE_DATE	New Effectivity Date for from operation
NEW_TO_START_EFFECTIVE_DATE	New Effectivity Date for from operation
ASSEMBLY_ITEM_ID	Inventory item identifier of manufactured assembly
ALTERNATE_ROUTING_DESIGNATOR	Alternate designator code
ORGANIZATION_ID	Organization identifier
ROUTING_SEQUENCE_ID	Routing unique identifier
ORGANIZATION_CODE	Abbreviation of organization name
ASSEMBLY_ITEM_NUMBER	Concatenated item segments
ORIGINAL_SYSTEM_REFERENCE	Original system reference
TRANSACTION_ID	Row identifier
PROCESS_FLAG	Row status
TRANSACTION_TYPE	Create, Update, or Delete
REQUEST_ID	Request id

Bills of Material - BOM_COMPONENT_OPS_INTERFACE	Additional operations for a Bill of Material Component
Column Name	Descritpion
OPERATION_SEQ_NUM	Operation Sequence Number, showing the sequences of process and line operations
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ADDITIONAL_OPERATION_SEQ_NUM	Operation Sequence Number, showing the sequences of process and line operations
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
NEW_ADDITIONAL_OP_SEQ_NUM	Operation Sequence Number, showing the sequences of process and line operations
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
OPERATION_SEQUENCE_ID	Operation sequence identifier
ASSEMBLY_ITEM_ID	Inventory item identifier of the bill
ASSEMBLY_ITEM_NUMBER	Concatenated item segments of the bill
ALTERNATE_BOM_DESIGNATOR	Alternate designator code
ORGANIZATION_ID	Organization identifier
LAST_UPDATE_DATE	Standard Who column
ORGANIZATION_CODE	Abbreviation of organization name
COMPONENT_ITEM_ID	Component item identifier
COMPONENT_ITEM_NUMBER	Concatenated item segments of the component
EFFECTIVITY_DATE	Effective date
LAST_UPDATED_BY	Standard Who column
FROM_END_ITEM_UNIT_NUMBER	From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER	To End Item Unit Number
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from
TRANSACTION_ID	Row identifier
CREATION_DATE	Standard Who column
PROCESS_FLAG	Row status
TRANSACTION_TYPE	Type of action: CREATE, UPDATE or DELETE
RETURN_STATUS	Return status
CREATED_BY	Standard Who column
BATCH_ID	Batch Identifier for Data Load
COMP_SOURCE_SYSTEM_REFERENCE	Component Source System Item Name
PARENT_SOURCE_SYSTEM_REFERENCE	Parent Source System Item Name
ASSEMBLY_ITEM_REVISION_CODE	Assembly item revision code
LAST_UPDATE_LOGIN	Standard Who column
ASSEMBLY_ITEM_REVISION_ID	Assembly item revision id
REQUEST_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
COMPONENT_SEQUENCE_ID	Component unique identifier
COMP_OPERATION_SEQ_ID	Component operation unique identifier
BILL_SEQUENCE_ID	Bill of material unique identifier
CONSUMING_OPERATION_FLAG	Consuming operation indicator
CONSUMPTION_QUANTITY	Consumption quantity
SUPPLY_SUBINVENTORY	Supply subinventory
SUPPLY_LOCATOR_ID	Supply locator identifier
WIP_SUPPLY_TYPE	WIP supply type code
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment

Bills of Material - BOM_STRUCTURE_TYPES_B	Structure Type master table
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who Column
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
DISABLE_DATE	Disbale date for a structure type
PARENT_STRUCTURE_TYPE_ID	Parent structure type identifier
LAST_UPDATED_BY	Standard Who Column
ENABLE_ATTACHMENTS_FLAG	Flag to decide enabling attachments
ENABLE_UNIMPLEMENTED_BOMS	This flag Identifies if a BOM with this structure type can be an unimplemented BOM
ALLOW_SUBTYPES	Determines whether subtypes allowed or not for this StructureType.
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
STRUCTURE_TYPE_NAME	Structure Type Name
ITEM_CATALOG_GROUP_ID	Catalog group Identifier
STRUCTURE_TYPE_ID	Structure Type unique identifier
EFFECTIVE_DATE	Effective date for a structure type
STRUCTURE_CREATION_ALLOWED	Flag to decide Structure Creation
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment

Bills of Material - BOM_STRUCTURE_TYPES_TL	Translation table for Structure types
Column Name	Descritpion
LANGUAGE	The language code of the language which the translatable fields are translated to
SOURCE_LANG	Language code of the language which the values of the translatable columns were originally entered
DISPLAY_NAME	Display Name for structure type
DESCRIPTION	Structure type Description
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
STRUCTURE_TYPE_ID	Strucutre Type unique identifier
LAST_UPDATE_LOGIN	Standard Who Column

Bills of Material - BOM_BILL_REVISIONS_B	BOM BILL REVISIONS
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REASON_CODE	Revision reason code
LAST_UPDATED_BY	Standard Who Column
EFFECTIVE_DATE	Effective date of the Strucutre revision
CHANGE_NOTICE	Change Notice for Structure Revision
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who Column
BILL_SEQUENCE_ID	Bill of material unique identifier
ITEM_REVISION_ID	Item Revision unique Identifier
COMMON_BILL_SEQUENCE_ID	Identifier of common bill
REVISION	Bill Revision Name
BILL_REVISION_ID	Bill Revision Unique Identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment

Bills of Material - BOM_BILL_REVISIONS_TL	Translation Table for Bill Revisions
Column Name	Descritpion
LANGUAGE	The language code of the language which the translatable fields are translated to
SOURCE_LANG	Language code of the language which the values of the translatable columns were originally entered
DESCRIPTION	Bill Revisions Description
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
BILL_REVISION_ID	Bill Revision Unique Identifier

Bills of Material - BOM_COMPONENT_TYPES
Column Name	Descritpion
STRUCTURE_TYPE_ID	Structure type unique identifier
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
DISABLE_DATE	Disable date
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
EFFECTIVE_DATE	Effective Date
PARENT_REV_CHANGE_CODE	Parent revision change code
COMPONENT_CATALOG_GROUP_ID	Component Catalog Group Identifier
COMPONENT_REV_CHANGE_CODE	Component revision change code
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment

Bills of Material - BOM_COMPONENTS_EXT_B
Column Name	Descritpion
EXTENSION_ID
C_EXT_ATTR1
REQUEST_ID
DATA_LEVEL_ID
CONTEXT_ID
C_EXT_ATTR2
C_EXT_ATTR3
C_EXT_ATTR4
C_EXT_ATTR5
C_EXT_ATTR6
C_EXT_ATTR7
C_EXT_ATTR8
C_EXT_ATTR9
C_EXT_ATTR10
COMPONENT_SEQUENCE_ID
C_EXT_ATTR11
C_EXT_ATTR12
C_EXT_ATTR13
C_EXT_ATTR14
C_EXT_ATTR15
BILL_SEQUENCE_ID
C_EXT_ATTR16
C_EXT_ATTR17
C_EXT_ATTR18
C_EXT_ATTR19
C_EXT_ATTR20
STRUCTURE_TYPE_ID
C_EXT_ATTR21
C_EXT_ATTR22
C_EXT_ATTR23
C_EXT_ATTR24
C_EXT_ATTR25
C_EXT_ATTR26
C_EXT_ATTR27
C_EXT_ATTR28
C_EXT_ATTR29
C_EXT_ATTR30
ATTR_GROUP_ID
C_EXT_ATTR31
C_EXT_ATTR32
C_EXT_ATTR33
C_EXT_ATTR34
C_EXT_ATTR35
C_EXT_ATTR36
C_EXT_ATTR37
C_EXT_ATTR38
C_EXT_ATTR39
C_EXT_ATTR40
CREATED_BY
N_EXT_ATTR1
N_EXT_ATTR2
N_EXT_ATTR3
N_EXT_ATTR4
N_EXT_ATTR5
N_EXT_ATTR6
N_EXT_ATTR7
N_EXT_ATTR8
N_EXT_ATTR9
N_EXT_ATTR10
CREATION_DATE
N_EXT_ATTR11
N_EXT_ATTR12
N_EXT_ATTR13
N_EXT_ATTR14
N_EXT_ATTR15
N_EXT_ATTR16
N_EXT_ATTR17
N_EXT_ATTR18
N_EXT_ATTR19
N_EXT_ATTR20
LAST_UPDATED_BY
D_EXT_ATTR1
D_EXT_ATTR2
D_EXT_ATTR3
D_EXT_ATTR4
D_EXT_ATTR5
D_EXT_ATTR6
D_EXT_ATTR7
D_EXT_ATTR8
D_EXT_ATTR9
D_EXT_ATTR10
LAST_UPDATE_DATE
UOM_EXT_ATTR1
UOM_EXT_ATTR2
UOM_EXT_ATTR3
UOM_EXT_ATTR4
UOM_EXT_ATTR5
UOM_EXT_ATTR6
UOM_EXT_ATTR7
UOM_EXT_ATTR8
UOM_EXT_ATTR9
UOM_EXT_ATTR10
LAST_UPDATE_LOGIN
UOM_EXT_ATTR11
UOM_EXT_ATTR12
UOM_EXT_ATTR13
UOM_EXT_ATTR14
UOM_EXT_ATTR15
UOM_EXT_ATTR16
UOM_EXT_ATTR17
UOM_EXT_ATTR18
UOM_EXT_ATTR19
UOM_EXT_ATTR20

Bills of Material - BOM_COMPONENTS_EXT_TL
Column Name	Descritpion
EXTENSION_ID
CREATED_BY
CREATION_DATE
TL_EXT_ATTR1
TL_EXT_ATTR2
TL_EXT_ATTR3
TL_EXT_ATTR4
TL_EXT_ATTR5
TL_EXT_ATTR6
TL_EXT_ATTR7
TL_EXT_ATTR8
COMPONENT_SEQUENCE_ID
TL_EXT_ATTR9
TL_EXT_ATTR10
TL_EXT_ATTR11
TL_EXT_ATTR12
TL_EXT_ATTR13
BILL_SEQUENCE_ID
TL_EXT_ATTR14
TL_EXT_ATTR15
TL_EXT_ATTR16
TL_EXT_ATTR17
TL_EXT_ATTR18
STRUCTURE_TYPE_ID
TL_EXT_ATTR19
TL_EXT_ATTR20
TL_EXT_ATTR21
TL_EXT_ATTR22
TL_EXT_ATTR23
TL_EXT_ATTR24
TL_EXT_ATTR25
TL_EXT_ATTR26
TL_EXT_ATTR27
TL_EXT_ATTR28
ATTR_GROUP_ID
TL_EXT_ATTR29
TL_EXT_ATTR30
TL_EXT_ATTR31
TL_EXT_ATTR32
TL_EXT_ATTR33
TL_EXT_ATTR34
TL_EXT_ATTR35
TL_EXT_ATTR36
TL_EXT_ATTR37
TL_EXT_ATTR38
SOURCE_LANG
TL_EXT_ATTR39
TL_EXT_ATTR40
DATA_LEVEL_ID
CONTEXT_ID
LANGUAGE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN

Bills of Material - BOM_STRUCTURES_EXT_B
Column Name	Descritpion
EXTENSION_ID
C_EXT_ATTR23
D_EXT_ATTR9
D_EXT_ATTR10
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
UOM_EXT_ATTR3
C_EXT_ATTR1
C_EXT_ATTR2
UOM_EXT_ATTR13
C_EXT_ATTR3
C_EXT_ATTR4
LAST_UPDATED_BY
C_EXT_ATTR5
C_EXT_ATTR6
D_EXT_ATTR8
C_EXT_ATTR7
BILL_SEQUENCE_ID
N_EXT_ATTR8
C_EXT_ATTR33
C_EXT_ATTR9
C_EXT_ATTR10
C_EXT_ATTR11
C_EXT_ATTR12
C_EXT_ATTR13
C_EXT_ATTR14
C_EXT_ATTR15
C_EXT_ATTR16
C_EXT_ATTR17
BILL_REVISION_ID
C_EXT_ATTR19
C_EXT_ATTR20
N_EXT_ATTR1
N_EXT_ATTR2
N_EXT_ATTR3
N_EXT_ATTR4
N_EXT_ATTR5
N_EXT_ATTR6
N_EXT_ATTR7
STRUCTURE_TYPE_ID
N_EXT_ATTR13
N_EXT_ATTR9
N_EXT_ATTR10
D_EXT_ATTR1
D_EXT_ATTR2
D_EXT_ATTR3
D_EXT_ATTR4
D_EXT_ATTR5
C_EXT_ATTR21
C_EXT_ATTR22
CHANGE_LINE_ID
C_EXT_ATTR24
C_EXT_ATTR25
C_EXT_ATTR26
C_EXT_ATTR27
C_EXT_ATTR28
C_EXT_ATTR29
C_EXT_ATTR30
C_EXT_ATTR31
C_EXT_ATTR32
ACD_TYPE
C_EXT_ATTR18
C_EXT_ATTR34
C_EXT_ATTR35
C_EXT_ATTR36
C_EXT_ATTR37
C_EXT_ATTR38
C_EXT_ATTR39
C_EXT_ATTR40
N_EXT_ATTR11
N_EXT_ATTR12
ATTR_GROUP_ID
N_EXT_ATTR14
N_EXT_ATTR15
N_EXT_ATTR16
N_EXT_ATTR17
N_EXT_ATTR18
N_EXT_ATTR19
N_EXT_ATTR20
UOM_EXT_ATTR1
UOM_EXT_ATTR2
CREATED_BY
C_EXT_ATTR8
UOM_EXT_ATTR4
UOM_EXT_ATTR5
UOM_EXT_ATTR6
UOM_EXT_ATTR7
UOM_EXT_ATTR8
UOM_EXT_ATTR9
UOM_EXT_ATTR10
UOM_EXT_ATTR11
UOM_EXT_ATTR12
CREATION_DATE
UOM_EXT_ATTR14
UOM_EXT_ATTR15
UOM_EXT_ATTR16
UOM_EXT_ATTR17
UOM_EXT_ATTR18
UOM_EXT_ATTR19
UOM_EXT_ATTR20
D_EXT_ATTR6
D_EXT_ATTR7

Bills of Material - BOM_STRUCTURES_EXT_TL
Column Name	Descritpion
EXTENSION_ID
TL_EXT_ATTR26
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
TL_EXT_ATTR1
TL_EXT_ATTR2
TL_EXT_ATTR3
TL_EXT_ATTR4
TL_EXT_ATTR5
BILL_SEQUENCE_ID
TL_EXT_ATTR16
TL_EXT_ATTR7
TL_EXT_ATTR8
TL_EXT_ATTR9
TL_EXT_ATTR10
TL_EXT_ATTR11
TL_EXT_ATTR12
TL_EXT_ATTR13
TL_EXT_ATTR14
TL_EXT_ATTR15
BILL_REVISION_ID
TL_EXT_ATTR17
TL_EXT_ATTR18
TL_EXT_ATTR19
TL_EXT_ATTR20
TL_EXT_ATTR21
TL_EXT_ATTR22
TL_EXT_ATTR23
TL_EXT_ATTR24
TL_EXT_ATTR25
STRUCTURE_TYPE_ID
TL_EXT_ATTR6
TL_EXT_ATTR27
TL_EXT_ATTR28
TL_EXT_ATTR29
TL_EXT_ATTR30
TL_EXT_ATTR31
TL_EXT_ATTR32
TL_EXT_ATTR33
TL_EXT_ATTR34
TL_EXT_ATTR35
CHANGE_LINE_ID
TL_EXT_ATTR37
TL_EXT_ATTR38
TL_EXT_ATTR39
TL_EXT_ATTR40
ACD_TYPE
TL_EXT_ATTR36
ATTR_GROUP_ID
SOURCE_LANG
LAST_UPDATE_DATE
LANGUAGE

Bills of Material - BOM_STRUCTURES_B	Bills of material
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
PK2_VALUE	Primary key of the object
PK3_VALUE	Primary key of the object
CREATION_DATE	Standard Who column
PK4_VALUE	Primary key of the object
PK5_VALUE	Primary key of the object
CREATED_BY	Standard Who column
EFFECTIVITY_CONTROL	Effectivity control
LAST_UPDATE_LOGIN	Standard Who column
IS_PREFERRED	Is preferred
SOURCE_BILL_SEQUENCE_ID	Source Bill Sequence Id
COMMON_ASSEMBLY_ITEM_ID	Assembly item identifier of common bill
SPECIFIC_ASSEMBLY_COMMENT	Specific bill of material comment
PENDING_FROM_ECN	Change notice that created this bill of material
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ASSEMBLY_TYPE	Assembly type: 1=Manufacturing bill 2=Engineering bill
COMMON_BILL_SEQUENCE_ID	Identifier of common bill
BILL_SEQUENCE_ID	Bill of material unique identifier
REQUEST_ID	Concurrent Who column
ASSEMBLY_ITEM_ID	Inventory item identifier of manufactured assembly
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
COMMON_ORGANIZATION_ID	Organization identifier of common bill
ORGANIZATION_ID	Organization identifier
NEXT_EXPLODE_DATE	Next date when pre-explosion will be refreshed
PROJECT_ID	Project Identifier for Project Manufacturing
TASK_ID	Task identifier for Project Manufacturing
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from.
ALTERNATE_BOM_DESIGNATOR	Alternate designator code
STRUCTURE_TYPE_ID	Structure Type Id
IMPLEMENTATION_DATE	Implementation date
LAST_UPDATE_DATE	Standard Who column
OBJ_NAME	Object Name
PK1_VALUE	Primary key of the object

Bills of Material - BOM_COMPONENTS_B	Bill of material components
Column Name	Descritpion
OPERATION_SEQ_NUM	Operation sequence number
ATTRIBUTE11	Descriptive flexfield segment
COMPONENT_ITEM_ID	Component item identifier
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE14	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE15	Descriptive flexfield segment
CREATION_DATE	Standard Who column
PLANNING_FACTOR	Factor used to multiply component quantity with to obtain planning quantity
QUANTITY_RELATED	Identifier to indicate if this component has quantity related reference designators
SO_BASIS	Quantity basis used by Oracle Order Management to determine how many units of component to put on an order
OPTIONAL	Flag indicating if component is optional in bill
MUTUALLY_EXCLUSIVE_OPTIONS	Flag indicating if one or more children of component can be picked when taking an order
CREATED_BY	Standard Who column
INCLUDE_IN_COST_ROLLUP	Flag indicating if this component is to be used when rolling up costs
CHECK_ATP	Flag indicating if ATP check is required
SHIPPING_ALLOWED	Flag indicating if component is allowed to ship
REQUIRED_TO_SHIP	Flag indicating if component is required to ship
REQUIRED_FOR_REVENUE	Flag indicating if component is required for revenue
LAST_UPDATE_LOGIN	Standard Who column
INCLUDE_ON_SHIP_DOCS	Flag indicating if component is displayed on shipping documents
INCLUDE_ON_BILL_DOCS	(not currently used)
LOW_QUANTITY	Minimum quantity allowed on an order
HIGH_QUANTITY	Maximum quantity allowed on an order
ACD_TYPE	Add, change, or disable code for component on an engineering change order
OLD_COMPONENT_SEQUENCE_ID	Identifier of original component row an ECO effects
COMPONENT_SEQUENCE_ID	Component unique identifier
BILL_SEQUENCE_ID	Bill of material unique identifier
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
WIP_SUPPLY_TYPE	WIP supply type code
PICK_COMPONENTS	(not currently used)
ITEM_NUM	Item sequence within bill of material structure
SUPPLY_SUBINVENTORY	Supply subinventory
SUPPLY_LOCATOR_ID	Supply locator identifier
OPERATION_LEAD_TIME_PERCENT	Operation offset from first operation in routing (denormalized from corresponding column in BOM_OPERATION_SEQUNCES)
REVISED_ITEM_SEQUENCE_ID	Engineering change order revised item identifier
COST_FACTOR	(not currently used)
BOM_ITEM_TYPE	Type of item (denormalized from BOM Item Type in MTL_SYSTEM_ITEMS)
FROM_END_ITEM_UNIT_NUMBER	From End Item Unit Number
TO_END_ITEM_UNIT_NUMBER	To End Item Unit Number
COMPONENT_ITEM_REVISION_ID	Item revision Identifier
ORIGINAL_SYSTEM_REFERENCE	Original system that data for the current record has come from
BASIS_TYPE	Basis type identifier
ECO_FOR_PRODUCTION	Indicates if this component on an Engineering Change Order is only for WIP jobs
DELETE_GROUP_NAME	Delete group name for the entity type you are deleting
DG_DESCRIPTION	Description of the delete group
ENFORCE_INT_REQUIREMENTS	Enforce Integer Requirements
COMPONENT_QUANTITY	Quantity of component in bill of material
OPTIONAL_ON_MODEL	Flag indicating if component is optional on model bill (for ATO)
PARENT_BILL_SEQ_ID	Common bill sequence id of the model bill (for ATO)
COMPONENT_YIELD_FACTOR	Factor used to multiply component quantity with to obtain required component quantity
MODEL_COMP_SEQ_ID	Component sequence identifier from model bill (for ATO)
PLAN_LEVEL	Plan level based on model bill (for ATO)
AUTO_REQUEST_MATERIAL	Flag to indicate if the item is automatically requested or not
SUGGESTED_VENDOR_NAME	Suggested vendor name will be used for direct items for EAM BOMs
VENDOR_ID	Suggested Vendor ID column
COMPONENT_REMARKS	Component remarks
UNIT_PRICE	Unit Price for direct items used by EAM BOMs
OBJ_NAME	Object Name
PK1_VALUE	Primary Key id of the object
PK2_VALUE	Primary Key id of the object
EFFECTIVITY_DATE	Effective date
PK3_VALUE	Primary Key of the object
PK4_VALUE	Primary key of the object
PK5_VALUE	Primary key of the object
FROM_END_ITEM_REV_ID	From End Item Revision Id
CHANGE_NOTICE	Engineering change order number
TO_END_ITEM_REV_ID	To End Item Revision Id
IMPLEMENTATION_DATE	Date on which engineering change order was implemented
OVERLAPPING_CHANGES	Overlapping Changes
DISABLE_DATE	Disable date
FROM_OBJECT_REVISION_ID	From Object Revision Id
FROM_MINOR_REVISION_ID	From Minor Revision Id
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
TO_OBJECT_REVISION_ID	To Object Revision Id
TO_MINOR_REVISION_ID	To Minor Revision Id
ATTRIBUTE1	Descriptive flexfield segment
FROM_END_ITEM_MINOR_REV_ID	From End Item Minor Rev Id
TO_END_ITEM_MINOR_REV_ID	To End Item Minor Rev Id
ATTRIBUTE2	Descriptive flexfield segment
COMPONENT_MINOR_REVISION_ID	Component Minor Revision Id
FROM_BILL_REVISION_ID	From Bill Revision Id
ATTRIBUTE3	Descriptive flexfield segment
TO_BILL_REVISION_ID	To Bill Revision Id
FROM_STRUCTURE_REVISION_CODE	From structure revision code
TO_STRUCTURE_REVISION_CODE	To structure revision code
FROM_END_ITEM_STRC_REV_ID	(not currently used)
ATTRIBUTE4	Descriptive flexfield segment
TO_END_ITEM_STRC_REV_ID	(not currently used)
COMMON_COMPONENT_SEQUENCE_ID	Common Component Sequence Id
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment

Bills of Material - BOM_STD_SUB_OP_RESOURCES
Column Name	Descritpion
STANDARD_OPERATION_ID
BASIS_TYPE	Basis type identifier
SCHEDULE_FLAG	Schedule the resource
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
CREATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
AUTOCHARGE_TYPE	Autocharge type for shopfloor moves
ATTRIBUTE_CATEGORY	Attribute category
RESOURCE_ID
REQUEST_ID	Concurrent WHO columns
PROGRAM_APPLICATION_ID	Concurrent WHO columns
PROGRAM_ID	Concurrent WHO columns
PROGRAM_UPDATE_DATE	Concurrent WHO columns
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flex value
SUBSTITUTE_GROUP_NUM	Substitute group number
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
SCHEDULE_SEQ_NUM	Schedule Sequence Number for Alternate Recources
AVAILABLE_24_HOURS_FLAG	taken from bom_department_resources
REPLACEMENT_GROUP_NUM	Replacement group number
ACTIVITY_ID	Activity identifier
STANDARD_RATE_FLAG	Use standard rate for shopfloor transactions
ASSIGNED_UNITS	Resource units assigned
USAGE_RATE_OR_AMOUNT	Resource usage rate
USAGE_RATE_OR_AMOUNT_INVERSE	Resource usage rate inverse

Bills of Material - BOM_ALTERNATE_DESIGNATORS_TL	Alternate Designators Translation table
Column Name	Descritpion
ALTERNATE_DESIGNATOR_CODE	Alternate designator code
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ORGANIZATION_ID	Organization id
DISPLAY_NAME	Display Name for structure name
DESCRIPTION	Structure name Description
LANGUAGE	The language code of the language which the translatable fields are translated to
SOURCE_LANG	Language code of the language which the values of the translatable columns were originally entered
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column

Bills of Material - BOM_CTO_SRC_ORGS_B	BOM_CTO_SRC_ORGS_B
Column Name	Descritpion
CONFIG_ITEM_ID	CONFIG_ITEM_ID
RCV_ORG_ID	RCV_ORG_ID
TOP_MODEL_LINE_ID	TOP_MODEL_LINE_ID
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
COST_ROLLUP	COST_ROLLUP
LAST_UPDATE_DATE	Standard Who column
GROUP_REFERENCE_ID	Group Reference Id
CREATE_BOM	CREATE_BOM
CREATE_SRC_RULES	CREATE_SRC_RULES
LINE_ID	LINE_ID
MODEL_ITEM_ID	MODEL_ITEM_ID
ORGANIZATION_ID	ORGANIZATION_ID
ORGANIZATION_TYPE	ORGANIZATION_TYPE
RANK	RANK

Bills of Material - BOM_COMPONENT_COLUMNS	BOM COMPONENT COLUMNS TABLE
Column Name	Descritpion
BOM_INTF_TABLE_NAME	BOM interface table name
AVAILABLE_IN_RESULT_FORMAT	Available in Result Format flag
AVAILABLE_IN_CRITERIA	Available in Criteria Flag
OPERATION_TYPE	Data Type / Operation Type
LOV_OR_POPLIST_SQL	Lov/Poplist Sql according to operation type
ADDITIONAL_JOIN_CONDITIONS	Additional join conditions
ATTRIBUTE_GROUP_DISPLAY_NAME	Attribute Group Display Name
PREDEFINED	Predefined column is used to determine if the attribute is predefined or seeded
UPDATE_ALLOWED	Updatable
VALUESET_NAME	Value set name
ATTRIBUTE_GROUP	ATTRIBUTE GROUP
LOOKUP_TYPE	Holds the value of lookup_type, which will be used to convert the code to meaning.
DISPLAY_TYPE	Holds the display type value for the attribute
ATTRIBUTE_SEQUENCE	The sequence in which the attribute should appear in an attribute group.
ATTRIBUTE_CODE	ATTRIBUTE CODE
OBJECT_TYPE	OBJECT_TYPE
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
APPLICATION_SHORT_NAME	Application Short Name
LAST_UPDATE_LOGIN	Standard Who Column
DISPLAY_NAME	DISPLAY NAME
SORTABLE	SORTABLE
TABLE_NAME	TABLE NAME
TABLE_COLUMN_NAME	COLUMN_NAME
TABLE_ALIAS_NAME	TABLE ALIAS NAME
BASE_WHERE_CLAUSE	WHERE CLAUSE
PARENT_ENTITY	Parent entity
ADDITIONAL_JOIN_TABLES	Extra Table Name
BOM_INTF_COLUMN_NAME	Bom interface column name

Bills of Material - BOM_CTO_ORDER_LINES_UPG	bom cto order lines
Column Name	Descritpion
ATO_LINE_ID	ATO_LINE_ID
LINK_TO_LINE_ID	LINK_TO_LINE_ID
ORDERED_QUANTITY	ORDERED_QUANTITY
ORDER_QUANTITY_UOM	ORDER_QUANTITY_UOM
PARENT_ATO_LINE_ID	PARENT_ATO_LINE_ID
PERFORM_MATCH	PERFORM_MATCH
PLAN_LEVEL	PLAN_LEVEL
SCHEDULE_SHIP_DATE	SCHEDULE_SHIP_DATE
SHIP_FROM_ORG_ID	SHIP_FROM_ORG_ID
TOP_MODEL_LINE_ID	TOP_MODEL_LINE_ID
WIP_SUPPLY_TYPE	WIP_SUPPLY_TYPE
BATCH_ID	BATCH_ID
HEADER_ID	HEADER_ID
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
BOM_ITEM_TYPE	BOM_ITEM_TYPE
REUSE_CONFIG	Resuse Config Flag
OPTION_SPECIFIC	Option Specific Flag
QTY_PER_PARENT_MODEL	Qty Per Parent Model
CONFIG_CREATION	Config Creation Attribute
SEQUENCE	Sequence
STATUS	Status
COMPONENT_CODE	COMPONENT_CODE
COMPONENT_SEQUENCE_ID	COMPONENT_SEQUENCE_ID
CONFIG_ITEM_ID	CONFIG_ITEM_ID
INVENTORY_ITEM_ID	INVENTORY_ITEM_ID
ITEM_TYPE_CODE	ITEM_TYPE_CODE
LINE_ID	LINE_ID

Bills of Material - BOM_STRUCTURE_REVISIONS_B	BOM BILL REVISIONS
Column Name	Descritpion
REVISION	Bill Revision Name
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
REVISION_REASON
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CHANGE_LINE_ID
CHANGE_NOTICE
STRUCTURE_REVISION_CODE
REASON_CODE	Revision reason code
BILL_SEQUENCE_ID	Bill of material unique identifier
OBJECT_REVISION_ID	Item Revision unique Identifier
EFFECTIVE_DATE	Effective date of the Strucutre revision
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who Column
STRUCTURE_REVISION_ID	Bill Revision Unique Identifier
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who Column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment

Bills of Material - BOM_STRUCTURE_REVISIONS_TL	Translation Table for Bill Revisions
Column Name	Descritpion
REVISION_LABEL
LANGUAGE	The language code of the language which the translatable fields are translated to
SOURCE_LANG	Language code of the language which the values of the translatable columns were originally entered
DESCRIPTION	Bill Revisions Description
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
STRUCTURE_REVISION_ID	Bill Revision Unique Identifier
LAST_UPDATE_DATE
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Bills of Material - BOM_ITEM_ATTACH_CATEGORY_ASSOC	Structure Types Item Attachment Categories Association Table
Column Name	Descritpion
ATTACH_CATEGORY_ID	Attachment category identifier
CREATED_BY	Standard WHO columns
CREATION_DATE	Standard WHO columns
LAST_UPDATED_BY	Standard WHO columns
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATE_LOGIN	Standard WHO columns
STRUCTURE_TYPE_ID	BOM structure type identifier

Bills of Material - BOM_CTO_OSS_COMPONENTS	OSS Component Definition
Column Name	Descritpion
ATTRIBUTE1	Attribute1
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Concurrent Who Column
PROGRAM_APPLICATION_ID	Concurrent Who Column
PROGRAM_ID	Concurrent Who Column
PROGRAM_UPDATE_DATE	Concurrent Who Column
ATTRIBUTE9	Attribute9
ATTRIBUTE3	Attribute3
ATTRIBUTE15	Attribute15
ATTRIBUTE14	Attribute14
ATTRIBUTE13	Attribute13
ATTRIBUTE12	Attribute12
ATTRIBUTE11	Attribute11
ATTRIBUTE10	Attribute10
ATTRIBUTE8	Attribute8
ATTRIBUTE7	Attribute7
ATTRIBUTE6	Attribute6
ATTRIBUTE4	Attribute4
ATTRIBUTE5	Attribute5
ATTRIBUTE2	Attribute2
OSS_COMP_SEQ_ID	Component Sequence Id
MODEL_ITEM_ID	Model Item Id
ATTRIBUTE_CATEGORY	Attribute Category
OPTION_ITEM_ID	Option Item Id
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column

Bills of Material - BOM_CTO_OSS_ORGS_LIST	OSS Org List
Column Name	Descritpion
OSS_LIST_SEQ_ID	OSS List Sequence Id
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Concurrent Who Column
PROGRAM_APPLICATION_ID	Concurrent Who Column
PROGRAM_ID	Concurrent Who Column
PROGRAM_UPDATE_DATE	Concurrent Who Column
ATTRIBUTE_CATEGORY	DFF Attribute Category
ATTRIBUTE1	DFF Attribute Column
ATTRIBUTE2	DFF Attribute Column
ATTRIBUTE3	DFF Attribute Column
ATTRIBUTE4	DFF Attribute Column
OSS_COMP_SEQ_ID	OSS Component Sequence Id
ATTRIBUTE5	DFF Attribute Column
ATTRIBUTE6	DFF Attribute Column
ATTRIBUTE7	DFF Attribute Column
ATTRIBUTE8	DFF Attribute Column
ATTRIBUTE9	DFF Attribute Column
ATTRIBUTE10	DFF Attribute Column
ATTRIBUTE11	DFF Attribute Column
ATTRIBUTE12	DFF Attribute Column
ATTRIBUTE13	DFF Attribute Column
ATTRIBUTE14	DFF Attribute Column
ORGANIZATION_ID	Organization Id
ATTRIBUTE15	DFF Attribute Column
VENDOR_ID	Vendor Id
VENDOR_SITE_CODE	Vendor Site Code
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column

Bills of Material - BOM_CTO_MODEL_ORGS	BOM_CTO_MODEL_ORGS
Column Name	Descritpion
REFERENCE_ID	reference id
RANK	Rank
RCV_ORG_ID	Rcv Org Id
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
GROUP_REFERENCE_ID	group reference id
LAST_UPDATE_DATE	Standard Who column
CONFIG_ITEM_ID	CONFIG ITEM ID
COST_ROLLUP	Cost Rollup
CREATE_BOM	Create Bom
CREATE_SRC_RULES	Create Src Rules
MODEL_ITEM_ID	Model Item Id
ORGANIZATION_ID	Organization Id
ORGANIZATION_TYPE	Organization Type

Bills of Material - BOM_STRUCTURE_EXT_B
Column Name	Descritpion
EXTENSION_ID
LAST_UPDATED_BY
D_EXT_ATTR8
D_EXT_ATTR9
D_EXT_ATTR10
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
C_EXT_ATTR1
C_EXT_ATTR2
C_EXT_ATTR3
C_EXT_ATTR4
C_EXT_ATTR5
C_EXT_ATTR6
C_EXT_ATTR7
BILL_SEQUENCE_ID
C_EXT_ATTR8
C_EXT_ATTR9
C_EXT_ATTR10
C_EXT_ATTR11
C_EXT_ATTR12
C_EXT_ATTR13
C_EXT_ATTR14
C_EXT_ATTR15
C_EXT_ATTR16
C_EXT_ATTR17
BILL_REVISION_ID
C_EXT_ATTR18
C_EXT_ATTR19
C_EXT_ATTR20
N_EXT_ATTR1
N_EXT_ATTR2
N_EXT_ATTR3
N_EXT_ATTR4
N_EXT_ATTR5
N_EXT_ATTR6
N_EXT_ATTR7
STRUCTURE_TYPE_ID
N_EXT_ATTR8
N_EXT_ATTR9
N_EXT_ATTR10
D_EXT_ATTR1
D_EXT_ATTR2
D_EXT_ATTR3
D_EXT_ATTR4
D_EXT_ATTR5
C_EXT_ATTR21
C_EXT_ATTR22
CHANGE_LINE_ID
C_EXT_ATTR23
C_EXT_ATTR24
C_EXT_ATTR25
C_EXT_ATTR26
C_EXT_ATTR27
C_EXT_ATTR28
C_EXT_ATTR29
C_EXT_ATTR30
C_EXT_ATTR31
C_EXT_ATTR32
ACD_TYPE
C_EXT_ATTR33
C_EXT_ATTR34
C_EXT_ATTR35
C_EXT_ATTR36
C_EXT_ATTR37
C_EXT_ATTR38
C_EXT_ATTR39
C_EXT_ATTR40
N_EXT_ATTR11
N_EXT_ATTR12
ATTR_GROUP_ID
N_EXT_ATTR13
N_EXT_ATTR14
N_EXT_ATTR15
N_EXT_ATTR16
N_EXT_ATTR17
N_EXT_ATTR18
N_EXT_ATTR19
N_EXT_ATTR20
UOM_EXT_ATTR1
UOM_EXT_ATTR2
CREATED_BY
UOM_EXT_ATTR3
UOM_EXT_ATTR4
UOM_EXT_ATTR5
UOM_EXT_ATTR6
UOM_EXT_ATTR7
UOM_EXT_ATTR8
UOM_EXT_ATTR9
UOM_EXT_ATTR10
UOM_EXT_ATTR11
UOM_EXT_ATTR12
CREATION_DATE
UOM_EXT_ATTR13
UOM_EXT_ATTR14
UOM_EXT_ATTR15
UOM_EXT_ATTR16
UOM_EXT_ATTR17
UOM_EXT_ATTR18
UOM_EXT_ATTR19
UOM_EXT_ATTR20
D_EXT_ATTR6
D_EXT_ATTR7

Bills of Material - BOM_BILL_OF_MATERIALS_TEMP
Column Name	Descritpion
ASSEMBLYITEMNAME
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ORGANIZATIONCODE
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ORIGINALSYSTEMREFERENCE
DELETEGROUPNAME
DGDESCRIPTION
IMPLEMENTATIONDATE
ALTERNATEBOMCODE
COMMONASSEMBLYITEMNAME
COMMONORGANIZATIONCODE
ASSEMBLYCOMMENT
ASSEMBLYTYPE
ATTRIBUTECATEGORY
ATTRIBUTE1

Bills of Material - BOM_ATO_CONFIGS_TEMP
Column Name	Descritpion
CONFIG_ITEM_ID
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ORGANIZATION_ID
BASE_MODEL_ID
COMPONENT_ITEM_ID
COMPONENT_CODE
COMPONENT_QUANTITY
CREATION_DATE
CREATED_BY
LAST_UPDATED_BY

Bills of Material - BOM_CTO_MLSUPPLY_MAIN_TEMP
Column Name	Descritpion
ORDER_LINE_ID
FIXED_LEAD_TIME
VARIABLE_LEAD_TIME
PROCESSING_LEAD_TIME
POSTPROCESSING_LEAD_TIME
BOM_ITEM_TYPE
AUTO_CONFIG_FLAG
PARENT_INDEX
JOB_START_DATE
JOB_COMPLETION_DATE
LINE_ID
ITEM_INDEX
LINE_CODE
SOURCE_TYPE
JOB_NAME
FEEDER_SYNC
FLOW_START_INDEX
FLOW_END_INDEX
COMMENTS
WIP_SUPPLY_TYPE
OPERATION_SEQ_NUM
ACTUAL_PARENT_INDEX
ITEM_ID
ITEM_NAME
ITEM_QUANTITY
NEEDED_ITEM_QTY
OPERATION_LEAD_TIME_PERCENT
CFM_ROUTING_FLAG
ROUTING_SEQUENCE_ID

Bills of Material - BOM_INVENTORY_COMPONENTS_TEMP
Column Name	Descritpion
ORGANIZATIONCODE
ITEMSEQUENCENUMBER
QUANTITYPERASSEMBLY
PLANNINGPERCENT
PROJECTEDYIELD
INCLUDEINCOSTROLLUP
WIPSUPPLYTYPE
SOBASIS
OPTIONAL
MUTUALLYEXCLUSIVE
CHECKATP
ASSEMBLYITEMNAME
SHIPPINGALLOWED
REQUIREDTOSHIP
REQUIREDFORREVENUE
INCLUDEONSHIPDOCS
QUANTITYRELATED
SUPPLYSUBINVENTORY
LOCATIONNAME
MINIMUMALLOWEDQUANTITY
MAXIMUMALLOWEDQUANTITY
COMMENTS
STARTEFFECTIVEDATE
ATTRIBUTECATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
DISABLEDATE
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
FROMENDITEMUNITNUMBER
NEWFROMENDITEMUNITNUMBER
TOENDITEMUNITNUMBER
ORIGINALSYSTEMREFERENCE
OPERATIONSEQUENCENUMBER
DELETEGROUPNAME
DGDESCRIPTION
ENFORCEINTREQUIREMENTS
SUGGESTEDVENDORNAME
UNITPRICE
BASISTYPE
COMPONENTITEMNAME
ALTERNATEBOMCODE
NEWEFFECTIVITYDATE
NEWOPERATIONSEQUENCENUMBER

Bills of Material - BOM_EXPLOSIONS_ALL
Column Name	Descritpion
TOP_BILL_SEQUENCE_ID
PROGRAM_APPLICATION_ID
PLANNING_FACTOR
OPERATION_SEQ_NUM
PARENT_BOM_ITEM_TYPE
WIP_SUPPLY_TYPE
ITEM_NUM
EFFECTIVITY_DATE
DISABLE_DATE
TRIMMED_EFFECTIVITY_DATE
TRIMMED_DISABLE_DATE
IMPLEMENTATION_DATE
PROGRAM_ID
SUPPLY_SUBINVENTORY
SUPPLY_LOCATOR_ID
COMPONENT_REMARKS
CHANGE_NOTICE
OPERATION_LEAD_TIME_PERCENT
REXPLODE_FLAG
COMMON_BILL_SEQUENCE_ID
COMMON_ORGANIZATION_ID
PRIMARY_PATH_FLAG
AUTO_REQUEST_MATERIAL
PROGRAM_UPDATE_DATE
EXPLOSION_TYPE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
COMP_BILL_SEQ_ID
COMP_COMMON_BILL_SEQ_ID
NUM_COL1
NUM_COL2
NUM_COL3
GROUP_ID
DATE_COL1
DATE_COL2
DATE_COL3
CHAR_COL1
CHAR_COL2
CHAR_COL3
INCLUDE_IN_COST_ROLLUP
PARENT_SORT_ORDER
STRUCTURE_TYPE_ID
OBJ_NAME
SESSION_ID
PK1_VALUE
PK2_VALUE
PK3_VALUE
PK4_VALUE
PK5_VALUE
HGRID_FLAG
OPERATION_OFFSET
CURRENT_REVISION
LOCATOR
SUGGESTED_VENDOR_NAME
SELECT_FLAG
UNIT_PRICE
VENDOR_ID
FROM_END_ITEM_UNIT_NUMBER
TO_END_ITEM_UNIT_NUMBER
TRIMMED_FROM_UNIT_NUMBER
TRIMMED_TO_UNIT_NUMBER
FROM_END_ITEM_REV_ID
FROM_END_ITEM_MINOR_REV_ID
TO_END_ITEM_REV_ID
TO_END_ITEM_MINOR_REV_ID
SELECT_QUANTITY
NEW_COMPONENT_CODE
FROM_BILL_REVISION_ID
TO_BILL_REVISION_ID
REVISION_ID
REVISION_LABEL
EFFECTIVITY_CONTROL
ACCESS_FLAG
ENG_ITEM_FLAG
ASSEMBLY_TYPE
FROM_OBJECT_REVISION_ID
EXTEND_COST_FLAG
FROM_MINOR_REVISION_ID
TO_OBJECT_REVISION_ID
TO_MINOR_REVISION_ID
OBJECT_REVISION_ID
MINOR_REVISION_ID
MINOR_REVISION_CODE
COMPONENT_ITEM_REVISION_ID
COMPONENT_MINOR_REVISION_ID
BOM_IMPLEMENTATION_DATE
GTIN_NUMBER
TOP_ALTERNATE_DESIGNATOR
GTIN_DESCRIPTION
TRADE_ITEM_DESCRIPTOR
TRADE_ITEM_DESCRIPTOR_DESC
GTIN_PUBLICATION_STATUS
TOP_GTIN_NUMBER
TOP_GTIN_DESCRIPTION
TOP_TRADE_ITEM_DESCRIPTOR
PARENT_GTIN_NUMBER
PARENT_GTIN_DESCRIPTION
PARENT_TRADE_ITEM_DESCRIPTOR
TOP_ITEM_ID
QUANTITY_OF_CHILDREN
TOTAL_QTY_AT_NEXT_LEVEL
CHANGE_ID
ACD_TYPE
QUANTITY_RELATED
CHANGE_POLICY_VALUE
EXPLODED_DATE
EXPLODED_UNIT_NUMBER
EXPLODED_END_ITEM_REV
EXPLODED_END_ITEM_ID
BILL_SEQUENCE_ID
CONTEXT
EXPLODED_END_ITEM_ORG_ID
EXPLODED_OPTION
PARENT_COMP_SEQ_ID
END_ITEM_ID
END_ITEM_ORG_ID
FROM_END_ITEM_REVISION
TO_END_ITEM_REVISION
IS_END_ITEM_SPECIFIC
IS_EXCLUDED_BY_RULE
REAPPLY_EXCLUSIONS
ATTRIBUTE1
COMP_FIXED_REV_HIGH_DATE
COMP_FIXED_REVISION_ID
MAX_BILL_LEVEL
IS_PREFERRED
PARENT_IMPLEMENTATION_DATE
PARENT_CHANGE_NOTICE
BASIS_TYPE
SOURCE_BILL_SEQUENCE_ID
COMMON_COMPONENT_SEQUENCE_ID
COMP_SOURCE_BILL_SEQ_ID
ATTRIBUTE2
COMP_EFFECTIVITY_CONTROL
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ORGANIZATION_ID
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
HEADER_ID
LINE_ID
LIST_PRICE
SELLING_PRICE
COMPONENT_SEQUENCE_ID
COMPONENT_YIELD_FACTOR
ITEM_COST
INCLUDE_IN_ROLLUP_FLAG
BASED_ON_ROLLUP_FLAG
ACTUAL_COST_TYPE_ID
COMPONENT_QUANTITY
SHRINKAGE_RATE
SO_BASIS
OPTIONAL
MUTUALLY_EXCLUSIVE_OPTIONS
COMPONENT_ITEM_ID
CHECK_ATP
SHIPPING_ALLOWED
REQUIRED_TO_SHIP
REQUIRED_FOR_REVENUE
INCLUDE_ON_SHIP_DOCS
INCLUDE_ON_BILL_DOCS
LOW_QUANTITY
HIGH_QUANTITY
PICK_COMPONENTS
PRIMARY_UOM_CODE
PLAN_LEVEL
PRIMARY_UNIT_OF_MEASURE
BASE_ITEM_ID
ATP_COMPONENTS_FLAG
ATP_FLAG
BOM_ITEM_TYPE
PICK_COMPONENTS_FLAG
REPLENISH_TO_ORDER_FLAG
SHIPPABLE_ITEM_FLAG
CUSTOMER_ORDER_FLAG
INTERNAL_ORDER_FLAG
EXTENDED_QUANTITY
CUSTOMER_ORDER_ENABLED_FLAG
INTERNAL_ORDER_ENABLED_FLAG
SO_TRANSACTIONS_FLAG
MTL_TRANSACTIONS_ENABLED_FLAG
STOCK_ENABLED_FLAG
DESCRIPTION
ASSEMBLY_ITEM_ID
ALTERNATE_BOM_DESIGNATOR
CONFIGURATOR_FLAG
PRICE_LIST_ID
SORT_ORDER
ROUNDING_FACTOR
PRICING_CONTEXT
PRICING_ATTRIBUTE1
PRICING_ATTRIBUTE2
PRICING_ATTRIBUTE3
PRICING_ATTRIBUTE4
PRICING_ATTRIBUTE5
PRICING_ATTRIBUTE6
PRICING_ATTRIBUTE7
PRICING_ATTRIBUTE8
REQUEST_ID
PRICING_ATTRIBUTE9
PRICING_ATTRIBUTE10
PRICING_ATTRIBUTE11
PRICING_ATTRIBUTE12
PRICING_ATTRIBUTE13
PRICING_ATTRIBUTE14
PRICING_ATTRIBUTE15
COMPONENT_CODE
LOOP_FLAG
INVENTORY_ASSET_FLAG

Bills of Material - BOM_OPERATION_SEQUENCES_TEMP
Column Name	Descritpion
OPERATION_SEQUENCE_ID
DEPARTMENT_ID
OPERATION_LEAD_TIME_PERCENT
MINIMUM_TRANSFER_QUANTITY
COUNT_POINT_TYPE
OPERATION_DESCRIPTION
EFFECTIVITY_DATE
DISABLE_DATE
BACKFLUSH_FLAG
OPTION_DEPENDENT_FLAG
ATTRIBUTE_CATEGORY
ROUTING_SEQUENCE_ID
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
OPERATION_SEQ_NUM
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
OPERATION_TYPE
LAST_UPDATE_DATE
REFERENCE_FLAG
PROCESS_OP_SEQ_ID
LINE_OP_SEQ_ID
YIELD
CUMULATIVE_YIELD
REVERSE_CUMULATIVE_YIELD
LABOR_TIME_CALC
MACHINE_TIME_CALC
TOTAL_TIME_CALC
LABOR_TIME_USER
LAST_UPDATED_BY
MACHINE_TIME_USER
TOTAL_TIME_USER
NET_PLANNING_PERCENT
X_COORDINATE
Y_COORDINATE
INCLUDE_IN_ROLLUP
OPERATION_YIELD_ENABLED
OLD_OPERATION_SEQUENCE_ID
ACD_TYPE
REVISED_ITEM_SEQUENCE_ID
CREATION_DATE
ORIGINAL_SYSTEM_REFERENCE
CHANGE_NOTICE
IMPLEMENTATION_DATE
ECO_FOR_PRODUCTION
SHUTDOWN_TYPE
ACTUAL_IPK
CRITICAL_TO_QUALITY
VALUE_ADDED
MACHINE_PROCESS_EFFICIENCY
LABOR_PROCESS_EFFICIENCY
CREATED_BY
TOTAL_PROCESS_EFFICIENCY
LONG_DESCRIPTION
CONFIG_ROUTING_ID
MODEL_OP_SEQ_ID
LOWEST_ACCEPTABLE_YIELD
USE_ORG_SETTINGS
QUEUE_MANDATORY_FLAG
RUN_MANDATORY_FLAG
TO_MOVE_MANDATORY_FLAG
SHOW_NEXT_OP_BY_DEFAULT
LAST_UPDATE_LOGIN
SHOW_SCRAP_CODE
SHOW_LOT_ATTRIB
TRACK_MULTIPLE_RES_USAGE_DATES
STANDARD_OPERATION_ID

Bills of Material - BOM_RTG_OPER_RES_TEMP
Column Name	Descritpion
ASSEMBLYITEMNAME
STANDARDRATEFLAG
ASSIGNEDUNITS
USAGERATEORAMOUNT
USAGERATEORAMOUNTINVERSE
BASISTYPE
SCHEDULEFLAG
RESOURCEOFFSETPERCENT
AUTOCHARGETYPE
SCHEDULESEQUENCENUMBER
PRINCIPLEFLAG
ORGANIZATIONCODE
ATTRIBUTECATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ALTERNATEROUTINGCODE
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ORIGINALSYSTEMREFERENCE
SETUPTYPE
SUBSTITUTEGROUPNUMBER
OPERATIONSEQUENCENUMBER
OPERATIONTYPE
STARTEFFECTIVEDATE
RESOURCESEQUENCENUMBER
RESOURCECODE
ACTIVITY

Bills of Material - BOM_EXPLOSION_TEMP_OLD	Temporary data for indented bills of material (batch processes)
Column Name	Descritpion
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
PLAN_LEVEL	Level in bill
HEADER_ID	System-generated identifier of order header
LINE_ID	System-generated identifier of order, configuration or shipment schedule line
LIST_PRICE	The price of the item on the price list
SELLING_PRICE	Actual price charged to customer
COMPONENT_YIELD_FACTOR	Component yield
ITEM_COST	Item unit cost
INCLUDE_IN_ROLLUP_FLAG	Flag indicating if component is to be used when rolling up costs
BASED_ON_ROLLUP_FLAG	Flag indicating whether cost will be rolled up
ACTUAL_COST_TYPE_ID	Actual cost type identifier
EXTENDED_QUANTITY	Extended quantity including quantity per, yield, and shrinkage
COMPONENT_QUANTITY	Quantity of component in bill of material
SHRINKAGE_RATE	Planned shrinkage rate
SO_BASIS	Quantity basis used by Oracle Order Management to determine how many units of component to put on an order
OPTIONAL	Flag indicating if component is optional in bill of material
MUTUALLY_EXCLUSIVE_OPTIONS	Flag indicating if one or more children of component can be picked when taking an order
CHECK_ATP	Flag indicating if ATP check is required
SHIPPING_ALLOWED	Flag indicating if component is allowed to ship
REQUIRED_TO_SHIP	Flag indicating if component is required to ship
REQUIRED_FOR_REVENUE	Flag indicating if component is required for revenue
INCLUDE_ON_SHIP_DOCS	Flag indicating if component is included on shipping documents
INCLUDE_ON_BILL_DOCS	Flag indicating if component is included on billing documents
LOW_QUANTITY	Minimum quantity allowed on an order
HIGH_QUANTITY	Maximum quantity allowed on an order
PICK_COMPONENTS	(not currently used)
PRIMARY_UOM_CODE	Unit of measure code of component
PRIMARY_UNIT_OF_MEASURE	Unit of measure of component
BASE_ITEM_ID	Base item identifier
ATP_COMPONENTS_FLAG	Flag indicating whether item may have components requiring ATP check
ATP_FLAG	Flag indicating ATP must be checked when item is ordered
BOM_ITEM_TYPE	Type of item
PICK_COMPONENTS_FLAG	Flag indicating all shippable components should be picked
REPLENISH_TO_ORDER_FLAG	Assemble to order flag
SHIPPABLE_ITEM_FLAG	Flag indicating shippable item
CUSTOMER_ORDER_FLAG	Flag indicating customer orderable item
INTERNAL_ORDER_FLAG	Flag indicating item has been internally ordered
CUSTOMER_ORDER_ENABLED_FLAG	Flag indicating item is customer orderable
INTERNAL_ORDER_ENABLED_FLAG	Flag indicating item can be internally ordered
SO_TRANSACTIONS_FLAG	Sales order transactions flag
MTL_TRANSACTIONS_ENABLED_FLAG	Flag indicating item is transactable
STOCK_ENABLED_FLAG	Flag indicating item is stockable
SORT_ORDER	Sorting sequence for the explosion
DESCRIPTION	Description
ASSEMBLY_ITEM_ID	Assembly item identifier
CONFIGURATOR_FLAG	Flag indicating if component is used by the configurator form
PRICE_LIST_ID	System-generated identifier of price list
ROUNDING_FACTOR	Rounding factor used to determine order quantity
PRICING_CONTEXT	Descriptive flexfield structure defining column
PRICING_ATTRIBUTE1	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE2	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE3	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE4	User defined attribute that adjusts the list price of an item
REQUEST_ID	Concurrent Who column
PRICING_ATTRIBUTE5	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE6	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE7	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE8	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE9	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE10	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE11	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE12	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE13	User defined attribute that adjusts the list price of an item
PRICING_ATTRIBUTE14	User defined attribute that adjusts the list price of an item
PROGRAM_APPLICATION_ID	Concurrent Who column
PRICING_ATTRIBUTE15	User defined attribute that adjusts the list price of an item
COMPONENT_CODE	Concatenation of component item identifiers
LOOP_FLAG	Indicates whether a loop is detected
INVENTORY_ASSET_FLAG	Flag indicating item is an inventory asset
PLANNING_FACTOR	Factor used to multiply component quantity with to obtain planning quantity
OPERATION_SEQ_NUM	Operation sequence number
PARENT_BOM_ITEM_TYPE	Parent item's bom item type
WIP_SUPPLY_TYPE	Supply type
ITEM_NUM	Item sequence within bill of material structure
EFFECTIVITY_DATE	Effective date
PROGRAM_ID	Concurrent Who column
DISABLE_DATE	Disable date
IMPLEMENTATION_DATE	Date on which engineering change order was implemented
SUPPLY_SUBINVENTORY	Supply subinventory
SUPPLY_LOCATOR_ID	Supply locator identifier
COMPONENT_REMARKS	Component remarks
CHANGE_NOTICE	Engineering change order number
OPERATION_LEAD_TIME_PERCENT	Operation offset from first operation in routing
REXPLODE_FLAG	Flag indicating whether to re-explode
COMMON_BILL_SEQUENCE_ID	Common bill of material unique identifier
PROGRAM_UPDATE_DATE	Concurrent Who column
PRIMARY_PATH_FLAG	Primary path flag
AUTO_REQUEST_MATERIAL	Auomatically create move order for the material at work order release
SUGGESTED_VENDOR_NAME	Used by direct items in EAM BOMs
TOP_BILL_SEQUENCE_ID	Bill identifier of level 0 items
VENDOR_ID	Used by direct items in EAM BOMs
UNIT_PRICE	Unit Price for direct items used by EAM BOMs
GROUP_ID	Explosion identifier
BILL_SEQUENCE_ID	Bill of material unique identifier
SESSION_ID	Session identifier
ORGANIZATION_ID	Organization identifier
COMPONENT_SEQUENCE_ID	Component unique identifier
SELECT_FLAG	Whether this component has been ordered
SELECT_QUANTITY	Order quantity
EXTEND_COST_FLAG	Whether to extend cost for this item
COMPONENT_ITEM_ID	Component item identifier
TOP_ALTERNATE_DESIGNATOR	Alternate designator for level 0
TOP_ITEM_ID	Item identifier of level 0 item
CONTEXT	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment

Bills of Material - BOM_CMP_USR_ATTR_INTERFACE	Bom Component User Attributes Interface Table
Column Name	Descritpion
DATA_SET_ID	An identifier for the collection of rows to be processed together; this value should correspond to the parent object's data set ID
STRUCTURE_TYPE_ID	The catalog group to which the Item belongs, derived from ORGANIZATION_ID and INVENTORY_ITEM_ID (user should not populate)
TRANSACTION_ID	A user-specified identifier (e.g., a spreadsheet row number) against which errors for each row will be logged
ROW_IDENTIFIER	An identifier for the collection of rows that make up one logical Attribute Group Row
ATTR_GROUP_ID	Identifier for the Attribute Group, derived from ATTR_GROUP_INT_NAME (foreign key to EGO_FND_DSC_FLX_CTX_EXT)
ATTR_GROUP_INT_NAME	The internal name for the Attribute Group
ATTR_INT_NAME	The internal name for the Attribute
ATTR_VALUE_STR	The Attribute value, if its data type is String
ATTR_VALUE_NUM	The Attribute value, if its data type is Number
ATTR_VALUE_DATE	The Attribute value, if its data type is Date
ATTR_DISP_VALUE	The Attribute value in its user-friendly form; used mainly for Attributes with Value Sets of validation type Independent or Table
PROCESS_STATUS	Whether this row is to be processed, being processed, encountered an error, or was processed successfully
REQUEST_ID	Identifier for the request that starts the concurrent program that processes the row
PROGRAM_APPLICATION_ID	Identifier for the application that owns the concurrent program that processes the row
PROGRAM_ID	Identifier for the concurrent program that processes the row
PROGRAM_UPDATE_DATE	Time when the row was last updated by a concurrent program
CREATED_BY	One of the five standard "WHO" columns
CREATION_DATE	One of the five standard "WHO" columns
LAST_UPDATED_BY	One of the five standard "WHO" columns
LAST_UPDATE_DATE	One of the five standard "WHO" columns
LAST_UPDATE_LOGIN	One of the five standard "WHO" columns
ATTR_GROUP_TYPE	Attribute group type
SOURCE_SYSTEM_ID	Source system identifier
COMP_SOURCE_SYSTEM_REFERENCE	Component source system reference
TRANSACTION_TYPE	Whether this row is to be part of a CREATE, UPDATE, SYNC, or DELETE operation
BATCH_ID	Batch identifier
BILL_SEQUENCE_ID	Bill sequence id
INTERFACE_TABLE_UNIQUE_ID	Interface Table Unique Id for Merge
ATTR_UOM_DISP_VALUE	Attribute UOM Display value
ATTR_VALUE_UOM	Attribute Value UOM
ASSEMBLY_ITEM_NUMBER	Assembly Item Number
PARENT_SOURCE_SYSTEM_REFERENCE	Parent Source System Reference
COMPONENT_ITEM_ID	Component item identifier
DATA_LEVEL_ID
DATA_LEVEL_NAME
USER_DATA_LEVEL_NAME
ORGANIZATION_CODE	An identifier for the Organization to which the Item belongs; populate this column if ORGANIZATION_ID \is unknown
ORGANIZATION_ID	The internal identifier for the Organization; if this column and ORGANIZATION_CODE are both populated, this column's value determines the Org
ITEM_NUMBER	An identifier for the Item composed of its Concatenated Segments
COMPONENT_SEQUENCE_ID	The internal identifier for the Item (populate this value to speed up processing); if this column and ITEM_NUMBER are both populated, this column's value identifies the Item

Bills of Material - BOM_RESOURCE_DOWNCODES	BOM_RESOURCE_DOWNCODES stores resource downcodes information.You will be able to specify multiple downcodes for each resource.
Column Name	Descritpion
DOWNCODE	Resource Downcode
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
CREATED_BY	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
RESOURCE_ID	Resource unique identifier

Bills of Material - BOM_STD_OP_SCRAP_CODES	Standard Operation Scrap Codes
Column Name	Descritpion
STANDARD_OPERATION_ID	Standard Operation Unique Identtifier
SEQUENCE_NUM	Sequence number of the scrap code assigned
SCRAP_CODE	Scrap code
MAX_ACCEPTABLE_SCRAP_QTY	Maximum acceptable scrap quantity
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column

Bills of Material - BOM_STD_OP_RESP_EXCLUSIONS	Standard Operation responsibility exclusions
Column Name	Descritpion
STANDARD_OPERATION_ID	Standard Operation Unique Identifier
RESPONSIBILITY_ID	Responsibility Unique Identifier
APPLICATION_ID	Application to which the current responsibility belongs to
CREATED_BY	Standard who columns
CREATION_DATE	Standard who columns
LAST_UPDATED_BY	Standard who columns
LAST_UPDATE_DATE	Standard who columns
LAST_UPDATE_LOGIN	Standard who columns

Bills of Material - BOM_STD_OP_BONUS_CODES	Standard Operation Bonus codes
Column Name	Descritpion
SEQUENCE_NUMBER	Sequence Number of the bonus code
BONUS_CODE	Bonus code
CREATED_BY	Standard WHO Column
LAST_UPDATE_DATE	Standard WHO Column
STANDARD_OPERATION_ID	Standard operation unique identifier
LAST_UPDATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column

Bills of Material - BOM_COPY_STRUCTURE_REQUEST
Column Name	Descritpion
COPY_REQUEST_ID	Unique Identifier of the copy request
SRC_FROM_END_ITEM_MNR_REV_ID	End Item Minor Revision for the source structure to filter the components
SRC_TO_END_ITEM_REV_ID	End Item Revision for the source structure to filter the components
SRC_TO_END_ITEM_MNR_REV_ID	End Item Minor Revision for the source structure to filter the components
SRC_FILTER	Effectivity Filter for source structure
SRC_ECO_FILTER	ECO Filter for source structure
SRC_BILL_SEQUENCE_ID	Bill Sequence Id of the source structure
SRC_STRUCTURE_TYPE_ID	Structure Typd Id of the source structure
SRC_EFFECTIVITY_CONTROL	Effectivity Control of the source structure
TRGT_ORG_ID	Target Structure's organization id
TRGT_ITEM_ID	Target Structure's Item Id
SRC_ORG_ID	Source Structure's Organization Id
TRGT_ITEM_REV_ID	Target Structure's Item Revision Id
TRGT_STRUCTURE_NAME	Target Structure's structure name
TRGT_EFFECTIVITY_DATE	Target structure's effectivity date for component
TRGT_FROM_END_ITEM_UNIT_NUMBER	Target structure's end item unit number for components
TRGT_TO_END_ITEM_UNIT_NUMBER	Target structure's end item unit number for components
TRGT_FROM_END_ITEM_REV_ID	Target structure's end item revision for components
TRGT_FROM_END_ITEM_MNR_REV_ID	Target structure's end item minor revision for components
TRGT_TO_END_ITEM_REV_ID	Target structure's end item revision for components
TRGT_TO_END_ITEM_MNR_REV_ID	Target structure's end item revision for components
TRGT_BILL_SEQUENCE_ID	Target structure's bill sequence id
SRC_ITEM_ID	Source Structure's Item Id
TRGT_STRUCTURE_TYPE_ID	Target structure's structure type id
TRGT_EFFECTIVITY_CONTROL	Target structure's effectivity control
TRGT_STRUCTURE_DESCRIPTION	Target Structure's Description
LEVELS_TO_COPY	Number of levels to copy
CPY_EXCLUSIONS	Flag to specify whether exclusions needs to be copied or not
CPY_ROUTINGS	Flag to specify whether routings needs to be copied or not
CPY_STRUCTURE_ATTRIBUTES	Flag to specify whether structure attributes needs to be copied or not
CPY_COMPONENT_ATTRIBUTES	Flag to specify whether component attributes needs to be copied or not
CPY_STRUCTURE_ATTACHMENTS	Flag to specify whether structure attachments needs to be copied or not
CPY_REFERENCE_DESIGNATORS	Flag to specify whether reference designators needs to be copied or not
CPY_SUBSTITUTE_COMPONENTS	Flag to specify whether substitute components needs to be copied or not
SRC_ITEM_REV_ID	Source Structure's Item Revision Id
CPY_COMPONENT_OPERATIONS	Flag to specify whether component operations needs to be copied or not
REQUEST_STATUS	Copy Request Status
ORG_HIERARCHY_NAME	Organization Hierarchy Name for the copy criteria.
ORG_HIERARCHY_ID	Organization Hierarchy Id of the copy criteria.
CHANGE_NOTICE	Copy Operation will create change notice with this name.
CHANGE_ID	Change Id of the Change Order to which the revised items of this copy operation will be added.
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Request Column
PROGRAM_APPLICATION_ID	Standard Request Column
PROGRAM_ID	Standard Request Column
SRC_STRUCTURE_NAME	Source Structure's structure name
PROGRAM_UPDATE_DATE	Standard Request Column
SRC_EXPLOSION_DATE	Explosion Date for the source structure
SRC_FROM_END_ITEM_UNIT_NUMBER	End Item Unit Number for the source structure to filter the components
SRC_TO_END_ITEM_UNIT_NUMBER	End Item Unit Number for the source structure to filter the components
SRC_FROM_END_ITEM_REV_ID	End Item Revision for the source structure to filter the components

Bills of Material - BOM_COPY_STRUCTURE_ACTIONS
Column Name	Descritpion
COPY_REQUEST_ID	Copy Request Id of the copy operation
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Request Column
PROGRAM_APPLICATION_ID	Standard Request Column
PROGRAM_ID	Standard Request Column
PROGRAM_UPDATE_DATE	Standard Request Column
ORGANIZATION_ID	Copy Request Id of the copy operation
COMPONENT_SEQUENCE_ID	Component Sequence Id of the component for which the exception action needs to be taken
COMPONENT_EXCEPTION_ACTION	Component Exception which needs to be taken for the component
STRUCTURE_EXCEPTION_ACTION	Structure Exception which needs to be taken for the component if it is a sub-assembly
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column

Bills of Material - BOM_COPY_ORGANIZATION_LIST	List of Organization to which the source structure is getting copied
Column Name	Descritpion
COPY_REQUEST_ID	Copy Request Id of the copy operation
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID
PROGRAM_APPLICATION_ID	Standard Request Column
PROGRAM_ID	Standard Request Column
PROGRAM_UPDATE_DATE	Standard Request Column
ORGANIZATION_ID	Organization Id of the organization to which the source structure needs to be copied
COMMON_STRUCTURE	Flag which specifies whether common structure needs to be created.
EFFECTIVITY_DATE	Effectvity Date of the target structure Components
FROM_END_ITEM_UNIT_NUMBER	Effectivity Unit Number for target unit effective structures
FROM_END_ITEM_REV_ID	From End Item Rev Id for End Item Revision Effective components
ASSEMBLY_TYPE	Target structure's assembly type in this organization
CREATED_BY	CREATED_BY
CREATION_DATE	Standard Who Column

Bills of Material - BOM_EXCLUSION_RULE_DEF
Column Name	Descritpion
RULE_ID	Foreign key for the rule header table.
LAST_UPDATE_LOGIN	Standard WHO coloumn
REQUEST_ID	Standard WHO coloumn
PROGRAM_APPLICATION_ID	Standard WHO coloumn
PROGRAM_ID	Standard WHO coloumn
PROGRAM_UPDATE_DATE	Standard WHO coloumn
ATTRIBUTE_CATEGORY	Standard DFF Column
ATTRIBUTE1	Standard DFF Column
ATTRIBUTE2	Standard DFF Column
ATTRIBUTE3	Standard DFF Column
ATTRIBUTE4	Standard DFF Column
EXCLUSION_PATH	It holds the path of the component to be excluded.
ATTRIBUTE5	Standard DFF Column
ATTRIBUTE6	Standard DFF Column
ATTRIBUTE7	Standard DFF Column
ATTRIBUTE8	Standard DFF Column
ATTRIBUTE9	Standard DFF Column
ATTRIBUTE10	Standard DFF Column
ATTRIBUTE11	Standard DFF Column
ATTRIBUTE12	Standard DFF Column
ATTRIBUTE13	Standard DFF Column
ATTRIBUTE14	Standard DFF Column
RULE_SEQUENCE	Sequence Number
ATTRIBUTE15	Standard DFF Column
CHANGE_ID	Change ID value
ACD_TYPE	ACD Type Value ( Add -1 , Change -2 & Delete -3)
IMPLEMENTATION_DATE	Implementation Date
DISABLE_DATE	Disable Date
FROM_REVISION_ID	From Revision Id
TO_REVISION_ID	To Revision Id
APPLY_TO_PENDING_CHANGES	Apply To Pending Changes
ENABLED_FLAG	It holds the value of whether this exclusion rule is enabled or not
LAST_UPDATE_DATE	Standard WHO coloumn
LAST_UPDATED_BY	Standard WHO coloumn
CREATION_DATE	Standard WHO coloumn
CREATED_BY	Standard WHO coloumn

Bills of Material - BOM_EXCLUSION_RULE_ARCHIVE
Column Name	Descritpion
RULE_ID	Foreign key for the rule header table.
LAST_UPDATE_LOGIN	Standard WHO coloumn
REQUEST_ID	Standard WHO coloumn
PROGRAM_APPLICATION_ID	Standard WHO coloumn
PROGRAM_ID	Standard WHO coloumn
PROGRAM_UPDATE_DATE	Standard WHO coloumn
ATTRIBUTE_CATEGORY	Standard DFF Column
ATTRIBUTE1	Standard DFF Column
ATTRIBUTE2	Standard DFF Column
ATTRIBUTE3	Standard DFF Column
ATTRIBUTE4	Standard DFF Column
EXCLUSION_PATH	It holds the path of the component to be excluded.
ATTRIBUTE5	Standard DFF Column
ATTRIBUTE6	Standard DFF Column
ATTRIBUTE7	Standard DFF Column
ATTRIBUTE8	Standard DFF Column
ATTRIBUTE9	Standard DFF Column
ATTRIBUTE10	Standard DFF Column
ATTRIBUTE11	Standard DFF Column
ATTRIBUTE12	Standard DFF Column
ATTRIBUTE13	Standard DFF Column
ATTRIBUTE14	Standard DFF Column
RULE_SEQUENCE	Sequence Number
ATTRIBUTE15	Standard DFF Column
CHANGE_ID	Change ID value
ACD_TYPE	ACD Type Value ( Add -1 , Change -2 & Delete -3)
IMPLEMENTATION_DATE	Implementation Date
DISABLE_DATE	Disable Date
FROM_REVISION_ID	From Revision Id
TO_REVISION_ID	To Revision Id
APPLY_TO_PENDING_CHANGES	Apply To Pending Changes
ENABLED_FLAG	It holds the value of whether this exclusion rule is enabled or not
LAST_UPDATE_DATE	Standard WHO coloumn
LAST_UPDATED_BY	Standard WHO coloumn
CREATION_DATE	Standard WHO coloumn
CREATED_BY	Standard WHO coloumn

Bills of Material - BOM_RULES_B
Column Name	Descritpion
RULE_ID	Rule ID, which uniquely identifies the Rule.
LAST_UPDATE_LOGIN	Standard WHO coloumn
REQUEST_ID	Standard WHO coloumn
PROGRAM_APPLICATION_ID	Standard WHO coloumn
PROGRAM_ID	Standard WHO coloumn
PROGRAM_UPDATE_DATE	Standard WHO coloumn
ATTRIBUTE_CATEGORY	Standard DFF Column
ATTRIBUTE1	Standard DFF Column
ATTRIBUTE2	Standard DFF Column
ATTRIBUTE3	Standard DFF Column
ATTRIBUTE4	Standard DFF Column
RULE_NAME	Name of the rule.
ATTRIBUTE5	Standard DFF Column
ATTRIBUTE6	Standard DFF Column
ATTRIBUTE7	Standard DFF Column
ATTRIBUTE8	Standard DFF Column
ATTRIBUTE9	Standard DFF Column
ATTRIBUTE10	Standard DFF Column
ATTRIBUTE11	Standard DFF Column
ATTRIBUTE12	Standard DFF Column
ATTRIBUTE13	Standard DFF Column
ATTRIBUTE14	Standard DFF Column
BILL_SEQUENCE_ID	Structure's primary key.
ATTRIBUTE15	Standard DFF Column
CHANGE_ID	Change ID, which uniquely identifies the ECO
IMPLEMENTATION_DATE	Implementation Date
EFFECTIVE_DATE	Effective Date
DISABLE_DATE	Disable Date
LAST_UPDATE_DATE	Standard WHO coloumn
LAST_UPDATED_BY	Standard WHO coloumn
CREATION_DATE	Standard WHO coloumn
CREATED_BY	Standard WHO coloumn

Bills of Material - BOM_OPERATION_SKILLS	Skills for Operations
Column Name	Descritpion
LEVEL_ID	Level Id
ORGANIZATION_ID	Organization Id
OPERATION_SEQUENCE_ID	Operation Sequence Id
STANDARD_OPERATION_ID	STANDARD_OPERATION_ID
RESOURCE_ID	RESOURCE_ID
COMPETENCE_ID	COMPETENCE_ID
RATING_LEVEL_ID	RATING_LEVEL_ID
QUALIFICATION_TYPE_ID	QUALIFICATION_TYPE_ID
LAST_UPDATE_DATE	LAST_UPDATE_DATE
LAST_UPDATED_BY	LAST_UPDATED_BY
LAST_UPDATE_LOGIN	LAST_UPDATE_LOGIN
CREATED_BY	CREATED_BY
CREATION_DATE	CREATION_DATE

Bills of Material - BOM_COMP_ATTR_CTX_ASSOCS_B
Column Name	Descritpion
CONTEXT_ID
FROM_REVISION_ID
TO_REVISION_ID
FROM_REVISION_CODE
TO_REVISION_CODE
ATTRIBUTES_LIST
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
EXTENSION_ID
OBJECT_VERSION_NUMBER
BASE_EXTENSION_ID
COMPONENT_SEQUENCE_ID
BILL_SEQUENCE_ID
TOP_BILL_SEQUENCE_ID
STRUCTURE_TYPE_ID
ATTR_GROUP_ID
COMPONENT_CODE

Bills of Material - BOM_CTO_ORDER_LINES_GT
Column Name	Descritpion
ATO_LINE_ID
LINK_TO_LINE_ID
ORDERED_QUANTITY
QTY_PER_PARENT_MODEL
ORDER_QUANTITY_UOM
PARENT_ATO_LINE_ID
GOP_PARENT_ATO_LINE_ID
PERFORM_MATCH
PLAN_LEVEL
SCHEDULE_SHIP_DATE
SHIP_FROM_ORG_ID
BATCH_ID
TOP_MODEL_LINE_ID
WIP_SUPPLY_TYPE
HEADER_ID
OPTION_SPECIFIC
REUSE_CONFIG
OSS_ERROR_CODE
CONFIG_CREATION
STATUS
SEQUENCE
LAST_UPDATE_DATE
BOM_ITEM_TYPE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
VALIDATION_ORG
COMPONENT_CODE
COMPONENT_SEQUENCE_ID
CONFIG_ITEM_ID
INVENTORY_ITEM_ID
ITEM_TYPE_CODE
LINE_ID

Bills of Material - BOM_CTO_SRC_ORGS_GT
Column Name	Descritpion
CONFIG_ITEM_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
LAST_UPDATE_DATE
ORGANIZATION_ID
RCV_ORG_ID
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID

Bills of Material - BOM_ODI_WS_ENTITIES
Column Name	Descritpion
SESSION_ID
EXPLOSION_OPTION
STRUCTURE_NAME
CREATION_DATE
CREATED_BY
SEQUENCE_NUMBER
PUBLISH_FLAG
ROOT_NODE_ID
ODI_SESSION_ID
ITEM_ID
ITEM_ORG_ID
ITEM_REV
ITEM_REV_CODE
ITEM_UNIT_NUMBER
GROUP_ID
EXPLOSION_DATE

Bills of Material - BOM_ODI_WS_REVISIONS
Column Name	Descritpion
SESSION_ID
PUBLISH_FLAG
SEQUENCE_NUMBER
ROW_ID
REVISION
REVISION_ID
REVISION_LABEL
REVISION_HIGH_DATE
PARENT_REVISION
CREATION_DATE
CREATED_BY

Bills of Material - BOM_TA_VAL_EXCLUSION_DEF_B
Column Name	Descritpion
SEQUENCE_NUMBER
OBJECT_VERSION_NUMBER
EXCLUSION_RULE_ID
EXCLUDED_VALUE
USER_ENETERED
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN

Bills of Material - BOM_TA_VAL_EXCLUSION_RULES_B
Column Name	Descritpion
EXCLUSION_RULE_ID
TOP_ITEM_REV_CODE_FROM
TOP_ITEM_REV_CODE_TO
ORGANIZATION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
TOP_BILL_SEQUENCE_ID
COMPONENT_CODE
TRANSACTION_ATTRIBUTE_ID
VALUE_SET_ID
PARENT_BILL_SEQ_ID
COMPONENT_ITEM_ID
TOP_ITEM_REV_ID_FROM
TOP_ITEM_REV_ID_TO