DBC: Vendors > Vendor Tracking File
The purpose of the reconciliation file being sent by our vendors to us is to inform us when that particular order has completed production and has shipped.
Frequency
Each vendor will have the ability to transmit this file to DemandBridge as many times per day as needed. They should work this into their production workflow.
File Transfer Method
DemandBridge has set up an FTP site with a logon/password pair to accept inbound only reconciliation files. Logon information is as follows:
| FTP Address | ftp.demandbridge.com |
| Username | reconcile |
| Password | recon |
File Name Convention
The reconciliation files need to be named with the following convention.
VV_MMDDYYYY_HHMM.CSV
| VV | 2 letter vendor name (See DemandBridge for details) |
| MM | Month of file creation |
| DD | Day of file creation |
| YYYY | Year of file creation |
| HH | Hour of file creation |
| MM | Minute of file creation |
| CSV | File extension of CSV |
File Contents
The file should be a *Quote – comma – Quote* file type with the following layout.
| Field #1: | DemandBridge Order Number AND Line Number |
| Field #2: | Shipper (Ex: UPS, FedEx) |
| Field #3: | Shipper tracking number |
| Field #4: | Date Shipped (mmddyyyy) The date must be 8 digits |
| Field #5: | Time Shipped (hhmm) The timestamp must be 4 digits |
| Field #6: | Numeric distributor identifier (See DemandBridge for details) |
Sample File
"02-A00123-2","UPS","1Z2772400322207884","03302004","1451",”99”
"03-A00123-1","UPS","1Z2772400322207884","03302004","1451",”99”
"02-A00122-5","UPS","1Z2772400322207884","03302004","1451",”99”
"01-A00125-1","UPS","1Z2772400322207517","03302004","1058",”99”