PURPOSE
When a third-party warehouse receives goods from suppliers, a csv file is created and placed in an ftp location.
The internal process imports this file into a local file system on a schedule and creates a PO Receipt record.
OVERVIEW
Each file should correspond to a single purchase order. The file should contain a single header line and a line for each type of product received. There may be multiple receipt files per purchase order but there cannot be lines corresponding to multiple purchase orders in a single receipt file.
CSV FORMAT
File Format
Format Type | Requirement | Notes |
File Type | CSV |
|
Delimiter | [,] | Comma |
Encoding | UTF8 |
|
Header | Mandatory |
|
File Name | GRNyyyymmdd-hhmmss.nn.csv | (i.e. GRN20101028-153000.01.csv)
|
Field Quote | Required | “[data]” |
Escape Chars | Not allowed | (i.e. \) |
FILE DATA
Header Data
Column Name | Format | Notes |
ClientID | String (x10) | Constant – “WD40” |
OwnerID | String (x10) | Constant – “WD40” |
PONum | Int (x20) | WD40 Internal PONum |
RcvDate | String (x15) | Date of receipt (“ddMMyyyy”) |
SiteID | String (x10) | Constant – “*WhseCode*” (Warehouse location) |
DeliveryID | String (x30) | Unique warehouse defined external delivery ID |
LineType | String (x10) | Constant - “HGRN” |
Detail Data
Column Name | Format | Notes |
PartNum | String (x30) | WD40 internal PartNum or warehouse barcode |
LineNum | Int (x6) | File line number |
RcvQty | Int (x15) | Quantity received |
Unused Column | String (x10) | Constant – “” (Unused) |
LockCode | String (x10) | Constant – “” (Unused) |
Comment | String (x30) | Constant – “” (Unused) |
LineType | String (x10) | Constant - “LGRN” |
*Note there is no header description row. Header and detail lines are identified by the line type column.