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

TABLE: PO.PO_ACCRUAL_WRITE_OFFS_ALL

Object Details
Object Name: PO_ACCRUAL_WRITE_OFFS_ALL
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_ACCRUAL_WRITE_OFFS_ALL
Subobject Name:
Status: VALID


PO_ACCRUAL_WRITE_OFFS_ALL holds the accounts payable write-offs,
created by the Accrual Write-Offs window. You may write off and reverse a
write-off at any time. You never change or remove an existing row, you
always add more rows. The Accrual Reconciliation Report can exclude
written-off transactions, since the underlying table,
PO_ACCRUAL_RECONCILE_TEMP_ALL has the WRITE_OFF_ID, which is the
unique identifier for the PO_ACCRUAL_WRITE_OFFS_ALL table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PO_ACCRUAL_WRITE_OFFS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWRITE_OFF_ID
PO_ACCRUAL_WRITE_OFFS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_DISTRIBUTION_ID
ColumnPO_TRANSACTION_ID
PO_ACCRUAL_WRITE_OFFS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVOICE_ID
ColumnINVOICE_LINE_NUM
PO_ACCRUAL_WRITE_OFFS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINV_TRANSACTION_ID
PO_ACCRUAL_WRITE_OFFS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWIP_TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
WRITE_OFF_ID NUMBER
Yes Write-off unique identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
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 (25) Yes Accrual account unique identifier
ACCRUAL_CODE VARCHAR2 (80) Yes Type of transaction or A/P match condition
PO_TRANSACTION_TYPE VARCHAR2 (25)
Purchasing transaction code
TRANSACTION_DATE DATE
Yes Original transaction date
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)
Purchasing 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 the receipt quantity
PO_HEADER_ID NUMBER

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

Purchase order 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 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 the 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 the 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
ORG_ID NUMBER

Organization identifier
ADJUSTMENT_TRANSACTION NUMBER

Specifies if the transaction is a retroactive price adjustment
ENTERED_TRANSACTION_AMOUNT NUMBER

Transaction amount in the entered currency
CURRENCY_CODE VARCHAR2 (15)
Currency code of the entered currency
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion type used
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion rate used
CURRENCY_CONVERSION_DATE DATE

Currency conversion date
Query Text

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


SELECT 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
,      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
,      ORG_ID
,      ADJUSTMENT_TRANSACTION
,      ENTERED_TRANSACTION_AMOUNT
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
FROM PO.PO_ACCRUAL_WRITE_OFFS_ALL;

Dependencies

[top of page]

PO.PO_ACCRUAL_WRITE_OFFS_ALL does not reference any database object

PO.PO_ACCRUAL_WRITE_OFFS_ALL is referenced by following:

SchemaPO
ViewPO_ACCRUAL_WRITE_OFFS_ALL#