ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
TabLabelDefinition
3
Acquired Price
4
Order NumberThe order number attached to the shipment of medications
5
Order DateThe date the order was made (DD/MM/YYYY)
6
Order ReceivedThe date the order was received (DD/MM/YYYY)
7
SupplierThe name of the supplier the order was issued from (i.e. BGA, Masters US, Janssen)
8
CountryThe country the supplier is located (I.e. USA, Canada, UK)
9
Medication DescriptionThe full name of the medication and the strength
10
Medication NumberThe medication identifying number assigned by the country of origin (I.e. NDC, DIN)
11
Purchase QtyThe total amount of medication ordered (i.e. the total amount of pack sizes ordered)
12
Pack sizeThe size the medication comes in (i.e. 25 per pack)
13
UnitThe type of unit the pack size comes in (i.e. Tablet, Milliliters)
14
Cost per packThe cost of one pack size from supplier
15
Cost of full orderThe cost of the whole order for all medication from supplier, not just the price of the medication on the drug formulary list
16
Additional Cost per orderThe total(Sum) amount of the indirect costs associated with the order. The total amount attached to the order number in the indirect cost tab
17
TotalAuto calculated (Cost per order + additional cost per order)
18
Indirect Cost
19
Order NumberThe order number attached to the shipment of medications requested from supplier
20
CategoryThe type of additional charges attached to the order number, such as, shipping fees, handling fees, insurance fees, Bank transaction fee, delivery fees. Each new cost category should have its own row
21
Order CostThe cost of the individual category items
22
Comments
23
Retail Price
24
Date Rx filledThe Date when the Rx was filled (DD/MM/YYYY)
25
Medication DescriptionName of drug including strength
26
Quantity dispensedThe amount of medication dispensed for Rx
27
Final prescription PriceFinal cost (CHANGE TO FINAL PRESCRIPTION PRICE) includes retail price + dispensing fee before any insurance and/or discounts are applied
28
Name of insurance Name of insurance (if no insurance put CASH or NONE)
29
Amount paid by insuranceTotal amount paid by insurers (if none, state 0)
30
Discount % The percentage of the discount applied to Rx filled (If applicable)
31
Discount in dollar valueThe dollar amount of the discount applied to Rx filled (If applicable)
32
Amount charged for copay Total amount paid by patient (if none, state 0)
33
DISPENSING FEE amount applied
The amount charged to patient for the despensing fee
34
Retail price The amount you charge for that Rx (Note: not the same as acquired landed cost, unless your charge amount is same as landed cost)
35
AWP IF YOU HAVE IT ON REPORT(Aquired Wholesale Price - actual cost ) If available on your report , please include here
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100