Transaction lines

Back to list of main tables

Table name is trans_line. Contains the lines that belong to transactions.

Field name Description Type Indexed
batch The batch ID of the item received or issued Alpha 20
box_number The box ID or ID's that the item has been packed to for distribution purposes Alpha 80
cost_price The cost of the item in local currency during purchase Real
donor_id This is used if stock receipt and distribution is to be tracked by donors. Long
expiry_date The expiry date of this line on the invoice Date
foreign_currency_price While purchasing, this field is used to log cost of items in suppliers foreign currency. Real
goods_received_lines_ID This field is filled if the stock came via mSupply's ordering system Long *
ID Internal tracking number used by mSupply Long *
is_from_inventory_adjustment True if the item was added or removed via the stock take module Boolean *
item_ID Key of the item to which it belongs Long *
item_line_ID The key of the item line (stock line) that the transaction line belongs to Long *
item_name The item name (stored to give data integrity for historical transactions even if the related item name is later changed) Alpha 80
line_number The sequential line number on the invoice Long
linked_transact_id Stores the id of a transaction being paid Alpha 255
local_charge_line_total Field to account for local freight or custom cost when receiving stock. Real
location_ID Used to assign stock to location or for stock picking purposes. Long *
manufacturer_ID Used to specify the manufacturer of the batch. Long
note Note or directions if a dispensary line Text
order_lines_ID Stores the Order line ID if the stock was received via mSupply's ordering system. Long *
pack_inners_in_outer Long
pack_size The number of items in a carton. Real
pack_size_inner Long
price_extension Total cost price or sell price for the line. Real
quantity Quantity issued (in number of packs) Real
repeat_ID In dispensary mode, patients may be called to repeat prescriptions. Real *
sell_price The sell price for a single packsize. Real
source_backorder_id Used if customer backorders are being full-filled. Long
supp_trans_line_ID_ns Used if customer Non stock items orders are being issued. Long
transaction_ID Key of the transaction to which it belongs Long *
user_1 Custom field Alpha 20
user_2 Custom field Alpha 20
user_3 Custom field Alpha 20
user_4 Custom field Alpha 40
volume_per_pack Volume for a single packsize in m3 Real
weight The total weight for this line (NOT for each item) Real
type The type of the transaction line
“stock_out” for all CIs, SCs, the issue line on a repack which is the first line of a repack
“stock_in” for all CCs, SIs, the received line(s) on a repack which are all other lines of a repack
“placeholder” for all placeholder lines which, in previous versions of mSupply, were all lines of table [trans_line] that had a Neg ID's in field [trans_line]item_line_ID.
“cash_in” for cash receipts
“cash_out” for cash payments
“non_stock” for non-stock transactions on customer invoices
“service” for service items
Text
user_5_ID The ID of the custom field 5 record selected for this transaction line. Text *
user_6_ID The ID of the custom field 6 record selected for this transaction line. Text *
user_7_ID The ID of the custom field 7 record selected for this transaction line. Text *
user_8_ID The ID of the custom field 8 record selected for this transaction line. Text *