Transferring supply plan data

The supply plan data type is used to determine the replenishment possibilities. This data type is used to determine when the inventory will be replenished and will the inventory replenishment avoid stockout.

Procedure

To create the supply.csv files, specify the following details.
1. For the file name, use SUPPLY_[CUSTOMER NAME]_YYYYMMDDHHMISS.csv format.
2. For the separator, use the comma (,).
3. Upload multiple .csv files by compressing them into a tar.gz file.

Review the following fields and descriptions for the supply plan data:

Table 1. Supply plan data descriptions
Field Name	Required	Type	Description
Item ID	Yes	STRING	The identifier of an item that is to be supplied or replenished.
Item UOM	No	STRING	The unit of measure for an item that is to be supplied or replenished. The valid values are Each, Pallet and Pound. The default unit of measure is Each.
Item class	No	STRING	The class of an item that is to be supplied or replenished.
Ship node	Yes	STRING	The ship node is a store or distribution center (DC) where an item is to be supplied or replenished.
Segment	No	STRING	The specific segment under the segment type on which the item is categorized.
Segment type	No	STRING	The type of the item's segment based on which the item is categorized.
Reference	Yes	STRING	Reference is an attribute of a supply that is defined as identifiers for the records. Reference can be the order number that is associated with the supply.
Line reference	No	STRING	The line reference of the supply.
Reference type	No	STRING	The reference type of the supply. This can be any string value that represents the type of value that is passed as reference. For example, it can be the order type.
Tag ID	No	STRING	The tag identifier of the supply. The tag identifier is categorized as lot number, batch number, and revision number.
Supply base type	Yes	STRING	The type of supply for an item. The possible supply base types are ONHAND, PO_PLACED, and INTRANSIT.
Supply type	No	STRING	The customized supply type that can be defined for an item.
Supply quantity	Yes	DOUBLE	The number of items supplied.
Supply changed quantity	No	DOUBLE	The quantity of supply that is changed.
Supply date	Yes	STRING	The date on which the item is supplied or replenished. The timestamp uses the ISO 8601 standard format, YYYY-MM-DDTHH:MM:SS.000Z.
Supply expiry date	No	STRING	The date on which the supply ends. The timestamp uses the ISO 8601 standard format, YYYY-MM-DDTHH:MM:SS.000Z.
Supply adjustment reason	No	STRING	The reason for adjustment of supply.
Supply updated timestamp	No	STRING	The timestamp at which the supply plan is updated. The timestamp uses the ISO 8601 standard format, YYYY-MM-DDTHH:MM:SS.000Z.

Review the following sample command to upload a single file to the <tenantId>/UPLOAD/SUPPLY/ virtual folder on IBM Cloud® Object Storage:
```
./cos_transfer_client.sh -conf transfer.options -op UPLOAD -dataType SUPPLY -src /path/to/local/SUPPLY_TENANTID_20240513170423.csv
```
Review the following sample command to upload all files from a local directory to the <tenantId>/UPLOAD/SUPPLY/ virtual folder on IBM Cloud Object Storage:
```
./cos_transfer_client.sh -conf transfer.options -op UPLOAD -dataType SUPPLY -src /path/to/local/directory
```

Review the following sample .csv file:

item_id,item_uom,item_class,ship_node,segment,segment_type,reference,line_reference,reference_type,tag_no,supply_base_type,supply_type,supply_qty,supply_changed_qty,supply_date,supply_expiry_date,adjustment_reason,supply_updated_ts
I1,EACH,CLASS1,intNode1,MERCH,ONLINE,101,,,,PO_PLACED,PO_PLACED,50.0,10.0,2024-10-02T00:00:00.000Z,2500-01-01T00:00:00.000Z,,2024-07-17T15:43:19.473Z
I2,EACH,CLASS1,intNode1,MERCH,ONLINE,102,,,,PO_PLACED,PO_PLACED,60.0,10.0,2024-10-02T00:00:00.000Z,2500-01-01T00:00:00.000Z,,2024-07-17T15:43:23.041Z
I3,EACH,CLASS1,intNode1,MERCH,ONLINE,103,,,,ONHAND,ONHAND,60.0,10.0,1900-01-01T00:00:00.000Z,2500-01-01T00:00:00.000Z,,2024-07-17T15:43:23.041Z