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 Costs
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
Wholesalers
24
Date Order RequestedThe date the order was made by the pharmacy (DD/MM/YYYY)
25
Date Order FilledThe date the order was received by the pharmacy (DD/MM/YYYY)
26
Pharmacy NameName of the purchasing Pharmacy
27
Order numberThe order number attatched to the Pharmacy's purchase
28
Medication DescriptionThe full name of the medication and the strength
29
Quantity Purchased (# of packs)
The total amount of medication ordered (i.e. the total amount of pack sizes ordered)
30
Pack sizeThe size the medication comes in (i.e. 25 per pack)
31
Pharmacy Total Purchase Price
The total amount paid by the Pharmacy
32
Phamacy Price Per PackageThe price the pharmacy paid per package
33
34
35
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