5 replies to this topic

[Michael_R]

Hi All

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

[dseibold]

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.

[Michael_R]

Hi dseibold,

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.

[dseibold]

Hmmm... hadn't noticed that one. Which led me to discover I had mislabeled the O code.

REVISED INFO

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 = Orders on File
B = Bill-To Address
P = Prospect
S = Ship-To Address
U = Multiple-use Address


Any other strange codes you find, just note the custnum and bring up the customer record in MOM.
The Status field will tell you what it means.

[ypf1258]

please Note

the above info is for the "" addr_type """ field

[dseibold]

please Note

the above info is for the "" addr_type """ field

Obviously, my head must be half asleep! Thanks for pointing out my confusion...

REVISED INFO - REVISED AGAIN

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

The CUST.CUSTTYPE field will tell you the status of the customer.
O = Orders on File
P = Prospect (No orders on file)

Any other strange codes you find in the CUSTTYPE field, just note the custnum and bring up the customer record in MOM.
The Status field will tell you what it means.