Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Rx_Dispense_Transaction
Touchworks 25.2
[dbo].[Rx_Dispense_Transaction]
MS_Description
Transaction sent to Inventory Mgmt System when a Medication/Immunization is dispensed
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Surrogate auto-generated unique primary key value
ItemID
[dbo].[uniqueid]
9
NOT NULL
Item_Medication.ID or Item_Immunization.ID
OrigItemChildID
[dbo].[uniqueid]
9
NOT NULL
Medication.ID or Immunization.ID when entry was created
ItemType
char(2)
2
NOT NULL
Item Type - Medication, Med Admin, Immunization
CurrentID
[dbo].[uniqueid]
9
NOT NULL
Medication.ID or Immunization.ID
CreatedByID
[dbo].[uniqueid]
9
NOT NULL
Logged in User ID. Link to IDX_User.ID
CreatedDTTM
datetime
8
NULL allowed
Date/time record was created
ModifiedByID
[dbo].[uniqueid]
9
NOT NULL
Logged in User ID. Link to IDX_User.ID
ModifiedDTTM
datetime
8
NULL allowed
Date/time record last updated
GetInventoryResponse
varchar(max)
max
NULL allowed
Response from Inventory System (json)
PostInventoryRequest
varchar(max)
max
NULL allowed
Message sent to Inventory System when med was dispensed (json)
DispenseStatus
int
4
NULL allowed
Status of Rx Dispense transaction
InventorySystem
varchar(24)
24
NULL allowed
Rx Inventory system integration name
InventoryDispenseInfo
varchar(500)
500
NULL allowed
JSON document containing information required to post the dispense transaction to the Rx inventory system