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

TABLE: AP.AP_CHECK_STOCKS_ALL

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


AP_CHECK_STOCKS_ALL stores information about payment
documents you defined for bank accounts. You need one
row for each payment document you use to create
payments for a supplier. Each record in this table must
be associated with a bank account. Each bank account
corresponds with zero or more rows in this table. When
you initiate a payment batch, record a manual payment, or
create a Quick payment, you can select a payment document
that you defined in this table. For a payment document you use to
create automatic payments, DISBURSEMENT_TYPE_LOOKUP_CODE
must be 'COMPUTER GENERATED' or 'COMBINED.'
For manual payments, it must be 'RECORDED' or 'COMBINED.'
.
Your Oracle Payables application updates the
LAST_DOCUMENT_NUM when you create payments in an
automatic payment batch, enter a manual payment, or
create a Quick payment.
.
This table corresponds to the Payment Documents window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_CHECK_STOCKS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHECK_STOCK_ID
AP_CHECK_STOCKS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBANK_ACCOUNT_ID
ColumnNAME
Columns
Name Datatype Length Mandatory Comments
CHECK_STOCK_ID NUMBER (15) Yes Payment document identifier
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).
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).
NAME VARCHAR2 (20) Yes Name of payment document
BANK_ACCOUNT_ID NUMBER (15) Yes Bank account identifier
DISBURSEMENT_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Disbursement type for payment document
CHECK_FORMAT_ID NUMBER (15)
Payment format identifier
LAST_DOCUMENT_NUM NUMBER (15)
Last payment number used on a payment document to pay invoices
LAST_AVAILABLE_DOCUMENT_NUM NUMBER (15)
Last payment number available for a payment document
NUM_SETUP_CHECKS NUMBER (15)
Number of checks printed at the beginning of each automatic payment batch
AUTO_MEDIUM_ID NUMBER (15)
No longer used
CHECK_RECON_GROUP_ID NUMBER (15)
No longer used
SEQUENTIAL_FLAG VARCHAR2 (1)
No longer used
INACTIVE_DATE DATE

Inactive date
FUTURE_PAY_CODE_COMBINATION_ID NUMBER (15)
Accounting Flexfield identifier for intermediate account that Oracle Payables credits when a future dated payment is issued and accounted
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
DOC_CATEGORY_CODE VARCHAR2 (30)
Default Sequential Numbering (voucher number) document category for payment document
ORG_ID NUMBER (15)
Organization identifier
BANK_CHARGES_CCID NUMBER (15)
Accounting Flexfield identifier for the Bank Charges account
BANK_ERRORS_CCID NUMBER (15)
Accounting Flexfield identifier for the Bank Errors account
CLEARING_DAYS NUMBER (15)
No longer used
FUTURE_DATED_PAYMENTS_FLAG VARCHAR2 (30)
Flag that determines whether future dated payments are Allowed (A), Not Allowed (N), or Mandatory (M) for this payment document
CASH_CLEARING_CCID NUMBER (15)
Accounting Flexfield identifier for the cash clearing account
TRANSMISSION_CODE VARCHAR2 (100)
Unique name for automatic bank transmission setup
Query Text

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


SELECT CHECK_STOCK_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      NAME
,      BANK_ACCOUNT_ID
,      DISBURSEMENT_TYPE_LOOKUP_CODE
,      CHECK_FORMAT_ID
,      LAST_DOCUMENT_NUM
,      LAST_AVAILABLE_DOCUMENT_NUM
,      NUM_SETUP_CHECKS
,      AUTO_MEDIUM_ID
,      CHECK_RECON_GROUP_ID
,      SEQUENTIAL_FLAG
,      INACTIVE_DATE
,      FUTURE_PAY_CODE_COMBINATION_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DOC_CATEGORY_CODE
,      ORG_ID
,      BANK_CHARGES_CCID
,      BANK_ERRORS_CCID
,      CLEARING_DAYS
,      FUTURE_DATED_PAYMENTS_FLAG
,      CASH_CLEARING_CCID
,      TRANSMISSION_CODE
FROM AP.AP_CHECK_STOCKS_ALL;

Dependencies

[top of page]

AP.AP_CHECK_STOCKS_ALL does not reference any database object

AP.AP_CHECK_STOCKS_ALL is referenced by following:

SchemaAPPS
SynonymAP_CHECK_STOCKS
SynonymAP_CHECK_STOCKS_ALL