[[admin:tables_fields:authorisation]]

Field number Field Name Description Type Length Index
6ID The ID of the record UUID Y
4priorityIf this type of authorisation requires authorisation in a particular order, this value is > 0 and denotes this authoriser's place in the order Long Integer
2recordTypeTEXT values: customerInvoice, supplierInvoice, requestRequistion, responseRequisition, purchaseOrder. In v4.0, only implemented: customerInvoice and requestRequistion Text
5reportType Text
1storeIDThe store where this authoriser can authorise this type of transaction Alpha
3userIDThe user who this record applies to- Authorisers are users with the “Can authorise” type set Alpha
Field number Field Name Description Type Length Index
3authoriserID The ID of the authoriser (foreign key of Authoriser.ID) UUID
7comment Text
8ID The ID of this record Alpha Y
2recordIDThe ID of the record to be authorised (could be from transact, Purchase_order or requisition tables UUID
9recordTypeTEXT values: customerInvoice, supplierInvoice, requestRequistion, responseRequisition, purchaseOrder. In v4.0, only implemented: customerInvoice and requestRequistion Text
4status none (i.e. email not sent), pending: email sent to authoriser, authorised, denied Text
5statusDate Date
6statusTime Time
1storeID The store where this record to be authorised exists Alpha
10userID The Alpha
  • Last modified: 2018/05/11 00:39
  • by Craig Drown