Increment sequence of BN rule via direct sql

Summary:

Hello,

We need to know if it is possible to increment the sequence of a GID in a standard way from a Direct SQL action according to the definition of the sequence in Business Number. Specifically this BN rule:

We are automating the creation of capacity usage per agent and we need to insert records through an action like this via DSU incrementing the CAPACITY_USAGE_GID according the BN rule defined above :

We have achieve this using sql functions but we need to know if there are some standard method.

Note: The nextval is not working in this case because the system always retrieves one NNNN code (ie: '1000' value) and we have another type of code based on 2 type of codes: yyyymmdd and nnnn (yyyymmdd-nnnn).