PilotERP – E-commerce Interface Specifications
File Format
The file format will be a comma delimited file where fields are separated by a ,
Bold Fields are required.
On file contain all the records below, starting with Customer, Order Master then Order Details.
File Layout
Each field will have the following specifications:
| Customer |
|
| |
| Field | Type | Length | |
0 | Record Type | “CUSTOMER” |
| |
1 | CustomerNo | String | 10 | |
2 | CustomerName | String | 40 | |
3 | AddressLine1 | String | 35 | |
4 | AddressLine2 | String | 35 | |
5 | City | String | 35 | |
6 | StateProv | String | 20 | |
7 | ZipCode | String | 10 | |
8 | Country | String | 20 | |
9 | Contact | String | 35 | |
10 | Phone | String | 20 | |
11 | Fax | String | 02 | |
12 | String | 50 | ||
13 | WebPage | String | 50 | |
14 | Tax No | String | 20 | |
15 | Notes | Memo |
| |
| ||||
| Order Master |
|
| |
| Field | Type | Length | |
0 | Record Type | “MASTER” |
| |
1 | OrderNo | String | 10 | |
2 | OrderDate | Date |
| |
3 | Required Date | Date |
| |
4 | PO Number | String | 20 | |
5 | Freight Method | Integer |
| |
6 | Order Status | Integer |
| |
7 | Description | String | 50 | |
8 | Order Amount | Float |
| |
9 | Notes | Memo |
| |
10 | Freight Amount | Float |
| |
11 | Expected Ship Date | Date |
| |
12 | Project No | String | 20 | |
|
|
|
| |
| Order Details |
|
| |
| Field | Type | Length | |
0 | Record Type | “DETAIL” |
| |
1 | Seq | Integer |
| |
2 | QtyOrdered | Float |
| |
3 | ItemID | Integer |
| |
4 | UnitPrice | Currency |
| |
5 | ReqShipDate | Date |
| |
6 | Expected Ship Date | Date |
| |
7 | Notes | Memo |
| |