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

VIEW: APPS.POA_FII_AP_SCH_PAYMTS_F_V

Object Details
Object Name: POA_FII_AP_SCH_PAYMTS_F_V
Object Type: VIEW
Owner: APPS
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
SUPPLIER_FK_KEY NUMBER

System generated foreign key for the supplier dimension
DUE_DATE_FK_KEY NUMBER

System generated foreign key for the due date dimension.
DISC_DATE_FK_KEY NUMBER

System generated foreign key for the discount date dimension
INV_DATE_FK_KEY NUMBER

System generated foreign key for the invoice date dimension
SIC_CODE_FK_KEY NUMBER

System generated foreign key for the standard industry code,SIC, dimension.
DUNS_FK_KEY NUMBER

System generated foreign key for the data universal numbering system,DUNS, dimension
ORG_FK_KEY NUMBER

System generated foreign key for the organization dimension
INV_FK_KEY NUMBER

System generated foreign key for the invoice dimension
INV_SOURCE_FK_KEY NUMBER

System generated foreign key for the invoice source dimension
INSTANCE_FK_KEY NUMBER

System generated foreign key for the instance dimension
EMPLOYEE_FK_KEY NUMBER

System generated foreign key for the employee dimension
GL_ACCT9_FK_KEY NUMBER

Foreign keys to the Accounting Flexfield dimension
GL_ACCT8_FK_KEY NUMBER

Foreign keys to the Accounting Flexfield dimension
GL_ACCT7_FK_KEY NUMBER

Foreign keys to the Accounting Flexfield dimension
GL_ACCT6_FK_KEY NUMBER

Foreign keys to the Accounting Flexfield dimension
GL_ACCT5_FK_KEY NUMBER

Foreign keys to the Accounting Flexfield dimension
GL_ACCT4_FK_KEY NUMBER

Foreign keys to the Accounting Flexfield dimension
GL_ACCT3_FK_KEY NUMBER

Foreign keys to the Accounting Flexfield dimension
GL_ACCT2_FK_KEY NUMBER

Foreign keys to the Accounting Flexfield dimension
GL_ACCT1_FK_KEY NUMBER

Foreign keys to the Accounting Flexfield dimension
GL_ACCT10_FK_KEY NUMBER

Foreign keys to the Accounting Flexfield dimension
SOB_FK_KEY NUMBER

System generated foreign key for the set of books dimension
GEOGRAPHY_FK_KEY NUMBER

System generated foreign key for the geography dimension
PAYMENT_CURRENCY_FK_KEY NUMBER

System generated foreign key to the payment currency dimension.
INV_CURRENCY_FK_KEY NUMBER

System generated foreign key to the invoice currency dimension.
PAYMENT_TERM_FK_KEY NUMBER

System generated foreign key for payment term dimension
USER_MEASURE5 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE1 NUMBER

User defined measure
USER_FK5_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK4_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK3_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK2_KEY NUMBER

System generated foreign key for the user defined dimension
USER_FK1_KEY NUMBER

System generated foreign key for the user defined dimension
UNPAID_PAYMENT_COUNT NUMBER

Set to 1 if this scheduled payment has not been paid. 0 otherwise.
THIRD_DISC_AVAILABLE_T NUMBER

Discount amount in transaction currency that is available at the third discount rate.
THIRD_DISC_AVAILABLE_G NUMBER

Discount amount in global currency that is available at the third discount rate.
THIRD_DISC_AVAILABLE_B NUMBER

Discount amount in functional currency that is available at the third discount rate.
SECOND_DISC_AVAILABLE_T NUMBER

Discount amount in transaction currency that is available at the second discount rate.
SECOND_DISC_AVAILABLE_G NUMBER

Discount amount in global currency that is available at the second discount rate.
SECOND_DISC_AVAILABLE_B NUMBER

Discount amount in functional currency that is available at the second discount rate.
SCH_PAYMENT_PK_KEY NUMBER

Unique Identifier
REMAINING_INV_AMT_AT_RISK_ NUMBER

The unpaid payment amount in transaction currency that is still eligible for discount.
REMAINING_INV_AMT_AT_RISK2 NUMBER

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

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

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

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

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

The amount in transaction currency of the best discount that can be or could have been taken for this scheduled payment.
POTENTIAL_DISC_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_B NUMBER

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

Number representing the payment priority of a scheduled payment
PAYMENT_EXCHANGE_RATE NUMBER

Exchange rate between invoice currency and payment currency.
PAYMENT_AMT_T NUMBER

Payment amount in transactional currency.
PAYMENT_AMT_G NUMBER

Payment amount in global currency.
PAYMENT_AMT_B NUMBER

Payment amount in functional currency.
PARTIALLY_PAID_PAYMENT_COU NUMBER

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

Exchange rate between invoice currency and base currency.
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_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_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_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_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_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.
FIRST_DISC_AVAILABLE_T NUMBER

Discount amount in transaction 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_B NUMBER

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

Discount amount taken in transaction currency.
DISC_AMT_TAKEN_G NUMBER

Discount amount taken in global currency.
DISC_AMT_TAKEN_B NUMBER

Discount amount taken in functional currency
DISC_AMT_LOST_T NUMBER

Discount amount lost in transaction currency.
DISC_AMT_LOST_G NUMBER

Discount amount lost in global currency.
DISC_AMT_LOST_B NUMBER

Discount amount lost in functional currency.
COMPLETELY_PAID_PAYMENT_CO NUMBER

Set to 1 if this schedule payment has been completely paid. 0 otherwise.
CCID NUMBER

Invoice Accounting Flexfield identifier for accounts payable liability account.
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
SCH_PAYMENT_PK VARCHAR2 (40)
Unique Identifier
PAYMENT_STATUS_FLAG VARCHAR2 (1)
Flag that indicates if payment has been made (Y/N/P)
PAYMENT_METHOD VARCHAR2 (25)
Payment method
PAYMENT_EXCHANGE_RATE_TYPE VARCHAR2 (30)
Rate type of the payment exchange rate
INV_EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange rate type for foreign currency invoice
HOLD_FLAG VARCHAR2 (1)
Flag that indicates if the scheduled payment is on hold (Y/N)
THIRD_DISC_DATE DATE

The date the third discount is available.
SECOND_DISC_DATE DATE

The date the second discount is available.
PAYMENT_EXCHANGE_DATE DATE

The date of the payment exchange rate.
LAST_UPDATE_DATE DATE

Standard Who column
INV_EXCHANGE_DATE DATE

The date the exchange rate is effective.
FIRST_DISC_DATE DATE

The date the first discount is available.
DUE_DATE DATE

Scheduled payment due date
CREATION_DATE DATE

Standard Who column
INVOICE_NUM VARCHAR2 (50)
Invoice Number
INSTANCE VARCHAR2 (40)
Instance identifier.
REMAINING_INV_AMT_B NUMBER (22)
Remaining invoice amount in base currency.
REMAINING_INV_AMT_G NUMBER (22)
Remaining invoice amount in global currency.
REMAINING_INV_AMT_T NUMBER (22)
Remaining invoice amount in transaction currency.
Query Text

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


SELECT SUPPLIER_FK_KEY
,      DUE_DATE_FK_KEY
,      DISC_DATE_FK_KEY
,      INV_DATE_FK_KEY
,      SIC_CODE_FK_KEY
,      DUNS_FK_KEY
,      ORG_FK_KEY
,      INV_FK_KEY
,      INV_SOURCE_FK_KEY
,      INSTANCE_FK_KEY
,      EMPLOYEE_FK_KEY
,      GL_ACCT9_FK_KEY
,      GL_ACCT8_FK_KEY
,      GL_ACCT7_FK_KEY
,      GL_ACCT6_FK_KEY
,      GL_ACCT5_FK_KEY
,      GL_ACCT4_FK_KEY
,      GL_ACCT3_FK_KEY
,      GL_ACCT2_FK_KEY
,      GL_ACCT1_FK_KEY
,      GL_ACCT10_FK_KEY
,      SOB_FK_KEY
,      GEOGRAPHY_FK_KEY
,      PAYMENT_CURRENCY_FK_KEY
,      INV_CURRENCY_FK_KEY
,      PAYMENT_TERM_FK_KEY
,      USER_MEASURE5
,      USER_MEASURE4
,      USER_MEASURE3
,      USER_MEASURE2
,      USER_MEASURE1
,      USER_FK5_KEY
,      USER_FK4_KEY
,      USER_FK3_KEY
,      USER_FK2_KEY
,      USER_FK1_KEY
,      UNPAID_PAYMENT_COUNT
,      THIRD_DISC_AVAILABLE_T
,      THIRD_DISC_AVAILABLE_G
,      THIRD_DISC_AVAILABLE_B
,      SECOND_DISC_AVAILABLE_T
,      SECOND_DISC_AVAILABLE_G
,      SECOND_DISC_AVAILABLE_B
,      SCH_PAYMENT_PK_KEY
,      REMAINING_INV_AMT_AT_RISK_
,      REMAINING_INV_AMT_AT_RISK2
,      REMAINING_INV_AMT_AT_RISK3
,      REMAINING_DISC_AMT_AT_RISK
,      REMAINING_DISC_AMT_AT_RIS2
,      REMAINING_DISC_AMT_AT_RIS3
,      POTENTIAL_DISC_T
,      POTENTIAL_DISC_G
,      POTENTIAL_DISC_B
,      PAYMENT_PRIORITY
,      PAYMENT_EXCHANGE_RATE
,      PAYMENT_AMT_T
,      PAYMENT_AMT_G
,      PAYMENT_AMT_B
,      PARTIALLY_PAID_PAYMENT_COU
,      INV_EXCHANGE_RATE
,      INV_AMT_NOT_HAVING_DISC_T
,      INV_AMT_NOT_HAVING_DISC_G
,      INV_AMT_NOT_HAVING_DISC_B
,      INV_AMT_HAVING_DISC_T
,      INV_AMT_HAVING_DISC_G
,      INV_AMT_HAVING_DISC_B
,      FIRST_DISC_AVAILABLE_T
,      FIRST_DISC_AVAILABLE_G
,      FIRST_DISC_AVAILABLE_B
,      DISC_AMT_TAKEN_T
,      DISC_AMT_TAKEN_G
,      DISC_AMT_TAKEN_B
,      DISC_AMT_LOST_T
,      DISC_AMT_LOST_G
,      DISC_AMT_LOST_B
,      COMPLETELY_PAID_PAYMENT_CO
,      CCID
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE1
,      SCH_PAYMENT_PK
,      PAYMENT_STATUS_FLAG
,      PAYMENT_METHOD
,      PAYMENT_EXCHANGE_RATE_TYPE
,      INV_EXCHANGE_RATE_TYPE
,      HOLD_FLAG
,      THIRD_DISC_DATE
,      SECOND_DISC_DATE
,      PAYMENT_EXCHANGE_DATE
,      LAST_UPDATE_DATE
,      INV_EXCHANGE_DATE
,      FIRST_DISC_DATE
,      DUE_DATE
,      CREATION_DATE
,      INVOICE_NUM
,      INSTANCE
,      REMAINING_INV_AMT_B
,      REMAINING_INV_AMT_G
,      REMAINING_INV_AMT_T
FROM APPS.POA_FII_AP_SCH_PAYMTS_F_V;

Dependencies

[top of page]

APPS.POA_FII_AP_SCH_PAYMTS_F_V references the following:

SchemaAPPS
SynonymEDW_INV_TYPE_M
SynonymFII_AP_SCH_PAYMTS_F
APPS.POA_FII_AP_SCH_PAYMTS_F_V is referenced by following:

SchemaAPPS
ViewPOA_PMF_DIS_LOST_V