tables_fields:main_tables:transaction

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
tables_fields:main_tables:transaction [2020/01/07 01:04] – ↷ Page moved from tables:main_tables:transaction to tables_fields:main_tables:transaction loutables_fields:main_tables:transaction [2026/01/21 10:05] (current) – Raksha Khadka
Line 1: Line 1:
 ====== Transactions ====== ====== Transactions ======
 +[[tables_fields:main_tables:|Back to list of main tables]]
  
-[[tables:main_tables:|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 [[other_stuff:transaction_status_codes|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 [[other_stuff:transaction_status_codes|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      |      |+
  
 +^ Field name ^ Description       ^ mSupply Use     ^ Reference link   ^ Type    ^ Indexed ^
 +| **name_ID** | UUID of the name (customer/supplier) associated with the transaction (if any)| Usally not ID are not used in UI but used to display Customer/supplier/prescription invoice>>name | https://docs.msupply.org.nz/issuing_goods:issuing_goods_customer_invoice#name | Alpha | * |
 +| **ID** | UUID of the transaction (not usually visible to the user | Not use in UI | | Alpha | * |
 +| **invoice_num** | Invoice number given by mSupply | Customer/Supplier/Prescription invoice>>Invoice | | Long Integer | * |
 +| amount_outstanding | The amount remaining to be paid by the supplier or customer (zero if payments module is not activated).| Prescription>>Amount Outstanding | | Real | |
 +| arrival_date_estimated | Estimated date goods will reach facility to supply/customer -only applies to type “CI” | Customer invoice>>Transport details tab>>Expected arrival date | | Date | |
 +| arrival_date_actual | Actual date goods reached facility to supply/customer -only applies to type “CI” | Customer invoice>>Transport details tab>>Actual arrival date | | Date | |
 +| budget_period_ID | The ID of the budget period the transaction is assigned to (may be different to logical period from transact.date | | | Alpha | |
 +| category_ID | The ID of the category of the transaction | Supplier/Customer/Build/Repack/Prescription invoice>>Category | https://docs.msupply.org.nz/issuing_goods:issuing_goods_customer_invoice#category | Alpha | * |
 +| comment | The comment text entered by the user | | | Text | |
 +| Colour | The colour assigned to the transaction (longint version of hex RGB) | | | Long Integer | |
 +| 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 | Not used in UI but used to display Customer invoice>>Transport details tab>>Shipped to | | Alpha | * |
 +| currency_ID | The ID of the currency of the transaction | | | Alpha | |
 +| currency_rate | The currency rate of the transaction | If the store pref is on to issue in foreign currency Customer invoice>>Currency rate | | Real | |
 +| linked_transaction_id | The ID of the associated customer invoice if there is one (for stock transfers)| | | Alpha| |
 +| date_order_received | Date the requistion/order was received from customer/facility to supply -only applies to type “CI” | Customer invoice>>Transport details tab>>Order received date | | Date | |
 +| date_order_written | Date the requistion/order was created by the customer/facility to supply -only applies to type “CI” | Customer invoice>>Transport details tab>>Order written date | | Date | |
 +| donor_default_ID | The ID of the donor to assign to transaction_lines as they are created | | | Alpha | |
 +| encounter_id | The id of the HIS encounter. Related: HIS.encounter_id | | | Alpha | |
 +| entry_date | The date the transaction was created | Customer/Supplier/Prescription invoice>>Entry date | | Date | |
 +| export_batch | The batch number supplied by mSupply when the invoice was finalised. | | | Long Integer | |
 +| 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 | | | Alpha | * |
 +| hold | If true, the transaction status can not be changed, stopping putting goods in or out of stock, or finalising an invoice | Supplier/Customer Invoice>>Hold | https://docs.msupply.org.nz/issuing_goods:issuing_goods_customer_invoice#hold |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 | Need to set in store preference Supplier/Customer Invoice>>Authorised | | Boolean | |
 +| is_cancellation | True if the transaction is a cancellation of an existing transaction (i.e. a contra) | | | Boolean | |
 +| 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 | * |
 +| mode | 0 for store, 1 for dispensary | | | Alpha | |
 +| mwks_sequence_num | The id of the corresponding transaction in Moneyworks | | | Long Integer | |
 +| number_of_cartons | Number of cartons the order was shipped in | | | Long Integer | |
 +| original_PO_ID | The ID of the Purchase Order that generated this transaction | | | Alpha | * |
 +| requisition_ID | ID requisition that this transaction was created from (Only applies to customer invoices. New field from version 3.6)| | | Alpha | |
 +| responsible_officer_ID | ID of the user responsible for shipping goods | Not used in UI but used to display Customer invoice>>Transport details tab>>Responsible officer | | Alpha | |
 +| pickslip_printed_date | Date of first pickslip printing (not updated with subsequent printing)| | | Date | |
 +| prescriber_ID | ID of the prescriber (for prescriptions) | | | Alpha | * |
 +| ship_date | Date the order was shipped (for type “CI”) | Customer invoice>>Transport details tab>>Ship date | https://docs.msupply.org.nz/issuing_goods:issuing_goods_customer_invoice#order_tracking_data | Date | |
 +| ship_method_comment | | | | Alpha | |
 +| ship_method_ID | ID of Shipping method | Not used in UI but used to display Customer invoice>>Transport details tab>>Ship method | https://docs.msupply.org.nz/issuing_goods:issuing_goods_customer_invoice#shipping_method | Alpha | |
 +|**status** | A 2 letter code denoting the status of the transaction. See [[other_stuff:transaction_status_codes|Transaction Codes]] | Customer/supplier invoice>>Status | https://docs.msupply.org.nz/receiving_goods:supplier_invoices#buttons_in_the_supplier_invoice_window | Alpha | |
 +| subtotal | The subtotal of transaction lines plus extra charges excluding tax | Customer/supplier/prescription invoice>>Subtotal | https://docs.msupply.org.nz/receiving_goods:supplier_invoices#general_tab | Real | |
 +| tax | Tax (value) on the subtotal | Customer/supplier/prescription invoice>>% Tax | https://docs.msupply.org.nz/receiving_goods:supplier_invoices#general_tab | Real | |
 +|**type** | The transaction type. See Transaction Types here | | | Alpha | |
 +|**total** | The subtotal plus the tax amount (see below) | Customer/supplier/prescription invoice>>Subtotal | https://docs.msupply.org.nz/receiving_goods:supplier_invoices#general_tab | Real | |
 +| their_ref | The reference supplied by the other party for the transaction | Customer/supplier/prescription invoice>>Their ref | | Alpha | |
 +| service_descrip | Description of any service items on the invoice | Customer/supplier/prescription invoice>>Item | https://docs.msupply.org.nz/receiving_goods:supplier_invoices#general_tab | Alpha | |
 +| service_price | The amount of any extra charges added to the invoice (or discount) | Customer/supplier/prescription invoice>>Amount | https://docs.msupply.org.nz/receiving_goods:supplier_invoices#general_tab | Real | |
 +| user_ID | The user id number of the user who created the invoice | | | Alpha | |
 +| user1 | Custom user-defined field | | | Alpha | |
 +| user2 | Custom user-defined field | | | Alpha | |
 +| user3 | Custom user-defined field | | | Alpha | |
 +| user4 | Custom user-defined field | | | Alpha | |
 +| waybill_number | | | | Alpha | |
 +| entry_time | The time of invoice entry | | | Time | |
 +| authorisationStatus | Detailed authorisation state | | | Alpha | |
 +| nameInsuranceJoinID | Links patient and insurance record. | | | Alpha | |
 +| insuranceDiscountAmount | Calculated insurance discount value | Prescription>>N% Discount(N=insurance discount rate) | |Real | |
 +| optionID | | | | Alpha | * |
 +| insuranceDiscountRate | Insurance discount percentage | | | Real | |
 +| internalData | | | | Object | |
 +| lastModifiedAt | | | | Long Integer | |
 +| custom_data | | | | Object | |
 +| goodsReceivedConfirmation | | | | Object | |
 +| paymentTypeID | | | | Alpha | |
 +| diagnosis_ID | Diagnosis associated with the prescription. | | | Alpha | * |
 +| wardID | | | | Alpha | |
 +| category2_ID | | | | Alpha | |
 +| om_created_datetime | | | | Alpha | |
 +| om_allocated_datetime | | | | Alpha | |
 +| om_picked_datetime | | | | Alpha | |
 +| om_shipped_datetime | | | | Alpha | |
 +| om_delivered_datetime | | | | Alpha | |
 +| om_verified_datetime | | | | Alpha | |
 +| om_status | | | | Alpha | |
 +| om_colour | | | | Alpha | |
 +| om_type | | | | Alpha | |
 +| om_transport_reference | | | | Alpha | |
 +| finalised_date | | | | Date | |
 +| programID | ID of program that link to the invoice | | | Alpha | * |
 +| tax_rate | | | | Real | |
 +| gender | Patient gender | | | Text | |
 +| om_original_shipment_id | | | | Alpha | |
 +| finalised_time | The time of finalise invoice | | | Time | |
 +| om_expected_delivery_datetime | | | | Alpha | |
 +| oms_fields | | | | Object | |
 +| om_gender | | | | Alpha | |
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2020/01/07 01:04
  • by lou