[Home] [Help] [Dependency Information]
Object Name: | CST_MISC_RECONCILIATION |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.CST_MISC_RECONCILIATION |
Subobject Name: | |
Status: | VALID |
Table will be used in the accrual reconciliation process to handle miscellaneous AP transactions as well as any INV transaction that hit an accrual account
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CST_MISC_RECONCILIATION_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OPERATING_UNIT_ID
TRANSACTION_DATE |
CST_MISC_RECONCILIATION_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TRANSACTION_TYPE_CODE
INVOICE_DISTRIBUTION_ID |
CST_MISC_RECONCILIATION_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INVENTORY_TRANSACTION_ID
TRANSACTION_TYPE_CODE |
CST_MISC_RECONCILIATION_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PO_DISTRIBUTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_DATE | DATE | Yes | Transaction Date | |
AMOUNT | NUMBER | Yes | Transaction Amount | |
ENTERED_AMOUNT | NUMBER | Entered Transaction Amount | ||
QUANTITY | NUMBER | Transaction Quantity | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Type | ||
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
INVOICE_DISTRIBUTION_ID | NUMBER | Invoice Distribution Identifier | ||
INVENTORY_TRANSACTION_ID | NUMBER | Inventory Transaction Identifier | ||
PO_DISTRIBUTION_ID | NUMBER | PO Distribution Identifier | ||
ACCRUAL_ACCOUNT_ID | NUMBER | Yes | Accrual Account Identifier | |
TRANSACTION_TYPE_CODE | VARCHAR2 | (25) | Yes | Transaction Type Identifier |
INVENTORY_ITEM_ID | NUMBER | Item Identifier | ||
VENDOR_ID | NUMBER | Vendor Identifier | ||
INVENTORY_ORGANIZATION_ID | NUMBER | Organization Identifier | ||
WRITE_OFF_SELECT_FLAG | VARCHAR2 | (1) | Internal Record Selection | |
OPERATING_UNIT_ID | NUMBER | Yes | Operating Unit Identifier | |
BUILD_ID | NUMBER | Build Identifier | ||
AE_HEADER_ID | NUMBER | Accounting Header Identifier | ||
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
CREATION_DATE | DATE | Standard Who Column | ||
CREATED_BY | NUMBER | Standard Who Column | ||
REQUEST_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_ID | NUMBER | Concurrent Who Column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who Column | ||
AE_LINE_NUM | NUMBER | Accounting Line Number |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_DATE
, AMOUNT
, ENTERED_AMOUNT
, QUANTITY
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, INVOICE_DISTRIBUTION_ID
, INVENTORY_TRANSACTION_ID
, PO_DISTRIBUTION_ID
, ACCRUAL_ACCOUNT_ID
, TRANSACTION_TYPE_CODE
, INVENTORY_ITEM_ID
, VENDOR_ID
, INVENTORY_ORGANIZATION_ID
, WRITE_OFF_SELECT_FLAG
, OPERATING_UNIT_ID
, BUILD_ID
, AE_HEADER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, AE_LINE_NUM
FROM BOM.CST_MISC_RECONCILIATION;
BOM.CST_MISC_RECONCILIATION does not reference any database object
BOM.CST_MISC_RECONCILIATION is referenced by following:
|
|
|