Fulfillment network cutoff data type (TP)

The fulfillment network cutoff data type data specifies the daily cutoff for fulfilling orders.

The fulfillment network cutoff data type overrides the data in the fulfillment network data type. If a date is specified in this data, the date overrides day values.

When an order is sent to Fulfillment Optimizer, the local time at the ship node is checked against the cut-off time defined in time-period/fulfillment network cutoff data type for that particular day. If the local time is past the cut-off time, the next day is considered for shipping and so on. A day is also reduced from the SLA days or the days to deliver.

Since the data files are not large, delta uploads are not supported.

File name and separator

This data type uses the comma (,) separator.

The recommended format for the file name is: FNC_[CUSTOMER NAME]_YYYYMMDDHHMISS.csv

where YYYYMMDDHHMISS is the date and time at which the file is transferred to Fulfillment Optimizer.

For example,
  • If you send a file on July 23, 2018 at 8:30 AM EST, the file name is FNC_[CUSTOMER NAME]_2018072308300000.csv
  • If you send a file on July 23, 2018 at 10:45 AM EST, the file name is FNC_[CUSTOMER NAME]_2018072310450000.csv
Note: Duplicate file names are not allowed.

Fields

Table 1. Table 1 displays the fields and descriptions for the fulfillment network cutoff data type.
Field Name Required Type Description
Node key Yes String The Node Key attribute corresponds with a specific node type, such as Store, distribution center, 3rd party vendor, etc.
Cutoff date Conditional Date Either a date or a day of the week that is specified for the last day to be used to fulfill an order. The format for the date is YYYY-MM-DD.
Cutoff day of week Conditional INT Either a date or day of week can be specified for fulfillment.
  • 1=Sunday
  • 2=Monday
  • 3=Tuesday
  • 4=Wednesday
  • 5=Thursday
  • 6=Friday
  • 7=Saturday
Cutoff time Yes Time The cutoff time for the date or the day of week specified. For example, 17:00 can be the cutoff time for a given day if no orders are fulfilled after that time.

The format for the time is HH:MM in a 24 hour format.

The time zone for the cutoff time must be the same as the time zone of the ship node.

Sample for FNC_[CUSTOMER NAME]_YYYYMMDDHHMISS.csv

Node_Key, Cutoff Date, Cutoff day of week, Cutoff Time

1296,,6,03:00

1300,2018-06-01,6,03:00

Sample script to upload data by using the file adapter

/<Install_dir>//AsperaClientLinuxDist/asperaTransferClient.sh -jobname TPPush 
-contentType TP -server -userid -password -op UPLOAD -src -dest/TP 
-conf /<Install_dir>//AsperaLinuxDist/asperaTransferOption.properties