| 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. |
| stock_item_id | integer | Unique identifier for the stock item. |
| stock_item_guid | varchar | Globally unique identifier for the stock item. |
| stock_item_added_date_time | timestamp | The date and time the stock item was added. |
| stock_item_modified_date_time | timestamp | The date and time the stock item was modified. |
| stock_level | integer | Current quantity of the stock item. |
| minimum_stock | integer | Minimum quantity of the stock item to be kept in inventory. |
| maximum_stock | integer | Maximum quantity of the stock item to be kept in inventory. |
| pack_code_id | integer | Local identifier of ProScript Connect packs. |
| 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. |
| pharmacy_id | integer | Foreign key to the pharmacy table. |
| pharmacy_name | varchar | The name of the pharmacy. |
| pack_price | numeric | Regional preparation pack price. |
| pip_code | varchar | PIP code is a unique identifier allocated to a specific product. |
| is_generic_pack | boolean | Identifies whether a pack is generic or branded. |
| is_generic_preparation | boolean | Identifies whether a preparation is generic or branded. |
| is_parallel_import | boolean | Indicates whether the pack is a parallel import. |
| is_discount_not_deducted | boolean | Discount-not-deducted (zero discount) status of the preparation/pack. |
| drug_tariff_category | varchar | Drug tariff category used for pricing and reimbursement. |
| preparation_type_identifier | integer | Pharmaceutical type identifier of the preparation. |
| is_acbs | boolean | Whether the regional preparation has ACBS approval. |
| contraceptive_identifier | integer | Contraceptive status identifier for a regional pack. |
| dispensable_type_identifier | integer | Suitability classification for dispensed product choice lists. |
| is_special | boolean | Whether or not the stock item is special. |
| dispensed_date_time | timestamp | The date and time when the item was dispensed. |
| dispensed_quantity | numeric | Dispensed quantity of the latest qualifying dispense event. |
| dispensed_cost | numeric | Cost value of the latest qualifying dispense event. |
| dispensed_price | numeric | Price value of the latest qualifying dispense event. |
| 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. |
| 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. |