Sage 100 ProvideX SQL: BM_ProductionHistoryDetail Load Replace Example
BM_ProductionHistoryDetail
SQL
SELECT
D.[CommentText],
D.[ComponentDesc],
D.[ComponentItemCode],
D.[ComponentRevision],
D.[ComponentWarehouseCode],
D.[ExtendedQuantity],
D.[GLAccountKey],
D.[ItemCode],
D.[ItemDesc],
D.[ItemType],
D.[LineKey],
D.[LineSeqNo],
D.[ProductionNo],
D.[ProductionSeqNo],
D.[QuantityPerBill],
D.[TotalCost],
D.[UnitOfMeasure],
D.[Valuation],
H.ProductionDate
FROM
{ IJ BM_ProductionHistoryHeader H INNER JOIN
BM_ProductionHistoryDetail D
ON
H.ProductionNo = D.ProductionNo AND
H.ProductionSeqNo = D.ProductionSeqNo }
Load Replace Settings
Source Field =
ProductionDate
Target Value or Constant =
DATEADD(DAY,-365,CONVERT(DATE, GetDate() ))