Fred Dispense Transfer to POS Specification

This topic explains the Fred Dispense configuration and specifications for sending dispensary information (as ASCII or database files) to a POS system on the same network.

There are three POS feed formats:

  • Fred2POS
  • Fred4POS
  • Fred8POS

In this topic

Configuration in Fred Dispense

POS Recommended Processing

Maintenance

Reports

Field Explanatory Notes

Configuration in Fred Dispense

Set up transfer to POS

  1. From the Setup menu, select Dispense Options.

    The Fred Dispense Configuration window is displayed.

  2. Select the POS/Debtor Link Options tab.
  3. In the POS System Link field, enter Y.
  4. From the Type list box, select the required file format:
    • POS will transfer using the Fred2POS.DBF, Fred4POS.DBF, and Fred8POS.DBF database file.

    • POSF will transfer using the ASCII Fred2POS.DAT , Fred4POS.DAT or Fred8POS.DAT file.

      When transferring to POS via the Fred2POS.DAT , Fred4POS.DAT or Fred8POS.DAT file, the Fred2POS.DBF, Fred4POS.DBF, or Fred8POS.DBF database file is maintained at the same time to enable simple resending of transactions.

  5. If you selected POSF, enter the server directory path that Fred2POS.DAT , Fred4POS.DAT or Fred8POS.DAT file will be created in, in the text box below the POS System Link field.

    For example, if you enter \FredHealth\Fred, the Fred2POS.DAT , Fred4POS.DAT or Fred8POS.DAT file will be created in the \FredHealth\Fred directory on the Fred server.

    It is preferred to configure the system to write the transfer file to the Fred Server, to avoid dispensing problems if any network issues occur. On re-establishing the network, the POS system can then process the transactions that have accumulated during the network down time.

Transaction processing by Fred Dispense

Fred Dispense endeavors to keep the POS figures accurate with respect to Sales and Stock Levels. At the end of each dispensing, a POS Transfer Record (Format detailed in Field Explanatory Notes) is sent to the POS system to keep stock levels up to date, automatically debit customer accounts or provide information at the till to be able to produce an itemized receipt.

Fred Dispense keeps a copy of the last 6 days of transactions sent to the POS system in the Fred2POS.DBF, Fred4POS.DBF, and Fred8POS.DBF database file. For whatever reason, transactions can be re-sent from the Fred Menu ([Alt+F)] and Browse POS Trans. Changing the ‘Sent’ field from 'Y' to 'N' triggers Fred to re-send the transaction to the POS System.

Cancelling a script within Fred sends a cancellation record to the POS system to place the script item back in stock. Modifying the price or quantity of a script on Fred does NOT send a single transaction adjustment. The adjustment is handled by sending a cancellation ([X]) for the original script and sending a new [A]ctive record.

Owing Scripts dispensed on Fred results in a transaction being sent immediately to the POS system for Charging and Stock adjustment. The Owing Script Mark-off does not send any transactions unless script information is changed requiring a Cancel/Send to keep the POS system accurate.

Deferred Scripts are not dispensings, which supply stock, so Fred does not send a transaction to the POS. Dispensing the deferred item is treated as a normal dispensing resulting in a transaction being sent to the POS system.

When editing scripts with Fred, the following script modifications will cause a Cancel Transaction and New Transaction to be sent to the POS:

  • Script Type e.g. [N]HS to [P]rivate
  • Drug e.g. Amoxil Caps 250mg -> 500mg
  • Quantity e.g. 50 -> 25
  • Patient Price e.g. $3.40 -> $2.70
  • Government Recovery e.g. $4.05 -> $4.15 because of choice of different Solvent

POS Account Customers

Within each Patients Details (found in Patient Update in [Extra Information] - [Ctrl+I] for fast access), exists the fields 'Account No' and 'Direct Charging'. This is where the Debtor Account No, that exists on the POS for the chosen Patient can be supplied. Dispensing for a patient with their 'Account No' entered and 'Direct Charging' set to "Y", should directly send the charges to the patients Account.

If the Patient pays for some things, but wants other things on Account, the 'Direct Charging' can be set to "N". When an item is dispensed for this patient, it should wait on the Till to be made a cash sale and receipt printed or placed on the patients account (where the Account No. is also supplied) if an account charge is required.

When modifying the price/quantity of a script for a customer with an account, the system checks to see whether the patient price is modified. If the patient price is the same, there is no need to have a debit and credit for the same amounts, so the system inserts the Dummy Account number as supplied in the Owner details. This is to try and keep the patient accounts as tidy as possible.

POS Recommended Processing

Communication with Drug Wholesalers

There are 4 major drug wholesalers in Australia. All have different product codes, different transmission protocols, different types of electronic invoicing. All ordering is done electronically using PDE units/modem from POS. The systems return out of stock notifications and the customer may then order again next order (up to twice daily) or change the order to the alternative wholesaler.

  1. Receive updated product files and prices from the wholesaler.
  2. Send orders to the wholesaler and receive out-of-stock lines back.
  3. Re-order out-of-/stock items from a second supplier.

Recommended Processing

To process the transactions fromFred2POS.DAT , Fred4POS.DAT or Fred8POS.DAT that are created by Fred, it is recommended that the POS system processes the Transaction file at regular intervals, say every 15 seconds, or every time a sale is about to take place at the till. The POS system should rename the Transaction file before commencing processing, to ensure NO locking problems occur. Depending how the POS system handles the transaction processing, it may have to handle renaming the file to a unique name for each POS terminal to ensure no locking problems are encountered. It is possible that the POS system could attempt to rename the Fred2POS.DAT , Fred4POS.DAT or Fred8POS.DAT file just as Fred opens it to append more POS Transfer records. The POS system should not continue processing until it successfully renames the file, which won't be for long, as Fred takes very little time to add any Transactions records and close the file.

See Field Explanatory Notes for information on the formats.

POS Transaction File Processing Steps

  1. Read All transactions - Automatically process any account customer transactions that are flagged for direct account debiting.
  2. Sort remaining Transactions by Surname or Account Number and allow the operator to select particular customers transactions.
  3. Allow the operator to select individual line items from the transaction list to add to a sale or account.
  4. Allow easy select all or select individual line items from the transaction list.

Example

A customer has 4 items dispensed for him and his wife 3 items. The details of these items e.g. code, qty, sale price, wholesale price, account code etc. are sent by the dispense program, via the Transactions file (on our server) to the POS system.

The POS program should try to process this file in say 15sec intervals, and hold the transactions in a format compatible for use by the POS system. A new file is created by the dispense program.

These transactions may sit on the file for days until collected by a customer. When the customer presents, the clerk brings up the customer usually using a surname search - One letter, start of surname is usually enough. The display shows only matching surnames, which have scripts waiting for collection. The clerk chooses the customer from the list and a list of items waiting to be collected is displayed. The clerk chooses all or specific items to add to the sale. A 2nd customer (i.e. wife/husband) script items may then be added to the same sale using same method. Additional nonprescription items may be scanned/added at the till before totaling and proceeding with the sale.

As transaction data can contain the customer’s account number on the POS, this account number is included, so the clerk doesn’t have to locate the customer’s account number on the POS, if the customer chooses to have items added to ther account. The feature exists which allows account customers who we deliver the script items to (e.g. in nursing home so don’t come into your store) to automatically process the transactions in the background without clerk intervention. A flag in the data tells the POS to auto charge the items to customer account.

This prescription transaction-processing feature occurs in over 60% of all sales so must be a singlekey access with smart processing to be successful.

Maintenance

Allowances for down periods are desirable. That is, manually process stock sale, and later process items in the transaction file to reduce stock but not to add to money sales figures.

Void items in transaction log, i.e. returned to stock

Reports

Scripts awaiting collection, i.e. still in transaction file

Transaction log report

Field Explanatory Notes

All fields relate to one dispensing, but named fields starting with:

  • XS are more script-related data.
  • XP are more patient-related data.
  • XD are more drug-related data.

All 'Logical' fields have the values of Y or N in the Fred2POS.DAT , Fred4POS.DAT or Fred8POS.DAT ASCII file.

All 'Numeric' fields that include a value for Decimal Place, use a floating decimal point. So, for example, if a field has a Width of 7 and Decimal Place of 2, it can display:

  • 2 decimal points up to 9999.99
  • 1 decimal place for 10000.0 to 99999.9
  • 0 decimal places for 100000 to 999999

Shown below are the fields and their content, to assist with the processing from a Fred Dispense Fred2POS, Fred4POS, and Fred8POS transfer file.

Fred8POS

Field Field Name Type Width Dec Additional Information
1 XSTATUS Character 1   Transfer Status Type
2 XDEDUCTSTK Logical 1   Deduct Stock
3 XSTOCKLOCN Character 4   Stock Location
4 XSRXNO Numeric 8   Script Number
5 XTRANSDATE Character 9   Transaction Date
6 XSTYPE Character 1   Script Type
7 XSPATPRICE Numeric 7 2 Script Patient Price
8 XSSNAMT Numeric 5 2 Safetynet Amount
9 XSWSCOST Numeric 7 2 Wholesale Cost
10 XSGOVRECOV Numeric 7 2 Government Recovery Amount
11 XSDRUGDESC Character 40   Drug Description
12 XSALTDESC Character 30   Alternate Description
13 XSLDRUGORD Character 1    
14 XDDRUGCODE Character 6   Fred Drug Code
15 XDAPNCODE1 Character 13   Barcode 1
16 XDAPNCODE2 Character 13   Barcode 2
17 XDSCODE1 Character 3   Supplier Identifier Code 1
18 XDPDENO1 Character 20   Reorder Number 1
19 XDSCODE2 Character 3   Supplier Identifier Code 2
20 XDPDENO2 Character 20   Reorder Number 2
21 XDUSERCODE Character 6   User Drug Code
22 XDNAME Character 30   Drug Name
23 XDFORMABB Character 10   Drug Form
24 XDSTRENGTH Character 20   Drug Strength
25 XDGENNAME Character 30   Drug Generic Name
26 XDPACKSIZE Numeric 5   Drug Pack Size
27 XDWSPRC Numeric 9 4 Wholesale Price
28 XDOTCPRC Numeric 6 2 Nhs Gst / Otc Set Price
29 XDPRIVPRC Numeric 6 2 Private Set Price
30 XDS3RPRC Numeric 6 2 Schedule 3r Set Price
31 XDDISCRATE Numeric 5 2  
32 XDPROFNO Numeric 4   Drug Prof Number
33 XDMONOGRPH Numeric 4    
34 XDAUSREGNO Character 5   Drug Australian Registration Number
35 XDPPGUIDE Character 6    
36 XDHBFNO Character 5   HBF Number
37 XDSCHEDULE Character 2   Drug Schedule
38 XDINTGRP Numeric 4   Interacting Group 1
39 XDINTGRP2 Numeric 4   Interacting Group 2
40 XDSTKGROUP Numeric 3   Stock Group
41 XDMANFCODE Character 2   Manufacturer Code
42 XDWARNLBLS Character 30   Warning Labels
43 XSDOCCODE Character 4   Doctor Fast Code
44 XSDPRESCNO Numeric 7   Doctor Prescriber Number
45 XSDOCNAME Character 20   Doctor Names
46 XSNHSCODE Character 5   NHS Code
47 XSQTY Numeric 4   NHS Quantity Dispensed
48 XSPACKS Numeric 7 2 Number Of Packs Dispensed
49 XSSIGS Character 10   Script Directions
50 XSPHMINIT Character 2    
51 XSORIGINIT Character 2    
52 XSMAXDISP Numeric 2    
53 XSDISPNO Numeric 2    
54 XSAUTHNO Numeric 8   Authority Number
55 XSAUTHORTY Logical 1   Authority Script
56 XSCLASS Character 1   Script Class
57 XSNARCOTIC Logical 1   Narcotic Drug
58 XSGSTINC Character 1   GST Included in Patient Price
59 XSWARDNO Character 4   Ward Number
60 XSHOSPNPAT Character 1   Hospital
61 XPNUMBER Numeric 7   Patient Number
62 XPURNUMBER Numeric 8   Ur Number
63 XPADMISSNO Numeric 8   Admission Number
64 XPSEX Character 1   Patient Gender
65 XPTITLE Character 6   Patient Title
66 XPSURNAME Character 18   Patient Surname
67 XPFIRSTNAM Character 18   Patient First Name
68 XPADDRESS Character 22   Patient Address
69 XPSUBURB Character 18   Patient Suburb
70 XPPOSTCODE Numeric 4   Patient Post Code
71 XPPHONE Character 12   Patient Phone Number
72 XPPOSACCT Numeric 6   Patient POS Account Number
73 XPDIRCHRGE Logical 1   Direct Charge Account Flag
74 XPDISCOUNT Numeric 5 2  
75 XPFAMCODE Numeric 4   Patient Family Code
76 XPPTYPE Character 1   Patient Type
77 XPCONCNO Character 11   Patient Concession Number
78 XPCONCVDTE Character 9   Patient Concession Expiry Date
79 XPREPATNO Character 10   Patient Repat Number
80 XPSAFENTNO Character 11   Patient Safetynet Number
81 XPMEDICARE Character 11   Patient Medicare Number
82 XPDOB Character 9   Patient Date Of Birth
83 XPALLERGY Character 25   Patient Allergies
84 XPNURSCODE Character 4   Nursing Home Code
85 XPWARDNO Character 4   Ward Number
86 XPMAILCAT Character 4   Mailing Category
87 XPHFUNDID Character 4   Patient Health Fund Code
88 XPHFUNDTBL Character 6   Patient Health Fund Table
89 XPHFUNDMNO Numeric 9   Patient Health Fund Member Number
90 XPINSVDATE Character 9    
91 XPOWERXS Character 1    
92 XPPATGRP Character 3   Patient Group
93 XPRPTSHERE Character 1   Repeats Held
94 XPREPATCOL Character 1   Owing
95 XPGENSONLY Character 1   Generics Only Flag
96 XPRECEIPT Character 1   Used As Acct. Category
97 XPPOPORINH Character 1    
98 XPRXCNT Numeric 3    
99 XPSAFEAMT Numeric 7 2 Patient Safetynet Amount
100 XPOUTRXCNT Numeric 3    
101 XPOUTSNAMT Numeric 7 2  
102 XAMTTPP Character 20   Drug AMT Code TPP (if available)
103 XAMTCTPP Character 20   Drug AMT Code CTPP (if available)
104 XPNOTES Character 10   Patient Notes
    CRLF 2   End of Record Delimiter CRLF

Fred4POS

Field Field Name Type Width Dec Addditional Information
1 XSTATUS Character 1   Transfer Status Type
2 XDEDUCTSTK Logical 1   Deduct Stock
3 XSTOCKLOCN Character 4   Stock Location
4 XSRXNO Numeric 8   Script Number
5 XTRANSDATE Character 9   Transaction Date
6 XSTYPE Character 1   Script Type
7 XSPATPRICE Numeric 7 2 Script Patient Price
8 XSSNAMT Numeric 5 2 Script Safetynet Amount
9 XSWSCOST Numeric 7 2 Wholesale Cost
10 XSGOVRECOV Numeric 7 2 Government Recovery Amount
11 XSDRUGDESC Character 40   Drug Description
12 XSALTDESC Character 30   Alternate Description
13 XSLDRUGORD Character 1    
14 XDDRUGCODE Character 6   Fred Drug Code
15 XDAPNCODE1 Character 13   Barcode 1
16 XDAPNCODE2 Character 13   Barcode 2
17 XDSCODE1 Character 3   Supplier Identifier Code 1
18 XDPDENO1 Character 6   Reorder Number 1
19 XDSCODE2 Character 3   Supplier Identifier Code 2
20 XDPDENO2 Character 6   Reorder Number 2
21 XDUSERCODE Character 6   User Drug Code
22 XDNAME Character 30   Drug Name
23 XDFORMABB Character 10   Drug Form
24 XDSTRENGTH Character 20   Drug Strength
25 XDGENNAME Character 30   Drug Generic Name
26 XDPACKSIZE Numeric 5   Drug Pack Size
27 XDWSPRC Numeric 9 4 Wholesale Price
28 XDOTCPRC Numeric 6 2 Nhs Gst / Otc Set Price
29 XDPRIVPRC Numeric 6 2 Private Set Price
30 XDS3RPRC Numeric 6 2 Schedule 3r Set Price
31 XDDISCRATE Numeric 5 2  
32 XDPROFNO Numeric 4   Drug Prof Number
33 XDMONOGRPH Numeric 4    
34 XDAUSREGNO Character 5   Drug Australian Registration Number
35 XDPPGUIDE Character 6    
36 XDHBFNO Character 5   HBF Number
37 XDSCHEDULE Character 2   Drug Schedule
38 XDINTGRP Numeric 4   Interacting Group 1
39 XDINTGRP2 Numeric 4   Interacting Group 2
40 XDSTKGROUP Numeric 3   Stock Group
41 XDMANFCODE Character 2   Manufacturer Code
42 XDWARNLBLS Character 30   Warning Labels
43 XSDOCCODE Character 4   Doctor Fast Code
44 XSDPRESCNO Numeric 7   Doctor Prescriber Number
45 XSDOCNAME Character 20   Doctor Names
46 XSNHSCODE Character 5   NHS Code
47 XSQTY Numeric 4   NHS Quantity Dispensed
48 XSPACKS Numeric 7 2 Number Of Packs Dispensed
49 XSSIGS Character 10   Script Directions
50 XSPHMINIT Character 2    
51 XSORIGINIT Character 2    
52 XSMAXDISP Numeric 2    
53 XSDISPNO Numeric 2    
54 XSAUTHNO Numeric 8   Authority Number
55 XSAUTHORTY Logical 1   Authority Script
56 XSCLASS Character 1   Script Class
57 XSNARCOTIC Logical 1   Narcotic Drug
58 XSGSTINC Character 1   GST Included In Patient Price
59 XSWARDNO Character 4   Ward Number
60 XSHOSPNPAT Character 1   Hospital
61 XPNUMBER Numeric 6   Patient Number
62 XPURNUMBER Numeric 8   Ur Number
63 XPADMISSNO Numeric 8   Admission Number
64 XPSEX Character 1   Patient Gender
65 XPTITLE Character 6   Patient Title
66 XPSURNAME Character 18   Patient Surname
67 XPFIRSTNAM Character 18   Patient First Name
68 XPADDRESS Character 22   Patient Address
69 XPSUBURB Character 18   Patient Suburb
70 XPPOSTCODE Numeric 4   Patient Post Code
71 XPPHONE Character 12   Patient Phone Number
72 XPPOSACCT Numeric 6   Patient POS Account Number
73 XPDIRCHRGE Logical 1   Direct Charge Account Flag
74 XPDISCOUNT Numeric 5 2  
75 XPFAMCODE Numeric 4   Patient Family Code
76 XPPTYPE Character 1   Patient Type
77 XPCONCNO Character 11   Patient Concession Number
78 XPCONCVDTE Character 9   Patient Concession Expiry Date
79 XPREPATNO Character 10   Patient Repat Number
80 XPSAFENTNO Character 11   Patient Safetynet Number
81 XPMEDICARE Character 11   Patient Medicare Number
82 XPDOB Character 9   Patient Date Of Birth
83 XPALLERGY Character 25   Patient Allergies
84 XPNURSCODE Character 4   Nursing Home Code
85 XPWARDNO Character 4   Ward Number
86 XPMAILCAT Character 4   Mailing Category
87 XPHFUNDID Character 4   Patient Health Fund Code
88 XPHFUNDTBL Character 6   Patient Health Fund Table
89 XPHFUNDMNO Numeric 9   Patient Health Fund Member Number
90 XPINSVDATE Character 9    
91 XPOWERXS Character 1    
92 XPPATGRP Character 3   Patient Group
93 XPRPTSHERE Character 1   Repeats Held
94 XPREPATCOL Character 1   Owing
95 XPGENSONLY Character 1   Generics Only Flag
96 XPRECEIPT Character 1   Used as Account Category
97 XPPOPORINH Character 1    
98 XPRXCNT Numeric 3    
99 XPSAFEAMT Numeric 7 2 Patient Safetynet Amount
100 XPOUTRXCNT Numeric 3    
101 XPOUTSNAMT Numeric 7 2  
102 XPNOTES Character 10   Patient Notes
    CRLF 2   End of Record Delimiter CRLF

Fred2POS

Field Field Name Type Width Dec Additional Information
1 XSTATUS Character 1   Transfer Status Type
2 XDEDUCTSTK Logical 1   Deduct Stock
3 XSTOCKLOCN Character 4   Stock Location
4 XSRXNO Character 6   Script Number
5 XDISPDATE Date 10   Script Date
6 XSTYPE Character 1   Script Type
7 XSPATPRICE Numeric 7 2 Script Patient Price
8 XSSNAMT Numeric 5 2 Script Safetynet Amount
9 XWSCOST Numeric 7 2 Wholesale Cost
10 XSGOVRECOV Numeric 7 2 Government Recovery Amount
11 XSDRUGDESC Character 40   Drug Description
12 XSALTDESC Character 30   Alternate Description
13 XSLDRUGORD Character 1    
14 XDDRUGCODE Character 6   Fred Drug Code
15 XDAPNCODE1 Character 13   Barcode 1
16 XDAPNCODE2 Character 13   Barcode 2
17 XDSCODE1 Character 3   Supplier Identifier Code 1
18 XDPDENO1 Character 6   Reorder Number 1
19 XDSCODE2 Character 3   Supplier Identifier Code 2
20 XDPDENO2 Character 6   Reorder Number 2
21 XDUSERCODE Character 6   User Drug Code
22 XDNAME Character 30   Drug Name
23 XDFORMABB Character 10   Drug Form
24 XDSTRENGTH Character 20   Drug Strength
25 XDGENNAME Character 30   Drug Generic Name
26 XDPACKSIZE Numeric 5   Drug Pack Size
27 XDWSPRC Numeric 9 4 Wholesale Price
28 XDOTCPRC Numeric 6 2 Nhs Gst / Otc Set Price
29 XDPRIVPRC Numeric 6 2 Private Set Price
30 XDS3RPRC Numeric 6 2 Schedule 3r Set Price
31 XDDISCRATE Numeric 5 2  
32 XDPROFNO Numeric 4   Drug Prof Number
33 XDMONOGRPH Numeric 4    
34 XDAUSREGNO Character 5   Drug Australian Registration Number
35 XDPPGUIDE Character 6    
36 XDHBFNO Character 5   HBF Number
37 XDSCHEDULE Character 2   Drug Schedule
38 XDINTGRP Numeric 4   Interacting Group 1
39 XDINTGRP2 Numeric 4   Interacting Group 2
40 XDSTKGROUP Numeric 3   Stock Group
41 XDMANFCODE Character 2   Manufacturer Code
42 XDWARNLBLS Character 30   Warning Labels
43 XSDOCCODE Character 4   Doctor Fast Code
44 XSDPRESCNO Numeric 7   Doctor Prescriber Number
45 XSDOCNAME Character 20   Doctor Names
46 XSNHSCODE Character 5   NHS Code
47 XSQTY Numeric 4   NHS Quantity Dispensed
48 XSPACKS Numeric 7 2 Number Of Packs Dispensed
49 XSSIGS Character 10   Script Directions
50 XSPHMINIT Character 2    
51 XSORIGINIT Character 2    
52 XSMAXDISP Numeric 2    
53 XSDISPNO Numeric 2    
54 XSAUTHNO Numeric 8   Authority Number
55 XSAUTHORITY Logical 1   Authority Script
56 XSCLASS Character 1   Script Class
57 XSNARCOTIC Logical 1   Narcotic Drug
58 XSGSTINC Character 1   GST Included in Patient Price
59 XSWARDNO Character 4   Ward Number
60 XSHOSPNPAT Character 1   Hospital
61 XPNUMBER Numeric 6   Patient Number
62 XPURNUMBER Numeric 8   Ur Number
63 XPADMISSNO Numeric 8   Admission Number
64 XPSEX Character 1   Patient Gender
65 XPTITLE Character 6   Patient Title
66 XPSURNAME Character 18   Patient Surname
67 XPFIRSTNAM Character 18   Patient First Name
68 XPADDRESS Character 22   Patient Address
69 XPSUBURB Character 18   Patient Suburb
70 XPPOSTCODE Numeric 4   Patient Post Code
71 XPPHONE Character 12   Patient Phone Number
72 XPPOSACCT Numeric 6   Patient POS Account Number
73 XPDIRCHRGE Logical 1   Direct Charge Account Flag
74 XPDISCOUNT Numeric 5 2  
75 XPFAMCODE Numeric 4   Patient Family Code
76 XPPTYPE Character 1   Patient Type
77 XPCONCNO Character 11   Patient Concession Number
78 XPCONCVDTE Date 10   Patient Concession Expiry Date
79 XPREPATNO Character 10   Patient Repat Number
80 XPSAFENTNO Character 11   Patient Safetynet Number
81 XPMEDICARE Character 11   Patient Medicare Number
82 XPDOB Date 10   Patient Date Of Birth
83 XPALLERGY Character 25   Patient Allergies
84 XPNURSCODE Character 4   Nursing Home Code
85 XPWARDNO Character 4   Ward Number
86 XPMAILCAT Character 4   Mailing Category
87 XPHFUNDID Character 4   Patient Health Fund Code
88 XPHFUNDTBL Character 4   Patient Health Fund Table
89 XPHFUNDMNO Numeric 9   Patient Health Fund Member Number
90 XPINSVDATE Date 10    
91 XPOWERXS Character 1    
92 XPPATGRP Character 3   Patient Group
93 XPRPTSHERE Character 1   Repeats Held
94 XPREPATCOL Character 1   Owing
95 XPGENSONLY Character 1   Generics Only Flag
96 XPRECEIPT Character 1   Used as Account Category
97 XPPOPORINH Character 1    
98 XPRXCNT Character 3    
99 XPSAFEAMT Numeric 7 2 Patient Safetynet Amount
100 XPOUTRXCNT Numeric 3    
101 XPOUTSNAMT Numeric 7 2  
102 XPNOTES Character 10   Patient Notes
    CRLF 2   End of Record Delimiter CRLF

Fred8POS

Field Sequence Field Name Type Size Dec Additional Information
1 XPROCESSED Logical      
2 XSTATUS Character 1   Transfer Status Type
3 XDEDUCTSTK Logical     Deduct Stock
4 XSTOCKLOCN Character 4   Stock Location
5 XTRANSDATE Character 9   Transaction Date
6 XSRXNO Numeric 8   Script Number
7 XSDISPDATE Character 9    
8 XSTYPE Character 1   Script Type
9 XSPATPRICE Numeric 7 2 Script Patient Price
10 XSSNAMT Numeric 5 2 Script Safetynet Amount
11 XSWSCOST Numeric 7 2 Wholesale Cost
12 XSGOVRECOV Numeric 7 2 Government Recovery Amount
13 XSDRUGDESC Character 40   Drug Description
14 XSALTDESC Character 30   Alternate Description
15 XSLDRUGORD Character 1    
16 XDDRUGCODE Character 6   Fred Drug Code
17 XDAPNCODE1 Character 13   Barcode 1
18 XDAPNCODE2 Character 13   Barcode 2
19 XDSCODE1 Character 3   Supplier Identifier Code 1
20 XDPDENO1 Character 20   Reorder Number 1
21 XDSCODE2 Character 3   Supplier Identifier Code 2
22 XDPDENO2 Character 20   Reorder Number 2
23 XDUSERCODE Character 6   User Drug Code
24 XDNAME Character 30   Drug Name
25 XDFORMABB Character 10   Drug Form
26 XDSTRENGTH Character 20   Drug Strength
27 XDGENNAME Character 30   Drug Generic Name
28 XDPACKSIZE Numeric 5   Drug Pack Size
29 XDWSPRC Numeric 9 4 Wholesale Price
30 XDOTCPRC Numeric 6 2 Nhs Gst / Otc Set Price
31 XDPRIVPRC Numeric 6 2 Private Set Price
32 XDS3RPRC Numeric 6 2 Schedule 3r Set Price
33 XDDISCRATE Numeric 5 2  
34 XDPROFNO Numeric 4   Drug Prof Number
35 XDMONOGRPH Numeric 4    
36 XDAUSREGNO Character 5   Drug Australian Registration Number
37 XDPPGUIDE Character 6    
38 XDHBFNO Character 5   HBF Number
39 XDSCHEDULE Character 2   Drug Schedule
40 XDINTGRP Numeric 4   Interacting Group 1
41 XDINTGRP2 Numeric 4   Interacting Group 2
42 XDSTKGROUP Numeric 3   Stock Group
43 XDMANFCODE Character 2   Manufacturer Code
44 XDWARNLBLS Character 30   Warning Labels
45 XSDOCCODE Character 4   Doctor Fast Code
46 XSDPRESCNO Numeric 7   Doctor Prescriber Number
47 XSDOCNAME Character 20   Doctor Names
48 XSNHSCODE Character 5   NHS Code
49 XSQTY Numeric 4   NHS Quantity Dispensed
50 XSPACKS Numeric 7 2 Number Of Packs Dispensed
51 XSSIGS Memo     Script Directions
52 XSPHMINIT Character 2    
53 XSORIGINIT Character 2    
54 XSMAXDISP Numeric 2    
55 XSDISPNO Numeric 2    
56 XSAUTHNO Numeric 8   Authority Number
57 XSAUTHORTY Logical     Authority Script
58 XSCLASS Character 1   Script Class
59 XSNARCOTIC Logical     Narcotic Drug
60 XSGSTINC Character 1   GST Included in Patient Price
61 XSWARDNO Character 4   Ward Number
62 XSHOSPNPAT Character 1   Hospital
63 XPNUMBER Numeric 7   Patient Number
64 XPURNUMBER Numeric 8   Ur Number
65 XPADMISSNO Numeric 8   Admission Number
66 XPSEX Character 1   Patient Gender
67 XPTITLE Character 6   Patient Title
68 XPSURNAME Character 18   Patient Surname
69 XPFIRSTNAM Character 18   Patient First Name
70 XPADDRESS Character 22   Patient Address
71 XPSUBURB Character 18   Patient Suburb
72 XPPOSTCODE Numeric 4   Patient Post Code
73 XPPHONE Character 12   Patient Phone Number
74 XPPOSACCT Numeric 6   Patient POS Account Number
75 XPDIRCHRGE Logical     Direct Charge Account Flag
76 XPDISCOUNT Numeric 5 2  
77 XPFAMCODE Numeric 4   Patient Family Code
78 XPPTYPE Character 1   Patient Type
79 XPCONCNO Character 11   Patient Concession Number
80 XPCONCVDTE Character 9   Patient Concession Expiry Date
81 XPREPATNO Character 10   Patient Repat Number
82 XPSAFENTNO Character 11   Patient Safetynet Number
83 XPMEDICARE Character 11   Patient Medicare Number
84 XPDOB Character 9   Patient Date Of Birth
85 XPALLERGY Character 25   Patient Allergies
86 XPNURSCODE Character 4   Nursing Home Code
87 XPWARDNO Character 4   Ward Number
88 XPMAILCAT Character 4   Mailing Category
89 XPHFUNDID Character 4   Patient Health Fund Code
90 XPHFUNDTBL Character 6   Patient Health Fund Table
91 XPHFUNDMNO Numeric 9   Patient Health Fund Member Number
92 XPINSVDATE Character 9    
93 XPOWERXS Character 1    
94 XPPATGRP Character 3   Patient Group
95 XPRPTSHERE Character 1   Repeats Held
96 XPREPATCOL Character 1   Owing
97 XPGENSONLY Character 1   Generics Only Flag
98 XPRECEIPT Character 1   Used as Account Category
99 XPPOPORINH Character 1    
100 XPRXCNT Numeric 3    
101 XPSAFEAMT Numeric 7 2 Patient Safetynet Amount
102 XPOUTRXCNT Numeric 3    
103 XPOUTSNAMT Numeric 7 2  
104 XAMTTPP Character 20   Drug AMT Code TPP (if available)
105 XAMTCTPP Character 20   Drug AMT Code CTPP (if available)
106 XPNOTES Memo     Patient Notes

Fred4POS

Field Sequence Field Name Type Size Dec Additional Information
1 XPROCESSED Logical      
2 XSTATUS Character 1   Transfer Status Type
3 XDEDUCTSTK Logical     Deduct Stock
4 XSTOCKLOCN Character 4   Stock Location
5 XTRANSDATE Character 9   Transaction Date
6 XSRXNO Numeric 8   Script Number
7 XSDISPDATE Character 9   Dispense Date
8 XSTYPE Character 1   Script Type
9 XSPATPRICE Numeric 7 2 Script Patient Price
10 XSSNAMT Numeric 5 2

Script Safetynet Amount
11 XSWSCOST Numeric 7 2 Wholesale Cost
12 XSGOVRECOV Numeric 7 2 Government Recovery Amount
13 XSDRUGDESC Character 40   Drug Description
14 XSALTDESC Character 30   Alternate Description
15 XSLDRUGORD Character 1    
16 XDDRUGCODE Character 6   Fred Drug Code
17 XDAPNCODE1 Character 13   Barcode 1
18 XDAPNCODE2 Character 13   Barcode 2
19 XDSCODE1 Character 3   Supplier Identifier Code 1
20 XDPDENO1 Character 6   Reorder Number 1
21 XDSCODE2 Character 3   Supplier Identifier Code 2
22 XDPDENO2 Character 6   Reorder Number 2
23 XDUSERCODE Character 6   User Drug Code
24 XDNAME Character 30   Drug Name
25 XDFORMABB Character 10   Drug Form
26 XDSTRENGTH Character 20   Drug Strength
27 XDGENNAME Character 30   Drug Generic Name
28 XDPACKSIZE Numeric 5   Drug Pack Size
29 XDWSPRC Numeric 9 4 Wholesale Price
30 XDOTCPRC Numeric 6 2 Nhs Gst / Otc Set Price
31 XDPRIVPRC Numeric 6 2 Private Set Price
32 XDS3RPRC Numeric 6 2 Schedule 3r Set Price
33 XDDISCRATE Numeric 5 2  
34 XDPROFNO Numeric 4   Drug Prof Number
35 XDMONOGRPH Numeric 4    
36 XDAUSREGNO Character 5   Drug Australian Registration Number
37 XDPPGUIDE Character 6    
38 XDHBFNO Character 5   HBF Number
39 XDSCHEDULE Character 2   Drug Schedule
40 XDINTGRP Numeric 4   Interacting Group 1
41 XDINTGRP2 Numeric 4   Interacting Group 2
42 XDSTKGROUP Numeric 3   Stock Group
43 XDMANFCODE Character 2   Manufacturer Code
44 XDWARNLBLS Character 30   Warning Labels
45 XSDOCCODE Character 4   Doctor Fast Code
46 XSDPRESCNO Numeric 7   Doctor Prescriber Number
47 XSDOCNAME Character 20   Doctor Names
48 XSNHSCODE Character 5   NHS Code
49 XSQTY Numeric 4   NHS Quantity Dispensed
50 XSPACKS Numeric 7 2 Number Of Packs Dispensed
51 XSSIGS Memo     Script Directions
52 XSPHMINIT Character 2    
53 XSORIGINIT Character 2    
54 XSMAXDISP Numeric 2    
55 XSDISPNO Numeric 2    
56 XSAUTHNO Numeric 8   Authority Number
57 XSAUTHORTY Logical     Authority Script
58 XSCLASS Character 1   Script Class
59 XSNARCOTIC Logical     Narcotic Drug
60 XSGSTINC Character 1   GST Included In Patient Price
61 XSWARDNO Character 4   Ward Number
62 XSHOSPNPAT Character 1   Hospital
63 XPNUMBER Numeric 6   Patient Number
64 XPURNUMBER Numeric 8   Ur Number
65 XPADMISSNO Numeric 8   Admission Number
66 XPSEX Character 1   Patient Gender
67 XPTITLE Character 6   Patient Title
68 XPSURNAME Character 18   Patient Surname
69 XPFIRSTNAM Character 18   Patient First Name
70 XPADDRESS Character 22   Patient Address
71 XPSUBURB Character 18   Patient Suburb
72 XPPOSTCODE Numeric 4   Patient Post Code
73 XPPHONE Character 12   Patient Phone Number
74 XPPOSACCT Numeric 6   Patient POS Account Number
75 XPDIRCHRGE Logical     Direct Charge Account Flag
76 XPDISCOUNT Numeric 5 2  
77 XPFAMCODE Numeric 4   Patient Family Code
78 XPPTYPE Character 1   Patient Type
79 XPCONCNO Character 11   Patient Concession Number
80 XPCONCVDTE Character 9   Patient Concession Expiry Date
81 XPREPATNO Character 10   Patient Repat Number
82 XPSAFENTNO Character 11   Patient Safetynet Number
83 XPMEDICARE Character 11   Patient Medicare Number
84 XPDOB Character 9   Patient Date Of Birth
85 XPALLERGY Character 25   Patient Allergies
86 XPNURSCODE Character 4   Nursing Home Code
87 XPWARDNO Character 4   Ward Number
88 XPMAILCAT Character 4   Mailing Category
89 XPHFUNDID Character 4   Patient Health Fund Code
90 XPHFUNDTBL Character 6   Patient Health Fund Table
91 XPHFUNDMNO Numeric 9   Patient Health Fund Member Number
92 XPINSVDATE Character 9    
93 XPOWERXS Character 1    
94 XPPATGRP Character 3   Patient Group
95 XPRPTSHERE Character 1   Repeats Held
96 XPREPATCOL Character 1   Owing
97 XPGENSONLY Character 1   Generics Only Flag
98 XPRECEIPT Character 1   Used as Account Category
99 XPPOPORINH Character 1    
100 XPRXCNT Numeric 3    
101 XPSAFEAMT Numeric 7 2 Patient Safetynet Amount
102 XPOUTRXCNT Numeric 3    
103 XPOUTSNAMT Numeric 7 2  
104 XPNOTES Memo     Patient Notes

Fred2POS

Field Sequence Field Name Type Size Dec Additional Information
1 XPROCESSED Logical      
2 XSTATUS Character 1   Transfer Status Type
3 XDEDUCTSTK Logical     Deduct Stock
4 XSTOCKLOCN Character 4   Stock Location
5 XTRANSDATE Date 8    
6 XSRXNO Numeric 8   Script Number
7 XSDISPDATE Date 8   Script Date
8 XSTYPE Character 1   Script Type
9 XSPATPRICE Numeric 7 2 Script Patient Price
10 XSSNAMT Numeric 5 2 Script Safetynet Amount
11 XWSCOST Numeric 7 2 Wholesale Cost
12 XSGOVRECOV Numeric 7 2 Government Recovery Amount
13 XSDRUGDESC Character 40   Drug Description
14 XSALTDESC Character 30   Alternate Description
15 XSLDRUGORD Character 1    
16 XDDRUGCODE Character 6   Fred Drug Code
17 XDAPNCODE1 Character 13   Barcode 1
18 XDAPNCODE2 Character 13   Barcode 2
19 XDSCODE1 Character 3   Supplier Identifier Code 1
20 XDPDENO1 Character 6   Reorder Number 1
21 XDSCODE2 Character 3   Supplier Identifier Code 2
22 XDPDENO2 Character 6   Reorder Number 2
23 XDUSERCODE Character 6   User Drug Code
24 XDNAME Character 30   Drug Name
25 XDFORMABB Character 10   Drug Form
26 XDSTRENGTH Character 20   Drug Strength
27 XDGENNAME Character 30   Drug Generic Name
28 XDPACKSIZE Numeric 5   Drug Pack Size
29 XDWSPRC Numeric 9 4 Wholesale Price
30 XDOTCPRC Numeric 6 2 Nhs Gst / Otc Set Price
31 XDPRIVPRC Numeric 6 2 Private Set Price
32 XDS3RPRC Numeric 6 2 Schedule 3r Set Price
33 XDDISCRATE Numeric 5 2  
34 XDPROFNO Numeric 4   Drug Prof Number
35 XDMONOGRPH Numeric 4    
36 XDAUSREGNO Character 5   Drug Australian Registration Number
37 XDPPGUIDE Character 6    
38 XDHBFNO Character 5   HBF Number
39 XDSCHEDULE Character 2   Drug Schedule
40 XDINTGRP Numeric 4   Interacting Group 1
41 XDINTGRP2 Numeric 4   Interacting Group 2
42 XDSTKGROUP Numeric 3   Stock Group
43 XDMANFCODE Character 2   Manufacturer Code
44 XDWARNLBLS Character 30   Warning Labels
45 XSDOCCODE Character 4   Doctor Fast Code
46 XSDPRESCNO Numeric 7   Doctor Prescriber Number
47 XSDOCNAME Character 20   Doctor Names
48 XSNHSCODE Character 5   NHS Code
49 XSQTY Numeric 4   NHS Quantity Dispensed
50 XSPACKS Numeric 7 2 Number Of Packs Dispensed
51 XSSIGS Memo     Script Directions
52 XSPHMINIT Character 2    
53 XSORIGINIT Character 2    
54 XSMAXDISP Numeric 2    
55 XSDISPNO Numeric 2    
56 XSAUTHNO Numeric 8   Authorty Number
57 XSAUTHORITY Logical     Authority
58 XSCLASS Character 1   Script Class
59 XSNARCOTIC Logical     Narcotic Drug
60 XSGSTINC Character 1   GST Included In Patient Price
61 XSWARDNO Character 4   Ward Number
62 XSHOSPNPAT Character 1   Hospital
63 XPNUMBER Numeric 6   Patient Number
64 XPURNUMBER Numeric 8   Ur Number
65 XPADMISSNO Numeric 8   Admission Number
66 XPSEX Character 1   Patient Gender
67 XPTITLE Character 6   Patient Title
68 XPSURNAME Character 18   Patient Surname
69 XPFIRSTNAM Character 18   Patient First Name
70 XPADDRESS Character 22   Patient Address
71 XPSUBURB Character 18   Patient Suburb
72 XPPOSTCODE Numeric 4   Patient Post Code
73 XPPHONE Character 12   Patient Phone Number
74 XPPOSACCT Numeric 6   Patient POS Account Number
75 XPDIRCHRGE Logical     Direct Charge Account Flag
76 XPDISCOUNT Numeric 5 2  
77 XPFAMCODE Numeric 4   Patient Family Code
78 XPPTYPE Character 1   Patient Type
79 XPCONCNO Character 11   Patient Concession Number
80 XPCONCVDTE Date 8   Patient Concession Expiry Date
81 XPREPATNO Character 10   Patient Repat Number
82 XPSAFENTNO Character 11   Patient Safetynet Number
83 XPMEDICARE Character 11   Patient Medicare Number
84 XPDOB Date 8   Patient Date Of Birth
85 XPALLERGY Character 25   Patient Allergies
86 XPNURSCODE Character 4   Nursing Home Code
87 XPWARDNO Character 4   Ward Number
88 XPMAILCAT Character 4   Mailing Category
89 XPHFUNDID Character 4   Patient Health Fund Code
90 XPHFUNDTBL Character 4   Patient Health Fund Table
91 XPHFUNDMNO Numeric 9   Patient Health Fund Member Number
92 XPINSVDATE Date 8    
93 XPOWERXS Character 1    
94 XPPATGRP Character 3   Patient Group
95 XPRPTSHERE Character 1   Repeats Held
96 XPREPATCOL Character 1   Owing
97 XPGENSONLY Character 1   Generics Only Flag
98 XPRECEIPT Character 1   Used as Account Category
99 XPPOPORINH Character 1    
100 XPRXCNT Character 3    
101 XPSAFEAMT Numeric 7 2 Patient Safetynet Amount
102 XPOUTRXCNT Numeric 3    
103 XPOUTSNAMT Numeric 7 2  
104 XPNOTES Memo     Patient Notes