Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • NAME - diagram name;

  • WHS_ID - warehouse ID in MySales system (filled only for picking and cross-dock diagrams);

  • WAREHOUSE_TYPE - warehouse type - value “c” for cross-dock and “p” for picking;

  • SUPPLIER_ID - supplier ID in MySales system;

  • SPECIFICATION_ID - contract ID in MySales system;

  • RECEIVERS - list of stores (or warehouse) IDs for which delivery will be made. Values should be comma separated (leave empty if ALL_STORES is 1);

  • ALL_STORES - value "1" if delivery is for all stores and "0", otherwise;

  • SKUS - a list of products IDs which will be delivered. Values should be comma separated (leave empty if ALL_SKUS is 1);

  • ALL_SKUS - value "1" if all products are delivered under the contract and "0", otherwise;

  • TYPE - type of schedule (schedule on a weekly basis or for a whole month) - the values of the field "W" for the week and "M" for the month;

  • MORNING - morning delivery identifier - “1” if delivery occurs in the morning and “0” in other cases;

  • INTERVAL - the repetition interval of the delivery schedule (1 - every week / month, 2 - every two weeks / month, etc.);

  • RPM_DAYS - days in which the order will be made, should comma separated. From 1 to 7 for the weekly format (where 1 is Monday, 7 is Sunday) and from 1 to 30 for the monthly;

  • DELIVERY_DAYS - the number of days between order and delivery for stores. Should be filled for each order day from the field RPM_DAYS (comma separated);

  • DELIVERY_DAYS_WHS - the number of days between order and delivery for warehouse. Should be filled only for cross-dock orders;

  • PLUS_D1_FCST - +D1 coefficient;

  • PLUS_D1D2FCST - +D1D2 coefficient, at the store level;

  • REQUIRES_CONFIRM - store orders manual confirmation indicator - "1" must be manually confirmed, "0" - the order will be automatically confirmed;

  • AUTOCONFIRM - time of automatic confirmation of the order - only for orders with manual confirmation (optional field);

  • WHS_REQUIRES_CONFIRM - warehouse orders manual confirmation indicator - "1" must be manually confirmed, "0" - the order will be automatically confirmed;

  • SEPARATE_PROMO - indicates if promo items should be separated from the main order;

  • PROMO_REQUIRES_CONFIRMATION - indicates if separated order with promo items requires confirmation;

  • MIN_ORDER_QTY_STORE - minimum store order quantity;

  • MIN_ORDER_AMOUNT_STORE - minimum store order amount in money;

  • MIN_ORDER_QTY_WHS - minimum warehouse order quantity (only for cross-dock);

  • MIN_ORDER_AMOUNT_WHS - minimum warehouse order amount in money (only for cross-dock);

  • SUPPLIER_EMAIL - supplier manager email

  • ALLOW_EDIT_ORDER - edit of order quantity permission - the value "1" allows editing, "0" prohibits editing;

  • ALLOW_EDIT_STOCK - edit of stock quantity permission - the value "1" allows editing, "0" prohibits editing;

  • START_DATE - diagram start date (in the format YYYY-MM-DD);

  • END_DATE - diagram expiration date (in the format YYYY-MM-DD) - optional field, leave empty if the end date is open.

...