ACD_PRODUCT_PROPOSAL_INT

Product Proposal interface table for Bulk Import.

Details

  • Schema: FUSION

  • Object owner: ACD

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

ACD_PRODUCT_PROPOSAL_INT_PK

PRODUCT_PROPOSAL_ID

Columns

Name Datatype Length Precision Not-null Comments
PRODUCT_PROPOSAL_ID NUMBER 18 Yes Primary Key which will be system generated Application Unique Id.
THREAD_ID NUMBER 18 Thread id column for requirement staging table.
DESCRIPTION CLOB This represents the description of the product concept.
PUBLISHED_FROM_PORTFOLIO VARCHAR2 30 Shows that the proposal is published from portfolio or not.
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.
IS_CLONED VARCHAR2 1 Yes Specifies if theProduct Proposal is a cloned copy. Y - Cloned;N-Not Cloned. Default N
CONCEPT_MASTER_ID NUMBER 18 Yes MASTER_ID from CONCEPT_B table as Foreign Key
PROPOSAL_STATUS VARCHAR2 30 Yes Indicates the Proposal Status value for the Product Concept (Draft, Submitted, and Approved). The supported types are defined in the Lookup type with the name ACD_PROPOSAL_STATUS and the look up codes are DRAFT_STATUS, SUBMITTED_STATUS, and APPROVED_STATUS. Default Value is DRAFT_STATUS
VERSION NUMBER 8 Yes This is the version number for this proposal.
IS_LATEST VARCHAR2 1 Yes Flag which indicates whether the proposal is latest or not. 'Y' stands for latest version and 'N' stands for old version.
LAST_CONCEPT_VERSION VARCHAR2 10 Indicates last concept version with which proposal is associated.
SRC_PRODUCT_PROPOSAL_ID NUMBER 18 Product Proposal Id of the source Product Proposal for a cloned copy
PROPOSAL_TYPE VARCHAR2 30 Indicates the proposal type for the Product COncept (New Technology, New Concept, New Product, Sustaining Product, End of Life). The supported types are defined in the Lookup type with the name ACD_PROPOSAL_TYPE and the look up codes are NEW_TECHNOLOGY, NEW_CONCEPT,SUSTAINING_PRODUCT,END_OF_LIFE.
ALLOW_ACCESSTO_EVERYONE VARCHAR2 1 Yes This holds either "Y" to allow acess to everyone or "N" to restrict access to Team
LAST_PROJ_RES_REFRESH_TIME TIMESTAMP Stores last refresh time of resources updated from projects
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.
EXTN_ATTRIBUTE_TIMESTAMP001 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP002 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP003 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER001 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER002 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER003 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER004 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER005 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER006 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER007 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER008 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR001 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR002 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR003 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR004 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR005 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR006 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR007 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR008 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR009 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR010 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR011 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR012 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR013 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR014 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP004 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP005 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP006 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER009 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER010 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER011 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER012 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER013 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER014 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER015 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER016 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR015 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR016 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR017 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR018 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR019 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR020 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR021 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR022 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR023 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR024 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR025 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR026 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR027 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR028 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP007 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP008 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP009 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER017 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER018 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER019 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER020 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER021 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER022 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER023 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER024 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR029 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR030 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR031 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR032 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR033 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR034 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR035 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR036 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR037 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR038 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR039 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR040 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR041 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR042 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP010 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP011 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP012 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER025 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER026 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER027 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER028 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER029 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER030 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER031 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER032 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR043 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR044 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR045 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR046 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR047 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR048 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR049 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR050 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR051 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR052 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR053 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR054 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR055 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR056 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP013 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP014 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP015 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER033 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER034 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER035 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER036 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER037 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER038 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER039 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER040 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR057 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR058 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR059 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR060 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR061 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR062 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR063 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR064 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR065 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR066 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR067 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR068 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR069 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR070 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP016 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP017 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP018 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER041 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER042 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER043 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER044 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER045 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER046 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER047 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER048 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR071 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR072 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR073 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR074 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR075 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR076 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR077 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR078 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR079 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR080 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR081 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR082 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR083 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR084 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP019 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_TIMESTAMP020 TIMESTAMP Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER049 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER050 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR085 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR086 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR087 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR088 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR089 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR090 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR091 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR092 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR093 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR094 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR095 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR096 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR097 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR098 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR099 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_CHAR100 VARCHAR2 1500 Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER201 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER202 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER203 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER204 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
EXTN_ATTRIBUTE_NUMBER205 NUMBER Runtime Extensibility: Column reserved for custom extension attributes.
SOURCE_LANG_FLAG VARCHAR2 1 Indicates the code of the language in which the contents of the translatable columns were originally created.
NAME VARCHAR2 400 Name of the Product Proposal object.
TYPE VARCHAR2 400 Indicates the product proposal type for the product concept.
LANG_CODE VARCHAR2 20 Indicates the code of the language into which the contents of the translatable columns are translated.
SRC_LANG_CODE VARCHAR2 4 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 INTERFACE_ROW_ID is the unique identifier for the record with in a batch.

Indexes

Index Uniqueness Tablespace Columns
ACD_PRODUCT_PROPOSAL_INT_U1 Unique Default PRODUCT_PROPOSAL_ID