Jump to content


Photo

Import fields


  • Please log in to reply
2 replies to this topic

#1 johnay

johnay

    Advanced Member

  • Members
  • PipPipPip
  • 92 posts

Posted 20 January 2006 - 11:26 AM

I've not been able to figure out exactly what these fields are for. Here are my best guesses:

INPART - "The invoice part letter code" - Is this A, B, C, etc for multi-part (>5 item) orders? If so, is it really needed?

INTERNETID - Help: "Order number assigned to the order by SiteLINK when the customer checks out of your web store." - Import Field Selection Dialog: "Customer's Internet ID for Sitelink" - Our site generates order #s in the form abcd1234. Is this the right field for that? The dialog's description for the field implies it's a customer ID, while the help file says it's an order ID.

PONUMBER - This could concievably hold our order #s since we don't take POs. Would this be the better place for them?

ADDRESS3 & SADDRESS3 - the help file says "UK Only." The dialog just says they're the 3rd lines of the bill-to and ship-to addresses. The order entry dialog doesn't seem to have a corresponding field. We do ship to the UK and elsewhere. Is this going to be a problem? ISSUE_NUM and FRDATE are also marked "UK Only" in help but don't show up at all in the dialog. Are the "UK Only" marking for the address lines in error, or should they not be showing up in the dialog?

CC_OTHER- Is this the extra three or four digit code on the back of the credit card?

ORDERMEMO1, 2, 3 - This seems redundant, or are ORDNOTE1 through 5 associated with the line items? The only thing that implies they are is that there are five of them.

CARDHOLDER - in help: "Account Holder's Name for eCheck Payment." in dialog: "Cardholder Name" - Is this used for the name of the cardholder on the front of the customer's credit card, or is this just an eCheck thing?

Now we get to some confusing omissions & errors.

ISSUE_NUM is listed twice in the help file.

Then the dialog lists two more fields for which I have no size or type info:

Credit Card Security Key - I thought that was covered by CC_OTHER.

PayPal ID - We don't use PayPal, so no problem here.

Thanks for any clarification you can give.
JA

#2 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 01 April 2006 - 07:39 PM

** The information below is from an out of date Axton file. Use for testing and guideline purposes only. Based on MOM 4.3



IMPORT TABLE
The IMPORT table is a temporary table, not a permanent one, and therefore
does not have relations to the
other MOM tables. This table is imported into MOM, or exported from MOM,
during the use of the
Import-Export Module. When information in this table is imported, it�s just
as though the order were
entered manually; MOM sorts the description out among the many tables
governing orders. We have
included the field descriptions in this manual so that you can get a better
understanding of what information
should be included, and why.

Field Name T W Name
1 CUSTNUM N 10
The billing customer number. In most cases, this is left blank for
importing. It should only be filled in when the order entry system is
working off the same MOM table as your MOM system, and can
access the correct MOM-assigned customer number.
2 ALTNUM C 15
The customer number that has been assigned by the other system or
web package used in order entry. Note that this is a CUSTOMER
number, not an order number--that's taken care of by Field 32 below.
3 LASTNAME C 20 Billing address last name.
4 FIRSTNAME C 15 Billing address first name.
5 COMPANY C 40 Billing address company name.
6 ADDRESS1 C 40 Billing address first address line.
7 ADDRESS2 C 40 Billing address second address line.
8 CITY C 20 Billing city.
9 STATE C 3 Billing state or province.
10 ZIPCODE C 10 Billing zip code or postal code.
11 FOREIGN C 1 X or Y if billing address is outside of your country. Blank
or N indicates
a domestic address.
12 PHONE C 14
If this is a US address, the format is (xxx) xxx-xxxx. Note the space,
hyphen, and parenthesis for a total of 14 characters. If this is a foreign
address, the special formatting requirement is dropped, but there is
still a 14-character limit.
13 COMMENT C 40 This information writes to the COMMENT field in the CUST
table, and
shows on the customer's general tab of the main information screen.
14 CTYPE1 C 1
This corresponds to the first customer type, a single character, located
on the "General" tab in the customer's main information screen in
MOM.
15 CTYPE2 C 2
This corresponds to the second customer type, two characters,
located on the "General" tab in the customer's main information
screen in MOM.


16 CTYPE3 C 4
This corresponds to the third customer type, four characters, located
on the "General" tab in the customer's main information screen in
MOM.
17 TAXEXEMPT C 1
If this customer has tax exempt status, indicate with an X or Y so that
MOM does not calculate tax on the order if the address is in a state
where your company has a presence. Leave blank or type N to
indicate if this customer does not have tax exempt status.
18 PROSPECT C 1
If this entry is not an order, but rather a catalog request, indicate with
an X or Y. In that case, there is no need to complete any of the
subsequent fields besides field 22, the source of the catalog request,
or field 55, PROMOCRED, to place a promotional credit in the
prospect's record. Leave blank or type N to indicate if this entry is an
order.
19 CARDTYPE C 2 Credit Card type. This entry will be checked against the
valid list of
credit card types setup in Merchant Accounts.
20 CARDNUM C 19 Credit Card Number. Spaces are permitted. Dashes are not
permitted.
21 EXPIRES C 5 Credit Card Expiration date. The format should be MM/YY, even
for
Year 2000.
22 SOURCE_KEY C 9 The source key for this order or catalog request. Will be
matched
against source codes set up in MOM.
23 CATALOG C 2 The catalog code for this order, to be sent if this is to be
a catalog
request rather than an order. Matched against MOM catalog codes.
24 SALES_ID C 3
The sales ID for the order setup in Maintain User ID. Very often if this
is a web order or an inbound telemarketing order, MOM users set up a
single identifier code (like "WEB") in the Maintain User Security
Profiles section of MOM, and then default all imported orders to that
Sales ID. Make sure when you set this up that "Salesperson" is
checked to true.
25 OPER_ID C 3 The Operator ID for this order setup in Maintain User ID.
Same
information immediately above.
26 REFERENCE C 10 A Purchase Order number or check number for this order.
27 SHIPVIA C 3
Designated shipping method for order set up in Maintain Shipping
Methods. Default method that is set up in Import-Export setup is used
if this field is left blank.
28 FULFILLED C 1
If this order has been filled outside of MOM and therefore does not
need to deduct inventory from the shelves, indicate with an X or Y. In
this case, no processing paperwork will be generated, although it still
must be processed through Order Processing in order for MOM to
view the sale as complete. Leave blank or type N to indicate that this
order still needs to be filled in normal MOM processing.


59

29 PAID N 9
Designates that this dollar amount has already been paid. Indicating
an amount causes Mail Order Manager to generate an accounting
entry showing pre-payment of this amount.
30 CONTINUED C 1
If this record is a continuation of the prior record, indicate with an X or
Y. What is this field used for? You'll notice below that there is space
for only up to 5 products per import record. What happens when there
are more than 5 products in an order? The information for these
subsequent products must be contained in records immediately below
the first record. The first record for the order has nothing in this
Continued field (i.e., it should be left blank), and any subsequent
records for the order have an X or Y in this field. Upon import, MOM
will then flow the records together. For Continued records, there is no
need to repeat any of the address or payment information (and in fact
you MUST not repeat the AMOUNT field or the SHIPPING field), only
the product and pricing information that is specific to the product. In
fact, it's often easier, programming-wise, to simply ignore
PRODUCT02, PRODUCT03, PRODUCT04, and PRODUCT05-
instead, have as many IMPORT records as you have line items.
Complete PRODUCT01/QUANTITY01 for each record, and all line
items subsequent to the first one.
31 ORDER_DATE C 8 The entry date of the order. The format is MM/DD/YY.
32 ODR_NUM N 8
For importing, it is the order number assigned by the order taking
company. This number is imported into the ALT ORDER # field in the
M.O.M. database and can be used for order lookup, although it cannot
be seen from within the order proper.
33 PRODUCT01 C 20 The 1st product code on the order. Please see discussion
in Field 30
above for more information.
34 QUANTITY01 N 8 The quantity of this product being ordered.
35 PRODUCT02 C 20 The 2nd product code on the order.
36 QUANTITY02 N 8 The quantity of this product being ordered.
37 PRODUCT03 C 20 The 3rd product code on the order.
38 QUANTITY03 N 8 The quantity of this product being ordered.
39 PRODUCT04 C 20 The 4th product code on the order.
40 QUANTITY04 N 8 The quantity of this product being ordered.
41 PRODUCT05 C 20 The 5th product code on the order.
42 QUANTITY05 N 8 The quantity of this product being ordered.
43 SLASTNAME C 20 Shipping address Last Name. If the bill-to is the same as
the ship-to,
leave these shipping address fields blank.
44 SFIRSTNAME C 15 Shipping address First Name.


45 SCOMPANY C 40 Shipping address Company Name.
46 SADDRESS1 C 40 Shipping address first address line.
47 SADDRESS2 C 40 Shipping address second address line.
48 SCITY C 20 Shipping address city.
49 SSTATE C 3 Shipping address state or province.
50 SZIPCODE C 10 Shipping address zip or postal code.
51 HOLDDATE D 8 The date until which MOM will hold the order before
processing. This
is optional, of course, and is a processing hold, not a shipping hold.
52 PAYMETHOD C 2
Payment method for the order. CC=Credit Card; CK=Check; IN=Open
Invoice; CO=COD. If this field is blank and there is credit card number
for this record, MOM will assume it's a credit card payment; otherwise,
it will look to the default payment method established in the Define
Settings for Import-Export Module.
53 GREETING1 C 35 1st Box label greeting (Optional).
54 GREETING2 C 35 2nd Box label greeting (Optional).
55 PROMOCRED N 8 Dollar value of promotional credit.
56 USEPRICES C 1
If this is marked X or Y, then MOM will use the next 10 fields to assign
prices and discounts to the items being imported. If it is blank or N,
then MOM will assign the prices to the line items as they are entered
into MOM. Most MOM users importing from the web or an inbound
telemarketing company mark this X or Y because it ensures that the
price that the customer saw or was quoted is ultimately the price he or
she pays. If there is a discrepancy between MOM and this amount,
you don't want to risk dissatisfied customers.
57 PRICE01 N 9 The price to assign to the 1st product code.
58 DISCOUNT01 N 2 Corresponding discount expressed as a percentage (0-99).
59 PRICE02 N 9 The price to assign to the 2nd product code.
60 DISCOUNT02 N 2 Corresponding discount expressed as a percentage (0-99).
61 PRICE03 N 9 The price to assign to the 3rd product code.
62 DISCOUNT03 N 2 Corresponding discount expressed as a percentage (0-99).
63 PRICE04 N 9 The price to assign to the 4th product code.
64 DISCOUNT04 N 2 Corresponding discount expressed as a percentage (0-99).
65 PRICE05 N 9 The price to assign to the 5th product code.


61

66 DISCOUNT05 N 2 Corresponding discount expressed as a percentage (0-99).
67 USESHIPAMT C 1
If this is marked X or Y, then MOM will use the next field, SHIPPING,
to assign the shipping charges to the order. If it is blank or N, then
MOM will calculate the shipping charge if you have the Automatic
Shipping Calculations Module.
68 SHIPPING N 8 The shipping charges to assign to the order if the
USESHIPAMT field
is marked X or Y.
69 EMAIL C 50 Customer's e-mail address.
70 INTERNETID C 32 Order number assigned to the order by SiteLINK when the
customer
"checks out" of your web store. SiteLINK only.
71 COUNTRY C 3
Country code for the billing address on an order. Country codes
correspond to M.O.M. country codes (001,002, etc.) If empty, the field
defaults to the code for the country you selected for your business
address in Maintain Global Parameters.
72 SCOUNTRY C 3
Country code for the shipping address on an order. Country codes
correspond to M.O.M. country codes listed in this manual. If empty,
the field defaults to the code for the country you selected for your
business address in Maintain Global Parameters.
73 PHONE2 C 14 The billing customer's alternate phone or fax number.
74 SPHONE C 14 The shipping customer's phone number, if there is a separate
shipping
address.
75 SPHONE2 C 14 The shipping customer's alternate phone or fax number.
76 SEMAIL C 50 The shipping customer's e-mail address.
77 ORDERTYPE C 6 The order type of the order (usually WEB in this case)
78 INPART C 1 The invoice part (populated in Export, not in Import)
79 GREETING3 C 35 Third line of greeting/gift message
80 GREETING4 C 35 Fourth line of greeting/gift message
81 GREETING5 C 35 Fifth line of greeting/gift message
82 GREETING6 C 35 Sixth line of greeting/gift message
83 TITLE C 40 Title of bill-to customer
84 SALU C 6 Salutation of bill-to customer
85 HONO C 6 Honorific (suffix) of bill-to customer
86 EXT C 5 Phone 1 extension of bill-to customer


87 EXT2 C 5 Phone 2 extension of bill-to customer
88 STITLE C 40 Title of ship-to customer
89 SSALU C 6 Salutation of ship-to customer
90 SHONO C 6 Honorific of ship-to customer
91 SEXT C 5 Phone 1 extension of ship-to customer
92 SEXT2 C 5 Phone 2 extension of ship-to customer
93 SHIP_WHEN D 8 Date to ship item
94 PASSWORD C 20 SiteLINK password assigned to customer
95 CUSTOM01 C 240 Custom 1 field
96 CUSTOM02 C 240 Custom 2 field
97 CUSTOM03 C 240 Custom 3 field
98 CUSTOM04 C 240 Custom 4 field
99 CUSTOM05 C 240 Custom 5 field
100 INTERNET L 1
101 RCODE C 3 MOM 4.3 and higher only. Return code from MOM export.
102 APPROVAL C 10 MOM 4.3 and higher only. Approval code from authorization.
103 AVS C 2 MOM 4.3 and higher only. Address verification system code.
104 ANTRANS_ID C 30 MOM 4.3 and higher only
105 AUTH_AMT N 11 MOM 4.3 and higher only. Authorized amount.
106 AUTH_TIME T 8 MOM 4.3 and higher only. Authorization time.
David Narciso
Ecommerce Operations Manager CVS Inc

[email protected]

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.

#3 CDI Fulfillment

CDI Fulfillment

    Advanced Member

  • Members
  • PipPipPip
  • 43 posts

Posted 03 April 2006 - 09:33 AM

Here's what I know concerning those fields:

INPART - used during export, not import. MOM generates this when you ship an order. Different invoice parts are created if you ship the order in parts.

INTERNETID - only use if you have SiteLink. The correct field for placing the order number generated by your website is ODR_NUM. If your site also assigns customer numbers, those should be in the ALTNUM field.

PONUMBER - use this field if you are allowing customers to pay using a Purchase Order

ADDRESS3 - not positive, but I think that the "UK Only" designation refers to the UK version of MOM.

CC_OTHER - CID from back of customer CC. 3 digits for Visa/MC/Discover, 4 digits for AMEX.

ORDERMEMO - I think this populates some internal only notes that do not print on packing slips. ORDERNOTE 1 through 5 print on the packing slip.

CARDHOLDER - I think you can also use this for the name on the front of a CC, not required becuase MOM pulls that info from the bill-to information.

ISSUE_NUM - again, UK version only

Credit Card Security Key - I also thought that was covered by CC_OTHER. I don't see this field listed in the help file

PaypalID - as you said, use with PAYPAL.
Jay Snelgrove
Fulfillment Manager
CDI Media, Inc.

http://www.cdimedia.com




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users