What the RxMiniTM file is: It is a small text file in plain ASCII fixed-width format.
How the RxMiniTM file gets created: The user clicks on a pushbutton in the MS EXCEL workbook
that he/she receives. A VBA macro inside the workbook creates the file on the user’s PC.
Where the RxMiniTM file resides: Configurable; defaults to c:\RxMini.txt
How the RxMiniTM file gets used: The user can have an "adapter" program that can read a generic file and
import its data into his/her company's Financials system. By definition, the program that reads the RxMini® file
is called the RxAdapter® program.
Reading the data: The file has 4 record types. The character in the first column indicates the record type.
One Header record:
01-01 Record type “[”
02-11 Manufacturer/Seller Name. Left-Justified, Blank-Filled.
12-21 Payee Name. Left-Justified, Blank-Filled.
22-41 Reference (Payee invoice number if available).
42-49 Submission/Invoice Signed Date. YYYYMMDD.
50-57 Submission Processed Date. YYYYMMDD.
Zero or more Detail records - one per NDC.
01-01 Record type “N”
02-14 NDC of the product, with the dashes
15-24 Quantity in prescription units (TABs, MLs). Integer, Right-Justified, Zero-Filled.
25-37 Calculated Rebate Amount. Two explicit decimals, R-J, Z-F.
38-50 Requested Rebate Amount. Two explicit decimals, R-J, Z-F.
If any of these last 3 amounts is less than zero, the first position is a minus sign.
One Trailer record:
01-01 Record type “]”
Any number of comments, interleaved within any other lines.
01-01 Record type “*” (an asterisk)
02+ Comment text
Notes:
The payable amount is always the Calculated Rebate Amount.
The Requested Rebate Amount is for reference only, and it equals the amount that payee requested if
(a) the payee requested one AND (b) the payer instructed RxContracts, Inc. to reconcile it.
In all other cases, this amount is listed as zeroes.
Sample file
* RxMini file for import into Financials
*
[Mfr Payee Invoice_Number 2001040620010407
N12345-1234-1200000000300000000001.230000000001.22
N12345-1234-13-000000100-000000004.000000000000.00
]
The invoice above was signed by the Payee on 4/6/2001.
The data was processed by RxContracts, Inc. the next day.
The first data row was for NDC 12345-1234-12, 30 prescription units. The rebate was calculated as $1.23. The payee had requested $1.22.
The second data row was for NDC 12345-1234-13, -100 prescription units, probably a return. The rebate was calculated as -$4.00. The payee
had neither requested nor offered any rebate.
