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_SCH_PAYMTS_FCV

Product:	FII - Financial Intelligence (Obsolete)
Description:	None. Internal Table.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SEQ_ID
, PINVOICE_ID
, INV_TYPE
, PAY_NUM
, CCID
, COMPLETELY_PAID_PAYMENT_COUNT
, CREATION_DATE
, DISC_AMT_LOST_B
, DISC_AMT_LOST_G
, DISC_AMT_LOST_T
, DISC_AMT_TAKEN_B
, DISC_AMT_TAKEN_G
, DISC_AMT_TAKEN_T
, DISC_DATE_FK
, DUE_DATE
, DUE_DATE_FK
, EMPLOYEE_FK
, INV_EXCHANGE_DATE
, INV_EXCHANGE_RATE
, INV_EXCHANGE_RATE_TYPE
, PAYMENT_EXCHANGE_RATE
, PAYMENT_EXCHANGE_DATE
, PAYMENT_EXCHANGE_RATE_TYPE
, FIRST_DISC_AVAILABLE_B
, FIRST_DISC_AVAILABLE_G
, FIRST_DISC_AVAILABLE_T
, FIRST_DISC_DATE
, GEOGRAPHY_FK
, HOLD_FLAG
, INSTANCE
, INSTANCE_FK
, INV_AMT_HAVING_DISC_B
, INV_AMT_HAVING_DISC_G
, INV_AMT_HAVING_DISC_T
, INV_AMT_NOT_HAVING_DISC_B
, INV_AMT_NOT_HAVING_DISC_G
, INV_AMT_NOT_HAVING_DISC_T
, INV_CURRENCY_FK
, PAYMENT_CURRENCY_FK
, INV_DATE_FK
, INV_FK
, INV_SOURCE_FK
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE1
, LAST_UPDATE_DATE2
, ORG_FK
, PARTIALLY_PAID_PAYMENT_COUNT
, PAYMENT_AMT_B
, PAYMENT_AMT_G
, PAYMENT_AMT_T
, PAYMENT_METHOD
, PAYMENT_PRIORITY
, PAYMENT_STATUS_FLAG
, PAYMENT_TERM_FK
, POTENTIAL_DISC_AMT_B
, POTENTIAL_DISC_AMT_G
, POTENTIAL_DISC_AMT_T
, REMAINING_DISC_AMT_AT_RISK_B
, REMAINING_DISC_AMT_AT_RISK_G
, REMAINING_DISC_AMT_AT_RISK_T
, REMAINING_INV_AMT_B
, REMAINING_INV_AMT_G
, REMAINING_INV_AMT_T
, REMAINING_INV_AMT_AT_RISK_B
, REMAINING_INV_AMT_AT_RISK_G
, REMAINING_INV_AMT_AT_RISK_T
, SCH_PAYMENT_PK
, SECOND_DISC_AVAILABLE_B
, SECOND_DISC_AVAILABLE_G
, SECOND_DISC_AVAILABLE_T
, SECOND_DISC_DATE
, SIC_CODE_FK
, DUNS_FK
, SOB_FK
, SUPPLIER_FK
, THIRD_DISC_AVAILABLE_B
, THIRD_DISC_AVAILABLE_G
, THIRD_DISC_AVAILABLE_T
, THIRD_DISC_DATE
, UNPAID_PAYMENT_COUNT
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, GLOBAL_CURRENCY_RATE
, INVOICE_NUM
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 1
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 1
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT1_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 26
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 26
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT2_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 51
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 51
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT3_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 76
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 76
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT4_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 101
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 101
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT5_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 126
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 126
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT6_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 151
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 151
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT7_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 176
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 176
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT8_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 201
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 201
, 25))||SUBSTR(GL_SEG
, 251))) GL_ACCT9_FK
, DECODE(GL_SEG
, 'NA_EDW'
, 'NA_EDW'
, DECODE(RTRIM(SUBSTR(GL_SEG
, 226
, 25))
, 'NA_EDW'
, 'NA_EDW'
, RTRIM(SUBSTR(GL_SEG
, 226
, 25))||SUBSTR(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
, FROM_CURRENCY
, GL_DATE
, INVOICE_DATE
FROM ( SELECT SEQ_ID
, PINVOICE_ID
, INV_TYPE
, PAY_NUM
, CCID
, COMPLETELY_PAID_PAYMENT_COUNT
, CREATION_DATE
, DISC_AMT_LOST_B
, DISC_AMT_LOST_G
, DISC_AMT_LOST_T
, DISC_AMT_TAKEN_B
, DISC_AMT_TAKEN_G
, DISC_AMT_TAKEN_T
, DISC_DATE_FK
, DUE_DATE
, DUE_DATE_FK
, EMPLOYEE_FK
, INV_EXCHANGE_DATE
, INV_EXCHANGE_RATE
, INV_EXCHANGE_RATE_TYPE
, PAYMENT_EXCHANGE_RATE
, PAYMENT_EXCHANGE_DATE
, PAYMENT_EXCHANGE_RATE_TYPE
, FIRST_DISC_AVAILABLE_B
, FIRST_DISC_AVAILABLE_G
, FIRST_DISC_AVAILABLE_T
, FIRST_DISC_DATE
, GEOGRAPHY_FK
, HOLD_FLAG
, INSTANCE
, INSTANCE_FK
, INV_AMT_HAVING_DISC_B
, INV_AMT_HAVING_DISC_G
, INV_AMT_HAVING_DISC_T
, INV_AMT_NOT_HAVING_DISC_B
, INV_AMT_NOT_HAVING_DISC_G
, INV_AMT_NOT_HAVING_DISC_T
, INV_CURRENCY_FK
, PAYMENT_CURRENCY_FK
, INV_DATE_FK
, INV_FK
, INV_SOURCE_FK
, LAST_UPDATE_DATE
, LAST_UPDATE_DATE1
, LAST_UPDATE_DATE2
, ORG_FK
, PARTIALLY_PAID_PAYMENT_COUNT
, PAYMENT_AMT_B
, PAYMENT_AMT_G
, PAYMENT_AMT_T
, PAYMENT_METHOD
, PAYMENT_PRIORITY
, PAYMENT_STATUS_FLAG
, PAYMENT_TERM_FK
, POTENTIAL_DISC_AMT_B
, POTENTIAL_DISC_AMT_G
, POTENTIAL_DISC_AMT_T
, REMAINING_DISC_AMT_AT_RISK_B
, REMAINING_DISC_AMT_AT_RISK_G
, REMAINING_DISC_AMT_AT_RISK_T
, REMAINING_INV_AMT_B
, REMAINING_INV_AMT_G
, REMAINING_INV_AMT_T
, REMAINING_INV_AMT_AT_RISK_B
, REMAINING_INV_AMT_AT_RISK_G
, REMAINING_INV_AMT_AT_RISK_T
, SCH_PAYMENT_PK
, SECOND_DISC_AVAILABLE_B
, SECOND_DISC_AVAILABLE_G
, SECOND_DISC_AVAILABLE_T
, SECOND_DISC_DATE
, SIC_CODE_FK
, DUNS_FK
, SOB_FK
, SUPPLIER_FK
, THIRD_DISC_AVAILABLE_B
, THIRD_DISC_AVAILABLE_G
, THIRD_DISC_AVAILABLE_T
, THIRD_DISC_DATE
, UNPAID_PAYMENT_COUNT
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
, GLOBAL_CURRENCY_RATE
, INVOICE_NUM
, FROM_CURRENCY
, GL_DATE
, INVOICE_DATE
, FII_FLEX_MAPPING.GET_VALUE( CCID
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID) GL_SEG
FROM FIIBV_AP_SCH_PAYMTS_FCV)

Columns

Name
SEQ_ID
PINVOICE_ID
INV_TYPE
PAY_NUM
CCID
COMPLETELY_PAID_PAYMENT_COUNT
CREATION_DATE
DISC_AMT_LOST_B
DISC_AMT_LOST_G
DISC_AMT_LOST_T
DISC_AMT_TAKEN_B
DISC_AMT_TAKEN_G
DISC_AMT_TAKEN_T
DISC_DATE_FK
DUE_DATE
DUE_DATE_FK
EMPLOYEE_FK
INV_EXCHANGE_DATE
INV_EXCHANGE_RATE
INV_EXCHANGE_RATE_TYPE
PAYMENT_EXCHANGE_RATE
PAYMENT_EXCHANGE_DATE
PAYMENT_EXCHANGE_RATE_TYPE
FIRST_DISC_AVAILABLE_B
FIRST_DISC_AVAILABLE_G
FIRST_DISC_AVAILABLE_T
FIRST_DISC_DATE
GEOGRAPHY_FK
HOLD_FLAG
INSTANCE
INSTANCE_FK
INV_AMT_HAVING_DISC_B
INV_AMT_HAVING_DISC_G
INV_AMT_HAVING_DISC_T
INV_AMT_NOT_HAVING_DISC_B
INV_AMT_NOT_HAVING_DISC_G
INV_AMT_NOT_HAVING_DISC_T
INV_CURRENCY_FK
PAYMENT_CURRENCY_FK
INV_DATE_FK
INV_FK
INV_SOURCE_FK
LAST_UPDATE_DATE
LAST_UPDATE_DATE1
LAST_UPDATE_DATE2
ORG_FK
PARTIALLY_PAID_PAYMENT_COUNT
PAYMENT_AMT_B
PAYMENT_AMT_G
PAYMENT_AMT_T
PAYMENT_METHOD
PAYMENT_PRIORITY
PAYMENT_STATUS_FLAG
PAYMENT_TERM_FK
POTENTIAL_DISC_AMT_B
POTENTIAL_DISC_AMT_G
POTENTIAL_DISC_AMT_T
REMAINING_DISC_AMT_AT_RISK_B
REMAINING_DISC_AMT_AT_RISK_G
REMAINING_DISC_AMT_AT_RISK_T
REMAINING_INV_AMT_B
REMAINING_INV_AMT_G
REMAINING_INV_AMT_T
REMAINING_INV_AMT_AT_RISK_B
REMAINING_INV_AMT_AT_RISK_G
REMAINING_INV_AMT_AT_RISK_T
SCH_PAYMENT_PK
SECOND_DISC_AVAILABLE_B
SECOND_DISC_AVAILABLE_G
SECOND_DISC_AVAILABLE_T
SECOND_DISC_DATE
SIC_CODE_FK
DUNS_FK
SOB_FK
SUPPLIER_FK
THIRD_DISC_AVAILABLE_B
THIRD_DISC_AVAILABLE_G
THIRD_DISC_AVAILABLE_T
THIRD_DISC_DATE
UNPAID_PAYMENT_COUNT
SET_OF_BOOKS_ID
CHART_OF_ACCOUNTS_ID
GLOBAL_CURRENCY_RATE
INVOICE_NUM
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
FROM_CURRENCY
GL_DATE
INVOICE_DATE