Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Customer Type in the AR_Customer Table

Posted By Thulasi Kumar 5 months ago

Hi Team

I would like to know about the description for the values in the column (CustomerType) in the AR_Customer table

Top Replies

connex 5 months ago +1

There are no descriptions. They are self defined. You could add a UDT with a list of CustomerType values with descriptions. To keep the values consistent, you could use a Column Pre-Validate script on…

0 Kevin M 5 months ago

From the help files:

https://help-sage100.na.sage.com/2023/index.htm#Subsystems/AR/ARMainFields/Customer_Maintenance_-_Fields.htm#CUST_MAINT_ADDL_CUST_TYPE
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 connex 5 months ago

There are no descriptions. They are self defined. You could add a UDT with a list of CustomerType values with descriptions. To keep the values consistent, you could use a Column Pre-Validate script on the CustomerType field to validate entries against the UDT.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Customer Type in the AR_Customer Table

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING