VRM_BM_SOURCE_DOC_SUB_LINES_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name

DOCUMENT_SUB_LINE_ID DOCUMENT_LINE_ID DOCUMENT_ID APPLICATION_ID DOCUMENT_TYPE_ID DOC_SUB_LINE_TYPE DOC_SUB_LINE_LEVEL DOC_SUB_LINE_ID_INT_1 DOC_SUB_LINE_ID_INT_2 DOC_SUB_LINE_ID_INT_3 DOC_SUB_LINE_ID_INT_4 DOC_SUB_LINE_ID_INT_5 DOC_SUB_LINE_ID_CHAR_1 DOC_SUB_LINE_ID_CHAR_2 DOC_SUB_LINE_ID_CHAR_3 DOC_SUB_LINE_ID_CHAR_4 DOC_SUB_LINE_ID_CHAR_5 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 LINE_NUMBER ORG_ID LEDGER_ID SUB_LINE_CREATION_DATE SUB_LINE_LAST_UPDATE_DATE ACCOUNT_CLASS AMOUNT ACCTD_AMOUNT ACCOUNTING_DATE SLA_POSTED_FLAG SLA_POSTED_DATE SOURCE_ACCOUNT_CCID SOURCE_SALESREP_NAME SOURCE_CONTINGENCY_NAME EVENT_ID CODE_COMBINATION_ID SALESREP_ID SALESREP_NAME REVENUE_AMOUNT_SPLIT REVENUE_PERCENT_SPLIT CONTINGENCY_CODE CONTINGENCY_NAME CONTINGENCY_ID EXPIRATION_DATE EXPIRATION_DAYS EXPIRED_FLAG EXPIRATION_EVENT_DATE EXPIRED_BY COMMENTS ACCOUNT_CODE_SEGMENT1 ACCOUNT_CODE_SEGMENT2 ACCOUNT_CODE_SEGMENT3 ACCOUNT_CODE_SEGMENT4 ACCOUNT_CODE_SEGMENT5 ACCOUNT_CODE_SEGMENT6 ACCOUNT_CODE_SEGMENT7 ACCOUNT_CODE_SEGMENT8 ACCOUNT_CODE_SEGMENT9 ACCOUNT_CODE_SEGMENT10 ACCOUNT_CODE_SEGMENT11 ACCOUNT_CODE_SEGMENT12 ACCOUNT_CODE_SEGMENT13 ACCOUNT_CODE_SEGMENT14 ACCOUNT_CODE_SEGMENT15 ACCOUNT_CODE_SEGMENT16 ACCOUNT_CODE_SEGMENT17 ACCOUNT_CODE_SEGMENT18 ACCOUNT_CODE_SEGMENT19 ACCOUNT_CODE_SEGMENT20 ACCOUNT_CODE_SEGMENT21 ACCOUNT_CODE_SEGMENT22 ACCOUNT_CODE_SEGMENT23 ACCOUNT_CODE_SEGMENT24 ACCOUNT_CODE_SEGMENT25 ACCOUNT_CODE_SEGMENT26 ACCOUNT_CODE_SEGMENT27 ACCOUNT_CODE_SEGMENT28 ACCOUNT_CODE_SEGMENT29 ACCOUNT_CODE_SEGMENT30 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 SOURCE_ORG_ID REQUEST_ID 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_ACCOUNT_CODE LOAD_REQUEST_ID SOURCE_SYSTEM SP_FIRST_NAME SP_MIDDLE_NAME SP_LAST_NAME

Query

SQL_Statement

SELECT DOCUMENT_SUB_LINE_ID, DOCUMENT_LINE_ID, DOCUMENT_ID, APPLICATION_ID, DOCUMENT_TYPE_ID, DOC_SUB_LINE_TYPE, DOC_SUB_LINE_LEVEL, DOC_SUB_LINE_ID_INT_1, DOC_SUB_LINE_ID_INT_2, DOC_SUB_LINE_ID_INT_3, DOC_SUB_LINE_ID_INT_4, DOC_SUB_LINE_ID_INT_5, DOC_SUB_LINE_ID_CHAR_1, DOC_SUB_LINE_ID_CHAR_2, DOC_SUB_LINE_ID_CHAR_3, DOC_SUB_LINE_ID_CHAR_4, DOC_SUB_LINE_ID_CHAR_5, 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, LINE_NUMBER, ORG_ID, LEDGER_ID, SUB_LINE_CREATION_DATE, SUB_LINE_LAST_UPDATE_DATE, ACCOUNT_CLASS, AMOUNT, ACCTD_AMOUNT, ACCOUNTING_DATE, SLA_POSTED_FLAG, SLA_POSTED_DATE, SOURCE_ACCOUNT_CCID, SOURCE_SALESREP_NAME, SOURCE_CONTINGENCY_NAME, EVENT_ID, CODE_COMBINATION_ID, SALESREP_ID, SALESREP_NAME, REVENUE_AMOUNT_SPLIT, REVENUE_PERCENT_SPLIT, CONTINGENCY_CODE, CONTINGENCY_NAME, CONTINGENCY_ID, EXPIRATION_DATE, EXPIRATION_DAYS, EXPIRED_FLAG, EXPIRATION_EVENT_DATE, EXPIRED_BY, COMMENTS, ACCOUNT_CODE_SEGMENT1, ACCOUNT_CODE_SEGMENT2, ACCOUNT_CODE_SEGMENT3, ACCOUNT_CODE_SEGMENT4, ACCOUNT_CODE_SEGMENT5, ACCOUNT_CODE_SEGMENT6, ACCOUNT_CODE_SEGMENT7, ACCOUNT_CODE_SEGMENT8, ACCOUNT_CODE_SEGMENT9, ACCOUNT_CODE_SEGMENT10, ACCOUNT_CODE_SEGMENT11, ACCOUNT_CODE_SEGMENT12, ACCOUNT_CODE_SEGMENT13, ACCOUNT_CODE_SEGMENT14, ACCOUNT_CODE_SEGMENT15, ACCOUNT_CODE_SEGMENT16, ACCOUNT_CODE_SEGMENT17, ACCOUNT_CODE_SEGMENT18, ACCOUNT_CODE_SEGMENT19, ACCOUNT_CODE_SEGMENT20, ACCOUNT_CODE_SEGMENT21, ACCOUNT_CODE_SEGMENT22, ACCOUNT_CODE_SEGMENT23, ACCOUNT_CODE_SEGMENT24, ACCOUNT_CODE_SEGMENT25, ACCOUNT_CODE_SEGMENT26, ACCOUNT_CODE_SEGMENT27, ACCOUNT_CODE_SEGMENT28, ACCOUNT_CODE_SEGMENT29, ACCOUNT_CODE_SEGMENT30, 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, SOURCE_ORG_ID, REQUEST_ID, 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_ACCOUNT_CODE, LOAD_REQUEST_ID, SOURCE_SYSTEM, SP_FIRST_NAME, SP_MIDDLE_NAME, SP_LAST_NAME FROM VRM_SOURCE_DOC_SUB_LINES WHERE 1=2