ACD_REVENUE_INT

Product Proposal Revenue interface table for the Bulk Import.

Details

  • Schema: FUSION

  • Object owner: ACD

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

ACD_REVENUE_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.
PROPOSAL_NAME VARCHAR2 400 Name of the proposal to which the revenue record associates.
REVENUE_CATEGORY VARCHAR2 30 Custom lookup values for the revenue categories.
REVENUE_TYPE VARCHAR2 30 Custom lookup values for the revenue type.
REVENUE_STATUS VARCHAR2 30 Custom lookup values for the revenue status.
REVENUE_AMOUNT NUMBER Total revenue amount during some particular time-period.
REVENUE_DATE DATE Date column for the each revenue record inserted.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
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.
SOURCE_LANG_FLAG VARCHAR2 1 Indicates the code of the language in which the contents of the translatable columns were originally created.
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.
SEQ_NO NUMBER 18 Yes For every record of data that will be inserted into the interface table SEQ_NO will be populated.
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_REVENUE_INT_U1 Unique Default SEQ_NO, INTERFACE_ROW_ID