[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_BATCHES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | AP |
| FND Design Data: |  SQLAP.AP_BATCHES_ALL
|
| Subobject Name: | |
| Status: | VALID |
AP_BATCHES_ALL contains summary information about invoices you enter in batches if you enable the Batch Control Payables option. There is one row for each batch of invoices you enter. If you enable Batch Control, each invoice must correspond to a record in this table. Your Oracle Payables application uses this information to group together invoices that one person entered in a batch.
This table corresponds to the Invoice Batches window.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AP_BATCHES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 BATCH_ID
|
| AP_BATCHES_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
BATCH_NAME
BATCH_DATE
ORG_ID
|
| AP_BATCHES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BATCH_DATE
|
| AP_BATCHES_N2 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
UPPER("BATCH_NAME")
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_ID | NUMBER | (15) | Yes | Invoice batch identifier |
| BATCH_NAME | VARCHAR2 | (50) | Yes | Invoice batch name (uniqueness enforced by the Invoice workbench) |
| BATCH_DATE | DATE | Yes | Invoice batch date | |
| 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). |
| CONTROL_INVOICE_COUNT | NUMBER | (15) | User entered control of number of invoices in batch | |
| CONTROL_INVOICE_TOTAL | NUMBER | User entered control of invoice amount total for invoices in batch | ||
| ACTUAL_INVOICE_COUNT | NUMBER | (15) | Not currently used | |
| ACTUAL_INVOICE_TOTAL | NUMBER | Not currently used | ||
| INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Currency code of invoice, overrides supplier invoice currency (may be left null for Multiple Currency Batches) | |
| PAYMENT_CURRENCY_CODE | VARCHAR2 | (15) | Currency code of payment (must be an associated fixed-rate currency or same as INVOICE_CURRENCY_CODE) | |
| 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). | |
| PAY_GROUP_LOOKUP_CODE | VARCHAR2 | (25) | Name of pay group. This value overrides supplier pay group | |
| BATCH_CODE_COMBINATION_ID | NUMBER | (15) | Accounting Flexfield identifier for accounts payable liability account, overrides supplier liability account | |
| TERMS_ID | NUMBER | (15) | Terms identifier, overrides supplier pay group | |
| 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 | |
| INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Default invoice type | |
| HOLD_LOOKUP_CODE | VARCHAR2 | (25) | Default invoice hold name | |
| HOLD_REASON | VARCHAR2 | (240) | Default hold reason for hold name | |
| DOC_CATEGORY_CODE | VARCHAR2 | (30) | Default Sequential Numbering (voucher number) document category | |
| ORG_ID | NUMBER | (15) | Organization identifier | |
| GL_DATE | DATE | GL Date to default to invoices | ||
| PAYMENT_PRIORITY | NUMBER | (2) | Number representing payment priority used to default down to invoices and payment schedules (1 to 99) |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, BATCH_NAME
, BATCH_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CONTROL_INVOICE_COUNT
, CONTROL_INVOICE_TOTAL
, ACTUAL_INVOICE_COUNT
, ACTUAL_INVOICE_TOTAL
, INVOICE_CURRENCY_CODE
, PAYMENT_CURRENCY_CODE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, PAY_GROUP_LOOKUP_CODE
, BATCH_CODE_COMBINATION_ID
, TERMS_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, INVOICE_TYPE_LOOKUP_CODE
, HOLD_LOOKUP_CODE
, HOLD_REASON
, DOC_CATEGORY_CODE
, ORG_ID
, GL_DATE
, PAYMENT_PRIORITY
FROM AP.AP_BATCHES_ALL;
AP.AP_BATCHES_ALL does not reference any database object
AP.AP_BATCHES_ALL is referenced by following:
AP
AP_BATCHES_ALL#
|
|
|
|