VIEW: WSH.WSH_NEW_DEL_INTERFACE#

Source

View Text - Preformatted

select DELIVERY_INTERFACE_ID DELIVERY_INTERFACE_ID, DELIVERY_ID DELIVERY_ID, NAME NAME, PLANNED_FLAG PLANNED_FLAG, STATUS_CODE STATUS_CODE, INITIAL_PICKUP_DATE INITIAL_PICKUP_DATE, INITIAL_PICKUP_LOCATION_ID INITIAL_PICKUP_LOCATION_ID, ULTIMATE_DROPOFF_LOCATION_ID ULTIMATE_DROPOFF_LOCATION_ID, ULTIMATE_DROPOFF_DATE ULTIMATE_DROPOFF_DATE, CUSTOMER_ID CUSTOMER_ID, INTMED_SHIP_TO_LOCATION_ID INTMED_SHIP_TO_LOCATION_ID, POOLED_SHIP_TO_LOCATION_ID POOLED_SHIP_TO_LOCATION_ID, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FOB_CODE FOB_CODE, FOB_LOCATION_ID FOB_LOCATION_ID, WAYBILL WAYBILL, LOAD_TENDER_FLAG LOAD_TENDER_FLAG, ACCEPTANCE_FLAG ACCEPTANCE_FLAG, ACCEPTED_BY ACCEPTED_BY, ACCEPTED_DATE ACCEPTED_DATE, ACKNOWLEDGED_BY ACKNOWLEDGED_BY, CONFIRMED_BY CONFIRMED_BY, ASN_DATE_SENT ASN_DATE_SENT, ASN_STATUS_CODE ASN_STATUS_CODE, ASN_SEQ_NUMBER ASN_SEQ_NUMBER, GROSS_WEIGHT GROSS_WEIGHT, NET_WEIGHT NET_WEIGHT, WEIGHT_UOM_CODE WEIGHT_UOM_CODE, VOLUME VOLUME, VOLUME_UOM_CODE VOLUME_UOM_CODE, ADDITIONAL_SHIPMENT_INFO ADDITIONAL_SHIPMENT_INFO, 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, TP_ATTRIBUTE_CATEGORY TP_ATTRIBUTE_CATEGORY, TP_ATTRIBUTE1 TP_ATTRIBUTE1, TP_ATTRIBUTE2 TP_ATTRIBUTE2, TP_ATTRIBUTE3 TP_ATTRIBUTE3, TP_ATTRIBUTE4 TP_ATTRIBUTE4, TP_ATTRIBUTE5 TP_ATTRIBUTE5, TP_ATTRIBUTE6 TP_ATTRIBUTE6, TP_ATTRIBUTE7 TP_ATTRIBUTE7, TP_ATTRIBUTE8 TP_ATTRIBUTE8, TP_ATTRIBUTE9 TP_ATTRIBUTE9, TP_ATTRIBUTE10 TP_ATTRIBUTE10, TP_ATTRIBUTE11 TP_ATTRIBUTE11, TP_ATTRIBUTE12 TP_ATTRIBUTE12, TP_ATTRIBUTE13 TP_ATTRIBUTE13, TP_ATTRIBUTE14 TP_ATTRIBUTE14, TP_ATTRIBUTE15 TP_ATTRIBUTE15, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, INTERFACE_ACTION_CODE INTERFACE_ACTION_CODE, LOCK_FLAG LOCK_FLAG, PROCESS_FLAG PROCESS_FLAG, PROCESS_MODE PROCESS_MODE, DELETE_FLAG DELETE_FLAG, PROCESS_STATUS_FLAG PROCESS_STATUS_FLAG, CURRENCY_CODE CURRENCY_CODE, DELIVERY_TYPE DELIVERY_TYPE, ORGANIZATION_ID ORGANIZATION_ID, CARRIER_ID CARRIER_ID, SHIP_METHOD_CODE SHIP_METHOD_CODE, DOCK_CODE DOCK_CODE, CONFIRM_DATE CONFIRM_DATE, BATCH_ID BATCH_ID, BILL_FREIGHT_TO BILL_FREIGHT_TO, BOOKING_NUMBER BOOKING_NUMBER, CARRIED_BY CARRIED_BY, COD_AMOUNT COD_AMOUNT, COD_CHARGE_PAID_BY COD_CHARGE_PAID_BY, COD_CURRENCY_CODE COD_CURRENCY_CODE, COD_REMIT_TO COD_REMIT_TO, DESCRIPTION DESCRIPTION, ENTRY_NUMBER ENTRY_NUMBER, FTZ_NUMBER FTZ_NUMBER, HASH_VALUE HASH_VALUE, IN_BOND_CODE IN_BOND_CODE, LOADING_ORDER_FLAG LOADING_ORDER_FLAG, LOADING_SEQUENCE LOADING_SEQUENCE, NUMBER_OF_LPN NUMBER_OF_LPN, PORT_OF_DISCHARGE PORT_OF_DISCHARGE, PORT_OF_LOADING PORT_OF_LOADING, PROBLEM_CONTACT_REFERENCE PROBLEM_CONTACT_REFERENCE, REASON_OF_TRANSPORT REASON_OF_TRANSPORT, ROUTED_EXPORT_TXN ROUTED_EXPORT_TXN, ROUTING_INSTRUCTIONS ROUTING_INSTRUCTIONS, SERVICE_CONTRACT SERVICE_CONTRACT, SHIPPING_MARKS SHIPPING_MARKS, SOURCE_HEADER_ID SOURCE_HEADER_ID, CARRIER_CODE CARRIER_CODE, CUSTOMER_NUMBER CUSTOMER_NUMBER, FOB_LOCATION_CODE FOB_LOCATION_CODE, INITIAL_PICKUP_LOCATION_CODE INITIAL_PICKUP_LOCATION_CODE, INTMED_SHIP_TO_LOCATION_CODE INTMED_SHIP_TO_LOCATION_CODE, ORGANIZATION_CODE ORGANIZATION_CODE, POOLED_SHIP_TO_LOCATION_CODE POOLED_SHIP_TO_LOCATION_CODE, ULTIMATE_DROPOFF_LOCATION_CODE ULTIMATE_DROPOFF_LOCATION_CODE, CUSTOMER_NAME CUSTOMER_NAME, SERVICE_LEVEL SERVICE_LEVEL, MODE_OF_TRANSPORT MODE_OF_TRANSPORT, TP_DELIVERY_NUMBER TP_DELIVERY_NUMBER, TP_PLAN_NAME TP_PLAN_NAME, VENDOR_ID VENDOR_ID, EARLIEST_PICKUP_DATE EARLIEST_PICKUP_DATE, LATEST_PICKUP_DATE LATEST_PICKUP_DATE, EARLIEST_DROPOFF_DATE EARLIEST_DROPOFF_DATE, LATEST_DROPOFF_DATE LATEST_DROPOFF_DATE, IGNORE_FOR_PLANNING IGNORE_FOR_PLANNING, PARTY_ID PARTY_ID, ROUTING_RESPONSE_ID ROUTING_RESPONSE_ID, RCV_SHIPMENT_HEADER_ID RCV_SHIPMENT_HEADER_ID, ASN_SHIPMENT_HEADER_ID ASN_SHIPMENT_HEADER_ID, SHIPMENT_DIRECTION SHIPMENT_DIRECTION, SHIPPING_CONTROL SHIPPING_CONTROL, HASH_STRING HASH_STRING, WV_FROZEN_FLAG WV_FROZEN_FLAG, DELIVERED_DATE DELIVERED_DATE, TMS_VERSION_NUMBER TMS_VERSION_NUMBER, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID, SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS1, SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS2, SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS3, SHIP_TO_ADDRESS4 SHIP_TO_ADDRESS4, SHIP_TO_CITY SHIP_TO_CITY, SHIP_TO_STATE SHIP_TO_STATE, SHIP_TO_COUNTRY SHIP_TO_COUNTRY, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, SHIP_TO_CONTACT_NAME SHIP_TO_CONTACT_NAME, SHIP_TO_CONTACT_PHONE SHIP_TO_CONTACT_PHONE, INVOICE_TO_CUSTOMER_ID INVOICE_TO_CUSTOMER_ID, INVOICE_TO_CUSTOMER_NAME INVOICE_TO_CUSTOMER_NAME, INVOICE_TO_ADDRESS_ID INVOICE_TO_ADDRESS_ID, INVOICE_TO_ADDRESS1 INVOICE_TO_ADDRESS1, INVOICE_TO_ADDRESS2 INVOICE_TO_ADDRESS2, INVOICE_TO_ADDRESS3 INVOICE_TO_ADDRESS3, INVOICE_TO_ADDRESS4 INVOICE_TO_ADDRESS4, INVOICE_TO_CITY INVOICE_TO_CITY, INVOICE_TO_STATE INVOICE_TO_STATE, INVOICE_TO_COUNTRY INVOICE_TO_COUNTRY, INVOICE_TO_POSTAL_CODE INVOICE_TO_POSTAL_CODE, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID, INVOICE_TO_CONTACT_NAME INVOICE_TO_CONTACT_NAME, INVOICE_TO_CONTACT_PHONE INVOICE_TO_CONTACT_PHONE, DELIVER_TO_CUSTOMER_ID DELIVER_TO_CUSTOMER_ID, DELIVER_TO_CUSTOMER_NAME DELIVER_TO_CUSTOMER_NAME, DELIVER_TO_ADDRESS_ID DELIVER_TO_ADDRESS_ID, DELIVER_TO_ADDRESS1 DELIVER_TO_ADDRESS1, DELIVER_TO_ADDRESS2 DELIVER_TO_ADDRESS2, DELIVER_TO_ADDRESS3 DELIVER_TO_ADDRESS3, DELIVER_TO_ADDRESS4 DELIVER_TO_ADDRESS4, DELIVER_TO_CITY DELIVER_TO_CITY, DELIVER_TO_STATE DELIVER_TO_STATE, DELIVER_TO_COUNTRY DELIVER_TO_COUNTRY, DELIVER_TO_POSTAL_CODE DELIVER_TO_POSTAL_CODE, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID, DELIVER_TO_CONTACT_NAME DELIVER_TO_CONTACT_NAME, DELIVER_TO_CONTACT_PHONE DELIVER_TO_CONTACT_PHONE, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID, PRICE_LIST_ID PRICE_LIST_ID, CLIENT_CODE CLIENT_CODE from "WSH"."WSH_NEW_DEL_INTERFACE"

View Text - HTML Formatted

SELECT DELIVERY_INTERFACE_ID DELIVERY_INTERFACE_ID
, DELIVERY_ID DELIVERY_ID
, NAME NAME
, PLANNED_FLAG PLANNED_FLAG
, STATUS_CODE STATUS_CODE
, INITIAL_PICKUP_DATE INITIAL_PICKUP_DATE
, INITIAL_PICKUP_LOCATION_ID INITIAL_PICKUP_LOCATION_ID
, ULTIMATE_DROPOFF_LOCATION_ID ULTIMATE_DROPOFF_LOCATION_ID
, ULTIMATE_DROPOFF_DATE ULTIMATE_DROPOFF_DATE
, CUSTOMER_ID CUSTOMER_ID
, INTMED_SHIP_TO_LOCATION_ID INTMED_SHIP_TO_LOCATION_ID
, POOLED_SHIP_TO_LOCATION_ID POOLED_SHIP_TO_LOCATION_ID
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FOB_CODE FOB_CODE
, FOB_LOCATION_ID FOB_LOCATION_ID
, WAYBILL WAYBILL
, LOAD_TENDER_FLAG LOAD_TENDER_FLAG
, ACCEPTANCE_FLAG ACCEPTANCE_FLAG
, ACCEPTED_BY ACCEPTED_BY
, ACCEPTED_DATE ACCEPTED_DATE
, ACKNOWLEDGED_BY ACKNOWLEDGED_BY
, CONFIRMED_BY CONFIRMED_BY
, ASN_DATE_SENT ASN_DATE_SENT
, ASN_STATUS_CODE ASN_STATUS_CODE
, ASN_SEQ_NUMBER ASN_SEQ_NUMBER
, GROSS_WEIGHT GROSS_WEIGHT
, NET_WEIGHT NET_WEIGHT
, WEIGHT_UOM_CODE WEIGHT_UOM_CODE
, VOLUME VOLUME
, VOLUME_UOM_CODE VOLUME_UOM_CODE
, ADDITIONAL_SHIPMENT_INFO ADDITIONAL_SHIPMENT_INFO
, 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
, TP_ATTRIBUTE_CATEGORY TP_ATTRIBUTE_CATEGORY
, TP_ATTRIBUTE1 TP_ATTRIBUTE1
, TP_ATTRIBUTE2 TP_ATTRIBUTE2
, TP_ATTRIBUTE3 TP_ATTRIBUTE3
, TP_ATTRIBUTE4 TP_ATTRIBUTE4
, TP_ATTRIBUTE5 TP_ATTRIBUTE5
, TP_ATTRIBUTE6 TP_ATTRIBUTE6
, TP_ATTRIBUTE7 TP_ATTRIBUTE7
, TP_ATTRIBUTE8 TP_ATTRIBUTE8
, TP_ATTRIBUTE9 TP_ATTRIBUTE9
, TP_ATTRIBUTE10 TP_ATTRIBUTE10
, TP_ATTRIBUTE11 TP_ATTRIBUTE11
, TP_ATTRIBUTE12 TP_ATTRIBUTE12
, TP_ATTRIBUTE13 TP_ATTRIBUTE13
, TP_ATTRIBUTE14 TP_ATTRIBUTE14
, TP_ATTRIBUTE15 TP_ATTRIBUTE15
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, INTERFACE_ACTION_CODE INTERFACE_ACTION_CODE
, LOCK_FLAG LOCK_FLAG
, PROCESS_FLAG PROCESS_FLAG
, PROCESS_MODE PROCESS_MODE
, DELETE_FLAG DELETE_FLAG
, PROCESS_STATUS_FLAG PROCESS_STATUS_FLAG
, CURRENCY_CODE CURRENCY_CODE
, DELIVERY_TYPE DELIVERY_TYPE
, ORGANIZATION_ID ORGANIZATION_ID
, CARRIER_ID CARRIER_ID
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, DOCK_CODE DOCK_CODE
, CONFIRM_DATE CONFIRM_DATE
, BATCH_ID BATCH_ID
, BILL_FREIGHT_TO BILL_FREIGHT_TO
, BOOKING_NUMBER BOOKING_NUMBER
, CARRIED_BY CARRIED_BY
, COD_AMOUNT COD_AMOUNT
, COD_CHARGE_PAID_BY COD_CHARGE_PAID_BY
, COD_CURRENCY_CODE COD_CURRENCY_CODE
, COD_REMIT_TO COD_REMIT_TO
, DESCRIPTION DESCRIPTION
, ENTRY_NUMBER ENTRY_NUMBER
, FTZ_NUMBER FTZ_NUMBER
, HASH_VALUE HASH_VALUE
, IN_BOND_CODE IN_BOND_CODE
, LOADING_ORDER_FLAG LOADING_ORDER_FLAG
, LOADING_SEQUENCE LOADING_SEQUENCE
, NUMBER_OF_LPN NUMBER_OF_LPN
, PORT_OF_DISCHARGE PORT_OF_DISCHARGE
, PORT_OF_LOADING PORT_OF_LOADING
, PROBLEM_CONTACT_REFERENCE PROBLEM_CONTACT_REFERENCE
, REASON_OF_TRANSPORT REASON_OF_TRANSPORT
, ROUTED_EXPORT_TXN ROUTED_EXPORT_TXN
, ROUTING_INSTRUCTIONS ROUTING_INSTRUCTIONS
, SERVICE_CONTRACT SERVICE_CONTRACT
, SHIPPING_MARKS SHIPPING_MARKS
, SOURCE_HEADER_ID SOURCE_HEADER_ID
, CARRIER_CODE CARRIER_CODE
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, FOB_LOCATION_CODE FOB_LOCATION_CODE
, INITIAL_PICKUP_LOCATION_CODE INITIAL_PICKUP_LOCATION_CODE
, INTMED_SHIP_TO_LOCATION_CODE INTMED_SHIP_TO_LOCATION_CODE
, ORGANIZATION_CODE ORGANIZATION_CODE
, POOLED_SHIP_TO_LOCATION_CODE POOLED_SHIP_TO_LOCATION_CODE
, ULTIMATE_DROPOFF_LOCATION_CODE ULTIMATE_DROPOFF_LOCATION_CODE
, CUSTOMER_NAME CUSTOMER_NAME
, SERVICE_LEVEL SERVICE_LEVEL
, MODE_OF_TRANSPORT MODE_OF_TRANSPORT
, TP_DELIVERY_NUMBER TP_DELIVERY_NUMBER
, TP_PLAN_NAME TP_PLAN_NAME
, VENDOR_ID VENDOR_ID
, EARLIEST_PICKUP_DATE EARLIEST_PICKUP_DATE
, LATEST_PICKUP_DATE LATEST_PICKUP_DATE
, EARLIEST_DROPOFF_DATE EARLIEST_DROPOFF_DATE
, LATEST_DROPOFF_DATE LATEST_DROPOFF_DATE
, IGNORE_FOR_PLANNING IGNORE_FOR_PLANNING
, PARTY_ID PARTY_ID
, ROUTING_RESPONSE_ID ROUTING_RESPONSE_ID
, RCV_SHIPMENT_HEADER_ID RCV_SHIPMENT_HEADER_ID
, ASN_SHIPMENT_HEADER_ID ASN_SHIPMENT_HEADER_ID
, SHIPMENT_DIRECTION SHIPMENT_DIRECTION
, SHIPPING_CONTROL SHIPPING_CONTROL
, HASH_STRING HASH_STRING
, WV_FROZEN_FLAG WV_FROZEN_FLAG
, DELIVERED_DATE DELIVERED_DATE
, TMS_VERSION_NUMBER TMS_VERSION_NUMBER
, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME
, SHIP_TO_ADDRESS_ID SHIP_TO_ADDRESS_ID
, SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4 SHIP_TO_ADDRESS4
, SHIP_TO_CITY SHIP_TO_CITY
, SHIP_TO_STATE SHIP_TO_STATE
, SHIP_TO_COUNTRY SHIP_TO_COUNTRY
, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, SHIP_TO_CONTACT_NAME SHIP_TO_CONTACT_NAME
, SHIP_TO_CONTACT_PHONE SHIP_TO_CONTACT_PHONE
, INVOICE_TO_CUSTOMER_ID INVOICE_TO_CUSTOMER_ID
, INVOICE_TO_CUSTOMER_NAME INVOICE_TO_CUSTOMER_NAME
, INVOICE_TO_ADDRESS_ID INVOICE_TO_ADDRESS_ID
, INVOICE_TO_ADDRESS1 INVOICE_TO_ADDRESS1
, INVOICE_TO_ADDRESS2 INVOICE_TO_ADDRESS2
, INVOICE_TO_ADDRESS3 INVOICE_TO_ADDRESS3
, INVOICE_TO_ADDRESS4 INVOICE_TO_ADDRESS4
, INVOICE_TO_CITY INVOICE_TO_CITY
, INVOICE_TO_STATE INVOICE_TO_STATE
, INVOICE_TO_COUNTRY INVOICE_TO_COUNTRY
, INVOICE_TO_POSTAL_CODE INVOICE_TO_POSTAL_CODE
, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, INVOICE_TO_CONTACT_NAME INVOICE_TO_CONTACT_NAME
, INVOICE_TO_CONTACT_PHONE INVOICE_TO_CONTACT_PHONE
, DELIVER_TO_CUSTOMER_ID DELIVER_TO_CUSTOMER_ID
, DELIVER_TO_CUSTOMER_NAME DELIVER_TO_CUSTOMER_NAME
, DELIVER_TO_ADDRESS_ID DELIVER_TO_ADDRESS_ID
, DELIVER_TO_ADDRESS1 DELIVER_TO_ADDRESS1
, DELIVER_TO_ADDRESS2 DELIVER_TO_ADDRESS2
, DELIVER_TO_ADDRESS3 DELIVER_TO_ADDRESS3
, DELIVER_TO_ADDRESS4 DELIVER_TO_ADDRESS4
, DELIVER_TO_CITY DELIVER_TO_CITY
, DELIVER_TO_STATE DELIVER_TO_STATE
, DELIVER_TO_COUNTRY DELIVER_TO_COUNTRY
, DELIVER_TO_POSTAL_CODE DELIVER_TO_POSTAL_CODE
, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID
, DELIVER_TO_CONTACT_NAME DELIVER_TO_CONTACT_NAME
, DELIVER_TO_CONTACT_PHONE DELIVER_TO_CONTACT_PHONE
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, PRICE_LIST_ID PRICE_LIST_ID
, CLIENT_CODE CLIENT_CODE
FROM "WSH"."WSH_NEW_DEL_INTERFACE"