RCV_HEADERS_INTERFACE
RCV_HEADERS_INTERFACE is an interface table that stores receiving header information. Scope: public Lifecycle: active Display Name: RCV Headers Interface Product: PO Category: BUSINESS_ENTITY PO_GOODS_RECEIPT Category: BUSINESS_ENTITY PO_EXPENSE_RECEIPT Category: BUSINESS_ENTITY PO_SERVICES_RECEIPTS Category: BUSINESS_ENTITY PO_GOODS_RETURN Category: BUSINESS_ENTITY PO_RECEIPT_CORRECTION
Details
-
Schema: FUSION
-
Object owner: RCV
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
RCV_HEADERS_INTERFACE_PK |
HEADER_INTERFACE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| HEADER_INTERFACE_ID | NUMBER | 18 | Yes | Unique identifier for the receiving header interface row. | ||
| GROUP_ID | NUMBER | 18 | Interface group for set processing. All the interface records for a given value of group_id will be processed together. | |||
| EDI_CONTROL_NUM | VARCHAR2 | 10 | EDI transaction control number if data is sent via EDI. | |||
| PROCESSING_STATUS_CODE | VARCHAR2 | 25 | Processing status of the interface header row. Default value is PENDING. Other values are RUNNING, SUCCESS, ERROR. | |||
| RECEIPT_SOURCE_CODE | VARCHAR2 | 25 | Source type of the shipment or the receipt. Valid Values are VENDOR, INVENTORY, TRANSFER ORDER, CUSTOMER and OUTSOURCER. | |||
| ASN_TYPE | VARCHAR2 | 25 | ASN type of the shipment. Valid values are ASN, ASBN and STD. The valid values are ASN and ASBN for ASN/ASBN creation and STD for a receipt. | |||
| TRANSACTION_TYPE | VARCHAR2 | 25 | The transaction purpose code for the receiving header interface. Values are NEW, CREATE, UPDATE, or CANCEL | |||
| AUTO_TRANSACT_CODE | VARCHAR2 | 25 | Automatic transaction creation code of the shipment. | |||
| TEST_FLAG | VARCHAR2 | 1 | Flag indicating transaction is in test mode. | |||
| 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. | |||
| 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. | ||
| NOTICE_CREATION_DATE | DATE | EDI transaction creation date/time at source if importing data via EDI. | ||||
| SHIPMENT_NUM | VARCHAR2 | 30 | Shipment number assigned by the shipment's source. Corresponds to the ASN Number, In-transit Shipment number and Transfer order shipment number. | |||
| RECEIPT_NUM | VARCHAR2 | 30 | This column stores the receipt number to be used when creating a receipt in fusion receiving. | |||
| RECEIPT_HEADER_ID | NUMBER | 18 | This column stores the shipment unique identifier or the receipt unique identifier. It maps to rcv_shipment_headers.shipment_header_id and is used when creating receipt for ASN/in-transit shipments or adding to an existing receipt. | |||
| VENDOR_NAME | VARCHAR2 | 240 | This column stores the supplier name and is used to derive VENDOR_ID. | |||
| VENDOR_NUM | VARCHAR2 | 30 | This column stores the supplier number and is used to derive VENDOR_ID. | |||
| VENDOR_ID | NUMBER | 18 | Supplier unique identifier. References POZ_SUPPLIERS.VENDOR_ID. | |||
| VENDOR_SITE_CODE | VARCHAR2 | 240 | This column stores the supplier site code and is used in conjunction with BU_ID to derive VENDOR_SITE_ID. | |||
| VENDOR_SITE_ID | NUMBER | 18 | Supplier site unique identifier. References POZ_SUPPLIER_SITES_ALL_M.VENDOR_SITE_ID. | |||
| FROM_ORGANIZATION_CODE | VARCHAR2 | 18 | This column stores the from organization code for in-transit shipments and is used to derive FROM_ORGANIZATION_ID. | |||
| FROM_ORGANIZATION_ID | NUMBER | 18 | From organization unique identifier for in-transit shipments. | |||
| SHIP_TO_ORGANIZATION_CODE | VARCHAR2 | 18 | Inventory organization code where the receipt and shipment are created. Used to derive SHIP_TO_ORGANIZATION_ID. | |||
| SHIP_TO_ORGANIZATION_ID | NUMBER | 18 | Inventory organization unique identifier where the receipt and shipment are created. | |||
| LOCATION_CODE | VARCHAR2 | 60 | This column stores the receiving location code. Used to derive LOCATION_ID. | |||
| LOCATION_ID | NUMBER | 18 | This column stores the Receiving location unique identifier. | |||
| BILL_OF_LADING | VARCHAR2 | 25 | This column stores the Bill of lading number. | |||
| PACKING_SLIP | VARCHAR2 | 25 | This column stores the Packing slip number. | |||
| SHIPPED_DATE | DATE | This column stores the date when the shipment was created. | ||||
| FREIGHT_CARRIER_ID | NUMBER | 18 | This column stores the Freight Carrier unique identifier. | |||
| FREIGHT_CARRIER_NAME | VARCHAR2 | 360 | This column stores the Freight Carrier name. | |||
| EXPECTED_RECEIPT_DATE | DATE | This column stores the Expected arrival date of the shipment. | ||||
| RECEIVER_ID | NUMBER | 18 | This column is not being used currently. | |||
| NUM_OF_CONTAINERS | NUMBER | 18 | This column stores the number of containers in the shipment. | |||
| WAYBILL_AIRBILL_NUM | VARCHAR2 | 20 | This column stores the waybill or air bill number. | |||
| COMMENTS | VARCHAR2 | 240 | This column stores the note created by the receiver. | |||
| GROSS_WEIGHT | NUMBER | Shipment gross weight specified while creating ASN. | ||||
| GROSS_WEIGHT_UOM_CODE | VARCHAR2 | 3 | Shipment gross weight unit of measure code specified while creating ASN. | |||
| GROSS_WEIGHT_UNIT_OF_MEASURE | VARCHAR2 | 25 | Shipment gross weight unit of measure specified while creating ASN. | |||
| NET_WEIGHT | NUMBER | Shipment net weight specified while creating ASN. | ||||
| NET_WEIGHT_UOM_CODE | VARCHAR2 | 3 | Shipment net weight unit of measure code specified while creating ASN. | |||
| NET_WEIGHT_UNIT_OF_MEASURE | VARCHAR2 | 25 | Shipment net weight unit of measure specified while creating ASN. | |||
| TAR_WEIGHT | NUMBER | Shipment tar (container) weight specified while creating ASN. | ||||
| TAR_WEIGHT_UOM_CODE | VARCHAR2 | 3 | Shipment tar (container) weight unit of measure code specified while creating ASN. | |||
| TAR_WEIGHT_UNIT_OF_MEASURE | VARCHAR2 | 25 | Shipment tar (container) weight unit of measure specified while creating ASN. | |||
| PACKAGING_CODE | VARCHAR2 | 5 | This column stores the packaging code of the shipment. | |||
| CARRIER_METHOD | VARCHAR2 | 2 | Carrier transportation method code. | |||
| CARRIER_EQUIPMENT | VARCHAR2 | 10 | Carrier equipment description code. | |||
| SPECIAL_HANDLING_CODE | VARCHAR2 | 3 | This column stores the special handling code for the shipment. | |||
| HAZARD_CODE | VARCHAR2 | 1 | Hazardous material qualifier code of the shipment. | |||
| HAZARD_CLASS | VARCHAR2 | 4 | Hazardous material class of the shipment. | |||
| HAZARD_DESCRIPTION | VARCHAR2 | 80 | This column stores the hazardous material description. | |||
| FREIGHT_TERMS | VARCHAR2 | 25 | This column stores the Freight Payment Method (e.g. user defined, Prepaid, Collect). | |||
| FREIGHT_BILL_NUMBER | VARCHAR2 | 35 | This column stores the Freight bill (PRO invoice) number. | |||
| INVOICE_NUM | VARCHAR2 | 30 | Invoice number associated with the shipment/billing notice (ASN with billing information). | |||
| INVOICE_DATE | DATE | Invoice date associated with the shipment/billing notice (ASN with billing information). | ||||
| TOTAL_INVOICE_AMOUNT | NUMBER | Invoice amount associated with the shipment/billing notice (ASN with billing information). | ||||
| TAX_NAME | VARCHAR2 | 15 | Tax name associated with the shipment/billing notice (ASN with billing information). | |||
| TAX_AMOUNT | NUMBER | Tax amount associated with the shipment/billing notice name indicated at the header level. | ||||
| FREIGHT_AMOUNT | NUMBER | This column stores the Freight bill amount associated with the shipment/billing notice. | ||||
| CURRENCY_CODE | VARCHAR2 | 15 | This column stores the invoice currency and maps to POZ_SUPPLIER_SITES_ALL_M.INVOICE_CURRENCY_CODE. Used for ASN with billing information (ASBN) only. | |||
| CONVERSION_RATE_TYPE | VARCHAR2 | 30 | This column stores the currency conversion rate type of the purchase order. Used for purchase order receipts only. | |||
| CONVERSION_RATE | NUMBER | This column stores the currency conversion rate for the receipt. Used for purchase order shipments only. | ||||
| CONVERSION_RATE_DATE | DATE | This column stores the currency conversion date for the receipt. Used for purchase order shipments only. | ||||
| PAYMENT_TERMS_NAME | VARCHAR2 | 50 | EDI transaction 857 payment terms name. Used to derive PAYMENT_TERMS_ID. | |||
| PAYMENT_TERMS_ID | NUMBER | 18 | EDI transaction 857 payment terms unique identifier. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Receipt Header (RCV_SHIPMENT_HEADERS) | |||
| EMPLOYEE_NAME | VARCHAR2 | 240 | This column stores the name of the person creating the receiving transaction and is used to derive EMPLOYEE_ID. References PER_PERSON_NAMES_F.FULL_NAME. | |||
| EMPLOYEE_ID | NUMBER | 18 | This column stores the Unique identifier for the person creating the receiving transaction. References PER_PERSON_NAMES_F.PERSON_ID. | |||
| INVOICE_STATUS_CODE | VARCHAR2 | 25 | For ASN with billing information (ASBN) only, indicates when line items were rejected. | |||
| VALIDATION_FLAG | VARCHAR2 | 1 | Flag to indicate if row needs to be validated before being processed. When creating rows from receiving open interface, the value of this column must be 'Y'. | |||
| PROCESSING_REQUEST_ID | NUMBER | 18 | Unique identifier for the ESS request that has processed the current row. | |||
| TRANSACTION_DATE | DATE | This column stores the transaction date for the header interface record. | ||||
| CUSTOMER_ACCOUNT_NUMBER | NUMBER | 18 | Customer account number. Used to derive customer_id. | |||
| CUSTOMER_ID | NUMBER | 18 | Customer unique identifier. Applicable for RMA transactions. | |||
| CUSTOMER_SITE_ID | NUMBER | 18 | Customer site unique identifier. Applicable for RMA transactions. | |||
| CUSTOMER_PARTY_NAME | VARCHAR2 | 360 | Customer Party Name. Used to derive customer_id. Maps to HZ_PARTIES.PARTY_NAME. | |||
| REMIT_TO_SITE_ID | NUMBER | 18 | Remit to Site unique identifier. | |||
| BU_ID | NUMBER | 18 | Business Unit Unique Identifier. For Purchase Order receipts, this column refers to Procurement BU identifier of the supplier site. For RMA receipts, this column refers to the RMA business unit identifier. | |||
| BUSINESS_UNIT | VARCHAR2 | 240 | Business Unit Name used to derive BU_ID. For Purchase Order receipts, this column refers to Procurement Business Unit of the supplier site. For RMA receipts, this column refers to the RMA business unit. | |||
| SHIP_FROM_LOCATION_ID | NUMBER | 18 | Ship From Location Unique Identifier of the supplier site. | |||
| PERFORMANCE_PERIOD_FROM | DATE | Work Confirmation's Performance period from. | ||||
| PERFORMANCE_PERIOD_TO | DATE | Work Confirmation's Performance period to. | ||||
| REQUEST_DATE | DATE | Request date of the work confirmation. | ||||
| SHIP_FROM_LOCATION_CODE | VARCHAR2 | 30 | Ship from location code of the supplier site. Used to derive SHIP_FROM_LOCATION_ID. | |||
| 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. | ||
| RA_OUTSOURCER_PARTY_ID | NUMBER | 18 | This column stores the Logistics service provider customer party unique identifier. | |||
| RA_OUTSOURCER_PARTY_NAME | VARCHAR2 | 240 | This column stores the Logistics service provider customer party name. Used to derive RA_OUTSOURCER_PARTY_ID. Applicable to flexible supply source documents. | |||
| RECEIPT_ADVICE_NUMBER | VARCHAR2 | 80 | This column stores the unique receipt advice number corresponding to the receipt advice created. Applicable to RMA and flexible supply source documents. | |||
| RA_DOCUMENT_CODE | VARCHAR2 | 25 | This column stores the source document code for the document created as part of the receipt advice. Applicable to RMA and flexible supply source documents. | |||
| RA_DOCUMENT_NUMBER | VARCHAR2 | 80 | Source document number for the receipt advice. Applicable to RMA and flexible supply source documents. | |||
| RA_DOC_REVISION_NUMBER | VARCHAR2 | 80 | Revision number of the source document for the receipt advice. Applicable to flexible supply source documents. | |||
| RA_DOC_REVISION_DATE | DATE | Source document revision date for Receipt advice. Applicable to RMA and flexible supply source documents. | ||||
| RA_DOC_CREATION_DATE | DATE | Source document creation date for Receipt advice. Applicable to RMA and flexible supply source documents. | ||||
| RA_DOC_LAST_UPDATE_DATE | DATE | Source document last update date for Receipt advice. Applicable to RMA and flexible supply source documents. | ||||
| RA_OUTSOURCER_CONTACT_ID | NUMBER | 18 | This column stores the logistic outsourcer contact party unique identifier. Applicable to flexible supply source documents. | |||
| RA_OUTSOURCER_CONTACT_NAME | VARCHAR2 | 240 | This column stores the logistic outsourcer contact party name. Used to derive RA_OUTSOURCER_CONTACT_ID. Applicable to flexible supply source documents. | |||
| RA_VENDOR_SITE_NAME | VARCHAR2 | 240 | Supplier site party name for Receipt advice. Used to derive VENDOR_ID for flexible supply source documents. References HZ_PARTY_SITES.PARTY_SITE_NAME. | |||
| RA_NOTE_TO_RECEIVER | VARCHAR2 | 480 | Note to receiver specified in the receipt advice. Applicable to RMA and flexible supply source documents. | |||
| RA_DOO_SOURCE_SYSTEM_ID | NUMBER | 18 | Unique identifier of the Distributed Order Orchestration instance that has created the receipt advice. | |||
| RA_DOO_SOURCE_SYSTEM_NAME | VARCHAR2 | 80 | Unique name of the Source System instance that has created the receipt advice. Used to derive RA_DOO_SOURCE_SYSTEM_ID. | |||
| LOAD_REQUEST_ID | NUMBER | 18 | Used by Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | |||
| HEADER_INTERFACE_NUM | VARCHAR2 | 30 | Alternate key for HEADER_INTERFACE_ID for a load_request_id. Used by SAAS processing. | |||
| RA_ORIG_SYSTEM_REF | VARCHAR2 | 30 | Reference code for the source system that created the receipt advice. | |||
| CUSTOMER_PARTY_NUMBER | VARCHAR2 | 30 | Unique identifier for customer party number. Used to derive CUSTOMER_ID in conjunction with CUSTOMER_PARTY_NUMBER. Maps to HZ_PARTIES.PARTY_NUMBER. | |||
| GL_DATE | DATE | This column stores the general ledger date. | ||||
| EXTERNAL_SYS_TXN_REFERENCE | VARCHAR2 | 300 | This column is used to store the link to the transaction references passed by external WMS or 3PL systems. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| RCV_HEADERS_INTERFACE_N1 | Non Unique | Default | VENDOR_ID |
| RCV_HEADERS_INTERFACE_N2 | Non Unique | Default | PROCESSING_STATUS_CODE |
| RCV_HEADERS_INTERFACE_N3 | Non Unique | Default | SHIPMENT_NUM |
| RCV_HEADERS_INTERFACE_N4 | Non Unique | Default | LOAD_REQUEST_ID, HEADER_INTERFACE_NUM |
| RCV_HEADERS_INTERFACE_N5 | Non Unique | Default | EXTERNAL_SYS_TXN_REFERENCE |
| RCV_HEADERS_INTERFACE_N6 | Non Unique | Default | PROCESSING_REQUEST_ID |
| RCV_HEADERS_INTERFACE_N7 | Non Unique | Default | GROUP_ID |
| RCV_HEADERS_INTERFACE_U1 | Unique | Default | HEADER_INTERFACE_ID |