New to this forum, and new to using the Business Object Interface.  

Scenerio:

I'm on Sage 100 2022 Standard, and am about to implement Sage Alerts & Workflow.  One of the tasks I will be creating will periodically look at all open Sales Orders and automatically create Production Management Work Tickets for any S/O line items whose BOMs can be produced with available raw materials and no conflicts with other S/Os competing for the same available raw materials, will automatically create P/Os when underlying BOM raw materials are unavailable, and will automatically create Drop Ship P/Os when the item itself is a drop ship (along with attendant notifications to internal teams).  This is oversimplifying the business logic, but it's enough to establish a baseline for my question.

Obviously there are situations (customers on credit hold should not have automation enabled unless specifically overridden) and specific individual customers where auto-generation would not be ideal.  The ability to override this functionality on an individual Sales Order level is necessary, and the ability to set the default for new sales orders on a customer level would be ideal to avoid manual override and the potential for entry error. 

I have two UDF fields in AR_CUSTOMER.M4T (which can be edited in a customized panel) that are to be used to establish default values for subsequent Sales Orders:
UDF_WOAUTOMATION - Production Automation (3 Validation Choices: UNLESS ON CREDIT HOLD (default), EVEN WHEN ON CREDIT HOLD, NEVER)
UDF_POAUTOMATION - Drop Ship P/O Automation (3 Validation Choices: UNLESS ON CREDIT HOLD (default), EVEN WHEN ON CREDIT HOLD, NEVER)

The same fields exist in SO_SALESORDERHEADER.M4T (also able to be edited in a customized panel).

All I'm trying to do is query the AR_CUSTOMER.M4T table every time a new Sales Order is created (either through the interface or automatically generated by Return of Merchandise or automation I'll be creating related to Repeating Orders in Alerts & Workflow), and set the equivalent fields on the Sales Order to the defaults set on the Customer.  I understand how to frame the script on the S/O from a metadata perspective, but I cannot for the life of me figure out how to query columns in the AR_CUSTOMER.M4T table from the Sales Order Business Object, since it's not a child object of the Sales Order.  My hopes were that I could set the UDF in the Sales Order table to reference the AR_CUSTOMER.M4T table as its default, but that table is not available in the list, so I'm guessing the only way to achieve this is via script. 

I cannot for the life of me figure out how to achieve this.  Some posts on this forum indicate an ODBC query is necessary in the script, but I can't find any documentation on how to do this properly.  Any help would be appreciated!