tdietrich
09/06/2021, 11:25 PMSELECT
Transaction.ID,
Transaction.TranID AS ItemFullfillmentID,
Transaction.TranDate AS FulfillmentDate,
Transaction.Entity AS CustomerID,
BUILTIN.DF( Transaction.Entity ) AS CustomerName,
SalesOrder.TranID AS SalesOrderNumber,
Transaction.OtherRefNum AS CustomerPONumber,
BUILTIN.DF( Transaction.ShippingAddress ) AS ShipToAddress,
REPLACE( BUILTIN.DF( Transaction.Status ), 'Item Fulfillment : ', '' ) AS Status,
FROM
Transaction
INNER JOIN TransactionLine ON
( TransactionLine.Transaction = Transaction.ID )
AND ( TransactionLine.MainLine = 'T' )
INNER JOIN Transaction AS SalesOrder ON
( SalesOrder.ID = TransactionLine.CreatedFrom )
WHERE
( Transaction.Type = 'ItemShip' )
AND ( Transaction.TranDate >= TO_DATE( '2021-09-01', 'YYYY-MM-DD' ) )
AND ( Transaction.Void = 'F' )
Simon
09/07/2021, 3:53 PM