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