Approval Rule [sn_shop_approval_rule] table

  • Release version: Australia
  • Updated July 13, 2026
  • 1 minute to read

    • The Approval Rule [sn_shop_approval_rule] table stores the rules that determine how and when approval requests are sent for purchasing objects.

    This table contains the following fields.

    Table 1. Approval Rule table
    Field Data type Description
    Number String System-generated number used to identify this approval rule.
    Name String Name of this approval rule.
    Active Boolean When selected, this rule requests approvals.
    Approval rule type Choice Determines how approvals are requested. The options are Cost Center Managers, Dynamic Users or Groups, Managerial Job Code Hierarchy, Managerial Hierarchy, or Specified Users or Groups.
    Base approvals on Field name Person on whom the approval rule is based.
    Purchasing user (deprecated) Field name User from whom approvals are triggered. This field is deprecated.
    Send approval request to Choice People who receive an approval request. The options are Direct Manager, Most Senior Manager, All Managers in Hierarchy, All Users up to the User with Authorized Code, or Most Junior User with an Authorized Code.
    Up to job level Reference Highest job level to which an approval request is sent.
    Authorized job codes List Job codes of those who can approve this object.
    Approval limit Currency Maximum amount that can be approved by the authorized job codes.
    Approval sequence Choice Determines whether approval requests are sent all at once or one at a time. The options are Send Approvals in Parallel or Send Approvals Sequentially.
    Approval required from Choice Determines whether all approvers or just one approver must approve. The options are All Approvers Must Approve or Any Approver Can Approve.
    Users List People who can approve this object.
    Groups List Groups that can approve this object.
    Send approval to purchasing user's (deprecated) Field name Approval is sent dynamically to a user or group related to the purchasing user. This field is deprecated.
    Approval trigger conditions Conditions Conditions that the object details must meet for an approval request to be sent.
    Approving object Table name Type of item that needs approval.
    Approving line Table name Line items of the approving object that define the triggers for an approval request.
    Allow automatic approval Boolean When selected, the requester receives automatic approval if the role has the required authority.