Schema

Column Name	Data Type	Description
is_deleted	boolean	Whether this record should be considered deleted. Data deleted at source has non-key columns set to null while primary keys are retained.
organisation	varchar	An organisation is synonymous with a pharmacy and is also known as the RXid.
order_history_item_id	integer	Unique identifier for the order history item.
order_history_id	integer	Unique identifier for the order history.
order_pad_id	integer	Unique identifier for the order pad.
order_history_item_description	varchar	Item description.
pack_code_id	integer	Local identifier of ProScript Connect packs.
order_quantity	integer	Ordered quantity.
received_quantity	integer	Received quantity.
book_in_quantity	integer	Booked in quantity.
cost	numeric	Cost of an item.
pip_code	varchar	PIP code is a unique identifier allocated to a specific product.
order_code	varchar	Order code of an item.
order_status_reason	varchar	Reason an order failed to transmit.
order_item_status_reason	varchar	Reason an order item failed to transmit.
date_actioned	date	Date when the order history item was actioned from Goods In.
order_history_item_guid	varchar	Globally unique identifier for the order history item.
supplied_by	varchar	Details of the wholesaler the item was sent to, including fulfilment by another supplier.
retail_price	numeric	Retail price.
vat_rate	numeric	VAT rate.
pharmacy_id	integer	Foreign key to the pharmacy table.
wholesaler_id	integer	Foreign key to the wholesaler table.
order_reference	varchar	Order reference generated using OrderHistoryId and WholesalerCode.
order_history_status_id	integer	Order history status identifier. Foreign key to order history status.
order_history_added_date_time	timestamp	Date and time when the order history was added.
order_history_modified_date_time	timestamp	Date and time when the order history was last modified.
pharmacy_name	varchar	The name of the pharmacy.
wholesaler_code	varchar	Wholesaler code used to identify the order pad.
supplier_codes	varchar	Secondary supplier codes used to search an item within products data.
wholesaler_account_number	varchar	Wholesaler account number.
wholesaler_name	varchar	Wholesaler name.
wholesaler_type_id	integer	Foreign key to wholesaler type.
product_pack_size	numeric	Pack size from PKB.
product_name	varchar	PKB product name.
manufacturer_name	varchar	PKB manufacturer name.
product_pack_type	integer	DM+D product pack type (0 = VMPP, 1 = AMPP).
product_pack_code_id	integer	DM+D pack identifier (VMPP/AMPP). Relates to virtual and actual product pack entities.
virtual_product_pack_id	integer	Generic pack information corresponding to a virtual product pack.
row_id	varchar	Unique hash generated based on column values, used to identify data changes.
last_updated_date	date	Date that this record was last updated by the orchestration process.
branch_identifier	varchar	Branch identifier assigned by head office for data exchange workflows.
national_practice_code	varchar	Pharmacy NacsCode used to identify the pharmacy when the user logs in.
order_status	varchar	Order status verbose value (for example Sending, Failed, Sent, Completed).
order_item_status_id	integer	Order history item status identifier. Foreign key to order item status.
order_item_status	varchar	Order item status verbose value (for example None, Accepted, Rejected).