[Home] [Help] [Dependency Information]
Object Name: | RCV_ACCOUNTING_EVENTS# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNTING_EVENT_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UDPATE_DATE | DATE | |||
RCV_TRANSACTION_ID | NUMBER | |||
EVENT_TYPE_ID | NUMBER | Yes | ||
EVENT_SOURCE | VARCHAR2 | (25) | Yes | |
EVENT_SOURCE_ID | NUMBER | |||
SET_OF_BOOKS_ID | NUMBER | |||
ORG_ID | NUMBER | |||
TRANSFER_ORG_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
TRANSFER_ORGANIZATION_ID | NUMBER | |||
DEBIT_ACCOUNT_ID | NUMBER | |||
CREDIT_ACCOUNT_ID | NUMBER | |||
TRANSACTION_DATE | DATE | |||
TRANSACTION_QUANTITY | NUMBER | |||
TRANSACTION_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
SOURCE_DOC_QUANTITY | NUMBER | |||
SOURCE_DOC_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
PRIMARY_QUANTITY | NUMBER | |||
PRIMARY_UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
INVENTORY_ITEM_ID | NUMBER | |||
PO_HEADER_ID | NUMBER | |||
PO_RELEASE_ID | NUMBER | |||
PO_LINE_ID | NUMBER | |||
PO_LINE_LOCATION_ID | NUMBER | |||
PO_DISTRIBUTION_ID | NUMBER | |||
INTERCOMPANY_PRICING_OPTION | NUMBER | |||
UNIT_PRICE | NUMBER | |||
TRANSACTION_AMOUNT | NUMBER | |||
PRIOR_UNIT_PRICE | NUMBER | |||
NR_TAX | NUMBER | |||
REC_TAX | NUMBER | |||
NR_TAX_AMOUNT | NUMBER | |||
REC_TAX_AMOUNT | NUMBER | |||
PRIOR_NR_TAX | NUMBER | |||
PRIOR_REC_TAX | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CURRENCY_CONVERSION_DATE | DATE | |||
ACCOUNTED_FLAG | VARCHAR2 | (1) | ||
PROCUREMENT_ORG_FLAG | VARCHAR2 | (1) | ||
CROSS_OU_FLAG | VARCHAR2 | (1) | ||
TRX_FLOW_HEADER_ID | NUMBER | |||
INVOICED_FLAG | VARCHAR2 | (1) | ||
PA_ADDITION_FLAG | VARCHAR2 | (1) | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (32) | ||
GL_GROUP_ID | NUMBER | |||
QUANTITY_RECEIVED | NUMBER | |||
QUANTITY_INVOICED | NUMBER | |||
AMOUNT_RECEIVED | NUMBER | |||
AMOUNT_INVOICED | NUMBER | |||
LCM_ACCOUNT_ID | NUMBER | |||
UNIT_LANDED_COST | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNTING_EVENT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UDPATE_DATE
, RCV_TRANSACTION_ID
, EVENT_TYPE_ID
, EVENT_SOURCE
, EVENT_SOURCE_ID
, SET_OF_BOOKS_ID
, ORG_ID
, TRANSFER_ORG_ID
, ORGANIZATION_ID
, TRANSFER_ORGANIZATION_ID
, DEBIT_ACCOUNT_ID
, CREDIT_ACCOUNT_ID
, TRANSACTION_DATE
, TRANSACTION_QUANTITY
, TRANSACTION_UNIT_OF_MEASURE
, SOURCE_DOC_QUANTITY
, SOURCE_DOC_UNIT_OF_MEASURE
, PRIMARY_QUANTITY
, PRIMARY_UNIT_OF_MEASURE
, INVENTORY_ITEM_ID
, PO_HEADER_ID
, PO_RELEASE_ID
, PO_LINE_ID
, PO_LINE_LOCATION_ID
, PO_DISTRIBUTION_ID
, INTERCOMPANY_PRICING_OPTION
, UNIT_PRICE
, TRANSACTION_AMOUNT
, PRIOR_UNIT_PRICE
, NR_TAX
, REC_TAX
, NR_TAX_AMOUNT
, REC_TAX_AMOUNT
, PRIOR_NR_TAX
, PRIOR_REC_TAX
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
, ACCOUNTED_FLAG
, PROCUREMENT_ORG_FLAG
, CROSS_OU_FLAG
, TRX_FLOW_HEADER_ID
, INVOICED_FLAG
, PA_ADDITION_FLAG
, USSGL_TRANSACTION_CODE
, GL_GROUP_ID
, QUANTITY_RECEIVED
, QUANTITY_INVOICED
, AMOUNT_RECEIVED
, AMOUNT_INVOICED
, LCM_ACCOUNT_ID
, UNIT_LANDED_COST
FROM PO.RCV_ACCOUNTING_EVENTS#;
|
|
|