Date Field Dependencies - Intergraph Smart Materials - Version 10.2 - Help - Hexagon

Intergraph Smart Materials Classic Help

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

Label on Field

Column in Table M_ITEM_SHIPS

Origin

Prom Ship

PROM_SHIP_DATE

LAST_SHIP_DATE of quote details if value exists;
LAST_SHIP (of quote details) * 7 + SYSDATE if LAST_SHIP_DATE does not exist.

Prom Contract

PROM_CONTRACT_DATE

Same as Prom Ship

Curr/Rev Prom Ship

REV_PROM_SHIP_DATE

Same as Prom Ship when the agreement is created; can be changed afterwards.

Pred On Site

PRED_ON_SITE_DATE

Curr/Rev Prom Ship + total transit days of routing method.

Will also be used as date for forecast run.

If Pred Ship is updated, Pred On Site is set to Pred Ship + total transit days of routing method.

If Actual Ship is updated, Pred On Site is set to Actual Ship + total transit days of routing method.

Req on Site

REQ_SITE_DATE

ROS date of the associated requisition line item

Prom On Site

FORECAST_ETA_SITE_DATE

LAST_SHIP of quote details/ PO line items * 7 + SYSDATE + total transit days of routing method

(not displayed)

REQ_SHIP_DATE

ROS date of requisition line item – total transit days of routing method

Actual Ship

ACTUAL_SHIP_DATE

Set manually on P.70.72 Expediting Details.

Pred Ship

PRED_SHIP_DATE

Set manually on P.70.72 Expediting Details.

Actual On Site

ACTUAL_ON_SITE_DATE

Is set when the associated MRR is posted
(depending on ZC_AOS_DAT and ZC_UPD_EXP settings),
but it can be updated or manually set in Expediting.

PO Actual

ACTUAL_CONTRACT_DATE

Set manually on P.70.72 Expediting Details.

Actual Fab Start

ACTUAL_FAB_START_DATE

Set manually on P.70.72 Expediting Details.

50% Comp

FIFTY_PERCENT_FAB_COMP

Set manually on P.70.72 Expediting Details.

Prom Fab Comp

PROM_FAB_COMP_DATE

Set manually on P.70.72 Expediting Details.

Actual Fab Comp

ACTUAL_FAB_COMP_DATE

Set manually on P.70.72 Expediting Details.

Ready Predicted

READY_PREDICTED

Set manually on P.70.72 Expediting Details.

Ready Actual

READY_ACTUAL

Set manually on P.70.72 Expediting Details.

Prom Inspect

PROM_INSPECT_DATE

Set manually on P.70.72 Expediting Details.

Final Inspect

FINAL_INSPECT_DATE

Set manually on P.70.72 Expediting Details.

Maj Matl Order

MAJ_MATL_ORDER_DATE

Set manually on P.70.72 Expediting Details.

Maj Matl Recv

MAJ_MATL_RECV_DATE

Set manually on P.70.72 Expediting Details.

Pred Stage Ready

PRED_STAGE_READY_DATE

Set manually on P.80.51 Traffic Fast Window 2.

Actual Stage Ready

ACTUAL_STAGE_READY_DATE

Set manually on P.80.51 Traffic Fast Window 2.

Pred Loaded

PRED_LOADED_DATE

Set manually on P.80.51 Traffic Fast Window 2.

Actual Loaded

ACTUAL_LOADED_DATE

Set manually on P.80.51 Traffic Fast Window 2.