Objektová akce

Kód:
2
Tělo:
INSERT INTO CRPPlanVariants2 
  (Parent_ID,
   ProduceDocument_ID,
   ProduceDocumentBasedJO,
   ProduceDocumentDisplayName,
   pdplannedstartat$date,
   pdscheduledstartat$date,
   pdreleasedstartat$date,
   pdpriority,
   pdstorecard_id,
   pdstorecarddisplayname,
   pdquantity,
   pdqunit,
   PDBusOrder_ID,
   Req_ID,
   WorkScheduleItem_ID,
   wsiversion,
   WorkScheduleItemDisplayName,
   WorkPlace_ID,
   wsiroutinetitle,
   wsistorecard_id,
   wsistorecarddisplayname,
   wsipriority,
   wsistatus,
   WSIPlannedQuantity,
   WSIOngoing,
   WSIAdvanceQuantity,
   WSIQuantum,
   WSIRealizedQuantity,
   RoutineQuantity,
   Routine_ID ,
   WSIRequestWSI_ID,
   WSISuspend,
   calcdate$date,
   CalcMethod_ID,
   BeginTime$date,
   EndTime$date,
   Machine_ID,
   PowerRate,
   Quantity,
   Capacity,     
   ItemID,
   ItemType
) 
VALUES 
(  :Parent_ID,
   :ProduceDocument_ID,
   :ProduceDocumentBasedJO,
   :ProduceDocumentDisplayName,
   :pdplannedstartat$date,
   :pdscheduledstartat$date,
   :pdreleasedstartat$date,
   :pdpriority,
   :pdstorecard_id,
   :pdstorecarddisplayname,
   :pdquantity,
   :pdqunit,
   :PDBusOrder_ID,
   :Req_ID,
   :WorkScheduleItem_ID,
   :wsiversion,
   :WorkScheduleItemDisplayName,
   :WorkPlace_ID,
   :wsiroutinetitle,
   :wsistorecard_id,
   :wsistorecarddisplayname,
   :wsipriority,
   :wsistatus,
   :WSIPlannedQuantity,
   :WSIOngoing,
   :WSIAdvanceQuantity,
   :WSIQuantum,
   :WSIRealizedQuantity,
   :RoutineQuantity,
   :Routine_ID ,
   :WSIRequestWSI_ID,
   :WSISuspend,
   :calcdate$date,
   :CalcMethod_ID,
   :BeginTime$date,
   :EndTime$date,
   :Machine_ID,
   :PowerRate,
   :Quantity,
   :Capacity,     
   :ItemID,
   :ItemType)

Generated by ABRA Software a.s. 27.10.2021 16:35:42