How are OM Payment Terms associated to AR Terms?

Summary:

We implemented an algorithm to map Payment Term from Order Management header to AR Interface Line. The algorithm retrieves payment term from Order Header and then set it on the Interface Line for the Credit line.

Service Mapping > Algorithm

resultPaymentTermId = GetMscValueForAR(OrderHeader.PaymentTermId.toString(),"PAYMENT_TERMS","TERM_ID","300000000352368");

Iface.PaymentTermsId = resultPaymentTermId;

This works most of the time, but not all the time because the Payment Term ID are not the same between OM and AR.

Here is an example,
On Sales order header the payment term is "Net 15" and DOO_ORDER_HEADERS_V shows PAYMENT_TERM_ID as 5006.

In AR term_id for "Net 15" is 300000006703479. Due to this the service mapping does not work as expected.