VRM_BM_SOURCE_DOC_LINES_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name

DOCUMENT_LINE_ID DOCUMENT_ID APPLICATION_ID DOCUMENT_TYPE_ID DOC_LINE_ID_INT_1 DOC_LINE_ID_INT_2 DOC_LINE_ID_INT_3 DOC_LINE_ID_INT_4 DOC_LINE_ID_INT_5 DOC_LINE_ID_CHAR_1 DOC_LINE_ID_CHAR_2 DOC_LINE_ID_CHAR_3 DOC_LINE_ID_CHAR_4 DOC_LINE_ID_CHAR_5 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 LINE_TYPE LINE_NUMBER INVENTORY_ORG_ID ITEM_ID ITEM_NUMBER ITEM_DESCRIPTION MEMO_LINE_ID UOM_CODE QUANTITY UNIT_SELLING_PRICE UNIT_LIST_PRICE DISCOUNT_PERCENTAGE UNIT_SELLING_PCT_BASE_PRICE UNIT_LIST_PCT_BASE_PRICE BASE_PRICE LINE_AMOUNT BILL_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID BILL_TO_CUSTOMER_PARTY_ID BILL_TO_CUSTOMER_PARTY_NUM BILL_TO_CUSTOMER_PARTY_NAME BILL_TO_CUSTOMER_NUM SHIP_TO_CUSTOMER_NUM BILL_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME BILL_TO_CUST_SITE_NAME BILL_TO_CUSTOMER_SITE_ID SHIP_TO_CUSTOMER_SITE_ID SHIP_TO_CUST_SITE_NAME BILL_TO_COUNTRY SHIP_TO_COUNTRY BILL_TO_CUSTOMER_STATE BILL_TO_CUSTOMER_COUNTY BILL_TO_CUSTOMER_CITY BILL_TO_CUSTOMER_POSTAL_CODE BILL_TO_CUST_CLASSIFICATION MEMO_LINE_NAME PAYMENT_TERM_NAME ACCOUNTING_RULE_NAME INVENTORY_ORG_CODE SOURCE_INVENTORY_ORG_CODE SOURCE_MEMO_LINE_NAME SOURCE_ITEM_NUMBER SOURCE_UOM_CODE SOURCE_SALESREP_NAME SOURCE_PAYMENT_TERM_NAME SOURCE_ACCOUNTING_RULE_NAME SOURCE_BILL_TO_CUST_NUM SOURCE_BILL_TO_CUST_NAME SOURCE_BILL_TO_CUST_SITE_NUM SOURCE_BILL_TO_CUST_ADDRESS SOURCE_SHIP_TO_CUST_NUM SOURCE_SHIP_TO_CUST_NAME SOURCE_SHIP_TO_CUST_SITE_NUM SOURCE_SHIP_TO_CUST_ADDRESS DELIVERED_FLAG INVOICED_FLAG FULFILLED_FLAG CANCELLED_FLAG DELIVERY_STATUS DELIVERY_DATE SALESREP_ID SALESREP_NAME LINE_CREATION_DATE LINE_LAST_UPDATE_DATE COMMENTS 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 MEMO_LINE_SEQ_ID PAYMENT_AMOUNT QUANTITY_CANCELLED QUANTITY_SHIPPED QUANTITY_ORDERED QUANTITY_FULFILLED QUANTITY_INVOICED OPEN_FLAG CUST_PO_NUMBER PROJECT_ID TASK_ID PAYMENT_TERM_ID ACCOUNTING_RULE_ID RULE_START_DATE RULE_END_DATE ACTUAL_SHIPMENT_DATE ACTUAL_ARRIVAL_DATE FOB_POINT_CODE FRIEGHT_TERMS_CODE SCHEDULED_STATUS_CODE SOURCE_TYPE_CODE RETURN_REASON_CODE SHIPPING_INTERFACED_FLAG CREDIT_INVOICE_LINE_ID REFERENCE_CUSTOMER_TRX_LINE_ID SHIPPABLE_FLAG FULFILLMENT_DATE ACCOUNTING_RULE_DURATION ACTUAL_FULFILLMENT_DATE CONTINGENCY_ID REVREC_EVENT_CODE REVREC_EXPIRATION_DAYS ACCEPTED_QUANTITY ACCEPTED_BY REVREC_COMMENTS REVREC_REFERENCE_DOCUMENT REVREC_SIGNATURE REVREC_SIGNATURE_DATE REVREC_IMPLICIT_FLAG COST_AMOUNT GROSS_MARGIN_PERCENT SRC_ATTRIBUTE_CATEGORY SOURCE_ORG_ID REFERENCE_DOC_LINE_ID_INT_1 REFERENCE_DOC_LINE_ID_INT_2 REFERENCE_DOC_LINE_ID_INT_3 REFERENCE_DOC_LINE_ID_INT_4 REFERENCE_DOC_LINE_ID_INT_5 REFERENCE_DOC_LINE_ID_CHAR_1 REFERENCE_DOC_LINE_ID_CHAR_2 REFERENCE_DOC_LINE_ID_CHAR_3 REFERENCE_DOC_LINE_ID_CHAR_4 REFERENCE_DOC_LINE_ID_CHAR_5 OVERRIDE_AUTO_ACCOUNTING_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_INVENTORY_ORG_ID REVENUE_REVERSAL_METHOD VERSION_NUMBER VERSION_FLAG LINE_NUM DISCOUNT_AMOUNT LAST_PERIOD_TO_CREDIT LOAD_REQUEST_ID REFERENCE_DOCUMENT_TYPE_ID SOURCE_SYSTEM SP_FIRST_NAME SP_MIDDLE_NAME SP_LAST_NAME REFERENCE_SOURCE_SYSTEM

Query

SQL_Statement

SELECT DOCUMENT_LINE_ID, DOCUMENT_ID, APPLICATION_ID, DOCUMENT_TYPE_ID, DOC_LINE_ID_INT_1, DOC_LINE_ID_INT_2, DOC_LINE_ID_INT_3, DOC_LINE_ID_INT_4, DOC_LINE_ID_INT_5, DOC_LINE_ID_CHAR_1, DOC_LINE_ID_CHAR_2, DOC_LINE_ID_CHAR_3, DOC_LINE_ID_CHAR_4, DOC_LINE_ID_CHAR_5, 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, LINE_TYPE, LINE_NUMBER, INVENTORY_ORG_ID, ITEM_ID, ITEM_NUMBER, ITEM_DESCRIPTION, MEMO_LINE_ID, UOM_CODE, QUANTITY, UNIT_SELLING_PRICE, UNIT_LIST_PRICE, DISCOUNT_PERCENTAGE, UNIT_SELLING_PCT_BASE_PRICE, UNIT_LIST_PCT_BASE_PRICE, BASE_PRICE, LINE_AMOUNT, BILL_TO_CUSTOMER_ID, SHIP_TO_CUSTOMER_ID, BILL_TO_CUSTOMER_PARTY_ID, BILL_TO_CUSTOMER_PARTY_NUM, BILL_TO_CUSTOMER_PARTY_NAME, BILL_TO_CUSTOMER_NUM, SHIP_TO_CUSTOMER_NUM, BILL_TO_CUSTOMER_NAME, SHIP_TO_CUSTOMER_NAME, BILL_TO_CUST_SITE_NAME, BILL_TO_CUSTOMER_SITE_ID, SHIP_TO_CUSTOMER_SITE_ID, SHIP_TO_CUST_SITE_NAME, BILL_TO_COUNTRY, SHIP_TO_COUNTRY, BILL_TO_CUSTOMER_STATE, BILL_TO_CUSTOMER_COUNTY, BILL_TO_CUSTOMER_CITY, BILL_TO_CUSTOMER_POSTAL_CODE, BILL_TO_CUST_CLASSIFICATION, MEMO_LINE_NAME, PAYMENT_TERM_NAME, ACCOUNTING_RULE_NAME, INVENTORY_ORG_CODE, SOURCE_INVENTORY_ORG_CODE, SOURCE_MEMO_LINE_NAME, SOURCE_ITEM_NUMBER, SOURCE_UOM_CODE, SOURCE_SALESREP_NAME, SOURCE_PAYMENT_TERM_NAME, SOURCE_ACCOUNTING_RULE_NAME, SOURCE_BILL_TO_CUST_NUM, SOURCE_BILL_TO_CUST_NAME, SOURCE_BILL_TO_CUST_SITE_NUM, SOURCE_BILL_TO_CUST_ADDRESS, SOURCE_SHIP_TO_CUST_NUM, SOURCE_SHIP_TO_CUST_NAME, SOURCE_SHIP_TO_CUST_SITE_NUM, SOURCE_SHIP_TO_CUST_ADDRESS, DELIVERED_FLAG, INVOICED_FLAG, FULFILLED_FLAG, CANCELLED_FLAG, DELIVERY_STATUS, DELIVERY_DATE, SALESREP_ID, SALESREP_NAME, LINE_CREATION_DATE, LINE_LAST_UPDATE_DATE, COMMENTS, 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, MEMO_LINE_SEQ_ID, PAYMENT_AMOUNT, QUANTITY_CANCELLED, QUANTITY_SHIPPED, QUANTITY_ORDERED, QUANTITY_FULFILLED, QUANTITY_INVOICED, OPEN_FLAG, CUST_PO_NUMBER, PROJECT_ID, TASK_ID, PAYMENT_TERM_ID, ACCOUNTING_RULE_ID, RULE_START_DATE, RULE_END_DATE, ACTUAL_SHIPMENT_DATE, ACTUAL_ARRIVAL_DATE, FOB_POINT_CODE, FRIEGHT_TERMS_CODE, SCHEDULED_STATUS_CODE, SOURCE_TYPE_CODE, RETURN_REASON_CODE, SHIPPING_INTERFACED_FLAG, CREDIT_INVOICE_LINE_ID, REFERENCE_CUSTOMER_TRX_LINE_ID, SHIPPABLE_FLAG, FULFILLMENT_DATE, ACCOUNTING_RULE_DURATION, ACTUAL_FULFILLMENT_DATE, CONTINGENCY_ID, REVREC_EVENT_CODE, REVREC_EXPIRATION_DAYS, ACCEPTED_QUANTITY, ACCEPTED_BY, REVREC_COMMENTS, REVREC_REFERENCE_DOCUMENT, REVREC_SIGNATURE, REVREC_SIGNATURE_DATE, REVREC_IMPLICIT_FLAG, COST_AMOUNT, GROSS_MARGIN_PERCENT, SRC_ATTRIBUTE_CATEGORY, SOURCE_ORG_ID, REFERENCE_DOC_LINE_ID_INT_1, REFERENCE_DOC_LINE_ID_INT_2, REFERENCE_DOC_LINE_ID_INT_3, REFERENCE_DOC_LINE_ID_INT_4, REFERENCE_DOC_LINE_ID_INT_5, REFERENCE_DOC_LINE_ID_CHAR_1, REFERENCE_DOC_LINE_ID_CHAR_2, REFERENCE_DOC_LINE_ID_CHAR_3, REFERENCE_DOC_LINE_ID_CHAR_4, REFERENCE_DOC_LINE_ID_CHAR_5, OVERRIDE_AUTO_ACCOUNTING_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_INVENTORY_ORG_ID, REVENUE_REVERSAL_METHOD, VERSION_NUMBER, VERSION_FLAG, LINE_NUM, DISCOUNT_AMOUNT, LAST_PERIOD_TO_CREDIT, LOAD_REQUEST_ID, REFERENCE_DOCUMENT_TYPE_ID, SOURCE_SYSTEM, SP_FIRST_NAME, SP_MIDDLE_NAME, SP_LAST_NAME, REFERENCE_SOURCE_SYSTEM FROM VRM_SOURCE_DOC_LINES WHERE 1=2