ORACLE
EBS Data Intelligence Analytics
Table Documentation / DW_EB_X_EBS_PROC_W_PURCH_CYCLE_LINE_A

DW_EB_X_EBS_PROC_W_PURCH_CYCLE_LINE_A

This is an aggregate table of DW_EB_X_EBS_PROC_W_PURCH_CYCLE_LINE_F at a higher level of dimentionality. The Product dimension is replaced by a Product type dimension to give a high level analysis of the sourcing data. It stores Purchase Cycle Line records aggregated over a preconfigured Monthly time period and product types.

Details

Module: Procurement (EBS_PROC)

Business Name: Purchase Cycle Line Aggregate

Key Columns

Key column information is not documented in the supplied metadata.

Columns

Columns
NameDatatypeLengthPrecisionNot NullCommentsReferred Table
COMPANY_ORG_WIDNUMBER38This is the default financial entity (or Company Org) into which the accounting transactions generated through the execution of the purchases order are posted into. This links to the "COMPANY" type rows within DW_EB_X_EBS_COMMON_W_INT_ORG_D dimension table. Lookup
CONSIGNED_TYPE_WIDNUMBER38Foreign key to the DW_EB_X_EBS_COMMON_W_XACT_TYPE_D dimension indicating whether it's a regular PO, consigned PO or consumption advice.DW_EB_X_EBS_COMMON_W_XACT_TYPE_D
DATASOURCE_NUM_IDNUMBER10This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances.
DOC_STYLE_WIDNUMBER38DW_EB_X_EBS_COMMON_W_XACT_TYPE_D
LINE_TYPE_WIDNUMBER38This column is used as a generic field for customer extensions.DW_EB_X_EBS_COMMON_W_XACT_TYPE_D
LOC_CURR_CODEVARCHAR230 CHARThis code corresponds to the local currency. The local currency typically is the one in which the transaction will be posted to meet legal requirements for Company's Financial reporting. Alternatively, it may be linked to the currency used by local/regional business units for reporting purposes.
OPERATING_UNIT_ORG_WIDNUMBER38Identifies the operating unit organization.DW_EB_X_EBS_COMMON_W_INT_ORG_D
ORDER_UOM_CODEVARCHAR250 CHARThe unit of measure of this group of purchase order schedule lines -- this could be different from the inventory unit of measure in which the product is stored at the receipt location. The price on the purchase order schedule line is for a unit of the product in this UOM. Example: Each, Pound, Ton...
PERIOD_END_DT_WIDNUMBER38This indicates the last day of the aggregation period in which this group of purchase orders have been ordered.DW_EB_X_EBS_COMMON_W_DAY_D
PERIOD_START_DT_WIDNUMBER38This indicates the first day of the aggregation period in which this group of purchase orders have been ordered.DW_EB_X_EBS_COMMON_W_DAY_D
PO_STATUS_WIDNUMBER38PO_STATUS_WID
PRODUCT_TYPE_WIDNUMBER38This indicates the product which is being sourced from the supplier on the purchase order schedule line. Lookup: DW_EB_X_EBS_COMMON_W_PRODUCT_D Example :Spray paint, auto exhaust pump, IBM laptop T-Series 230DW_EB_X_EBS_COMMON_W_PRODUCT_TYPE_D
PURCH_ORG_WIDNUMBER38This indicates the purchasing organization that has generated the purchase order -- usually represents the purchasing unit of a large business organization. The link to the "PURCH" type rows within DW_EB_X_EBS_COMMON_W_INT_ORG_D dimension table. Lookup: DW_EB_X_EBS_COMMON_W_INT_ORG_DDW_EB_X_EBS_COMMON_W_INT_ORG_D
SUPPLIER_ACCOUNT_WIDNUMBER38Foreign key to DW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D dimensionDW_EB_X_EBS_COMMON_W_SUPPLIER_ACCOUNT_D
SUPPLIER_WIDNUMBER38This indicates the supplier on whom the purchase order has been placed. The link to the W_SUPPLIER_D dimension. Lookup: W_SUPPLIER_D Example : Circuit City, Good Guys etc. for any electronic equipmentDW_EB_X_EBS_COMMON_W_PARTY_ORG_D
TENANT_IDVARCHAR280 CHARThis column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model.
XACT_TYPE_WIDNUMBER38This indicates the specific type of the purchase order. There could be further sub-classifications to these purchase order types. There could be domain values mapped for each of these transactions into the W_type domain value columns in DW_EB_X_EBS_COMMON_W_XACT_TYPE_D.DW_EB_X_EBS_COMMON_W_XACT_TYPE_D
ACCEPTED_QTYNUMBER28,10The total quantity of the product type (purchase order UOM) that has passed acceptance tests. The accepted quantity could be less than or equal to the received quantity.
CANCELLED_QTYNUMBER28,10The quantity of the product (in purchase order UOM) that has been cancelled on the purchase order schedule line.
DOC_ACCEPTED_AMTNUMBER38,10
DOC_CANCELLED_AMTNUMBER38,10
DOC_INVOICE_AMTNUMBER38,10
DOC_LINE_AMTNUMBER38,10
DOC_RECEIVED_AMTNUMBER38,10
DOC_RECEIVED_EARLY_AMTNUMBER38,10
DOC_RECEIVED_LATE_AMTNUMBER38,10
DOC_RECEIVED_ONTIME_AMTNUMBER38,10
DOC_REJECTED_AMTNUMBER38,10
DOC_RETURNED_AMTNUMBER38,10
DOC_SHIPPED_AMTNUMBER38,10
DOC_SHIPPED_EARLY_AMTNUMBER38,10
DOC_SHIPPED_LATE_AMTNUMBER38,10
DOC_SHIPPED_ONTIME_AMTNUMBER38,10
DOC_STD_COST_AMTNUMBER38,10
ETL_PROC_WIDNUMBER38This column is used as a generic field for customer extensions.
GLOBAL1_ACCEPTED_AMTNUMBER38,10The total currency value of the accepted purchase order schedule lines in Global1 currency.
GLOBAL1_CANCELLED_AMTNUMBER38,10The currency value of the cancelled purchase order schedule line in Global1 currency.
GLOBAL1_INVOICE_AMTNUMBER38,10
GLOBAL1_LINE_AMTNUMBER38,10The currency value of this group of purchase schedule lines in Global1 currency(including Discounts and Surcharges).
GLOBAL1_RECEIVED_AMTNUMBER38,10The total currency value of the received purchase order schedule lines in this group in Global1 currency.
GLOBAL1_RECEIVED_EARLY_AMTNUMBER38,10Total Currency value on all the purchase schedule lines that has been received (in purchase order UOM) prior to the due date in Global1 currency.
GLOBAL1_RECEIVED_LATE_AMTNUMBER38,10Currency value of all the purchase schedule lines that has been received (in purchase order UOM) after the due date in Global1 currency.
GLOBAL1_RECEIVED_ONTIME_AMTNUMBER38,10Total Currency value of all the purchase schedule lines that have been received (in purchase order UOM) on the due date in Global1 currency.
GLOBAL1_REJECTED_AMTNUMBER38,10The total currency value (by product type ) of all the rejected purchase order schedule lines in Global1 currency.
GLOBAL1_RETURNED_AMTNUMBER38,10
GLOBAL1_SHIPPED_AMTNUMBER38,10
GLOBAL1_SHIPPED_EARLY_AMTNUMBER38,10
GLOBAL1_SHIPPED_LATE_AMTNUMBER38,10
GLOBAL1_SHIPPED_ONTIME_AMTNUMBER38,10
GLOBAL1_STD_COST_AMTNUMBER38,10Standard Cost Amount in Global1 currency.
GLOBAL2_ACCEPTED_AMTNUMBER38,10The total currency value of the accepted purchase order schedule lines in Global2 currency.
GLOBAL2_CANCELLED_AMTNUMBER38,10The currency value of the cancelled purchase order schedule line in Global2 currency.
GLOBAL2_INVOICE_AMTNUMBER38,10
GLOBAL2_LINE_AMTNUMBER38,10The currency value of this group of purchase schedule lines in Global2 currency(including Discounts and Surcharges).
GLOBAL2_RECEIVED_AMTNUMBER38,10The total currency value of the received purchase order schedule lines in this group in Global2 currency.
GLOBAL2_RECEIVED_EARLY_AMTNUMBER38,10Total Currency value on all the purchase schedule lines that has been received (in purchase order UOM) prior to the due date in Global2 currency.
GLOBAL2_RECEIVED_LATE_AMTNUMBER38,10Currency value of all the purchase schedule lines that has been received (in purchase order UOM) after the due date in Global2 currency.
GLOBAL2_RECEIVED_ONTIME_AMTNUMBER38,10Total Currency value of all the purchase schedule lines that have been received (in purchase order UOM) on the due date in Global2 currency.
GLOBAL2_REJECTED_AMTNUMBER38,10The total currency value (by product type ) of all the rejected purchase order schedule lines in Global2 currency.
GLOBAL2_RETURNED_AMTNUMBER38,10
GLOBAL2_SHIPPED_AMTNUMBER38,10
GLOBAL2_SHIPPED_EARLY_AMTNUMBER38,10
GLOBAL2_SHIPPED_LATE_AMTNUMBER38,10
GLOBAL2_SHIPPED_ONTIME_AMTNUMBER38,10
GLOBAL2_STD_COST_AMTNUMBER38,10Standard Cost Amount in Global2 currency.
GLOBAL3_ACCEPTED_AMTNUMBER38,10The total currency value of the accepted purchase order schedule lines in Global3 currency.
GLOBAL3_CANCELLED_AMTNUMBER38,10The currency value of the cancelled purchase order schedule line in Global3 currency.
GLOBAL3_INVOICE_AMTNUMBER38,10
GLOBAL3_LINE_AMTNUMBER38,10The currency value of this group of purchase schedule lines in Global3 currency(including Discounts and Surcharges).
GLOBAL3_RECEIVED_AMTNUMBER38,10The total currency value of the received purchase order schedule lines in this group in Global3 currency.
GLOBAL3_RECEIVED_EARLY_AMTNUMBER38,10Total Currency value on all the purchase schedule lines that has been received (in purchase order UOM) prior to the due date in Global3 currency.
GLOBAL3_RECEIVED_LATE_AMTNUMBER38,10Currency value of all the purchase schedule lines that has been received (in purchase order UOM) after the due date in Global1 currency.
GLOBAL3_RECEIVED_ONTIME_AMTNUMBER38,10Total Currency value of all the purchase schedule lines that have been received (in purchase order UOM) on the due date in Global3 currency.
GLOBAL3_REJECTED_AMTNUMBER38,10The total currency value (by product type ) of all the rejected purchase order schedule lines in Global3 currency.
GLOBAL3_RETURNED_AMTNUMBER38,10
GLOBAL3_SHIPPED_AMTNUMBER38,10
GLOBAL3_SHIPPED_EARLY_AMTNUMBER38,10
GLOBAL3_SHIPPED_LATE_AMTNUMBER38,10
GLOBAL3_SHIPPED_ONTIME_AMTNUMBER38,10
GLOBAL3_STD_COST_AMTNUMBER38,10Standard Cost Amount in Global3 currency.
LOC_ACCEPTED_AMTNUMBER38,10The total currency value of the accepted purchase order schedule lines in local or regional currency.
LOC_CANCELLED_AMTNUMBER38,10The currency value of the cancelled purchase order schedule line in local or transaction currency.
LOC_INVOICE_AMTNUMBER38,10
LOC_LINE_AMTNUMBER38,10The currency value of this group of purchase schedule lines in local or regional currency.
LOC_RECEIVED_AMTNUMBER38,10The total currency value of the received purchase order schedule lines in this group in local or regional currency.
LOC_RECEIVED_EARLY_AMTNUMBER38,10Total Currency value on all the purchase schedule lines that has been received (in purchase order UOM) prior to the due date.
LOC_RECEIVED_LATE_AMTNUMBER38,10Currency value of all the purchase schedule lines that has been received (in purchase order UOM) after the due date
LOC_RECEIVED_ONTIME_AMTNUMBER38,10Total Currency value of all the purchase schedule lines that have been received (in purchase order UOM) on the due date.
LOC_REJECTED_AMTNUMBER38,10The total currency value (by product type ) of all the rejected purchase order schedule lines in local or regional currency.
LOC_RETURNED_AMTNUMBER38,10
LOC_SHIPPED_AMTNUMBER38,10
LOC_SHIPPED_EARLY_AMTNUMBER38,10
LOC_SHIPPED_LATE_AMTNUMBER38,10
LOC_SHIPPED_ONTIME_AMTNUMBER38,10
LOC_STD_COST_AMTNUMBER38,10Standard Cost Amount in local currency.
ORDERED_QTYNUMBER28,10The quantity of the product (in purchase order UOM) that has been scheduled to be received on the purchase order schedule line.
RECEIVED_EARLY_QTYNUMBER28,10The quantity of the product type on this group of purchase schedule lines that has been received (in purchase order UOM) prior to the due date.
RECEIVED_LATE_QTYNUMBER28,10The total quantity of the product type on this group of purchase schedule lines that has been received (in purchase order UOM) after the due date.
RECEIVED_ONTIME_QTYNUMBER28,10The total quantity of the product type on this group of purchase schedule lines that has been received (in purchase order UOM) on the due date.
RECEIVED_QTYNUMBER28,10The total quantity of the product type (in purchase order UOM) that has been received to date for this group of purchase order schedule lines.
REJECTED_QTYNUMBER28,10The total quantity of the product type (purchase order UOM) that has NOT passed acceptance tests. The rejected quantity would be <= received quantity.
RETURNED_QTYNUMBER28,10
ROW_WIDNUMBER38Surrogate key to uniquely identify a record.
SHIPPED_EARLY_QTYNUMBER28,10
SHIPPED_LATE_QTYNUMBER28,10
SHIPPED_ONTIME_QTYNUMBER28,10
SHIPPED_QTYNUMBER28,10
W$_INSERT_DTTIMESTAMP6
W$_UPDATE_DTTIMESTAMP6