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

TABLE: AP.AP_PAYMENT_REP_ITF

Object Details
Object Name: AP_PAYMENT_REP_ITF
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_PAYMENT_REP_ITF
Subobject Name:
Status: VALID


AP_PAYMENT_REP_ITF stores information for the Report eXchange Payables Payment Reports. This report lets you sort and display your payments in a custom format.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_PAYMENT_REP_ITF_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER (15) Yes Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORGANIZATION_NAME VARCHAR2 (240)
Set of Books Name
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
Functional Currency Code
PAYMENT_NUMBER NUMBER (15)
Document number of a printed payment
PAYMENT_TYPE VARCHAR2 (20)
Payment Type
PAYMENT_DOC_SEQ_NAME VARCHAR2 (30)
Sequential Numbering document sequence name
PAYMENT_DOC_SEQ_VALUE NUMBER

Voucher number for payment
PAYMENT_DATE DATE

Payment Date
PAYMENT_CURRENCY_CODE VARCHAR2 (15)
Payment Currency Code
ORIG_PAYMENT_AMOUNT NUMBER

Payment Amount
ORIG_PAYMENT_BASE_AMOUNT NUMBER

Payment Amount in functional currency
PAYMENT_AMOUNT NUMBER

Payment Amount (Original Payment Amount or 0 if Payment voided)
PAYMENT_BASE_AMOUNT NUMBER

Payment Amount in functional currency
PAYMENT_EXCHANGE_RATE NUMBER

Exchange rate for foreign currency payment
PAYMENT_EXCHANGE_DATE DATE

Date exchange rate is effective. Usually the accounting date of the transaction
PAYMENT_EXCHANGE_TYPE VARCHAR2 (30)
Exchange rate type for foreign currency payment
PAYMENT_CLEARED_DATE DATE

Date a Payment cleared the bank
PAYMENT_CLEARED_AMOUNT NUMBER

Amount of a Payment that cleared the bank
PAYMENT_CLEARED_BASE_AMOUNT NUMBER

Payment cleared amount in base currency
PAYMENT_CLEARED_EXC_RATE NUMBER

Exchange rate at which the payment cleared, for foreign currency payments only
PAYMENT_CLEARED_EXC_DATE DATE

Date clearing exchange rate is effective, usually accounting date of a transaction
PAYMENT_CLEARED_EXC_TYPE VARCHAR2 (30)
Exchange rate type at payment clearing time, for foreign currency payments only
PAYMENT_FUTURE_PAY_DUE_DATE DATE

Negotiable Date for future dated payments
PAYMENT_VOID_FLAG VARCHAR2 (10)
Flag to indicate whether Payment has been voided
PAYMENT_PAY_METHOD VARCHAR2 (25)
Payment Method
PAYMENT_DOC_NAME VARCHAR2 (20)
Name of payment document
PAYMENT_DISBURSEMENT_TYPE VARCHAR2 (25)
Disbursement type for payment document
PAYMENT_STATUS VARCHAR2 (50)
Status of payment
SUPPLIER_NAME VARCHAR2 (240)
Supplier Name
SUPPLIER_NAME_ALT VARCHAR2 (320)
Alternate supplier name for kana value
SUPPLIER_SITE_CODE VARCHAR2 (15)
Site code name
SUPPLIER_SITE_CODE_ALT VARCHAR2 (320)
Alternate supplier site code for kana value
SUPPLIER_ADDRESS_LINE1 VARCHAR2 (240)
First line of supplier address
SUPPLIER_ADDRESS_LINE2 VARCHAR2 (240)
Second line of supplier address
SUPPLIER_ADDRESS_LINE3 VARCHAR2 (240)
Third line of supplier address
SUPPLIER_ADDRESS_ALT VARCHAR2 (560)
Alternate address line for kana value
SUPPLIER_CITY VARCHAR2 (25)
Supplier City
SUPPLIER_STATE VARCHAR2 (150)
Supplier State
SUPPLIER_PROVINCE VARCHAR2 (150)
Supplier Province
SUPPLIER_POSTAL_CODE VARCHAR2 (20)
Supplier Postal Code
SUPPLIER_COUNTRY VARCHAR2 (25)
Supplier Country
SUPPLIER_TERRITORY VARCHAR2 (80)
Supplier Territory
INT_BANK_NAME VARCHAR2 (60)
Internal Bank Name
INT_BANK_NAME_ALT VARCHAR2 (320)
Alternate Internal Bank Name for kana value
INT_BANK_NUMBER VARCHAR2 (30)
Internal Bank Number
INT_BANK_BRANCH_NAME VARCHAR2 (60)
Internal Bank Branch Name
INT_BANK_BRANCH_NAME_ALT VARCHAR2 (320)
Alternate Internal Bank Branch Name for kana value
INT_BANK_ACCOUNT_NAME VARCHAR2 (80)
Internal Bank Account Name
INT_BANK_ACCOUNT_NAME_ALT VARCHAR2 (320)
Alternate Internal Bank Account Name for kana value
INT_BANK_ACCOUNT_NUM VARCHAR2 (30)
Internal Bank Account Number
INT_BANK_CURRENCY_CODE VARCHAR2 (15)
Internal Bank Account Currency Code
INV_PAY_AMOUNT NUMBER

Payment Amount applied to Invoice
INV_PAY_BASE_AMOUNT NUMBER

Payment Amount applied to Invoice in functional currency
INV_PAY_DISCOUNT_TAKEN NUMBER

Discount Taken
INVOICE_NUM VARCHAR2 (50)
Invoice Number
INVOICE_DATE DATE

Invoice Date
INVOICE_CURRENCY_CODE VARCHAR2 (15)
Invoice Currency Code
INVOICE_AMOUNT NUMBER

Invoice Amount
INVOICE_BASE_AMOUNT NUMBER

Invoice Amount in functional currency
INVOICE_DESCRIPTION VARCHAR2 (240)
Invoice Description
INT_BANK_NUM#1 VARCHAR2 (30)
Internal Bank Branch Number
Query Text

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


SELECT REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_NAME
,      FUNCTIONAL_CURRENCY_CODE
,      PAYMENT_NUMBER
,      PAYMENT_TYPE
,      PAYMENT_DOC_SEQ_NAME
,      PAYMENT_DOC_SEQ_VALUE
,      PAYMENT_DATE
,      PAYMENT_CURRENCY_CODE
,      ORIG_PAYMENT_AMOUNT
,      ORIG_PAYMENT_BASE_AMOUNT
,      PAYMENT_AMOUNT
,      PAYMENT_BASE_AMOUNT
,      PAYMENT_EXCHANGE_RATE
,      PAYMENT_EXCHANGE_DATE
,      PAYMENT_EXCHANGE_TYPE
,      PAYMENT_CLEARED_DATE
,      PAYMENT_CLEARED_AMOUNT
,      PAYMENT_CLEARED_BASE_AMOUNT
,      PAYMENT_CLEARED_EXC_RATE
,      PAYMENT_CLEARED_EXC_DATE
,      PAYMENT_CLEARED_EXC_TYPE
,      PAYMENT_FUTURE_PAY_DUE_DATE
,      PAYMENT_VOID_FLAG
,      PAYMENT_PAY_METHOD
,      PAYMENT_DOC_NAME
,      PAYMENT_DISBURSEMENT_TYPE
,      PAYMENT_STATUS
,      SUPPLIER_NAME
,      SUPPLIER_NAME_ALT
,      SUPPLIER_SITE_CODE
,      SUPPLIER_SITE_CODE_ALT
,      SUPPLIER_ADDRESS_LINE1
,      SUPPLIER_ADDRESS_LINE2
,      SUPPLIER_ADDRESS_LINE3
,      SUPPLIER_ADDRESS_ALT
,      SUPPLIER_CITY
,      SUPPLIER_STATE
,      SUPPLIER_PROVINCE
,      SUPPLIER_POSTAL_CODE
,      SUPPLIER_COUNTRY
,      SUPPLIER_TERRITORY
,      INT_BANK_NAME
,      INT_BANK_NAME_ALT
,      INT_BANK_NUMBER
,      INT_BANK_BRANCH_NAME
,      INT_BANK_BRANCH_NAME_ALT
,      INT_BANK_ACCOUNT_NAME
,      INT_BANK_ACCOUNT_NAME_ALT
,      INT_BANK_ACCOUNT_NUM
,      INT_BANK_CURRENCY_CODE
,      INV_PAY_AMOUNT
,      INV_PAY_BASE_AMOUNT
,      INV_PAY_DISCOUNT_TAKEN
,      INVOICE_NUM
,      INVOICE_DATE
,      INVOICE_CURRENCY_CODE
,      INVOICE_AMOUNT
,      INVOICE_BASE_AMOUNT
,      INVOICE_DESCRIPTION
,      INT_BANK_NUM#1
FROM AP.AP_PAYMENT_REP_ITF;

Dependencies

[top of page]

AP.AP_PAYMENT_REP_ITF does not reference any database object

AP.AP_PAYMENT_REP_ITF is referenced by following:

SchemaAP
ViewAP_PAYMENT_REP_ITF#