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 |