ACD_COSTS_INT

Product Proposal Costs interface table for Bulk Import.

Details

  • Schema: FUSION

  • Object owner: ACD

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

ACD_COSTS_INT_PK

SEQ_NO, INTERFACE_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
HEADER_FLAG NUMBER 1 Header flag columns holds the value of 0 or 1 based on the value.
COST_CATEGORY VARCHAR2 30 Indicates the category of cost for Product Concept (Development, Production + Custom) The supported types are defined in the Lookup type with the name ACD_COST_CATEGORY and the look up codes are DEVELOPMENT, PRODUCTION, custom values
COST_TYPE VARCHAR2 30 Indicates the type of cost for Product Concept (Fixed,Labor,Variable,Material) The supported types are defined in the Lookup type with the name ACD_COST_TYPES and the look up codes are FIXED,LABOR,VARIABLE,MATERIAL values
COST_STATUS VARCHAR2 30 Indicates the status of cost for Product Concept (Budgeted,Estimated,Actual) The supported types are defined in the Lookup type with the name ACD_COST_STATUS and the look up codes are BUDGETED,ESTIMATED,ACTUAL values
COST_AMOUNT NUMBER Total amount spent during the time-period between start and end dates
START_DATE DATE Start date of a time-period e.g. 04/01/201
END_DATE DATE End date of a time-period e.g. 08/01/2011
COST_TREND VARCHAR2 30 Indicates the trend of cost for Product Concept (Point, Uniformly Distributed, Front Loaded, Back Loaded) The supported types are defined in the Lookup type with the name ACD_TREND and the look up codes are POINT,UNIFORMLY_DISTRIBUTED,FRONT_LOADED,BACK_LOADED values
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
SEQ_NO NUMBER 18 Yes For every batch of data that will be inserted into the interface table a new SEQ_ID will be populated.
PROPOSAL_NAME VARCHAR2 400 Product proposal name for which the cost rows added or updated or inserted.
IMPORT_STATUS_CODE VARCHAR2 30 IMPORT_STATUS_CODE tells status of a row in the interface table.
INTERNAL_ACTION_CODE VARCHAR2 30 This column is created for internal use and will be populated and used by bulk import logic.
ACTION_CODE VARCHAR2 30 ACTION_CODE in interface table allows source system to specify a particular operation (insert, update, etc) for a row.
LOAD_REQUEST_ID NUMBER 10 When Data file uploaded and click on submit that time the load request Id generated.
INTERFACE_ROW_ID NUMBER 18 Yes INTERFACE_ROW_ID is the unique identifier for the record with in a batch.
EXTN_ATTR001 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR002 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR003 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR004 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR005 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR006 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR007 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR008 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR009 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR010 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR011 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR012 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR013 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR014 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR015 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR016 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR017 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR018 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR019 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR020 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR021 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR022 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR023 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR024 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR025 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR026 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR027 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR028 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR029 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR030 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR031 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR032 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR033 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR034 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR035 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR036 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR037 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR038 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR039 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR040 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR041 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR042 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR043 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR044 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR045 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR046 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR047 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR048 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR049 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR050 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR051 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR052 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR053 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR054 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR055 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR056 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR057 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR058 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR059 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR060 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR061 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR062 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR063 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR064 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR065 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR066 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR067 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR068 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR069 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR070 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR071 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR072 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR073 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR074 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR075 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR076 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR077 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR078 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR079 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR080 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR081 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR082 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR083 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR084 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR085 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR086 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR087 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR088 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR089 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR090 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR091 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR092 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR093 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR094 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR095 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR096 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR097 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR098 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR099 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR100 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR101 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR102 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR103 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR104 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR105 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR106 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR107 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR108 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR109 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR110 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR111 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR112 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR113 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR114 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR115 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR116 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR117 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR118 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR119 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR120 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR121 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR122 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR123 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR124 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR125 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR126 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR127 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR128 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR129 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR130 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR131 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR132 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR133 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR134 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR135 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR136 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR137 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR138 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR139 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR140 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR141 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR142 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR143 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR144 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR145 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR146 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR147 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR148 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR149 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR150 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR151 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR152 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR153 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR154 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR155 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR156 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR157 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR158 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR159 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR160 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR161 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR162 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR163 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR164 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR165 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR166 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR167 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR168 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR169 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR170 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR171 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR172 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR173 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR174 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTR175 VARCHAR2 4000 Runtime Extensibility: Column reserved for custom extension attributes.

Indexes

Index Uniqueness Tablespace Columns
ACD_COSTS_INT_U1 Unique Default SEQ_NO, INTERFACE_ROW_ID