sc.arnwl - It tells next order will be on auto renewal or not
sc.renew - it is "do not renew" flag for the product
o.arenew :
o.arnwl : It tells if order is created via auto renewal
Here is a write up from DSI developers.
Automatic Renewals
Setting the Auto Renew Flag - SC.ARNWL
The Auto Renew flag is stored as a logical field on the SC table - the field is sc.arnwl.
Order Entry - it is set on the TRXD table and updates the SC table when posting occurs
If it set when the transaction is saved - ECOMMOFF.P and also in posting.
Can be checked and unchecked in data entry
Order Renew flags
ord.arnwl - set if the order was created as an auto renewal
ord.arenew - set to “Y” if this ord is an auto renewal. This field has a limited use for reports - it is primarly used for products where there are overlapping issue dates and drives the renewal process.
Transaction Renew Flags
Trxd.arnwl - this field is set when an order is entered to auto renew. It is used to set the SC.ARNWL flag when batches are posted.
Opting Out of Auto Renewals
When a customer is opted out of auto renewals the following flags need to be set.
sc.arnwl - the product auto renew flag.
trxd.arnwl - the flag on any batches since this overwrites the SC tables.
Auto Renewal Policy
If an order is set to auto renew (ord.arnwl = yes) then when that order cancels it should be a status 18 (ord.stat 2. = 18A).
If an order is not set to auto renew (ord.arnwl = no) then when that order cancels it will be a status 15 (o3. rd.stat = 15A).
The INQUIRY screen in Multipub has the field Auto Rnwl. This field represents the subscription control record (sc.arnwl). If this field is set to yes, this indicates that the order will automatically renew, it does NOT indicate that the current order is or is not an auto renewal.
There are four different combinations of ord.arnwl and sc.arnwl.
ORD.ARNWL SC.ARNWL
- YES YES
- YES NO
- NO YES
- NO NO
Combinations of ord.arnwl and sc.arnwl:
If both are yes then the order is an auto renewal order and when it expires it will renew again.
If the order is auto renewal and the subscription control is not, then the order has auto renewed but when it expires it will not auto renew.
If the order is not auto renew and the subscription control is auto renewal then it is probably a new order and will auto renew when it expires.
If neither the order nor the subscription control is set to auto renewal than the order is not an auto renewal order and when it expires it will not auto renew.
Thanks,
Lacy Vigil