VRM_BM_SOURCE_DOCUMENTS_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name

DOCUMENT_ID APPLICATION_ID DOCUMENT_TYPE_ID DOC_ID_INT_1 DOC_ID_INT_2 DOC_ID_INT_3 DOC_ID_INT_4 DOC_ID_INT_5 DOC_ID_CHAR_1 DOC_ID_CHAR_2 DOC_ID_CHAR_3 DOC_ID_CHAR_4 DOC_ID_CHAR_5 DOCUMENT_DATE DOCUMENT_NUMBER DOCUMENT_TYPE DOCUMENT_CREATION_DATE DOCUMENT_UPDATE_DATE CURRENCY_CODE SALESREP_ID SALESREP_NAME BILL_TO_CUSTOMER_PARTY_ID BILL_TO_CUSTOMER_PARTY_NUM BILL_TO_CUSTOMER_PARTY_NAME BILL_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID BILL_TO_CUSTOMER_NUM SHIP_TO_CUSTOMER_NUM BILL_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME BILL_TO_CUSTOMER_SITE_ID BILL_TO_CUST_SITE_NAME SHIP_TO_CUSTOMER_SITE_ID SHIP_TO_CUST_SITE_NAME BILL_TO_COUNTRY SHIP_TO_COUNTRY ORG_ID ORGANIZATION_NAME LEDGER_ID LEDGER_NAME LEGAL_ENTITY_ID LEGAL_ENTITY_NAME CUST_PO_NUMBER CUSTOMER_CONTRACT_NUMBER SALES_AGREEMENT_NUMBER QUOTE_NUMBER EXCHANGE_RATE EXCHANGE_RATE_TYPE EXCHANGE_DATE BILL_TO_CUSTOMER_STATE BILL_TO_CUSTOMER_COUNTY BILL_TO_CUSTOMER_CITY BILL_TO_CUSTOMER_POSTAL_CODE BILL_TO_CUST_CLASSIFICATION PAYMENT_TERM_NAME SRC_ATTRIBUTE_CHAR1 SRC_ATTRIBUTE_CHAR2 SRC_ATTRIBUTE_CHAR3 SRC_ATTRIBUTE_CHAR4 SRC_ATTRIBUTE_CHAR5 SRC_ATTRIBUTE_CHAR6 SRC_ATTRIBUTE_CHAR7 SRC_ATTRIBUTE_CHAR8 SRC_ATTRIBUTE_CHAR9 SRC_ATTRIBUTE_CHAR10 SRC_ATTRIBUTE_CHAR11 SRC_ATTRIBUTE_CHAR12 SRC_ATTRIBUTE_CHAR13 SRC_ATTRIBUTE_CHAR14 SRC_ATTRIBUTE_CHAR15 SRC_ATTRIBUTE_CHAR16 SRC_ATTRIBUTE_CHAR17 SRC_ATTRIBUTE_CHAR18 SRC_ATTRIBUTE_CHAR19 SRC_ATTRIBUTE_CHAR20 SRC_ATTRIBUTE_CHAR21 SRC_ATTRIBUTE_CHAR22 SRC_ATTRIBUTE_CHAR23 SRC_ATTRIBUTE_CHAR24 SRC_ATTRIBUTE_CHAR25 SRC_ATTRIBUTE_CHAR26 SRC_ATTRIBUTE_CHAR27 SRC_ATTRIBUTE_CHAR28 SRC_ATTRIBUTE_CHAR29 SRC_ATTRIBUTE_CHAR30 SRC_ATTRIBUTE_CHAR31 SRC_ATTRIBUTE_CHAR32 SRC_ATTRIBUTE_CHAR33 SRC_ATTRIBUTE_CHAR34 SRC_ATTRIBUTE_CHAR35 SRC_ATTRIBUTE_CHAR36 SRC_ATTRIBUTE_CHAR37 SRC_ATTRIBUTE_CHAR38 SRC_ATTRIBUTE_CHAR39 SRC_ATTRIBUTE_CHAR40 SRC_ATTRIBUTE_CHAR41 SRC_ATTRIBUTE_CHAR42 SRC_ATTRIBUTE_CHAR43 SRC_ATTRIBUTE_CHAR44 SRC_ATTRIBUTE_CHAR45 SRC_ATTRIBUTE_CHAR46 SRC_ATTRIBUTE_CHAR47 SRC_ATTRIBUTE_CHAR48 SRC_ATTRIBUTE_CHAR49 SRC_ATTRIBUTE_CHAR50 SRC_ATTRIBUTE_CHAR51 SRC_ATTRIBUTE_CHAR52 SRC_ATTRIBUTE_CHAR53 SRC_ATTRIBUTE_CHAR54 SRC_ATTRIBUTE_CHAR55 SRC_ATTRIBUTE_CHAR56 SRC_ATTRIBUTE_CHAR57 SRC_ATTRIBUTE_CHAR58 SRC_ATTRIBUTE_CHAR59 SRC_ATTRIBUTE_CHAR60 SRC_ATTRIBUTE_NUMBER1 SRC_ATTRIBUTE_NUMBER2 SRC_ATTRIBUTE_NUMBER3 SRC_ATTRIBUTE_NUMBER4 SRC_ATTRIBUTE_NUMBER5 SRC_ATTRIBUTE_NUMBER6 SRC_ATTRIBUTE_NUMBER7 SRC_ATTRIBUTE_NUMBER8 SRC_ATTRIBUTE_NUMBER9 SRC_ATTRIBUTE_NUMBER10 SRC_ATTRIBUTE_NUMBER11 SRC_ATTRIBUTE_NUMBER12 SRC_ATTRIBUTE_NUMBER13 SRC_ATTRIBUTE_NUMBER14 SRC_ATTRIBUTE_NUMBER15 SRC_ATTRIBUTE_NUMBER16 SRC_ATTRIBUTE_NUMBER17 SRC_ATTRIBUTE_NUMBER18 SRC_ATTRIBUTE_NUMBER19 SRC_ATTRIBUTE_NUMBER20 SRC_ATTRIBUTE_DATE1 SRC_ATTRIBUTE_DATE2 SRC_ATTRIBUTE_DATE3 SRC_ATTRIBUTE_DATE4 SRC_ATTRIBUTE_DATE5 SRC_ATTRIBUTE_DATE6 SRC_ATTRIBUTE_DATE7 SRC_ATTRIBUTE_DATE8 SRC_ATTRIBUTE_DATE9 SRC_ATTRIBUTE_DATE10 REQUEST_ID LEGAL_ENTITY_COUNTRY LEGAL_ENTITY_ADDRESS PAYMENT_TERM_ID INVOICING_RULE_ID ACCOUNTING_RULE_ID ACCOUNTING_RULE_DURATION CANCELLED_FLAG OPEN_FLAG RETURN_REASON_CODE MEA_FLAG SRC_ATTRIBUTE_CATEGORY SOURCE_ORG_ID ACCOUNTING_EFFECT_FLAG ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 SOURCE_TYPE_CODE LOAD_REQUEST_ID SOURCE_SYSTEM SP_FIRST_NAME SP_MIDDLE_NAME SP_LAST_NAME

Query

SQL_Statement

SELECT DOCUMENT_ID, APPLICATION_ID, DOCUMENT_TYPE_ID, DOC_ID_INT_1, DOC_ID_INT_2, DOC_ID_INT_3, DOC_ID_INT_4, DOC_ID_INT_5, DOC_ID_CHAR_1, DOC_ID_CHAR_2, DOC_ID_CHAR_3, DOC_ID_CHAR_4, DOC_ID_CHAR_5, DOCUMENT_DATE, DOCUMENT_NUMBER, DOCUMENT_TYPE, DOCUMENT_CREATION_DATE, DOCUMENT_UPDATE_DATE, CURRENCY_CODE, SALESREP_ID, SALESREP_NAME, BILL_TO_CUSTOMER_PARTY_ID, BILL_TO_CUSTOMER_PARTY_NUM, BILL_TO_CUSTOMER_PARTY_NAME, BILL_TO_CUSTOMER_ID, SHIP_TO_CUSTOMER_ID, BILL_TO_CUSTOMER_NUM, SHIP_TO_CUSTOMER_NUM, BILL_TO_CUSTOMER_NAME, SHIP_TO_CUSTOMER_NAME, BILL_TO_CUSTOMER_SITE_ID, BILL_TO_CUST_SITE_NAME, SHIP_TO_CUSTOMER_SITE_ID, SHIP_TO_CUST_SITE_NAME, BILL_TO_COUNTRY, SHIP_TO_COUNTRY, ORG_ID, ORGANIZATION_NAME, LEDGER_ID, LEDGER_NAME, LEGAL_ENTITY_ID, LEGAL_ENTITY_NAME, CUST_PO_NUMBER, CUSTOMER_CONTRACT_NUMBER, SALES_AGREEMENT_NUMBER, QUOTE_NUMBER, EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_DATE, BILL_TO_CUSTOMER_STATE, BILL_TO_CUSTOMER_COUNTY, BILL_TO_CUSTOMER_CITY, BILL_TO_CUSTOMER_POSTAL_CODE, BILL_TO_CUST_CLASSIFICATION, PAYMENT_TERM_NAME, SRC_ATTRIBUTE_CHAR1, SRC_ATTRIBUTE_CHAR2, SRC_ATTRIBUTE_CHAR3, SRC_ATTRIBUTE_CHAR4, SRC_ATTRIBUTE_CHAR5, SRC_ATTRIBUTE_CHAR6, SRC_ATTRIBUTE_CHAR7, SRC_ATTRIBUTE_CHAR8, SRC_ATTRIBUTE_CHAR9, SRC_ATTRIBUTE_CHAR10, SRC_ATTRIBUTE_CHAR11, SRC_ATTRIBUTE_CHAR12, SRC_ATTRIBUTE_CHAR13, SRC_ATTRIBUTE_CHAR14, SRC_ATTRIBUTE_CHAR15, SRC_ATTRIBUTE_CHAR16, SRC_ATTRIBUTE_CHAR17, SRC_ATTRIBUTE_CHAR18, SRC_ATTRIBUTE_CHAR19, SRC_ATTRIBUTE_CHAR20, SRC_ATTRIBUTE_CHAR21, SRC_ATTRIBUTE_CHAR22, SRC_ATTRIBUTE_CHAR23, SRC_ATTRIBUTE_CHAR24, SRC_ATTRIBUTE_CHAR25, SRC_ATTRIBUTE_CHAR26, SRC_ATTRIBUTE_CHAR27, SRC_ATTRIBUTE_CHAR28, SRC_ATTRIBUTE_CHAR29, SRC_ATTRIBUTE_CHAR30, SRC_ATTRIBUTE_CHAR31, SRC_ATTRIBUTE_CHAR32, SRC_ATTRIBUTE_CHAR33, SRC_ATTRIBUTE_CHAR34, SRC_ATTRIBUTE_CHAR35, SRC_ATTRIBUTE_CHAR36, SRC_ATTRIBUTE_CHAR37, SRC_ATTRIBUTE_CHAR38, SRC_ATTRIBUTE_CHAR39, SRC_ATTRIBUTE_CHAR40, SRC_ATTRIBUTE_CHAR41, SRC_ATTRIBUTE_CHAR42, SRC_ATTRIBUTE_CHAR43, SRC_ATTRIBUTE_CHAR44, SRC_ATTRIBUTE_CHAR45, SRC_ATTRIBUTE_CHAR46, SRC_ATTRIBUTE_CHAR47, SRC_ATTRIBUTE_CHAR48, SRC_ATTRIBUTE_CHAR49, SRC_ATTRIBUTE_CHAR50, SRC_ATTRIBUTE_CHAR51, SRC_ATTRIBUTE_CHAR52, SRC_ATTRIBUTE_CHAR53, SRC_ATTRIBUTE_CHAR54, SRC_ATTRIBUTE_CHAR55, SRC_ATTRIBUTE_CHAR56, SRC_ATTRIBUTE_CHAR57, SRC_ATTRIBUTE_CHAR58, SRC_ATTRIBUTE_CHAR59, SRC_ATTRIBUTE_CHAR60, SRC_ATTRIBUTE_NUMBER1, SRC_ATTRIBUTE_NUMBER2, SRC_ATTRIBUTE_NUMBER3, SRC_ATTRIBUTE_NUMBER4, SRC_ATTRIBUTE_NUMBER5, SRC_ATTRIBUTE_NUMBER6, SRC_ATTRIBUTE_NUMBER7, SRC_ATTRIBUTE_NUMBER8, SRC_ATTRIBUTE_NUMBER9, SRC_ATTRIBUTE_NUMBER10, SRC_ATTRIBUTE_NUMBER11, SRC_ATTRIBUTE_NUMBER12, SRC_ATTRIBUTE_NUMBER13, SRC_ATTRIBUTE_NUMBER14, SRC_ATTRIBUTE_NUMBER15, SRC_ATTRIBUTE_NUMBER16, SRC_ATTRIBUTE_NUMBER17, SRC_ATTRIBUTE_NUMBER18, SRC_ATTRIBUTE_NUMBER19, SRC_ATTRIBUTE_NUMBER20, SRC_ATTRIBUTE_DATE1, SRC_ATTRIBUTE_DATE2, SRC_ATTRIBUTE_DATE3, SRC_ATTRIBUTE_DATE4, SRC_ATTRIBUTE_DATE5, SRC_ATTRIBUTE_DATE6, SRC_ATTRIBUTE_DATE7, SRC_ATTRIBUTE_DATE8, SRC_ATTRIBUTE_DATE9, SRC_ATTRIBUTE_DATE10, REQUEST_ID, LEGAL_ENTITY_COUNTRY, LEGAL_ENTITY_ADDRESS, PAYMENT_TERM_ID, INVOICING_RULE_ID, ACCOUNTING_RULE_ID, ACCOUNTING_RULE_DURATION, CANCELLED_FLAG, OPEN_FLAG, RETURN_REASON_CODE, MEA_FLAG, SRC_ATTRIBUTE_CATEGORY, SOURCE_ORG_ID, ACCOUNTING_EFFECT_FLAG, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE_DATE1, ATTRIBUTE_DATE2, ATTRIBUTE_DATE3, ATTRIBUTE_DATE4, ATTRIBUTE_DATE5, ATTRIBUTE_NUMBER1, ATTRIBUTE_NUMBER2, ATTRIBUTE_NUMBER3, ATTRIBUTE_NUMBER4, ATTRIBUTE_NUMBER5, SOURCE_TYPE_CODE, LOAD_REQUEST_ID, SOURCE_SYSTEM, SP_FIRST_NAME, SP_MIDDLE_NAME, SP_LAST_NAME FROM VRM_SOURCE_DOCUMENTS WHERE 1=2