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: FII_AP_INV_PAYMTS_FCV

Product:	FII - Financial Intelligence (Obsolete)
Description:	Internal view used for warehouse data extraction.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SEQ_ID
, ACCOUNTING_DATE
, ACCRUAL_POSTED_FLAG
, ASSETS_ADDITION_FLAG
, BANK_ACCOUNT_ID
, BASE_CURRENCY_CODE
, CASH_JE_BATCH_ID
, CASH_POSTED_FLAG
, CCID
, CHECK_DATE
, CREATION_DATE
, DISC_AMT_LOST_B
, DISC_AMT_LOST_G
, DISC_AMT_LOST_T
, EARLY_DISC_PAYMENT_AMT_B
, EARLY_DISC_PAYMENT_AMT_G
, EARLY_DISC_PAYMENT_AMT_T
, EARLY_DISC_PAYMENT_DAYS
, EARLY_DISC_PAYMENT_COUNT
, EARLY_NET_PAYMENT_AMT_B
, EARLY_NET_PAYMENT_AMT_G
, EARLY_NET_PAYMENT_AMT_T
, EARLY_NET_PAYMENT_COUNT
, EARLY_NET_PAYMENT_DAYS
, EMPLOYEE_FK
, FUTURE_PAY_POSTED_FLAG
, GEOGRAPHY_FK
, INSTANCE
, INSTANCE_FK
, INVOICE_DATE
, INV_CURRENCY_CODE
, INV_EXCHANGE_DATE
, INV_EXCHANGE_RATE
, INV_EXCHANGE_RATE_TYPE
, INV_FK
, INV_NUM
, INV_PAYMENT_PK
, INV_PAYMENT_STATUS_FLAG
, INV_PAYMENT_TYPE
, INV_SOURCE
, INV_SOURCE_FK
, INV_TYPE
, JE_BATCH_ID
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE1
, LAST_UPDATE_DATE2
, LATE_DISC_DAYS
, LATE_DISC_PAYMENT_AMT_B
, LATE_DISC_PAYMENT_AMT_G
, LATE_DISC_PAYMENT_AMT_T
, LATE_DISC_PAYMENT_COUNT
, LATE_NET_PAYMENT_AMT_B
, LATE_NET_PAYMENT_AMT_G
, LATE_NET_PAYMENT_AMT_T
, LATE_NET_PAYMENT_COUNT
, LATE_NET_PAYMENT_DAYS
, ORG_FK
, PAYMENT_AMT_B
, PAYMENT_AMT_G
, PAYMENT_AMT_T
, PAYMENT_COUNT
, PAYMENT_CURRENCY_CODE
, PAYMENT_CURRENCY_FK
, PAYMENT_DATE_FK
, DISC_AMT_TAKEN_B
, DISC_AMT_TAKEN_G
, DISC_AMT_TAKEN_T
, PAYMENT_EXCHANGE_DATE
, PAYMENT_EXCHANGE_RATE
, PAYMENT_EXCHANGE_RATE_TYPE
, PAYMENT_FK
, PAYMENT_TERM_FK
, POSTED_FLAG
, SIC_CODE_FK
, DUNS_FK
, SOB_FK
, SUPPLIER_FK
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, GLOBAL_CURRENCY_RATE
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 1
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 1
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT1_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 26
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 26
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT2_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 51
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 51
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT3_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 76
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 76
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT4_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 101
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 101
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT5_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 126
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 126
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT6_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 151
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 151
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT7_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 176
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 176
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT8_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 201
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 201
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT9_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTRB(GL_SEG
, 226
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTRB(GL_SEG
, 226
, 25))||SUBSTRB(GL_SEG
, 251))) GL_ACCT10_FK
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, CHECK_AMT_B
, CHECK_AMT_T
, CHECK_AMT_G
, CHECK_NUMBER
FROM ( SELECT SEQ_ID
, ACCOUNTING_DATE
, ACCRUAL_POSTED_FLAG
, ASSETS_ADDITION_FLAG
, BANK_ACCOUNT_ID
, BASE_CURRENCY_CODE
, CASH_JE_BATCH_ID
, CASH_POSTED_FLAG
, CCID
, CHECK_DATE
, CREATION_DATE
, DISC_AMT_LOST_B
, DISC_AMT_LOST_G
, DISC_AMT_LOST_T
, EARLY_DISC_PAYMENT_AMT_B
, EARLY_DISC_PAYMENT_AMT_G
, EARLY_DISC_PAYMENT_AMT_T
, EARLY_DISC_PAYMENT_DAYS
, EARLY_DISC_PAYMENT_COUNT
, EARLY_NET_PAYMENT_AMT_B
, EARLY_NET_PAYMENT_AMT_G
, EARLY_NET_PAYMENT_AMT_T
, EARLY_NET_PAYMENT_COUNT
, EARLY_NET_PAYMENT_DAYS
, EMPLOYEE_FK
, FUTURE_PAY_POSTED_FLAG
, GEOGRAPHY_FK
, INSTANCE
, INSTANCE_FK
, INVOICE_DATE
, INV_CURRENCY_CODE
, INV_EXCHANGE_DATE
, INV_EXCHANGE_RATE
, INV_EXCHANGE_RATE_TYPE
, INV_FK
, INV_NUM
, INV_PAYMENT_PK
, INV_PAYMENT_STATUS_FLAG
, INV_PAYMENT_TYPE
, INV_SOURCE
, INV_SOURCE_FK
, INV_TYPE
, JE_BATCH_ID
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE1
, LAST_UPDATE_DATE2
, LATE_DISC_DAYS
, LATE_DISC_PAYMENT_AMT_B
, LATE_DISC_PAYMENT_AMT_G
, LATE_DISC_PAYMENT_AMT_T
, LATE_DISC_PAYMENT_COUNT
, LATE_NET_PAYMENT_AMT_B
, LATE_NET_PAYMENT_AMT_G
, LATE_NET_PAYMENT_AMT_T
, LATE_NET_PAYMENT_COUNT
, LATE_NET_PAYMENT_DAYS
, ORG_FK
, PAYMENT_AMT_B
, PAYMENT_AMT_G
, PAYMENT_AMT_T
, PAYMENT_COUNT
, PAYMENT_CURRENCY_CODE
, PAYMENT_CURRENCY_FK
, PAYMENT_DATE_FK
, DISC_AMT_TAKEN_B
, DISC_AMT_TAKEN_G
, DISC_AMT_TAKEN_T
, PAYMENT_EXCHANGE_DATE
, PAYMENT_EXCHANGE_RATE
, PAYMENT_EXCHANGE_RATE_TYPE
, PAYMENT_FK
, PAYMENT_TERM_FK
, POSTED_FLAG
, SIC_CODE_FK
, DUNS_FK
, SOB_FK
, SUPPLIER_FK
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, GLOBAL_CURRENCY_RATE
, FII_FLEX_MAPPING.GET_VALUE( CCID
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID) GL_SEG
, CHECK_AMT_B
, CHECK_AMT_T
, CHECK_AMT_G
, CHECK_NUMBER
FROM FIIBV_AP_INV_PAYMTS_FCV)

Columns

Name
SEQ_ID
ACCOUNTING_DATE
ACCRUAL_POSTED_FLAG
ASSETS_ADDITION_FLAG
BANK_ACCOUNT_ID
BASE_CURRENCY_CODE
CASH_JE_BATCH_ID
CASH_POSTED_FLAG
CCID
CHECK_DATE
CREATION_DATE
DISC_AMT_LOST_B
DISC_AMT_LOST_G
DISC_AMT_LOST_T
EARLY_DISC_PAYMENT_AMT_B
EARLY_DISC_PAYMENT_AMT_G
EARLY_DISC_PAYMENT_AMT_T
EARLY_DISC_PAYMENT_DAYS
EARLY_DISC_PAYMENT_COUNT
EARLY_NET_PAYMENT_AMT_B
EARLY_NET_PAYMENT_AMT_G
EARLY_NET_PAYMENT_AMT_T
EARLY_NET_PAYMENT_COUNT
EARLY_NET_PAYMENT_DAYS
EMPLOYEE_FK
FUTURE_PAY_POSTED_FLAG
GEOGRAPHY_FK
INSTANCE
INSTANCE_FK
INVOICE_DATE
INV_CURRENCY_CODE
INV_EXCHANGE_DATE
INV_EXCHANGE_RATE
INV_EXCHANGE_RATE_TYPE
INV_FK
INV_NUM
INV_PAYMENT_PK
INV_PAYMENT_STATUS_FLAG
INV_PAYMENT_TYPE
INV_SOURCE
INV_SOURCE_FK
INV_TYPE
JE_BATCH_ID
LAST_UPDATE_DATE
LAST_UPDATE_DATE1
LAST_UPDATE_DATE2
LATE_DISC_DAYS
LATE_DISC_PAYMENT_AMT_B
LATE_DISC_PAYMENT_AMT_G
LATE_DISC_PAYMENT_AMT_T
LATE_DISC_PAYMENT_COUNT
LATE_NET_PAYMENT_AMT_B
LATE_NET_PAYMENT_AMT_G
LATE_NET_PAYMENT_AMT_T
LATE_NET_PAYMENT_COUNT
LATE_NET_PAYMENT_DAYS
ORG_FK
PAYMENT_AMT_B
PAYMENT_AMT_G
PAYMENT_AMT_T
PAYMENT_COUNT
PAYMENT_CURRENCY_CODE
PAYMENT_CURRENCY_FK
PAYMENT_DATE_FK
DISC_AMT_TAKEN_B
DISC_AMT_TAKEN_G
DISC_AMT_TAKEN_T
PAYMENT_EXCHANGE_DATE
PAYMENT_EXCHANGE_RATE
PAYMENT_EXCHANGE_RATE_TYPE
PAYMENT_FK
PAYMENT_TERM_FK
POSTED_FLAG
SIC_CODE_FK
DUNS_FK
SOB_FK
SUPPLIER_FK
SET_OF_BOOKS_ID
CHART_OF_ACCOUNTS_ID
GLOBAL_CURRENCY_RATE
GL_ACCT1_FK
GL_ACCT2_FK
GL_ACCT3_FK
GL_ACCT4_FK
GL_ACCT5_FK
GL_ACCT6_FK
GL_ACCT7_FK
GL_ACCT8_FK
GL_ACCT9_FK
GL_ACCT10_FK
USER_MEASURE1
USER_MEASURE2
USER_MEASURE3
USER_MEASURE4
USER_MEASURE5
USER_ATTRIBUTE1
USER_ATTRIBUTE2
USER_ATTRIBUTE3
USER_ATTRIBUTE4
USER_ATTRIBUTE5
USER_ATTRIBUTE6
USER_ATTRIBUTE7
USER_ATTRIBUTE8
USER_ATTRIBUTE9
USER_ATTRIBUTE10
USER_FK1
USER_FK2
USER_FK3
USER_FK4
USER_FK5
CHECK_AMT_B
CHECK_AMT_T
CHECK_AMT_G
CHECK_NUMBER