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 |
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 |