BOM Tables (316)
BOM - Bills of Material — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
BOM_ALTERNATE_DESIGNATORS |
32 | Alternate designators |
BOM_ALTERNATE_DESIGNATORS_TL |
12 | Alternate Designators Translation table |
BOM_ATO_CONFIGS_TEMP |
11 | |
BOM_ATO_CONFIGURATIONS |
17 | Unique configuration definition |
BOM_BILLS_HEADER_TEMP |
30 | Bills of material Header Temporary Table |
BOM_BILL_OF_MATERIALS_ARCHIVE |
50 | Bills of material archive |
BOM_BILL_OF_MATERIALS_TEMP |
27 | |
BOM_BILL_OF_MTLS_INTERFACE |
76 | Bills of material interface table |
BOM_CALENDARS |
33 | Workday calendars |
BOM_CALENDAR_DATES |
17 | Workday calendar dates |
BOM_CALENDAR_EXCEPTIONS |
29 | Workday calendar exceptions |
BOM_CALENDAR_SHIFTS |
30 | Workday calendar shifts |
BOM_CAL_WEEK_START_DATES |
15 | Workday calendar weekly start dates |
BOM_CAL_YEAR_START_DATES |
12 | Workday calendar yearly start dates |
BOM_CMP_USR_ATTR_INTERFACE |
41 | Bom Component User Attributes Interface Table |
BOM_COMPARISON_TEMP |
21 | Temporary data for bill of material comparisons |
BOM_COMPONENTS_B |
102 | Bill of material components |
BOM_COMPONENTS_EXT_B |
103 | |
BOM_COMPONENTS_EXT_TL |
54 | |
BOM_COMPONENT_COLUMNS |
32 | BOM COMPONENT COLUMNS TABLE |
BOM_COMPONENT_OPERATIONS |
36 | Additional operations for a Bill of Material Component |
BOM_COMPONENT_OPS_INTERFACE |
57 | Additional operations for a Bill of Material Component |
BOM_COMPONENT_TYPES |
27 | Component Types Master Table |
BOM_COMP_ATTR_CTX_ASSOCS_B |
20 | |
BOM_COMP_OPTCLASS_TEMP |
54 | Bill of material components interface data |
BOM_COMP_OPTIONS_TEMP |
54 | Bill of material components interface data |
BOM_CONFIG_EXPLOSIONS |
114 | Temporary data for ATO configurator window |
BOM_COPY_ORGANIZATION_LIST |
16 | List of Organization to which the source structure is getting copied |
BOM_COPY_STRUCTURE_ACTIONS |
14 | Copy action information |
BOM_COPY_STRUCTURE_REQUEST |
55 | FND concurrent request information |
BOM_CTO_MLSUPPLY_MAIN_TEMP |
29 | |
BOM_CTO_MODEL_ORGS |
20 | BOM_CTO_MODEL_ORGS |
BOM_CTO_ORDER_DEMAND |
18 | BCOD |
BOM_CTO_ORDER_LINES |
33 | bom cto order lines |
BOM_CTO_ORDER_LINES_GT |
38 | |
BOM_CTO_ORDER_LINES_UPG |
35 | bom cto order lines |
BOM_CTO_OSS_COMPONENTS |
28 | OSS Component Definition |
BOM_CTO_OSS_ORGS_LIST |
30 | OSS Org List |
BOM_CTO_SRC_ORGS_B |
21 | BOM_CTO_SRC_ORGS_B |
BOM_CTO_SRC_ORGS_GT |
12 | |
BOM_DELETE_ENTITIES |
23 | Deleted entities in BOM and INV |
BOM_DELETE_ERRORS |
14 | Errors occurring when deleting entities |
BOM_DELETE_GROUPS |
20 | Delete groups of BOM and INV entities |
BOM_DELETE_SQL_STATEMENTS |
22 | SQL statements used to check and delete entities |
BOM_DELETE_SUB_ENTITIES |
24 | Component and operations to be deleted |
BOM_DEPARTMENTS |
36 | Departments |
BOM_DEPARTMENT_CLASSES |
28 | Department classes |
BOM_DEPARTMENT_RESOURCES |
40 | Resources associated with departments |
BOM_DEPENDENT_DESC_ELEMENTS |
11 | Descriptive elements assigned to model/option bills |
BOM_DEPEND_DESC_ELEM_ARCHIVE |
11 | Descriptive elements assigned to model/option bills |
BOM_DEPT_RES_INSTANCES |
25 | Department Resource Instances |
BOM_EAM_DEPT_APPROVERS |
10 | Department Approvers |
BOM_EXCEPTION_SETS |
30 | Exception sets |
BOM_EXCEPTION_SET_DATES |
28 | Used for workday exception templates |
BOM_EXCLUSION_RULE_ARCHIVE |
36 | Exclusion rule archive data |
BOM_EXCLUSION_RULE_DEF |
36 | Excluded components data |
BOM_EXPLOSIONS |
95 | Pre-exploded model bills for use by Order Entry |
BOM_EXPLOSIONS_ALL |
220 | |
BOM_EXPLOSION_TEMP |
196 | Temporary data for indented bills of material (batch processes) |
BOM_FORM_QUERY |
42 | Retrofitted |
BOM_IMPLOSION_TEMP |
28 | Temporary data for item usage (Item Where Used Report) |
BOM_INTERFACE_DELETE_GROUPS |
3 | Delete group names for Bill, Routing and Engineering change order Open Interface |
BOM_INVENTORY_COMPONENTS_TEMP |
55 | |
BOM_INVENTORY_COMPS_ARCHIVE |
103 | Bill of material components |
BOM_INVENTORY_COMPS_INTERFACE |
146 | Bill of material components interface data |
BOM_INV_COMPONENTS_TEMP |
54 | Bill of material components temporary table |
BOM_ITEM_ATTACH_CATEGORY_ASSOC |
7 | Structure Types Item Attachment Categories Association Table |
BOM_ITEM_BACKFLUSH_SUBINV |
31 | Not currently used - to be used in future releases |
BOM_LISTS |
6 | Temporary list of data about reporting entities |
BOM_LOW_LEVEL_CODES |
10 | Temporary data for low level item codes |
BOM_MIXED_MODEL_MAP_CELLS |
18 | Matrix cell values for mixed model maps |
BOM_MIXED_MODEL_MAP_HEADER |
26 | Header information for a mixed model map |
BOM_MIXED_MODEL_MAP_PROCESSES |
26 | Processes or line operations and summary information for mixed model maps |
BOM_MIXED_MODEL_MAP_RES |
10 | Resources information of all the resources at a line operation/process for mixed model maps |
BOM_ODI_WS_ENTITIES |
16 | |
BOM_ODI_WS_REVISIONS |
11 | |
BOM_OPERATIONAL_ROUTINGS |
46 | Routings |
BOM_OPERATION_NETWORKS |
32 | Routing operation networks |
BOM_OPERATION_RESOURCES |
44 | Resources on operations |
BOM_OPERATION_RESOURCES_EFC |
5 | Euro as a Functional Currency Archive |
BOM_OPERATION_SEQUENCES |
83 | Routing operations |
BOM_OPERATION_SEQUENCES_TEMP |
82 | |
BOM_OPERATION_SKILLS |
13 | Table for skills validation |
BOM_OP_NETWORKS_INTERFACE |
53 | Operation networks interface data |
BOM_OP_RESOURCES_ARCHIVE |
44 | Archive of deleted resources on operations |
BOM_OP_RESOURCES_INTERFACE |
66 | Operation resources interface data |
BOM_OP_ROUTINGS_ARCHIVE |
46 | Archive of deleted routings |
BOM_OP_ROUTINGS_INTERFACE |
59 | Routing interface data |
BOM_OP_SEQUENCES_ARCHIVE |
83 | Routing operations |
BOM_OP_SEQUENCES_INTERFACE |
98 | Routing operation interface data |
BOM_PARAMETERS |
56 | Bills of material parameters |
BOM_PERIOD_START_DATES |
16 | Workday calendar period start dates |
BOM_REFERENCE_DESGS_ARCHIVE |
32 | Component reference designators |
BOM_REFERENCE_DESIGNATORS |
32 | Component reference designators |
BOM_REF_DESGS_INTERFACE |
61 | Reference designator interface data |
BOM_RESOURCES |
57 | Resources, overheads, material cost codes, and material overheads |
BOM_RESOURCES_EFC |
3 | Euro as a Functional Currency Archive |
BOM_RESOURCE_CHANGES |
37 | Resource capacity modifications |
BOM_RESOURCE_DOWNCODES |
7 | BOM_RESOURCE_DOWNCODES stores resource downcodes information.You will be able to specify multiple downcodes for each resource. |
BOM_RESOURCE_EMPLOYEES |
32 | Bom employee resources |
BOM_RESOURCE_EQUIPMENTS |
29 | Bom equipment resources |
BOM_RESOURCE_FLEX_FENCES |
29 | Tolerance percentage by which the present capacity of a particular resource or a line can be increased |
BOM_RESOURCE_SETUPS |
24 | Resource Setups |
BOM_RESOURCE_SHIFTS |
29 | Resource shift information |
BOM_RES_INSTANCE_CHANGES |
40 | Resource Instances modifications |
BOM_RTGHEADER_TEMP |
58 | Used in XML Routing Header import process |
BOM_RTG_ITEM_REVISIONS_ARCHIVE |
34 | Routing revisions archive |
BOM_RTG_NETWORK_TEMP |
39 | Used in XML Routing Network import Process |
BOM_RTG_OPERATION_TEMP |
54 | Used in XML Routing Import Process |
BOM_RTG_OPER_RES_TEMP |
38 | |
BOM_RTG_RESOURCE_TEMP |
41 | Used in XML Routing Resource Import Process |
BOM_RTG_SUB_RESOURCE_TEMP |
42 | Used in XML Routing substitute resource import process |
BOM_RULES_B |
32 | Rule Header information |
BOM_SETUP_TRANSITIONS |
29 | Setup Transitions |
BOM_SETUP_TYPES |
25 | Setup Types |
BOM_SHIFT_DATES |
18 | Workday calendar shift dates |
BOM_SHIFT_EXCEPTIONS |
30 | Workday calendar shift exceptions |
BOM_SHIFT_TIMES |
29 | Workday calendar shift times |
BOM_SMALL_EXPL_TEMP |
119 | Temporary data for indented bills of material (on-line processes) |
BOM_SMALL_IMPL_TEMP |
70 | Temporary data for item usage (View Item Usage window) |
BOM_STANDARD_OPERATIONS |
57 | Standard operations |
BOM_STD_OP_BONUS_CODES |
8 | Standard Operation Bonus codes |
BOM_STD_OP_RESOURCES |
39 | Standard operation resources |
BOM_STD_OP_RESP_EXCLUSIONS |
8 | Standard Operation responsibility exclusions |
BOM_STD_OP_SCRAP_CODES |
9 | Standard Operation Scrap Codes |
BOM_STD_SUB_OP_RESOURCES |
38 | BOM_STD_SUB_OP_RESOURCES stores Substitute Resource information for a particular operation for routing. |
BOM_STRUCTURES_B |
50 | Bills of material |
BOM_STRUCTURES_EXT_B |
102 | |
BOM_STRUCTURES_EXT_TL |
54 | |
BOM_STRUCTURE_TYPES_B |
32 | Structure Type master table |
BOM_STRUCTURE_TYPES_TL |
11 | Translation table for Structure types |
BOM_SUBSTITUTE_COMPONENTS |
33 | Substitute components |
BOM_SUBSTITUTE_COMPS_ARCHIVE |
33 | Substitute components |
BOM_SUB_COMPS_INTERFACE |
66 | Substitute component interface data |
BOM_SUB_OPERATION_RESOURCES |
44 | Substitue Resources |
BOM_SUB_OPERATION_RESOURCE_EFC |
5 | Euro as a Functional Currency Archive |
BOM_SUB_OP_RESOURCES_INTERFACE |
66 | Substitute resources interface data for routing operations |
BOM_TA_VAL_EXCLUSION_DEF_B |
10 | |
BOM_TA_VAL_EXCLUSION_RULES_B |
18 | |
BOM_WORKDAY_PATTERNS |
31 | On/Off workday patterns for calendars and shifts |
CSTGILEV_TEMP |
14 | |
CST_ACCOUNTING_LIBRARIES |
15 | CST_ACCOUNTING_LIBRARIES stores information about the library that should be called during the periodic distribution process for GAAP Accou |
CST_ACCOUNTING_PACKAGES |
14 | CST_ACCOUNTING_PACKAGES stores information about PL/SQL packages that are called during the periodic distribution process. |
CST_ACCRUAL_ACCOUNTS |
11 | Stores the accrual account information for accrual reconciliation modules |
CST_ACCT_LIB_PACKAGES |
13 | CST_ACCT_LIB_PACKAGES stores associations between the library for GAAP accounting and any PL/SQL package that should be called for a transac |
CST_ACTIVITIES |
34 | Activity definition associated with activity costing |
CST_ACTIVITY_COSTS |
31 | Cost associated with the activity |
CST_ACTIVITY_COSTS_EFC |
6 | Euro as a Functional Currency Archive |
CST_AE_HEADERS |
28 | Header Information for Periodic Accounting Distributions |
CST_AE_HEADERS_EFC |
2 | Euro as a Functional Currency Archive |
CST_AE_LINES |
52 | Stores debits and credits for Periodic Distributions |
CST_AE_LINES_EFC |
8 | Euro as a Functional Currency Archive |
CST_AP_PO_RECONCILIATION |
28 | Table to Store the Deatils of Purchasing and Payables Transactions |
CST_AP_VARIANCE_BATCHES |
23 | Stores the parameters for each Invoice Variance Transfer Program run |
CST_AP_VARIANCE_HEADERS |
17 | Stores the variance information for a purchase order distribution for each batch run |
CST_AP_VARIANCE_HEADERS_EFC |
3 | Euro as a Functional Currency Archive |
CST_AP_VARIANCE_LINES |
23 | Stores the variance information detail for a purchase order distribution and each batch run |
CST_AP_VARIANCE_LINES_EFC |
5 | Euro as a Functional Currency Archive |
CST_BIS_MARGIN_BUILD |
20 | Stores margin analysis load run parameters |
CST_BIS_MARGIN_SUMMARY |
77 | Margin analysis summary table for reporting purposes |
CST_CAT_ELE_EXP_ASSOCS |
11 | Stores associations between categories, cost elements, and expenditure types |
CST_CG_LIST_TEMP |
1 | Temporary list of cost groups for use in cost reporting |
CST_CG_WIP_ACCT_CLASSES |
13 | Uniquely identifies WIP accounting class for a cost group in each organization |
CST_COGS_EVENTS |
21 | This is the accounting events table for COGS Recognition events. |
CST_COGS_PCT_ADJ_EVENTS_TEMP |
16 | Global Temporary table used for matching COGS to Revenue in the package CST_RevenueCogsMatch_PVT. This table specifically helps create bulk |
CST_COGS_QTY_ADJ_EVENTS_TEMP |
16 | Global Temporary table used for matching COGS to Revenue in the package CST_RevenueCogsMatch_PVT. This table specifically helps create bulk |
CST_COMP_SNAPSHOT |
17 | Stores the assembly units completed at each operation step |
CST_COMP_SNAP_INTERFACE |
17 | Stores the assembly units completed at each operation step to be interfaced through the transactions interface |
CST_COMP_SNAP_TEMP |
17 | Stores the assembly units completed at each operation step to be interfaced through the transactions temporary table |
CST_COST_ELEMENTS |
13 | Cost elements definition |
CST_COST_ELEM_EXP_TYPES |
13 | Expenditure types for cost elements. |
CST_COST_GROUPS |
33 | Stores cost group definitions |
CST_COST_GROUP_ACCOUNTS |
25 | Accounts for a cost group for an average costing organization |
CST_COST_GROUP_ASSIGNMENTS |
11 | Stores the organization assignment |
CST_COST_TYPES |
43 | Stores cost type definitions |
CST_COST_TYPE_HISTORY |
30 | Cost rollups information and cost type purge information |
CST_COST_UPDATES |
29 | Cost update history |
CST_COST_UPDATES_EFC |
6 | Euro as a Functional Currency Archive |
CST_DEPARTMENT_OVERHEADS |
32 | Department overhead cost definition |
CST_DEPARTMENT_OVERHEADS_EFC |
5 | Euro as a Functional Currency Archive |
CST_DEPT_OVERHEADS_INTERFACE |
44 | Open interface table for overhead rate information |
CST_DIAG_ERRORED_TXNS |
15 | Temp table for Costing diagnostics |
CST_DIAG_TXN_ERRORS |
3 | Holds temp data while executing Diagnostic scripts |
CST_DISTRIBUTION_MASTER |
8 | WIP resource transaction seeded data |
CST_EAM_ACTIVITY_ESTIMATES |
7 | Estimated costs for activities |
CST_EAM_ASSET_PER_BALANCES |
25 | Cost information by asset |
CST_EAM_BALANCE_BY_ACCOUNTS |
20 | Estimated Cost Information by WIP Accounting Class Accounts |
CST_EAM_COST_ELEMENTS |
13 | EAM cost elements |
CST_EAM_DIRECT_ITEMS_TEMP |
47 | |
CST_EAM_HIERARCHY_SNAPSHOT |
13 | This temporary table contains a snapshot of hierarchies for which a cost rollup is required |
CST_EAM_ROLLUP_COSTS |
18 | Temporary table to store rollup costs |
CST_EAM_ROLLUP_TEMP |
26 | Temporary table for assets rollup |
CST_EAM_WO_ESTIMATE_DETAILS |
38 | Details of estimated cost for work orders |
CST_ELEMENTAL_COSTS |
14 | Standard elemental cost history |
CST_ELEMENTAL_COSTS_EFC |
5 | Euro as a Functional Currency Archive |
CST_ENCUMBRANCE_LINES |
52 | Stores encumbrance account distributions for periodic costing |
CST_EXPLOSION_TEMP |
8 | Temporary, indented bill of material |
CST_GL_SUMMARY_LINKS_TEMP |
10 | |
CST_INQUIRY_TEMP |
23 | Temporary table for item cost inquiry |
CST_INQUIRY_TYPES |
30 | Types of item cost inquiry |
CST_INTERFACE_ERRORS |
4 | Stores invalid records due to error in the item cost definition |
CST_INV_COST_TEMP |
13 | A temporary table to store intermediate results for period close summarization and inventory valuation reports |
CST_INV_LAYERS |
23 | Stores layer information |
CST_INV_LAYER_COST_DETAILS |
14 | Stores inventory layer cost details |
CST_INV_QTY_TEMP |
17 | A temporary table to store intermediate results for period close summarization, standard cost update and inventory valuation reports |
CST_ITEM_COSTS |
56 | Item cost summary |
CST_ITEM_COSTS_EFC |
24 | Euro as a Functional Currency Archive |
CST_ITEM_COSTS_INTERFACE |
62 | Open interface table for item cost information |
CST_ITEM_COSTS_TEMP |
43 | A temporary table to snapshot new item costs during standard cost update |
CST_ITEM_COST_DETAILS |
53 | Item cost detail information |
CST_ITEM_COST_DETAILS_EFC |
9 | Euro as a Functional Currency Archive |
CST_ITEM_CST_DTLS_INTERFACE |
70 | Open interface table for item cost detail information |
CST_ITEM_LIST_TEMP |
3 | Temporary list of items for use in cost reporting |
CST_ITEM_OVERHEAD_DEFAULTS |
36 | Default value for the overhead cost |
CST_ITEM_OVERHEAD_DEFAULTS_EFC |
6 | Euro as a Functional Currency Archive |
CST_LAYER_COST_DETAILS |
13 | Detailed cost information by element and level |
CST_LAYER_COST_DETAILS_EFC |
5 | Euro as a Functional Currency Archive |
CST_LC_ACCOUNTS_GT |
10 | |
CST_LC_ADJ_ACCTG_INFO_GT |
30 | |
CST_LC_ADJ_INTERFACE |
19 | The CST_LCM_ADJ_INTERFACE table is an interface table that is populated every time the landed cost of an LCM shipment is recalculated. The i |
CST_LC_ADJ_INTERFACE_ERRORS |
13 | CST_LC_ADJ_INTERFACE_ERRORS is the child table of table CST_LC_ADJ_INTERFACE. It contains details of the failed validation of the data in CS |
CST_LC_ADJ_TRANSACTIONS |
17 | |
CST_LC_MMT_GT |
37 | |
CST_LC_RAE_EVENTS_GT |
65 | |
CST_LC_RCV_TXN_GT |
11 | |
CST_LE_COST_TYPES |
24 | Holds information about the legal entity/cost |
CST_LISTS |
2 | Item list for item exploder |
CST_LOW_LEVEL_CODES |
12 | Temporary table for cost rollup |
CST_MARGIN_BUILD |
20 | Stores margin analysis load run parameters |
CST_MARGIN_SUMMARY |
76 | Margin analysis summary table for reporting purposes |
CST_MASS_EDITS |
18 | Item cost mass edit historical information |
CST_MATERIAL_OVHD_RULES |
15 | Stores material overhead rules |
CST_MGD_IAL_INVALID_MMT |
12 | Transaction types being excluded from inventory analytical ledger and inventory trial balance reports |
CST_MGD_INFL_ADJUSTED_COSTS |
29 | Stores inflation adjustment values |
CST_MGD_INFL_ADJ_KARDEX_DATA |
18 | Stores data that supports the Inflation Adjustment Kardex Report |
CST_MGD_INFL_ADJ_PER_STATUSES |
12 | Stores inflation status for each period. |
CST_MGD_INFL_TSF_ORG_ENTRIES |
17 | Stores transfer organization information for inflation adjustment. |
CST_MGD_MSTR_BOOK_TEMP |
26 | |
CST_MISC_RECONCILIATION |
30 | Table to store miscellaneous AP transactions and any INV transactions that hit an accrual account |
CST_ORG_COST_GROUP_ACCOUNTS |
17 | Stores the accounts defined against an organization cost group |
CST_OSFM_UPGRADE_TEMP |
8 | |
CST_PAC_ACCRUAL_ACCOUNTS_TEMP |
3 | Temporary table for storing accrual accounts for Accrual Reconciliation for periodic costing |
CST_PAC_ACCRUAL_RECONCILE_TEMP |
52 | Temporary table for Accrual Reconciliation for periodic costing |
CST_PAC_ACCRUAL_WRITE_OFFS |
54 | Stores the write-off information for Accrual Reconciliation for periodic costing |
CST_PAC_ACCRUAL_WRITE_OFFS_EFC |
6 | Euro as a Functional Currency Archive |
CST_PAC_EAM_ASSET_PER_BALANCES |
26 | PAC eAM Asset balances details |
CST_PAC_EAM_BALANCE_BY_ACCTS |
23 | Estimated Cost Information by WAC Accounts for PAC |
CST_PAC_EAM_PERIOD_BALANCES |
27 | PAC eAM Asset balances details |
CST_PAC_EAM_WO_EST_STATUSES |
12 | eAM workOrder Estimation Status for PAC Cost Type |
CST_PAC_EXPLOSION_TEMP |
6 | Stores distinct parent-child combinations of items for a given period and organization cost group. |
CST_PAC_INTERORG_TXNS_TMP |
20 | used in the interorg transfer iteration procedure |
CST_PAC_INTORG_ITMS_TEMP |
14 | used in the interorg transfer iteration procedure |
CST_PAC_ITEM_COSTS |
58 | Stores the item cost and quantity in a period and organization cost group. |
CST_PAC_ITEM_COSTS_EFC |
28 | Euro as a Functional Currency Archive |
CST_PAC_ITEM_COST_DETAILS |
18 | Stores the details of the item cost in a period and organization cost group. |
CST_PAC_ITEM_COST_DETAILS_EFC |
7 | Euro as a Functional Currency Archive |
CST_PAC_ITMS_ABSL_CODES |
4 | CST_PAC_ITMS_ABSL_CODES is used in the Absorption Cost Rollup process of PACP |
CST_PAC_LOW_LEVEL_CODES |
13 | Stores low level codes for items for a given period and organization cost group. |
CST_PAC_PERIODS |
20 | Holds information about periodic costing open and closed periods for each legal entity. |
CST_PAC_PERIOD_BALANCES |
23 | PAC period balances for transaction categories |
CST_PAC_PROCESS_PHASES |
15 | Holds the status for each process phase in a particular period and organization cost group |
CST_PAC_QUANTITY_LAYERS |
16 | Stores the layer quantity of an item by period for periodic costing |
CST_PAC_REQ_OPER_COST_DETAILS |
22 | Stores periodic balance of all WIP entities within a cost group by period for BOM based algo Cost Types |
CST_PC_COST_DET_INTERFACE |
21 | Periodic Item Cost Details Interface Table |
CST_PC_ITEM_COST_INTERFACE |
54 | Periodic Item Cost Header Interface Table |
CST_PC_TXN_HISTORY |
21 | CST_PC_TXN_HISTORY stores historical information about transactions processed by the periodic cost processor. |
CST_PERIOD_CLOSE_SUMMARY |
25 | This table stores item level period end balances for summarized periods |
CST_PERIOD_VALUE_TEMP |
15 | Temporary table used by View WIP Value form |
CST_PER_END_ACCRUALS_TEMP |
15 | Period End Accruals transaction specific temporary table |
CST_PM_MATL_TXNS_TEMP |
35 | Temporary table for use by Cost Collection Manager Concurrent program |
CST_QUANTITY_LAYERS |
36 | Stores cost information for each layer |
CST_QUANTITY_LAYERS_EFC |
22 | Euro as a Functional Currency Archive |
CST_RCV_ACQ_COSTS |
26 | Stores acquisition cost per period, organization cost group for periodic costing |
CST_RCV_ACQ_COSTS_ADJ |
27 | This table stores the header information for the Periodic Acquisition Cost Adjustment process |
CST_RCV_ACQ_COSTS_EFC |
8 | Euro as a Functional Currency Archive |
CST_RCV_ACQ_COST_DETAILS |
24 | Stores detailed acquisition cost per period, organization cost group. |
CST_RCV_ACQ_COST_DETAILS_ADJ |
24 | This table hold the details for the Periodic Acquisition Cost Adjustment Process |
CST_RCV_ACQ_COST_DETAILS_EFC |
6 | Euro as a Functional Currency Archive |
CST_RECONCILIATION_BUILD |
13 | Stores the build information for the accrual reconciliation load run |
CST_RECONCILIATION_GTT |
23 | |
CST_RECONCILIATION_SUMMARY |
23 | Table to store summary information for related Purchasing and Payables tranactions in Accrual Reconciliation |
CST_REPORT_TYPES |
27 | Column selection option for item cost report |
CST_RESOURCE_COSTS |
29 | Resource and outside processing resource cost definition |
CST_RESOURCE_COSTS_EFC |
4 | Euro as a Functional Currency Archive |
CST_RESOURCE_COSTS_INTERFACE |
39 | Open interface table for resource cost information |
CST_RESOURCE_OVERHEADS |
29 | Resource that an overhead is applied to |
CST_RES_OVERHEADS_INTERFACE |
40 | Open interface table for resource overhead association information |
CST_REVENUE_COGS_CONTROL |
11 | Simple table used to keep track of the last successful run of the Generate COGS Events concurrent request. |
CST_REVENUE_COGS_MATCH_LINES |
27 | For matching COGS to Revenue, stores the relationship between COGS lines (shippable lines) and Revenue Lines (invoicable lines). |
CST_REVENUE_RECOGNITION_LINES |
18 | Stores the latest Revenue Recognition Percentage for a given OM Line ID per accounting period. |
CST_ROLLUP_DELETE_TEMP |
10 | Temporary table for rollup identifier for deleting |
CST_SC_BOM_EXPLOSION |
20 | Supply Chain Bill of Material Explosion Table |
CST_SC_BOM_STRUCTURES |
28 | Supply Chain Bill of Material Structures |
CST_SC_LISTS |
12 | Supply Chain List for Assemblies to rollup |
CST_SC_LOW_LEVEL_CODES |
17 | Supply Chain Low Level Codes |
CST_SC_ROLLUP_HISTORY |
36 | Supply Chain Rollup History |
CST_SC_SOURCING_RULES |
28 | Supply Chain Sourcing Rule Snapshot |
CST_STANDARD_COSTS |
21 | Standard cost history |
CST_STANDARD_COSTS_EFC |
8 | Euro as a Functional Currency Archive |
CST_STD_COST_ADJ_DEBUG |
31 | Table to store intermediate data when debugging standard cost update process |
CST_STD_COST_ADJ_TEMP |
21 | Temporary table for standard cost adjustment |
CST_STD_COST_ADJ_VALUES |
33 | Standard cost adjustment value computed by standard cost update |
CST_STD_COST_ADJ_VALUES_EFC |
10 | Euro as a Functional Currency Archive |
CST_SUB_LIST_TEMP |
1 | Temporary list of subinventories for use in cost reporting |
CST_VALUE_REPORT_TEMP |
3 | Temporary table used by inventory value report |
CST_WIP_LAYERS |
22 | CST_WIP_LAYERS stores information about each inventory layer in WIP |
CST_WIP_LAYER_COST_DETAILS |
14 | CST_WIP_LAYER_COST_DETAILS stores the elemental cost, by level, of inventory layers in WIP |
CST_WIP_OPERATION_TXN_COSTS |
40 | CST_WIP_OPERATION_TXN_COSTS stores snapshots of WIP operations tables |
CST_WIP_PAC_PERIOD_BAL_TMP |
12 | PAC specific temporary table for WIP Value Report |
CST_WIP_VALUE_HISTORY |
78 | CST_WIP_VALUE_HISTORY stores snapshots of WIP_PERIOD_BALANCES |
CST_WRITE_OFFS |
33 | Table Holds Write-Off Header Information |
CST_WRITE_OFF_DETAILS |
27 | Table Holds Details of Write-Off Transactions |
CST_XLA_INV_EVENT_MAP |
10 | Table to map material transactions to their corresponding event types. |
CST_XLA_RCV_EVENT_MAP |
5 | Table to map receiving transactions to their corresponding event types. |
CST_XLA_SEQ_GT |
10 | Temporary table is used in Costing SLA Upgrade to generate XLA entity_id, event_id, and header_id from XLA sequences for every XLA events. |
CST_XLA_WIP_EVENT_MAP |
5 | Table to map wip transactions to their corresponding event types. |