CJM_DOC_BATCH_IMP_MAP_COLS
This table stores field names extracted from files imported for the Channel Batch Transaction batches. The columns in this table correspond to the attribute names of the import transaction view object, which is based on the interface table CJM_DOCUMENT_LINES_INT.
Details
-
Schema: FUSION
-
Object owner: CJM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CJM_DOC_BATCH_IMP_MAP_PK |
DOC_BATCH_IMP_MAP_COL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DOC_BATCH_IMP_MAP_COL_ID | NUMBER | 18 | Yes | Unique identifier of mapping columns for the document batch. | |
| DOCUMENT_BATCH_ID | NUMBER | 18 | Indicates the identifier of the document batch. | ||
| BATCH_TRANSACTION_TYPE_CODE | VARCHAR2 | 500 | Indicates the batch transaction type code. | ||
| BU_NAME | VARCHAR2 | 500 | Stores the field name for the BU_NAME in the imported CSV file. | ||
| VENDOR_ID | VARCHAR2 | 500 | Stores the field name for the VENDOR_ID in the imported CSV file. | ||
| VENDOR_NAME | VARCHAR2 | 500 | Stores the field name for the VENDOR_NAME in the imported CSV file. | ||
| VENDOR_NUMBER | VARCHAR2 | 500 | Stores the field name for the VENDOR_NUMBER in the imported CSV file. | ||
| VENDOR_SITE_ID | VARCHAR2 | 500 | Stores the field name for the VENDOR_SITE_ID in the imported CSV file. | ||
| VENDOR_SITE_CODE | VARCHAR2 | 500 | Stores the field name for the VENDOR_SITE_CODE in the imported CSV file. | ||
| HEADER_COMMENTS | VARCHAR2 | 500 | Stores the field name for the HEADER_COMMENTS in the imported CSV file. | ||
| ITEM_ID | VARCHAR2 | 500 | Stores the field name for the ITEM_ID in the imported CSV file. | ||
| ITEM_NUMBER | VARCHAR2 | 500 | Stores the field name for the ITEM_NUMBER in the imported CSV file. | ||
| ITEM_DESCRIPTION | VARCHAR2 | 500 | Stores the field name for the ITEM_DESCRIPTION in the imported CSV file. | ||
| INVENTORY_ORGANIZATION_ID | VARCHAR2 | 500 | Stores the field name for the INVENTORY_ORGANIZATION_ID in the imported CSV file. | ||
| INVENTORY_ORG_NAME | VARCHAR2 | 500 | Stores the field name for the INVENTORY_ORG_NAME in the imported CSV file. | ||
| INVENTORY_ORGANIZATION_CODE | VARCHAR2 | 500 | Stores the field name for the INVENTORY_ORGANIZATION_CODE in the imported CSV file. | ||
| RECEIVING_INVENTORY_ORG_ID | VARCHAR2 | 500 | Stores the field name for the RECEIVING_INVENTORY_ORG_ID in the imported CSV file. | ||
| RECEIVING_INVENTORY_ORG_CODE | VARCHAR2 | 500 | Stores the field name for the RECEIVING_INVENTORY_ORG_CODE in the imported CSV file. | ||
| PRC_BU_NAME | VARCHAR2 | 500 | Stores the field name for the PRC_BU_NAME in the imported CSV file. | ||
| PO_NUMBER | VARCHAR2 | 500 | Stores the field name for the PO_NUMBER in the imported CSV file. | ||
| PO_DATE | VARCHAR2 | 500 | Stores the field name for the PO_DATE in the imported CSV file. | ||
| PO_LINE_NUMBER | VARCHAR2 | 500 | Stores the field name for the PO_LINE_NUMBER in the imported CSV file. | ||
| RECEIVING_LOCATION_ID | VARCHAR2 | 500 | Stores the field name for the RECEIVING_LOCATION_ID in the imported CSV file. | ||
| RECEIVING_LOCATION_CODE | VARCHAR2 | 500 | Stores the field name for the RECEIVING_LOCATION_CODE in the imported CSV file. | ||
| RECEIVING_LOCATION_NAME | VARCHAR2 | 500 | Stores the field name for the RECEIVING_LOCATION_NAME in the imported CSV file. | ||
| LINE_COMMENTS | VARCHAR2 | 500 | Stores the field name for the LINE_COMMENTS in the imported CSV file. | ||
| ORIG_SYSTEM_SOURCE | VARCHAR2 | 500 | Stores the field name for the ORIG_SYSTEM_SOURCE in the imported CSV file. | ||
| ORIG_SYSTEM_REFERENCE | VARCHAR2 | 500 | Stores the field name for the ORIG_SYSTEM_REFERENCE in the imported CSV file. | ||
| ORIG_SYSTEM_LINE_REFERENCE | VARCHAR2 | 500 | Stores the field name for the ORIG_SYSTEM_LINE_REFERENCE in the imported CSV file. | ||
| CURRENCY_CODE | VARCHAR2 | 500 | Stores the field name for the CURRENCY_CODE in the imported CSV file. | ||
| PO_LINE_REQ_DELIVERY_DATE | VARCHAR2 | 500 | Stores the field name for the PO_LINE_REQ_DELIVERY_DATE in the imported CSV file. | ||
| PO_LINE_REQ_SHIP_DATE | VARCHAR2 | 500 | Stores the field name for the PO_LINE_REQ_SHIP_DATE in the imported CSV file. | ||
| RECEIVING_TRANSACTION_QTY | VARCHAR2 | 500 | Stores the field name for the RECEIVING_TRANSACTION_QTY in the imported CSV file. | ||
| RECEIVING_TRANSACTION_UOM | VARCHAR2 | 500 | Stores the field name for the RECEIVING_TRANSACTION_UOM in the imported CSV file. | ||
| RECEIVING_TRX_UNIT_PRICE | VARCHAR2 | 500 | Stores the field name for the RECEIVING_TRX_UNIT_PRICE in the imported CSV file. | ||
| SUPPLIER_INVOICE_LINE_QTY | VARCHAR2 | 500 | Stores the field name for the SUPPLIER_INVOICE_LINE_QTY in the imported CSV file. | ||
| SUPPLIER_INVOICE_LINE_UOM | VARCHAR2 | 500 | Stores the field name for the SUPPLIER_INVOICE_LINE_UOM in the imported CSV file. | ||
| SUPPLIER_INV_LINE_UNIT_PRICE | VARCHAR2 | 500 | Stores the field name for the SUPPLIER_INV_LINE_UNIT_PRICE in the imported CSV file. | ||
| PO_BILLTO_LOCATION_ID | VARCHAR2 | 500 | Stores the field name for the PO_BILLTO_LOCATION_ID in the imported CSV file. | ||
| PO_BILLTO_LOCATION_CODE | VARCHAR2 | 500 | Stores the field name for the PO_BILLTO_LOCATION_CODE in the imported CSV file. | ||
| PO_SHIPTO_LOCATION_ID | VARCHAR2 | 500 | Stores the field name for the PO_SHIPTO_LOCATION_ID in the imported CSV file. | ||
| PO_SHIPTO_LOCATION_CODE | VARCHAR2 | 500 | Stores the field name for the PO_SHIPTO_LOCATION_CODE in the imported CSV file. | ||
| RECEIPT_NUMBER | VARCHAR2 | 500 | Stores the field name for the RECEIPT_NUMBER in the imported CSV file. | ||
| RECEIPT_SHIPMENT_NUMBER | VARCHAR2 | 500 | Stores the field name for the RECEIPT_SHIPMENT_NUMBER in the imported CSV file. | ||
| RECEIPT_SHIPPED_DATE | VARCHAR2 | 500 | Stores the field name for the RECEIPT_SHIPPED_DATE in the imported CSV file. | ||
| RECEIPT_WAYBILL_NUMBER | VARCHAR2 | 500 | Stores the field name for the RECEIPT_WAYBILL_NUMBER in the imported CSV file. | ||
| RECEIPT_BILL_OF_LADING | VARCHAR2 | 500 | Stores the field name for the RECEIPT_BILL_OF_LADING in the imported CSV file. | ||
| RECEIVING_TRANSACTION_DATE | VARCHAR2 | 500 | Stores the field name for the RECEIVING_TRANSACTION_DATE in the imported CSV file. | ||
| RECEIVING_TRANSACTION_TYPE | VARCHAR2 | 500 | Stores the field name for the RECEIVING_TRANSACTION_TYPE in the imported CSV file. | ||
| RECEIVING_TRANSACTION_NUM | VARCHAR2 | 500 | Stores the field name for the RECEIVING_TRANSACTION_NUM in the imported CSV file. | ||
| ORIG_RECEIVING_TRX_NUM | VARCHAR2 | 500 | Stores the field name for the ORIG_RECEIVING_TRX_NUM in the imported CSV file. | ||
| RECEIVING_REASON_ID | VARCHAR2 | 500 | Stores the field name for the RECEIVING_REASON_ID in the imported CSV file. | ||
| RECEIVING_REASON_NAME | VARCHAR2 | 500 | Stores the field name for the RECEIVING_REASON_NAME in the imported CSV file. | ||
| SUPPLIER_INVOICE_NUMBER | VARCHAR2 | 500 | Stores the field name for the SUPPLIER_INVOICE_NUMBER in the imported CSV file. | ||
| SUPPLIER_INVOICE_DATE | VARCHAR2 | 500 | Stores the field name for the SUPPLIER_INVOICE_DATE in the imported CSV file. | ||
| SUPPLIER_INVOICE_TYPE_CODE | VARCHAR2 | 500 | Stores the field name for the SUPPLIER_INVOICE_TYPE_CODE in the imported CSV file. | ||
| SUPPLIER_INVOICE_LINE_NUM | VARCHAR2 | 500 | Stores the field name for the SUPPLIER_INVOICE_LINE_NUM in the imported CSV file. | ||
| TP_ITEM_ID | VARCHAR2 | 500 | Stores the field name for the TP_ITEM_ID in the imported CSV file. | ||
| TP_ITEM_NUM | VARCHAR2 | 500 | Stores the field name for the TP_ITEM_NUM in the imported CSV file. | ||
| ORIG_SUPPLIER_INVOICE_NUMBER | VARCHAR2 | 500 | Stores the field name for the ORIG_SUPPLIER_INVOICE_NUMBER in the imported CSV file. | ||
| SUPPLIER_INVOICE_LINE_REASON | VARCHAR2 | 500 | Stores the field name for the SUPPLIER_INVOICE_LINE_REASON in the imported CSV file. | ||
| ORIG_SUPPLIER_INV_LINE_NUM | VARCHAR2 | 500 | Stores the field name for the ORIG_SUPPLIER_INV_LINE_NUM in the imported CSV file. | ||
| BILL_TO_ACCOUNT_NUMBER | VARCHAR2 | 500 | Stores the field name for the BILL_TO_ACCOUNT_NUMBER in the imported CSV file. | ||
| BILL_TO_ACCOUNT_ID | VARCHAR2 | 500 | Stores the field name for the BILL_TO_ACCOUNT_ID in the imported CSV file. | ||
| BILL_TO_ACCOUNT_SITE | VARCHAR2 | 500 | Stores the field name for the BILL_TO_ACCOUNT_SITE in the imported CSV file. | ||
| BILL_TO_ACCOUNT_SITE_ID | VARCHAR2 | 500 | Stores the field name for the BILL_TO_ACCOUNT_SITE_ID in the imported CSV file. | ||
| BILL_TO_CUSTOMER_NAME | VARCHAR2 | 500 | Stores the field name for the BILL_TO_CUSTOMER_NAME in the imported CSV file. | ||
| BILL_TO_CUSTOMER_ID | VARCHAR2 | 500 | Stores the field name for the BILL_TO_CUSTOMER_ID in the imported CSV file. | ||
| BILL_TO_CUSTOMER_REGISTRY_ID | VARCHAR2 | 500 | Stores the field name for the BILL_TO_CUSTOMER_REGISTRY_ID in the imported CSV file. | ||
| BILL_TO_SITE_USE_ID | VARCHAR2 | 500 | Stores the field name for the BILL_TO_SITE_USE_ID in the imported CSV file. | ||
| ORIG_SALES_ORDER_NUMBER | VARCHAR2 | 500 | Stores the field name for the ORIG_SALES_ORDER_NUMBER in the imported CSV file. | ||
| ORIG_SALES_ORDER_LINE_NUMBER | VARCHAR2 | 500 | Stores the field name for the ORIG_SALES_ORDER_LINE_NUMBER in the imported CSV file. | ||
| REQUESTED_ARRIVAL_DATE | VARCHAR2 | 500 | Stores the field name for the REQUESTED_ARRIVAL_DATE in the imported CSV file. | ||
| REQUESTED_SHIP_DATE | VARCHAR2 | 500 | Stores the field name for the REQUESTED_SHIP_DATE in the imported CSV file. | ||
| SALES_INVOICE_NUMBER | VARCHAR2 | 500 | Stores the field name for the SALES_INVOICE_NUMBER in the imported CSV file. | ||
| SALES_INVOICE_TYPE_CODE | VARCHAR2 | 500 | Stores the field name for the SALES_INVOICE_TYPE_CODE in the imported CSV file. | ||
| SALES_INVOICE_DATE | VARCHAR2 | 500 | Stores the field name for the SALES_INVOICE_DATE in the imported CSV file. | ||
| SALES_INVOICE_LINE_NUMBER | VARCHAR2 | 500 | Stores the field name for the SALES_INVOICE_LINE_NUMBER in the imported CSV file. | ||
| SALES_INVOICE_LINE_TYPE_CODE | VARCHAR2 | 500 | Stores the field name for the SALES_INVOICE_LINE_TYPE_CODE in the imported CSV file. | ||
| SALES_ORDER_NUMBER | VARCHAR2 | 500 | Stores the field name for the SALES_ORDER_NUMBER in the imported CSV file. | ||
| SALES_ORDER_TYPE_CODE | VARCHAR2 | 500 | Stores the field name for the SALES_ORDER_TYPE_CODE in the imported CSV file. | ||
| SALES_ORDER_DATE | VARCHAR2 | 500 | Stores the field name for the SALES_ORDER_DATE in the imported CSV file. | ||
| SALES_ORDER_LINE_NUMBER | VARCHAR2 | 500 | Stores the field name for the SALES_ORDER_LINE_NUMBER in the imported CSV file. | ||
| SALES_ORDER_LINE_TYPE_CODE | VARCHAR2 | 500 | Stores the field name for the SALES_ORDER_LINE_TYPE_CODE in the imported CSV file. | ||
| SALESPERSON_ID | VARCHAR2 | 500 | Stores the field name for the SALESPERSON_ID in the imported CSV file. | ||
| SALESPERSON_NUMBER | VARCHAR2 | 500 | Stores the field name for the SALESPERSON_NUMBER in the imported CSV file. | ||
| SALESPERSON_NAME | VARCHAR2 | 500 | Stores the field name for the SALESPERSON_NAME in the imported CSV file. | ||
| SHIPPED_DATE | VARCHAR2 | 500 | Stores the field name for the SHIPPED_DATE in the imported CSV file. | ||
| SHIPPED_QUANTITY | VARCHAR2 | 500 | Stores the field name for the SHIPPED_QUANTITY in the imported CSV file. | ||
| SHIPPED_UOM | VARCHAR2 | 500 | Stores the field name for the SHIPPED_UOM in the imported CSV file. | ||
| CLAIMED_QUANTITY | VARCHAR2 | 500 | Stores the field name for the CLAIMED_QUANTITY in the imported CSV file. | ||
| SHIP_TO_CUSTOMER_NAME | VARCHAR2 | 500 | Stores the field name for the SHIP_TO_CUSTOMER_NAME in the imported CSV file. | ||
| SHIP_TO_CUSTOMER_ID | VARCHAR2 | 500 | Stores the field name for the SHIP_TO_CUSTOMER_ID in the imported CSV file. | ||
| SHIP_TO_CUSTOMER_REGISTRY_ID | VARCHAR2 | 500 | Stores the field name for the SHIP_TO_CUSTOMER_REGISTRY_ID in the imported CSV file. | ||
| SHIP_TO_CUSTOMER_SITE | VARCHAR2 | 500 | Stores the field name for the SHIP_TO_CUSTOMER_SITE in the imported CSV file. | ||
| SHIP_TO_CUSTOMER_SITE_ID | VARCHAR2 | 500 | Stores the field name for the SHIP_TO_CUSTOMER_SITE_ID in the imported CSV file. | ||
| SHIP_TO_SITE_USE_ID | VARCHAR2 | 500 | Stores the field name for the SHIP_TO_SITE_USE_ID in the imported CSV file. | ||
| SOLD_TO_CUSTOMER_NAME | VARCHAR2 | 500 | Stores the field name for the SOLD_TO_CUSTOMER_NAME in the imported CSV file. | ||
| SOLD_TO_CUSTOMER_ID | VARCHAR2 | 500 | Stores the field name for the SOLD_TO_CUSTOMER_ID in the imported CSV file. | ||
| SOLD_TO_CUSTOMER_REGISTRY_ID | VARCHAR2 | 500 | Stores the field name for the SOLD_TO_CUSTOMER_REGISTRY_ID in the imported CSV file. | ||
| SOLD_TO_CUSTOMER_SITE | VARCHAR2 | 500 | Stores the field name for the SOLD_TO_CUSTOMER_SITE in the imported CSV file. | ||
| SOLD_TO_CUSTOMER_SITE_ID | VARCHAR2 | 500 | Stores the field name for the SOLD_TO_CUSTOMER_SITE_ID in the imported CSV file. | ||
| SOLD_TO_SITE_USE_ID | VARCHAR2 | 500 | Stores the field name for the SOLD_TO_SITE_USE_ID in the imported CSV file. | ||
| UNIT_LIST_PRICE | VARCHAR2 | 500 | Stores the field name for the UNIT_LIST_PRICE in the imported CSV file. | ||
| UNIT_SELLING_PRICE | VARCHAR2 | 500 | Stores the field name for the UNIT_SELLING_PRICE in the imported CSV file. | ||
| CATEGORY_ID | VARCHAR2 | 500 | Stores the field name for the CATEGORY_ID in the imported CSV file. | ||
| SALES_BILL_OF_LADING_NUMBER | VARCHAR2 | 500 | Stores the field name for the SALES_BILL_OF_LADING_NUMBER in the imported CSV file. | ||
| SALES_SHIPMENT_NUMBER | VARCHAR2 | 500 | Stores the field name for the SALES_SHIPMENT_NUMBER in the imported CSV file. | ||
| SALES_WAYBILL_NUMBER | VARCHAR2 | 500 | Stores the field name for the SALES_WAYBILL_NUMBER in the imported CSV file. | ||
| WAREHOUSE_ID | VARCHAR2 | 500 | Stores the field name for the WAREHOUSE_ID in the imported CSV file. | ||
| WAREHOUSE_CODE | VARCHAR2 | 500 | Stores the field name for the WAREHOUSE_CODE in the imported CSV file. | ||
| DISTRIBUTOR_NAME | VARCHAR2 | 500 | Stores the field name for the DISTRIBUTOR_NAME in the imported CSV file. | ||
| DISTRI_BILL_TO_ACCT_NUMBER | VARCHAR2 | 500 | Stores the field name for the DISTRI_BILL_TO_ACCT_NUMBER in the imported CSV file. | ||
| DISTRIBUTOR_REGISTRY_ID | VARCHAR2 | 500 | Stores the field name for the DISTRIBUTOR_REGISTRY_ID in the imported CSV file. | ||
| DISTRIBUTOR_CLAIM_NUMBER | VARCHAR2 | 500 | Stores the field name for the DISTRIBUTOR_CLAIM_NUMBER in the imported CSV file. | ||
| AGREEMENT_NAME | VARCHAR2 | 500 | Stores the field name for the AGREEMENT_NAME in the imported CSV file. | ||
| AGREEMENT_NUMBER | VARCHAR2 | 500 | Stores the field name for the AGREEMENT_NUMBER in the imported CSV file. | ||
| UNIT_PURCHASE_PRICE | VARCHAR2 | 500 | Stores the field name for the UNIT_PURCHASE_PRICE in the imported CSV file. | ||
| UNIT_CLAIMED_AMOUNT | VARCHAR2 | 500 | Stores the field name for the UNIT_CLAIMED_AMOUNT in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CATEGORY | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CATEGORY in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR1 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR1 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR2 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR2 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR3 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR3 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR4 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR4 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR5 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR5 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR6 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR6 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR7 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR7 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR8 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR8 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR9 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR9 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR10 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR10 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR11 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR11 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR12 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR12 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR13 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR13 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR14 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR14 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR15 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR15 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR16 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR16 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR17 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR17 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR18 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR18 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR19 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR19 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_CHAR20 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_CHAR20 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_NUMBER1 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_NUMBER1 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_NUMBER2 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_NUMBER2 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_NUMBER3 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_NUMBER3 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_NUMBER4 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_NUMBER4 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_NUMBER5 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_NUMBER5 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_NUMBER6 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_NUMBER6 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_NUMBER7 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_NUMBER7 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_NUMBER8 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_NUMBER8 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_NUMBER9 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_NUMBER9 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_NUMBER10 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_NUMBER10 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_DATE1 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_DATE1 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_DATE2 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_DATE2 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_DATE3 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_DATE3 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_DATE4 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_DATE4 in the imported CSV file. | ||
| HEADER_ATTRIBUTE_DATE5 | VARCHAR2 | 500 | Stores the field name for the HEADER_ATTRIBUTE_DATE5 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CATEGORY | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CATEGORY in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR1 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR1 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR2 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR2 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR3 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR3 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR4 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR4 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR5 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR5 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR6 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR6 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR7 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR7 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR8 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR8 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR9 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR9 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR10 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR10 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR11 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR11 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR12 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR12 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR13 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR13 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR14 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR14 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR15 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR15 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR16 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR16 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR17 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR17 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR18 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR18 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR19 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR19 in the imported CSV file. | ||
| LINE_ATTRIBUTE_CHAR20 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_CHAR20 in the imported CSV file. | ||
| LINE_ATTRIBUTE_NUMBER1 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_NUMBER1 in the imported CSV file. | ||
| LINE_ATTRIBUTE_NUMBER2 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_NUMBER2 in the imported CSV file. | ||
| LINE_ATTRIBUTE_NUMBER3 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_NUMBER3 in the imported CSV file. | ||
| LINE_ATTRIBUTE_NUMBER4 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_NUMBER4 in the imported CSV file. | ||
| LINE_ATTRIBUTE_NUMBER5 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_NUMBER5 in the imported CSV file. | ||
| LINE_ATTRIBUTE_NUMBER6 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_NUMBER6 in the imported CSV file. | ||
| LINE_ATTRIBUTE_NUMBER7 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_NUMBER7 in the imported CSV file. | ||
| LINE_ATTRIBUTE_NUMBER8 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_NUMBER8 in the imported CSV file. | ||
| LINE_ATTRIBUTE_NUMBER9 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_NUMBER9 in the imported CSV file. | ||
| LINE_ATTRIBUTE_NUMBER10 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_NUMBER10 in the imported CSV file. | ||
| LINE_ATTRIBUTE_DATE1 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_DATE1 in the imported CSV file. | ||
| LINE_ATTRIBUTE_DATE2 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_DATE2 in the imported CSV file. | ||
| LINE_ATTRIBUTE_DATE3 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_DATE3 in the imported CSV file. | ||
| LINE_ATTRIBUTE_DATE4 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_DATE4 in the imported CSV file. | ||
| LINE_ATTRIBUTE_DATE5 | VARCHAR2 | 500 | Stores the field name for the LINE_ATTRIBUTE_DATE5 in the imported CSV file. | ||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CJM_DOC_BATCH_IMP_MAP_U1 | Unique | Default | DOC_BATCH_IMP_MAP_COL_ID |