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

TABLE: AP.AP_SELECTED_INVOICE_CHECKS_ALL

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


AP_SELECTED_INVOICE_CHECKS_ALL is a temporary table that stores payment information during a payment batch. Your Oracle Payables application inserts into this table when you build payments in a payment batch. There will be one row for
each payment issued during the current payment batch. When you confirm a payment batch, your Oracle Payables application inserts these payments into AP_CHECKS_ALL and creates a payment file.
.
Within a payment batch, SELECTED_CHECK_ID in this table joins with PRINT_SELECTED_CHECK_ID and PAY_SELECTED_CHECK_ID in AP_SELECTED_INVOICES to associate a selected invoice with its payment.


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_SELECTED_INVOICE_CHECKS_U1 NORMAL UNIQUE TablespaceAPPS_TS_NOLOGGING ColumnSELECTED_CHECK_ID
AP_SELECTED_INVOICE_CHECKS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_NOLOGGING ColumnCHECKRUN_NAME
ColumnCHECK_NUMBER
Columns
Name Datatype Length Mandatory Comments
CHECKRUN_NAME VARCHAR2 (255) Yes Payment batch name
CHECK_NUMBER NUMBER (15) Yes Number of payment issued
VENDOR_ID NUMBER (15)
Supplier identifier
VENDOR_SITE_ID NUMBER (15)
Supplier site identifier
PRINT_SEQUENCE_NUM NUMBER (15) Yes Sequence number of payment when first selected for payment
CHECK_AMOUNT NUMBER
Yes Amount of a payment in a payment batch
VENDOR_AMOUNT NUMBER
Yes Total payment amount for a supplier in a payment batch
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
OK_TO_PAY_FLAG VARCHAR2 (1)
Flag that indicates if invoice will be paid during a payment batch (Y or N)
DONT_PAY_REASON_CODE VARCHAR2 (25)
Reason that OK_TO_PAY_FLAG is N
STATUS_LOOKUP_CODE VARCHAR2 (25)
Current status of payment during payment batch processing
VENDOR_NUM VARCHAR2 (30)
Supplier number
VENDOR_NAME VARCHAR2 (240)
Supplier name
VENDOR_SITE_CODE VARCHAR2 (15)
Supplier site code
CUSTOMER_NUM VARCHAR2 (25)
Customer number a supplier uses for your company
ADDRESS_LINE1 VARCHAR2 (240)
First line of supplier site street address
ADDRESS_LINE2 VARCHAR2 (240)
Second line of supplier site street address
ADDRESS_LINE3 VARCHAR2 (240)
Third line of supplier site street address
CITY VARCHAR2 (60)
City of supplier site address
STATE VARCHAR2 (150)
State of supplier site address
ZIP VARCHAR2 (60)
Zip code of supplier site address
PROVINCE VARCHAR2 (150)
Province of supplier site address
COUNTRY VARCHAR2 (60)
Country of supplier site address
WITHHOLDING_STATUS_LOOKUP_CODE VARCHAR2 (25)
(Not currently used) Status that indicates if taxes should be withheld from supplier invoice payments
VOID_FLAG VARCHAR2 (1)
Flag that indicates if check is a void check due to overflow on check stub
CHECK_ID NUMBER (15)
Payment identifier of payment issued
CURRENCY_CODE VARCHAR2 (15) Yes Currency code
DISCOUNT_AMOUNT NUMBER

Discount amount taken on invoices for a payment
BANK_ACCOUNT_NUM VARCHAR2 (30)
Bank account number
BANK_NUM VARCHAR2 (25)
Bank number
BANK_ACCOUNT_TYPE VARCHAR2 (25)
Bank account type code
CHECK_VOUCHER_NUM NUMBER (16)
Voucher number of payment
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).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
FUTURE_PAY_DUE_DATE DATE

Negotiable date for future dated payment
DUE_DATE DATE

Due date for invoice
PAYMENT_DATE DATE

Payment date for invoice
SELECTED_CHECK_ID NUMBER (15)
Identifier for payment document selected to pay invoice
ATTENTION_AR_FLAG VARCHAR2 (1)
Flag that indicates if legend Attention Accounts Receivable will appear on payments
ORG_ID NUMBER (15)
Organization identifier
TRANSFER_PRIORITY VARCHAR2 (25)
Transfer priority
EXTERNAL_BANK_ACCOUNT_ID NUMBER (15)
External bank account identifier
ADDRESS_LINE4 VARCHAR2 (240)
Fourth line of supplier site street address
IBAN_NUMBER VARCHAR2 (40)
International bank account number. Used internationally to uniquely identify the account of a customer at a financial institution. During bank entry, the system validates the value to ensure that it is a valid IBAN.
Query Text

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


SELECT CHECKRUN_NAME
,      CHECK_NUMBER
,      VENDOR_ID
,      VENDOR_SITE_ID
,      PRINT_SEQUENCE_NUM
,      CHECK_AMOUNT
,      VENDOR_AMOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      OK_TO_PAY_FLAG
,      DONT_PAY_REASON_CODE
,      STATUS_LOOKUP_CODE
,      VENDOR_NUM
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      CUSTOMER_NUM
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      STATE
,      ZIP
,      PROVINCE
,      COUNTRY
,      WITHHOLDING_STATUS_LOOKUP_CODE
,      VOID_FLAG
,      CHECK_ID
,      CURRENCY_CODE
,      DISCOUNT_AMOUNT
,      BANK_ACCOUNT_NUM
,      BANK_NUM
,      BANK_ACCOUNT_TYPE
,      CHECK_VOUCHER_NUM
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      FUTURE_PAY_DUE_DATE
,      DUE_DATE
,      PAYMENT_DATE
,      SELECTED_CHECK_ID
,      ATTENTION_AR_FLAG
,      ORG_ID
,      TRANSFER_PRIORITY
,      EXTERNAL_BANK_ACCOUNT_ID
,      ADDRESS_LINE4
,      IBAN_NUMBER
FROM AP.AP_SELECTED_INVOICE_CHECKS_ALL;

Dependencies

[top of page]

AP.AP_SELECTED_INVOICE_CHECKS_ALL does not reference any database object

AP.AP_SELECTED_INVOICE_CHECKS_ALL is referenced by following:

SchemaAP
ViewAP_SELECTED_INVOICE_CHECKS_AL#