authoriser

Back to the list of other tables

Field number	Field Name	Description	Type	Length	Index
6	ID	The ID of the record	UUID	Y
4	priority	If 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
2	recordType	TEXT values: customerInvoice, supplierInvoice, requestRequistion, responseRequisition, purchaseOrder. In v4.0, only implemented: customerInvoice and requestRequistion	Text
5	reportType	Text
1	storeID	The store where this authoriser can authorise this type of transaction	Alpha
3	userID	The user who this record applies to- Authorisers are users with the “Can authorise” type set	Alpha

authorisationQueue

Field number	Field Name	Description	Type	Length	Index
3	authoriserID	The ID of the authoriser (foreign key of Authoriser.ID)	UUID
7	comment	Text
8	ID	The ID of this record	Alpha	Y
2	recordID	The ID of the record to be authorised (could be from transact, Purchase_order or requisition tables	UUID
9	recordType	TEXT values: customerInvoice, supplierInvoice, requestRequistion, responseRequisition, purchaseOrder. In v4.0, only implemented: customerInvoice and requestRequistion	Text
4	status	none (i.e. email not sent), pending: email sent to authoriser, authorised, denied	Text
5	statusDate	Date
6	statusTime	Time
1	storeID	The store where this record to be authorised exists	Alpha
10	userID	The	Alpha