DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.FIIBV_AP_SCH_PAYMTS_FCV

Object Details
Object Name: FIIBV_AP_SCH_PAYMTS_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFII.FIIBV_AP_SCH_PAYMTS_FCV
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER (15)
This column is for internal use only
INVOICE_NUM VARCHAR2 (50) Yes Invoice number
INV_TYPE VARCHAR2 (25)
PINVOICE_ID NUMBER (15) Yes Invoice Identifier
PAY_NUM NUMBER (15) Yes Payment Number
CCID NUMBER (15)
Invoice Accounting Flexfield identifier for accounts payable liability account
COMPLETELY_PAID_PAYMENT_COUNT NUMBER

Set to 1 if this schedule payment has been completely paid. 0 otherwise.
CREATION_DATE DATE

Standard Who column
DISC_AMT_LOST_B NUMBER

Discount amount lost in functional currency.
DISC_AMT_LOST_G NUMBER

Discount amount lost in global currency.
DISC_AMT_LOST_T NUMBER

Discount amount lost in transaction currency.
DISC_AMT_TAKEN_B NUMBER

Discount amount taken in global currency.
DISC_AMT_TAKEN_G NUMBER

Discount amount taken in global currency.
DISC_AMT_TAKEN_T NUMBER

Discount amount taken in transaction currency.
DISC_DATE_FK VARCHAR2 (76)
Foreign key to the discount date dimension
DUE_DATE DATE

Scheduled payment due date
DUE_DATE_FK VARCHAR2 (76)
Foreign key to the due date dimension
EMPLOYEE_FK VARCHAR2 (85)
Foreign key to the employee dimension
INV_EXCHANGE_DATE DATE

The date the exchange rate is effective.
INV_EXCHANGE_RATE NUMBER

Exchange rate between invoice currency and functional currency.
INV_EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type for foreign currency invoices.
PAYMENT_EXCHANGE_RATE NUMBER
Yes Exchange rate between invoice currency and payment currency.
PAYMENT_EXCHANGE_DATE DATE

Rate date of the payment exchange rate
PAYMENT_EXCHANGE_RATE_TYPE VARCHAR2 (30)
Rate type of the payment exchange rate
FIRST_DISC_AVAILABLE_B NUMBER

Discount amount in functional currency that is available at the first discount date.
FIRST_DISC_AVAILABLE_G NUMBER

Discount amount in global currency that is available at the first discount date.
FIRST_DISC_AVAILABLE_T NUMBER

Discount amount in transaction currency that is available at the first discount date.
FIRST_DISC_DATE DATE

The date the first discount is available.
GEOGRAPHY_FK VARCHAR2 (126)
Foreign key to the geography dimension
HOLD_FLAG VARCHAR2 (1)
Flag that indicates if the scheduled payment is on hold Y or N
INSTANCE VARCHAR2 (30)
Instance identifier
INSTANCE_FK VARCHAR2 (30)
Foreign key to the instance dimension
INV_AMT_HAVING_DISC_B NUMBER

The payment amount in functional currency of this scheduled payment if it is eligible for discount at any point in time. 0 otherwise. Assumption: the sum of all the payment amounts for one particular invoice equals to the invoice amount.
INV_AMT_HAVING_DISC_G NUMBER

The payment amount in global currency of this scheduled payment if it is eligible for discount at any point in time. 0 otherwise. Assumption: the sum of all the payment amounts for one particular invoice equals to the invoice amount.
INV_AMT_HAVING_DISC_T NUMBER

The payment amount in transaction currency of this scheduled payment if it is eligible for discount at any point in time. 0 otherwise. Assumption: the sum of all the payment amounts for one particular invoice equals to the invoice amount.
INV_AMT_NOT_HAVING_DISC_B NUMBER

The payment amount in functional currency of this scheduled payment if this scheduled payment is never eligible for discount. 0 otherwise. Assumption: the sum of all the payment amounts for one particular invoice equals to the invoice amount.
INV_AMT_NOT_HAVING_DISC_G NUMBER

The payment amount in global currency of this scheduled payment if this scheduled payment is never eligible for discount. 0 otherwise. Assumption: the sum of all the payment amounts for one particular invoice equals to the invoice amount.
INV_AMT_NOT_HAVING_DISC_T NUMBER

The payment amount in transaction currency of this scheduled payment if this scheduled payment is never eligible for discount. 0 otherwise. Assumption: the sum of all the payment amounts for one particular invoice equals to the invoice amount.
INV_CURRENCY_FK VARCHAR2 (15)
Foreign key to the invoice currency dimension
PAYMENT_CURRENCY_FK VARCHAR2 (15)
Foreign key to the payment currency dimension
INV_DATE_FK VARCHAR2 (76)
Foreign key to the invoice date dimension
INV_FK VARCHAR2 (112)
Foreign key to the invoice type dimension
INV_SOURCE_FK VARCHAR2 (25)
Foreign key to the invoice source dimension
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_DATE1 DATE
Yes Standard Who column
LAST_UPDATE_DATE2 DATE

Standard Who column
ORG_FK VARCHAR2 (71)
Foreign key to the organization dimension
PARTIALLY_PAID_PAYMENT_COUNT NUMBER

Set to 1 if this scheduled payment is partially paid, 0 otherwise.
PAYMENT_AMT_B NUMBER

Payment amount in functional currency.
PAYMENT_AMT_G NUMBER

Payment amount in global currency.
PAYMENT_AMT_T NUMBER

Payment amount in transactional currency.
PAYMENT_METHOD VARCHAR2 (25)
Payment method
PAYMENT_PRIORITY NUMBER (2)
Number representing the payment priority of a scheduled payment
PAYMENT_STATUS_FLAG VARCHAR2 (25)
Flag that indicates if payment has been made Y or N or P
PAYMENT_TERM_FK VARCHAR2 (74)
Foreign key to the payment term dimension
POTENTIAL_DISC_AMT_B NUMBER

The amount in functional currency of the best discount that can be or could have been taken for this scheduled payment.
POTENTIAL_DISC_AMT_G NUMBER

The amount in global currency of the best discount that can be or could have been taken for this scheduled payment.
POTENTIAL_DISC_AMT_T NUMBER

The amount in transaction currency of the best discount that can be or could have been taken for this scheduled payment.
REMAINING_DISC_AMT_AT_RISK_B NUMBER

The remaining discount amount in functional currency that the scheduled payment is still eligible for.
REMAINING_DISC_AMT_AT_RISK_G NUMBER

The remaining discount amount in global currency that the scheduled payment is still eligible for.
REMAINING_DISC_AMT_AT_RISK_T NUMBER

The remaining discount amount in transaction currency that the scheduled payment is still eligible for.
REMAINING_INV_AMT_AT_RISK_B NUMBER

The unpaid payment amount in functional currency that is still eligible for discount.
REMAINING_INV_AMT_AT_RISK_G NUMBER

The unpaid payment amount in global currency that is still eligible for discount.
REMAINING_INV_AMT_AT_RISK_T NUMBER

The unpaid payment amount in transaction currency that is still eligible for discount.
SCH_PAYMENT_PK VARCHAR2 (153)
Unique identifier
SECOND_DISC_AVAILABLE_B NUMBER

Discount amount in functional currency that is available at the second discount date.
SECOND_DISC_AVAILABLE_G NUMBER

Discount amount in global currency that is available at the second discount date.
SECOND_DISC_AVAILABLE_T NUMBER

Discount amount in transaction currency that is available at the second discount date.
SECOND_DISC_DATE DATE

The date the second discount is available.
SIC_CODE_FK VARCHAR2 (25)
Foreign key to the standard industry code,SIC, dimension.
DUNS_FK CHAR (6)
Foreign key to the data universal numbering system,DUNS, dimension.
SOB_FK VARCHAR2 (71)
Foreign key to the set of books dimension
SUPPLIER_FK VARCHAR2 (126)
Foreign key to the supplier dimension
THIRD_DISC_AVAILABLE_B NUMBER

Discount amount in functional currency that is available at the third discount date.
THIRD_DISC_AVAILABLE_G NUMBER

Discount amount in global currency that is available at the third discount date.
THIRD_DISC_AVAILABLE_T NUMBER

Discount amount in transaction currency that is available at the third discount date.
THIRD_DISC_DATE DATE

The date the third discount is available.
UNPAID_PAYMENT_COUNT NUMBER

Set to 1 if this scheduled payment has not been paid. 0 otherwise.
SET_OF_BOOKS_ID NUMBER (15) Yes Set of Books identifier
CHART_OF_ACCOUNTS_ID NUMBER (15) Yes Chart of accounts identifier
GLOBAL_CURRENCY_RATE NUMBER

Exchange rate for a foreign currency invoice
REMAINING_INV_AMT_B NUMBER

REMAINING_INV_AMT_G NUMBER

REMAINING_INV_AMT_T NUMBER

GL_ACCT1_FK CHAR (6)
Foreign keys to the Accounting Flexfield dimension
GL_ACCT2_FK CHAR (6)
Foreign keys to the Accounting Flexfield dimension
GL_ACCT3_FK CHAR (6)
Foreign keys to the Accounting Flexfield dimension
GL_ACCT4_FK CHAR (6)
Foreign keys to the Accounting Flexfield dimension
GL_ACCT5_FK CHAR (6)
Foreign keys to the Accounting Flexfield dimension
GL_ACCT6_FK CHAR (6)
Foreign keys to the Accounting Flexfield dimension
GL_ACCT7_FK CHAR (6)
Foreign keys to the Accounting Flexfield dimension
GL_ACCT8_FK CHAR (6)
Foreign keys to the Accounting Flexfield dimension
GL_ACCT9_FK CHAR (6)
Foreign keys to the Accounting Flexfield dimension
GL_ACCT10_FK CHAR (6)
Foreign keys to the Accounting Flexfield dimension
_KF:GL_ACCT_NUM:ACCT:_EDW CHAR (17)
This column is for internal use only
_DF:CHP:_EDW CHAR (34)
This column is for internal use only
_DF:CHG:_EDW CHAR (34)
This column is for internal use only
_DF:INV:_EDW CHAR (24)
This column is for internal use only
_DF:IVJ:_EDW CHAR (24)
This column is for internal use only
FROM_CURRENCY VARCHAR2 (15) Yes Currency used by edw_currency.get_rate api to calculate GLOBAL_CURRENCY_RATE
GL_DATE DATE
Yes
INVOICE_DATE DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SEQ_ID
,      INVOICE_NUM
,      INV_TYPE
,      PINVOICE_ID
,      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_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
,      REMAINING_INV_AMT_B
,      REMAINING_INV_AMT_G
,      REMAINING_INV_AMT_T
,      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
,      _KF:GL_ACCT_NUM:ACCT:_EDW
,      _DF:CHP:_EDW
,      _DF:CHG:_EDW
,      _DF:INV:_EDW
,      _DF:IVJ:_EDW
,      FROM_CURRENCY
,      GL_DATE
,      INVOICE_DATE
FROM APPS.FIIBV_AP_SCH_PAYMTS_FCV;

Dependencies

[top of page]

APPS.FIIBV_AP_SCH_PAYMTS_FCV references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
SynonymAP_INVOICE_PAYMENTS_ALL
SynonymAP_PAYMENT_SCHEDULES_ALL
PL/SQL PackageEDW_CURRENCY - show dependent code
SynonymEDW_LOCAL_INSTANCE
SynonymEDW_LOCAL_SYSTEM_PARAMETERS
SynonymFII_AP_TMP_SCHP_PK
SynonymFND_USER
SynonymGL_CODE_COMBINATIONS
ViewGL_SETS_OF_BOOKS
ViewPO_VENDORS
APPS.FIIBV_AP_SCH_PAYMTS_FCV is referenced by following:

SchemaAPPS
ViewFII_AP_SCH_PAYMTS_FCV