CSD Tables (105)

CSD - Depot Repair — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
CSD_AGING_THRESHOLDS_B 31 This is the setup table for holding the aging definitions.
CSD_AHL_W_CLAIM_XREF 31 Supplier Warranty Claim table
CSD_AHL_W_CONTRACT_XREF 29 Supplier Warranty table
CSD_BOM_EXPL_TEMP 119
CSD_BULK_RECEIVE_ITEMS_B 69 Transaction table for Bulk Receive module.
CSD_BULLETINS_B 32 Base table for service bulletins
CSD_BULLETINS_TL 10 Translation table for service bulletins
CSD_BULLETIN_SCS 9 Bulletin Service Codes table
CSD_CC_TRXN_XREF 8
CSD_DC_DOMAINS 28 Stores the domain definitions for Diagnostic codes.
CSD_DEFECT_CODE_DOMAINS 28 Stores the Defect Code
CSD_DIAGNOSTIC_CODES_B 26 Stores Diagnostic Codes definition.
CSD_DIAGNOSTIC_CODES_TL 10 Stores translated attributes for Diagnostic Codes
CSD_ECO_THRESHOLDS 31 Eco-Impact Business Intelligence Thresholds table
CSD_FACT_DETAILS 11 Table that maintains the detail of when the table was refreshed last.
CSD_FLOW_STATUSES_B 26 To store the Repair Status definition, including mapping to State.
CSD_FLOW_STATUSES_TL 9 Translation table for CSD_FLOW_STATUSES_B.
CSD_FLWSTS_TRANS_B 15 To store the allowable status transition(s) for a given repair type.
CSD_FLWSTS_TRANS_TL 9 Translation table for CSD_ FLWSTS_TRANS_B.
CSD_FLWSTS_TRAN_MILES 9 To store milestones associated to a given flow transition.
CSD_FLWSTS_TRAN_RESPS 9 To store the responsibilities that have access to a given status transition.
CSD_GENERIC_ERRMSGS 14 Stores messages to be shown by genric messages UI.
CSD_GROUP_JOB_PARAM_TEMP 23 Resolving table for creating WIP jobs for mass repair orders.
CSD_MASS_RO_SN 27 Stores multiple serial numbers for multiple repair orders functionality.
CSD_MASS_RO_SN_ERRORS 11 Obsoleted table.
CSD_MRO_SERIAL_NUMBERS 29 Stores serial numbers for the items in a repair order group.
CSD_MTL_CONSUMED_F 13 Table that stores aggregated count of materials consumed.
CSD_MTL_DISPOSITION_REASONS 25 Material Transaction Disposition Reasons
CSD_PARAMETERS 11
CSD_PARAMETERS_TL 10
CSD_PARAMETER_VALUES 9
CSD_PRODUCT_TRANSACTIONS 65 This enitty is the child table for CSD_REPAIRS and holds all the product (Inbound / Outbound) transactions for a Repair Order.
CSD_QUALITY_THRESHOLDS_B 30 Setup table to hold the quality threshold setups.
CSD_RECALLSTS_TRANS_B 9 Holds the valid status transitions
CSD_RECALL_HEADERS_B 43 The table stores all the recall header records
CSD_RECALL_HEADERS_TL 19 Translatable table for the recall entity.
CSD_RECALL_HISTORY 13 Stores the recall history. Modifications to each field is represented by one single row.
CSD_RECALL_ITEM_ATTRIBS 35 Used to capture the user entered item related information for the recall
CSD_RECALL_ITEM_DETAILS 32 Details of the items impacted by the recall
CSD_RECALL_LINES 39 Holds all the recall lines under a recall.
CSD_RECALL_METRICS 32 Holds the rolled up metrics for a particular recall.
CSD_RECALL_PARAMETERS 39 Recall parameters setup table
CSD_RECALL_STATUSES_B 26 The setup table for holding all the different recall flow statuses.
CSD_REGION_GEOGRAPHIES 25 Region Geographies table
CSD_REPAIRS 131 This table holds all the repair orders.
CSD_REPAIRS_INTERFACE 118 An interface table to create repair orders in bulk
CSD_REPAIR_ACTUALS 29 Stores Repair Actuals header information.
CSD_REPAIR_ACTUAL_LINES 60 Stores Repair Actuals Lines information.
CSD_REPAIR_ESTIMATE 35 Header for estimate lines of a repair order.
CSD_REPAIR_ESTIMATE_LINES 35 Stores estimate lines for a repair order. Stores reference to CS_ESTIMATE_DETAILS(Charge Lines) and few other attributes specific to Depot.
CSD_REPAIR_HISTORY 62 This table stores all the events (e.g. Broken Product Received, Job Created, Product Shipped) associated with a repair order.
CSD_REPAIR_JOB_XREF 39 This table holds all the jobs submitted for a repair order. This is the table as a result of many-many relationship between CSD_REPAIRS and
CSD_REPAIR_MILESTONES 10 Table that stores milestone occurances in a repair lifecycles.
CSD_REPAIR_ORDERS_F 16 Table that stores aggregated count of closed repair orders.
CSD_REPAIR_ORDER_GROUPS 42 Stores Repair Order groups. Each group translates into one or more repair order lines.
CSD_REPAIR_TYPES_B 51 This table stores all the repair types.
CSD_REPAIR_TYPES_SAR 10 This table saves search attriutes
CSD_REPAIR_TYPES_TL 12 This is the translation table for the repair type table CSD_REPAIR_TYPES_B.
CSD_RES_CONSUMED_F 13 Table that stores aggregated count of resources transacted.
CSD_RETURNS_BI_DISP_SUM_MV 13
CSD_RETURNS_BI_MTL_TXNS_F 27 Material Transactions fact table
CSD_RETURNS_BI_MTL_TXNS_MV 13
CSD_RETURNS_BI_POM_MV 13
CSD_RETURNS_BI_RCV_TXNS_F 29 Receiving Transactions fact table
CSD_RETURNS_BI_RCV_TXNS_MV 16
CSD_RETURNS_BI_SHP_TXNS_F 25
CSD_RETURN_REASON_MAPPINGS 9
CSD_RETURN_RULES_B 11
CSD_RETURN_RULES_TL 10
CSD_RETURN_STREAM_REASONS 29 Return Stream Reasons
CSD_RETURN_TYPES_B 10
CSD_RETURN_TYPES_TL 11
CSD_RET_RULE_CONDITIONS_B 24
CSD_RET_RULE_CONDITIONS_TL 9
CSD_RO_BULLETINS 13 Service Order Bulletins
CSD_RO_DEFECT_CODES 25 Table that stores applicable defect codes for the repair order.
CSD_RO_DIAGNOSTIC_CODES 26 Stores mapping between Repair Orders and Diagnostic codes.
CSD_RO_SAVEDSEARCHES 26 This table saves search attributes
CSD_RO_SERVICE_CODES 32 Stores mapping between Repair Orders and Service codes.
CSD_RO_SOLUTIONS 10
CSD_RT_TRANS_B 13 To store the allowable transition(s) for a given repair type.
CSD_RT_TRANS_TL 9 Translation table for CSD_ FLWSTS_TRANS_B.
CSD_RT_TRAN_RESPS 9 To store the responsibilities that have access to a given status transition.
CSD_RULES_B 28 Base table for Defaulting Rules
CSD_RULES_TL 10 Translation table for Defaulting Rules
CSD_RULE_CONDITIONS_B 28 Base table for rule conditions
CSD_RULE_CONDITIONS_TL 9 Translation table for rule conditions
CSD_SC_DOMAINS 28 This table stores service code domains.
CSD_SC_FREQ_SUM_MV 6
CSD_SC_RECOMMENDATIONS_B 11 Table for storing service code recommndations
CSD_SC_RECOMMENDATIONS_TL 9 This is the translation table for the repair type table CSD_SC_RECOMMENDATIONS_B
CSD_SC_REC_DC_REQMTS 10 This table stores the mappings between service recommendations and their diagnostic code requirements
CSD_SC_WORK_ENTITIES 28 This table stores service code work entities.
CSD_SERVICE_CODES_B 26 This table stores all service codes.
CSD_SERVICE_CODES_TL 10 This is the translation table for the service code table CSD_SERVICE_CODES_B.
CSD_SO_ORCHESTRATION 34 Stores statuses of documents outside of Depot Repair.
CSD_TASKS 10 Transaction table for Task-QA integration.
CSD_TASK_QUALITY_RESULTS 10 Transaction table for Task-QA integration.
CSD_TEMP_ERRORS 3 This is a temporary table for the data fix script
CSD_TIME_CLOCK_ENTRIES 14 Time Clock Entries
CSD_UPG_ERRORS 7 This table stores data migration errors.
CSD_UPG_SLABS 7 This table stores slab ranges for tables for use during data migration
CSD_WIP_MTL_USED_MV 9
CSD_WIP_RES_USED_MV 9
CSD_WIP_TRANSACTION_DETAILS 48 Transaction table for the High Volume Repair module.