No Longer Available (NLA) Items File
Description & Use Cases
The nla file provides a list of items that are no longer available for purchase from the manufacturer. Typical uses for this file are the following:
To maintain status of parts in customer systems
To upload to internal systems
To status on customer websites
Note: Parts listed in the NLA file are not necessarily unavailable from Gardner. We may have inventory onhand, but when that inventory is depleted, its likely we will not be able to re-order.
Schedule
The file is extracted weekly and expected to be available by 8am on Monday.
Delivery
The file will be delivered via ftp to a Gardner or customer ftp location.
File Layout
The file will be delivered in csv format. Description of fields below:
ManufacturerCode Varchar(3) Gardner Manufacturer Code
ItemNumber Varchar(33) Gardner Item Number
ManufacturerItemNumber Varchar(30) Manufacturer Item Number
Status Varchar(33) Fixed Value: NLA
Naming Convention
NLA_{Customer Number}_{YYYY-MM-DD}T{HHMMSS}.csv