Does this file CUST.dbf specifies ship-to and bill-to records, if not then how can I pull customers data out of MOM 5.4 with ship-to and bill-to addresses?
Thank you for the information it is very helpful, I just have another question do you know what P stands for in CUSTTYPE row?
The CUST file is a list of all customers and all addresses. The CUSTTYPE field will tell you if it is a bill-to or ship-to customer. O = Address ONLY B = Bill-To Address S = Ship-To Address U = Multiple-use Address
If you need ship-to and bill-to addresses for a specific order, you need to look at the CMS file for the CUSTNUM field for the bill-to customer and the SHIPNUM field for the ship-to customer.