[Home] [Help]
View: FII_AR_REVENUE_B_V1
View Text
SELECT LEDGER_ID
, COMPANY_COST_CENTER_ORG_ID
, FIN_CATEGORY_ID
, CHART_OF_ACCOUNTS_ID
, BILL_TO_PARTY_ID
, INVOICE_NUMBER
, INVOICE_DATE
, GL_DATE
, PRIM_AMOUNT_G
, POSTED_FLAG
, COMPANY_ID
, COST_CENTER_ID
FROM FII_AR_REVENUE_B
WHERE NVL(FIN_CAT_TYPE_CODE
, 'R') = 'R'
Columns
Name |
LEDGER_ID |
COMPANY_COST_CENTER_ORG_ID |
FIN_CATEGORY_ID |
CHART_OF_ACCOUNTS_ID |
BILL_TO_PARTY_ID |
INVOICE_NUMBER |
INVOICE_DATE |
GL_DATE |
ACTUAL_G |
POSTED_FLAG |
COMPANY_ID |
COST_CENTER_ID |