|
POSITION
|
FIELDNAME
|
TYPE
|
WIDTH
|
DEC
|
DESCRIPTION
|
|
1
|
CUSTNUM
|
Numeric
|
10
|
N/A
|
The billing customer number. This
should only be used when a direct match between the external source
customer number and the M.O.M. customer number is possible. In all
other cases, use ALTNUM (below) and leave this field blank.
|
|
2
|
ALTNUM
|
Character
|
15
|
N/A
|
The
customer
number assigned by the external source.
|
|
3
|
LASTNAME
|
Character
|
20
|
N/A
|
Last name (Billing address)
|
|
4
|
FIRSTNAME
|
Character
|
15
|
N/A
|
First name.
|
|
5
|
COMPANY
|
Character
|
40
|
N/A
|
Company name.
|
|
6
|
ADDRESS1
|
Character
|
40
|
N/A
|
First address line.
|
|
7
|
ADDRESS2
|
Character
|
40
|
N/A
|
Second address line.
|
|
8
|
CITY
|
Character
|
30
|
N/A
|
City.
|
|
9
|
STATE
|
Character
|
3
|
N/A
|
State/Province.
|
|
10
|
ZIPCODE
|
Character
|
10
|
N/A
|
ZIP Code/Postal Code.
|
|
11
|
CFOREIGN
|
Character
|
1
|
N/A
|
Indicate with an 'X' or 'Y' if this
address is outside of your country. Leave blank or type 'N' to
indicate domestic address.
|
|
12
|
PHONE
|
Character
|
18
|
N/A
|
Format (xxx) xxx-xxxx
|
|
13
|
COMMENT
|
Character
|
40
|
N/A
|
A comment line that is recorded with
the customer information. This comment only shows on the screen,
and can not be seen by the customer on any order paperwork.
|
|
14
|
CTYPE1
|
Character
|
1
|
N/A
|
First customer type field. These 3
fields are used to assign codes to the name that can be used to
control product pricing and list selection.
|
|
15
|
CTYPE2
|
Character
|
2
|
N/A
|
Second customer type field.
|
|
16
|
CTYPE3
|
Character
|
4
|
N/A
|
Third customer type field.
|
|
17
|
TAXEXEMPT
|
Character
|
1
|
N/A
|
Indicate with an 'X' or 'Y' if this
customer has a tax exempt status. Leave blank or type 'N' to
indicate if this customer does not have tax exempt status.
|
|
18
|
PROSPECT
|
Character
|
1
|
N/A
|
Indicate with an 'X' or 'Y' if this
entry is not an order,, but just a catalog request or other request
for information. Leave blank or type 'N' to indicate if this entry
is an order.
|
|
19
|
CARDTYPE
|
Character
|
2
|
N/A
|
Credit Card type. This entry will be
checked against the valid list of credit card types set up in
Merchant Accounts.
|
|
20
|
CARDNUM
|
Character
|
19
|
N/A
|
Credit Card Number. Spaces are
permitted. Dashes are not permitted.
|
|
21
|
EXPIRES
|
Character
|
5
|
N/A
|
Credit card Expiration date. The
format should be MM/YY.
|
|
22
|
SOURCE_KEY
|
Character
|
9
|
N/A
|
The source key for this
order/customer set up in Maintain Source Codes.
|
|
23
|
CCATALOG
|
Character
|
6
|
N/A
|
The catalog code for this order set
up in Maintain Catalog Codes.
|
|
24
|
SALES_ID
|
Character
|
3
|
N/A
|
The sales id for the order set up in
Maintain User ID.
|
|
25
|
OPER_ID
|
Character
|
3
|
N/A
|
The Operator ID for this order set up
in Maintain User ID.
|
|
26
|
REFERENCE
|
Character
|
20
|
N/A
|
A credit card approval number or
check number for this order.
|
|
27
|
SHIPVIA
|
Character
|
3
|
N/A
|
Designated shipping method for order
set up in Maintain Shipping Methods,, Default method is used if
left blank.
|
|
28
|
FULFILLED
|
Character
|
1
|
N/A
|
Indicate with an 'X' or 'Y' if this
order has been filled outside of Mail Order Manager. If marked, the
order is marked as shipped. Leave blank or type 'N' to indicate
that this order has not been filled outside of M.O.M.
|
|
29
|
PAID
|
Numeric
|
9
|
2
|
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
|
Character
|
1
|
N/A
|
Indicate with an 'X' or 'Y' if this
record is a continuation of the prior record. This is used when
more than 5 products are required for a given order, or in cases
where multiple shipping methods or shipping addresses are used.
When this is marked,, it is not necessary to repeat any customer
information on the next record. For cases with multiple shipping
methods or multiple shipping addresses,, each new continued entry
needs to have its own shipping address and or shipping method. Only
the additional product entries are recorded. Leave blank or type
'N' to indicate that this record is not a continuation.
|
|
31
|
ORDER_DATE
|
Date
|
8
|
N/A
|
The entry date of the order.
DBF
format: date must be MM/DD/YY.
SDF
format: date must be YYYYMMDD
CSV format:
date
must be either YYYYMMDD or MM/DD/YYYY
|
|
32
|
ODR_NUM
|
Numeric
|
8
|
N/A
|
For exporting,, this is the order
number assigned by Mail Order Manager. 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 throughout the M.O.M. system.
|
|
33
|
PRODUCT01
|
Character
|
20
|
N/A
|
The 1st product code on the
order.
|
|
34
|
QUANTITY01
|
Numeric
|
8
|
2
|
The quantity of this product being
ordered.
|
|
35
|
PRODUCT02
|
Character
|
20
|
N/A
|
The 2nd product code on the
order.
|
|
36
|
QUANTITY02
|
Numeric
|
8
|
2
|
The quantity of this product being
ordered.
|
|
37
|
PRODUCT03
|
Character
|
20
|
N/A
|
The 3rd product code on the
order.
|
|
38
|
QUANTITY03
|
Numeric
|
8
|
2
|
The quantity of this product being
ordered.
|
|
39
|
PRODUCT04
|
Character
|
20
|
N/A
|
The 4th product code on the
order.
|
|
40
|
QUANTITY04
|
Numeric
|
8
|
2
|
The quantity of this product being
ordered.
|
|
41
|
PRODUCT05
|
Character
|
20
|
N/A
|
The 5th product code on the
order.
|
|
42
|
QUANTITY05
|
Numeric
|
8
|
2
|
The quantity of this product being
ordered.
|
|
43
|
SLASTNAME
|
Character
|
20
|
N/A
|
Last name (Optional Shipping
address).
|
|
44
|
SFIRSTNAME
|
Character
|
15
|
N/A
|
First name (Optional Shipping
address).
|
|
45
|
SCOMPANY
|
Character
|
40
|
N/A
|
Company name (Optional Shipping
address).
|
|
46
|
SADDRESS1
|
Character
|
40
|
N/A
|
First address line (Optional Shipping
address).
|
|
47
|
SADDRESS2
|
Character
|
40
|
N/A
|
Second address line (Optional
Shipping address).
|
|
48
|
SCITY
|
Character
|
20
|
N/A
|
City (Optional Shipping address).
|
|
49
|
SSTATE
|
Character
|
3
|
N/A
|
State/Province (Optional Shipping
address).
|
|
50
|
SZIPCODE
|
Character
|
10
|
N/A
|
ZIP Code/Postal Code (Optional
Shipping address).
|
|
51
|
HOLDDATE
|
Date
|
8
|
N/A
|
Establishes a date to hold order
before processing (Optional).
|
|
52
|
PAYMETHOD
|
Character
|
2
|
N/A
|
Method of Payment (Optional). This
may be one of six codes:
CC - Credit Card
CK - Check with order
PP - PayPal
GO - Google Checkout
IN - Open Invoice
CO - COD order.
If not entered, the system will
determine payment based on accompanying CARDNUM field or
default.
|
|
53
|
GREETING1
|
Character
|
35
|
N/A
|
1st line of Box label greeting
(Optional).
|
|
54
|
GREETING2
|
Character
|
35
|
N/A
|
2nd line of Box label greeting
(Optional).
|
|
55
|
PROMOCRED
|
Numeric
|
8
|
2
|
Promotional Credit towards order.
|
|
56
|
USEPRICES
|
Character
|
1
|
N/A
|
Indicate with an 'X' or 'Y' if you
wish to import price and discount information for this order. If
used,, the next 10 fields will be used to assign prices and
discounts to the line items. If left blank,, or an 'N' is entered,,
M.O.M. will automatically price the line items.
|
|
57
|
PRICE01
|
Numeric
|
12
|
4
|
The price to assign to the 1st
product code.
|
|
58
|
DISCOUNT01
|
Numeric
|
3
|
N/A
|
Corresponding discount expressed as a
percentage (0-99).
|
|
59
|
PRICE02
|
Numeric
|
12
|
4
|
The price to assign to the 2nd
product code.
|
|
60
|
DISCOUNT02
|
Numeric
|
3
|
N/A
|
Corresponding discount expressed as a
percentage (0-99).
|
|
61
|
PRICE03
|
Numeric
|
12
|
4
|
The price to assign to the 3rd
product code.
|
|
62
|
DISCOUNT03
|
Numeric
|
3
|
N/A
|
Corresponding discount expressed as a
percentage (0-99).
|
|
63
|
PRICE04
|
Numeric
|
12
|
4
|
The price to assign to the 4th
product code.
|
|
64
|
DISCOUNT04
|
Numeric
|
3
|
N/A
|
Corresponding discount expressed as a
percentage (0-99).
|
|
65
|
PRICE05
|
Numeric
|
12
|
4
|
The price to assign to the 5th
product code.
|
|
66
|
DISCOUNT05
|
Numeric
|
3
|
N/A
|
Corresponding discount expressed as a
percentage (0-99).
|
|
67
|
USESHIPAMT
|
Character
|
1
|
N/A
|
Indicate with an 'X' or 'Y' if you
wish to have M.O.M. use the SHIPPING field to control the shipping
charges for the order. Leave this field blank, or 'N' to have
M.O.M. calculate the shipping charges.
|
|
68
|
SHIPPING
|
Numeric
|
8
|
2
|
The shipping charges to assign to the
order if the USESHIPAMT field is used.
|
|
69
|
EMAIL
|
Character
|
50
|
N/A
|
Customer's e-mail address. This is
automatically captured by SiteLINK.
|
|
70
|
COUNTRY
|
Character
|
3
|
N/A
|
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.
|
|
71
|
SCOUNTRY
|
Character
|
3
|
N/A
|
Country code for the shipping 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
|
PHONE2
|
Character
|
18
|
N/A
|
The fax number.
|
|
73
|
SPHONE
|
Character
|
18
|
N/A
|
The shipping phone number.
|
|
74
|
SPHONE2
|
Character
|
18
|
N/A
|
The shipping fax number.
|
|
75
|
SEMAIL
|
Character
|
50
|
N/A
|
The shipping e-mail address.
|
|
76
|
ORDERTYPE
|
Character
|
6
|
N/A
|
The order type code.
|
|
77
|
INPART
|
Character
|
1
|
N/A
|
The invoice part letter code.
|
|
78
|
TITLE
|
Character
|
40
|
N/A
|
The title of the bill-to name; e.g.,
president, manager.
|
|
79
|
SALU
|
Character
|
6
|
N/A
|
The salutation for the bill-to
name.
|
|
80
|
HONO
|
Character
|
6
|
N/A
|
The honorific for the bill-to
name
|
|
81
|
EXT
|
Character
|
5
|
N/A
|
Phone extension for the bill-to
name.
|
|
82
|
EXT2
|
Character
|
5
|
N/A
|
Alternate phone extension for the
bill-to name.
|
|
83
|
STITLE
|
Character
|
40
|
N/A
|
The title for the ship-to name.
|
|
84
|
SSALU
|
Character
|
6
|
N/A
|
The salutation for the ship-to
name.
|
|
85
|
SHONO
|
Character
|
6
|
N/A
|
The honorific for the ship-to
name.
|
|
86
|
SEXT
|
Character
|
5
|
N/A
|
Phone extension for the ship-to
name.
|
|
87
|
SEXT2
|
Character
|
5
|
N/A
|
Alternate phone extension for the
ship-to name.
|
|
88
|
SHIP_WHEN
|
Datetime
|
8
|
N/A
|
Scheduled date for shipment
(optional)
|
|
89
|
GREETING3
|
Character
|
35
|
N/A
|
3rd line of Box label greeting
(Optional).
|
|
90
|
GREETING4
|
Character
|
35
|
N/A
|
4th line of Box label greeting
(Optional).
|
|
91
|
GREETING5
|
Character
|
35
|
N/A
|
5th line of Box label greeting
(Optional).
|
|
92
|
GREETING6
|
Character
|
35
|
N/A
|
6th line of Box label greeting
(Optional).
|
|
93
|
PASSWORD
|
Character
|
20
|
N/A
|
SiteLINK Customer Password
|
|
94
|
CUSTOM01
|
Character
|
240
|
N/A
|
Custom Information (if any) for 1st
item in the order.
|
|
95
|
CUSTOM02
|
Character
|
240
|
N/A
|
Custom Information (if any) for 2nd
item in the order.
|
|
96
|
CUSTOM03
|
Character
|
240
|
N/A
|
Custom Information (if any) for 3rd
item in the order.
|
|
97
|
CUSTOM04
|
Character
|
240
|
N/A
|
Custom Information (if any) for 4th
item in the order.
|
|
98
|
CUSTOM05
|
Character
|
240
|
N/A
|
Custom Information (if any) for 5th
item in the order.
|
|
99
|
RCODE
|
Character
|
3
|
N/A
|
For Use with MOM SiteLink Gateway
only.
|
|
100
|
APPROVAL
|
Character
|
10
|
N/A
|
For Use with MOM SiteLink Gateway
only.
|
|
101
|
AVS
|
Character
|
2
|
N/A
|
For Use with MOM SiteLink Gateway
only.
|
|
102
|
ANTRANS_ID
|
Character
|
40
|
N/A
|
For Use with MOM SiteLink Gateway
only.
|
|
103
|
AUTH_AMT
|
Numeric
|
11
|
2
|
For Use with MOM SiteLink Gateway
only.
|
|
104
|
AUTH_TIME
|
Datetime
|
8
|
N/A
|
For Use with MOM SiteLink Gateway
only.
|
|
105
|
INTERNETID
|
Character
|
32
|
N/A
|
Order number assigned to the order by
SiteLINK when the customer checks out of your web store.
|
|
106
|
ORDNOTE1
|
Character
|
240
|
N/A
|
1st line of Order Notes
(Optional).
|
|
107
|
ORDNOTE2
|
Character
|
240
|
N/A
|
2nd line of Order Notes
(Optional).
|
|
108
|
ORDNOTE3
|
Character
|
240
|
N/A
|
3rd line of Order Notes
(Optional).
|
|
109
|
ORDNOTE4
|
Character
|
240
|
N/A
|
4th line of Order Notes
(Optional).
|
|
110
|
ORDNOTE5
|
Character
|
240
|
N/A
|
5th line of Order Notes
(Optional).
|
|
111
|
FULFILL1
|
Character
|
240
|
N/A
|
1st line of Fulfillment Instructions
(Optional).
|
|
112
|
FULFILL2
|
Character
|
240
|
N/A
|
2nd line of Fulfillment Instructions
(Optional).
|
|
113
|
FULFILL3
|
Character
|
240
|
N/A
|
3rd line of Fulfillment Instructions
(Optional).
|
|
114
|
FULFILL4
|
Character
|
240
|
N/A
|
4th line of Fulfillment Instructions
(Optional).
|
|
115
|
FULFILL5
|
Character
|
240
|
N/A
|
5th line of Fulfillment Instructions
(Optional)
|
|
116
|
INTERNET
|
Logical
|
1
|
N/A
|
Designates web orders with a
'T' or 'F'.
|
|
117
|
PRIORITY
|
Character
|
1
|
N/A
|
Order Priority.
'H'
for High Priority or blank.
|
|
118
|
NOMAIL
|
Logical
|
1
|
N/A
|
No correspondence will print for the
customer.
|
|
119
|
NORENT
|
Logical
|
1
|
N/A
|
Customer name will not be to a List
Management list.
|
|
120
|
NOEMAIL
|
Logical
|
1
|
N/A
|
No email correspondence will be sent
to the customer.
|
|
121
|
PONUMBER
|
Character
|
25
|
N/A
|
PO number for the order.
|
|
122
|
ADDRESS3
|
Character
|
40
|
N/A
|
UK Only.
|
|
123
|
SADDRESS3
|
Character
|
40
|
N/A
|
UK Only.
|
|
124
|
CC_OTHER
|
Character
|
4
|
N/A
|
Credit Card ID.
|
|
125
|
PROMO_CODE
|
Character
|
10
|
N/A
|
Order Promotion Code. Not for use with
SiteLINK.
|
|
126
|
BEST_PROMO
|
Logical
|
1
|
N/A
|
Setting to True will allow M.O.M. to
choose the Best Order Promotion regardless of (Non-blank) entry in
Promo_Code. Not for use with SiteLINK.
|
|
127
|
ORDERMEMO1
|
Character
|
70
|
N/A
|
Order Memo (Optional).
|
|
128
|
ORDERMEMO2
|
Character
|
70
|
N/A
|
Order Memo (Optional).
|
|
129
|
ORDERMEMO3
|
Character
|
70
|
N/A
|
Order Memo (Optional).
|
|
130
|
MULTISHIP
|
Logical
|
1
|
N/A
|
For Use with MOM SiteLink Gateway
only. Designates
Ship Ahead on web orders with a 'T' or
'F'.
|
|
131
|
R_CODE01
|
Character
|
1
|
N/A
|
Return Code for PRODUCT01.
|
|
132
|
R_CODE02
|
Character
|
1
|
N/A
|
Return Code for PRODUCT02.
|
|
133
|
R_CODE03
|
Character
|
1
|
N/A
|
Return Code for PRODUCT03.
|
|
134
|
R_CODE04
|
Character
|
1
|
N/A
|
Return Code for PRODUCT04.
|
|
135
|
R_CODE05
|
Character
|
1
|
N/A
|
Return Code for PRODUCT05.
|
|
136
|
CARDHOLDER
|
Character
|
30
|
N/A
|
Account Holder's Name for
Payment.
|
|
137
|
ISSUE_NUM
|
Character
|
2
|
N/A
|
UK Only.
|
|
138
|
IMPORT_ID
|
Integer
(Auto Increment)
|
4
|
N/A
|
RESERVED.
|
|
138
|
FRDATE
|
Character
|
5
|
N/A
|
UK Only.
|
|
139
|
UPDATEADDR
|
Logical
|
1
|
N/A
|
RESERVED.
|
|
140
|
ALTIT_ID01
|
Character
|
20
|
N/A
|
RESERVED.
|
|
141
|
ALTIT_ID02
|
Character
|
20
|
N/A
|
RESERVED.
|
|
142
|
ALTIT_ID03
|
Character
|
20
|
N/A
|
RESERVED.
|
|
143
|
ALTIT_ID04
|
Character
|
20
|
N/A
|
RESERVED.
|
|
144
|
ALTIT_ID05
|
Character
|
20
|
N/A
|
RESERVED.
|
|
145
|
ROUTINGNUM
|
Character
|
10
|
N/A
|
Bank's Routing Number for eCheck
Payment.
|
|
146
|
ACCOUNTNUM
|
Character
|
20
|
N/A
|
Account Number for eCheck
Payment.
|
|
147
|
ACCTTYPE
|
Character
|
10
|
N/A
|
Account Type for eCheck Payment.
|
|
148
|
BANKNAME
|
Character
|
30
|
N/A
|
Bank's Name for eCheck Payment.
|
|
149
|
SECURITYKY
|
Character
|
10
|
N/A
|
UK Only.
|
|
150
|
PAYPALID
|
Character
|
30
|
N/A
|
PayPal Account Email Address.
|
|
151
|
TX_CODE
|
Character
|
40
|
N/A
|
UK Only.
|
|
152
|
PREAUTH
|
Logical
|
1
|
N/A
|
UK Only.
|
|
153
|
BESTTTC
|
Character
|
13
|
N/A
|
Best Time to Call.
|
|
154
|
NOCALL
|
Logical
|
1
|
N/A
|
Do Not Call Request Indicator.
|
|
155
|
NOFAX
|
Logical
|
1
|
N/A
|
Do Not Fax Request Indicator.
|
|
156
|
CERTID
|
Numeric
|
12
|
0
|
Gift Certificate ID Number.
|
|
157
|
GC_RECIP
|
Character
|
40
|
0
|
Gift Certificate Recipient Name
|
|
158
|
GC_EXPDATE
|
Datetime
|
8
|
0
|
Gift Certificate Expiration Date.
|
|
159
|
GC_NOTE
|
Character
|
100
|
0
|
Gift Certificate Message.
|
|
160
|
PTS_AMT01
|
Numeric
|
12
|
2
|
Amount of Points Redeemed for Line
Item 1 or Amount of Points Redeemed for Order Level Point
Redemption.
|
|
161
|
PTS_USED01
|
Logical
|
1
|
N/A
|
Indicates that Points are being
redeemed for Line Item 1 or when using
Order
Level Point Redemption; for the entire order amount.
|
|
162
|
PTS_AMT02
|
Numeric
|
12
|
2
|
The amount of points redeemed for
Line Item 2.
|
|
163
|
PTS_USED02
|
Logical
|
1
|
N/A
|
Indicates that Points are being
redeemed for Line Item 2.
|
|
164
|
PTS_AMT03
|
Numeric
|
12
|
2
|
The amount of points redeemed for
Line Item 3.
|
|
165
|
PTS_USED03
|
Logical
|
1
|
N/A
|
Indicates that Points are being
redeemed for Line Item 3.
|
|
166
|
PTS_AMT04
|
Numeric
|
12
|
2
|
The amount of points redeemed for
Line Item 4.
|
|
167
|
PTS_USED04
|
Logical
|
1
|
N/A
|
Indicates that Points are being
redeemed for Line Item 4.
|
|
168
|
PTS_AMT05
|
Numeric
|
12
|
2
|
The amount of points redeemed for
Line Item 5.
|
|
169
|
PTS_USED05
|
Logical
|
1
|
N/A
|
Indicates that Points are being
redeemed for Line Item 5.
|
|
170
|
SHIP_HOLD
|
Date
|
8
|
N/A
|
|
