[Home] [Help]
View: FII_AR_TRX_DIST_MGR1_F
| Product: | FII - Financial Intelligence (Obsolete) |
|---|
| Description: | Internal view used for EDW data extraction. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT F.ACCOUNT_TYPE
, F.ACCOUNT_CLASS
, F.AMT_B
, F.AMT_G
, F.AMT_T
, F.TRANSACTION_CLASS
, F.FUNCTIONAL_CURRENCY_FK_KEY
, F.COMPANY_CC_ORG_FK_KEY
, F.GL_DATE_FK_KEY
, F.SET_OF_BOOKS_FK_KEY
, F.TRANSACTION_CURRENCY_FK_KEY
, F.INVOICE_PK_KEY
, O.ORGA_PERSON_MANAGER_FK_KEY
FROM FII_AR_TRX_DIST_F F
, EDW_ORGANIZATION_M O
WHERE F.ORGANIZATION_FK_KEY = O.ORGA_ORGANIZATION_PK_KEY
Columns
| Name |
| ACCOUNT_TYPE |
| ACCOUNT_CLASS |
| AMT_B |
| AMT_G |
| AMT_T |
| TRANSACTION_CLASS |
| FUNCTIONAL_CURRENCY_FK_KEY |
| COMPANY_CC_ORG_FK_KEY |
| GL_DATE_FK_KEY |
| SET_OF_BOOKS_FK_KEY |
| TRANSACTION_CURRENCY_FK_KEY |
| INVOICE_PK_KEY |
| MANAGER_ID |