/// <summary>
/// Sets the commander sales order header schema.
/// </summary>
/// <param name="fields">The fields.</param>
public static void SetCommanderSalesOrderHeaderSchema(TextFieldCollection fields)
{
//set-up fields collection, make sure the field names are the same as the
//CommanderSalesOrder class properties so that reflection can be used in the parsing subscriber
fields.Clear();
fields.Add(new TextField("LineNumber", TypeCode.Int32, 5));
fields.Add(new TextField("RecordType", TypeCode.Int32, 3));
fields.Add(new TextField("RecordSubType", TypeCode.String, 1));
fields.Add(new TextField("Site", TypeCode.String, 10));
fields.Add(new TextField("OrderReference", TypeCode.String, 20));
fields.Add(new TextField("CustomerNumber", TypeCode.String, 10));
fields.Add(new TextField("DespatchRouteCode", TypeCode.String, 10));
fields.Add(new TextField("DropNumber", TypeCode.Int32, 6));
fields.Add(new TextField("TotalWeight", TypeCode.Decimal, 19));
fields.Add(new TextField("DeliveryAddress.Line1", TypeCode.String, 32));
fields.Add(new TextField("DeliveryAddress.Line2", TypeCode.String, 32));
fields.Add(new TextField("DeliveryAddress.Line3", TypeCode.String, 32));
fields.Add(new TextField("DeliveryAddress.Line4", TypeCode.String, 32));
fields.Add(new TextField("DeliveryAddress.Line5", TypeCode.String, 32));
fields.Add(new TextField("CustomerOrderReference", TypeCode.String, 32));
fields.Add(new TextField("Carrier", TypeCode.String, 4));
fields.Add(new TextField("CustomerType", TypeCode.String, 3));
}
/// <summary>
/// Sets the file header and footer schema.
/// </summary>
/// <param name="fields">The fields.</param>
protected void SetFileHeaderAndFooterSchema(TextFieldCollection fields)
{
fields.Clear();
AddCommonFields(fields);
fields.Add(new TextField("Date", TypeCode.DateTime, 10));
fields.Add(new TextField("Time", TypeCode.DateTime, 5)); //should be 8 but the test data only has 5!
}
/// <summary>
/// Sets the parser schema.
/// </summary>
/// <param name="fields">The fields.</param>
public static void SetParserSchema(TextFieldCollection fields)
{
// Clear fields
fields.Clear();
// Add fields for schema
fields.Add(new TextField("Type", TypeCode.String, false));
fields.Add(new TextField("OpCoCode", TypeCode.String, false));
fields.Add(new TextField("ShipmentNumber", TypeCode.String, false));
fields.Add(new TextField("DespatchNumber", TypeCode.String, false));
fields.Add(new TextField("LineNumber", TypeCode.Int32, false));
fields.Add(new TextField("ProductCode", TypeCode.String, false));
fields.Add(new TextField("Description1", TypeCode.String, false));
fields.Add(new TextField("Description2", TypeCode.String, false));
fields.Add(new TextField("Quantity", TypeCode.Int32, false));
fields.Add(new TextField("QuantityUnit", TypeCode.String, false));
fields.Add(new TextField("NetWeight", TypeCode.Decimal, false));
fields.Add(new TextField("CustomerReference", TypeCode.String, false));
fields.Add(new TextField("ConversionQuantity", TypeCode.Int32, false));
fields.Add(new TextField("ConversionInstructions", TypeCode.String, false));
fields.Add(new TextField("Volume", TypeCode.Decimal, false));
fields.Add(new TextField("Width", TypeCode.Int32, false));
fields.Add(new TextField("Length", TypeCode.Int32, false));
fields.Add(new TextField("Grammage", TypeCode.Int32, false));
fields.Add(new TextField("Microns", TypeCode.Int32, false));
fields.Add(new TextField("Packing", TypeCode.String, false));
fields.Add(new TextField("IsPanel", TypeCode.Boolean, false));
fields.Add(new TextField("LoadCategoryCode", TypeCode.String, false));
fields.Add(new TextField("ProductGroup", TypeCode.String, false));
fields.Add(new TextField("IsISO9000Approved", TypeCode.Boolean, false));
}
/// <summary>
/// Sets the product maintenance file header schema.
/// </summary>
/// <param name="fields">The fields.</param>
public static void SetProductMaintenanceFileHeaderSchema(TextFieldCollection fields)
{
fields.Clear();
AddCommonFields(fields);
fields.Add(new TextField("Date", TypeCode.String, 10));
fields.Add(new TextField("Time", TypeCode.String, 8));
}
/// <summary>
/// Sets the item schema.
/// </summary>
/// <param name="fields">The fields.</param>
protected override void SetItemSchema(TextFieldCollection fields)
{
fields.Clear();
AddCommonFields(fields);
fields.Add(new TextField("Site", TypeCode.String, 10));
fields.Add(new TextField("ProductCode", TypeCode.String, 20));
fields.Add(new TextField("Quantity", TypeCode.Int32, 19));
fields.Add(new TextField("CustomerReferenceNumber", TypeCode.String, 20));
}
/// <summary>
/// Sets the commander sales order file header schema.
/// </summary>
/// <param name="fields">The fields.</param>
public static void SetCommanderSalesOrderFileHeaderSchema(TextFieldCollection fields)
{
fields.Clear();
fields.Add(new TextField("LineNumber", TypeCode.Int32, 5));
fields.Add(new TextField("RecordType", TypeCode.Int32, 3));
fields.Add(new TextField("RecordSubType", TypeCode.String, 1));
fields.Add(new TextField("Date", TypeCode.String, 10));
fields.Add(new TextField("Time", TypeCode.String, 8));
}
/// <summary>
/// Sets the commander product maintenance modify schema.
/// </summary>
/// <param name="fields">The fields.</param>
public static void SetCommanderProductMaintenanceModifySchema(TextFieldCollection fields)
{
//set-up fields collection, make sure the field names are the same as the
//CommanderSalesOrder class properties so that reflection can be used in the parsing subscriber
fields.Clear();
AddCommonFields(fields);
fields.Add(new TextField("ProductCode", TypeCode.String, 20));
fields.Add(new TextField("Description", TypeCode.String, 40));
fields.Add(new TextField("ShortDescription", TypeCode.String, 30));
fields.Add(new TextField("Account", TypeCode.String, 20));
}
/// <summary>
/// Sets the item schema. These fields describe the format of a single line
/// </summary>
/// <param name="fields">The fields.</param>
protected override void SetItemSchema(TextFieldCollection fields)
{
fields.Clear();
AddCommonFields(fields);
fields.Add(new TextField("Site", TypeCode.String, 10));
fields.Add(new TextField("RecieptRef", TypeCode.String, 20));
fields.Add(new TextField("LineNumber", TypeCode.Int32, 5));
fields.Add(new TextField("ProductCode", TypeCode.String, 20));
fields.Add(new TextField("QuantityReceived", TypeCode.Int32, 19));
fields.Add(new TextField("CustomerReferenceNumber", TypeCode.String, 20));
fields.Add(new TextField("IsAdviceNoteRequired", TypeCode.Int32, 2));
fields.Add(new TextField("AdviceNoteNumber", TypeCode.String, 30));
}
/// <summary>
/// Sets the parser schema.
/// </summary>
/// <param name="fields">The fields.</param>
public static void SetParserSchema(TextFieldCollection fields)
{
// Clear fields
fields.Clear();
// Add fields for schema
fields.Add(new TextField("MessageType", TypeCode.String, false)); // Not used
fields.Add(new TextField("OpCoCode", TypeCode.String, false));
fields.Add(new TextField("OpCoSequenceNumber", TypeCode.String, false));
fields.Add(new TextField("ShipmentNumber", TypeCode.String, false));
fields.Add(new TextField("DespatchNumber", TypeCode.String, false));
fields.Add(new TextField("Amendment", TypeCode.Boolean, false));
fields.Add(new TextField("OpCoHeld", TypeCode.Boolean, false));
fields.Add(new TextField("RequiredShipmentDate", TypeCode.DateTime, false));
fields.Add(new TextField("OpCoContact.Name", TypeCode.String, false));
fields.Add(new TextField("TransactionTypeCode", TypeCode.String, false));
fields.Add(new TextField("TransactionSubTypeCode", TypeCode.String, false)); // Not used
fields.Add(new TextField("CustomerReference", TypeCode.String, false));
fields.Add(new TextField("Instructions", TypeCode.String, false));
fields.Add(new TextField("RouteCode", TypeCode.String, false));
fields.Add(new TextField("CustomerNumber", TypeCode.String, false));
fields.Add(new TextField("StockWarehouseCode", TypeCode.String, false));
fields.Add(new TextField("SalesBranchCode", TypeCode.String, false));
fields.Add(new TextField("CustomerName", TypeCode.String, false));
fields.Add(new TextField("CustomerAddress.Line1", TypeCode.String, false));
fields.Add(new TextField("CustomerAddress.Line2", TypeCode.String, false));
fields.Add(new TextField("CustomerAddress.Line3", TypeCode.String, false));
fields.Add(new TextField("CustomerAddress.Line4", TypeCode.String, false));
fields.Add(new TextField("CustomerAddress.Line5", TypeCode.String, false));
fields.Add(new TextField("CustomerAddress.PostCode", TypeCode.String, false));
fields.Add(new TextField("ShipmentName", TypeCode.String, false));
fields.Add(new TextField("ShipmentAddress.Line1", TypeCode.String, false));
fields.Add(new TextField("ShipmentAddress.Line2", TypeCode.String, false));
fields.Add(new TextField("ShipmentAddress.Line3", TypeCode.String, false));
fields.Add(new TextField("ShipmentAddress.Line4", TypeCode.String, false));
fields.Add(new TextField("ShipmentAddress.Line5", TypeCode.String, false));
fields.Add(new TextField("ShipmentAddress.PostCode", TypeCode.String, false));
fields.Add(new TextField("ShipmentContact.Name", TypeCode.String, false));
fields.Add(new TextField("ShipmentContact.TelephoneNumber", TypeCode.String, false));
fields.Add(new TextField("ShipmentContact.Email", TypeCode.String, false));
fields.Add(new TextField("AfterTime", TypeCode.String, false));
fields.Add(new TextField("BeforeTime", TypeCode.String, false));
fields.Add(new TextField("TailLiftRequired", TypeCode.Boolean, false));
fields.Add(new TextField("VehicleMaxWeight", TypeCode.Decimal, false));
fields.Add(new TextField("CheckInTimeHHMMSS", TypeCode.String, false));
fields.Add(new TextField("DeliveryWarehouseCode", TypeCode.String, false));
fields.Add(new TextField("OpCoContact.Email", TypeCode.String, false));
fields.Add(new TextField("DivisionCode", TypeCode.String, false));
fields.Add(new TextField("GeneratedDateTime", TypeCode.DateTime, false));
fields.Add(new TextField("GeneratedTimeHHMMSS", TypeCode.String, false));
}
/// <summary>
/// Sets the commander sales order lines schema.
/// </summary>
/// <param name="fields">The fields.</param>
public static void SetCommanderSalesOrderLinesSchema(TextFieldCollection fields)
{
//set-up fields collection, make sure the field names are actually the same as the
//CommanderSalesOrderLine class properties so that reflection can be used in the parsing subscriber
fields.Clear();
fields.Add(new TextField("LineNumber", TypeCode.Int32, 5));
fields.Add(new TextField("RecordType", TypeCode.Int32, 3));
fields.Add(new TextField("RecordSubType", TypeCode.String, 1));
fields.Add(new TextField("Site", TypeCode.String, 10));
fields.Add(new TextField("OrderReference", TypeCode.String, 20));
fields.Add(new TextField("LineNumber", TypeCode.Int32, 5));
fields.Add(new TextField("ProductCode", TypeCode.String, 20));
fields.Add(new TextField("QuantityOrdered", TypeCode.Int32, 19));
fields.Add(new TextField("CustomerReferenceNumber", TypeCode.String, 20));
fields.Add(new TextField("UOM", TypeCode.String, 10));
fields.Add(new TextField("SpecialInstructions1", TypeCode.String, 33));
fields.Add(new TextField("SpecialInstructions2", TypeCode.String, 33));
fields.Add(new TextField("SpecialInstructions3", TypeCode.String, 33));
fields.Add(new TextField("SpecialInstructions4", TypeCode.String, 33));
fields.Add(new TextField("SpecialInstructions5", TypeCode.String, 33));
}
