1. Tables and Views for Financials
  2. VRM_REVENUE_DOCUMENTS_V

VRM_REVENUE_DOCUMENTS_V

Details

  • Schema: FUSION

  • Object owner: VRM

  • Object type: VIEW

Columns

Name

ACCOUNTING_DATE

REV_DOC_ATTRIBUTE_CATEGORY

REV_DOC_ATTRIBUTE1

REV_DOC_ATTRIBUTE2

REV_DOC_ATTRIBUTE3

REV_DOC_ATTRIBUTE4

REV_DOC_ATTRIBUTE5

REV_DOC_ATTRIBUTE6

REV_DOC_ATTRIBUTE7

REV_DOC_ATTRIBUTE8

REV_DOC_ATTRIBUTE9

REV_DOC_ATTRIBUTE10

REV_DOC_ATTRIBUTE11

REV_DOC_ATTRIBUTE12

REV_DOC_ATTRIBUTE13

REV_DOC_ATTRIBUTE14

REV_DOC_ATTRIBUTE15

BILL_TO_CUSTOMER_ID

BILL_TO_CUSTOMER_SITE_ID

COMPLETE_FLAG

CURRENCY_CODE

DOCUMENT_DATE

DOCUMENT_ID

DOCUMENT_NUMBER

DOCUMENT_RULE_ID

DOCUMENT_TYPE

DOCUMENT_TYPE_ID

DOCUMENT_TYPE_SEQ_ID

EXCHANGE_RATE

EXCHANGE_RATE_DATE

EXCHANGE_RATE_TYPE

LEGAL_ENTITY_ID

OBJECT_VERSION_NUMBER

ORG_ID

ORIG_REVENUE_DOCUMENT_NUMBER

PAYMENT_AMOUNT

PAYMENT_TERM_ID

PREV_REVENUE_DOCUMENT_ID

REQUEST_ID

REVENUE_DOCUMENT_ID

REVENUE_TOTAL_AMOUNT

REVENUE_TOTAL_CARVEOUT_AMOUNT

SET_OF_BOOKS_ID

SHIP_TO_CUSTOMER_ID

SHIP_TO_CUSTOMER_SITE_ID

SOURCE

SOURCE_DOCUMENT_DATE

SOURCE_DOCUMENT_NUMBER

STATUS

TOTAL_SELLING_AMOUNT

TRX_CLASS

LEGAL_ENTITY_NAME

BUSINESS_UNIT_NAME

EVENT_ID

LINE_NUMBER

Query

SQL_Statement

SELECT rda.ACCOUNTING_DATE,

rda.ATTRIBUTE_CATEGORY REV_DOC_ATTRIBUTE_CATEGORY,

rda.ATTRIBUTE1 REV_DOC_ATTRIBUTE1,

rda.ATTRIBUTE2 REV_DOC_ATTRIBUTE2,

rda.ATTRIBUTE3 REV_DOC_ATTRIBUTE3,

rda.ATTRIBUTE4 REV_DOC_ATTRIBUTE4,

rda.ATTRIBUTE5 REV_DOC_ATTRIBUTE5,

rda.ATTRIBUTE6 REV_DOC_ATTRIBUTE6,

rda.ATTRIBUTE7 REV_DOC_ATTRIBUTE7,

rda.ATTRIBUTE8 REV_DOC_ATTRIBUTE8,

rda.ATTRIBUTE9 REV_DOC_ATTRIBUTE9,

rda.ATTRIBUTE10 REV_DOC_ATTRIBUTE10,

rda.ATTRIBUTE11 REV_DOC_ATTRIBUTE11,

rda.ATTRIBUTE12 REV_DOC_ATTRIBUTE12,

rda.ATTRIBUTE13 REV_DOC_ATTRIBUTE13,

rda.ATTRIBUTE14 REV_DOC_ATTRIBUTE14,

rda.ATTRIBUTE15 REV_DOC_ATTRIBUTE15,

rda.BILL_TO_CUSTOMER_ID,

rda.BILL_TO_CUSTOMER_SITE_ID,

rda.COMPLETE_FLAG,

rda.CURRENCY_CODE,

rda.DOCUMENT_DATE,

rda.DOCUMENT_ID,

rda.DOCUMENT_NUMBER,

rda.DOCUMENT_RULE_ID,

lookup.MEANING AS DOCUMENT_TYPE,

rda.DOCUMENT_TYPE_ID,

rda.DOCUMENT_TYPE_SEQ_ID,

rda.EXCHANGE_RATE,

rda.EXCHANGE_RATE_DATE,

rda.EXCHANGE_RATE_TYPE,

rda.LEGAL_ENTITY_ID,

rda.OBJECT_VERSION_NUMBER,

rda.ORG_ID,

rda.ORIG_REVENUE_DOCUMENT_NUMBER,

rda.PAYMENT_AMOUNT,

rda.PAYMENT_TERM_ID,

rda.PREV_REVENUE_DOCUMENT_ID,

rda.REQUEST_ID,

rda.REVENUE_DOCUMENT_ID,

rda.REVENUE_TOTAL_AMOUNT,

rda.REVENUE_TOTAL_CARVEOUT_AMOUNT,

rda.SET_OF_BOOKS_ID,

rda.SHIP_TO_CUSTOMER_ID,

rda.SHIP_TO_CUSTOMER_SITE_ID,

rda.SOURCE,

rda.SOURCE_DOCUMENT_DATE,

rda.SOURCE_DOCUMENT_NUMBER,

rda.STATUS,

rda.TOTAL_SELLING_AMOUNT,

rda.TRX_CLASS,

vsd.LEGAL_ENTITY_NAME,

funbu.BU_NAME BUSINESS_UNIT_NAME,

l.EVENT_ID,

l.LINE_NUMBER

FROM VRM_REVENUE_DOCUMENTS_ALL rda,

VRM_SOURCE_DOCUMENTS vsd,

fun_all_business_units_v funbu,

vrm_xla_lines_extract_gt l,

VRM_LOOKUPS lookup

WHERE rda.REVENUE_DOCUMENT_ID = l.REVENUE_DOCUMENT_ID

and rda.DOCUMENT_ID = vsd.DOCUMENT_ID

and l.LEVEL_FLAG = 'H'

and rda.ORG_ID = funbu.bu_id

AND rda.document_type = lookup.lookup_code

AND lookup.lookup_type='VRM_REV_DOC_TYPE'