Transaction lines
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 | * |