Transactions

Back to list of main tables

Table name is transact. Transactions are customer invoices, supplier invoices, inventory adjustments, customer credits, supplier credits, repacks etc.

Field name	Description	Type	Ind
name_ID	UUID of the name (customer/supplier) associated with the transaction (if any)	UUID	*
ID	UUID of the transaction (not usually visible to the user	UUID	*
invoice_num	Invoice number given by mSupply	Long	*
amount_outstanding	The amount remaining to be paid by the supplier or customer (zero if payments module is not activated).	Real
arrival_date_estimated	Estimated date goods will reach facility to supply/customer -only applies to type “CI”	Date
arrival_date_actual	Actual date goods reached facility to supply/customer -only applies to type “CI”	Date
budget_period_ID	The ID of the budget period the transaction is assigned to (may be different to logical period from transact.date	Long
category_ID	The ID of the category of the transaction	Long	*
comment	The comment text entered by the user	Text
colour	The colour assigned to the transaction (longint version of hex RGB)	Long
confirm_date	The date the invoice was confirmed	Date	*
confirm_time	The time the invoice was confirmed	Time	*
contact_ID	The ID of the contact associated with this transaction	UUID	*
currency_ID	The ID of the currency of the transaction	String 20
currency_rate	The currency rate of the transaction	Real
cust_transaction_ID	The ID of the associated customer invoice if there is one (for stock transfers)	Long
date_order_received	Date the requistion/order was received from customer/facility to supply -only applies to type “CI”	Date
date_order_written	Date the requistion/order was created by the customer/facility to supply -only applies to type “CI”	Date
donor_default_ID	The ID of the donor to assign to transaction_lines as they are created	UUID
encounter_id	The id of the HIS encounter. Related: HIS.encounter_id	UUID
entry_date	The date the transaction was created	Date
export_batch	The batch number supplied by mSupply when the invoice was finalised.	Long
foreign_currency_total	Total in currency of the supplier/customer	real
goods_received_ID	The ID of the goods receipt that generated this transactions- applies to type “SI” only	UUID	*
hold	If true, the transaction status can not be changed, stopping putting goods in or out of stock, or finalising an invoice	Boolean
invoice_printed_date	Date the invoice was first printed (invoices are printed once status is “CN” - only for type “CI”)	Date
is_authorised	True if transaction has been authorised	Booelan
is_cancellation	True if the transaction is a cancellation of an existing transaction (i.e. a contra)	Long
local_charge_distributed	Any charges locally applied to a receipt transaction (used to calculate costs-included selling price)	Real
linked_goods_received_ID	The ID of the goods received note created from a customer invoice in an internal requisition	Alpha 255	*
mode_ID	0 for store, 1 for dispensary	Long
mwks_sequence_num	The id of the corresponding transaction in Moneyworks	Long
number_of_cartons	Number of cartons the order was shipped in	Long
original_PO_id	The ID of the Purchase Order that generated this transaction	Long	*
requisition_ID	ID requisition that this transaction was created from (Only applies to customer invoices. New field from version 3.6)	UUID
responsible_officer_ID	ID of the user responsible for shipping goods	UUID
pickslip_printed_date	Date of first pickslip printing (not updated with subsequent printing)	Date
prescriber_ID	ID of the prescriber (for prescriptions)	UUID	*
ship_date	Date the order was shipped (for type “CI”)	Date
ship_method_comment	Alpha 80
ship_method_ID	UUID
status	A 2 letter code denoting the status of the transaction. See Transaction Codes	Alpha 3
subtotal	The subtotal of transaction lines plus extra charges excluding tax	Real
tax	Tax (value) on the subtotal	Real
type	The transaction type. See Transaction Types here	Alpha 3
total	The subtotal plus the tax amount (see below)	Real
their_ref	The reference supplied by the other party for the transaction	Alpha 80
service_descrip	Description of any service items on the invoice	Alpha 60
service_price	The amount of any extra charges added to the invoice (or discount)	Real
subtotal	Total of all price extensions plus the service price	Real
tax	The tax amount of the invoice	Real
user_ID	The user id number of the user who created the invoice	UUID
user1	Alpha 50
user2	Alpha 50
user3	Alpha 50
user4	Alpha 50
waybill_number	Alpha 50