Requisition Item
Table
Columns
| Property |
Db Table |
Db Column |
Db DataType |
Nullable |
Primary Key |
Joins |
CreatedByUserId |
mm.requisition_item |
created_by_user_id |
bigint |
False |
|
|
CreatedByUserCode |
uam.user |
code |
character varying(50) |
False |
|
mm.requisition_item.created_by_user_id = uam.user.user_id |
CreatedByUserFullName |
uam.user |
full_name |
character varying(200) |
False |
|
mm.requisition_item.created_by_user_id = uam.user.user_id |
CreatedOn |
mm.requisition_item |
created_on |
timestamp without time zone |
False |
|
|
ModifiedByUserId |
mm.requisition_item |
modified_by_user_id |
bigint |
False |
|
|
ModifiedByUserCode |
uam.user |
code |
character varying(50) |
False |
|
mm.requisition_item.modified_by_user_id = uam.user.user_id |
ModifiedByUserFullName |
uam.user |
full_name |
character varying(200) |
False |
|
mm.requisition_item.modified_by_user_id = uam.user.user_id |
ModifiedOn |
mm.requisition_item |
modified_on |
timestamp without time zone |
False |
|
|
Version |
mm.requisition_item |
version |
integer |
False |
|
|
PermissionTreeId |
mm.requisition_item |
permission_tree_id |
bigint |
False |
|
|
PermissionTreeCode |
uam.permission_tree |
code |
text |
False |
|
mm.requisition_item.permission_tree_id = uam.permission_tree.permission_tree_id |
PermissionTreeDescription |
uam.permission_tree |
description |
text |
True |
|
mm.requisition_item.permission_tree_id = uam.permission_tree.permission_tree_id |
Id |
mm.requisition_item |
requisition_item_id |
bigint |
False |
True |
|
LineNumber |
mm.requisition_item |
line_number |
integer |
False |
|
|
ApprovalWorkflowProgress |
mm.requisition_item |
approval_workflow_progress |
mm.approval_workflow_progress |
True |
|
|
Notes |
mm.requisition_item |
notes |
text |
True |
|
|
QuantityIssued |
mm.requisition_item |
quantity_issued |
numeric(19,4) |
False |
|
|
QuantityNotIssued |
mm.requisition_item |
quantity_not_issued |
numeric(19,4) |
False |
|
|
QuantityOrdered |
mm.requisition_item |
quantity_ordered |
numeric(19,4) |
True |
|
|
QuantityRequired |
mm.requisition_item |
quantity_required |
numeric(19,4) |
False |
|
|
QuantityReserved |
mm.requisition_item |
quantity_reserved |
numeric(19,4) |
True |
|
|
RequisitionId |
mm.requisition_item |
requisition_id |
bigint |
False |
|
|
RequisitionCode |
mm.requisition |
code |
character varying(50) |
False |
|
mm.requisition_item.requisition_id = mm.requisition.requisition_id |
RequisitionRequestedOn |
mm.requisition |
requested_on |
timestamp without time zone |
False |
|
mm.requisition_item.requisition_id = mm.requisition.requisition_id |
RequisitionStatusId |
mm.requisition_status |
requisition_status_id |
bigint |
False |
True |
mm.requisition_item.requisition_id = mm.requisition.requisition_id Then
mm.requisition.requisition_status_id = mm.requisition_status.requisition_status_id |
RequisitionStatusBaseStatus |
mm.requisition_status |
base_status |
mm.requisition_status_base_status |
False |
|
mm.requisition_item.requisition_id = mm.requisition.requisition_id Then
mm.requisition.requisition_status_id = mm.requisition_status.requisition_status_id |
SequenceNumber |
mm.requisition_item |
sequence_number |
integer |
True |
|
|
TotalCostInSiteCurrency |
mm.requisition_item |
total_cost_in_site_currency |
numeric(21,4) |
False |
|
|
TotalCostInSpareCurrency |
mm.requisition_item |
total_cost_in_spare_currency |
numeric(21,4) |
False |
|
|
WorkOrderTaskSpareId |
mm.requisition_item |
work_order_task_spare_id |
bigint |
False |
|
|
WorkOrderTaskSpareCode |
wm.work_order_task_spare |
code |
character varying |
True |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id |
WorkOrderTaskSpareDescription |
wm.work_order_task_spare |
description |
character varying |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id |
WorkOrderTaskSpareSpareType |
wm.work_order_task_spare |
spare_type |
wm.spare_type |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id |
WorkOrderTaskSpareUnitPriceInSpareCurrency |
wm.work_order_task_spare |
unit_price_in_spare_currency |
numeric(21,4) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id |
WorkOrderTaskSpareUnitPriceInWorkOrderCurrency |
wm.work_order_task_spare |
unit_price_in_work_order_currency |
numeric(21,4) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id |
WorkOrderTaskSpareCostCentreId |
fin.cost_centre |
cost_centre_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.cost_centre_id = fin.cost_centre.cost_centre_id |
WorkOrderTaskSpareCostCentreCode |
fin.cost_centre |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.cost_centre_id = fin.cost_centre.cost_centre_id |
WorkOrderTaskSpareCostCentreDescription |
fin.cost_centre |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.cost_centre_id = fin.cost_centre.cost_centre_id |
WorkOrderTaskSpareCostElementId |
fin.cost_element |
cost_element_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.cost_element_id = fin.cost_element.cost_element_id |
WorkOrderTaskSpareCostElementCode |
fin.cost_element |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.cost_element_id = fin.cost_element.cost_element_id |
WorkOrderTaskSpareCostElementDescription |
fin.cost_element |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.cost_element_id = fin.cost_element.cost_element_id |
WorkOrderTaskSpareGeneralLedgerId |
fin.general_ledger |
general_ledger_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.general_ledger_id = fin.general_ledger.general_ledger_id |
WorkOrderTaskSpareGeneralLedgerCode |
fin.general_ledger |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.general_ledger_id = fin.general_ledger.general_ledger_id |
WorkOrderTaskSpareGeneralLedgerDescription |
fin.general_ledger |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.general_ledger_id = fin.general_ledger.general_ledger_id |
WorkOrderTaskSpareSpareCurrencyId |
fin.currency |
currency_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.spare_currency_id = fin.currency.currency_id |
WorkOrderTaskSpareSpareCurrencyCode |
fin.currency |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.spare_currency_id = fin.currency.currency_id |
WorkOrderTaskSpareSpareCurrencyDescription |
fin.currency |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.spare_currency_id = fin.currency.currency_id |
WorkOrderTaskSpareStockItemId |
mm.stock_item |
stock_item_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.stock_item_id = mm.stock_item.stock_item_id |
WorkOrderTaskSpareStockItemMaterialMasterId |
mm.material_master |
material_master_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.stock_item_id = mm.stock_item.stock_item_id Then
mm.stock_item.material_master_id = mm.material_master.material_master_id |
WorkOrderTaskSpareStockItemMaterialMasterCode |
mm.material_master |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.stock_item_id = mm.stock_item.stock_item_id Then
mm.stock_item.material_master_id = mm.material_master.material_master_id |
WorkOrderTaskSpareStockItemMaterialMasterDescription |
mm.material_master |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.stock_item_id = mm.stock_item.stock_item_id Then
mm.stock_item.material_master_id = mm.material_master.material_master_id |
WorkOrderTaskSpareStockItemWarehouseId |
mm.warehouse |
warehouse_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.stock_item_id = mm.stock_item.stock_item_id Then
mm.stock_item.warehouse_id = mm.warehouse.warehouse_id |
WorkOrderTaskSpareStockItemWarehouseCode |
mm.warehouse |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.stock_item_id = mm.stock_item.stock_item_id Then
mm.stock_item.warehouse_id = mm.warehouse.warehouse_id |
WorkOrderTaskSpareSupplierId |
gen.supplier |
supplier_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.supplier_id = gen.supplier.supplier_id |
WorkOrderTaskSpareSupplierCode |
gen.supplier |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.supplier_id = gen.supplier.supplier_id |
WorkOrderTaskSpareSupplierDescription |
gen.supplier |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.supplier_id = gen.supplier.supplier_id |
WorkOrderTaskSpareUnitOfMeasurementId |
gen.unit_of_measurement |
unit_of_measurement_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
WorkOrderTaskSpareUnitOfMeasurementCode |
gen.unit_of_measurement |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
WorkOrderTaskSpareUnitOfMeasurementDescription |
gen.unit_of_measurement |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
WorkOrderTaskSpareWorkOrderCurrencyId |
fin.currency |
currency_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.work_order_currency_id = fin.currency.currency_id |
WorkOrderTaskSpareWorkOrderCurrencyCode |
fin.currency |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.work_order_currency_id = fin.currency.currency_id |
WorkOrderTaskSpareWorkOrderCurrencyDescription |
fin.currency |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.work_order_currency_id = fin.currency.currency_id |
WorkOrderTaskSpareWorkOrderTaskId |
wm.work_order_task |
work_order_task_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.work_order_task_id = wm.work_order_task.work_order_task_id |
WorkOrderTaskSpareWorkOrderTaskTaskCode |
wm.work_order_task |
task_code |
character varying |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.work_order_task_id = wm.work_order_task.work_order_task_id |
WorkOrderTaskSpareWorkOrderTaskTaskDescription |
wm.work_order_task |
task_description |
character varying |
False |
|
mm.requisition_item.work_order_task_spare_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.work_order_task_id = wm.work_order_task.work_order_task_id |
WorkOrderTaskSpareInfoId |
wm.work_order_task_spare |
work_order_task_spare_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id |
Code |
wm.work_order_task_spare |
code |
character varying |
True |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id |
CostCentreId |
wm.work_order_task_spare |
cost_centre_id |
bigint |
False |
|
|
CostCentreDescription |
fin.cost_centre |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.cost_centre_id = fin.cost_centre.cost_centre_id |
CostCentreCode |
fin.cost_centre |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.cost_centre_id = fin.cost_centre.cost_centre_id |
CostElementId |
wm.work_order_task_spare |
cost_element_id |
bigint |
False |
|
|
CostElementDescription |
fin.cost_element |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.cost_element_id = fin.cost_element.cost_element_id |
CostElementCode |
fin.cost_element |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.cost_element_id = fin.cost_element.cost_element_id |
Description |
wm.work_order_task_spare |
description |
character varying |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id |
FinancialYearPeriodId |
wm.work_order_task_spare |
financial_year_period_id |
bigint |
True |
|
|
FinancialYearPeriodDescription |
fin.financial_year_period |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.financial_year_period_id = fin.financial_year_period.financial_year_period_id |
FinancialYearPeriodCode |
fin.financial_year_period |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.financial_year_period_id = fin.financial_year_period.financial_year_period_id |
GeneralLedgerId |
wm.work_order_task_spare |
general_ledger_id |
bigint |
False |
|
|
GeneralLedgerDescription |
fin.general_ledger |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.general_ledger_id = fin.general_ledger.general_ledger_id |
GeneralLedgerCode |
fin.general_ledger |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.general_ledger_id = fin.general_ledger.general_ledger_id |
RequiredOn |
wm.work_order_task_spare |
required_on |
timestamp without time zone |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id |
SpareToWorkOrderCurrencyRateValue |
wm.work_order_task_spare |
spare_to_work_order_currency_rate_value |
numeric |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id |
SpareType |
wm.work_order_task_spare |
spare_type |
wm.spare_type |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id |
StockItemId |
wm.work_order_task_spare |
stock_item_id |
bigint |
True |
|
|
StockItemAlternativeDescription |
mm.stock_item |
alternative_description |
character varying(500) |
True |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.stock_item_id = mm.stock_item.stock_item_id |
StockItemMaterialMasterId |
mm.material_master |
material_master_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.stock_item_id = mm.stock_item.stock_item_id Then
mm.stock_item.material_master_id = mm.material_master.material_master_id |
StockItemMaterialMasterCode |
mm.material_master |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.stock_item_id = mm.stock_item.stock_item_id Then
mm.stock_item.material_master_id = mm.material_master.material_master_id |
StockItemWarehouseId |
mm.warehouse |
warehouse_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.stock_item_id = mm.stock_item.stock_item_id Then
mm.stock_item.warehouse_id = mm.warehouse.warehouse_id |
StockItemWarehouseCode |
mm.warehouse |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.stock_item_id = mm.stock_item.stock_item_id Then
mm.stock_item.warehouse_id = mm.warehouse.warehouse_id |
SupplierId |
wm.work_order_task_spare |
supplier_id |
bigint |
True |
|
|
SupplierDescription |
gen.supplier |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.supplier_id = gen.supplier.supplier_id |
SupplierCode |
gen.supplier |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.supplier_id = gen.supplier.supplier_id |
UnitOfMeasurementId |
wm.work_order_task_spare |
unit_of_measurement_id |
bigint |
True |
|
|
UnitOfMeasurementDescription |
gen.unit_of_measurement |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
UnitOfMeasurementCode |
gen.unit_of_measurement |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.unit_of_measurement_id = gen.unit_of_measurement.unit_of_measurement_id |
UnitPriceInSpareCurrency |
wm.work_order_task_spare |
unit_price_in_spare_currency |
numeric(21,4) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id |
WorkOrderTaskId |
wm.work_order_task_spare |
work_order_task_id |
bigint |
False |
|
|
WorkOrderTaskTaskCode |
wm.work_order_task |
task_code |
character varying |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.work_order_task_id = wm.work_order_task.work_order_task_id |
WorkOrderTaskTaskDescription |
wm.work_order_task |
task_description |
character varying |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.work_order_task_id = wm.work_order_task.work_order_task_id |
WorkOrderTaskTaskType |
wm.work_order_task |
task_type |
system.entity_type |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.work_order_task_id = wm.work_order_task.work_order_task_id |
WorkOrderTaskWorkOrderId |
wm.work_order |
work_order_id |
bigint |
False |
True |
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.work_order_task_id = wm.work_order_task.work_order_task_id Then
wm.work_order_task.work_order_id = wm.work_order.work_order_id |
WorkOrderTaskWorkOrderCode |
wm.work_order |
code |
character varying(50) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.work_order_task_id = wm.work_order_task.work_order_task_id Then
wm.work_order_task.work_order_id = wm.work_order.work_order_id |
WorkOrderTaskWorkOrderDescription |
wm.work_order |
description |
character varying(100) |
False |
|
mm.requisition_item.work_order_task_spare_info_id = wm.work_order_task_spare.work_order_task_spare_id Then
wm.work_order_task_spare.work_order_task_id = wm.work_order_task.work_order_task_id Then
wm.work_order_task.work_order_id = wm.work_order.work_order_id |
Enumerations
Mapping 1
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| ApprovalWorkflowProgress |
ApprovalWorkflowProgress |
approval_workflow_progress |
mm.approval_workflow_progress |
NotStarted
Rejected
InProgress
Approved
|
Mapping 2
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| RequisitionStatusBaseStatus |
RequisitionStatusBaseStatus |
base_status |
mm.requisition_status_base_status |
AwaitingApproval
Approved
Completed
Closed
Cancelled
AwaitingApprovalWorkflow
|
Mapping 3
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| WorkOrderTaskSpareSpareType |
WorkOrderTaskSpareType |
spare_type |
wm.spare_type |
StockItem
CodedNonStockItem
DirectPurchase
Contractor
|
Mapping 4
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| SpareType |
WorkOrderTaskSpareType |
spare_type |
wm.spare_type |
StockItem
CodedNonStockItem
DirectPurchase
Contractor
|
Mapping 5
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| WorkOrderTaskTaskType |
EntityType |
task_type |
system.entity_type |
Alarm
NewAlarm
AlarmExpression
AlarmExpressionTask
AlarmAttribute
AlarmDocument
AlarmType
MonitoringPoint
MonitoringPointBoundEvaluationLog
MonitoringPointParameter
MonitoringPointReading
MonitoringPointTrigger
MonitoringPointTriggerExpression
MonitoringPointTriggerExpressionAlarmType
MonitoringPointTriggerExpressionParameter
MonitoringPointTriggerExpressionEvaluation
MonitoringPointTriggerExpressionEvaluationLog
MonitoringPointType
MonitoringPointTypeParameter
MonitoringPointAttribute
MonitoringPointDocument
AuxiliaryAssetTask
AuxiliaryAssetTaskResource
AuxiliaryAssetTaskSpare
AuxiliaryAssetTaskSubTask
RegularAssetComponent
RegularAssetComponentAttribute
RegularAssetComponentDocument
RegularAssetComponentRuleEvaluationFailure
AssetComponent
AssetWarranty
PlaceholderAssetComponent
PlaceholderAssetComponentOptionValue
PlaceholderAssetComponentCondition
PlaceholderAssetMeter
PlaceholderAssetComponentRuleEvaluationFailure
RegularAssetCondition
RegularAssetActiveCondition
AssetFmeca
RegularAssetOptionValue
Asset
RegularAssetAttribute
RegularAssetDocument
RegularAssetFileAttachment
PlaceholderAsset
PlaceholderAssetAttribute
PlaceholderAssetDocument
PlaceholderAssetFileAttachment
PlaceholderAssetRuleEvaluationFailure
PlaceholderAssetResponsibility
PlaceholderAssetCondition
PlaceholderAssetActiveCondition
AssetTask
SetAssetTaskSpareWarehouseEntity
RegularAssetTask
RegularAssetTaskRuleEvaluationFailure
RegularAssetTaskAttribute
RegularAssetTaskAuxiliaryTask
RegularAssetTaskFollowUpTask
RegularAssetTaskFollowUpTaskExpression
RegularAssetTaskSuppressedTask
RegularAssetTaskResource
RegularAssetTaskResourceRuleEvaluationFailure
RegularAssetTaskSpare
RegularAssetTaskSpareRuleEvaluationFailure
RegularAssetTaskSubTask
RegularAssetTaskFileAttachment
AuxiliaryAssetTypeTask
AuxiliaryAssetTypeTaskResource
AuxiliaryAssetTypeTaskSpare
AuxiliaryAssetTypeTaskSubTask
RegularAssetTypeComponent
RegularAssetTypeComponentAttribute
RegularAssetTypeComponentDocument
AssetTypeComponent
PlaceholderAssetTypeComponent
PlaceholderAssetTypeComponentCondition
PlaceholderAssetTypeComponentAttribute
PlaceholderAssetTypeComponentDocument
PlaceholderAssetTypeComponentRuleLink
RegularAssetTypeComponentRuleLink
PlaceholderAssetComponentAttribute
PlaceholderAssetComponentDocument
PlaceholderAssetComponentActiveCondition
AssetTypeFmeca
AssetTypeFunction
AssetFunction
AssetFmecaTask
AssetTypeFmecaTask
AssetTypeFolder
RegularAssetTypeOption
AssetType
PlaceholderAssetType
PlaceholderAssetTypeSpare
PlaceholderAssetTypeAttribute
PlaceholderAssetTypeDocument
PlaceholderAssetTypeResponsibility
PlaceholderAssetTypeRuleLink
RegularAssetTypeTask
RegularAssetTypeTaskAttribute
RegularAssetTypeTaskAuxiliaryTask
RegularAssetTypeTaskCondition
RegularAssetTypeTaskDocument
RegularAssetTypeTaskFollowUpTask
RegularAssetTypeTaskFollowUpTaskExpression
AssetTypeTask
AssetTypeTaskResource
AssetTaskResource
AssetTaskSpare
AssetTypeTaskSpare
RegularAssetTypeTaskResource
RegularAssetTypeTaskRuleLink
RegularAssetTypeTaskSpare
RegularAssetTypeTaskSubTask
RegularAssetTypeTaskSuppressedTask
Condition
ConditionType
Event
FailureCause
FailureCauseType
FailureMechanism
FailureMechanismType
FailureMode
FailureModeType
InPlaceAssetMeter
InPlaceAssetAttribute
InPlaceAssetFileAttachment
InPlaceAssetRuleEvaluationFailure
InPlaceAssetResponsibility
InPlaceAssetSpare
InPlaceAssetType
InPlaceAssetTypeResponsibility
InPlaceAssetTypeRuleLink
InPlaceAssetTypeSpare
InPlaceAsset
Option
OptionCategory
RegularAsset
RegularAssetTaskDocument
RegularAssetMeter
RegularAssetResponsibility
RegularAssetMonitoringPointTrigger
RegularAssetSpare
RegularAssetTaskCondition
RegularAssetType
RegularAssetTypeAttribute
RegularAssetTypeDocument
RegularAssetTypeCondition
PlaceholderAssetTypeCondition
RegularAssetTypeRule
RegularAssetTypeResponsibility
RegularAssetTypeMonitoringPointTrigger
RegularAssetTypeSpare
RepairType
Rule
RuleCategory
RuleOption
StandardTask
StandardTaskSpare
StandardTaskSubTask
StandardTaskResource
StandardTaskAttribute
StandardTaskDocument
TaskImportance
TaskInterval
TaskIntervalType
TaskRollUpPoint
TypeOfWork
RegularAssetTypeTaskSpareRuleLink
InPlaceAssetTypeAttribute
RegularAssetTypeTaskResourceRuleLink
PlaceholderAssetSpare
RegularAssetMonitoringPointTriggerParameter
AssetSpare
AssetTypeSpare
AssetMeter
AssetConsumption
RegularAssetConsumption
PlaceholderAssetConsumption
InPlaceAssetConsumption
WarrantyType
RegularAssetTypeFileAttachment
Meter
MeterAttribute
MeterDocument
MeterReading
PredictedMeterReading
TimeLossCategory
TimeLossReason
TimeLossType
Consumable
AcquisitionStatus
AcquisitionType
DocumentFolder
DocumentRecord
DocumentRecordAttribute
FileAttachment
FileAttachmentCategory
FileAttachmentContentHistory
DocumentRecordFileHistory
Costing
CostingBudget
CostCentre
CostCentreAttribute
CostCentreDocument
CostCentreType
CostElement
CostElementAttribute
CostElementDocument
Currency
BudgetTemplate
BudgetTemplateParameter
FinancialYear
FinancialYearPeriod
GeneralLedger
GeneralLedgerAttribute
GeneralLedgerDocument
CurrencyRate
Budget
BudgetParameter
AddressType
Approval
Attribute
AttributeAllowedValue
Calendar
CalendarDay
CalendarException
CalendarDayHour
Classification
ClassificationAllowedValue
EmailType
Language
OperationalRole
OperationalRoleTemplate
OperationalRoleResource
PhoneNumberType
UserOperationalRole
UserOperationalRoleTemplate
UserOperationalRoleResource
TermsAndCondition
TermsAndConditionVersion
TermsAndConditionOperationalRole
UserTermsAndConditionVersion
Location
LocationAttribute
LocationDocument
LocalisationSet
LocalisationKey
LocalisationTranslation
Phrase
PhraseTranslation
PreconfiguredReason
Site
SiteAttribute
SiteDocument
SiteType
Supplier
SupplierFileAttachment
SupplierAttribute
SupplierDocument
SupplierContactAddress
SupplierContactEmail
SupplierContactPhoneNumber
SupplierResource
SupplierTaxRate
UnitOfMeasurement
SiteResource
SiteContactAddress
SiteContactEmail
SiteContactPhoneNumber
ChangeDataTrigger
ChangeDataTriggerOccurrenceLog
ChangeDataTriggerCriteria
NotificationTemplate
ChangeDataTriggerCriteriaParameter
ChangeDataTriggerNotificationEvent
NotificationTemplateParameter
ChangeDataTriggerNotificationEventAttachment
ChangeDataTriggerNotificationEventAttachmentParameter
RequestType
Category
Commodity
MaterialMaster
MaterialMasterAttribute
MaterialMasterDocument
MaterialMasterBin
MaterialMasterSupplier
MaterialMasterLinkWarehouse
StockItem
StockItemFileAttachment
StockItemAttribute
StockItemDocument
StockItemBin
StockItemSupplier
WarehouseAttribute
Warehouse
WarehouseDocument
Requisition
RequisitionFileAttachment
RequisitionStatus
RequisitionStatusChange
RequisitionStatusAttribute
RequisitionStatusDocument
RequisitionStatusChangeHistory
RequisitionItemTransaction
ApprovalRole
RequisitionAttribute
RequisitionDocument
RequisitionTransaction
RequisitionItem
RequisitionItemFileAttachment
UserSiteApprovalRole
ApprovalWorkflow
ApprovalWorkflowExpression
ApprovalWorkflowExpressionApprovalRole
Competency
Resource
ResourceAttribute
ResourceAddress
ResourceClassification
ResourceCompetency
ResourceDocument
ResourceEmail
ResourcePhoneNumber
ResourceTrade
ResourceTradeCompetency
ResourceTradeFinancialRate
Section
SectionAttribute
SectionDocument
SectionTrade
TradeAttribute
TradeDocument
Trade
TradeCompetency
TradeFinancialRate
ResourceContext
ResourceFileAttachment
AssetImportance
RiskConsequence
RiskConsequenceCategory
RiskModel
RiskModelConsequenceCategory
RiskModelImportance
RiskModelProbability
RiskProbability
WorkOrderImportance
WorkOrderStatus
WorkOrderStatusAttribute
WorkOrderStatusDocument
WorkOrderStatusAllowedChange
WorkOrder
WorkOrderStatusChangeHistory
WorkOrderStatusChange
WorkOrderMerge
WorkOrderSplit
WorkOrderMeter
WorkOrderAttribute
WorkOrderDocument
WorkOrderFileAttachment
WorkOrderTaskFileAttachment
WorkOrderTaskWarranty
WorkOrderTaskSpareFileAttachment
WorkOrderTask
WorkOrderTaskDocument
WorkOrderTaskAdHocCost
WorkOrderMonitoringPoint
WorkOrderTaskMonitoringPoint
WorkOrderTaskSpare
WorkOrderTaskSubTask
WorkOrderTaskResource
WorkOrderTaskResourceUsage
DueTask
DueTaskSuppressor
ProposedWorkOrderBatch
ProposedWorkOrder
ProposedWorkOrderTask
ProposedWorkOrderMeter
WorkOrderMovement
WorkOrderTaskMovement
WorkOrderTaskResourceMovement
WorkOrderTaskSpareMovement
WorkOrderTaskSubTaskMovement
WorkOrderCompleteAllTasksLog
WorkRequest
WorkRequestAttribute
WorkRequestDocument
WorkRequestStatus
WorkRequestStatusChange
WorkRequestStatusChangeHistory
WorkRequestFileAttachment
WorkOrderDowntimeLoss
WorkOrderProgressEvent
WorkOrderProgressEventAllowedChange
WorkOrderProgressLog
WorkOrderWarranty
ServiceLevelAgreementClassification
ServiceLevelAgreement
ServiceLevelAgreementMeasure
WorkOrderServiceLevelAgreement
WorkOrderServiceLevelAgreementMeasure
ServiceLevelAgreementMeasureTrigger
ServiceLevelAgreementMeasureFieldAssignment
PermissionTree
User
UserAttribute
UserDocument
UserAuthentication
SecurityRole
SecurityRolePermission
UserSecurityRole
UserCustomPermission
UserOption
BackgroundTask
BackgroundTaskStep
ScheduledBackgroundTask
ScheduledJob
UserDefinedField
UserDefinedFieldPredefinedValue
SystemOption
SystemOptionPageLimit
SystemOptionWorkOrderStatus
SystemOptionDefaultStandardTask
SystemOptionWorkOrderStatusTypeOfWork
SystemOptionReferenceDataViewPermission
SystemOptionFileAttachmentCategory
SystemOptionFileAttachmentFileType
RecordChange
RecordChangeValue
RecordChangeUser
RecordChangeProperty
NotificationEventOutbox
NotificationEventAttachmentOutbox
NotificationOutbox
NotificationOutboxLog
ChangeDataTriggerCriteriaEvaluation
SystemOptionReportServerEntity
SystemOptionReportServerEntityDefaultReport
TemplateMigrationLog
TemplateMigrationLogIntent
ResourceActionMigrationLog
ImportSchema
ImportFile
UserDefinedQuery
ResourceActionCustomisation
TemplateCustomisation
TemplateResource
ClusterSettings
ClusterIdentityProviderSettings
MessageBrokerHost
MessageBrokerTopic
MessageBrokerTopicConsumer
TenantSettings
TenantChangeDataSubscriptionSettings
TenantIdentityProviderSettings
TenantJobSettings
TenantFileContentStoreLocationSettings
TenantFileContentStoreFileTypeGroupSettings
TenantFileContentStoreFileTypeSettings
ClusterFeatureToggle
TenantFeatureToggle
TenantHealthCheck
TenantMachineHealthCheck
ClusterHealthCheck
ClusterMachineHealthCheck
ClusterCapacitySlot
TenantChangeLogCleanupExpressionSettings
ClusterJobSettings
|
Queries
The list of example Requisition Item queries can be interpreted using the following legend:
| Legend |
Description |
| Primary Table Alias |
The alias for the mm.requisition_item table in the query |
| Include References |
Include (true) or exclude (false) all lookup table joins in the query |
| Include Permissions |
Include (true) or exclude (false) the permission table join in the query to enforce or skip row-level security based on the permissions for the user |
Query 1
| Primary Table Alias |
Include References |
Include Permissions |
_ri |
False |
False |
SELECT
_ri.created_by_user_id AS "CreatedByUserId",
_ri.created_on AS "CreatedOn",
_ri.modified_by_user_id AS "ModifiedByUserId",
_ri.modified_on AS "ModifiedOn",
_ri.version AS "Version",
_ri.permission_tree_id AS "PermissionTreeId",
_ri.requisition_item_id AS "Id",
_ri.line_number AS "LineNumber",
_ri.approval_workflow_progress AS "ApprovalWorkflowProgress",
_ri.notes AS "Notes",
_ri.quantity_issued AS "QuantityIssued",
_ri.quantity_not_issued AS "QuantityNotIssued",
_ri.quantity_ordered AS "QuantityOrdered",
_ri.quantity_required AS "QuantityRequired",
_ri.quantity_reserved AS "QuantityReserved",
_ri.requisition_id AS "RequisitionId",
_ri.sequence_number AS "SequenceNumber",
_ri.total_cost_in_site_currency AS "TotalCostInSiteCurrency",
_ri.total_cost_in_spare_currency AS "TotalCostInSpareCurrency",
_ri.work_order_task_spare_id AS "WorkOrderTaskSpareId",
_wots.work_order_task_spare_id AS "WorkOrderTaskSpareInfoId",
_wots.code AS "Code",
_wots.cost_centre_id AS "CostCentreId",
_wots.cost_element_id AS "CostElementId",
_wots.description AS "Description",
_wots.financial_year_period_id AS "FinancialYearPeriodId",
_wots.general_ledger_id AS "GeneralLedgerId",
_wots.required_on AS "RequiredOn",
_wots.spare_to_work_order_currency_rate_value AS "SpareToWorkOrderCurrencyRateValue",
_wots.spare_type AS "SpareType",
_wots.stock_item_id AS "StockItemId",
_wots.supplier_id AS "SupplierId",
_wots.unit_of_measurement_id AS "UnitOfMeasurementId",
_wots.unit_price_in_spare_currency AS "UnitPriceInSpareCurrency",
_wots.work_order_task_id AS "WorkOrderTaskId"
FROM
mm.requisition_item _ri
JOIN wm.work_order_task_spare _wots ON _ri.work_order_task_spare_info_id = _wots.work_order_task_spare_id
Query 2
| Primary Table Alias |
Include References |
Include Permissions |
_ri |
True |
False |
SELECT
_u.user_id AS "CreatedByUserId",
_u.code AS "CreatedByUserCode",
_u.full_name AS "CreatedByUserFullName",
_ri.created_on AS "CreatedOn",
_u1.user_id AS "ModifiedByUserId",
_u1.code AS "ModifiedByUserCode",
_u1.full_name AS "ModifiedByUserFullName",
_ri.modified_on AS "ModifiedOn",
_ri.version AS "Version",
_pt.permission_tree_id AS "PermissionTreeId",
_pt.code AS "PermissionTreeCode",
_pt.description AS "PermissionTreeDescription",
_ri.requisition_item_id AS "Id",
_ri.line_number AS "LineNumber",
_ri.approval_workflow_progress AS "ApprovalWorkflowProgress",
_ri.notes AS "Notes",
_ri.quantity_issued AS "QuantityIssued",
_ri.quantity_not_issued AS "QuantityNotIssued",
_ri.quantity_ordered AS "QuantityOrdered",
_ri.quantity_required AS "QuantityRequired",
_ri.quantity_reserved AS "QuantityReserved",
_r.requisition_id AS "RequisitionId",
_r.code AS "RequisitionCode",
_r.requested_on AS "RequisitionRequestedOn",
_r.requisition_status_id AS "RequisitionStatus",
_rs.requisition_status_id AS "RequisitionStatusId",
_rs.base_status AS "RequisitionStatusBaseStatus",
_ri.sequence_number AS "SequenceNumber",
_ri.total_cost_in_site_currency AS "TotalCostInSiteCurrency",
_ri.total_cost_in_spare_currency AS "TotalCostInSpareCurrency",
_wots.work_order_task_spare_id AS "WorkOrderTaskSpareId",
_wots.code AS "WorkOrderTaskSpareCode",
_wots.description AS "WorkOrderTaskSpareDescription",
_wots.spare_type AS "WorkOrderTaskSpareSpareType",
_wots.unit_price_in_spare_currency AS "WorkOrderTaskSpareUnitPriceInSpareCurrency",
_wots.unit_price_in_work_order_currency AS "WorkOrderTaskSpareUnitPriceInWorkOrderCurrency",
_wots.cost_centre_id AS "WorkOrderTaskSpareCostCentre",
_cc.cost_centre_id AS "WorkOrderTaskSpareCostCentreId",
_cc.code AS "WorkOrderTaskSpareCostCentreCode",
_cc.description AS "WorkOrderTaskSpareCostCentreDescription",
_wots.cost_element_id AS "WorkOrderTaskSpareCostElement",
_ce.cost_element_id AS "WorkOrderTaskSpareCostElementId",
_ce.code AS "WorkOrderTaskSpareCostElementCode",
_ce.description AS "WorkOrderTaskSpareCostElementDescription",
_wots.general_ledger_id AS "WorkOrderTaskSpareGeneralLedger",
_gl.general_ledger_id AS "WorkOrderTaskSpareGeneralLedgerId",
_gl.code AS "WorkOrderTaskSpareGeneralLedgerCode",
_gl.description AS "WorkOrderTaskSpareGeneralLedgerDescription",
_wots.spare_currency_id AS "WorkOrderTaskSpareSpareCurrency",
_c.currency_id AS "WorkOrderTaskSpareSpareCurrencyId",
_c.code AS "WorkOrderTaskSpareSpareCurrencyCode",
_c.description AS "WorkOrderTaskSpareSpareCurrencyDescription",
_wots.stock_item_id AS "WorkOrderTaskSpareStockItem",
_si.stock_item_id AS "WorkOrderTaskSpareStockItemId",
_si.material_master_id AS "WorkOrderTaskSpareStockItemMaterialMaster",
_mm.material_master_id AS "WorkOrderTaskSpareStockItemMaterialMasterId",
_mm.code AS "WorkOrderTaskSpareStockItemMaterialMasterCode",
_mm.description AS "WorkOrderTaskSpareStockItemMaterialMasterDescription",
_si.warehouse_id AS "WorkOrderTaskSpareStockItemWarehouse",
_w.warehouse_id AS "WorkOrderTaskSpareStockItemWarehouseId",
_w.code AS "WorkOrderTaskSpareStockItemWarehouseCode",
_wots.supplier_id AS "WorkOrderTaskSpareSupplier",
_s.supplier_id AS "WorkOrderTaskSpareSupplierId",
_s.code AS "WorkOrderTaskSpareSupplierCode",
_s.description AS "WorkOrderTaskSpareSupplierDescription",
_wots.unit_of_measurement_id AS "WorkOrderTaskSpareUnitOfMeasurement",
_uom.unit_of_measurement_id AS "WorkOrderTaskSpareUnitOfMeasurementId",
_uom.code AS "WorkOrderTaskSpareUnitOfMeasurementCode",
_uom.description AS "WorkOrderTaskSpareUnitOfMeasurementDescription",
_wots.work_order_currency_id AS "WorkOrderTaskSpareWorkOrderCurrency",
_c1.currency_id AS "WorkOrderTaskSpareWorkOrderCurrencyId",
_c1.code AS "WorkOrderTaskSpareWorkOrderCurrencyCode",
_c1.description AS "WorkOrderTaskSpareWorkOrderCurrencyDescription",
_wots.work_order_task_id AS "WorkOrderTaskSpareWorkOrderTask",
_wot.work_order_task_id AS "WorkOrderTaskSpareWorkOrderTaskId",
_wot.task_code AS "WorkOrderTaskSpareWorkOrderTaskTaskCode",
_wot.task_description AS "WorkOrderTaskSpareWorkOrderTaskTaskDescription",
_wots1.work_order_task_spare_id AS "WorkOrderTaskSpareInfoId",
_wots1.code AS "Code",
_cc1.cost_centre_id AS "CostCentreId",
_cc1.description AS "CostCentreDescription",
_cc1.code AS "CostCentreCode",
_ce1.cost_element_id AS "CostElementId",
_ce1.description AS "CostElementDescription",
_ce1.code AS "CostElementCode",
_wots1.description AS "Description",
_fyp.financial_year_period_id AS "FinancialYearPeriodId",
_fyp.description AS "FinancialYearPeriodDescription",
_fyp.code AS "FinancialYearPeriodCode",
_gl1.general_ledger_id AS "GeneralLedgerId",
_gl1.description AS "GeneralLedgerDescription",
_gl1.code AS "GeneralLedgerCode",
_wots1.required_on AS "RequiredOn",
_wots1.spare_to_work_order_currency_rate_value AS "SpareToWorkOrderCurrencyRateValue",
_wots1.spare_type AS "SpareType",
_si1.stock_item_id AS "StockItemId",
_si1.alternative_description AS "StockItemAlternativeDescription",
_si1.material_master_id AS "StockItemMaterialMaster",
_mm1.material_master_id AS "StockItemMaterialMasterId",
_mm1.code AS "StockItemMaterialMasterCode",
_si1.warehouse_id AS "StockItemWarehouse",
_w1.warehouse_id AS "StockItemWarehouseId",
_w1.code AS "StockItemWarehouseCode",
_s1.supplier_id AS "SupplierId",
_s1.description AS "SupplierDescription",
_s1.code AS "SupplierCode",
_uom1.unit_of_measurement_id AS "UnitOfMeasurementId",
_uom1.description AS "UnitOfMeasurementDescription",
_uom1.code AS "UnitOfMeasurementCode",
_wots1.unit_price_in_spare_currency AS "UnitPriceInSpareCurrency",
_wot1.work_order_task_id AS "WorkOrderTaskId",
_wot1.task_code AS "WorkOrderTaskTaskCode",
_wot1.task_description AS "WorkOrderTaskTaskDescription",
_wot1.task_type AS "WorkOrderTaskTaskType",
_wot1.work_order_id AS "WorkOrderTaskWorkOrder",
_wo.work_order_id AS "WorkOrderTaskWorkOrderId",
_wo.code AS "WorkOrderTaskWorkOrderCode",
_wo.description AS "WorkOrderTaskWorkOrderDescription"
FROM
mm.requisition_item _ri
JOIN uam.user _u ON _ri.created_by_user_id = _u.user_id
JOIN uam.user _u1 ON _ri.modified_by_user_id = _u1.user_id
JOIN uam.permission_tree _pt ON _ri.permission_tree_id = _pt.permission_tree_id
JOIN mm.requisition _r ON _ri.requisition_id = _r.requisition_id
JOIN mm.requisition_status _rs ON _r.requisition_status_id = _rs.requisition_status_id
JOIN wm.work_order_task_spare _wots ON _ri.work_order_task_spare_id = _wots.work_order_task_spare_id
JOIN fin.cost_centre _cc ON _wots.cost_centre_id = _cc.cost_centre_id
LEFT JOIN fin.cost_element _ce ON _wots.cost_element_id = _ce.cost_element_id
JOIN fin.general_ledger _gl ON _wots.general_ledger_id = _gl.general_ledger_id
LEFT JOIN fin.currency _c ON _wots.spare_currency_id = _c.currency_id
LEFT JOIN mm.stock_item _si ON _wots.stock_item_id = _si.stock_item_id
LEFT JOIN mm.material_master _mm ON _si.material_master_id = _mm.material_master_id
LEFT JOIN mm.warehouse _w ON _si.warehouse_id = _w.warehouse_id
LEFT JOIN gen.supplier _s ON _wots.supplier_id = _s.supplier_id
LEFT JOIN gen.unit_of_measurement _uom ON _wots.unit_of_measurement_id = _uom.unit_of_measurement_id
LEFT JOIN fin.currency _c1 ON _wots.work_order_currency_id = _c1.currency_id
JOIN wm.work_order_task _wot ON _wots.work_order_task_id = _wot.work_order_task_id
JOIN wm.work_order_task_spare _wots1 ON _ri.work_order_task_spare_info_id = _wots1.work_order_task_spare_id
JOIN fin.cost_centre _cc1 ON _wots1.cost_centre_id = _cc1.cost_centre_id
JOIN fin.cost_element _ce1 ON _wots1.cost_element_id = _ce1.cost_element_id
LEFT JOIN fin.financial_year_period _fyp ON _wots1.financial_year_period_id = _fyp.financial_year_period_id
JOIN fin.general_ledger _gl1 ON _wots1.general_ledger_id = _gl1.general_ledger_id
LEFT JOIN mm.stock_item _si1 ON _wots1.stock_item_id = _si1.stock_item_id
LEFT JOIN mm.material_master _mm1 ON _si1.material_master_id = _mm1.material_master_id
LEFT JOIN mm.warehouse _w1 ON _si1.warehouse_id = _w1.warehouse_id
LEFT JOIN gen.supplier _s1 ON _wots1.supplier_id = _s1.supplier_id
LEFT JOIN gen.unit_of_measurement _uom1 ON _wots1.unit_of_measurement_id = _uom1.unit_of_measurement_id
JOIN wm.work_order_task _wot1 ON _wots1.work_order_task_id = _wot1.work_order_task_id
JOIN wm.work_order _wo ON _wot1.work_order_id = _wo.work_order_id
Query 3
| Primary Table Alias |
Include References |
Include Permissions |
_ri |
False |
True |
| Parameter Name |
Data Type |
Value |
@permission_user_id |
Bigint |
500000000000 |
@permission_id |
Bigint |
110712400 |
WITH permission_tree_ids AS
(
SELECT DISTINCT unnest(psd.permission_tree_ids) AS permission_tree_id FROM uam.user_permission up JOIN uam.permission_set_data psd ON up.permission_set_id = psd.permission_set_id WHERE up.user_id = @permission_user_id AND up.permission_id = @permission_id
)
SELECT
_ri.created_by_user_id AS "CreatedByUserId",
_ri.created_on AS "CreatedOn",
_ri.modified_by_user_id AS "ModifiedByUserId",
_ri.modified_on AS "ModifiedOn",
_ri.version AS "Version",
_ri.permission_tree_id AS "PermissionTreeId",
_ri.requisition_item_id AS "Id",
_ri.line_number AS "LineNumber",
_ri.approval_workflow_progress AS "ApprovalWorkflowProgress",
_ri.notes AS "Notes",
_ri.quantity_issued AS "QuantityIssued",
_ri.quantity_not_issued AS "QuantityNotIssued",
_ri.quantity_ordered AS "QuantityOrdered",
_ri.quantity_required AS "QuantityRequired",
_ri.quantity_reserved AS "QuantityReserved",
_ri.requisition_id AS "RequisitionId",
_ri.sequence_number AS "SequenceNumber",
_ri.total_cost_in_site_currency AS "TotalCostInSiteCurrency",
_ri.total_cost_in_spare_currency AS "TotalCostInSpareCurrency",
_ri.work_order_task_spare_id AS "WorkOrderTaskSpareId",
_wots.work_order_task_spare_id AS "WorkOrderTaskSpareInfoId",
_wots.code AS "Code",
_wots.cost_centre_id AS "CostCentreId",
_wots.cost_element_id AS "CostElementId",
_wots.description AS "Description",
_wots.financial_year_period_id AS "FinancialYearPeriodId",
_wots.general_ledger_id AS "GeneralLedgerId",
_wots.required_on AS "RequiredOn",
_wots.spare_to_work_order_currency_rate_value AS "SpareToWorkOrderCurrencyRateValue",
_wots.spare_type AS "SpareType",
_wots.stock_item_id AS "StockItemId",
_wots.supplier_id AS "SupplierId",
_wots.unit_of_measurement_id AS "UnitOfMeasurementId",
_wots.unit_price_in_spare_currency AS "UnitPriceInSpareCurrency",
_wots.work_order_task_id AS "WorkOrderTaskId",
_ri.permission_tree_id AS "_ri_permission_tree_id"
FROM
mm.requisition_item _ri
JOIN permission_tree_ids permission_join ON _ri.permission_tree_id = permission_join.permission_tree_id
JOIN wm.work_order_task_spare _wots ON _ri.work_order_task_spare_info_id = _wots.work_order_task_spare_id
Query 4
| Primary Table Alias |
Include References |
Include Permissions |
_ri |
True |
True |
| Parameter Name |
Data Type |
Value |
@permission_user_id |
Bigint |
500000000000 |
@permission_id |
Bigint |
110712400 |
WITH permission_tree_ids AS
(
SELECT DISTINCT unnest(psd.permission_tree_ids) AS permission_tree_id FROM uam.user_permission up JOIN uam.permission_set_data psd ON up.permission_set_id = psd.permission_set_id WHERE up.user_id = @permission_user_id AND up.permission_id = @permission_id
)
SELECT
_u.user_id AS "CreatedByUserId",
_u.code AS "CreatedByUserCode",
_u.full_name AS "CreatedByUserFullName",
_ri.created_on AS "CreatedOn",
_u1.user_id AS "ModifiedByUserId",
_u1.code AS "ModifiedByUserCode",
_u1.full_name AS "ModifiedByUserFullName",
_ri.modified_on AS "ModifiedOn",
_ri.version AS "Version",
_pt.permission_tree_id AS "PermissionTreeId",
_pt.code AS "PermissionTreeCode",
_pt.description AS "PermissionTreeDescription",
_ri.requisition_item_id AS "Id",
_ri.line_number AS "LineNumber",
_ri.approval_workflow_progress AS "ApprovalWorkflowProgress",
_ri.notes AS "Notes",
_ri.quantity_issued AS "QuantityIssued",
_ri.quantity_not_issued AS "QuantityNotIssued",
_ri.quantity_ordered AS "QuantityOrdered",
_ri.quantity_required AS "QuantityRequired",
_ri.quantity_reserved AS "QuantityReserved",
_r.requisition_id AS "RequisitionId",
_r.code AS "RequisitionCode",
_r.requested_on AS "RequisitionRequestedOn",
_r.requisition_status_id AS "RequisitionStatus",
_rs.requisition_status_id AS "RequisitionStatusId",
_rs.base_status AS "RequisitionStatusBaseStatus",
_ri.sequence_number AS "SequenceNumber",
_ri.total_cost_in_site_currency AS "TotalCostInSiteCurrency",
_ri.total_cost_in_spare_currency AS "TotalCostInSpareCurrency",
_wots.work_order_task_spare_id AS "WorkOrderTaskSpareId",
_wots.code AS "WorkOrderTaskSpareCode",
_wots.description AS "WorkOrderTaskSpareDescription",
_wots.spare_type AS "WorkOrderTaskSpareSpareType",
_wots.unit_price_in_spare_currency AS "WorkOrderTaskSpareUnitPriceInSpareCurrency",
_wots.unit_price_in_work_order_currency AS "WorkOrderTaskSpareUnitPriceInWorkOrderCurrency",
_wots.cost_centre_id AS "WorkOrderTaskSpareCostCentre",
_cc.cost_centre_id AS "WorkOrderTaskSpareCostCentreId",
_cc.code AS "WorkOrderTaskSpareCostCentreCode",
_cc.description AS "WorkOrderTaskSpareCostCentreDescription",
_wots.cost_element_id AS "WorkOrderTaskSpareCostElement",
_ce.cost_element_id AS "WorkOrderTaskSpareCostElementId",
_ce.code AS "WorkOrderTaskSpareCostElementCode",
_ce.description AS "WorkOrderTaskSpareCostElementDescription",
_wots.general_ledger_id AS "WorkOrderTaskSpareGeneralLedger",
_gl.general_ledger_id AS "WorkOrderTaskSpareGeneralLedgerId",
_gl.code AS "WorkOrderTaskSpareGeneralLedgerCode",
_gl.description AS "WorkOrderTaskSpareGeneralLedgerDescription",
_wots.spare_currency_id AS "WorkOrderTaskSpareSpareCurrency",
_c.currency_id AS "WorkOrderTaskSpareSpareCurrencyId",
_c.code AS "WorkOrderTaskSpareSpareCurrencyCode",
_c.description AS "WorkOrderTaskSpareSpareCurrencyDescription",
_wots.stock_item_id AS "WorkOrderTaskSpareStockItem",
_si.stock_item_id AS "WorkOrderTaskSpareStockItemId",
_si.material_master_id AS "WorkOrderTaskSpareStockItemMaterialMaster",
_mm.material_master_id AS "WorkOrderTaskSpareStockItemMaterialMasterId",
_mm.code AS "WorkOrderTaskSpareStockItemMaterialMasterCode",
_mm.description AS "WorkOrderTaskSpareStockItemMaterialMasterDescription",
_si.warehouse_id AS "WorkOrderTaskSpareStockItemWarehouse",
_w.warehouse_id AS "WorkOrderTaskSpareStockItemWarehouseId",
_w.code AS "WorkOrderTaskSpareStockItemWarehouseCode",
_wots.supplier_id AS "WorkOrderTaskSpareSupplier",
_s.supplier_id AS "WorkOrderTaskSpareSupplierId",
_s.code AS "WorkOrderTaskSpareSupplierCode",
_s.description AS "WorkOrderTaskSpareSupplierDescription",
_wots.unit_of_measurement_id AS "WorkOrderTaskSpareUnitOfMeasurement",
_uom.unit_of_measurement_id AS "WorkOrderTaskSpareUnitOfMeasurementId",
_uom.code AS "WorkOrderTaskSpareUnitOfMeasurementCode",
_uom.description AS "WorkOrderTaskSpareUnitOfMeasurementDescription",
_wots.work_order_currency_id AS "WorkOrderTaskSpareWorkOrderCurrency",
_c1.currency_id AS "WorkOrderTaskSpareWorkOrderCurrencyId",
_c1.code AS "WorkOrderTaskSpareWorkOrderCurrencyCode",
_c1.description AS "WorkOrderTaskSpareWorkOrderCurrencyDescription",
_wots.work_order_task_id AS "WorkOrderTaskSpareWorkOrderTask",
_wot.work_order_task_id AS "WorkOrderTaskSpareWorkOrderTaskId",
_wot.task_code AS "WorkOrderTaskSpareWorkOrderTaskTaskCode",
_wot.task_description AS "WorkOrderTaskSpareWorkOrderTaskTaskDescription",
_wots1.work_order_task_spare_id AS "WorkOrderTaskSpareInfoId",
_wots1.code AS "Code",
_cc1.cost_centre_id AS "CostCentreId",
_cc1.description AS "CostCentreDescription",
_cc1.code AS "CostCentreCode",
_ce1.cost_element_id AS "CostElementId",
_ce1.description AS "CostElementDescription",
_ce1.code AS "CostElementCode",
_wots1.description AS "Description",
_fyp.financial_year_period_id AS "FinancialYearPeriodId",
_fyp.description AS "FinancialYearPeriodDescription",
_fyp.code AS "FinancialYearPeriodCode",
_gl1.general_ledger_id AS "GeneralLedgerId",
_gl1.description AS "GeneralLedgerDescription",
_gl1.code AS "GeneralLedgerCode",
_wots1.required_on AS "RequiredOn",
_wots1.spare_to_work_order_currency_rate_value AS "SpareToWorkOrderCurrencyRateValue",
_wots1.spare_type AS "SpareType",
_si1.stock_item_id AS "StockItemId",
_si1.alternative_description AS "StockItemAlternativeDescription",
_si1.material_master_id AS "StockItemMaterialMaster",
_mm1.material_master_id AS "StockItemMaterialMasterId",
_mm1.code AS "StockItemMaterialMasterCode",
_si1.warehouse_id AS "StockItemWarehouse",
_w1.warehouse_id AS "StockItemWarehouseId",
_w1.code AS "StockItemWarehouseCode",
_s1.supplier_id AS "SupplierId",
_s1.description AS "SupplierDescription",
_s1.code AS "SupplierCode",
_uom1.unit_of_measurement_id AS "UnitOfMeasurementId",
_uom1.description AS "UnitOfMeasurementDescription",
_uom1.code AS "UnitOfMeasurementCode",
_wots1.unit_price_in_spare_currency AS "UnitPriceInSpareCurrency",
_wot1.work_order_task_id AS "WorkOrderTaskId",
_wot1.task_code AS "WorkOrderTaskTaskCode",
_wot1.task_description AS "WorkOrderTaskTaskDescription",
_wot1.task_type AS "WorkOrderTaskTaskType",
_wot1.work_order_id AS "WorkOrderTaskWorkOrder",
_wo.work_order_id AS "WorkOrderTaskWorkOrderId",
_wo.code AS "WorkOrderTaskWorkOrderCode",
_wo.description AS "WorkOrderTaskWorkOrderDescription",
_ri.permission_tree_id AS "_ri_permission_tree_id",
_u.permission_tree_id AS "_u_permission_tree_id",
_u1.permission_tree_id AS "_u1_permission_tree_id",
_r.permission_tree_id AS "_r_permission_tree_id",
_rs.permission_tree_id AS "_rs_permission_tree_id",
_wots.permission_tree_id AS "_wots_permission_tree_id",
_cc.permission_tree_id AS "_cc_permission_tree_id",
_ce.permission_tree_id AS "_ce_permission_tree_id",
_gl.permission_tree_id AS "_gl_permission_tree_id",
_c.permission_tree_id AS "_c_permission_tree_id",
_si.permission_tree_id AS "_si_permission_tree_id",
_mm.permission_tree_id AS "_mm_permission_tree_id",
_w.permission_tree_id AS "_w_permission_tree_id",
_s.permission_tree_id AS "_s_permission_tree_id",
_uom.permission_tree_id AS "_uom_permission_tree_id",
_c1.permission_tree_id AS "_c1_permission_tree_id",
_wot.permission_tree_id AS "_wot_permission_tree_id",
_cc1.permission_tree_id AS "_cc1_permission_tree_id",
_ce1.permission_tree_id AS "_ce1_permission_tree_id",
_fyp.permission_tree_id AS "_fyp_permission_tree_id",
_gl1.permission_tree_id AS "_gl1_permission_tree_id",
_si1.permission_tree_id AS "_si1_permission_tree_id",
_mm1.permission_tree_id AS "_mm1_permission_tree_id",
_w1.permission_tree_id AS "_w1_permission_tree_id",
_s1.permission_tree_id AS "_s1_permission_tree_id",
_uom1.permission_tree_id AS "_uom1_permission_tree_id",
_wot1.permission_tree_id AS "_wot1_permission_tree_id",
_wo.permission_tree_id AS "_wo_permission_tree_id"
FROM
mm.requisition_item _ri
JOIN permission_tree_ids permission_join ON _ri.permission_tree_id = permission_join.permission_tree_id
JOIN uam.user _u ON _ri.created_by_user_id = _u.user_id
JOIN uam.user _u1 ON _ri.modified_by_user_id = _u1.user_id
JOIN uam.permission_tree _pt ON _ri.permission_tree_id = _pt.permission_tree_id
JOIN mm.requisition _r ON _ri.requisition_id = _r.requisition_id
JOIN mm.requisition_status _rs ON _r.requisition_status_id = _rs.requisition_status_id
JOIN wm.work_order_task_spare _wots ON _ri.work_order_task_spare_id = _wots.work_order_task_spare_id
JOIN fin.cost_centre _cc ON _wots.cost_centre_id = _cc.cost_centre_id
LEFT JOIN fin.cost_element _ce ON _wots.cost_element_id = _ce.cost_element_id
JOIN fin.general_ledger _gl ON _wots.general_ledger_id = _gl.general_ledger_id
LEFT JOIN fin.currency _c ON _wots.spare_currency_id = _c.currency_id
LEFT JOIN mm.stock_item _si ON _wots.stock_item_id = _si.stock_item_id
LEFT JOIN mm.material_master _mm ON _si.material_master_id = _mm.material_master_id
LEFT JOIN mm.warehouse _w ON _si.warehouse_id = _w.warehouse_id
LEFT JOIN gen.supplier _s ON _wots.supplier_id = _s.supplier_id
LEFT JOIN gen.unit_of_measurement _uom ON _wots.unit_of_measurement_id = _uom.unit_of_measurement_id
LEFT JOIN fin.currency _c1 ON _wots.work_order_currency_id = _c1.currency_id
JOIN wm.work_order_task _wot ON _wots.work_order_task_id = _wot.work_order_task_id
JOIN wm.work_order_task_spare _wots1 ON _ri.work_order_task_spare_info_id = _wots1.work_order_task_spare_id
JOIN fin.cost_centre _cc1 ON _wots1.cost_centre_id = _cc1.cost_centre_id
JOIN fin.cost_element _ce1 ON _wots1.cost_element_id = _ce1.cost_element_id
LEFT JOIN fin.financial_year_period _fyp ON _wots1.financial_year_period_id = _fyp.financial_year_period_id
JOIN fin.general_ledger _gl1 ON _wots1.general_ledger_id = _gl1.general_ledger_id
LEFT JOIN mm.stock_item _si1 ON _wots1.stock_item_id = _si1.stock_item_id
LEFT JOIN mm.material_master _mm1 ON _si1.material_master_id = _mm1.material_master_id
LEFT JOIN mm.warehouse _w1 ON _si1.warehouse_id = _w1.warehouse_id
LEFT JOIN gen.supplier _s1 ON _wots1.supplier_id = _s1.supplier_id
LEFT JOIN gen.unit_of_measurement _uom1 ON _wots1.unit_of_measurement_id = _uom1.unit_of_measurement_id
JOIN wm.work_order_task _wot1 ON _wots1.work_order_task_id = _wot1.work_order_task_id
JOIN wm.work_order _wo ON _wot1.work_order_id = _wo.work_order_id