Sample Fixed Width File Format Table

The following table conveys information about the fields to be included in a Transaction data file in their native file format. A table such as this enables TIBCO Reward’s engineers to set up an automated process for transforming the file every time it is sent.

Fixed Width File Format
Field# Field Description Type Length Decimal Location Notes
1 Transaction ID A 9 1
2 Store number S 4 0 10
3 Date S 8 0 14 CCYYMMDD
4 Time S 6 0 22 HHMMSS
5 Line item S 6 0 28 1
6 Line item amount S 9 2 34 Money (for example, 2000)
7 SKU A 10 43 for example, 8765309
8 Line item quantity S 6 0 53
9 Account number S 13 0 59
10 Name, first A 16 72
11 Name, middle initial A 1 88
12 Name, last A 20 89
13 State/province A 2 109
14 Zip + four A 9 111
15 Expiration date S 8 0 120 CCYYMMDD
16 Contract date S 8 0 128 CCYYMMDD
17 Reward amount allowed S 9 2 136 Money - 10% of dues amount paid
18 Shopper status A 1 145 “A”=Active, “I”=Inactive