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

Bills of Material - CST_COST_TYPES	Stores cost type definitions
Column Name	Descritpion
COST_TYPE_ID	Cost type identifier
COSTING_METHOD_TYPE	Costing method used, standard or average
FROZEN_STANDARD_FLAG	Whether it is frozen standard cost type or not
DEFAULT_COST_TYPE_ID	Cost type identifier used as the default cost type when rolling up costs
BOM_SNAPSHOT_FLAG	Whether to save the bill structure when rolling up costs
ALTERNATE_BOM_DESIGNATOR	Alternate designator
ALLOW_UPDATES_FLAG	Whether the costs defined for this cost type can be changed
PL_ELEMENT_FLAG	Whether to group previous level cost by cost element
PL_RESOURCE_FLAG	Whether to group previous level cost by subelement
PL_OPERATION_FLAG	Whether to group previous level cost by operation sequence number
PL_ACTIVITY_FLAG	Whether to group previous level cost by activity
LAST_UPDATE_DATE	Standard Who column
DISABLE_DATE	Inactive On/After
AVAILABLE_TO_ENG_FLAG	Whether the set of cost for this cost type is available for Oracle Engineering
COMPONENT_YIELD_FLAG	Whether to consider component yield factor when rolling up costs
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_UPDATED_BY	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
REQUEST_ID	Concurrent Who column
CREATION_DATE	Standard Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORGANIZATION_ID	Organization identifier
COST_TYPE	Cost type name
DESCRIPTION	Description

Bills of Material - CST_ACTIVITIES	Activity definition associated with activity costing
Column Name	Descritpion
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ACTIVITY	Activity name
ORGANIZATION_ID	Organization identifier
DESCRIPTION	Description
ACTIVITY_ID	Activity identifier
DEFAULT_BASIS_TYPE	Default basis for the activity
DISABLE_DATE	Date activity becomes inactive
OUTPUT_UOM	Activity measurement unit
VALUE_ADDED_ACTIVITY_FLAG	Flag indicating whether the activity adds value
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
LAST_UPDATE_DATE	Standard Who column
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
LAST_UPDATED_BY	Standard Who column
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
CREATION_DATE	Standard Who column

Bills of Material - CST_ITEM_COST_DETAILS	Item cost detail information
Column Name	Descritpion
CREATION_DATE	Standard Who column
SOURCE_ORGANIZATION_ID	Source organization identifier
VENDOR_ID	Vendor identifier
CREATED_BY	Standard Who column
ALLOCATION_PERCENT	Allocation percentage
VENDOR_SITE_ID	Vendor site identifier
LAST_UPDATE_LOGIN	Standard Who column
SHIP_METHOD	Shipping method
OPERATION_SEQUENCE_ID	Operation sequence identifier
OPERATION_SEQ_NUM	Operation sequence number in a routing
INVENTORY_ITEM_ID	Inventory item identifier
DEPARTMENT_ID	Department identifier
LEVEL_TYPE	Level at which cost is incurred
ACTIVITY_ID	Activity identifier
RESOURCE_SEQ_NUM	Resource sequence number in an operation
ORGANIZATION_ID	Organization identifier
RESOURCE_ID	Resource identifier (sub-element)
RESOURCE_RATE	Resource unit cost
ITEM_UNITS	Number of item units the activity cost is applied to
ACTIVITY_UNITS	Number of activity units applied to the item cost
USAGE_RATE_OR_AMOUNT	Number of resource units, overhead rate, or activity unit cost per basis
COST_TYPE_ID	Cost type identifier
BASIS_TYPE	Basis
BASIS_RESOURCE_ID	Resource identifier that the resource overhead is based on
BASIS_FACTOR	Basis factor
NET_YIELD_OR_SHRINKAGE_FACTOR	Item shrinkage factor computed from the item shrinkage
ITEM_COST	Item unit cost
COST_ELEMENT_ID	Cost element identifier
ROLLUP_SOURCE_TYPE	Cost source
ACTIVITY_CONTEXT	Structure defining column for the Activity Unit Information
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
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
LAST_UPDATED_BY	Standard Who column
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
YIELDED_COST	The yield cost as computed by the rollup process for WSM enabled organizations

Bills of Material - CST_DEPARTMENT_OVERHEADS	Department overhead cost definition
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORGANIZATION_ID	Organization identifier
BASIS_TYPE	Basis
DEPARTMENT_ID	Department identifier
RATE_OR_AMOUNT	Rate or amount for the overhead sub element
ACTIVITY_ID	Activity 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
COST_TYPE_ID	Cost type 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
OVERHEAD_ID	Overhead sub-element identifier
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
LAST_UPDATE_DATE	Standard Who column

Bills of Material - CST_ACTIVITY_COSTS	Cost associated with the activity
Column Name	Descritpion
ACTIVITY_ID	Activity identifier
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
TOTAL_COST	Total expected cost for the activity
TOTAL_ACTIVITY_UNITS	The total expected number of activity occurrences
UNIT_COST	Total unit cost
COST_TYPE_ID	Cost type identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ORGANIZATION_ID	Organization identifier
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
REQUEST_ID	Concurrent 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
CREATION_DATE	Standard Who column

Bills of Material - CST_RESOURCE_COSTS	Resource and outside processing resource cost definition
Column Name	Descritpion
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORGANIZATION_ID	Organization identifier
RESOURCE_RATE	Resource unit cost
RESOURCE_ID	Resource identifier (sub element)
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
COST_TYPE_ID	Cost type 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
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Bills of Material - CST_RESOURCE_OVERHEADS	Resource that an overhead is applied to
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ORGANIZATION_ID	Organization identifier
COST_TYPE_ID	Cost type 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
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
ATTRIBUTE5	Descriptive Flexfield segment
RESOURCE_ID	Resource identifier (subelement)
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
OVERHEAD_ID	Overhead subelement identifier
LAST_UPDATE_DATE	Standard Who column

Bills of Material - CST_ITEM_COSTS	Item cost summary
Column Name	Descritpion
LAST_UPDATE_DATE	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
LAST_UPDATED_BY	Standard Who column
ROLLUP_ID	Supply Chain Rollup identifier
ASSIGNMENT_SET_ID	MRP assignment set identifier used in Supply Chain Rollup
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
INVENTORY_ASSET_FLAG	Flag indicating whether the item is asset or expense
LOT_SIZE	Lot Size
BASED_ON_ROLLUP_FLAG	Flag indicating whether cost is to be rolled up
SHRINKAGE_RATE	Manufacturing shrinkage rate (for make item only)
DEFAULTED_FLAG	Flag indicating whether the cost of the item is defaulted from the default cost type during cost rollup
COST_UPDATE_ID	Cost update session identifier
PL_MATERIAL	Previous level material cost
PL_MATERIAL_OVERHEAD	Previous level material overhead cost
PL_RESOURCE	Previous level resource cost
PL_OUTSIDE_PROCESSING	Previous level outside processing cost
INVENTORY_ITEM_ID	Inventory item identifier
PL_OVERHEAD	Previous level overhead cost
TL_MATERIAL	This level material cost
TL_MATERIAL_OVERHEAD	This level material overhead cost
TL_RESOURCE	This level resource cost
TL_OUTSIDE_PROCESSING	This level outside processing cost
TL_OVERHEAD	This level overhead cost
MATERIAL_COST	Material cost
MATERIAL_OVERHEAD_COST	Material overhead cost
RESOURCE_COST	Resource cost
OUTSIDE_PROCESSING_COST	Outside Processing cost
ORGANIZATION_ID	Organization identifier
OVERHEAD_COST	Overhead cost
PL_ITEM_COST	Total previous level cost
TL_ITEM_COST	Total this level cost
ITEM_COST	Item unit cost
UNBURDENED_COST	Item unit cost minus this level material overhead
BURDEN_COST	This level material overhead
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
COST_TYPE_ID	Cost type 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

Bills of Material - CST_REPORT_TYPES	Column selection option for item cost report
Column Name	Descritpion
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REPORT_NAME	Report option name
REPORT_TITLE	Report option title
DESCRIPTION	Description
USER_DEFINED	Flag to indicate if this is a user-defined or seeded option
UNIQUE_ID	Unique identifier for report name
COLUMN1_HEADING	The displayed column heading for the first column
COLUMN2_HEADING	The displayed column heading for the second column
COLUMN3_HEADING	Not currently used
COLUMN4_HEADING	Not currently used
COLUMN1	Source of the information for column 1
COLUMN2	Source of the information for column 2
COLUMN3	Not currently used
COLUMN4	Not currently used
INVENTORY_FLAG	Flag to indicate if available in standalone inventory installation
LAST_UPDATE_DATE	Standard Who column
DISABLE_DATE	Inactive On/After
FLEXFIELD_APPLICATION_ID	Application identifier
DESCRIPTIVE_FLEXFIELD_NAME	Descriptive Flexfield name
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
REQUEST_ID	Concurrent Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Bills of Material - CST_MASS_EDITS	Item cost mass edit historical information
Column Name	Descritpion
MASS_EDIT_ID	Mass edit identifier
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Description
USER_DEFINED	Flag indicating whether this mass edit procedure is user-defined
CONCURRENT_PROGRAM	Concurrent program name to run the mass edit
MASS_EDIT_NAME	Mass edit name
PROCEDURE_NAME	Stored procedure name to run the mass edit
INVENTORY_FLAG	Not currently used
DISABLE_DATE	Inactive On/After
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
REQUEST_ID	Concurrent Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Bills of Material - CST_COST_UPDATES	Cost update history
Column Name	Descritpion
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
STATUS	Status of the cost update program
ORGANIZATION_ID	Organization identifier
COST_TYPE_ID	Cost type identifier
COST_UPDATE_ID	Cost update session identifier
UPDATE_DATE	Cost update session start time
DESCRIPTION	Description
RANGE_OPTION	Item range option
UPDATE_RESOURCE_OVHD_FLAG	Flag indicating whether resource and overhead costs should be updated
UPDATE_ACTIVITY_FLAG	Flag indicating whether activity cost should be updated
SNAPSHOT_SAVED_FLAG	Flag indicating whether adjustment details should be saved
INV_ADJUSTMENT_ACCOUNT	Code combination identifier for the inventory adjustment account
SINGLE_ITEM	Inventory item identifier
ITEM_RANGE_LOW	Inventory item range from
ITEM_RANGE_HIGH	Inventory item range to
LAST_UPDATE_DATE	Standard Who column
CATEGORY_ID	Category identifier
CATEGORY_SET_ID	Category set identifier
INVENTORY_ADJUSTMENT_VALUE	Adjustment total for on-hand inventories
INTRANSIT_ADJUSTMENT_VALUE	Adjustment total for intransit inventories
WIP_ADJUSTMENT_VALUE	Adjustment total for Work in Process
SCRAP_ADJUSTMENT_VALUE	Adjustment total for scrap
REQUEST_ID	Concurrent 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
CREATION_DATE	Standard Who column

Bills of Material - CST_ELEMENTAL_COSTS	Standard elemental cost history
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
COST_UPDATE_ID	Cost update session identifier
STANDARD_COST	Elemental cost for the cost element after cost update
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ORGANIZATION_ID	Organization identifier
INVENTORY_ITEM_ID	Inventory item identifier
COST_ELEMENT_ID	Cost element identifier

Bills of Material - CST_COST_ELEMENTS	Cost elements definition
Column Name	Descritpion
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
COST_ELEMENT	Cost element name
DESCRIPTION	Description
REQUEST_ID	Concurrent Who column
COST_ELEMENT_ID	Cost element identifier
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Bills of Material - CST_COST_TYPE_HISTORY	Cost rollups information and cost type purge information
Column Name	Descritpion
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ROLLUP_ID	Rollup identifier
ROLLUP_DATE	Cost Rollup run date
REPORT_OPTION	Report option
COST_TYPE_ID	Cost type identifier
REPORT_TYPE	Report type
ROLLUP_OPTION	Rollup option, full or single level rollup
RANGE	Range option
REVISION_DATE	Effective date of the assembly
UNIMPLEMENTED_ECN_FLAG	Included unimplemented ECN in the cost type or not
ALTERNATE_BOM_DESIGNATOR	Alternate designator
ALTERNATE_RTG_DESIGNATOR	Alternate routing designator
ENGINEERING_FLAG	Include engineering bills or not
INVENTORY_ITEM_ID	Inventory item identifier
CATEGORY_SET_ID	Category set identifier
CATEGORY_ID	Category identifier
CATEGORY	Category name
ORGANIZATION_ID	Organization identifier
RANGE_LOW	Inventory item from value
RANGE_HIGH	Inventory item to value
PURGE_DATE	Date the cost type was deleted
PURGE_OPTION	Purge option
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
REQUEST_ID	Concurrent Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Bills of Material - CST_DISTRIBUTION_MASTER	WIP resource transaction seeded data
Column Name	Descritpion
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DISTRIBUTION_TYPE	Distribution type
ACCOUNTING_LINE_TYPE	Accounting line type
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Bills of Material - CST_INQUIRY_TEMP	Temporary table for item cost inquiry
Column Name	Descritpion
OPERATION_SEQUENCE_ID	Operation sequence identifier
DEPARTMENT_ID	Department identifier
ACTIVITY_ID	Activity identifier
RESOURCE_ID	Resource identifier (subelement)
ITEM_COST	Item unit cost
SESSION_ID	Oracle session identifier
COST_ELEMENT_ID	Cost element identifier
THIS_LEVEL_COSTS	This level cost
PREVIOUS_LEVEL_COSTS	Previous level cost
COLUMN1_VALUE_2A	Column 1 value for the Summary By Level template in the View Item Cost information
COLUMN2_VALUE_2A	Column 2 value for the Summary By Level template in the View Item Cost information
COLUMN1_VALUE_2B	Column 1 value for the Summary template in the View Item Cost information
COLUMN2_VALUE_2B	Column 2 value for the Summary template in the View Item Cost information
YIELDED_COSTS	Inflation in item cost for operation yield in WSM organizations
DESCRIPTION_COLUMN	Column 3 value for the Summary template in the View Item Cost information
VALUE_ADDED_ACTIVITY_FLAG	Not currently used
GUI_COLUMN1	Activity
GUI_COLUMN2	Department code
GUI_DESCRIPTION	Description
INVENTORY_ITEM_ID	Inventory item identifier
ORGANIZATION_ID	Organization identifier
COST_TYPE_ID	Cost type identifier
OPERATION_SEQ_NUM	Operation sequence number in a routing

Bills of Material - CST_INQUIRY_TYPES	Types of item cost inquiry
Column Name	Descritpion
UNIQUE_ID	Unique identifier for the inquiry name
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
INQUIRY_NAME	Cost type detail option
DESCRIPTION	Inquiry option description
USER_DEFINED	User defined option
TEMPLATE_TYPE	No longer used
GUI_TEMPLATE_TYPE	Template type
VIEW_NAME	Name of view to be copied into CST_INQUIRY_TEMP
COLUMN1_HEADING	No longer used
COLUMN2_HEADING	No longer used
DESCRIPTION_COLUMN_HEADING	No longer used
GUI_COL1_PROMPT_TOP	First line of column heading for GUI_COL1
GUI_COL1_PROMPT_BOTTOM	Second line of column heading for GUI_COL1
GUI_COL2_PROMPT_TOP	First line of column heading for GUI_COL2
GUI_COL2_PROMPT_BOTTOM	Second line of column heading for GUI_COL2
GUI_DESC_PROMPT	Column heading for description column
INVENTORY_FLAG	Stand-alone inventory installation
LAST_UPDATE_DATE	Standard Who column
DISABLE_DATE	Inactive On/After
FLEXFIELD_APPLICATION_ID	Application identifier
DESCRIPTIVE_FLEXFIELD_NAME	Descriptive Flexfield name
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
REQUEST_ID	Concurrent Who column
CHAR_GUI_AVAILABLE	Flag to determine which version of the application the view could appear in
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Bills of Material - CST_ITEM_COSTS_INTERFACE	Open interface table for item cost information
Column Name	Descritpion
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
TRANSACTION_ID	Transaction identifier
CREATION_DATE	Standard Who column
PROCESS_FLAG	Not currently used
ITEM_NUMBER	Not currently used
TRANSACTION_TYPE	Transaction type
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
INVENTORY_ASSET_FLAG	Flag indicating whether the item is asset or expense
INVENTORY_ITEM_ID	Inventory item identifier
ORGANIZATION_CODE	Organization code
COST_TYPE	Cost type name
INVENTORY_ITEM	Concatenated inventory item segments
GROUP_ID	Group identifier
LOT_SIZE	Lot size
BASED_ON_ROLLUP_FLAG	Flag indicating whether costs should be rolled up
SHRINKAGE_RATE	Manufacturing shrinkage rate (for make item only)
DEFAULTED_FLAG	Flag indicating whether the cost of the item is defaulted from the default cost type during cost roll up
COST_UPDATE_ID	Cost update session identifier
PL_MATERIAL	Previous level material cost
ORGANIZATION_ID	Organization identifier
PL_MATERIAL_OVERHEAD	Previous level material overhead cost
PL_RESOURCE	Previous level resource cost
PL_OUTSIDE_PROCESSING	Previous level outside processing cost
PL_OVERHEAD	Previous level overhead cost
TL_MATERIAL	This level material cost
TL_MATERIAL_OVERHEAD	This level material overhead cost
TL_RESOURCE	This level resource cost
TL_OUTSIDE_PROCESSING	This level outside processing cost
TL_OVERHEAD	This level overhead cost
MATERIAL_COST	Material cost
COST_TYPE_ID	Cost type identifier
MATERIAL_OVERHEAD_COST	Material overhead cost
RESOURCE_COST	Resource cost
OUTSIDE_PROCESSING_COST	Outside Processing cost
OVERHEAD_COST	Overhead cost
PL_ITEM_COST	Total previous level cost
TL_ITEM_COST	Total this level cost
ITEM_COST	Item unit cost
UNBURDENED_COST	Item unit cost minus this level material overhead
BURDEN_COST	This level material overhead
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
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

Bills of Material - CST_ITEM_CST_DTLS_INTERFACE	Open interface table for item cost detail information
Column Name	Descritpion
CREATION_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
TRANSACTION_ID	Transaction identifier
PROCESS_FLAG	Not currently used
CREATED_BY	Standard Who column
ITEM_NUMBER	Not currently used
TRANSACTION_TYPE	Transaction type
YIELDED_COST	The yield cost, applicable for WSM enabled organizations
ERROR_CODE	Error code
LAST_UPDATE_LOGIN	Standard Who column
ERROR_EXPLANATION	Error explanation
LOT_SIZE	Lot size
GROUP_ID	Group identifier
BASED_ON_ROLLUP_FLAG	Based on Rollup flag
SHRINKAGE_RATE	Shrinkage rate
ORGANIZATION_ID	Organization identifier
INVENTORY_ASSET_FLAG	Inventory asset flag
ERROR_FLAG	Error flag
INVENTORY_ITEM_ID	Inventory item identifier
OPERATION_SEQUENCE_ID	Operation sequence identifier
GROUP_DESCRIPTION	Group ID description
OPERATION_SEQ_NUM	Operation sequence number in a routing
DEPARTMENT_ID	Department identifier
LEVEL_TYPE	Level at which cost is incurred
ACTIVITY_ID	Activity identifier
RESOURCE_SEQ_NUM	Resource sequence number in an operation
RESOURCE_ID	Resource identifier (sub-element)
RESOURCE_RATE	Resource unit cost
ITEM_UNITS	Number of item units the activity cost is applied to
ACTIVITY_UNITS	Number of activity units applied to the item cost
COST_TYPE_ID	Cost type identifier
USAGE_RATE_OR_AMOUNT	Number of resource units, overhead rate, or activity unit cost per basis
BASIS_TYPE	Basis
BASIS_RESOURCE_ID	Resource identifier that the resource overhead is based on
BASIS_FACTOR	Basis factor
NET_YIELD_OR_SHRINKAGE_FACTOR	Item shrinkage factor computed from the item shrinkage
ITEM_COST	Item unit cost
COST_ELEMENT_ID	Cost element identifier
ROLLUP_SOURCE_TYPE	Cost source
ACTIVITY_CONTEXT	Structure defining column for the Activity Unit Information
REQUEST_ID	Concurrent Who column
LAST_UPDATE_DATE	Standard Who column
ORGANIZATION_CODE	Organization code
COST_TYPE	Cost type name
INVENTORY_ITEM	Concatenated inventory item segments
DEPARTMENT	Department name
ACTIVITY	Activity name
RESOURCE_CODE	Resource code
BASIS_RESOURCE_CODE	Resource code of resource on which an overhead is based
COST_ELEMENT	Cost element name
ERROR_TYPE	Type of error
PROGRAM_APPLICATION_ID	Concurrent Who column
LAST_UPDATED_BY	Standard 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

Bills of Material - CST_LISTS	Item list for item exploder
Column Name	Descritpion
LIST_ID	List identifier
ENTITY_ID	Generic entity identifier

Bills of Material - CST_LOW_LEVEL_CODES	Temporary table for cost rollup
Column Name	Descritpion
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LOW_LEVEL_CODE	Lowest bill level at which this item exists for this rollup
REQUEST_ID	Concurrent Who column
ROLLUP_ID	Rollup identifier
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
INVENTORY_ITEM_ID	Inventory item identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Bills of Material - CST_PERIOD_VALUE_TEMP	Temporary table used by View WIP Value form
Column Name	Descritpion
SESSION_ID	ORACLE session identifier
COST_ELEMENT_ID	Cost element identifier
VALUATION_ACCOUNT	WIP valuation account identifier
TL_VALUE_IN	This level cost incurred
PL_VALUE_IN	Previous level cost incurred
TL_VALUE_OUT	This level cost relieved
WIP_ENTITY_ID	WIP job or repetitive assembly identifier
PL_VALUE_OUT	Previous level cost relieved
VALUE_IN	Total cost incurred
VALUE_OUT	Total cost relieved
VARIANCE	Total variance
NET_ACTIVITY	Cost incurred minus cost relieved
VAR	Total variance
LINE_ID	WIP repetitive line identifier
ORGANIZATION_ID	Organization identifier

Bills of Material - CST_ITEM_OVERHEAD_DEFAULTS	Default value for the overhead cost
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
ORGANIZATION_ID	Organization identifier
ACTIVITY_ID	Activity identifier
BASIS_TYPE	Basis
ITEM_UNITS	Number of item units the activity cost is applied to
ACTIVITY_UNITS	Number of activity units applied to the item cost
USAGE_RATE_OR_AMOUNT	Number of resource units, overhead rate, or activity unit cost per basis
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ACTIVITY_CONTEXT	Structure defining column for the Activity Unit Information
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
CATEGORY_SET_ID	Category set identifier
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
CATEGORY_ID	Category identifier
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
MATERIAL_OVERHEAD_ID	Material overhead sub element identifier
ITEM_TYPE	Type of item that the material overhead applies

Bills of Material - CST_INTERFACE_ERRORS	Stores invalid records due to error in the item cost definition
Column Name	Descritpion
GROUP_ID	Group identifier
INVENTORY_ITEM	Concatenated inventory item segment
ENTITY_CODE	Erroneous entity code
ERROR_TYPE	Erroneous entity type

Bills of Material - CST_EXPLOSION_TEMP	Temporary, indented bill of material
Column Name	Descritpion
ASSEMBLY_ITEM_ID	Assembly item identifier
COMPONENT_ITEM_ID	Component item identifier
DELETED	Indicates if assembly has been assigned a low level code
LOOP_COUNT	Explosion iteration at which assembly is assigned a low level code
TOP_BILL_SEQUENCE_ID	Bill identifier of level 0 items
TOP_ALTERNATE_DESIGNATOR	Alternate designator for level 0
PLAN_LEVEL	Level in bill
GROUP_ID	Explosion identifier

Bills of Material - CST_MARGIN_BUILD	Stores margin analysis load run parameters
Column Name	Descritpion
BUILD_DESCRIPTION	Description of the build
FROM_DATE	Build date from value
TO_DATE	Build date to value
ORG_ID	Operating unit
HEADER_ID	Header identifier for the sales order
ORGANIZATION_ID	Organization identifier
COST_TYPE_ID	Cost type identifier
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_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
LEGAL_ENTITY_NAME	Legal Entity name
BUILD_ID	Build identifier
BUILD_NAME	Build name
LEGAL_ENTITY_ID	Legal Entity identifier

Bills of Material - CST_MARGIN_TEMP	Margin analysis summary table for reporting purposes
Column Name	Descritpion
ORIGIN	Identifies the origin of the record
LINK_TO_LINE_ID	Parent line identifier if RETURN_REFERENCE_TYPE_CODE is populated
RMA_HEADER_ID	Header identifier for the RMA lines
RMA_NUMBER	Order number for the RMA lines
RMA_INVENTORY_ITEM_ID	Inventory item identifier for the RMA lines
RMA_LINE_ID	Line identifier for the RMA lines
RMA_LINE_NUMBER	Line number for the RMA lines
RMA_ORGANIZATION_ID	Organization identifier for the RMA lines
RMA_LINE_TYPE_CODE	Line type code for the RMA lines
RMA_SHIP_TO_SITE_USE_ID	Site identifier for the shipped site for the RMA lines
RMA_INVOICE_INVENTORY_ITEM_ID	Invoiced inventory item identifier for the RMA lines
INVOICE_SOURCE	Source of the invoice
CR_TRX_ID	Credit memo identifier in RA_CUSTOMER_TRX
CR_TRX_LINE_ID	Credit memo Identifier in RA_CUSTOMER_TRX_LINES
PERIOD_NAME_YEAR	Year name from General Ledger Periods
PERIOD_NUM_YEAR	Number identifier of Year in General Ledger Period
PERIOD_NAME_QTR	Quarter name from General Ledger Periods
PARENT_ROWID	Identifier of SO_ORDER_LINES
PERIOD_NUM_QTR	Number identifier of Quarter in General Ledger Period
PERIOD_SEQ_QTR	Sequence of General Ledger Period Quarter
PERIOD_NAME_MONTH	Month name from General Ledger Periods
PERIOD_NUM_MONTH	Number identifier of Month in General Ledger Period
PERIOD_SEQ_MONTH	Sequence of General Ledger Period Month
OE_ITEM_CATEGORY_ID	Item Category Identifier based on the default category set of the OE functional area
AREA_CODE	Identifier of Area level of the BIS geography dimension
COUNTRY_CODE	Identifier of Country level of the BIS geography dimension
ORDER_NUMBER	Order number of the sales order
REGION_CODE	Identifier of Region level of the BIS geography dimension
AREA_NAME	Name of Area level of the BIS geography dimension
COUNTRY_NAME	Name of Country level of the BIS geography dimension
REGION_NAME	Name of Region level of the BIS geography dimension
LEGAL_ENTITY_ID	Legal Entity Identifier
ORG_ID	Operating unit
OPERATING_UNIT_NAME	Name of Operating Unit
HEADER_ID	Order header identifier
ORDER_TYPE_ID	Order type identifier
CUSTOMER_ID	Customer identifier
SOLD_TO_CUSTOMER_NAME	Customer name based on customer identifier
PRIMARY_SALESREP_ID	Primary sales representative identifier
SALES_CHANNEL_CODE	Sales channel code identifier
PARENT_INVENTORY_ITEM_ID	Parent inventory item identifier in case of a non-standard item
PARENT_ORGANIZATION_ID	Organization identifier for the parent item
PARENT_LINE_ID	Line identifier for the parent line
BUILD_ID	Build identifier
PARENT_LINE_NUMBER	Line number for the parent line
PARENT_ITEM_TYPE_CODE	Type identifier of the parent item, i.e. Standard, Model, Class, etc.
PARENT_ATO_FLAG	Flag indicating if the order line is for ATO
INVENTORY_ITEM_ID	Inventory item identifier for the child line
ORGANIZATION_ID	Organization identifier for the child line
LINE_ID	Line identifier for the child line
LINE_TYPE_CODE	Line type code for the child line
LINE_NUMBER	Line number for the child line
SHIP_TO_SITE_USE_ID	Ship to site identifier
SHIP_TO_CUSTOMER_NAME	Customer name based on SHIP_TO_SITE_USE_ID
SOURCE	Identifies source of the record
INVOICE_TO_SITE_USE_ID	Site identifier for the invoiced site information
BILL_TO_CUSTOMER_NAME	Customer name based on the INVOICE_TO_SITE_USE_ID
CUSTOMER_TRX_ID	Identifier for RA_CUSTOMER_TRX
CUSTOMER_TRX_LINE_ID	Identifier for RA_CUSTOMER_TRX_LINES
ORIGINAL_GL_DATE	Original General ledger Date
GL_DATE	General ledger date
INVOICE_LINE_QUANTITY	Quantity invoiced for entire order line
INVOICE_QUANTITY	Quantity invoiced for invoice line
ORDER_LINE_QUANTITY	Order quantity for order line
SHIP_QUANTITY	Actual shipment quantity
ROW_TYPE	Identifies the type of a sales order line
INVOICED_AMOUNT	Invoiced amount
COGS_AMOUNT	Cost of goods sold amount
SALES_ACCOUNT	Sales account identifier
COGS_ACCOUNT	Cost of goods sold identifier
TERRITORY_ID	Territory identifier
CUSTOMER_CLASS_CODE	Industry identifier
MARGIN	Margin
MARGIN_PCT	Margin percentage
RETURN_REFERENCE_TYPE_CODE	Return reference type identifier for the RMA lines
RETURN_REFERENCE_ID	Return reference identifier for the RMA lines

Bills of Material - CST_QUANTITY_LAYERS	Stores cost information for each layer
Column Name	Descritpion
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
LAYER_ID	Unique layer identifier
PROGRAM_UPDATE_DATE	Standard Who column
ORGANIZATION_ID	Organization Identifier
INVENTORY_ITEM_ID	Item identifier
LAYER_QUANTITY	Costed quantity for this particular layer
CREATE_TRANSACTION_ID	Transaction which created this layer
UPDATE_TRANSACTION_ID	Last transaction to update this layer
PL_MATERIAL	Previous level material cost
PL_MATERIAL_OVERHEAD	Previous level material overhead cost
PL_RESOURCE	Previous level resource cost
PL_OUTSIDE_PROCESSING	Previous level outside processing cost
LAST_UPDATE_DATE	Standard Who column
PL_OVERHEAD	Previous level overhead cost
TL_MATERIAL	This level material cost
TL_MATERIAL_OVERHEAD	This level material overhead cost
TL_RESOURCE	This level resource cost
TL_OUTSIDE_PROCESSING	This level outside processing cost
TL_OVERHEAD	This level overhead cost
MATERIAL_COST	Material cost
MATERIAL_OVERHEAD_COST	Material overhead cost
RESOURCE_COST	Resource cost
OUTSIDE_PROCESSING_COST	Outside processing cost
LAST_UPDATED_BY	Standard Who column
OVERHEAD_COST	Overhead cost
PL_ITEM_COST	Previous level item cost
TL_ITEM_COST	This level item cost
ITEM_COST	Layer item cost
UNBURDENED_COST	Item unit cost minus this level material overhead
BURDEN_COST	This level material overhead
COST_GROUP_ID	Cost group identifier
CREATION_DATE	Standard Who column

Bills of Material - CST_LAYER_COST_DETAILS	Detailed cost information by element and level
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard Who column
LAYER_ID	Layer identifier
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
ITEM_COST	Item Cost
COST_ELEMENT_ID	Cost element identifier
LEVEL_TYPE	Level identifier
LAST_UPDATE_DATE	Standard Who column

Bills of Material - CST_COST_GROUPS	Stores cost group definitions
Column Name	Descritpion
COST_GROUP_ID	Cost Group Identifier
PROGRAM_UPDATE_DATE	Concurrent Who column
ORGANIZATION_ID	Organization Identifier
COST_GROUP	Cost group name
DESCRIPTION	Description
DISABLE_DATE	Inactive On/After
ATTRIBUTE_CATEGORY	Descriptive Flexfield structure defining column
ATTRIBUTE1	Descriptive Flexfield segment
ATTRIBUTE2	Descriptive Flexfield segment
ATTRIBUTE3	Descriptive Flexfield segment
ATTRIBUTE4	Descriptive Flexfield segment
LAST_UPDATE_DATE	Standard Who column
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
LEGAL_ENTITY	Legal Entity Identifier
COST_GROUP_TYPE	Cost group type based on the CST_COST_GROUP_TYPE lookup type
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

Bills of Material - CST_COST_GROUP_ACCOUNTS	Accounts for a cost group for an average costing organization
Column Name	Descritpion
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
COST_GROUP_ID	Cost group identifier
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
MATERIAL_ACCOUNT	Inventory material account
MATERIAL_OVERHEAD_ACCOUNT	Inventory material overhead account
RESOURCE_ACCOUNT	Resource labor account
OVERHEAD_ACCOUNT	Inventory overhead account
OUTSIDE_PROCESSING_ACCOUNT	Outside processing account
AVERAGE_COST_VAR_ACCOUNT	Average cost variance account
ENCUMBRANCE_ACCOUNT	Encumbrance account
PAYBACK_MAT_VAR_ACCOUNT	Borrow payback variance account for material
ORGANIZATION_ID	Organization identifier
PAYBACK_RES_VAR_ACCOUNT	Borrow payback variance account for resource
PAYBACK_OSP_VAR_ACCOUNT	Borrow payback variance account for outside processing
LAST_UPDATE_DATE	Standard Who column
PAYBACK_MOH_VAR_ACCOUNT	Borrow payback variance account for material overhead
PAYBACK_OVH_VAR_ACCOUNT	Borrow payback variance account for overhead
LAST_UPDATED_BY	Standard Who column
EXPENSE_ACCOUNT	Expense Account
PURCHASE_PRICE_VAR_ACCOUNT	Purchase price variance is required for Standard costing organizations supporting project manufacturing

Bills of Material - CST_COST_ELEM_EXP_TYPES	Expenditure types for cost elements.
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
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
COST_ELEMENT_ID	Cost element identifier
EXPENDITURE_TYPE_IN	Expenditure type for transfers into a project
EXPENDITURE_TYPE_OUT	Expenditure type for transfers out of a project

Bills of Material - CST_COMP_SNAPSHOT	Stores the assembly units completed at each operation step
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
TRANSACTION_ID	Transaction identifier
NEW_OPERATION_FLAG	Indicates that this operation was added after the job was released
PRIMARY_QUANTITY	Quantity in primary UOM
QUANTITY_COMPLETED	Number of units completed by the operation
PRIOR_COMPLETION_QUANTITY	Total number of units completed for the job prior to this transaction
PRIOR_SCRAP_QUANTITY	Total number of units scrapped for the job prior to this transaction
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
WIP_ENTITY_ID	WIP entity identifier
OPERATION_SEQ_NUM	Operation sequence number

Bills of Material - CST_COMP_SNAP_TEMP	Stores the assembly units completed at each operation step to be interfaced through the transactions temporary table
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
NEW_OPERATION_FLAG	Indicated that this operation was added after the job was released
TRANSACTION_TEMP_ID	Temporary transaction identifier
PRIMARY_QUANTITY	Primary quantity
QUANTITY_COMPLETED	Number of units completed by the operation
PRIOR_COMPLETION_QUANTITY	Total number of units completed for the job prior to this transaction
PRIOR_SCRAP_QUANTITY	Total number of units scrapped for the job prior to this transaction
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
WIP_ENTITY_ID	WIP entity identifier
OPERATION_SEQ_NUM	Operation sequence number
LAST_UPDATE_DATE	Standard Who column

Bills of Material - CST_COMP_SNAP_INTERFACE	Stores the assembly units completed at each operation step to be interfaced through the transactions interface
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
NEW_OPERATION_FLAG	Indicates that this operation was added after the job was released
TRANSACTION_INTERFACE_ID	Transaction identifier
PRIMARY_QUANTITY	Quantity in primary UOM
QUANTITY_COMPLETED	Number of units completed by the operation
PRIOR_COMPLETION_QUANTITY	Total number of units completed for the job prior to this transaction
PRIOR_SCRAP_QUANTITY	Total number of units scrapped for the job prior to this transaction
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
WIP_ENTITY_ID	WIP entity identifier
OPERATION_SEQ_NUM	Operation sequence number
LAST_UPDATE_DATE	Standard Who column

Bills of Material - CST_CG_WIP_ACCT_CLASSES	Uniquely identifies WIP accounting class for a cost group in each organization
Column Name	Descritpion
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DISABLE_DATE	Inactive On/After
COST_GROUP_ID	Cost group identifier
REQUEST_ID	Request identifier
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
ORGANIZATION_ID	Organization identifier
CLASS_CODE	Class code
LAST_UPDATE_DATE	Standard Who column

Bills of Material - CST_COST_GROUP_ASSIGNMENTS	Stores the organization assignment
Column Name	Descritpion
COST_GROUP_ID	Cost group identifier
PROGRAM_UPDATE_DATE	Extended Who Column
LAST_UPDATE_LOGIN	Standard Who Column
ORGANIZATION_ID	Organization identifier assigned to the cost group
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
REQUEST_ID	Extended Who Column
PROGRAM_APPLICATION_ID	Extended Who Column
PROGRAM_ID	Extended Who Column

Bills of Material - CST_LE_COST_TYPES	Holds information about the legal entity/cost
Column Name	Descritpion
LEGAL_ENTITY	The organization_id of the legal entity
REQUEST_ID	Extended Who column
PROGRAM_APPLICATION_ID	Extended Who column
PROGRAM_ID	Extended Who column
PROGRAM_UPDATE_DATE	Extended Who column
LAST_UPDATE_LOGIN	Standard Who column
CREATE_ACCT_ENTRIES	Option that allows the user to create accounting entries for periodic costing
ACCOUNTING_LIBRARY_ID	Identifier of the accounting library that is to be used to create accounting distributions for the Legal Entity,Cost Type combination
POST_TO_GL	Option that allows the user to post accounting entries to General Ledger
GL_TRANSFER_ALLOW_OVERRIDE	Option that allows the user to change the default values for program parameters when transfer to General Ledger process is submitted
GL_TRANSFER_MODE	General Ledger Interface Transfer Summary Level
COST_TYPE_ID	The identifier of the cost type that will be associated with the legal entity.
GL_TRANSFER_SUBMIT_JOURNAL_IMP	Option for submitting Journal Import to Oracle General Ledger at the same time as the transfer to General Ledger process
RESTRICT_DOC_FLAG	Determines if the Documents (Invoices and RTVs) are to be restricted by the Process upto date when the acquisition cost is calculated
TRANSFER_COST_FLAG	Column used to identify legal entity/cost type for interorg transfer
ITERATION_PROC_FLAG	iteration process as an option in Periodic Absorption Cost Processor
MATERIAL_RELIEF_ALGORITHM	Algorithm used for relieving material value
SET_OF_BOOKS_ID	Set of Books identifier
PRIMARY_COST_METHOD	Primary cost method obtained from lookups
PAC_RATES_COST_TYPE_ID	Cost type identifier that will serve as rates
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 - CST_PAC_EXPLOSION_TEMP	Stores distinct parent-child combinations of items for a given period and organization cost group.
Column Name	Descritpion
PAC_PERIOD_ID	Period Identifier
COST_GROUP_ID	Cost Group Identifier
ASSEMBLY_ITEM_ID	Parent assembly item identifier
COMPONENT_ITEM_ID	Child item identifier
DELETED	Flag, internally used during computation of low level codes
LOOP_COUNT	Counter, internally used during computation of low level codes

Bills of Material - CST_PAC_ITEM_COSTS	Stores the item cost and quantity in a period and organization cost group.
Column Name	Descritpion
COST_LAYER_ID	Cost layer identifier
ITEM_BUY_COST	The buy item cost at the end of the period
ITEM_MAKE_COST	The make item cost at the end of the period
BEGIN_ITEM_COST	The item cost at the beginning of the period
MATERIAL_COST	Material cost
MATERIAL_OVERHEAD_COST	Material overhead cost
RESOURCE_COST	Resource cost
OVERHEAD_COST	Overhead cost
OUTSIDE_PROCESSING_COST	Outside processing cost
PL_MATERIAL	Previous level material cost
PL_MATERIAL_OVERHEAD	Previous level material overhead cost
PAC_PERIOD_ID	Period Identifier
PL_RESOURCE	Previous level resource cost
PL_OUTSIDE_PROCESSING	Previous level outside processing cost
PL_OVERHEAD	Previous level overhead cost
TL_MATERIAL	This level material cost
TL_MATERIAL_OVERHEAD	This level material overhead cost
TL_RESOURCE	This level resource cost
TL_OUTSIDE_PROCESSING	This level outside processing cost
TL_OVERHEAD	This level overhead cost
PL_ITEM_COST	Total previous level item cost
TL_ITEM_COST	Total item cost in this level
COST_GROUP_ID	Cost Group Identifier
UNBURDENED_COST	Item unit cost minus this level material overhead
BURDEN_COST	This level material overhead
LAST_UPDATE_DATE	Who column
LAST_UPDATED_BY	Who column
CREATION_DATE	Who column
CREATED_BY	Who column
REQUEST_ID	Who column
PROGRAM_APPLICATION_ID	Who column
PROGRAM_ID	Who column
PROGRAM_UPDATE_DATE	Who column
INVENTORY_ITEM_ID	Inventory Item identifier
LAST_UPDATE_LOGIN	Who column
MARKET_VALUE	Market value
JUSTIFICATION	Justification for the market value
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
BUY_QUANTITY	The buy quantity in the period
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
ATTRIBUTE_CATEGORY	Descriptive Flexfield segment
MAKE_QUANTITY	The make quantity in the period
ISSUE_QUANTITY	The quantity issued in the periodic costing period
TOTAL_LAYER_QUANTITY	The net quantity at the end of the Periodic Average Costing period
ITEM_COST	The item cost at the end of the period.

Bills of Material - CST_PAC_ITEM_COST_DETAILS	Stores the details of the item cost in a period and organization cost group.
Column Name	Descritpion
COST_LAYER_ID	Cost layer identifier
CREATED_BY	Who column
REQUEST_ID	Who column
PROGRAM_APPLICATION_ID	Who column
PROGRAM_ID	Who column
PROGRAM_UPDATE_DATE	Who column
LAST_UPDATE_LOGIN	Who column
ITEM_BALANCE	Total Item balance in PAC period
BUY_BALANCE	Item buy balance in the PAC period
MAKE_BALANCE	Item make balance in the PAC period
COST_ELEMENT_ID	Cost element identifier
LEVEL_TYPE	Level type
ITEM_COST	Elemental item cost at the end of the period
ITEM_BUY_COST	Elemental buy item cost at the end of the period
ITEM_MAKE_COST	Elemental make item cost at the end of the period
LAST_UPDATE_DATE	Who column
LAST_UPDATED_BY	Who column
CREATION_DATE	Who column

Bills of Material - CST_PAC_LOW_LEVEL_CODES	Stores low level codes for items for a given period and organization cost group.
Column Name	Descritpion
PAC_PERIOD_ID	Period Identifier
PROGRAM_APPLICATION_ID	Extended Who column
PROGRAM_ID	Extended Who column
PROGRAM_UPDATE_DATE	Extended Who column
LAST_UPDATE_LOGIN	Standard Who column
COST_GROUP_ID	Cost Group Identifier
INVENTORY_ITEM_ID	Item Identifier
LOW_LEVEL_CODE	Low level code
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
REQUEST_ID	Extended Who column

Bills of Material - CST_PAC_PERIODS	Holds information about periodic costing open and closed periods for each legal entity.
Column Name	Descritpion
PAC_PERIOD_ID	Periodic Costing Period Identifier
PERIOD_NAME	Period Name
PERIOD_CLOSE_DATE	Period Close Date
LAST_UPDATE_DATE	Who column
LAST_UPDATED_BY	Who column
CREATION_DATE	Who column
CREATED_BY	Who column
REQUEST_ID	Who column
PROGRAM_APPLICATION_ID	Who column
PROGRAM_ID	Who column
PROGRAM_UPDATE_DATE	Who column
LEGAL_ENTITY	Legal Entity Identifier
LAST_UPDATE_LOGIN	Who column
COST_TYPE_ID	Cost Type Identifier
PERIOD_SET_NAME	Calendar associated with Set of Books
PERIOD_START_DATE	Period Start Date
PERIOD_END_DATE	Period End Date
OPEN_FLAG	Flag to denote whether period is in open, close or error status
PERIOD_YEAR	Period Year
PERIOD_NUM	Period Number

Bills of Material - CST_PAC_PROCESS_PHASES	Holds the status for each process phase in a particular period and organization cost group
Column Name	Descritpion
PAC_PERIOD_ID	Period Identifier
REQUEST_ID	Who column
PROGRAM_APPLICATION_ID	Who column
PROGRAM_ID	Who column
PROGRAM_UPDATE_DATE	Who column
LAST_UPDATE_LOGIN	Who column
PROCESS_UPTO_DATE	Stores the run until date for partial period run
COST_GROUP_ID	Cost Group Identifier
PROCESS_PHASE	Phase identifier for Periodic Cost Processing
PROCESS_STATUS	Processing Status for each phase
PROCESS_DATE	Date of the last status change
LAST_UPDATE_DATE	Who column
LAST_UPDATED_BY	Who column
CREATION_DATE	Who column
CREATED_BY	Who column

Bills of Material - CST_PAC_QUANTITY_LAYERS	Stores the layer quantity of an item by period for periodic costing
Column Name	Descritpion
QUANTITY_LAYER_ID	Quantity layer identifier
CREATED_BY	Who column
REQUEST_ID	Who column
PROGRAM_APPLICATION_ID	Who column
PROGRAM_ID	Who column
PROGRAM_UPDATE_DATE	Who column
LAST_UPDATE_LOGIN	Who column
BEGIN_LAYER_QUANTITY	Layer quantity at the period beginning
COST_LAYER_ID	Cost layer identifier
PAC_PERIOD_ID	Period Identifier
COST_GROUP_ID	Cost group identifier
INVENTORY_ITEM_ID	Item identifier
LAYER_QUANTITY	Quantity at the given layer
LAST_UPDATE_DATE	Who column
LAST_UPDATED_BY	Who column
CREATION_DATE	Who column

Bills of Material - CST_RCV_ACQ_COSTS	Stores acquisition cost per period, organization cost group for periodic costing
Column Name	Descritpion
HEADER_ID	Unique Identifier
AMOUNT_AT_PO_PRICE	Amount derived using Uninvoiced Quantity at PO Price
TOTAL_AMOUNT	Sum of the Invoice Amount and PO Amount
COSTED_QUANTITY	Quantity used to compute the per unit Acquisition Cost. This will be the Net Quantity Received or the Total Quantity Invoiced, whichever is greater
ACQUISITION_COST	Per Unit Periodic Acquisition Cost
PO_LINE_LOCATION_ID	Shipment Line Number for the receipt
PO_UNIT_PRICE	Per Unit PO price inclusive of non recoverable tax, based on primary UOM of the item
PRIMARY_UOM	Per Unit PO price inclusive of non recoverable tax, based on primary UOM of the item
REC_EXCHG_RATE	Currency Conversion rate.
LAST_UPDATE_DATE	Who column
LAST_UPDATED_BY	Who column
COST_GROUP_ID	Cost Group Identifier
CREATION_DATE	Who column
CREATED_BY	Who column
REQUEST_ID	Who column
PROGRAM_APPLICATION_ID	Who column
PROGRAM_ID	Who column
PROGRAM_UPDATE_DATE	Who column
LAST_UPDATE_LOGIN	Who column
COST_TYPE_ID	Cost Type Identifier
PERIOD_ID	Period (for the Cost Type) of the receipt
RCV_TRANSACTION_ID	Receipt Identifier from RCV_TRANSACTIONS
NET_QUANTITY_RECEIVED	Net Quantity Received (net of corrections and returns)
TOTAL_QUANTITY_INVOICED	Sum of the quantity invoiced for the invoices matched to the receipt
QUANTITY_AT_PO_PRICE	Portion of the Net Quantity Received that was not Invoiced (and is costed at the PO Price)
TOTAL_INVOICE_AMOUNT	Sum of the Invoice Amounts for the Invoices matched to the Receipt

Bills of Material - CST_RCV_ACQ_COST_DETAILS	Stores detailed acquisition cost per period, organization cost group.
Column Name	Descritpion
HEADER_ID	Header Identifier from CST_RCV_ACQ_COSTS
ALLOCATED_AMOUNT	Whole or portion of the parent invoice distribution amount
AMOUNT	Whole or portion of the Allocated Amount
QUANTITY	Invoice Quantity if source is INVOICE, Uninvoiced quantity if source is PO
PARENT_AMOUNT	Immediate Parent Invoice Distribution Amount
PRICE	Invoice Price if source is INVOICE, PO Price if source is PO
LINE_TYPE	Invoice Distribution Line Type (if source is INVOICE)
LAST_UPDATE_DATE	Who column
LAST_UPDATED_BY	Who column
CREATION_DATE	Who column
CREATED_BY	Who column
DETAIL_ID	Unique Identifier
REQUEST_ID	Who column
PROGRAM_APPLICATION_ID	Who column
PROGRAM_ID	Who column
PROGRAM_UPDATE_DATE	Who column
LAST_UPDATE_LOGIN	Who column
SOURCE_TYPE	Source of the line (INVOICE or PO)
PO_LINE_LOCATION_ID	Source Shipment ID if source is PO
PARENT_DISTRIBUTION_ID	Invoice Distribution Identifier for the parent distribution (if the source is INVOICE)
DISTRIBUTION_NUM	Serial Number of the distributions which make up the Acquisition Cost (if the source is INVOICE)
LEVEL_NUM	Level in the hierarchy of the special charge allocations (if the source is INVOICE)
INVOICE_DISTRIBUTION_ID	Source Invoice Distribution Identifier (if the source is INVOICE)
PARENT_INVOICE_DIST_ID	Immediate Parent Invoice Distribution Identifier (if source is INVOICE)

Bills of Material - CST_MGD_INFL_ADJUSTED_COSTS	Stores inflation adjustment values
Column Name	Descritpion
INVENTORY_ITEM_ID	Inventory Item Identifier
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
COUNTRY_CODE	Country Code
BEGIN_QTY	Quantity on-hand at the start of the period
ACCT_PERIOD_ID	Account Period Identifier
BEGIN_COST	Cost at the start of the period
BEGIN_INFLATION_ADJ	Inflation at the start of the period. Calculated from ending inflation of the previous period.
PURCHASE_QTY	Quantity purchased in the current period
PURCHASE_COST	Purchase cost for the current period
ACTUAL_QTY	Quantity on-hand in the current period
ACTUAL_COST	Cost of goods on-hand in the current period
ACTUAL_INFLATION_ADJ	Inflation adjustment for the current period
ISSUE_QTY	Quantity issued in the current period
ISSUE_COST	Cost of goods issued in the current period
ISSUE_INFLATION_ADJ	Inflation adjustment calculated from issue of goods.
INVENTORY_ADJ_ACCT_CR	Inventory Inflation Adjustment Account (Credit)
INVENTORY_ADJ_ACCT_DR	Inventory Inflation Adjustment Account (Debit)
MONETARY_CORR_ACCT_CR	Monetary Correction Account
SALES_COST_ACCT_DR	Inflation Adjustments of Sales Cost Account
HISTORICAL_FLAG	Historical Data (Y/N)
LAST_UPDATE_DATE	Standard Who column
ORGANIZATION_ID	Organization Identifier
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard Who column

Bills of Material - CST_MGD_INFL_ADJ_KARDEX_DATA	Stores data that supports the Inflation Adjustment Kardex Report
Column Name	Descritpion
INVENTORY_ITEM_ID	Inventory Item Identifier
TXN_H_TOTAL_COST	Transfer Historical Total Cost
TXN_ADJ_TOTAL_COST	Transfer Adjustment Total Cost
TXN_FNL_QTY	Transfer Final Quantity
TXN_FNL_UNIT_COST	Transfer Final Unit Cost
TXN_FNL_H_TOTAL_COST	Transfer Final Historical Total Cost
TXN_FNL_ADJ_TOTAL_COST	Transfer Final Adjustment Total Cost
CREATION_DATE
TRANSACTION_ID
TXN_DATE	Transfer Date
ORGANIZATION_ID	Organization Identifier
TXN_TYPE	Transfer Type
TXN_INI_QTY	Initial Transfer Quantity
TXN_INI_UNIT_COST	Initial Transfer Unit Cost
TXN_INI_H_TOTAL_COST	Initial Transfer Historical Total Cost
TXN_INI_ADJ_TOTAL_COST	Initial Transfer Adjustment Total Cost
TXN_QTY	Transfer Quantities
TXN_UNIT_COST	Transfer Unit Cost

Bills of Material - CST_MGD_INFL_ADJ_PER_STATUSES	Stores inflation status for each period.
Column Name	Descritpion
ACCT_PERIOD_ID	Account Period Identifier
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
STATUS	Status of a period with respect to the Inflation Adjustment process
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
ORGANIZATION_ID	Organization Identifier
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column

Bills of Material - CST_MGD_INFL_TSF_ORG_ENTRIES	Stores transfer organization information for inflation adjustment.
Column Name	Descritpion
REQUEST_ID	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
COUNTRY_CODE	Country Code
TRANSFER_ORGANIZATION_ID	Organization Identifier for organization involved in transfer
ENTERED_DR	Debit amount entered as a result of the transfer
ENTERED_CR	Credit amount entered as a result of the transfer
INVENTORY_ITEM_ID	Inventory Item Identifier
ORGANIZATION_ID	Organization Identifier
ACCT_PERIOD_ID	Account Period Identifier
TRANSACTION_ID	Transaction 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 - CST_PC_COST_DET_INTERFACE	Periodic Item Cost Details Interface Table
Column Name	Descritpion
INTERFACE_LINE_ID	Interface Line Identifier
REFERENCE	Reference
ERROR_FLAG	Error Status Flag
ERROR_EXPLANATION	Error Explanation
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
REQUEST_ID	Extended Who column
PROGRAM_APPLICATION_ID	Extended Who column
PROGRAM_ID	Extended Who column
INTERFACE_HEADER_ID	Interface Header Identifier
PROGRAM_UPDATE_DATE	Extended Who column
LAST_UPDATE_LOGIN	Standard Who column
COST_ELEMENT_ID	Cost Element Identifier
LEVEL_TYPE	Level Type
ITEM_COST	Item Cost
PROCESS_FLAG	Process Status Flag
ITEM_BUY_COST	Item Buy Cost
ITEM_MAKE_COST	Item Make Cost
COST_LAYER_ID	Cost Layer Identifier

Bills of Material - CST_PC_ITEM_COST_INTERFACE	Periodic Item Cost Header Interface Table
Column Name	Descritpion
INTERFACE_HEADER_ID	Interface Header Identifier
MAKE_QUANTITY	Make Quantity
INTERFACE_GROUP_ID	Interface Group Identifier
COST_LAYER_ID	Cost Layer Identifier
QUANTITY_LAYER_ID	Quantity Layer Identifier
PAC_PERIOD_ID	Periodic Period Identifier
COST_GROUP_ID	Cost Group Identifier
ITEM_COST	Item Cost
MARKET_VALUE	Market Value
JUSTIFICATION	Justification
BEGIN_ITEM_COST	Period Begin Item Cost
INVENTORY_ITEM_ID	Inventory Item Identifier
ITEM_BUY_COST	Item Buy Cost
ITEM_MAKE_COST	Item Make Cost
PL_MATERIAL	Previous Level Material Cost
PL_MATERIAL_OVERHEAD	Previous Level Material Overhead Cost
PL_RESOURCE	Previous Level Resource Cost
PL_OUTSIDE_PROCESSING	Previous Level Outside Processing Cost
PL_OVERHEAD	Previous Level Overhead Cost
TL_MATERIAL	This Level Material Cost
TL_MATERIAL_OVERHEAD	This Level Material Overhead Cost
TL_RESOURCE	This Level Resource Cost
COST_GROUP	Cost Group Name
TL_OUTSIDE_PROCESSING	This Level Outside Processing Cost
TL_OVERHEAD	This Level Overhead Cost
PL_ITEM_COST	Previous Level Item Cost
TL_ITEM_COST	This Level Item Cost
UNBURDENED_COST	Unburdened Cost
BURDEN_COST	Burden Cost
MATERIAL_COST	Material Cost
MATERIAL_OVERHEAD_COST	Material Overhead Cost
RESOURCE_COST	Resource Cost
OVERHEAD_COST	Overhead Cost
COST_TYPE	Cost Type Name
OUTSIDE_PROCESSING_COST	Outside Processing Cost
REFERENCE	Reference Flag
ERROR_FLAG	Error Status Flag
ERROR_EXPLANATION	Error Explanation
LOCK_FLAG	Lock Flag
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
REQUEST_ID	Extended Who column
PERIOD_NAME	Period name
PROGRAM_APPLICATION_ID	Extended Who column
PROGRAM_ID	Extended Who column
PROGRAM_UPDATE_DATE	Extended Who column
LAST_UPDATE_LOGIN	Standard Who column
LAYER_QUANTITY	Layer quantity
PROCESS_FLAG	Process status flag
BEGIN_LAYER_QUANTITY	Period Beginning Layer Quantity
ISSUE_QUANTITY	Issue Quantity
BUY_QUANTITY	Buy Quantity

Bills of Material - CST_ACCOUNTING_LIBRARIES	CST_ACCOUNTING_LIBRARIES stores information about the library that should be called during the periodic distribution process for GAAP Accounting.
Column Name	Descritpion
ACCOUNTING_LIB_ID	Unique ID
LAST_UPDATE_LOGIN	Standard Who column
PROGRAM_UPDATE_DATE	Extended Who column
PROGRAM_APPLICATION_ID	Extended Who column
PROGRAM_ID	Extended Who column
REQUEST_ID	Extended Who column
LIB_NAME	Name of the Accounting Library
DESCRIPTION	Description of the Accounting Library
COST_METHOD_ID	Cost Method identifier for which the library can be used
LIB_PKG_NAME	The PL/SQL package name for the library
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

Bills of Material - CST_ACCOUNTING_PACKAGES	CST_ACCOUNTING_PACKAGES stores information about PL/SQL packages that are called during the periodic distribution process.
Column Name	Descritpion
ACCOUNTING_PACKAGE_ID	Unique ID
PROGRAM_UPDATE_DATE	Extended Who column
PROGRAM_APPLICATION_ID	Extended Who column
PROGRAM_ID	Extended Who column
REQUEST_ID	Extended Who column
DESCRIPTION	Description of the accounting package
PACKAGE_NAME	Name of the PL/SQL package
COST_METHOD_ID	Cost Method identifier for which the package can be used
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Bills of Material - CST_ACCT_LIB_PACKAGES	CST_ACCT_LIB_PACKAGES stores associations between the library for GAAP accounting and any PL/SQL package that should be called for a transaction event during periodic distribution process.
Column Name	Descritpion
ACCOUNTING_LIB_ID	ID from CST_ACCOUNTING_LIBRARIES
PROGRAM_APPLICATION_ID	Extended Who column
PROGRAM_ID	Extended Who column
REQUEST_ID	Extended Who column
ACCOUNTING_PACKAGE_ID	ID from CST_ACCOUNTING_PACKAGES
EVENT_TYPE_ID	Event ID from CST_EVENT_TYPES
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PROGRAM_UPDATE_DATE	Extended Who column

Bills of Material - CST_AE_HEADERS	Header Information for Periodic Accounting Distributions
Column Name	Descritpion
AE_HEADER_ID	Unique Identifier
ACCOUNTING_DATE	Accounting Event Date
GL_TRANSFER_FLAG	General Ledger Transfer Flag
GL_TRANSFER_RUN_ID	General Ledger Transfer Run Identifier
DESCRIPTION	Description of Accounting Header
GL_TRANSFER_ERROR_CODE	General Ledger Transfer Error Code
ACCT_EVENT_SOURCE_TABLE	Accounting Event Source Table
ORGANIZATION_ID	Accounting Event Organization Identifier
ACCOUNTING_ERROR_CODE	Accounting Error Code
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
ACCOUNTING_EVENT_ID	Accounting Event Identifier
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
REQUEST_ID	Standard Who column
CROSS_CURRENCY_FLAG	Cross Currency Flag
GL_REVERSAL_FLAG	Indicates whether accounting entries need to be reversed
SET_OF_BOOKS_ID	Set of Books Identifier
LEGAL_ENTITY_ID	Legal Entity Identifier
COST_GROUP_ID	Cost Group Identifier
COST_TYPE_ID	Cost Type Identifier
AE_CATEGORY	Accounting Event Category
PERIOD_ID	Period Identifier
PERIOD_NAME	Name of accounting period

Bills of Material - CST_AE_LINES	Stores debits and credits for Periodic Distributions
Column Name	Descritpion
AE_LINE_ID	Unique Identifier
ENTERED_DR	Accounting Debit Entry
ENTERED_CR	Accounting Credit Entry
ACCOUNTED_DR	Accounting Debit entry in functional currency
ACCOUNTED_CR	Accounting Credit entry in functional currency
SOURCE_TABLE	Accounting Entry source table
SOURCE_ID	Accounting Entry source Identifier
RATE_OR_AMOUNT	Per Unit Rate
BASIS_TYPE	Basis Type for WIP
RESOURCE_ID	Resource Identifier for WIP
COST_ELEMENT_ID	Cost Element Identifier
AE_HEADER_ID	Accounting Header Identifier
ACTIVITY_ID	Activity Identifier for WIP
REPETITIVE_SCHEDULE_ID	Repetitive Schedule Identifier for WIP
OVERHEAD_BASIS_FACTOR	Overhead Basis Factor for WIP
BASIS_RESOURCE_ID	Basis Resource Identifier for WIP
GL_SL_LINK_ID	Link to General Ledger
DESCRIPTION	Description of Accounting entry line
ACCOUNTING_ERROR_CODE	Accounting Error Code
STAT_AMOUNT	Stat Amount
USSGL_TRANSACTION_CODE	USSGL Transaction Code
SUBLEDGER_DOC_SEQUENCE_ID	Subledger Document Sequence Identifier
AE_LINE_NUMBER	Accounting Line Number
SUBLEDGER_DOC_SEQUENCE_VALUE	Subledger Document Sequence Value
GL_TRANSFER_ERROR_CODE	General Ledger Transfer Error Code
REFERENCE1	Reference column
REFERENCE2	Reference column
REFERENCE3	Reference column
REFERENCE4	Reference column
REFERENCE5	Reference column
REFERENCE6	Reference column
REFERENCE7	Reference column
REFERENCE8	Reference column
AE_LINE_TYPE_CODE	Accounting Line Type Code
REFERENCE9	Reference column
REFERENCE10	Reference column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
CODE_COMBINATION_ID	Account Identifier
REQUEST_ID	Standard Who column
PO_DISTRIBUTION_ID	Purchase Order Distribution Identifier for Receiving Transactions
WIP_ENTITY_ID	WIP Entity Identifier
CURRENCY_CODE	Currency Code
CURRENCY_CONVERSION_TYPE	Currency Conversion Type
CURRENCY_CONVERSION_DATE	Currency Conversion Date
CURRENCY_CONVERSION_RATE	Currency Conversion Exchange Rate

Bills of Material - CST_ORG_COST_GROUP_ACCOUNTS	Stores the accounts defined against an organization cost group
Column Name	Descritpion
LEGAL_ENTITY_ID	Legal Entity Identifier
LAST_UPDATE_LOGIN	Standard Who Column
PROGRAM_UPDATE_DATE	Extended Who Column
PROGRAM_APPLICATION_ID	Extended Who Column
PROGRAM_ID	Extended Who Column
REQUEST_ID	Extended Who Column
LANDED_COST_VAR_ACCOUNT	Landed Cost Variance Account
LANDED_COST_ABS_ACCOUNT	Landed Cost Absorption Account
COST_TYPE_ID	Cost Type Identifier
COST_GROUP_ID	Cost Group Identifier
INVENTORY_OFFSET_ACCOUNT	Inventory Offset Account Number
COST_VARIANCE_ACCOUNT	Cost Variance Account Number
RETRO_PRICE_ADJ_ACCOUNT	Periodic Retroactive Price Adjustment Account
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column

Bills of Material - CST_ENCUMBRANCE_LINES	Stores encumbrance account distributions for periodic costing
Column Name	Descritpion
ENCUMBRANCE_LINE_ID	Unique Identifier
ENTERED_DR	Accounting Debit Entry
ENTERED_CR	Accounting Credit Entry
ACCOUNTED_DR	Accounting Debit entry in functional currency
ACCOUNTED_CR	Accounting Credit entry in functional currency
SOURCE_TABLE	Accounting entry source table
SOURCE_ID	Accounting source Identifier
RATE_OR_AMOUNT	Per Unit Rate
BASIS_TYPE	Basis Type for WIP
RESOURCE_ID	Resource Identifier for WIP
COST_ELEMENT_ID	Cost Element Identifier
AE_HEADER_ID	Accounting Event Identifier
ACTIVITY_ID	Activity Identifier
REPETITIVE_SCHEDULE_ID	Repetitive Schedule Identifier
OVERHEAD_BASIS_FACTOR	Overhead Basis Factor for WIP
BASIS_RESOURCE_ID	Basis Resource Identifier for WIP
GL_SL_LINK_ID	Link to General Ledger
DESCRIPTION	Description of Accounting Entry line
ACCOUNTING_ERROR_CODE	Accounting Error Code
STAT_AMOUNT	Stat Amount
USSGL_TRANSACTION_CODE	USSGL Transaction Code
SUBLEDGER_DOC_SEQUENCE_ID	Subledger Document Sequence Identifier
AE_LINE_NUMBER	Accounting Entry Line Number
SUBLEDGER_DOC_SEQUENCE_VALUE	Subledger Document Sequence Value
GL_TRANSFER_ERROR_CODE	General Ledger Transfer Error Code
ENCUMBRANCE_TYPE_ID	Encumbrance Type Identifier
REFERENCE1	Reference column
REFERENCE2	Reference column
REFERENCE3	Reference column
REFERENCE4	Reference column
REFERENCE5	Reference column
REFERENCE6	Reference column
REFERENCE7	Reference column
AE_LINE_TYPE_CODE	Accounting Line Type Code
REFERENCE8	Reference column
REFERENCE9	Reference column
REFERENCE10	Reference column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
CODE_COMBINATION_ID	Account Identifier
PROGRAM_ID	Standard Who column
REQUEST_ID	Standard Who column
PO_DISTRIBUTION_ID	Purchase Order Distribution Identifier for Receiving Transactions
CURRENCY_CODE	Currency Code
CURRENCY_CONVERSION_TYPE	Currency Conversion Type
CURRENCY_CONVERSION_DATE	Currency Conversion Date
CURRENCY_CONVERSION_RATE	Currency Conversion Exchange Rate

Bills of Material - CST_PAC_ACCRUAL_ACCOUNTS_TEMP	Temporary table for storing accrual accounts for Accrual Reconciliation for periodic costing
Column Name	Descritpion
REQUEST_ID	Standard Who column
ACCRUAL_ACCOUNT_ID	Accrual Account unique identifier
LEGAL_ENTITY_ID	Legal entity unique identifier

Bills of Material - CST_PAC_ACCRUAL_RECONCILE_TEMP	Temporary table for Accrual Reconciliation for periodic costing
Column Name	Descritpion
TRANSACTION_DATE	Date for the transaction
LINE_MATCH_ORDER	Line sequence number for matching
REQUEST_ID	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
TRANSACTION_ORGANIZATION_ID	Organization where transaction took place
VENDOR_ID	Supplier unique identifier
ITEM_MASTER_ORGANIZATION_ID	Item Master/Purchasing reference organization
ACCRUAL_ACCOUNT_ID	Accrual account unique identifier
ACCRUAL_CODE	Type of transaction or A/P match condition
INVENTORY_ITEM_ID	Item unique identifier
PO_TRANSACTION_TYPE	Purchasing transaction code
INVOICE_NUM	Invoice number
RECEIPT_NUM	Receipt number
PO_TRANSACTION_ID	Receiving transaction unique identifier
INV_TRANSACTION_ID	Inventory transaction unique identifier
INV_TRANSACTION_TYPE_ID	Inventory transaction type unique identifier
WIP_TRANSACTION_ID	WIP transaction unique identifier
WIP_TRANSACTION_TYPE_ID	WIP transaction type unique identifier
PO_UNIT_OF_MEASURE	PO unit of measure
PRIMARY_UNIT_OF_MEASURE	Primary unit of measure for the item
TRANSACTION_QUANTITY	Quantity for the transaction, in the PO_UOM
NET_PO_LINE_QUANTITY	Po line invoice quantity less PO line receipt quantity, for Release 9 calculations
PO_NUM	PO number
PO_DISTRIBUTION_ID	Document distribution unique identifier
TRANSACTION_UNIT_PRICE	Unit price for the transaction
AVG_RECEIPT_PRICE	Average receipt price for the PO line
TRANSACTION_AMOUNT	Transaction debit or credit
TRANSACTION_SOURCE_CODE	Transaction source or subledger
WRITE_OFF_FLAG	Indicates whether what has been written off
WRITE_OFF_ID	Write-off unique identifier
DESTINATION_TYPE_CODE	Destination type for the transaction
PO_HEADER_ID	Document header unique identifier
REASON_ID	Transaction reason unique identifier
COMMENTS	Comments for accrual write-off
PERIOD_NAME	Accounting period name
NET_PO_LINE_AMOUNT	PO line invoice amount less receipt amount. Used for IPV.
INVOICE_PRICE_VARIANCE	Invoice price variance
AGING_DATE	Earliest transaction date for the PO line
PERIOD_ID	Periodic costing period unique identifier
LINE_LOCATION_ID	Document line location unique identifier
VENDOR_NAME_ALT	Alternate supplier name for Japanese location
LEGAL_ENTITY_ID	Legal entity unique identifier
PO_LINE_NUM	Purchase order Line number
COST_GROUP_ID	Cost group unique identifier
COST_TYPE_ID	Cost type unique identifier
ADJUSTMENT_TRANSACTION	Specifies if the transaction is a retro active price adjustment
PO_LINE_ID	Document line unique identifier
VENDOR_NAME	Supplier name
INVOICE_ID	Invoice unique identifier
INVOICE_LINE_NUM	Invoice distribution number

Bills of Material - CST_PAC_ACCRUAL_WRITE_OFFS	Stores the write-off information for Accrual Reconciliation for periodic costing
Column Name	Descritpion
TRANSACTION_DATE	Original transaction
PO_UNIT_OF_MEASURE	PO unit of measure
PRIMARY_UNIT_OF_MEASURE	Primary unit of measure for the item
TRANSACTION_QUANTITY	Quantity for the transaction
NET_PO_LINE_QUANTITY	PO line invoice quantity less receipt quantity
PO_HEADER_ID	Document header unique identifier
PO_NUM	PO number
PO_LINE_NUM	PO line number
PO_LINE_ID	Document line unique identifier
PO_DISTRIBUTION_ID	Document distribution unique identifier
VENDOR_ID	Supplier unique identifier
INVOICE_NUM	Invoice number
VENDOR_NAME	Supplier name
TRANSACTION_UNIT_PRICE	Unit price for the transaction
INVOICE_ID	Invoice unique identifier
INVOICE_LINE_NUM	Invoice distribution number
AVG_RECEIPT_PRICE	Average receipt price for the purchase order line
TRANSACTION_AMOUNT	Transaction debit or credit
LINE_MATCH_ORDER	Line sequence number for printing Periodic Accrual Reconciliation report
TRANSACTION_SOURCE_CODE	Transaction source or subledger
REASON_ID	Transaction reason unique identifier
COMMENTS	Comments for accrual write-off
RECEIPT_NUM	Receipt number
WRITE_OFF_CODE	Write-off status for the write-off transaction
DESTINATION_TYPE_CODE	Destination type for the transaction
INVOICE_PRICE_VARIANCE	For pre-release 10 transactions, the reported IPV
PERIOD_ID	Periodic costing period unique identifier
WRITE_OFF_ID	Write-off 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
PO_TRANSACTION_ID	Receiving transaction unique identifier
REQUEST_ID	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
PERIOD_NAME	Accounting period name
WRITE_OFF_GL_DATE	The General Ledger date for the manual journal entry
TRANSACTION_ORGANIZATION_ID	Organization where transaction took place
ITEM_MASTER_ORGANIZATION_ID	Item Master/ Purchasing reference organization
ACCRUAL_ACCOUNT_ID	Accrual account unique identifier
ACCRUAL_CODE	Transaction type or A/P match condition
INV_TRANSACTION_ID	Inventory transaction unique identifier
PO_TRANSACTION_TYPE	Purchasing transaction date
LEGAL_ENTITY_ID	Legal entity unique identifier
COST_GROUP_ID	Cost group unique identifier
COST_TYPE_ID	Cost type unique identifier
ADJUSTMENT_TRANSACTION	Specifies if the transaction is a retro active price adjustment
INV_TRANSACTION_TYPE_ID	Inventory transaction type unique identifier
WIP_TRANSACTION_ID	WIP transaction unique identifier
WIP_TRANSACTION_TYPE_ID	WIP transaction type unique identifier
INVENTORY_ITEM_ID	Item unique identifier

Bills of Material - CST_AP_VARIANCE_BATCHES	Stores the parameters for each Invoice Variance Transfer Program run
Column Name	Descritpion
BATCH_ID	Batch identifier
CATEGORY_ID	Category identifier, applicable if category item option was chosen
CATEGORY_SET_ID	Category set identifier
CREATION_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATED_BY	Standard Who column
REQUEST_ID	Extended Who column
PROGRAM_APPLICATION_ID	Extended Who column
PROGRAM_ID	Extended Who column
PROGRAM_UPDATE_DATE	Extended Who column
ORGANIZATION_ID	Inventory organization identifier
LAST_UPDATE_LOGIN	Extended Who column
DESCRIPTION	Description as entered by the user at time of program submission
WIP_ENTITY_ID	WIP entity identifier
ITEM_TYPE	Item type
ITEM_OPTION	Item option specified at time of program submission
INVOICE_PROJECT_OPTION	Invoice option specified at time of program submission.
ADJUSTMENT_ACCOUNT	Adjustment account specified at time of program submission
CUTOFF_DATE	Invoice cut off date
TRANSACTION_PROCESS_MODE	Transaction process mode to control whether the update transactions are created in a state ready to import
SPECIFIC_ITEM_ID	Specific Item identifier, applicable only if specific item option was chosen
SPECIFIC_PROJECT_ID	Specific project identifier, applicable only if project invoice option was chosen

Bills of Material - CST_AP_VARIANCE_HEADERS	Stores the variance information for a purchase order distribution for each batch run
Column Name	Descritpion
VARIANCE_HEADER_ID	Variance header identifier
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
REQUEST_ID	Extended Who column
PROGRAM_APPLICATION_ID	Extended Who column
PROGRAM_ID	Extended Who column
PROGRAM_UPDATE_DATE	Extended Who column
LAST_UPDATE_LOGIN	Extended Who column
PO_DISTRIBUTION_ID	Purchase order distribution identifier for which invoice variance is computed
ORGANIZATION_ID	Inventory organization identifier
INVENTORY_ITEM_ID	Inventory item identifier
COST_GROUP_ID	Cost group identifier, applicable only if invoice option is chosen at time of program run
VAR_AMOUNT	Invoice variance amount
TRANSACTION_DATE	System derived date for average cost update transaction
BATCH_ID	Batch identifier that created this header record
CREATION_DATE	Standard Who column

Bills of Material - CST_AP_VARIANCE_LINES	Stores the variance information detail for a purchase order distribution and each batch run
Column Name	Descritpion
VARIANCE_HEADER_ID	Variance header identifier
VAR_AMOUNT	Invoice variance amount to be transferred to Inventory
PROJECT_ID	Project as indicated on the invoice
ORGANIZATION_ID	Inventory Organization to which the PO distribution will deliver
INVENTORY_ITEM_ID	Inventory item as indicated on the purchase order line
CREATION_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATED_BY	Standard Who column
REQUEST_ID	Extended Who column
PROGRAM_APPLICATION_ID	Extended Who column
VARIANCE_LINE_ID	Variance line identifier
PROGRAM_ID	Extended Who column
PROGRAM_UPDATE_DATE	Extended Who column
LAST_UPDATE_LOGIN	Standard Who column
COST_GROUP_ID	Cost Group Identifier
BATCH_ID	Batch identifier that created this record
INVOICE_DISTRIBUTION_ID	Invoice distribution ID as stored in AP tables
INVOICE_ID	Invoice ID as stored in AP tables
DISTRIBUTION_LINE_NUMBER	Invoice distribution line number
PO_DISTRIBUTION_ID	Purchase order distribution to which this invoice is matched
INVOICE_PRICE_VARIANCE	Invoice price variance amount
BASE_INVOICE_PRICE_VARIANCE	Invoice price variance amount in base currency

Bills of Material - CST_PC_TXN_HISTORY	CST_PC_TXN_HISTORY stores historical information about transactions processed by the periodic cost processor.
Column Name	Descritpion
PAC_PERIOD_ID	Period Identifier
NEW_COST	New Unit Cost
PRIOR_COST	Prior Unit Cost
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
REQUEST_ID	Extended Who column
PROGRAM_APPLICATION_ID	Extended Who column
PROGRAM_ID	Extended Who column
PROGRAM_UPDATE_DATE	Extended Who column
COST_GROUP_ID	Cost Group
LAST_UPDATE_LOGIN	Extended Who column
TXN_CATEGORY	Transaction Category
TRANSACTION_ID	Transaction identifier
PROCESS_SEQ	Sequence in which the transaction was processed
PROCESS_GROUP	Process Group categorization of transaction (For Internal use)
INVENTORY_ITEM_ID	Inventory item identifier
TXN_MASTER_QTY	Quantity expressed in the primary UOM of the Master Organization
PRIOR_COSTED_MASTER_QTY	Pre-transaction costed quantity expressed in the UOM of the master organization
ACTUAL_COST	Actual Unit Cost

Bills of Material - CST_BIS_MARGIN_BUILD	Stores margin analysis load run parameters
Column Name	Descritpion
BUILD_DESCRIPTION	Description of the build
FROM_DATE	Build date from value
TO_DATE	Build date to value
ORG_ID	Operating unit
HEADER_ID	Header identifier for the sales order
ORGANIZATION_ID	Organization identifier
COST_TYPE_ID	Cost type identifier
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_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
LEGAL_ENTITY_NAME	Legal Entity name
BUILD_ID	Build identifier
BUILD_NAME	Build name
LEGAL_ENTITY_ID	Legal Entity identifier

Bills of Material - CST_BIS_MARGIN_SUMMARY	Margin analysis summary table for reporting purposes
Column Name	Descritpion
ROW_TYPE	Identifies the type of a sales order line
RETURN_REFERENCE_ID	Return reference identifier for the RMA lines
LINK_TO_LINE_ID	Parent line identifier if RETURN_REFERENCE_TYPE_CODE is populated
RMA_HEADER_ID	Header identifier for the RMA lines
RMA_NUMBER	Order number for the RMA lines
RMA_INVENTORY_ITEM_ID	Inventory item identifier for the RMA lines
RMA_LINE_ID	Line identifier for the RMA lines
RMA_LINE_NUMBER	Line number for the RMA lines
RMA_ORGANIZATION_ID	Organization identifier for the RMA lines
RMA_LINE_TYPE_CODE	Line type code for the RMA lines
RMA_SHIP_TO_SITE_USE_ID	Site identifier for the shipped site for the RMA lines
ORIGIN	Identifies the origin of the record
RMA_INVOICE_INVENTORY_ITEM_ID	Invoiced inventory item identifier for the RMA lines
CR_TRX_ID	Credit memo identifier in RA_CUSTOMER_TRX
CR_TRX_LINE_ID	Credit memo Identifier in RA_CUSTOMER_TRX_LINES
PERIOD_NAME_YEAR	Year name from General Ledger Periods
PERIOD_NUM_YEAR	Number identifier of Year in General Ledger Period
INVOICE_SOURCE	Source of the invoice
PERIOD_NAME_QTR	Quarter name from General Ledger Periods
PERIOD_NUM_QTR	Number identifier of Quarter in General Ledger Period
PERIOD_SEQ_QTR	Sequence of General Ledger Period Quarter
PERIOD_NAME_MONTH	Month name from General Ledger Periods
PERIOD_NUM_MONTH	Number identifier of Month in General Ledger Period
PERIOD_SEQ_MONTH	Sequence of General Ledger Period Month
OE_ITEM_CATEGORY_ID	Item Category Identifier based on the default category set of the OE functional area
AREA_CODE	Identifier of Area level of the BIS geography dimension
PARENT_ROWID	Identifier of SO_ORDER_LINES
COUNTRY_CODE	Identifier of Country level of the BIS geography dimension
REGION_CODE	Identifier of Region level of the BIS geography dimension
AREA_NAME	Name of Area level of the BIS geography dimension
COUNTRY_NAME	Name of Country level of the BIS geography dimension
MARGIN_PK	Margin Primary Key
ORDER_NUMBER	Order number of the sales order
REGION_NAME	Name of Region level of the BIS geography dimension
OPERATING_UNIT_NAME	Name of Operating Unit
ORG_ID	Operating unit
HEADER_ID	Order header identifier
ORDER_TYPE_ID	Order type identifier
CUSTOMER_ID	Customer identifier
SOLD_TO_CUSTOMER_NAME	Customer name based on customer identifier
PRIMARY_SALESREP_ID	Primary sales representative identifier
SALES_CHANNEL_CODE	Sales channel code identifier
PARENT_INVENTORY_ITEM_ID	Parent inventory item identifier in case of a non-standard item
PARENT_ORGANIZATION_ID	Organization identifier for the parent item
LEGAL_ENTITY_ID	Legal Entity Identifier
PARENT_LINE_ID	Line identifier for the parent line
PARENT_LINE_NUMBER	Line number for the parent line
PARENT_ITEM_TYPE_CODE	Type identifier of the parent item, i.e. Standard, Model, Class, etc.
PARENT_ATO_FLAG	Flag indicating if the order line is for ATO
INVENTORY_ITEM_ID	Inventory item identifier for the child line
ORGANIZATION_ID	Organization identifier for the child line
LINE_ID	Line identifier for the child line
LINE_TYPE_CODE	Line type code for the child line
LINE_NUMBER	Line number for the child line
SHIP_TO_SITE_USE_ID	Ship to site identifier
BUILD_ID	Build identifier
SHIP_TO_CUSTOMER_NAME	Customer name based on SHIP_TO_SITE_USE_ID
INVOICE_TO_SITE_USE_ID	Site identifier for the invoiced site information
BILL_TO_CUSTOMER_NAME	Customer name based on the INVOICE_TO_SITE_USE_ID
CUSTOMER_TRX_ID	Identifier for RA_CUSTOMER_TRX
CUSTOMER_TRX_LINE_ID	Identifier for RA_CUSTOMER_TRX_LINES
ORIGINAL_GL_DATE	Original General ledger Date
GL_DATE	General ledger date
INVOICE_LINE_QUANTITY	Quantity invoiced for entire order line
INVOICE_QUANTITY	Quantity invoiced for invoice line
ORDER_LINE_QUANTITY	Order quantity for order line
SOURCE	Identifies source of the record
SHIP_QUANTITY	Actual shipment quantity
INVOICED_AMOUNT	Invoiced amount
COGS_AMOUNT	Cost of goods sold amount
SALES_ACCOUNT	Sales account identifier
COGS_ACCOUNT	Cost of goods sold identifier
TERRITORY_ID	Territory identifier
CUSTOMER_CLASS_CODE	Industry identifier
MARGIN	Margin
MARGIN_PCT	Margin percentage
RETURN_REFERENCE_TYPE_CODE	Return reference type identifier for the RMA lines

Bills of Material - CST_MARGIN_SUMMARY	Margin analysis summary table for reporting purposes
Column Name	Descritpion
ORIGIN	Identifies the origin of the record
LINK_TO_LINE_ID	Parent line identifier if RETURN_REFERENCE_TYPE_CODE is populated
RMA_HEADER_ID	Header identifier for the RMA lines
RMA_NUMBER	Order number for the RMA lines
RMA_INVENTORY_ITEM_ID	Inventory item identifier for the RMA lines
RMA_LINE_ID	Line identifier for the RMA lines
RMA_LINE_NUMBER	Line number for the RMA lines
RMA_ORGANIZATION_ID	Organization identifier for the RMA lines
RMA_LINE_TYPE_CODE	Line type code for the RMA lines
RMA_SHIP_TO_SITE_USE_ID	Site identifier for the shipped site for the RMA lines
RMA_INVOICE_INVENTORY_ITEM_ID	Invoiced inventory item identifier for the RMA lines
INVOICE_SOURCE	Source of the invoice
CR_TRX_ID	Credit memo identifier in RA_CUSTOMER_TRX
CR_TRX_LINE_ID	Credit memo Identifier in RA_CUSTOMER_TRX_LINES
PERIOD_NAME_YEAR	Year name from General Ledger Periods
PERIOD_NUM_YEAR	Number identifier of Year in General Ledger Period
PERIOD_NAME_QTR	Quarter name from General Ledger Periods
PARENT_ROWID	Identifier of SO_ORDER_LINES
PERIOD_NUM_QTR	Number identifier of Quarter in General Ledger Period
PERIOD_SEQ_QTR	Sequence of General Ledger Period Quarter
PERIOD_NAME_MONTH	Month name from General Ledger Periods
PERIOD_NUM_MONTH	Number identifier of Month in General Ledger Period
PERIOD_SEQ_MONTH	Sequence of General Ledger Period Month
OE_ITEM_CATEGORY_ID	Item Category Identifier based on the default category set of the OE functional area
AREA_CODE	Identifier of Area level of the BIS geography dimension
COUNTRY_CODE	Identifier of Country level of the BIS geography dimension
ORDER_NUMBER	Order number of the sales order
REGION_CODE	Identifier of Region level of the BIS geography dimension
AREA_NAME	Name of Area level of the BIS geography dimension
COUNTRY_NAME	Name of Country level of the BIS geography dimension
REGION_NAME	Name of Region level of the BIS geography dimension
LEGAL_ENTITY_ID	Legal Entity Identifier
ORG_ID	Operating unit
OPERATING_UNIT_NAME	Name of Operating Unit
HEADER_ID	Order header identifier
ORDER_TYPE_ID	Order type identifier
CUSTOMER_ID	Customer identifier
SOLD_TO_CUSTOMER_NAME	Customer name based on customer identifier
PRIMARY_SALESREP_ID	Primary sales representative identifier
SALES_CHANNEL_CODE	Sales channel code identifier
PARENT_INVENTORY_ITEM_ID	Parent inventory item identifier in case of a non-standard item
PARENT_ORGANIZATION_ID	Organization identifier for the parent item
PARENT_LINE_ID	Line identifier for the parent line
BUILD_ID	Build identifier
PARENT_LINE_NUMBER	Line number for the parent line
PARENT_ITEM_TYPE_CODE	Type identifier of the parent item, i.e. Standard, Model, Class, etc.
PARENT_ATO_FLAG	Flag indicating if the order line is for ATO
INVENTORY_ITEM_ID	Inventory item identifier for the child line
ORGANIZATION_ID	Organization identifier for the child line
LINE_ID	Line identifier for the child line
LINE_TYPE_CODE	Line type code for the child line
LINE_NUMBER	Line number for the child line
SHIP_TO_SITE_USE_ID	Ship to site identifier
SHIP_TO_CUSTOMER_NAME	Customer name based on SHIP_TO_SITE_USE_ID
SOURCE	Identifies source of the record
INVOICE_TO_SITE_USE_ID	Site identifier for the invoiced site information
BILL_TO_CUSTOMER_NAME	Customer name based on the INVOICE_TO_SITE_USE_ID
CUSTOMER_TRX_ID	Identifier for RA_CUSTOMER_TRX
CUSTOMER_TRX_LINE_ID	Identifier for RA_CUSTOMER_TRX_LINES
ORIGINAL_GL_DATE	Original General ledger Date
GL_DATE	General ledger date
INVOICE_LINE_QUANTITY	Quantity invoiced for entire order line
INVOICE_QUANTITY	Quantity invoiced for invoice line
ORDER_LINE_QUANTITY	Order quantity for order line
SHIP_QUANTITY	Actual shipment quantity
ROW_TYPE	Identifies the type of a sales order line
INVOICED_AMOUNT	Invoiced amount
COGS_AMOUNT	Cost of goods sold amount
SALES_ACCOUNT	Sales account identifier
COGS_ACCOUNT	Cost of goods sold identifier
TERRITORY_ID	Territory identifier
CUSTOMER_CLASS_CODE	Industry identifier
MARGIN	Margin
MARGIN_PCT	Margin percentage
RETURN_REFERENCE_TYPE_CODE	Return reference type identifier for the RMA lines
RETURN_REFERENCE_ID	Return reference identifier for the RMA lines

Bills of Material - CST_INV_LAYERS	Stores layer information
Column Name	Descritpion
LAYER_ID	Layer identifier
TRANSACTION_SOURCE_ID	Transaction source identifier
TRANSACTION_SOURCE_TYPE_ID	Transaction source type identifier
TRANSACTION_SOURCE	Transaction source number
UNBURDENED_COST	Item unit cost minus this level material overhead
BURDEN_COST	This level material overhead
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
INV_LAYER_ID	Inventory layer identifier
REQUEST_ID	Standard who column
PROGRAM_APPLICATION_ID	Standard who column
PROGRAM_ID	Standard who column
PROGRAM_UPDATE_DATE	Standard who column
ORGANIZATION_ID	Organization identifier
INVENTORY_ITEM_ID	Item identifier
CREATION_QUANTITY	Inventory layer creation quantity
LAYER_QUANTITY	Current inventory layer quantity
LAYER_COST	Inventory layer cost
CREATE_TRANSACTION_ID	Transaction which created this layer
TRANSACTION_ACTION_ID	Transaction action identifier

Bills of Material - CST_INV_LAYER_COST_DETAILS	Stores inventory layer cost details
Column Name	Descritpion
LAYER_ID	Layer identifier
LAST_UPDATE_LOGIN	Standard who column
REQUEST_ID	Standard who column
PROGRAM_APPLICATION_ID	Standard who column
PROGRAM_ID	Standard who column
PROGRAM_UPDATE_DATE	Standard who column
INV_LAYER_ID	Inventory layer identifier
LEVEL_TYPE	Level identifier
COST_ELEMENT_ID	Cost element identifier
LAYER_COST	Inventory layer cost
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 - CST_ITEM_COST_DETAILS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
YIELDED_COST	Yielded Cost
BASIS_FACTOR	Basis Factor
INVENTORY_ITEM_ID	Inventory Item Identifier
ORGANIZATION_ID	Organization Identifier
USAGE_RATE_OR_AMOUNT	Usage Rate Or Amount
RESOURCE_RATE	Resource Rate
COST_TYPE_ID	Cost Type Identifier
ITEM_COST	Item Cost
SET_OF_BOOKS_ID	Set Of Books Identifier

Bills of Material - CST_ITEM_COSTS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
RESOURCE_COST	Resource Cost
MATERIAL_COST	Material Cost
TL_RESOURCE	This Level Resource
INVENTORY_ITEM_ID	Inventory Item Identifier
PL_OVERHEAD	Previous Level Overhead
PL_MATERIAL	Previous Level Material
TL_OVERHEAD	This Level Overhead
TL_MATERIAL	This Level Material
OUTSIDE_PROCESSING_COST	Outside Processing Cost
PL_OUTSIDE_PROCESSING	Previous Level Outside Processing
MATERIAL_OVERHEAD_COST	Material Overhead Cost
ORGANIZATION_ID	Organization Identifier
PL_MATERIAL_OVERHEAD	Previous Level Material Overhead
BURDEN_COST	Burden Cost
TL_OUTSIDE_PROCESSING	This Level Outside Processing
TL_MATERIAL_OVERHEAD	This Level Material Overhead
SET_OF_BOOKS_ID	Set of Books Identifier
PL_ITEM_COST	Previous Level Item Cost
PL_RESOURCE	Previous Level Resource
UNBURDENED_COST	Unburdened Cost
TL_ITEM_COST	This Level Item Cost
OVERHEAD_COST	Overhead Cost
COST_TYPE_ID	Cost Type Identifier
ITEM_COST	Item Cost

Bills of Material - CST_ELEMENTAL_COSTS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
INVENTORY_ITEM_ID	Inventory Item Identifier
ORGANIZATION_ID	Organization Identifier
STANDARD_COST	Standard Cost
COST_UPDATE_ID	Cost Update Identifier
SET_OF_BOOKS_ID	Set Of Books Identifier

Bills of Material - CST_DEPARTMENT_OVERHEADS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
DEPARTMENT_ID	Department Identifier
OVERHEAD_ID	Overhead Identifier
COST_TYPE_ID	Cost Type Identifier
RATE_OR_AMOUNT	Rate or Amount
SET_OF_BOOKS_ID	Set Of books identifier

Bills of Material - CST_COST_UPDATES_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
INVENTORY_ADJUSTMENT_VALUE	Adjustment total for on-hand inventories
WIP_ADJUSTMENT_VALUE	Adjustment total for work in progress
SCRAP_ADJUSTMENT_VALUE	Adjustment total for scrap
INTRANSIT_ADJUSTMENT_VALUE	Adjustment total for intransit inventories
COST_UPDATE_ID	Cost update session identifier
SET_OF_BOOKS_ID	Set Of Books Identifier

Bills of Material - CST_AP_VARIANCE_LINES_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
BASE_INVOICE_PRICE_VARIANCE	Base Invoice Price Variance
VAR_AMOUNT	Variance Amount
VARIANCE_LINE_ID	Variance Line Identifier
VARIANCE_HEADER_ID	Variance Header Identifier
SET_OF_BOOKS_ID	Set Of Books Identifier

Bills of Material - CST_AP_VARIANCE_HEADERS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
VAR_AMOUNT	Invoice variance amount
VARIANCE_HEADER_ID	Variance header identifier
SET_OF_BOOKS_ID	Set Of Books Identifier

Bills of Material - CST_AE_LINES_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
AE_LINE_ID	Line Identifier
ACCOUNTED_CR	Accounted Credit
ACCOUNTED_DR	Accounted Debit
CURRENCY_CONVERSION_RATE	Currency Conversion Rate
OVERHEAD_BASIS_FACTOR	Overhead Basis Factor
STAT_AMOUNT	Stat_amount
RATE_OR_AMOUNT	Rate or Amount
SET_OF_BOOKS_ID	Set Of Books Identifier

Bills of Material - CST_ACTIVITY_COSTS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
UNIT_COST	Unit Cost
ORGANIZATION_ID	Organization Identifier
ACTIVITY_ID	Activity Identifier
TOTAL_COST	Total Cost
COST_TYPE_ID	Cost Type Identifier
SET_OF_BOOKS_ID	Set Of Books Identifier

Bills of Material - CST_RESOURCE_COSTS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
RESOURCE_RATE	resource rate
RESOURCE_ID	resource identifier
COST_TYPE_ID	cost type identifier
SET_OF_BOOKS_ID	set of books identifier

Bills of Material - CST_RCV_ACQ_COST_DETAILS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
PRICE	Price
AMOUNT	Amount
ALLOCATED_AMOUNT	Allocated Amount
PARENT_AMOUNT	Parent Amount
DETAIL_ID	Detail Identifier
SET_OF_BOOKS_ID	Set Of Books identifier

Bills of Material - CST_RCV_ACQ_COSTS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
AMOUNT_AT_PO_PRICE	Amount At PO Price
PO_UNIT_PRICE	PO Unit Price
ACQUISITION_COST	Acquisition Cost
REC_EXCHG_RATE	Currency Conversion rate.
TOTAL_INVOICE_AMOUNT	Total Invoice Amount
HEADER_ID	Header Identifier
TOTAL_AMOUNT	Total Amount
SET_OF_BOOKS_ID	Set Of Books Identifier

Bills of Material - CST_QUANTITY_LAYERS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
RESOURCE_COST	Resource Cost
LAYER_ID	Layer Identifier
PL_OVERHEAD	Previous Level Overhead
PL_MATERIAL	Previous Level Material
TL_OVERHEAD	This Level Overhead
TL_MATERIAL	This Level Material
OUTSIDE_PROCESSING_COST	Outside Processing Cost
PL_OUTSIDE_PROCESSING	Previous Level Outside Processing
MATERIAL_OVERHEAD_COST	Material Overhead Cost
PL_MATERIAL_OVERHEAD	Previous Level Material Overhead
BURDEN_COST	Burden Cost
PL_ITEM_COST	Previous Level Item Cost
TL_OUTSIDE_PROCESSING	This Level Outside Processing
TL_MATERIAL_OVERHEAD	This Level Material Overhead
SET_OF_BOOKS_ID	Set Of Books Identifier
PL_RESOURCE	Previous Level Resource
UNBURDENED_COST	Unburdened Cost
TL_ITEM_COST	This Level Item Cost
OVERHEAD_COST	Overhead Cost
ITEM_COST	Item Cost
MATERIAL_COST	Material Cost
TL_RESOURCE	This Level Resource

Bills of Material - CST_PAC_ITEM_COST_DETAILS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
LEVEL_TYPE	Level Type
COST_LAYER_ID	Cost Layer Identifier
ITEM_MAKE_COST	Item Make Cost
COST_ELEMENT_ID	Cost Element Identifier
ITEM_BUY_COST	Item Buy Cost
ITEM_COST	Item Cost
SET_OF_BOOKS_ID	Set of books identifier

Bills of Material - CST_PAC_ITEM_COSTS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
MARKET_VALUE	Market Value
OVERHEAD_COST	Overhead Cost
ITEM_COST	Item Cost
MATERIAL_COST	Material Cost
TL_RESOURCE	This Level Resource
PL_OVERHEAD	Previous Level Overhead
PL_MATERIAL	Previous Level Material
BEGIN_ITEM_COST	Begin Item Cost
TL_OVERHEAD	This Level Overhead
TL_MATERIAL	This Level Material
OUTSIDE_PROCESSING_COST	Outside Processing Cost
RESOURCE_COST	Resource Cost
COST_GROUP_ID	Cost Group Identifier
PL_OUTSIDE_PROCESSING	Previous Level Outside Processing
MATERIAL_OVERHEAD_COST	Material Overhead Cost
ITEM_BUY_COST	Item Buy Cost
PL_MATERIAL_OVERHEAD	Previous Level Material Overhead
BURDEN_COST	Burden Cost
TL_OUTSIDE_PROCESSING	This Level Outside Processing
TL_MATERIAL_OVERHEAD	This Level Material Overhead
SET_OF_BOOKS_ID	Set Of Books Identifier
COST_LAYER_ID	Cost Layer Identifier
PL_ITEM_COST	Previous Level Item Cost
PAC_PERIOD_ID	Periodic Actual Costing Period Identifier
PL_RESOURCE	Previous Level Resource
UNBURDENED_COST	Unburdened Cost
ITEM_MAKE_COST	Item Make Cost
TL_ITEM_COST	This Level Item Cost

Bills of Material - CST_PAC_ACCRUAL_WRITE_OFFS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
TRANSACTION_AMOUNT	Transaction Amount
INVOICE_PRICE_VARIANCE	Invoice Price Variance
AVG_RECEIPT_PRICE	Average Receipt Price
TRANSACTION_ORGANIZATION_ID	Transaction Organization Identifier
TRANSACTION_UNIT_PRICE	Transaction Unit Price
SET_OF_BOOKS_ID	Set Of Books Identifier

Bills of Material - CST_LAYER_COST_DETAILS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
LEVEL_TYPE	Level Type
LAYER_ID	Layer Id
COST_ELEMENT_ID	Cost Element Id
ITEM_COST	Item Cost
SET_OF_BOOKS_ID	Set Of Books Identifier

Bills of Material - CST_ITEM_OVERHEAD_DEFAULTS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
ITEM_TYPE	Item Type
MATERIAL_OVERHEAD_ID	Material Overhead Identifier
ORGANIZATION_ID	Organization Identifier
CATEGORY_ID	Category Identifier
USAGE_RATE_OR_AMOUNT	Usage Rate Or Amount
SET_OF_BOOKS_ID	Set Of Books Identifier

Bills of Material - CST_AE_HEADERS_EFC	Euro as a Functional Currency Archive
Column Name	Descritpion
SET_OF_BOOKS_ID	Set Of Books Identifier
AE_HEADER_ID	AE Header Identifier

Bills of Material - CST_EAM_ASSET_PER_BALANCES	Cost information by asset
Column Name	Descritpion
PERIOD_SET_NAME	Period set name
ACTUAL_EQP_COST	Actual equipment cost
SYSTEM_ESTIMATED_MAT_COST	System estimated material cost
SYSTEM_ESTIMATED_LAB_COST	System estimated labor cost
SYSTEM_ESTIMATED_EQP_COST	System estimated equipment cost
MANUAL_ESTIMATED_MAT_COST	Manual estimated material cost
MANUAL_ESTIMATED_LAB_COST	Manual estimated labor cost
MANUAL_ESTIMATED_EQP_COST	Manual estimated equipment cost
PERIOD_START_DATE	Period start date
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
PERIOD_NAME	Period name
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
REQUEST_ID	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
MAINTENANCE_OBJECT_ID	Maintenance Object Identifier
MAINTENANCE_OBJECT_TYPE	Maintenance Object Type
ACCT_PERIOD_ID	Accounting period identifier
INVENTORY_ITEM_ID	Inventory item identifier for the asset
SERIAL_NUMBER	Serial number
ORGANIZATION_ID	Organization identifier
MAINT_COST_CATEGORY	Maintenance cost category
ACTUAL_MAT_COST	Actual material cost
ACTUAL_LAB_COST	Actual labor cost

Bills of Material - CST_EAM_ROLLUP_TEMP	Temporary table for assets rollup
Column Name	Descritpion
GROUP_ID	Group identifier
ACTUAL_LAB_COST	Actual labor cost
ACTUAL_EQP_COST	Actual equipment cost
SYSTEM_ESTIMATED_MAT_COST	System estimated material cost
SYSTEM_ESTIMATED_LAB_COST	System estimated labor cost
SYSTEM_ESTIMATED_EQP_COST	System estimated equipment cost
MANUAL_ESTIMATED_MAT_COST	Manual estimated material cost
MANUAL_ESTIMATED_LAB_COST	Manual estimated labor cost
MANUAL_ESTIMATED_EQP_COST	Manual estimated equipment cost
PERIOD_START_DATE	Period start date
LAST_UPDATE_DATE	Standard Who columns
PERIOD_SET_NAME	Period set name
LAST_UPDATED_BY	Standard Who columns
CREATION_DATE	Standard Who columns
CREATED_BY	Standard Who columns
REQUEST_ID	Standard Who columns
PROGRAM_APPLICATION_ID	Standard Who columns
MAINTENANCE_OBJECT_ID	Maintenance Object Identifier
MAINTENANCE_OBJECT_TYPE	Maintenance Object Type
PERIOD_NAME	Period name
INVENTORY_ITEM_ID	Inventory item identifier
SERIAL_NUMBER	Serial number
ORGANIZATION_ID	Organization identifier
ACCT_PERIOD_ID	Accounting period identifier
MAINT_COST_CATEGORY	Maintenance cost category
ACTUAL_MAT_COST	Actual material cost

Bills of Material - CST_EAM_HIERARCHY_SNAPSHOT	This temporary table contains a snapshot of hierarchies for which a cost rollup is required
Column Name	Descritpion
GROUP_ID	An identifier for the hierarchy that this record makes up
PROGRAM_APPLICATION_ID	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
OBJECT_ID	The entity id of the current node
OBJECT_TYPE	The entity type of the current node
PARENT_OBJECT_ID	The entity id of the current node's parent
PARENT_OBJECT_TYPE	The entity type of the current node's parent
LEVEL_NUM	A relative depth indicator of the hierarchy. The root node is indicated by level 0.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
REQUEST_ID	Standard Who column

Bills of Material - CST_EAM_COST_ELEMENTS	EAM cost elements
Column Name	Descritpion
EAM_COST_ELEMENT_ID	eAM cost element identifier
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
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
EAM_COST_ELEMENT	eAM cost element
DESCRIPTION	Description of eAM cost element
REQUEST_ID	Standard Who column

Bills of Material - CST_DEPT_OVERHEADS_INTERFACE	Open interface table for overhead rate information
Column Name	Descritpion
DEPARTMENT_ID	Department identifier
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
GROUP_ID	Group identifier
TRANSACTION_ID	Transaction identifier
PROCESS_FLAG	Indicates at what processing phase this row is in. Must be set to 1 initially
BASIS_TYPE	The basis Identifier 1. Item, 2. Lot, 3. Resource Units, 4. Resource Value, 5. Total Value, 6. Activity
RATE_OR_AMOUNT	Rate or Amount for the Overhead subelement
ACTIVITY_ID	Activity Identifier
DEPARTMENT_CODE	Department code
ACTIVITY	Activity Name
REQUEST_ID	Concurrent Who column
ERROR_CODE	Error Code
ERROR_EXPLANATION	Error Explanation
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
COST_TYPE_ID	Cost type identifier
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
COST_TYPE	Cost type name
ATTRIBUTE13	Descriptive Flexfield segment
ATTRIBUTE14	Descriptive Flexfield segment
ATTRIBUTE15	Descriptive Flexfield segment
ERROR_FLAG	Set to 'E' if there is an error
GROUP_DESCRIPTION	Description of Group
ORGANIZATION_ID	Organization identifier
ORGANIZATION_CODE	Organization code
OVERHEAD_ID	Overhead Identifier
OVERHEAD	Overhead Name
LAST_UPDATE_DATE	Standard Who column

Bills of Material - CST_RESOURCE_COSTS_INTERFACE	Open interface table for resource cost information
Column Name	Descritpion
RESOURCE_ID	Resource Identifier
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
GROUP_ID	Group identifier
TRANSACTION_ID	Transaction identifier
PROCESS_FLAG	Indicates at what processing phase this row is in. Must be set to 1 initially
RESOURCE_RATE	Resource unit cost
REQUEST_ID	Concurrent Who column
ERROR_CODE	Error Code
RESOURCE_CODE	Resource code
ERROR_EXPLANATION	Error Explanation
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
COST_TYPE_ID	Cost type 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
COST_TYPE	Cost type name
ERROR_FLAG	Set to 'E' if there is an error
GROUP_DESCRIPTION	Description of Group
ORGANIZATION_ID	Organization identifier
ORGANIZATION_CODE	Organization code
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Bills of Material - CST_RES_OVERHEADS_INTERFACE	Open interface table for resource overhead association information
Column Name	Descritpion
RESOURCE_ID	Reource Identifier
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
GROUP_ID	Group identifier
TRANSACTION_ID	Transaction identifier
PROCESS_FLAG	Indicates at what processing phase this row is in. Must be set to 1 initially
REQUEST_ID	Concurrent Who column
RESOURCE_CODE	Resource code
ERROR_CODE	Error Code
ERROR_EXPLANATION	Error Explanation
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
COST_TYPE_ID	Cost type 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
COST_TYPE	Cost type name
ATTRIBUTE15	Descriptive Flexfield segment
ERROR_FLAG	Set to 'E' if there is an error
GROUP_DESCRIPTION	Description of Group
ORGANIZATION_ID	Organization identifier
ORGANIZATION_CODE	Organization code
OVERHEAD_ID	Overhead Identifier
OVERHEAD	Overhead Name
LAST_UPDATE_DATE	Standard Who column

Bills of Material - CST_RCV_ACQ_COST_DETAILS_ADJ	This table hold the details for the Periodic Acquisition Cost Adjustment Process
Column Name	Descritpion
HEADER_ID	Header ID referencing the CST_RCV_ACQ_COSTS_ADJ table
ALLOCATED_AMOUNT	Whole or portion of the parent Invoice distribution amount
PARENT_AMOUNT	Immediate parent invoice distribution amount
AMOUNT	Whole or portion of the allocated amount
QUANTITY	Invoice quantity if source is invoice, uninvoiced quantity if source is PO
PRICE	Invoice price if source is INVOICE, PO price if source is PO
LINE_TYPE	Invoice Distribution Line type
LAST_UPDATE_DATE	Who column
LAST_UPDATED_BY	Who column
CREATION_DATE	Who column
CREATED_BY	Who column
DETAIL_ID	Unique Identifier for every detail row
REQUEST_ID	Who column
PROGRAM_APPLICATION_ID	Who column
PROGRAM_ID	Who column
PROGRAM_UPDATE_DATE	Who column
LAST_UPDATE_LOGIN	Who column
SOURCE_TYPE	The source type for the detail row
PO_LINE_LOCATION_ID	Source Shipment ID if source is PO
PARENT_DISTRIBUTION_ID	Invoice Distribution Identifier for the parent distribution
DISTRIBUTION_NUM	Serial Number of the distributions that make up the Acquisition Cost
LEVEL_NUM	Level in the hierarchy of the charge allocations
INVOICE_DISTRIBUTION_ID	Source Invoice Distribution Identifier
PARENT_INVOICE_DIST_ID	Immediate Parent Invoice Distribution identifier

Bills of Material - CST_RCV_ACQ_COSTS_ADJ	This table stores the header information for the Periodic Acquisition Cost Adjustment process
Column Name	Descritpion
HEADER_ID	Header ID for each row
AMOUNT_AT_PO_PRICE	The Total amount at PO price
TOTAL_AMOUNT	Sum of Invoiced amount and amount at PO Price
COSTED_QUANTITY	The total costed quantity considered for the Acquisition Cost
ACQUISITION_COST	The Acquisition Cost for the item
PO_LINE_LOCATION_ID	The Purchase order line location ID
PO_UNIT_PRICE	The unit price on the PO
PRIMARY_UOM	The primary unit of measure
REC_EXCHG_RATE	The exchange rate
LAST_UPDATE_DATE	Last Update Date
LAST_UPDATED_BY	Last Updated By
COST_GROUP_ID	Cost Group ID that refers to the Cost Group
CREATION_DATE	Creation Date
CREATED_BY	Created By
REQUEST_ID	Request ID of the Periodic Acquisition Cost adjustment process
PROGRAM_APPLICATION_ID	The Program Application ID
PROGRAM_ID	The Program ID
PROGRAM_UPDATE_DATE	Program Update Date
LAST_UPDATE_LOGIN	The last Update Login ID
MMT_TRANSACTION_ID	The transaction ID of the Update transaction in MMT
COST_TYPE_ID	Cost Type ID that refers to the Cost Type
PERIOD_ID	The PAC Period ID
RCV_TRANSACTION_ID	The Transaction ID of the parent Receipt
NET_QUANTITY_RECEIVED	The Net quantity Received for the receipt
TOTAL_QUANTITY_INVOICED	Total Quantity Invoiced
QUANTITY_AT_PO_PRICE	The quantity considered for acquisition cost at PO price
TOTAL_INVOICE_AMOUNT	The Total Invoice Amount

Bills of Material - CST_MATERIAL_OVHD_RULES	Stores material overhead rules
Column Name	Descritpion
RULE_ID	Rule Identifier
ITEM_FROM	Not currently used
ITEM_TO	Not currently used
ITEM_TYPE	Item type
SHIP_FROM_ORG	Not currently used
COST_TYPE_ID	Identifies the cost type identifier against which material overhead is earned.
EARN_MOH	Identifies if material overhead should be earned or not.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
ORGANIZATION_ID	Organization Identifier
TRANSACTION_TYPE	Transaction Type Identifier - determines the transaction type for which the rules is defined.
SELECTION_CRITERIA	Not currently used
CATEGORY_ID	Not currently used

Bills of Material - CST_EAM_WO_ESTIMATE_DETAILS	Details of estimated cost for work orders
Column Name	Descritpion
WIP_ENTITY_ID	WIP Entity Id - Identifier of Work Order
RESOURCE_RATE	Resource Rate
USAGE_RATE	Usage Rate
UOM	Unit of Measure
RESOURCE_INSTANCE_ID	Instance Identifier of the Resource
RESOURCE_INSTANCE_RATE	Instance Rate for the Resource
RESOURCE_USAGE	Resource Usage
INVENTORY_ITEM_ID	Inventory Item Identifier
ITEM_COST	Item Cost
REQUIRED_QUANTITY	Required Quantity of Material
REQUISITION_HEADER_ID	Requisition Header Id
ORGANIZATION_ID	Organization Identifier of Work Order
PO_HEADER_ID	Purchase Order header ID
RATE	Conversion rate
DIRECT_ITEM	Flag to determine whether it is a direct item
REQUISITION_LINE_ID	Requisition Line Identifier
PO_DISTRIBUTION_ID	Purchase Order Distribution Identifier
LINE_LOCATION_ID	Line Location Identifier
ITEM_DESCRIPTION	Item Description
PO_LINE_CANCEL_FLAG	Cancel flag for Purchase Order Line
REQ_LINE_CANCEL_FLAG	Cancel flag for Requisition Line
REQ_AUTH_STATUS	Requisition Authorization Status
OPERATIONS_DEPT_ID	Assigned Department Identifier of Operation
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	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
OPERATIONS_SEQ_NUM	Operation Sequence Number
MAINT_COST_CATEGORY	Maintenance Cost Category
OWNING_DEPT_ID	Owning Department Identifier
DEPT_OVERHEAD_COST	Overhead Cost for the Department
ESTIMATED_COST	Estimated Cost
RESOURCE_ID	Resource Identifier

Bills of Material - CST_EAM_ACTIVITY_ESTIMATES	Estimated costs for activities
Column Name	Descritpion
ACTIVITY_ESTIMATE_RECORD_ID	Activity Estimate Record Identifier
RECORD_TYPE	Record Type
ORGANIZATION_ID	Organization Identifier
ACTIVITY_ITEM_ID	Activity Inventory Item Identifier
EAM_COST_ELEMENT	EAM Cost Element
MAINT_COST_CATEGORY	Maintenance Cost Category
COST_VALUE	Cost Value

Bills of Material - CST_MGD_IAL_INVALID_MMT	Transaction types being excluded from inventory analytical ledger and inventory trial balance reports
Column Name	Descritpion
TRANSACTION_SOURCE_TYPE_ID	Transaction source type identifier that is associated with the transaction type
PROGRAM_ID	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
TRANSACTION_ACTION_ID	Transaction action identifier that is associated with the transaction type
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
REQUEST_ID	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column

Bills of Material - CST_PAC_INTORG_ITMS_TEMP	used in the interorg transfer iteration procedure
Column Name	Descritpion
COST_GROUP_ID	Cost Group Identifier
PAC_PERIOD_ID	PAC Period Identifier
ITEM_COST	Item Cost
PREV_ITR_ITEM_COST	Previous iteration PMAC Item Cost
LOW_LEVEL_CODE	Low Level Code of Inventory Item specific to cost group
ABSORPTION_LEVEL_CODE	Bill of Materials Level to which item is absorbed
TOLERANCE_FLAG	Tolerance Flag
ITERATION_COUNT	Iteration Count
INTERORG_RECEIPT_FLAG	Interorg Receipt Flag used in iteration process
INTERORG_SHIPMENT_FLAG	Interorg Shipment Flag used in Iteration Process of PACP
INVENTORY_ITEM_ID	Inventory Item Identifier
SEQUENCE_NUM	Optimal Sequence of Cost Group in Iteration Process
DIFFERENCE	Difference between current and previous iteration item cost
DIVERGING_FLAG	Diverging Flag

Bills of Material - CST_OSFM_UPGRADE_TEMP
Column Name	Descritpion
UPGRADE_DATE	Upgrade date
PENDING_MMTT_TXNS
UNCOSTED_MMT_TXNS
ERRORED_MMT_TXNS
UNCOSTED_WCTI_TXNS
ERRORED_WCTI_TXNS
UNCOSTED_WSMT_TXNS
ERRORED_WSMT_TXNS

Bills of Material - CST_EAM_ROLLUP_COSTS	Temporary table to store rollup costs
Column Name	Descritpion
GROUP_ID	An identifier for the hierarchy that this record corresponds to
ESTIMATED_LAB_COST	The estimated labor cost of this entity and its descendants
ESTIMATED_EQP_COST	The estimated equipment cost of this entity and its descendants
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATION_BY	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
OBJECT_TYPE	The entity type of the current node
OBJECT_ID	The entity type of the current node
ACCT_PERIOD_ID	The accounting period when the costs are incurred
PERIOD_SET_NAME	Period Set Name
PERIOD_NAME	Period Name
MAINT_COST_CATEGORY	The maintenance cost category
ACTUAL_MAT_COST	The actual material cost of this entity and its descendants
ACTUAL_LAB_COST	The actual labor cost of this entity and its descendants
ACTUAL_EQP_COST	The actual equipment cost of this entity and its descendants
ESTIMATED_MAT_COST	The estimated material cost of this entity and its descendants

Bills of Material - CST_CAT_ELE_EXP_ASSOCS	Stores associations between categories, cost elements, and expenditure types
Column Name	Descritpion
CATEGORY_ID	Category ID
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
MNT_COST_ELEMENT_ID	Maintenance Cost Element ID
MFG_COST_ELEMENT_ID	Manufacturing Cost Element ID
START_DATE	Start Enable Date
END_DATE	End Enable Date
EXPENDITURE_TYPE_ID	Direct Item Expenditure Type ID
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

Bills of Material - CST_PERIOD_CLOSE_SUMMARY	This table stores item level period end balances for summarized periods
Column Name	Descritpion
ACCT_PERIOD_ID	Accounting period 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
ACCOUNTED_VALUE	The period close value calculated from accounting distributions
ROLLBACK_VALUE	The period close value calculated by rolling back transaction quantity and cost
ROLLBACK_QUANTITY	The period close quantity obtained by rolling back transaction quantity
ROLLBACK_ONHAND_VALUE	Onhand portion of the rollback value
ROLLBACK_INTRANSIT_VALUE	Intransit portion of the rollback value
ACCOUNTED_ONHAND_VALUE	Onhand portion of the accounted value
ACCOUNTED_INTRANSIT_VALUE	Intransit portion of the accounted value
ONHAND_VALUE_DISCREPANCY	Difference between the rollback onhand value and the accounted onhand value
ORGANIZATION_ID	Organization identifier
INTRANSIT_VALUE_DISCREPANCY	Difference between the rollback intransit value and the accounted intransit value
CUMULATIVE_ONHAND_MTA	Onhand portion of the cumulative accounting distributions
CUMULATIVE_INTRANSIT_MTA	Intransit portion of the cumulative accounting distributions
COST_GROUP_ID	Cost group identifier
SUBINVENTORY_CODE	Subinventory identifier
INVENTORY_ITEM_ID	Item identifier
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
CREATION_BY	Standard WHO column

Bills of Material - CSTGILEV_TEMP
Column Name	Descritpion
ITEM_ID
TOTAL_LAYER_QUANTITY
INVENTORY_VALUE
TOTAL_INVENTORY_VALUE
ITEM_CODE
UOM_CODE
ITEM_DESC
PERIOD_ID
PERIOD_NAME
WAC
LIFO_COST
MARKET_VALUE
JUSTIFICATION
LAYER_QUANTITY

Bills of Material - CST_CG_LIST_TEMP	Temporary list of cost groups for use in cost reporting
Column Name	Descritpion
COST_GROUP_ID	Cost group identifier from cst_cost_groups

Bills of Material - CST_COGS_QTY_ADJ_EVENTS_TEMP	Global Temporary table used for matching COGS to Revenue in the package CST_RevenueCogsMatch_PVT. This table specifically helps create bulk quantity adjustment events which may result from backdated RMA receipts.
Column Name	Descritpion
ADJ_EVENT_ID
INVENTORY_ITEM_ID
PRIMARY_UOM
ORGANIZATION_ID
COST_GROUP_ID
COGS_ACCT_ID
OPM_ORG_FLAG
ACCT_PERIOD_ID
ADJ_MMT_TXN_ID
ADJ_COGS_OM_LINE_ID
ADJ_RMA_OM_LINE_ID
ADJ_EVENT_DATE
ADJ_NEW_COGS_PERCENTAGE
ADJ_PRIOR_COGS_PERCENTAGE
ADJ_EVENT_QUANTITY
PARENT_EVENT_ID

Bills of Material - CST_COGS_PCT_ADJ_EVENTS_TEMP	Global Temporary table used for matching COGS to Revenue in the package CST_RevenueCogsMatch_PVT. This table specifically helps create bulk percentage adjustment events which may result from backdated COGS recognition events.
Column Name	Descritpion
ADJ_EVENT_ID
INVENTORY_ITEM_ID
PRIMARY_UOM
ORGANIZATION_ID
COST_GROUP_ID
COGS_ACCT_ID
OPM_ORG_FLAG
ACCT_PERIOD_ID
ADJ_MMT_TXN_ID
ADJ_COGS_OM_LINE_ID
ADJ_EVENT_DATE
ADJ_NEW_COGS_PERCENTAGE
ADJ_PRIOR_COGS_PERCENTAGE
ADJ_PRIOR_EVENT_ID
ADJ_EVENT_QUANTITY
FTR_EVENT_ID

Bills of Material - CST_INV_COST_TEMP	A temporary table to store intermediate results for period close summarization and inventory valuation reports
Column Name	Descritpion
COST_SOURCE	Identifies the code module that has created the row
OUTSIDE_PROCESSING_COST	Outside processing cost
RESOURCE_COST	Resource cost
OVERHEAD_COST	Overhead cost
INVENTORY_ASSET_FLAG	Asset status of the item
ORGANIZATION_ID	Organization identifier
INVENTORY_ITEM_ID	Item identifier
COST_TYPE_ID	The item costs and asset status correspond to this cost type
COST_GROUP_ID	In actual costing organizations, the item costs correspond to this cost group
RCV_TRANSACTION_ID	Receiving transaction identifier
ITEM_COST	Item unit cost
MATERIAL_COST	Material cost
MATERIAL_OVERHEAD_COST	Material overhead cost

Bills of Material - CST_INV_QTY_TEMP	A temporary table to store intermediate results for period close summarization, standard cost update and inventory valuation reports
Column Name	Descritpion
QTY_SOURCE	Identifies the code module that has created the row
TXN_SOURCE_TYPE_ID	Identifies the source type of the transaction that we are rolling back
CATEGORY_ID	Category identifier
COST_TYPE_ID	The cost type against which the asset status of the item is checked
FROM_ORGANIZATION_ID	Identifies the organization that the intransit quantity originated from
TO_ORGANIZATION_ID	Identifies the organization that the intransit quantity is going to
RCV_TRANSACTION_ID	Receiving Transaction Identifier
SHIPMENT_LINE_ID	Shipment Line Identifier
INTRANSIT_INV_ACCOUNT	The account that holds the intransit value
ORGANIZATION_ID	Organization identifier
INVENTORY_ITEM_ID	Item identifier
COST_GROUP_ID	Cost group identifier
SUBINVENTORY_CODE	Identifies the subinventory
ACCOUNTED_VALUE	Value obtained from summing the accounting distributions
ROLLBACK_VALUE	Value obtained from the quantity and cost of transactions that are being rolled back
ROLLBACK_QTY	Quantity contributing to the inventory value
REVISION	Item revision

Bills of Material - CST_EAM_DIRECT_ITEMS_TEMP
Column Name	Descritpion
WORK_ORDER_NUMBER
RQL_ORDERED
QUANTITY_ORDERED
QUANTITY_RECEIVED
LATEST_DELIVERY_DATE
PO_QUANTITY_ORDERED
PO_QUANTITY_CANCELLED
SUPPLIER_NAME
SUPPLIER_NUMBER
LINE_LOCATION_ID
PO_LINE_CANCEL_FLAG
TASK_NUMBER
ITEM_ID
CLOSED_CODE
PO_CLOSED_CODE
REQ_AUTHORIZATION_STATUS
PO_AUTHORIZATION_STATUS
PO_LINE_ID
PO_HEADER_ID
REQUISITION_HEADER_ID
DIRECT_ITEM_SEQUENCE_ID
CATEGORY_ID
ORGANIZATION_ID
PO_RELEASE_ID
REQUISITION_LINE_ID
ORDER_TYPE_LOOKUP_CODE
AMOUNT
AMOUNT_DELIVERED
REQ_DISTRIBUTION_ID
CATEGORY_DATE
PROJECT_ID
PURCHASING_OU_ID
SET_OF_BOOKS_ID
DEPARTMENT_ID
TXN_FLOW_HEADER_ID
RECEIVING_OU_ID
CURRENCY_CODE
CURRENCY_DATE
CURRENCY_TYPE
CURRENCY_RATE
DOCUMENT_TYPE
IS_SHARED_PROC
REQUISITION_NUMBER
PO_NUMBER
ITEM_DESCRIPTION
UOM_CODE
UNIT_PRICE

Bills of Material - CST_ITEM_COSTS_TEMP	A temporary table to snapshot new item costs during standard cost update
Column Name	Descritpion
INVENTORY_ITEM_ID
PL_OUTSIDE_PROCESSING
PL_OVERHEAD
TL_OVERHEAD
TL_MATERIAL
TL_MATERIAL_OVERHEAD
TL_RESOURCE
TL_OUTSIDE_PROCESSING
MATERIAL_COST
MATERIAL_OVERHEAD_COST
RESOURCE_COST
INVENTORY_ASSET_FLAG
OUTSIDE_PROCESSING_COST
OVERHEAD_COST
COST_UPDATE_ID
PL_ITEM_COST
TL_ITEM_COST
UNBURDENED_COST
BURDEN_COST
ITEM_COST
ATTRIBUTE_CATEGORY
ATTRIBUTE1
LOT_SIZE
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
BASED_ON_ROLLUP_FLAG
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
SHRINKAGE_RATE
DEFAULTED_FLAG
PL_MATERIAL
PL_MATERIAL_OVERHEAD
PL_RESOURCE

Bills of Material - CST_ITEM_LIST_TEMP	Temporary list of items for use in cost reporting
Column Name	Descritpion
INVENTORY_ITEM_ID	Item identifier from mtl_system_items
CATEGORY_ID	Category identifier from mtl_categories
COST_TYPE_ID	Cost type identifier from cst_cost_types

Bills of Material - CST_MGD_MSTR_BOOK_TEMP
Column Name	Descritpion
TRANSACTION_ID
TXN_QTY
TXN_UNIT_COST
TXN_H_TOTAL_COST
TXN_ADJ_TOTAL_COST
TXN_FNL_QTY
TXN_FNL_UNIT_COST
TXN_FNL_H_TOTAL_COST
TXN_FNL_ADJ_TOTAL_COST
UOM_CODE
ITEM_CODE
ORGANIZATION_ID
ITEM_DESC
ORG_NAME
CURRENCY_CODE
TXN_SOURCE
CREATION_DATE
SUB_INV_ORGANIZATION_ID
SUBINVENTORY_CODE
INVENTORY_ITEM_ID
TXN_DATE
TXN_TYPE
TXN_INI_QTY
TXN_INI_UNIT_COST
TXN_INI_H_TOTAL_COST
TXN_INI_ADJ_TOTAL_COST

Bills of Material - CST_PM_MATL_TXNS_TEMP	Temporary table for use by Cost Collection Manager Concurrent program
Column Name	Descritpion
TRANSACTION_ID
INVENTORY_ITEM_ID
PRIMARY_QUANTITY
COSTED_FLAG
PRIMARY_COST_METHOD
AVG_RATES_COST_TYPE_ID
ITEM_DESCRIPTION
COST_GROUP_ID
TRANSFER_COST_GROUP_ID
TRANSACTION_SOURCE_ID
TO_PROJECT_ID
ORGANIZATION_ID
TO_TASK_ID
SOURCE_PROJECT_ID
SOURCE_TASK_ID
TRANSFER_TRANSACTION_ID
ACCT_PERIOD_ID
EXP_ORG_ID
DISTRIBUTION_ACCOUNT_ID
PM_COST_COLLECTOR_GROUP_ID
SI_ASSET_YES_NO
TRANSFER_SI_ASSET_YES_NO
TRANSACTION_ACTION_ID
PM_COST_COLLECTED
SUBINVENTORY_CODE
TRANSFER_SUBINVENTORY
TRANSFER_ORGANIZATION_ID
INVENTORY_ASSET_FLAG
FLOW_SCHEDULE
TRANSACTION_SOURCE_TYPE_ID
TYPE_CLASS
EXPENDITURE_TYPE
TRANSACTION_DATE
PROJECT_ID
TASK_ID

Bills of Material - CST_PER_END_ACCRUALS_TEMP	Period End Accruals transaction specific temporary table
Column Name	Descritpion
SHIPMENT_ID	PO Shipment Identifier
ACCRUAL_AMOUNT	Accrual amount
ENCUM_AMOUNT	Encumbrance amount
CURRENCY_CODE	Currency code
CURRENCY_CONVERSION_TYPE	Currency conversion rate type
CURRENCY_CONVERSION_RATE	Currency conversion rate
CURRENCY_CONVERSION_DATE	Currency conversion date
DISTRIBUTION_ID	PO Distribution Identifier
CATEGORY_ID	Item Category Identifier
MATCH_OPTION	Match Option
QUANTITY_RECEIVED	Amount or quantity received
QUANTITY_BILLED	Amount or quantity invoiced
ACCRUAL_QUANTITY	Accrual quantity
ENCUM_QUANTITY	Encumbrance quantity
UNIT_PRICE	Distribution unit price

Bills of Material - CST_RECONCILIATION_GTT
Column Name	Descritpion
TRANSACTION_DATE
RCV_TRANSACTION_ID
INVOICE_DISTRIBUTION_ID
ACCRUAL_ACCOUNT_ID
TRANSACTION_TYPE_CODE
INVENTORY_ITEM_ID
VENDOR_ID
INVENTORY_ORGANIZATION_ID
WRITE_OFF_ID
DESTINATION_TYPE_CODE
AE_HEADER_ID	Accounting Header Identifier
AMOUNT
AE_LINE_NUM	Accounting Line Number
OPERATING_UNIT_ID
BUILD_ID
REQUEST_ID
ENTERED_AMOUNT
QUANTITY
CURRENCY_CODE
CURRENCY_CONVERSION_TYPE
CURRENCY_CONVERSION_RATE
CURRENCY_CONVERSION_DATE
PO_DISTRIBUTION_ID

Bills of Material - CST_ACCRUAL_ACCOUNTS	Stores the accrual account information for accrual reconciliation modules
Column Name	Descritpion
OPERATING_UNIT_ID	Operating Unit Identifier
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
REQUEST_ID	Concurrent Who Column
PROGRAM_APPLICATION_ID	Concurrent Who Column
ACCRUAL_ACCOUNT_ID	Accrual Account Identifier
PROGRAM_ID	Concurrent Who Column
PROGRAM_UPDATE_DATE	Concurrent Who Column

Bills of Material - CST_AP_PO_RECONCILIATION	Table to Store the Deatils of Purchasing and Payables Transactions
Column Name	Descritpion
AMOUNT	Transaction Amount
LAST_UPDATE_LOGIN	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_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
AE_LINE_NUM	Accounting Line Number
ENTERED_AMOUNT	Entered Transaction Amount
QUANTITY	Transaction Quantity
CURRENCY_CODE	Currency Code
CURRENCY_CONVERSION_TYPE	Currency Conversion Type
CURRENCY_CONVERSION_RATE	Currency Conversion Rate
CURRENCY_CONVERSION_DATE	Currency Conversion Date
PO_DISTRIBUTION_ID	PO Distribution Identifier
TRANSACTION_DATE	Accounting Line Number
RCV_TRANSACTION_ID	Receiving Transaction Identifier
INVOICE_DISTRIBUTION_ID	Invoice Distribution Identifier
ACCRUAL_ACCOUNT_ID	Accrual Account Identifier
TRANSACTION_TYPE_CODE	Transaction Type Identifier
INVENTORY_ORGANIZATION_ID	Organization Identifier
WRITE_OFF_ID	Write-Off Identifier
OPERATING_UNIT_ID	Operating Unit Identifier
BUILD_ID	Build Identifier
AE_HEADER_ID	Accounting Header Identifier
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column

Bills of Material - CST_RECONCILIATION_SUMMARY	Table to store summary information for related Purchasing and Payables tranactions in Accrual Reconciliation
Column Name	Descritpion
ACCRUAL_ACCOUNT_ID	Accrual Account Identifier
REQUEST_ID	Concurrent Who Column
PROGRAM_APPLICATION_ID	Concurrent Who Column
PROGRAM_ID	Concurrent Who Column
PROGRAM_UPDATE_DATE	Concurrent Who Column
PO_BALANCE	Total Balance of all PO Transactions
AP_BALANCE	Total Balance of all PO Transactions
WRITE_OFF_BALANCE	Total Balance of all Write-Off Transactions
LAST_RECEIPT_DATE	Date of the Latest Receipt
LAST_INVOICE_DIST_DATE	Date of the Latest Invoice
LAST_WRITE_OFF_DATE	Date of the Latest Write-Off
INVENTORY_ITEM_ID	Item Identifier
PO_DISTRIBUTION_ID	PO Distribution Identifier
VENDOR_ID	Vendor Identifier
DESTINATION_TYPE_CODE	Destination Type Identifier
WRITE_OFF_SELECT_FLAG	Internal Record Selection
OPERATING_UNIT_ID	Operating Unit Identifier
BUILD_ID	Build Identifier
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 - CST_RECONCILIATION_BUILD	Stores the build information for the accrual reconciliation load run
Column Name	Descritpion
OPERATING_UNIT_ID	Operating Unit Identifier
FROM_DATE	Start Date
TO_DATE	End 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
BUILD_ID	Build Identifier
REQUEST_ID	Concurrent Who Column
PROGRAM_APPLICATION_ID	Concurrent Who Column
PROGRAM_ID	Concurrent Who Column
PROGRAM_UPDATE_DATE	Concurrent Who Column

Bills of Material - CST_MISC_RECONCILIATION	Table to store miscellaneous AP transactions and any INV transactions that hit an accrual account
Column Name	Descritpion
AMOUNT	Transaction Amount
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
REQUEST_ID	Concurrent Who Column
PROGRAM_APPLICATION_ID	Concurrent Who Column
PROGRAM_ID	Concurrent Who Column
PROGRAM_UPDATE_DATE	Concurrent Who Column
AE_LINE_NUM	Accounting Line Number
ENTERED_AMOUNT	Entered Transaction Amount
QUANTITY	Transaction Quantity
CURRENCY_CODE	Currency Code
CURRENCY_CONVERSION_TYPE	Currency Conversion Type
CURRENCY_CONVERSION_RATE	Currency Conversion Type
CURRENCY_CONVERSION_DATE	Currency Conversion Date
INVOICE_DISTRIBUTION_ID	Invoice Distribution Identifier
TRANSACTION_DATE	Transaction Date
INVENTORY_TRANSACTION_ID	Inventory Transaction Identifier
PO_DISTRIBUTION_ID	PO Distribution Identifier
ACCRUAL_ACCOUNT_ID	Accrual Account Identifier
TRANSACTION_TYPE_CODE	Transaction Type Identifier
INVENTORY_ITEM_ID	Item Identifier
VENDOR_ID	Vendor Identifier
INVENTORY_ORGANIZATION_ID	Organization Identifier
WRITE_OFF_SELECT_FLAG	Internal Record Selection
OPERATING_UNIT_ID	Operating Unit Identifier
BUILD_ID	Build Identifier
AE_HEADER_ID	Accounting Header Identifier

Bills of Material - CST_PAC_REQ_OPER_COST_DETAILS	Stores periodic balance of all WIP entities within a cost group by period for BOM based algo Cost Types
Column Name	Descritpion
PAC_PERIOD_ID	PAC Period ID
RELIEVED_VALUE	Relieved Value
RELIEVED_QUANTITY	Relieved Quantity
COMP_VARIANCE	Comp variance
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
CREATED_BY	Standard Who Column
REQUEST_ID	Concurrent Who Column
PROGRAM_APPLICATION_ID	Concurrent Who Column
PROGRAM_ID	Concurrent Who Column
COST_GROUP_ID	Cost Group ID
PROGRAM_UPDATE_DATE	Concurrent Who Column
LAST_UPDATE_LOGIN	Standard Who Column
TEMP_RELIEVED_VALUE	Temp Relieved Value
WIP_ENTITY_ID	WIP ENTITY ID
LINE_ID	LINE ID
OPERATION_SEQ_NUM	Operation Sequence Number
INVENTORY_ITEM_ID	Component Id
COST_ELEMENT_ID	Cost Element Id
APPLIED_VALUE	Applied Value to the Job
APPLIED_QUANTITY	Applied Component Qty

Bills of Material - CST_PAC_PERIOD_BALANCES	PAC period balances for transaction categories
Column Name	Descritpion
PAC_PERIOD_ID	PAC Period ID
TXN_CATEGORY_VALUE	Cumulative transaction value for this transaction category
PERIOD_QUANTITY	Cumulative quantity for the period (across transaction categories)
PERIODIC_COST	Periodic Cost after processing this transaction category
PERIOD_BALANCE	Cumulative balance for the period (across transaction categories)
VARIANCE_AMOUNT	Cumulative Variance for this transaction category
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
COST_GROUP_ID	Cost Group ID
REQUEST_ID	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
INVENTORY_ITEM_ID	Transaction Item ID
COST_LAYER_ID	Cost Layer ID
QUANTITY_LAYER_ID	Quantity Layer ID
COST_ELEMENT_ID	Cost Element ID
LEVEL_TYPE	Level Type
TXN_CATEGORY	Transaction Category
TXN_CATEGORY_QTY	Cumulative Quantity for this transaction Category

Bills of Material - CST_PAC_ITMS_ABSL_CODES	CST_PAC_ITMS_ABSL_CODES is used in the Absorption Cost Rollup process of PACP
Column Name	Descritpion
INVENTORY_ITEM_ID	Inventory Item Identifier
ABSORPTION_LEVEL_CODE	Absorption Level Code used in Absorption Cost Rollup Process
PROCESS_FLAG	Process Flag to identify whether an item is processed or not
PAC_PERIOD_ID	PAC Period Identifier

Bills of Material - CST_PAC_EAM_BALANCE_BY_ACCTS	Estimated Cost Information by WAC Accounts for PAC
Column Name	Descritpion
LEGAL_ENTITY_ID	Legal Entity
OPERATIONS_SEQ_NUM	Operations seq num
MAINT_COST_CATEGORY	Maintenance cost category
OWNING_DEPT_ID	Owning department id
PERIOD_START_DATE	Period start date
ACCOUNT_ID	Wip Accounting Class Account id
ACCT_VALUE	Amount charged to the acct
TXN_TYPE	Material, Labor or Equipment
WIP_ACCT_CLASS_CODE	Accounting Class Code
MFG_COST_ELEMENT_ID	Manufacturing Cost Element Id
CREATED_BY	Who Column
COST_GROUP_ID	Cost Group
CREATION_DATE	Who Column
LAST_UPDATED_BY	Who Column
LAST_UPDATE_LOGIN	Who Column
LAST_UPDATE_DATE	Who Column
COST_TYPE_ID	Cost Type
PERIOD_SET_NAME	Period Set Name
PERIOD_NAME	Period Name
ACCT_PERIOD_ID	Account period ID. Can be 0 if a future period.
WIP_ENTITY_ID	Job id
ORGANIZATION_ID	Organization id
OPERATIONS_DEPT_ID	Operations deparment id

Bills of Material - CST_PAC_EAM_PERIOD_BALANCES	PAC eAM Asset balances details
Column Name	Descritpion
LEGAL_ENTITY_ID	Legal Entity ID
OPERATIONS_DEPT_ID	Operation Department ID
OPERATION_SEQ_NUM	Operation Seq Number
MAINT_COST_CATEGORY	Maintenance Cost Category
ACTUAL_MAT_COST	Actual Material Cost
ACTUAL_LAB_COST	Actual Labour Cost
ACTUAL_EQP_COST	Actual Equipment Cost
SYSTEM_ESTIMATED_MAT_COST	Estimated Material Cost
SYSTEM_ESTIMATED_LAB_COST	Estimated Labour Cost
SYSTEM_ESTIMATED_EQP_COST	Estimated Equipment Cost
PERIOD_START_DATE	Period Start Date
COST_GROUP_ID	PAC Cost Group 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
COST_TYPE_ID	PAC Cost Type ID
PERIOD_SET_NAME	Period Set Name
PERIOD_NAME	PAC Period Name
PAC_PERIOD_ID	PAC Period ID
WIP_ENTITY_ID	PAC WIP entity ID
ORGANIZATION_ID	Orgnization ID
OWNING_DEPT_ID	Owning Department ID

Bills of Material - CST_PAC_EAM_ASSET_PER_BALANCES	PAC eAM Asset balances details
Column Name	Descritpion
LEGAL_ENTITY_ID	Legal Entity ID
MAINT_COST_CATEGORY	Maintenance Cost Category
ACTUAL_MAT_COST	Actual Material Cost
ACTUAL_LAB_COST	Actual Labour Cost
ACTUAL_EQP_COST	Actual Equipment Cost
SYSTEM_ESTIMATED_MAT_COST	Estimated Material Cost
SYSTEM_ESTIMATED_LAB_COST	Estimated Labour Cost
SYSTEM_ESTIMATED_EQP_COST	Estimated Equipment Cost
PERIOD_START_DATE	Period Start Date
LAST_UPDATE_DATE	Standard who Column
LAST_UPDATED_BY	Standard who Column
COST_GROUP_ID	PAC Cost Group ID
CREATION_DATE	Standard who Column
CREATED_BY	Standard who Column
REQUEST_ID	Concurrent who Column
PROGRAM_APPLICATION_ID	Concurrent who Column
PROGRAM_ID	Concurrent who Column
MAINTENANCE_OBJECT_ID	MAINTENANCE OBJECT ID
MAINTENANCE_OBJECT_TYPE	Maintenance Object Type
COST_TYPE_ID	PAC Cost Type ID
PERIOD_SET_NAME	Period Set Name
PERIOD_NAME	PAC Period Name
PAC_PERIOD_ID	PAC Period ID
ORGANIZATION_ID	Orgnization ID
INVENTORY_ITEM_ID	Inventory Item ID
SERIAL_NUMBER	serial number

Bills of Material - CST_PAC_EAM_WO_EST_STATUSES	eAM workOrder Estimation Status for PAC Cost Type
Column Name	Descritpion
LEGAL_ENTITY_ID	Legal Entity ID
COST_GROUP_ID	PAC Cost Group ID
WIP_ENTITY_ID	WIP Entity ID
ESTIMATION_STATUS	Work Order Estimation Status
ORGANIZATION_ID	Organization ID
LAST_UPDATE_DATE	Standard WHO column
COST_TYPE_ID	Cost Type ID
LAST_UPDATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
CREATED_BY	Standard WHO column
LAST_ESTIMATION_REQ_ID	Standard WHO column
LAST_ESTIMATION_DATE	Standard WHO column

Bills of Material - CST_EAM_BALANCE_BY_ACCOUNTS	Estimated Cost Information by WIP Accounting Class Accounts
Column Name	Descritpion
PERIOD_SET_NAME	Period Set Name
PERIOD_START_DATE	Period start date
ACCOUNT_ID	Wip Accounting Class Account Id
ACCT_VALUE	Amount charged to the account
TXN_TYPE	Material, Labor or Equipment
WIP_ACCT_CLASS_CODE	WIP Accounting Class Code
MFG_COST_ELEMENT_ID	Manufacturing Cost Element Id
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PERIOD_NAME	Period Name
LAST_UPDATE_DATE	Standard Who column
ACCT_PERIOD_ID	Account Period Id
WIP_ENTITY_ID	Wip Entity Id
ORGANIZATION_ID	Organization id
OPERATIONS_DEPT_ID	Operations Department Id
OPERATIONS_SEQ_NUM	Operations Department Id
MAINT_COST_CATEGORY	Maintenance cost category
OWNING_DEPT_ID	Owning department id

Bills of Material - CST_COGS_EVENTS	This is the accounting events table for COGS Recognition events.
Column Name	Descritpion
EVENT_ID	Unique identifier for a COGS event row in this table.
EVENT_QUANTITY	Quantity affected by the COGS event
COSTED	Set to 'N' until the event is processed and accounting is created, at which point it is set ot NULL.
PARENT_EVENT_ID	All quantity adjustments (such as RMAs and COGS Rec. Qty. Adj. events) are constructed as child events of a single parent. These child events do store a prior_event_id as they are not directly in the chain of COGS events. To find the quan
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	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
COGS_OM_LINE_ID	Reference to the line ID of the original sales order issue to which this COGS event applies. In Order Management's table: oe_order_lines.line_id.
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
EVENT_DATE	Truncated date of the COGS event. For COGS recognition event types, it corresponds to the Oracle Receivables GL date of the revenue recognition event.
MMT_TRANSACTION_ID	All of the types of events in this table except for RMA placeholders have a corresponding transaction in mtl_material_transactions.
COGS_PERCENTAGE	The percentage of the total outstanding cost of an order line shipment that is recognized as Cost of Goods Sold.
PRIOR_COGS_PERCENTAGE	The amount of COGS recognized by the previous COGS event in the sequence. It stores the same value as the cogs_percentage in the event pointed to by prior_event_id.
PRIOR_EVENT_ID	For a given COGS_OM_LINE_ID, all events impacting COGS all into a sequence that is built using this column. The original sales order itself will not have a prior_event_id as it is the starting point.
EVENT_TYPE	Specifies the type of COGS event: (1) Sales Order Issue (2) RMA Receipt (3) COGS Recognition Event (4) COGS Rec. Percent Adjustment (5) COGS Rec. Qty. Adj. (6) RMA placeholder
EVENT_OM_LINE_ID	Holds oe_order_lines_all.line_id of the OM event which was the source of this COGS event. It will only be populated for sales order issues and RMA receipts.

Bills of Material - CST_REVENUE_COGS_CONTROL	Simple table used to keep track of the last successful run of the Generate COGS Events concurrent request.
Column Name	Descritpion
CONTROL_ID	Set to 1 for the single row
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
LAST_PROCESS_UPTO_DATE	Date of the last successful run of phase 2 of the concurrent request.
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	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column

Bills of Material - CST_REVENUE_COGS_MATCH_LINES	For matching COGS to Revenue, stores the relationship between COGS lines (shippable lines) and Revenue Lines (invoicable lines).
Column Name	Descritpion
COGS_OM_LINE_ID	Reference to the line ID of the original sales order issue to which this COGS event applies. In Order Management's table: oe_order_lines.line_id.
LEDGER_ID	Ledger identifier
SALES_ORDER_ISSUE_DATE	Original sales order issue shipment date
UNIT_MATERIAL_COST	Elemental material cost per unit
UNIT_MOH_COST	Elemental material overhead cost per unit
UNIT_RESOURCE_COST	Elemental resource cost per unit
UNIT_OP_COST	Elemental outside processing cost per unit
UNIT_OVERHEAD_COST	Elemental overhead cost per unit
UNIT_COST	Total unit cost
ORIGINAL_SHIPPED_QTY	Quantity shipped for the sales order issue. If the sales issue is composed of multiple MMT transactions, this will contain the total quantity across those transactions.
PAC_COST_TYPE_ID	Each COGS OM LINE ID will have one row where this column is NULL (the perpetual row), and the remaining will have this populated with the Periodic Average Costing Cost Type 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	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
REVENUE_OM_LINE_ID	Stores the OM Line ID that contains the relevant revenue recognition percentage that this COGS Line ID must match with.
DEFERRED_COGS_ACCT_ID	Stores the CCID of the Deferred COGS account which applies to this order line.
COGS_ACCT_ID	Stores the CCID of the COGS account which applies to this order line.
ORGANIZATION_ID	Unique identifier for the inventory organization of the sales order issue.
INVENTORY_ITEM_ID	Unique identifier of the inventory item.
OPERATING_UNIT_ID	Operating unit
COST_GROUP_ID	Cost group in which the original sales order issue was costed

Bills of Material - CST_REVENUE_RECOGNITION_LINES	Stores the latest Revenue Recognition Percentage for a given OM Line ID per accounting period.
Column Name	Descritpion
REVENUE_OM_LINE_ID	Order Line from oe_order_lines_all for which a revenue recognition percentage is relevant (determined by whether the line is invoicable or whether it's the top model of a configuration).
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	Standard Who Column
PROGRAM_APPLICATION_ID	Standard Who Column
PROGRAM_ID	Standard Who Column
PROGRAM_UPDATE_DATE	Standard Who Column
ACCT_PERIOD_NUM	Unique representation of an accounting period for a given set of books and application ID. Corresponds to GL_PERIOD_STATUSES.EFFECTIVE_PERIOD_NUM.
POTENTIALLY_UNMATCHED_FLAG	Indicator that is set to 'Y' whenever an action is taken that may have resulted in a Revenue/COGS mismatch. Cleared to NULL after the concurrent request is run to match revenue and COGS.
REVENUE_RECOGNITION_PERCENT	The latest known revenue recognition percentage for this OM line and accounting period.
LAST_EVENT_DATE	The GL date corresponding to this revenue recognition percentage.
OPERATING_UNIT_ID	Operating Unit
LEDGER_ID	Ledger identifier
INVENTORY_ITEM_ID	Item unique identifier
CUSTOMER_TRX_LINE_ID	Invoice line number

Bills of Material - CST_LC_ACCOUNTS_GT
Column Name	Descritpion
LCM_TRANSACTION_ID
EXP_FLAG
RCV_TRANSACTION_ID
TRANSACTION_ID
COST_GROUP_ID
SUBINVENTORY_CODE
ACCOUNT
ACCOUNTING_LINE_TYPE_ID
ACCOUNTING_LINE_TYPE
DEBIT_CREDIT_FLAG

Bills of Material - CST_LC_MMT_GT
Column Name	Descritpion
LCM_TRANSACTION_ID
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
INVENTORY_ITEM_ID
ORGANIZATION_ID
TRANSACTION_ID
TRANSACTION_DATE
ACCT_PERIOD_ID
TRANSACTION_SOURCE_NAME
SOURCE_CODE
TRX_SOURCE_LINE_ID
MATERIAL_ACCOUNT
MATERIAL_OVERHEAD_ACCOUNT
RESOURCE_ACCOUNT
OUTSIDE_PROCESSING_ACCOUNT
OVERHEAD_ACCOUNT
TRANSACTION_TYPE_ID
EXPENSE_ACCOUNT_ID
COSTED_FLAG
PM_COST_COLLECTED
OWNING_ORGANIZATION_ID
OWNING_TP_TYPE
TRANSACTION_UOM
TRANSACTION_REFERENCE
VALUE_CHANGE
TRANSACTION_ACTION_ID
TRANSACTION_SOURCE_TYPE_ID
TRANSACTION_SOURCE_ID
COST_GROUP_ID
PRIMARY_QUANTITY
LAST_UPDATE_DATE

Bills of Material - CST_LC_RAE_EVENTS_GT
Column Name	Descritpion
LCM_TRANSACTION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
RCV_TRANSACTION_ID
EVENT_TYPE_ID
EVENT_SOURCE
EVENT_SOURCE_ID
SET_OF_BOOKS_ID
ORG_ID
TRANSFER_ORG_ID
ORGANIZATION_ID
ACCOUNTING_EVENT_ID
TRANSFER_ORGANIZATION_ID
DEBIT_ACCOUNT_ID
CREDIT_ACCOUNT_ID
DEBIT_ACCOUNTING_LINE_TYPE
CREDIT_ACCOUNTING_LINE_TYPE
TRANSACTION_DATE
TRANSACTION_QUANTITY
TRANSACTION_UNIT_OF_MEASURE
SOURCE_DOC_QUANTITY
SOURCE_DOC_UNIT_OF_MEASURE
LAST_UPDATE_DATE
PRIMARY_QUANTITY
PRIMARY_UNIT_OF_MEASURE
INVENTORY_ITEM_ID
PO_HEADER_ID
PO_RELEASE_ID
PO_LINE_ID
PO_LINE_LOCATION_ID
PO_DISTRIBUTION_ID
INTERCOMPANY_PRICING_OPTION
UNIT_PRICE
LAST_UPDATED_BY
TRANSACTION_AMOUNT
PRIOR_UNIT_PRICE
NR_TAX
REC_TAX
NR_TAX_AMOUNT
REC_TAX_AMOUNT
PRIOR_NR_TAX
PRIOR_REC_TAX
CURRENCY_CODE
CURRENCY_CONVERSION_TYPE
LAST_UPDATE_LOGIN
CURRENCY_CONVERSION_RATE
CURRENCY_CONVERSION_DATE
ACCOUNTED_FLAG
PROCUREMENT_ORG_FLAG
CROSS_OU_FLAG
TRX_FLOW_HEADER_ID
INVOICED_FLAG
PA_ADDITION_FLAG
USSGL_TRANSACTION_CODE
GL_GROUP_ID
CREATION_DATE
QUANTITY_RECEIVED
QUANTITY_INVOICED
AMOUNT_RECEIVED
AMOUNT_INVOICED
LCM_ACCOUNT_ID
UNIT_LANDED_COST
CREATED_BY
REQUEST_ID
PROGRAM_APPLICATION_ID

Bills of Material - CST_LC_ADJ_ACCTG_INFO_GT
Column Name	Descritpion
LCM_TRANSACTION_ID
PO_RELEASE_ID
PO_LINE_ID
PO_LINE_LOCATION_ID
SOURCE_DOC_UNIT_OF_MEASURE
PRIMARY_UNIT_OF_MEASURE
LCM_ACCOUNT
LCM_VAR_ACCOUNT
RECEIVING_ACCOUNT
PURCHASE_PRICE_VAR_ACCOUNT
ORG_EXPENSE_ACCOUNT
RCV_TRANSACTION_ID
ORGANIZATION_ID
LEGAL_ENTITY_ID
LEDGER_ID
OPERATING_UNIT
CHART_OF_ACCOUNTS_ID
FUNC_CURRENCY_CODE
FUNC_MINIMUM_ACCOUNTABLE_UNIT
FUNC_PRECISION
PERIOD_NAME
ACCT_PERIOD_ID
INVENTORY_ITEM_ID
INVENTORY_ASSET_FLAG
PRIOR_LANDED_COST
NEW_LANDED_COST
TRANSACTION_DATE
ACCOUNTING_DATE
PO_NUMBER
PO_HEADER_ID

Bills of Material - CST_LC_RCV_TXN_GT
Column Name	Descritpion
LCM_TRANSACTION_ID
PARENT_TRANSACTION_TYPE
SUBINVENTORY_CODE
RCV_TRANSACTION_ID
GROUP_ID
PARENT_TRANSACTION_ID
ACCOUNTING_EVENT_ID
PO_DISTRIBUTION_ID
SOURCE_DOC_QUANTITY
PRIMARY_QUANTITY
TRANSACTION_TYPE

Bills of Material - CST_LC_ADJ_INTERFACE_ERRORS	Validation errors encountered during landed cost adjustment processing
Column Name	Descritpion
TRANSACTION_ID	Landed cost adjustment unique transaction identifier
REQUEST_ID	Concurrent Who column
PROGRAM_APPLICATION_ID	Concurrent Who column
PROGRAM_ID	Concurrent Who column
PROGRAM_UPDATE_DATE	Concurrent Who column
GROUP_ID	Landed cost adjustment processor group id
ERROR_COLUMN	Column in the interface table that has invalid value
ERROR_MESSAGE	Description of the validation that failed for the column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Bills of Material - CST_LC_ADJ_INTERFACE	Interface table for landed cost adjustment transactions for LCM shipments
Column Name	Descritpion
TRANSACTION_ID	Unique landed cost transaction identifier
GROUP_ID	Landed cost adjustment processor group id
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_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
RCV_TRANSACTION_ID	Parent receipt transaction for LCM shipment
ORGANIZATION_ID	Destination inventory organization id
INVENTORY_ITEM_ID	Inventory Item identifier
TRANSACTION_DATE	Landed cost adjustment transaction date
PRIOR_LANDED_COST	Prior landed cost
NEW_LANDED_COST	New landed cost
PROCESS_STATUS	Process phase: 1-Pending, 2-Running
PROCESS_PHASE	Process status: 1-Pending, 2-Validated, 3-Errored

Bills of Material - CST_LC_ADJ_TRANSACTIONS	Table that stores historical landed cost adjustment transactions for LCM shipments
Column Name	Descritpion
TRANSACTION_ID	Landed cost adjustment unique transaction identifier
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_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
RCV_TRANSACTION_ID	Parent receipt transaction for LCM shipment
ORGANIZATION_ID	Destination inventory organization id
INVENTORY_ITEM_ID	Inventory Item identifier
TRANSACTION_DATE	Landed cost adjustment transaction date
PRIOR_LANDED_COST	Prior landed cost
NEW_LANDED_COST	New landed cost
GROUP_ID	Landed cost adjustment processor group id
CREATION_DATE	Standard Who column

Bills of Material - CST_PAC_INTERORG_TXNS_TMP	used in the interorg transfer iteration procedure
Column Name	Descritpion
COST_GROUP_ID	Cost Group Id
TRANSFER_COST_GROUP_ID	Transfer Cost Group Id
PAC_PERIOD_ID	Periodic Average Costing Period
TXN_TYPE	Transaction Type. One of Cost Owned (1), Cost Derived (2)
TRANSACTION_ACTION_ID	Transaction Action Id
TRANSACTION_SOURCE_TYPE_ID	Transaction Source Type Id
INVENTORY_ITEM_ID	Inventory Item Id
PRIMARY_QUANTITY	Primary Quantity
PERIODIC_PRIMARY_QUANTITY	Periodic Primary Quantity
TRANSACTION_ID	Transaction Id
ORGANIZATION_ID	Organization Id
TRANSFER_ORGANIZATION_ID	Transfer Organization Id
SUBINVENTORY_CODE	Subinventory Code
TRANSFER_PRICE	Transfer Price
SHIPMENT_NUMBER	Shipment Number
TRANSFER_TRANSACTION_ID	Transfer Transaction Id
WAYBILL_AIRBILL	Airbill / waybill number
TRANSFER_COST	Transfer Cost
TRANSPORTATION_COST	Transportation Cost
TRANSFER_PERCENTAGE	Transfer Percentage

Bills of Material - CST_DIAG_TXN_ERRORS	Holds temp data while executing Diagnostic scripts
Column Name	Descritpion
ERROR_MESSAGE	Brief description of Error
RESOLUTION	Actions required to resolve error
TRANSACTION_ID	Transaction identifier

Bills of Material - CST_DIAG_ERRORED_TXNS	Temp table for Costing diagnostics
Column Name	Descritpion
BOTTLE_NECK_TXN_ID	Transaction id holding the costing of other transactions
TRANSACTION_DATE	Transaction date
TRANSACTION_ORGANIZATION_ID	Organization id in which transaction exists
TRANSFER_ORGANIZATION_ID	Transfer opposing organization id
TRANSFER_TRANSACTION_ID	Transaction id of the opposing transfer transaction
TRANSACTION_ACTION_ID	Transaction action identifier
TRANSACTION_SOURCE_TYPE_ID	Transaction source type identifier
TRANSACTION_COST	Transaction source type identifier
ORGANIZATION_ID	Organization identifier
SHIPMENT_COSTED	Indicates if the shipment transaction has been processed by the cost worker
MOVE_TRANSACTION_ID	Move transaction cross reference
COMPLETION_TRANSACTION_ID	Completion transaction cross reference
COSTED_FLAG	Costed flag to mark if the transactions are costed or not
WAITING_ORGANIZATION_ID	Organization id containing transactions to be costed
LOGICAL_TXN_CREATED	Flag to mark logical transactions are created or not