[Home] [Help] [Dependency Information]
Object Name: | CST_RCV_RAE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.CST_RCV_RAE_V |
Subobject Name: | |
Status: | VALID |
View on the Receiving Accounting events table. Selects information related to the receiving accounting event along with details of the receiving transaction, inventory organization, purchase order document, shipment, vendor etc
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Unique Row Identifier | |
ORGANIZATION_ID | NUMBER | Organization in which the accounting event is being generated | ||
OPERATING_UNIT_ID | NUMBER | Operating Unit in which the event is being generated | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Name of Inventory Organization | |
ORG_CODE | VARCHAR2 | (3) | Code of Inventory Organization | |
SET_OF_BOOKS_ID | NUMBER | (15) | Set Of Books Identifier | |
TRANSACTION_ID | NUMBER | Receiving Transaction Unique Identifier | ||
ACCOUNTING_EVENT_ID | NUMBER | Accounting Event Unique Identifier | ||
EVENT_TYPE_ID | NUMBER | Accounting Event Type Identifier | ||
EVENT_TYPE_NAME | VARCHAR2 | (240) | Accounting Event Type Name | |
TRANSACTION_DATE | DATE | Transaction date | ||
TRANSACTION_QUANTITY | NUMBER | Transaction Quantity | ||
TRANSACTION_UOM | VARCHAR2 | (3) | Transaction Unit of Measure | |
PRIMARY_QUANTITY | NUMBER | Transaction quantity in item's primary unit of measure. | ||
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Item primary unit of measure | |
PO_HEADER_ID | NUMBER | Purchase Order Header Unique Identifier | ||
PO_HEADER_NUM | VARCHAR2 | (50) | Purchase Order Number | |
PO_LINE_ID | NUMBER | Purchase Order Line Unique Identifier | ||
PO_LINE_NUM | VARCHAR2 | (240) | PO LIne Number | |
PO_DISTRIBUTION_ID | NUMBER | Purchase Order Distribution Unique Identifier | ||
PO_RELEASE_ID | NUMBER | Purchase Order Release Unique Identifier | ||
RELEASE_NUM | NUMBER | Release Number | ||
REQUISITION_ID | NUMBER | Requisition header unique identifier | ||
REQUISITION_NUM | VARCHAR2 | (20) | Requisition Number | |
REQUISITION_LINE_ID | NUMBER | Requisition line unique identifier | ||
REQUISITION_LINE_NUM | NUMBER | Requisition line number | ||
PO_VENDOR_ID | NUMBER | Supplier unique identifier | ||
PO_VENDOR_NAME | VARCHAR2 | (240) | Supplier name | |
PO_VENDOR_SITE_ID | NUMBER | Supplier site unique identifier | ||
PO_VENDOR_SITE_NAME | VARCHAR2 | (15) | Supplier site name | |
RECEIPT_NUM | VARCHAR2 | (30) | Receipt number | |
SHIPMENT_NUM | VARCHAR2 | (30) | Shipment number assigned by the shipment's source | |
SHIPMENT_HEADER_ID | NUMBER | Receipt header unique identifier | ||
RECEIPT_LINE_NUM | NUMBER | Receipt line number | ||
SHIPMENT_LINE_ID | NUMBER | Shipment line unique identifier | ||
RECEIVING_LOCATION_ID | NUMBER | Receiving location unique identifier | ||
INVENTORY_ITEM_ID | NUMBER | Item unique identifier | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
REVISION | VARCHAR2 | (3) | Item revision | |
UNIT_PRICE | NUMBER | Unit Price in PO unit of measure. Could be PO price or transfer price | ||
PRIOR_UNIT_PRICE | NUMBER | Prior unit price. Used only for retroactive pricing and landed cost adjustment events | ||
UNIT_LANDED_COST | NUMBER | Landed cost of the LCM shipment | ||
INTERCOMPANY_PRICING_OPTION | NUMBER | Flag that indicates if Unit Price is at PO price or Transfer Price. 1-PO price 2-Transfer price | ||
TRANSACTION_AMOUNT | NUMBER | Transaction Amount. Used only for service line types | ||
NR_TAX | NUMBER | Non-recoverable Tax | ||
REC_TAX | NUMBER | Recoverable Tax | ||
NR_TAX_AMOUNT | NUMBER | Nonrecoverable tax amount. Used for service line types. | ||
REC_TAX_AMOUNT | NUMBER | Recoverable tax amount. Used only for service line types. | ||
PRIOR_NR_TAX | NUMBER | Prior non-recoverable tax. Only applicable for retroactive pricing. | ||
PRIOR_REC_TAX | NUMBER | Prior recoverable tax. Only applicable for retroactive pricing. | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion date | ||
ACCOUNTED_FLAG | VARCHAR2 | (1) | Flag that indicates if accounting entries have been created for the accounting event | |
PROCUREMENT_ORG_FLAG | VARCHAR2 | (1) | Flag that indicates if event is for the supplier facing operating unit | |
CROSS_OU_FLAG | VARCHAR2 | (1) | Flag that indicates if transaction is for a PO that crosses operating units | |
TRX_FLOW_HEADER_ID | NUMBER | Identifier of the transaction flow being used for the event. Only applicable for Shared Services scenarios. | ||
INVOICED_FLAG | VARCHAR2 | (1) | Flag that indicates if the event has been processed by the Intercompany invoicing program. Only applicable to invoice match and invoice reversal events. | |
PA_ADDITION_FLAG | VARCHAR2 | (1) | Flag that indicates if project related receipts have been transferred to projects | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | Standard Who column | ||
LAST_UPDATE_LOGIN | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORGANIZATION_ID
, OPERATING_UNIT_ID
, ORGANIZATION_NAME
, ORG_CODE
, SET_OF_BOOKS_ID
, TRANSACTION_ID
, ACCOUNTING_EVENT_ID
, EVENT_TYPE_ID
, EVENT_TYPE_NAME
, TRANSACTION_DATE
, TRANSACTION_QUANTITY
, TRANSACTION_UOM
, PRIMARY_QUANTITY
, PRIMARY_UOM_CODE
, PO_HEADER_ID
, PO_HEADER_NUM
, PO_LINE_ID
, PO_LINE_NUM
, PO_DISTRIBUTION_ID
, PO_RELEASE_ID
, RELEASE_NUM
, REQUISITION_ID
, REQUISITION_NUM
, REQUISITION_LINE_ID
, REQUISITION_LINE_NUM
, PO_VENDOR_ID
, PO_VENDOR_NAME
, PO_VENDOR_SITE_ID
, PO_VENDOR_SITE_NAME
, RECEIPT_NUM
, SHIPMENT_NUM
, SHIPMENT_HEADER_ID
, RECEIPT_LINE_NUM
, SHIPMENT_LINE_ID
, RECEIVING_LOCATION_ID
, INVENTORY_ITEM_ID
, ITEM_DESCRIPTION
, REVISION
, UNIT_PRICE
, PRIOR_UNIT_PRICE
, UNIT_LANDED_COST
, INTERCOMPANY_PRICING_OPTION
, TRANSACTION_AMOUNT
, 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
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM APPS.CST_RCV_RAE_V;
APPS.CST_RCV_RAE_V is not referenced by any database object
|
|
|