1. Tables and Views for SCM
  2. DOO_HEADERS_RM_V

DOO_HEADERS_RM_V

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: VIEW

Columns

Name

BILL_TO_CUSTOMER_PARTY_ID

EXCHANGE_DATE

EXCHANGE_RATE_TYPE

EXCHANGE_RATE

CURRENCY_CODE

CUST_PO_NUMBER

DOCUMENT_DATE

SOLD_TO_CUSTOMER_ID

LEGAL_ENTITY_ID

ORG_ID

DOCUMENT_NUMBER

DOC_ID_INT_1

DOCUMENT_TYPE_ID

SOURCE_SYSTEM

ACCOUNTING_EFFECT_FLAG

DOCUMENT_CREATION_DATE

DOCUMENT_UPDATE_DATE

Query

SQL_Statement

SELECT SOLD_TO_PARTY_ID BILL_TO_CUSTOMER_PARTY_ID,

CONVERSION_DATE EXCHANGE_DATE,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('CONVERSION_TYPE','CURRENCY_CONV_TYPES',CONVERSION_TYPE_CODE) EXCHANGE_RATE_TYPE,

CONVERSION_RATE EXCHANGE_RATE,

DOO_CROSS_REFERENCE.GETFULFILLMENTVALUE('CURRENCY_CODE','CURRENCIES',TRANSACTIONAL_CURRENCY_CODE) CURRENCY_CODE,

CUSTOMER_PO_NUMBER CUST_PO_NUMBER,

ORDERED_DATE DOCUMENT_DATE,

SOLD_TO_CUSTOMER_ID,

LEGAL_ENTITY_ID,

ORG_ID,

ORDER_NUMBER DOCUMENT_NUMBER,

HEADER_ID DOC_ID_INT_1,

5 DOCUMENT_TYPE_ID,

'FUSION' SOURCE_SYSTEM,

'N' ACCOUNTING_EFFECT_FLAG,

DHA.CREATION_DATE DOCUMENT_CREATION_DATE,

DHA.LAST_UPDATE_DATE DOCUMENT_UPDATE_DATE

FROM DOO_HEADERS_ALL DHA