5 replies to this topic

[bbdesign]

I'm setting up IEM imports for the first time and am stuck on just a few fields...

CARDTYPE = I assume this is Visa, MasterCard, etc. Where can I find the list of valid codes? Field length is only two, so I assume its an abbreviated code (VI, MC, something like that)

COUNTRY = MOM appears to be using a 3-digit country code. Where can I find the code list? Could not find it in the MOM manual or on this website

INTERNET = In my Excel file, some of the cell data is corrupted... I cannot read the description of this field, but it sounds like it might be important. Says its a LOGICAL type field, but I'm not sure what this field means.

CC_OTHER = Not sure what this is, description says "credit card ID"

Considering there are 130 fields, only needing help with 4 isn't too bad, I guess! I would appreciate any assistance with finishing this up. Thanks!

-Brad

[dseibold]

I'll reply to one of the questions:

For country codes, go to the country.dbf in mom for a complete list.

[ypf1258]

I'm setting up IEM imports for the first time and am stuck on just a few fields...

CARDTYPE = I assume this is Visa, MasterCard, etc. Where can I find the list of valid codes? Field length is only two, so I assume its an abbreviated code (VI, MC, something like that)

COUNTRY = MOM appears to be using a 3-digit country code. Where can I find the code list? Could not find it in the MOM manual or on this website

INTERNET = In my Excel file, some of the cell data is corrupted... I cannot read the description of this field, but it sounds like it might be important. Says its a LOGICAL type field, but I'm not sure what this field means.

CC_OTHER = Not sure what this is, description says "credit card ID"

Considering there are 130 fields, only needing help with 4 isn't too bad, I guess! I would appreciate any assistance with finishing this up. Thanks!

-Brad

i have recently looked thru our folder named Mom problems (believe me its 2 full hanging folders) and i have seen some print outs that we got from dayacomp when we set up mom with our website
i have from
cust.dbf
cms.dbf
stock.dbf (of the file that holds the stock file
journal.dbf
and some more that i do not remember offhand
it will walk you thru all the field with an exact explanation what each is
if you want it pm me with your fax # and ill send it to you


Joe

[bbdesign]

Thanks for the offer, but I have 99% of the information I need, just stuck on a few fields.

[notehead]

The easiest is to use dbuwin to look at the tables but.....CARDTYPE is the code of the card you set up in Maintain >Accounting>Creditcard Merchant Accounts. If you want to look at the table it's in cc.dbf

Country's already been answered but if you want to find them in MOM they are in Maintain >Accounting>Sales Tax Tables.

Internet is a flag set to -1 if yes 0 if no. It is used in credit card processing to tell your processor if it's an internet order, if they require it.

cc_other I think is for CVV2/CVC2 if you use it.

j

[ypf1258]

The easiest is to use dbuwin to look at the tables but.....CARDTYPE  is the code of the card you set up in Maintain >Accounting>Creditcard Merchant Accounts. If you want to look at the table it's in cc.dbf

Country's already been answered but if you want to find them in MOM they are in Maintain >Accounting>Sales Tax Tables.

Internet is a flag set to -1 if yes 0 if no. It is used in credit card processing to tell your processor if it's an internet order, if they require it.

cc_other I think is for CVV2/CVC2 if you use it.

j

On the print out that we have it says "reserved for future use" don't forget this was for mom 4.3