Customer File Format
File: [CUSTTXN.ASC]
Store Manager application: Place file in the parm subdirectory of the Xpress Server.
Field Number and Name | Field Type or Mask | Possible Values |
|---|---|---|
1 Update Type * | Decimal 2.0 | 1 - Add 2 - Modify 3 - Deletes all bucket data as well as the bucket definition 99 - Delete File |
2 Customer Number | String 14 | |
3 Reference Number 2 | String 20 | |
4 Reference Number 3 | String 20 | |
5 Last Name | String 40 | |
6 First Name | String 20 | |
7 Middle Name | String 20 | |
8 Address Field 1 | String 40 | |
9 Address Field 2 | String 40 | |
10 City | String 20 | |
11 State/Province | String 10 | |
12 Zip/Postal Code | String 10 | |
13 Country | String 20 | |
14 Phone Number 1 | String 10 | |
15 Phone Number 2 | String 10 | |
16 Customer Type | Decimal 2.0 | Regular/Business Customer Indicator |
17 Customer Status | Decimal 2.0 | |
18 Birth Date | String 8 | YYYYMMDD |
19 Title Type | Decimal 1.0 | 0 - No Title 1 - Mr. 2 - Mrs. 3 - Ms. 4 - Miss |
20 Customer Price Level | Decimal 2.0 | 0 - 99 |
21 Auto Discount ID | Decimal 3.0 | 0 - 99 |
22 Transaction Discount % | Decimal 3.3 | Discount % for Auto Discount ID |
23 Internal Reference # | Decimal 9.0 | Internal customer refNum |
24 Last Update Date | String 8 | YY/MM/DD (date of last update) |
25 Original Purchase Date | String 8 | YY/MM/DD |
26 Previous Purchase Amount | Decimal 7.2 | |
27 Previous Purchase Date | String 8 | YY/MM/DD |
28 Period Sales | Decimal 7.2 | |
29 Period To Date Visits | Decimal 4.0 | |
30 Previous Period Sales | Decimal 7.2 | |
31 Previous Period Visits | Decimal 4.0 | |
32 Charge Account Limit | Decimal 7.2 | |
33 Total Charges | Decimal 7.2 | |
34 Total Payments | Decimal 7.2 | |
35 Last Payment Amount | Decimal 7.2 | |
36 Last Payment Date | String 8 | YY/MM/DD |
37 Points Earned | Decimal 9.0 | |
38 Points Redeemed | Decimal 9.0 | |
39 Previous Redeem Points | Decimal 9.0 | |
40 Previous Redeem Date | String 8 | YY/MM/DD |
41 Loyalty Program ID 1 | Decimal 2.0 | 1 - 20 |
42 Loyalty Program ID 2 | Decimal 2.0 | 1 - 20 |
43 Loyalty Program ID 3 | Decimal 2.0 | 1 - 20 |
44 Loyalty Program ID 4 | Decimal 2.0 | 1 - 20 |
45 Gender | String 1 | M – Male F – Female |
46 Secondary Price Level | Decimal 2.0 | 0 - 99 |
47 Price Rule | Decimal 2.0 | Default 0 |
48 Print Address Receipt | Decimal 1.0 | Default 0 |
49 Display Customer Name | Char 1 | Y,N |
50 Reason Code Description | String 40 |