dataitem(Vendor; Vendor)
{
column(No; "No.")
{
}
column(Name; Name)
{
}
column(Address; Address)
{
}
column(Address2; "Address 2")
{
}
column(City; City)
{
}
column(County; County)
{
}
dataitem(Item; Item)
{
DataItemLink = "Vendor No." = Vendor."No.";
SqlJoinType = InnerJoin;
column(ItemNo; "No.")
{
}
column(Description; Description)
{
}
column(SYCSize; "SYC Size")
{
}
column(SYCPack; "SYC Pack")
{
}
column(SYCCaseQuantity; "SYC Case Quantity")
{
}
column(SYCLayerQuantity; "SYC Layer Quantity")
{
}
column(SYCPalletQuantity; "SYC Pallet Quantity")
{
}
column(SYCItemStatus; "SYC Item Status")
{
}
column(Inventory; Inventory)
{
}
column(QtyonSalesOrder; "Qty. on Sales Order")
{
}
column(QtyonPurchOrder; "Qty. on Purch. Order")
{
}
column(SYCSalesQtytoShip; "SYC Sales Qty. to Ship")
{
}
column(UnitCost; "Unit Cost")
{
}
column(SYCListCost; "SYC List Cost")
{
}
dataitem(SYC_Sales_Analysis_History; "SYC Sales Analysis History")
{
DataItemLink = "No." = Item."No.";
DataItemTableFilter = "Document Type" = const("Posted Sales Invoice");
SqlJoinType = InnerJoin;
column(Week_No_; "Week No.")
{ }
column(Quantity; Quantity)
{
Method = Sum;
}
filter(Posting_Date; "Posting Date")
{
}
}
}
}
