[Home] [Help] [Dependency Information]
Object Name: | FIIBV_AP_INV_PAYMTS_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FII.FIIBV_AP_INV_PAYMTS_FCV |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_ID | NUMBER | (15) | Sequence identifier | |
ACCOUNTING_DATE | DATE | Yes | Accounting date of the invoice line | |
ACCRUAL_POSTED_FLAG | VARCHAR2 | (1) | Flag that indicates if payment has been posted Y or N | |
ASSETS_ADDITION_FLAG | VARCHAR2 | (1) | Flag that indicates if discounts on invoice payment have been transferred into Oracle Assets Y or N | |
BANK_ACCOUNT_ID | NUMBER | (15) | Bank account identifier of the payment check | |
BASE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Base currency of the set of books |
CASH_JE_BATCH_ID | NUMBER | (15) | Cash journal entry batch identifier | |
CASH_POSTED_FLAG | VARCHAR2 | (1) | Flag that indicates if payment has been posted Y or N | |
CCID | NUMBER | (15) | Invoice accounting flexfield identifier for accounts payable liability account | |
CHECK_DATE | DATE | Yes | Payment date | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
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 | ||
EARLY_DISC_PAYMENT_AMT_B | NUMBER | The payment amount in functional currency of this payment if it is made before or on the first discount date for the discount taken, otherwise 0 | ||
EARLY_DISC_PAYMENT_AMT_G | NUMBER | The payment amount in warehouse currency of this payment if it is made before or on the first discount date for the discount taken, otherwise 0 | ||
EARLY_DISC_PAYMENT_AMT_T | NUMBER | The payment amount in transaction currency of this payment if it is made before or on the first discount date for the discount taken, otherwise 0 | ||
EARLY_DISC_PAYMENT_DAYS | NUMBER | The number of days from the payment date to the first discount date, where the payment date is earlier or on the first discount date | ||
EARLY_DISC_PAYMENT_COUNT | NUMBER | Set to 1 if this payment is made before or on the first discount date, otherwise 0 | ||
EARLY_NET_PAYMENT_AMT_B | NUMBER | The payment amount in functional currency of this payment if it is made before or on the net due date but after all discount dates, otherwise 0 | ||
EARLY_NET_PAYMENT_AMT_G | NUMBER | The payment amount in warehouse currency of this payment if it is made before or on the net due date but after all discount dates, otherwise 0 | ||
EARLY_NET_PAYMENT_AMT_T | NUMBER | The payment amount in transaction currency of this payment if it is made before or on the net due date but after all discount dates, otherwise 0 | ||
EARLY_NET_PAYMENT_COUNT | NUMBER | Set to 1 if this payment is made before or on the net due date but after all discount dates, otherwise 0 | ||
EARLY_NET_PAYMENT_DAYS | NUMBER | The number of days from the payment date to the net due date, where the payment date is earlier or on the due date, and the payment date is after all discount dates | ||
EMPLOYEE_FK | VARCHAR2 | (85) | Foreign key for the employee dimension | |
FUTURE_PAY_POSTED_FLAG | VARCHAR2 | (1) | Flag that indicates if payment has been posted Y or N | |
GEOGRAPHY_FK | VARCHAR2 | (126) | Foreign key to the geography dimension | |
INSTANCE | VARCHAR2 | (30) | Instance identifier | |
INSTANCE_FK | VARCHAR2 | (30) | Foreign key for the instance dimension | |
INVOICE_DATE | DATE | Invoice date | ||
INV_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Invoice currency code |
INV_EXCHANGE_DATE | DATE | Date exchange rate is effective | ||
INV_EXCHANGE_RATE | NUMBER | Exchange rate between invoice currency and base currency | ||
INV_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type of foreign currecny invoice | |
INV_FK | VARCHAR2 | (112) | Foreign key for the invoice type dimension | |
INV_NUM | VARCHAR2 | (50) | Yes | Invoice number of paid invoice. |
INV_PAYMENT_PK | VARCHAR2 | (112) | Foreign key for the invoice payment dimension | |
INV_PAYMENT_STATUS_FLAG | VARCHAR2 | (1) | Flag that indicates if the inovice has been paid Y or N or P | |
INV_PAYMENT_TYPE | VARCHAR2 | (25) | Creation method of a paymnet used by the postive pay feature (single or batch) | |
INV_SOURCE | VARCHAR2 | (25) | Invoice source of paid invoice. | |
INV_SOURCE_FK | VARCHAR2 | (25) | Foreign key for the invoice source dimension | |
INV_TYPE | VARCHAR2 | (25) | Type of paid invoice. | |
JE_BATCH_ID | NUMBER | (15) | Journal entry batch identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_DATE1 | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE2 | DATE | Yes | Standard Who column | |
LATE_DISC_DAYS | NUMBER | The number of days from the discount deadline date of the best possible discount to the payment date | ||
LATE_DISC_PAYMENT_AMT_B | NUMBER | The payment amount in functional currency that was made after the first discount date | ||
LATE_DISC_PAYMENT_AMT_G | NUMBER | The payment amount in global currency that was made after the first discount date | ||
LATE_DISC_PAYMENT_AMT_T | NUMBER | The payment amount in transaction currency that was made after the first discount date | ||
LATE_DISC_PAYMENT_COUNT | NUMBER | Set to 1 if this payment is made after the first discount date. 0 otherwise | ||
LATE_NET_PAYMENT_AMT_B | NUMBER | The payment amount in functional currency that was made after the net due date | ||
LATE_NET_PAYMENT_AMT_G | NUMBER | The payment amount in global currency that was made after the net due date | ||
LATE_NET_PAYMENT_AMT_T | NUMBER | The payment amount in payment currency that was made after the net due date | ||
LATE_NET_PAYMENT_COUNT | NUMBER | Set to 1 if this payment is made after the net due date. 0 otherwise | ||
LATE_NET_PAYMENT_DAYS | NUMBER | The number of days from the net due date to the payment date | ||
ORG_FK | VARCHAR2 | (71) | Foreign key for the organization dimension | |
PAYMENT_AMT_B | NUMBER | Payment amount in functional currency | ||
PAYMENT_AMT_G | NUMBER | Payment amount in global currency | ||
PAYMENT_AMT_T | NUMBER | Yes | Payment amount in transactional currency | |
PAYMENT_COUNT | NUMBER | Set to 1 | ||
PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | Yes | Payment currency code |
PAYMENT_CURRENCY_FK | VARCHAR2 | (15) | Foreign key for the payment currency dimension | |
PAYMENT_DATE_FK | VARCHAR2 | (76) | Foreign key for the payment date dimension | |
DISC_AMT_TAKEN_B | NUMBER | Discount amount taken in functional currency | ||
DISC_AMT_TAKEN_G | NUMBER | Discount amount taken in global currency | ||
DISC_AMT_TAKEN_T | NUMBER | Discount amount taken in transaction currency | ||
PAYMENT_EXCHANGE_DATE | DATE | Rate date of the payment exchange rate | ||
PAYMENT_EXCHANGE_RATE | NUMBER | Exchange rate between invoice currency and payment currency | ||
PAYMENT_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Rate type of the payment exchange rate | |
PAYMENT_FK | VARCHAR2 | (112) | Foreign key for the payment dimension | |
PAYMENT_TERM_FK | VARCHAR2 | (74) | Foreign key for the payment term dimension | |
POSTED_FLAG | VARCHAR2 | (1) | Yes | Flag that indicates if payment has been posted Y or N |
SIC_CODE_FK | VARCHAR2 | (25) | Foreign key for the standard industry code,SIC, dimension. | |
DUNS_FK | CHAR | (6) | Foreign key for the data universal numbering system,DUNS, dimension. | |
SOB_FK | VARCHAR2 | (71) | Foreign key for the set of books dimension | |
SUPPLIER_FK | VARCHAR2 | (126) | Foreign key for the supplier dimension | |
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 | ||
GL_ACCT1_FK | CHAR | (6) | Foreign key to the Accounting Flexfield dimension | |
GL_ACCT2_FK | CHAR | (6) | Foreign key to the Accounting Flexfield dimension | |
GL_ACCT3_FK | CHAR | (6) | Foreign key to the Accounting Flexfield dimension | |
GL_ACCT4_FK | CHAR | (6) | Foreign key to the Accounting Flexfield dimension | |
GL_ACCT5_FK | CHAR | (6) | Foreign key to the Accounting Flexfield dimension | |
GL_ACCT6_FK | CHAR | (6) | Foreign key to the Accounting Flexfield dimension | |
GL_ACCT7_FK | CHAR | (6) | Foreign key to the Accounting Flexfield dimension | |
GL_ACCT8_FK | CHAR | (6) | Foreign key to the Accounting Flexfield dimension | |
GL_ACCT9_FK | CHAR | (6) | Foreign key to the Accounting Flexfield dimension | |
GL_ACCT10_FK | CHAR | (6) | Foreign key to the Accounting Flexfield dimension | |
_KF:GL_ACCT_NUM:ACCT:_EDW | CHAR | (17) | This column is for internal use only | |
_DF:IPJ:_EDW | CHAR | (33) | 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 | |
_DF:CHK:_EDW | CHAR | (22) | This column is for internal use only | |
_DF:CHJ:_EDW | CHAR | (22) | 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 | |
CHECK_AMT_B | NUMBER | |||
CHECK_AMT_T | NUMBER | Yes | ||
CHECK_AMT_G | NUMBER | |||
CHECK_NUMBER | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
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
, 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:IPJ:_EDW
, _DF:INV:_EDW
, _DF:IVJ:_EDW
, _DF:CHK:_EDW
, _DF:CHJ:_EDW
, _DF:CHP:_EDW
, _DF:CHG:_EDW
, CHECK_AMT_B
, CHECK_AMT_T
, CHECK_AMT_G
, CHECK_NUMBER
FROM APPS.FIIBV_AP_INV_PAYMTS_FCV;
|
|
|