eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: FIIBV_AR_ARTT_TYPE_LCV

Product:	FII - Financial Intelligence (Obsolete)
Description:	FIIBV_AR_ARTT_TYPE_LCV is the base view for AR Transaction type level of AR Transaction Type dimension
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CTT.CUST_TRX_TYPE_ID||'-'||ORG_ID||'-'||SUBSTR(EDW_INSTANCE.GET_CODE
, 1
, 40)
, CTT.TYPE
, CTT.NAME
, CTT.NAME
, CTT.NAME
, CTT.ALLOW_FREIGHT_FLAG
, CTT.ALLOW_OVERAPPLICATION_FLAG
, CTT.CREATION_SIGN
, CTT.DEFAULT_STATUS
, CTT.DESCRIPTION
, CTT.STATUS
, CTT.TAX_CALCULATION_FLAG
, CTT.CREDIT_MEMO_TYPE_ID
, CTT.DEFAULT_TERM
, CTT.END_DATE
, CTT.GL_ID_CLEARING
, CTT.GL_ID_FREIGHT
, CTT.GL_ID_REC
, CTT.GL_ID_REV
, CTT.GL_ID_TAX
, CTT.GL_ID_UNBILLED
, CTT.GL_ID_UNEARNED
, CTT.ORG_ID
, CTT.RULE_SET_ID
, CTT.SET_OF_BOOKS_ID
, CTT.START_DATE
, CTT.SUBSEQUENT_TRX_TYPE_ID
, SUBSTR(EDW_INSTANCE.GET_CODE
, 1
, 40)
, CTT.LAST_UPDATE_DATE
, '_DF:AR:RA_CUST_TRX_TYPES:CTT'
, '_DF:JG:JG_RA_CUST_TRX_TYPES:CTT'
FROM RA_CUST_TRX_TYPES_ALL CTT

Columns

Name
TRX_TYPE_PK
TRX_CODE_FK
TRX_TYPE_DP
NAME
TRANSACTION_TYPE
ALLOW_FRT_FLAG
ALLOW_OVAPP_FLAG
CREATION_SIGN
DEFAULT_STATUS
DESCRIPTION
STATUS
TAX_CALC_FLAG
CM_TYPE_ID
DEFAULT_TERM
END_DATE
GL_ID_CLEARING
GL_ID_FREIGHT
GL_ID_REC
GL_ID_REV
GL_ID_TAX
GL_ID_UNBILLED
GL_ID_UNEARNED
ORG_ID
RULE_SET_ID
SET_OF_BOOKS_ID
START_DATE
SUB_TRX_TYPE_ID
INSTANCE
LAST_UPDATE_DATE
"_DF:RAT:_EDW"
"_DF:JGT:_EDW"