VIEW: PO.RCV_HEADERS_INTERFACE#

Source

View Text - Preformatted

select HEADER_INTERFACE_ID HEADER_INTERFACE_ID, GROUP_ID GROUP_ID, EDI_CONTROL_NUM EDI_CONTROL_NUM, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE, RECEIPT_SOURCE_CODE RECEIPT_SOURCE_CODE, ASN_TYPE ASN_TYPE, TRANSACTION_TYPE TRANSACTION_TYPE, AUTO_TRANSACT_CODE AUTO_TRANSACT_CODE, TEST_FLAG TEST_FLAG, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, NOTICE_CREATION_DATE NOTICE_CREATION_DATE, SHIPMENT_NUM SHIPMENT_NUM, RECEIPT_NUM RECEIPT_NUM, RECEIPT_HEADER_ID RECEIPT_HEADER_ID, VENDOR_NAME VENDOR_NAME, VENDOR_NUM VENDOR_NUM, VENDOR_ID VENDOR_ID, VENDOR_SITE_CODE VENDOR_SITE_CODE, VENDOR_SITE_ID VENDOR_SITE_ID, FROM_ORGANIZATION_CODE FROM_ORGANIZATION_CODE, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, SHIP_TO_ORGANIZATION_CODE SHIP_TO_ORGANIZATION_CODE, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID, LOCATION_CODE LOCATION_CODE, LOCATION_ID LOCATION_ID, BILL_OF_LADING BILL_OF_LADING, PACKING_SLIP PACKING_SLIP, SHIPPED_DATE SHIPPED_DATE, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE, EXPECTED_RECEIPT_DATE EXPECTED_RECEIPT_DATE, RECEIVER_ID RECEIVER_ID, NUM_OF_CONTAINERS NUM_OF_CONTAINERS, WAYBILL_AIRBILL_NUM WAYBILL_AIRBILL_NUM, COMMENTS COMMENTS, GROSS_WEIGHT GROSS_WEIGHT, GROSS_WEIGHT_UOM_CODE GROSS_WEIGHT_UOM_CODE, NET_WEIGHT NET_WEIGHT, NET_WEIGHT_UOM_CODE NET_WEIGHT_UOM_CODE, TAR_WEIGHT TAR_WEIGHT, TAR_WEIGHT_UOM_CODE TAR_WEIGHT_UOM_CODE, PACKAGING_CODE PACKAGING_CODE, CARRIER_METHOD CARRIER_METHOD, CARRIER_EQUIPMENT CARRIER_EQUIPMENT, SPECIAL_HANDLING_CODE SPECIAL_HANDLING_CODE, HAZARD_CODE HAZARD_CODE, HAZARD_CLASS HAZARD_CLASS, HAZARD_DESCRIPTION HAZARD_DESCRIPTION, FREIGHT_TERMS FREIGHT_TERMS, FREIGHT_BILL_NUMBER FREIGHT_BILL_NUMBER, INVOICE_NUM INVOICE_NUM, INVOICE_DATE INVOICE_DATE, TOTAL_INVOICE_AMOUNT TOTAL_INVOICE_AMOUNT, TAX_NAME TAX_NAME, TAX_AMOUNT TAX_AMOUNT, FREIGHT_AMOUNT FREIGHT_AMOUNT, CURRENCY_CODE CURRENCY_CODE, CONVERSION_RATE_TYPE CONVERSION_RATE_TYPE, CONVERSION_RATE CONVERSION_RATE, CONVERSION_RATE_DATE CONVERSION_RATE_DATE, PAYMENT_TERMS_NAME PAYMENT_TERMS_NAME, PAYMENT_TERMS_ID PAYMENT_TERMS_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, USGGL_TRANSACTION_CODE USGGL_TRANSACTION_CODE, EMPLOYEE_NAME EMPLOYEE_NAME, EMPLOYEE_ID EMPLOYEE_ID, INVOICE_STATUS_CODE INVOICE_STATUS_CODE, VALIDATION_FLAG VALIDATION_FLAG, PROCESSING_REQUEST_ID PROCESSING_REQUEST_ID, CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, CUSTOMER_PARTY_NAME CUSTOMER_PARTY_NAME, REMIT_TO_SITE_ID REMIT_TO_SITE_ID, TRANSACTION_DATE TRANSACTION_DATE, ORG_ID ORG_ID, OPERATING_UNIT OPERATING_UNIT, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID, PERFORMANCE_PERIOD_FROM PERFORMANCE_PERIOD_FROM, PERFORMANCE_PERIOD_TO PERFORMANCE_PERIOD_TO, REQUEST_DATE REQUEST_DATE, SHIP_FROM_LOCATION_CODE SHIP_FROM_LOCATION_CODE from "PO"."RCV_HEADERS_INTERFACE"

View Text - HTML Formatted

SELECT HEADER_INTERFACE_ID HEADER_INTERFACE_ID
, GROUP_ID GROUP_ID
, EDI_CONTROL_NUM EDI_CONTROL_NUM
, PROCESSING_STATUS_CODE PROCESSING_STATUS_CODE
, RECEIPT_SOURCE_CODE RECEIPT_SOURCE_CODE
, ASN_TYPE ASN_TYPE
, TRANSACTION_TYPE TRANSACTION_TYPE
, AUTO_TRANSACT_CODE AUTO_TRANSACT_CODE
, TEST_FLAG TEST_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, NOTICE_CREATION_DATE NOTICE_CREATION_DATE
, SHIPMENT_NUM SHIPMENT_NUM
, RECEIPT_NUM RECEIPT_NUM
, RECEIPT_HEADER_ID RECEIPT_HEADER_ID
, VENDOR_NAME VENDOR_NAME
, VENDOR_NUM VENDOR_NUM
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, VENDOR_SITE_ID VENDOR_SITE_ID
, FROM_ORGANIZATION_CODE FROM_ORGANIZATION_CODE
, FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, SHIP_TO_ORGANIZATION_CODE SHIP_TO_ORGANIZATION_CODE
, SHIP_TO_ORGANIZATION_ID SHIP_TO_ORGANIZATION_ID
, LOCATION_CODE LOCATION_CODE
, LOCATION_ID LOCATION_ID
, BILL_OF_LADING BILL_OF_LADING
, PACKING_SLIP PACKING_SLIP
, SHIPPED_DATE SHIPPED_DATE
, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, EXPECTED_RECEIPT_DATE EXPECTED_RECEIPT_DATE
, RECEIVER_ID RECEIVER_ID
, NUM_OF_CONTAINERS NUM_OF_CONTAINERS
, WAYBILL_AIRBILL_NUM WAYBILL_AIRBILL_NUM
, COMMENTS COMMENTS
, GROSS_WEIGHT GROSS_WEIGHT
, GROSS_WEIGHT_UOM_CODE GROSS_WEIGHT_UOM_CODE
, NET_WEIGHT NET_WEIGHT
, NET_WEIGHT_UOM_CODE NET_WEIGHT_UOM_CODE
, TAR_WEIGHT TAR_WEIGHT
, TAR_WEIGHT_UOM_CODE TAR_WEIGHT_UOM_CODE
, PACKAGING_CODE PACKAGING_CODE
, CARRIER_METHOD CARRIER_METHOD
, CARRIER_EQUIPMENT CARRIER_EQUIPMENT
, SPECIAL_HANDLING_CODE SPECIAL_HANDLING_CODE
, HAZARD_CODE HAZARD_CODE
, HAZARD_CLASS HAZARD_CLASS
, HAZARD_DESCRIPTION HAZARD_DESCRIPTION
, FREIGHT_TERMS FREIGHT_TERMS
, FREIGHT_BILL_NUMBER FREIGHT_BILL_NUMBER
, INVOICE_NUM INVOICE_NUM
, INVOICE_DATE INVOICE_DATE
, TOTAL_INVOICE_AMOUNT TOTAL_INVOICE_AMOUNT
, TAX_NAME TAX_NAME
, TAX_AMOUNT TAX_AMOUNT
, FREIGHT_AMOUNT FREIGHT_AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, CONVERSION_RATE_TYPE CONVERSION_RATE_TYPE
, CONVERSION_RATE CONVERSION_RATE
, CONVERSION_RATE_DATE CONVERSION_RATE_DATE
, PAYMENT_TERMS_NAME PAYMENT_TERMS_NAME
, PAYMENT_TERMS_ID PAYMENT_TERMS_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, USGGL_TRANSACTION_CODE USGGL_TRANSACTION_CODE
, EMPLOYEE_NAME EMPLOYEE_NAME
, EMPLOYEE_ID EMPLOYEE_ID
, INVOICE_STATUS_CODE INVOICE_STATUS_CODE
, VALIDATION_FLAG VALIDATION_FLAG
, PROCESSING_REQUEST_ID PROCESSING_REQUEST_ID
, CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, CUSTOMER_PARTY_NAME CUSTOMER_PARTY_NAME
, REMIT_TO_SITE_ID REMIT_TO_SITE_ID
, TRANSACTION_DATE TRANSACTION_DATE
, ORG_ID ORG_ID
, OPERATING_UNIT OPERATING_UNIT
, SHIP_FROM_LOCATION_ID SHIP_FROM_LOCATION_ID
, PERFORMANCE_PERIOD_FROM PERFORMANCE_PERIOD_FROM
, PERFORMANCE_PERIOD_TO PERFORMANCE_PERIOD_TO
, REQUEST_DATE REQUEST_DATE
, SHIP_FROM_LOCATION_CODE SHIP_FROM_LOCATION_CODE
FROM "PO"."RCV_HEADERS_INTERFACE"