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

TABLE: BOM.CST_PAC_ACCRUAL_WRITE_OFFS

Object Details
Object Name: CST_PAC_ACCRUAL_WRITE_OFFS
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.CST_PAC_ACCRUAL_WRITE_OFFS
Subobject Name:
Status: VALID


Stores the write-off information for Accrual Reconciliation


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CST_PAC_ACCRUAL_WRITE_OFFS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEGAL_ENTITY_ID
ColumnCOST_GROUP_ID
ColumnCOST_TYPE_ID
ColumnPERIOD_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_DATE DATE
Yes Original transaction
INVOICE_NUM VARCHAR2 (50)
Invoice number
RECEIPT_NUM VARCHAR2 (30)
Receipt number
PO_TRANSACTION_ID NUMBER

Receiving transaction unique identifier
INV_TRANSACTION_ID NUMBER

Inventory transaction unique identifier
INV_TRANSACTION_TYPE_ID NUMBER

Inventory transaction type unique identifier
WIP_TRANSACTION_ID NUMBER

WIP transaction unique identifier
WIP_TRANSACTION_TYPE_ID NUMBER

WIP transaction type unique identifier
INVENTORY_ITEM_ID NUMBER

Item unique identifier
PO_UNIT_OF_MEASURE VARCHAR2 (25)
PO unit of measure
PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)
Primary unit of measure for the item
TRANSACTION_QUANTITY NUMBER

Quantity for the transaction
NET_PO_LINE_QUANTITY NUMBER

PO line invoice quantity less receipt quantity
PO_HEADER_ID NUMBER

Document header unique identifier
PO_NUM VARCHAR2 (20)
PO number
PO_LINE_NUM NUMBER

PO line number
PO_LINE_ID NUMBER

Document line unique identifier
PO_DISTRIBUTION_ID NUMBER

Document distribution unique identifier
VENDOR_ID NUMBER

Supplier unique identifier
VENDOR_NAME VARCHAR2 (240)
Supplier name
TRANSACTION_UNIT_PRICE NUMBER

Unit price for the transaction
INVOICE_ID NUMBER

Invoice unique identifier
INVOICE_LINE_NUM NUMBER

Invoice distribution number
AVG_RECEIPT_PRICE NUMBER

Average receipt price for the purchase order line
TRANSACTION_AMOUNT NUMBER

Transaction debit or credit
LINE_MATCH_ORDER NUMBER

Line sequence number for printing Periodic Accrual Reconciliation report
TRANSACTION_SOURCE_CODE VARCHAR2 (25) Yes Transaction source or subledger
REASON_ID NUMBER

Transaction reason unique identifier
COMMENTS VARCHAR2 (240)
Comments for accrual write-off
WRITE_OFF_CODE VARCHAR2 (25)
Write-off status for the write-off transaction
DESTINATION_TYPE_CODE VARCHAR2 (25)
Destination type for the transaction
INVOICE_PRICE_VARIANCE NUMBER

For pre-release 10 transactions, the reported IPV
PERIOD_ID NUMBER

Periodic costing period unique identifier
WRITE_OFF_ID NUMBER
Yes Write-off unique identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
PERIOD_NAME VARCHAR2 (15)
Accounting period name
WRITE_OFF_GL_DATE DATE
Yes The General Ledger date for the manual journal entry
TRANSACTION_ORGANIZATION_ID NUMBER
Yes Organization where transaction took place
ITEM_MASTER_ORGANIZATION_ID NUMBER
Yes Item Master/ Purchasing reference organization
ACCRUAL_ACCOUNT_ID NUMBER
Yes Accrual account unique identifier
ACCRUAL_CODE VARCHAR2 (25) Yes Transaction type or A/P match condition
PO_TRANSACTION_TYPE VARCHAR2 (25)
Purchasing transaction date
LEGAL_ENTITY_ID NUMBER (15) Yes Legal entity unique identifier
COST_GROUP_ID NUMBER (15) Yes Cost group unique identifier
COST_TYPE_ID NUMBER (15) Yes Cost type unique identifier
ADJUSTMENT_TRANSACTION NUMBER

Specifies if the transaction is a retro active price adjustment
Query Text

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


SELECT TRANSACTION_DATE
,      INVOICE_NUM
,      RECEIPT_NUM
,      PO_TRANSACTION_ID
,      INV_TRANSACTION_ID
,      INV_TRANSACTION_TYPE_ID
,      WIP_TRANSACTION_ID
,      WIP_TRANSACTION_TYPE_ID
,      INVENTORY_ITEM_ID
,      PO_UNIT_OF_MEASURE
,      PRIMARY_UNIT_OF_MEASURE
,      TRANSACTION_QUANTITY
,      NET_PO_LINE_QUANTITY
,      PO_HEADER_ID
,      PO_NUM
,      PO_LINE_NUM
,      PO_LINE_ID
,      PO_DISTRIBUTION_ID
,      VENDOR_ID
,      VENDOR_NAME
,      TRANSACTION_UNIT_PRICE
,      INVOICE_ID
,      INVOICE_LINE_NUM
,      AVG_RECEIPT_PRICE
,      TRANSACTION_AMOUNT
,      LINE_MATCH_ORDER
,      TRANSACTION_SOURCE_CODE
,      REASON_ID
,      COMMENTS
,      WRITE_OFF_CODE
,      DESTINATION_TYPE_CODE
,      INVOICE_PRICE_VARIANCE
,      PERIOD_ID
,      WRITE_OFF_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PERIOD_NAME
,      WRITE_OFF_GL_DATE
,      TRANSACTION_ORGANIZATION_ID
,      ITEM_MASTER_ORGANIZATION_ID
,      ACCRUAL_ACCOUNT_ID
,      ACCRUAL_CODE
,      PO_TRANSACTION_TYPE
,      LEGAL_ENTITY_ID
,      COST_GROUP_ID
,      COST_TYPE_ID
,      ADJUSTMENT_TRANSACTION
FROM BOM.CST_PAC_ACCRUAL_WRITE_OFFS;

Dependencies

[top of page]

BOM.CST_PAC_ACCRUAL_WRITE_OFFS does not reference any database object

BOM.CST_PAC_ACCRUAL_WRITE_OFFS is referenced by following:

SchemaAPPS
SynonymCST_PAC_ACCRUAL_WRITE_OFFS