# | Name | Location | Type | Details | Index | Description |
---|---|---|---|---|---|---|
.01 | oracle document id(+) | 0;1 | FREE TEXT | B | This is document number send by the ORACLE system. | |
1 | batch number | 0;2 | FREE TEXT | This is a batch number. | ||
2 | line number | 0;3 | FREE TEXT | This is a line number. | ||
3 | credit card number | 0;4 | FREE TEXT | This is a credit card number. | ||
4 | bank's vendor id | 0;5 | FREE TEXT | This is a vendor id of Rocky Mountain Bank. | ||
5 | statement date | 0;6 | DATE-TIME | D | This is a statement date. | |
6 | transaction date | 0;7 | DATE-TIME | This is the transaction date. | ||
7 | station number | 0;8 | FREE TEXT | This is the station #. | ||
8 | purchase date | 0;9 | DATE-TIME | This is the purchase date. | ||
9 | txn reference # | 0;10 | FREE TEXT | This is the transaction reference number. | ||
10 | bbfy | 0;11 | DATE-TIME | This is the beginning budget fiscal year date. | ||
11 | ebfy | 0;12 | DATE-TIME | This is the ending budget fiscal year. | ||
12 | accounting period | 0;13 | NUMERIC | This is the accounting period. | ||
13 | amount | 0;14 | NUMERIC | This is the transaction amount. | ||
14 | fiscal year | 0;15 | NUMERIC | This is a fiscal year. | ||
15 | status | 0;16 | SET OF CODES | R:RECONCILED N:NONE D:DISPUTED | This is the status of a entry. | |
16 | card holder | 0;17 | POINTER | 200 | This is a card holder. | |
17 | et code sheet ri | 0;18 | FREE TEXT | This an is ET-code sheet ri of file 2100.1 in free text format. | ||
18 | committed amount | 0;19 | NUMERIC | This is a committed amount copied from 410 if the final payment is reconciled. | ||
19 | old po status code | 0;20 | FREE TEXT | This is the old status code of p.o. | ||
20 | vendor purchase order | 0;21 | FREE TEXT | C | This is the purchase order id provided by the vendor. | |
21 | fund code | 5;1 | FREE TEXT | This is a fund code. | ||
22 | acc code | 5;2 | FREE TEXT | This is a acc code. | ||
23 | cost center | 5;3 | FREE TEXT | This is a cost center. | ||
24 | boc | 5;4 | FREE TEXT | This is a BOC. | ||
25 | approving office | 5;5 | FREE TEXT | This is a approving office code. | ||
26 | approval date | 5;6 | DATE-TIME | This field is used to store the date when the approving official signed off on the PO corresponding to the reconciled Oracle transaction. | ||
27 | approving official | 5;7 | POINTER | 200 | This field is used to store the approving official. | |
31 | merchant name | 6;1 | FREE TEXT | This is a merchant name. | ||
32 | merchant address 1 | 6;2 | FREE TEXT | This is mechant address 1. | ||
33 | merchant address 2 | 6;3 | FREE TEXT | This is the merchant address 2. | ||
34 | merchant city | 6;4 | FREE TEXT | This is the merchant city. | ||
35 | merchant state | 6;5 | FREE TEXT | This is the merchant state. | ||
36 | merchant zip | 6;6 | FREE TEXT | This is the merchant zip. | ||
41 | purchase order | 1;1 | POINTER | 442 | This is a purchase order field. | |
42 | receiving required | 1;2 | BOOLEAN | Y:YES N:NO | This is a RECEIVING REQUIRED data field. | |
43 | complete order received(+) | 1;3 | BOOLEAN | Y:YES N:NO | This is the MERCHANT RECEIVED data. | |
44 | final charge(+) | 1;4 | BOOLEAN | Y:YES N:NO | This is the FINAL CHARGE data field. | |
45 | reconcile user | 1;5 | POINTER | 200 | This is the reconcile user data. | |
46 | reconcile date | 1;6 | DATE-TIME | This is a reconcile date. | ||
47 | charge receiving date | 1;7 | DATE-TIME | This field is filled in whenever the field .01 is populated and will hold the arrival date/time of the ORACLE charge data in the file. Users should not try to edit this field directly. |