[Home] [Help] [Dependency Information]
Object Name: | RCV_HEADERS_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_INTERFACE_ID | NUMBER | Yes | ||
GROUP_ID | NUMBER | |||
EDI_CONTROL_NUM | VARCHAR2 | (10) | ||
PROCESSING_STATUS_CODE | VARCHAR2 | (25) | ||
RECEIPT_SOURCE_CODE | VARCHAR2 | (25) | ||
ASN_TYPE | VARCHAR2 | (25) | ||
TRANSACTION_TYPE | VARCHAR2 | (25) | ||
AUTO_TRANSACT_CODE | VARCHAR2 | (25) | ||
TEST_FLAG | VARCHAR2 | (1) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
NOTICE_CREATION_DATE | DATE | |||
SHIPMENT_NUM | VARCHAR2 | (30) | ||
RECEIPT_NUM | VARCHAR2 | (30) | ||
RECEIPT_HEADER_ID | NUMBER | |||
VENDOR_NAME | VARCHAR2 | (240) | ||
VENDOR_NUM | VARCHAR2 | (30) | ||
VENDOR_ID | NUMBER | |||
VENDOR_SITE_CODE | VARCHAR2 | (35) | ||
VENDOR_SITE_ID | NUMBER | |||
FROM_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
FROM_ORGANIZATION_ID | NUMBER | |||
SHIP_TO_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
SHIP_TO_ORGANIZATION_ID | NUMBER | |||
LOCATION_CODE | VARCHAR2 | (60) | ||
LOCATION_ID | NUMBER | |||
BILL_OF_LADING | VARCHAR2 | (25) | ||
PACKING_SLIP | VARCHAR2 | (25) | ||
SHIPPED_DATE | DATE | |||
FREIGHT_CARRIER_CODE | VARCHAR2 | (25) | ||
EXPECTED_RECEIPT_DATE | DATE | |||
RECEIVER_ID | NUMBER | |||
NUM_OF_CONTAINERS | NUMBER | |||
WAYBILL_AIRBILL_NUM | VARCHAR2 | (30) | ||
COMMENTS | VARCHAR2 | (240) | ||
GROSS_WEIGHT | NUMBER | |||
GROSS_WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
NET_WEIGHT | NUMBER | |||
NET_WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
TAR_WEIGHT | NUMBER | |||
TAR_WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
PACKAGING_CODE | VARCHAR2 | (5) | ||
CARRIER_METHOD | VARCHAR2 | (2) | ||
CARRIER_EQUIPMENT | VARCHAR2 | (10) | ||
SPECIAL_HANDLING_CODE | VARCHAR2 | (3) | ||
HAZARD_CODE | VARCHAR2 | (1) | ||
HAZARD_CLASS | VARCHAR2 | (4) | ||
HAZARD_DESCRIPTION | VARCHAR2 | (80) | ||
FREIGHT_TERMS | VARCHAR2 | (25) | ||
FREIGHT_BILL_NUMBER | VARCHAR2 | (35) | ||
INVOICE_NUM | VARCHAR2 | (30) | ||
INVOICE_DATE | DATE | |||
TOTAL_INVOICE_AMOUNT | NUMBER | |||
TAX_NAME | VARCHAR2 | (50) | ||
TAX_AMOUNT | NUMBER | |||
FREIGHT_AMOUNT | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CONVERSION_RATE_TYPE | VARCHAR2 | (30) | ||
CONVERSION_RATE | NUMBER | |||
CONVERSION_RATE_DATE | DATE | |||
PAYMENT_TERMS_NAME | VARCHAR2 | (50) | ||
PAYMENT_TERMS_ID | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
USGGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
EMPLOYEE_NAME | VARCHAR2 | (240) | ||
EMPLOYEE_ID | NUMBER | |||
INVOICE_STATUS_CODE | VARCHAR2 | (25) | ||
VALIDATION_FLAG | VARCHAR2 | (1) | ||
PROCESSING_REQUEST_ID | NUMBER | |||
CUSTOMER_ACCOUNT_NUMBER | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
CUSTOMER_SITE_ID | NUMBER | |||
CUSTOMER_PARTY_NAME | VARCHAR2 | (360) | ||
REMIT_TO_SITE_ID | NUMBER | |||
TRANSACTION_DATE | DATE | |||
ORG_ID | NUMBER | |||
OPERATING_UNIT | VARCHAR2 | (240) | ||
SHIP_FROM_LOCATION_ID | NUMBER | |||
PERFORMANCE_PERIOD_FROM | DATE | |||
PERFORMANCE_PERIOD_TO | DATE | |||
REQUEST_DATE | DATE | |||
SHIP_FROM_LOCATION_CODE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_INTERFACE_ID
, GROUP_ID
, EDI_CONTROL_NUM
, PROCESSING_STATUS_CODE
, RECEIPT_SOURCE_CODE
, ASN_TYPE
, TRANSACTION_TYPE
, AUTO_TRANSACT_CODE
, TEST_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, NOTICE_CREATION_DATE
, SHIPMENT_NUM
, RECEIPT_NUM
, RECEIPT_HEADER_ID
, VENDOR_NAME
, VENDOR_NUM
, VENDOR_ID
, VENDOR_SITE_CODE
, VENDOR_SITE_ID
, FROM_ORGANIZATION_CODE
, FROM_ORGANIZATION_ID
, SHIP_TO_ORGANIZATION_CODE
, SHIP_TO_ORGANIZATION_ID
, LOCATION_CODE
, LOCATION_ID
, BILL_OF_LADING
, PACKING_SLIP
, SHIPPED_DATE
, FREIGHT_CARRIER_CODE
, EXPECTED_RECEIPT_DATE
, RECEIVER_ID
, NUM_OF_CONTAINERS
, WAYBILL_AIRBILL_NUM
, COMMENTS
, GROSS_WEIGHT
, GROSS_WEIGHT_UOM_CODE
, NET_WEIGHT
, NET_WEIGHT_UOM_CODE
, TAR_WEIGHT
, TAR_WEIGHT_UOM_CODE
, PACKAGING_CODE
, CARRIER_METHOD
, CARRIER_EQUIPMENT
, SPECIAL_HANDLING_CODE
, HAZARD_CODE
, HAZARD_CLASS
, HAZARD_DESCRIPTION
, FREIGHT_TERMS
, FREIGHT_BILL_NUMBER
, INVOICE_NUM
, INVOICE_DATE
, TOTAL_INVOICE_AMOUNT
, TAX_NAME
, TAX_AMOUNT
, FREIGHT_AMOUNT
, CURRENCY_CODE
, CONVERSION_RATE_TYPE
, CONVERSION_RATE
, CONVERSION_RATE_DATE
, PAYMENT_TERMS_NAME
, PAYMENT_TERMS_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, USGGL_TRANSACTION_CODE
, EMPLOYEE_NAME
, EMPLOYEE_ID
, INVOICE_STATUS_CODE
, VALIDATION_FLAG
, PROCESSING_REQUEST_ID
, CUSTOMER_ACCOUNT_NUMBER
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, CUSTOMER_PARTY_NAME
, REMIT_TO_SITE_ID
, TRANSACTION_DATE
, ORG_ID
, OPERATING_UNIT
, SHIP_FROM_LOCATION_ID
, PERFORMANCE_PERIOD_FROM
, PERFORMANCE_PERIOD_TO
, REQUEST_DATE
, SHIP_FROM_LOCATION_CODE
FROM PO.RCV_HEADERS_INTERFACE#;
|
|
|