DOO_ORDER_HEADERS

Details

Schema: FUSION
Object owner: DOO
Object type: VIEW

Columns

Name
HEADER_ID ORDER_NUMBER OBJECT_VERSION_NUMBER OWNER_ID SOURCE_ORDER_SYSTEM SOURCE_ORDER_NUMBER SOURCE_ORDER_ID SOURCE_DOCUMENT_TYPE_CODE ORIG_SYS_DOCUMENT_REF SOURCE_ORG_ID ORG_ID LEGAL_ENTITY_ID SOLD_TO_CUSTOMER_ID SOLD_TO_CONTACT_ID ORDERED_DATE CUSTOMER_PO_NUMBER ORDER_TYPE_CODE TRANSACTIONAL_CURRENCY_CODE CONVERSION_RATE CONVERSION_TYPE_CODE CONVERSION_DATE STATUS_CODE PARTIAL_SHIP_ALLOWED_FLAG OPEN_FLAG CANCELED_FLAG CHANGE_VERSION_NUMBER IS_EDITABLE ON_HOLD SOLD_TO_PARTY_ID SOLD_TO_PARTY_CONTACT_ID CANCEL_REASON_CODE REQUEST_CANCEL_DATE COMMENTS FREEZE_PRICE_FLAG FREEZE_SHIPPING_CHARGE_FLAG FREEZE_TAX_FLAG ALLOW_CURRENCY_OVERRIDE_FLAG APPLIED_CURRENCY_CODE PRICED_ON PRICING_SEGMENT_CODE SEGMENT_EXPLANATION_MSG_NAME STRATEGY_EXPLANATION_MSG_NAME PRICING_STRATEGY_ID SHIPSET_FLAG FULFILL_ORG_ID SUPPLIER_ID SUPPLIER_SITE_ID DEMAND_CLASS_CODE SUBSTITUTE_ALLOWED_FLAG FREIGHT_TERMS_CODE FOB_POINT_CODE PACKING_INSTRUCTIONS SHIPPING_INSTRUCTIONS SHIPMENT_PRIORITY_CODE REQUEST_SHIP_DATE LATEST_ACCEPTABLE_SHIP_DATE EARLIEST_ACCEPTABLE_SHIP_DATE CARRIER_ID SHIP_MODE_OF_TRANSPORT SHIP_CLASS_OF_SERVICE REQUEST_ARRIVAL_DATE LATEST_ACCEPT_ARRIVAL_DATE EARLIEST_ACCEPT_ARRIVAL_DATE REFERENCE_HEADER_ID PAYMENT_TERM_ID SOLD_TO_PARTY_CONTACT_POINT_ID REVISION_SOURCE_ORDER_SYSTEM SUBMITTED_FLAG TRADE_COMPLIANCE_RESULT_CODE SALESPERSON_ID SALES_CHANNEL_CODE AGREEMENT_HEADER_ID

Name

HEADER_ID

ORDER_NUMBER

OBJECT_VERSION_NUMBER

OWNER_ID

SOURCE_ORDER_SYSTEM

SOURCE_ORDER_NUMBER

SOURCE_ORDER_ID

SOURCE_DOCUMENT_TYPE_CODE

ORIG_SYS_DOCUMENT_REF

SOURCE_ORG_ID

ORG_ID

LEGAL_ENTITY_ID

SOLD_TO_CUSTOMER_ID

SOLD_TO_CONTACT_ID

ORDERED_DATE

CUSTOMER_PO_NUMBER

ORDER_TYPE_CODE

TRANSACTIONAL_CURRENCY_CODE

CONVERSION_RATE

CONVERSION_TYPE_CODE

CONVERSION_DATE

STATUS_CODE

PARTIAL_SHIP_ALLOWED_FLAG

OPEN_FLAG

CANCELED_FLAG

CHANGE_VERSION_NUMBER

IS_EDITABLE

ON_HOLD

SOLD_TO_PARTY_ID

SOLD_TO_PARTY_CONTACT_ID

CANCEL_REASON_CODE

REQUEST_CANCEL_DATE

COMMENTS

FREEZE_PRICE_FLAG

FREEZE_SHIPPING_CHARGE_FLAG

FREEZE_TAX_FLAG

ALLOW_CURRENCY_OVERRIDE_FLAG

APPLIED_CURRENCY_CODE

PRICED_ON

PRICING_SEGMENT_CODE

SEGMENT_EXPLANATION_MSG_NAME

STRATEGY_EXPLANATION_MSG_NAME

PRICING_STRATEGY_ID

SHIPSET_FLAG

FULFILL_ORG_ID

SUPPLIER_ID

SUPPLIER_SITE_ID

DEMAND_CLASS_CODE

SUBSTITUTE_ALLOWED_FLAG

FREIGHT_TERMS_CODE

FOB_POINT_CODE

PACKING_INSTRUCTIONS

SHIPPING_INSTRUCTIONS

SHIPMENT_PRIORITY_CODE

REQUEST_SHIP_DATE

LATEST_ACCEPTABLE_SHIP_DATE

EARLIEST_ACCEPTABLE_SHIP_DATE

CARRIER_ID

SHIP_MODE_OF_TRANSPORT

SHIP_CLASS_OF_SERVICE

REQUEST_ARRIVAL_DATE

LATEST_ACCEPT_ARRIVAL_DATE

EARLIEST_ACCEPT_ARRIVAL_DATE

REFERENCE_HEADER_ID

PAYMENT_TERM_ID

SOLD_TO_PARTY_CONTACT_POINT_ID

REVISION_SOURCE_ORDER_SYSTEM

SUBMITTED_FLAG

TRADE_COMPLIANCE_RESULT_CODE

SALESPERSON_ID

SALES_CHANNEL_CODE

AGREEMENT_HEADER_ID

Query

SQL_Statement
SELECT HEADER_ID, ORDER_NUMBER, OBJECT_VERSION_NUMBER, OWNER_ID, SOURCE_ORDER_SYSTEM, SOURCE_ORDER_NUMBER, SOURCE_ORDER_ID, SOURCE_DOCUMENT_TYPE_CODE, ORIG_SYS_DOCUMENT_REF, SOURCE_ORG_ID, ORG_ID, LEGAL_ENTITY_ID, SOLD_TO_CUSTOMER_ID, SOLD_TO_CONTACT_ID, ORDERED_DATE, CUSTOMER_PO_NUMBER, ORDER_TYPE_CODE, TRANSACTIONAL_CURRENCY_CODE, CONVERSION_RATE, CONVERSION_TYPE_CODE, CONVERSION_DATE, STATUS_CODE, PARTIAL_SHIP_ALLOWED_FLAG, OPEN_FLAG, CANCELED_FLAG, CHANGE_VERSION_NUMBER, IS_EDITABLE, ON_HOLD , SOLD_TO_PARTY_ID, SOLD_TO_PARTY_CONTACT_ID, CANCEL_REASON_CODE, REQUEST_CANCEL_DATE, COMMENTS, FREEZE_PRICE_FLAG, FREEZE_SHIPPING_CHARGE_FLAG, FREEZE_TAX_FLAG, ALLOW_CURRENCY_OVERRIDE_FLAG, APPLIED_CURRENCY_CODE , PRICED_ON , PRICING_SEGMENT_CODE, SEGMENT_EXPLANATION_MSG_NAME , STRATEGY_EXPLANATION_MSG_NAME , PRICING_STRATEGY_ID , SHIPSET_FLAG , FULFILL_ORG_ID , SUPPLIER_ID , SUPPLIER_SITE_ID , DEMAND_CLASS_CODE , SUBSTITUTE_ALLOWED_FLAG , FREIGHT_TERMS_CODE , FOB_POINT_CODE , PACKING_INSTRUCTIONS , SHIPPING_INSTRUCTIONS , SHIPMENT_PRIORITY_CODE , REQUEST_SHIP_DATE, LATEST_ACCEPTABLE_SHIP_DATE , EARLIEST_ACCEPTABLE_SHIP_DATE , CARRIER_ID , SHIP_MODE_OF_TRANSPORT , SHIP_CLASS_OF_SERVICE , REQUEST_ARRIVAL_DATE , LATEST_ACCEPT_ARRIVAL_DATE , EARLIEST_ACCEPT_ARRIVAL_DATE , REFERENCE_HEADER_ID , PAYMENT_TERM_ID , SOLD_TO_PARTY_CONTACT_POINT_ID, REVISION_SOURCE_ORDER_SYSTEM, SUBMITTED_FLAG, TRADE_COMPLIANCE_RESULT_CODE, SALESPERSON_ID, SALES_CHANNEL_CODE, AGREEMENT_HEADER_ID FROM DOO_HEADERS_ALL

SQL_Statement

SELECT

HEADER_ID,

ORDER_NUMBER,

OBJECT_VERSION_NUMBER,

OWNER_ID,

SOURCE_ORDER_SYSTEM,

SOURCE_ORDER_NUMBER,

SOURCE_ORDER_ID,

SOURCE_DOCUMENT_TYPE_CODE,

ORIG_SYS_DOCUMENT_REF,

SOURCE_ORG_ID,

ORG_ID,

LEGAL_ENTITY_ID,

SOLD_TO_CUSTOMER_ID,

SOLD_TO_CONTACT_ID,

ORDERED_DATE,

CUSTOMER_PO_NUMBER,

ORDER_TYPE_CODE,

TRANSACTIONAL_CURRENCY_CODE,

CONVERSION_RATE,

CONVERSION_TYPE_CODE,

CONVERSION_DATE,

STATUS_CODE,

PARTIAL_SHIP_ALLOWED_FLAG,

OPEN_FLAG,

CANCELED_FLAG,

CHANGE_VERSION_NUMBER,

IS_EDITABLE,

ON_HOLD ,

SOLD_TO_PARTY_ID,

SOLD_TO_PARTY_CONTACT_ID,

CANCEL_REASON_CODE,

REQUEST_CANCEL_DATE,

COMMENTS,

FREEZE_PRICE_FLAG,

FREEZE_SHIPPING_CHARGE_FLAG,

FREEZE_TAX_FLAG,

ALLOW_CURRENCY_OVERRIDE_FLAG,

APPLIED_CURRENCY_CODE ,

PRICED_ON ,

PRICING_SEGMENT_CODE,

SEGMENT_EXPLANATION_MSG_NAME ,

STRATEGY_EXPLANATION_MSG_NAME ,

PRICING_STRATEGY_ID ,

SHIPSET_FLAG ,

FULFILL_ORG_ID ,

SUPPLIER_ID ,

SUPPLIER_SITE_ID ,

DEMAND_CLASS_CODE ,

SUBSTITUTE_ALLOWED_FLAG ,

FREIGHT_TERMS_CODE ,

FOB_POINT_CODE ,

PACKING_INSTRUCTIONS ,

SHIPPING_INSTRUCTIONS ,

SHIPMENT_PRIORITY_CODE ,

REQUEST_SHIP_DATE,

LATEST_ACCEPTABLE_SHIP_DATE ,

EARLIEST_ACCEPTABLE_SHIP_DATE ,

CARRIER_ID ,

SHIP_MODE_OF_TRANSPORT ,

SHIP_CLASS_OF_SERVICE ,

REQUEST_ARRIVAL_DATE ,

LATEST_ACCEPT_ARRIVAL_DATE ,

EARLIEST_ACCEPT_ARRIVAL_DATE ,

REFERENCE_HEADER_ID ,

PAYMENT_TERM_ID ,

SOLD_TO_PARTY_CONTACT_POINT_ID,

REVISION_SOURCE_ORDER_SYSTEM,

SUBMITTED_FLAG,

TRADE_COMPLIANCE_RESULT_CODE,

SALESPERSON_ID,

SALES_CHANNEL_CODE,

AGREEMENT_HEADER_ID

FROM

DOO_HEADERS_ALL