MKT_IMP_ATTACHED_DOCUMENTS
This is an interface table containing attachment associations with base objects.
Details
-
Schema: FUSION
-
Object owner: MKT
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
MKT_IMP_ATTACHED_DOCUMENT_PK |
BATCH_ID, INTERFACE_ROW_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BATCH_ID | NUMBER | 18 | Yes | Batch ID corresponds to a job batch. | |
| INTERFACE_ROW_ID | NUMBER | 18 | Yes | Interface Row ID is the unique identifier for the record with in a batch. Combination of BATCH_ID and INTERFACE_ROW_ID will be unique in the interface table. | |
| PRODUCT_BATCH_ID | NUMBER | 18 | Yes | Product Batch ID corresponds to a job batch in the product specific interface table. | |
| PRODUCT_INTERFACE_ROW_ID | NUMBER | 18 | Product Interface Row ID is the unique identifier for the record with in a batch. Combination of PRODUCT_BATCH_ID and PRODUCT_INTERFACE_ROW_ID will be unique in the product specific interface table. | ||
| FILE_RECORD_NUM | NUMBER | 18 | Yes | Record number indicator in the file. | |
| INTERFACE_TABLE_NAME | VARCHAR2 | 30 | Name of the product specific interface table for which the attached document record is associated with. | ||
| STATUS | VARCHAR2 | 30 | Yes | Status of the attached document record. | |
| PK1_VALUE | VARCHAR2 | 150 | The FND attached document PK1 value | ||
| PK2_VALUE | VARCHAR2 | 150 | The FND attached document PK2 value | ||
| PK3_VALUE | VARCHAR2 | 150 | The FND attached document PK3 value | ||
| PK4_VALUE | VARCHAR2 | 150 | The FND attached document PK4 value | ||
| PK5_VALUE | VARCHAR2 | 150 | The FND attached document PK5 value | ||
| ATTACHMENT_FILE_NAME | VARCHAR2 | 200 | The source attachment file name. | ||
| ATTACHMENT_FILE_DESC | VARCHAR2 | 200 | The source attachment file description. | ||
| ATTACHMENT_FILE_TITLE | VARCHAR2 | 200 | The source attachment file title. | ||
| ATTACHMENT_CATEGORY_NAME | VARCHAR2 | 30 | The source attachment category name. | ||
| ATTACHMENT_ENTITY_NAME | VARCHAR2 | 40 | The attachment entity name | ||
| DOCUMENT_ID | NUMBER | 18 | Document ID for reference | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| 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. | |
| FILE_NAME_SYSTASK_ID | NUMBER | 18 | File Name Systask Id to store the systask id of the object that is associated while doing the import. It iwll help us to generate the logs like success, error and exception logs |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MKT_IMP_ATTACHED_DOCUMENT_PK | Unique | Default | BATCH_ID, INTERFACE_ROW_ID |