Contents

Introduction
Basic Concepts
Accounting
Advertisements and Catalogs
Shipping
Order Processing
Purchasing
Getting Started
Main Menu
Documentation
Customer Functions
Customer Lookup Screen
Customer Information Screen
Customer Contact Screen
Deduping and Deleting Customers
Order Functions
Order Entry
Order Review
Order Status Screen
Release Orders on Hold
Credit Card Processing
Order Processing Examples
Order Processing - Batch Mode
Order Processing - Single Order
Batch Order Making Utility
Club Membership Plan
Product Functions
Supplier Maintenance
Stock Maintenance - Overview
Rename Stock Number
Additional Stock Information Maintenance
Additional Supplier Information Maintenance
Purchasing Functions
Establish New Low Levels
Order Product
Review Purchase Orders
Record Delivery from Suppliers
Product's Purchasing Forecast
Inventory Recieving & Adjustment Functions
Purchase Order List
Adjust Inventory for Stock Item
Assemble Kits
Auto-Replenish Bins
Print Additional Stock ID Labels
Product Scan & Receive
AIM Import From An External File
AIM Export To An External File
Accounting Functions
Accounts Receivable Functions
Accounts Receivable Journal
Accounts Receivable Status Definitions
Applying Customer Credit
Applying Customer Payments
Applying Finance Charges
Accounts Payable Functions
Accounts Payable Journal
Paying Suppliers
Reconcile Received Merchandise With Supplier Invoices
General Accounting Functions
Credit Card Merchant Accounts
General Ledger Interface
Sales Tax Rates Maintenance
Close Year
Posting
Inventory Valuation Methods
System Setup Functions
Advertising Information
Catalogs
Media Source Codes
Customer Form Letters
Telemarketing Scripts
Order Type Code Maintenance
Standard Greetings Maintenance
Order Promotions Information
Accounting Information
Credit Card Merchant Accounts
General Ledger Interface
Sales Tax Rates Maintenance
Posting
Close Year
Inventory Valuation Methods
General System Parameters
Shipping Methods
System Security
Customer Information
Customer Type Code Maintenance
Customer Salutations Maintenance
Customer Honorifics Maintenance
Order Processing Forms
Master Pick Report
Pick Ticket
Packing Slip & Invoice w/ Label
Special Modules
Address Correction and Validation Module
Advanced Inventory Module
Advanced Warehouse Module
Amazon Order Management Module
Automatic Shipping Calculations Module
Contact Management Module
Database Purge Module
eCommerce Management Direct Feeds
Interactive Credit Card Authorization System
Import/Export Module
List Management Module
Miva Order Management Module
Multi-Company Controller Module
Point of Purchase Module
Product Manufacturing Module
Shared Inventory Module
ShopSite Order Management Module
SiteLINK e-Commerce Module
Subscription Management Module
Web Auction Management Module (WAMM)
X-Cart Order Management Module
Yahoo Order Management Module
Reports
Accounting Reports
A/P Aging Report
A/P Checks-to-Print Report
A/P Journal Activity Report
A/R Aging Report
A/R Journal Activity Report
Credit Card Merchant Deposit Report
Customer Deferred Balance Report
Inventory Cost Lots
Gift Certificates Activity Report
Lost Sales Report
Product Profit Report
Product Royalties Report
Sales Listing Report
Sales Tax Collection Report
Shipping Charges Report
Cashier's Drawer Daily Reconciliation Report
Customer Performance Report
Uncollected Balance Report
Advertising Reports
Catalog Square Inch Analysis Report
Downstream Analysis Report
Market Analysis Report
Order Promotions Activity Report
Product Within Source Key Profit Report
Response Curve Analysis Report
Selling Tools Activity Report
Source Key Profit Report
Inventory Reports
Auto Replenish Bin Report
Back Ordered Products Report
Bin Report
Detailed Back Ordered Kit Items Report
Inventory Journal Transactions
Inventory List
Product Low Level Notification List
Return Merchandise Authorization Detail Report
Item Exchange Report
Order Activity Reports
Daily Order Activity Report Section 1 (Orders Entered)
Daily Order Activity Report Section 2 (Invoices Generated)
Daily Order Activity Report Section 3 (Payment Received)
Warehouse Daily Activity Report
Feed Order Activity Report Sample
Performance Analysis Reports
Catalog Performance Analysis Report
Customer Performance Analysis Report
Product Performance Analysis Report
Source Key Performance Analysis Report
Data Dictionary
File Structure - A/R Journal
File Structure - Advertising Source Keys
File Structure - Composite Items
File Structure - Customers
File Structure - Invoices
File Structure - Import/Export
File Structure - Orders
File Structure - Order Line Items
File Structure - Stock Item Buy Price
File Structure - Stock Item Selling Price
File Structure - Stock Items
File Structure - Subscriptions
File Structure - Suppliers
File Structure - Telemarketing Entries
Data Dictionary - XL Edition
XL File Structure - A/R Journal
XL File Structure - Advertising Source Keys
XL File Structure - Composite Items
XL File Structure - Customers
XL File Structure - Invoice
XL File Structure - Order Line Items
XL File Structure - Orders
XL File Structure - Stock Item Buy Price
XL File Structure - Stock Item Selling Price
XL File Structure - Stock Items
XL File Structure - Subscriptions
XL File Structure - Suppliers
XL File Structure - Telemarketing Entries
XL File Structure - Import/Export
SiteLINK
SiteLINK 5.4
SiteLINK 5.4 Setup
SiteLINK 5.4 System Requirements
Creating Your Store
Uploading New Customer and Order Information to SiteLINK 5
Downloading Orders and Information Requests in MOM
Store Activity Reports
SiteLINK 5.0 Global Discount
Store Setting
Style Sheet
Maintain Store Text Pages
Generate Search Engine Product List
Account Info
SiteLINK Support Team for SiteLINK
Getting Help For SiteLINK 5.4
Setup In Mom
Product Options
SiteLINK Store Departments Maintenance
SiteLINK Store Specials Maintenance
Setting Up Product Information
Mom Maintenance
SiteLINK Preferences Maintenance
Setting Up Acknowledgement E-Mails
Setting Up the Import/Export Module for Use with SiteLINK
Setting Up Shipping Options for Shoppers
Setting Up Credit Card Options for Shoppers
Setting Up Advertising Source Codes for Hyperlinks
Setting Up Catalog Selection Options for Information Requests
SiteLINK 5.4 Store Publisher
SiteLINK 5.4 Store Publisher - Web Service Settings
SiteLINK 5.4 Store Publisher - Froogle Data Feed
SiteLINK 5.4 Store Publisher - SiteLINK
Download New Orders from SiteLINK
Demo Store Instructions
Section 1 - M.O.M. Setup
Section 2 - SiteLINK Setup

 
Home
MOM Helpers Online Help
Prev Page Next Page
 
 

File Structure - Import/Export

This table lists the data fields required for the customer and order information in an order import or export file.

See Also

Import/Export Module

Table Legend

The column headings in the table include the following.

  • Position - The ordinal position of the field in the table.

  • Field Name - The column name used in programming the information transferred. It serves to classify data kept in this field.

  • Type - Can be one of 6 types:

Char - Text type data

Text- a field with a large character limit.

Numeric - numbers

Int- a whole number

Datetime - a date

Bit- a logical   field. 0=False, 1=True

  • Character Length- For Character fields only. The maximum number of character that the field element can occupy.

  • Numeric Precision - For numeric fields only. The maximum length for a numeric value before the radix point.

  • Numeric Scale- For numeric fields only. The maximum length for a decimal value after the radix point.

  • Description of Field - A definition of the field's contents. RESERVED signifies for M.O.M. use only. FUTURE USE signifies that the field may be used in a future release. UK Only signifies a field used for the UK edition of M.O.M.

Table

POSITION

FIELDNAME

TYPE

CHARACTER LENGTH

NUMERIC PRECISION

NUMERIC SCALE

DESCRIPTION

1

CUSTNUM

Numeric

N/A

10

0

The billing customer number. This should only be used when a direct match between the 800 service 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

Char

15

N/A

N/A

The 800 service assigned customer number.

3

LASTNAME

Char

20

N/A

N/A

Last name (Billing address)

4

FIRSTNAME

Char

15

N/A

N/A

First name.

5

COMPANY

Char

40

N/A

N/A

Company name.

6

ADDRESS1

Char

40

N/A

N/A

First address line.

7

ADDRESS2

Char

40

N/A

N/A

Second address line.

8

CITY

Char

20

N/A

N/A

City.

9

STATE

Char

3

N/A

N/A

State/Province.

10

ZIPCODE

Char

10

N/A

N/A

ZIP Code/Postal Code.

11

CFOREIGN

Char

1

N/A

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

Char

18

N/A

N/A

Format (xxx) xxx-xxxx

13

COMMENT

Char

40

N/A

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

Char

1

N/A

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

Char

2

N/A

N/A

Second customer type field.

16

CTYPE3

Char

4

N/A

N/A

Third customer type field.

17

TAXEXEMPT

Char

1

N/A

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

Char

1

N/A

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

Char

2

N/A

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

Char

19

N/A

N/A

Credit Card Number. Spaces are permitted. Dashes are not permitted.

21

EXPIRES

Char

5

N/A

N/A

Credit card Expiration date. The format should be MM/YY.

22

SOURCE_KEY

Char

9

N/A

N/A

The source key for this order/customer set up in Maintain Source Codes.

23

CCATALOG

Char

6

N/A

N/A

The catalog code for this order set up in Maintain Catalog Codes.

24

SALES_ID

Char

3

N/A

N/A

The sales id for the order set up in Maintain User ID.

25

OPER_ID

Char

3

N/A

N/A

The Operator ID for this order set up in Maintain User ID.

26

REFERENCE

Char

20

N/A

N/A

A credit card approval number or check number for this order.

27

SHIPVIA

Char

3

N/A

N/A

Designated shipping method for order. Set up in Maintain Shipping Methods, Default method is used if left blank. Also can be used to designate a shipping method for a particular product, or groups of products (01 through 05) ordered.

28

FULFILLED

Char

1

N/A

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

N/A

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

Char

1

N/A

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

Datetime

N/A

8

0

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

N/A

8

0

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

Char

20

N/A

N/A

The 1st product code on the order.

34

QUANTITY01

Numeric

N/A

8

2

The quantity of this product being ordered.

35

PRODUCT02

Char

20

N/A

N/A

The 2nd product code on the order.

36

QUANTITY02

Numeric

N/A

8

2

The quantity of this product being ordered.

37

PRODUCT03

Char

20

N/A

N/A

The 3rd product code on the order.

38

QUANTITY03

Numeric

N/A

8

2

The quantity of this product being ordered.

39

PRODUCT04

Char

20

N/A

N/A

The 4th product code on the order.

40

QUANTITY04

Numeric

N/A

8

2

The quantity of this product being ordered.

41

PRODUCT05

Char

20

N/A

N/A

The 5th product code on the order.

42

QUANTITY05

Numeric

N/A

8

2

The quantity of this product being ordered.

43

SLASTNAME

Char

20

N/A

N/A

Last name (Optional Shipping address).

44

SFIRSTNAME

Char

15

N/A

N/A

First name (Optional Shipping address).

45

SCOMPANY

Char

40

N/A

N/A

Company name (Optional Shipping address).

46

SADDRESS1

Char

40

N/A

N/A

First address line (Optional Shipping address).

47

SADDRESS2

Char

40

N/A

N/A

Second address line (Optional Shipping address).

48

SCITY

Char

20

N/A

N/A

City (Optional Shipping address).

49

SSTATE

Char

3

N/A

N/A

State/Province (Optional Shipping address).

50

SZIPCODE

Char

10

N/A

N/A

ZIP Code/Postal Code (Optional Shipping address).

51

HOLDDATE

Datetime

N/A

23

3

Establishes a date to hold order before processing (Optional).

52

PAYMETHOD

Char

2

N/A

N/A

Method of Payment (Optional). This may be one of four codes: CC - Credit Card CK - Check with order IN - Open Invoice CO - COD order If not entered,, the system will determine payment based on accompanying CARDNUM field or default.

53

GREETING1

Char

35

N/A

N/A

1st line of Box label greeting (Optional).

54

GREETING2

Char

35

N/A

N/A

2nd line of Box label greeting (Optional).

55

PROMOCRED

Numeric

N/A

8

2

Promotional Credit towards order.

56

USEPRICES

Char

1

N/A

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

N/A

12

4

The price to assign to the 1st product code.

58

DISCOUNT01

Numeric

N/A

3

0

Corresponding discount expressed as a percentage (0-99).

59

PRICE02

Numeric

N/A

12

4

The price to assign to the 2nd product code.

60

DISCOUNT02

Numeric

N/A

3

0

Corresponding discount expressed as a percentage (0-99).

61

PRICE03

Numeric

N/A

12

4

The price to assign to the 3rd product code.

62

DISCOUNT03

Numeric

N/A

3

0

Corresponding discount expressed as a percentage (0-99).

63

PRICE04

Numeric

N/A

12

4

The price to assign to the 4th product code.

64

DISCOUNT04

Numeric

N/A

3

0

Corresponding discount expressed as a percentage (0-99).

65

PRICE05

Numeric

N/A

12

4

The price to assign to the 5th product code.

66

DISCOUNT05

Numeric

N/A

3

0

Corresponding discount expressed as a percentage (0-99).

67

USESHIPAMT

Char

1

N/A

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

N/A

8

2

The shipping charges to assign to the order if the USESHIPAMT field is used.

69

EMAIL

Char

50

N/A

N/A

Customer's e-mail address. This is automatically captured by SiteLINK.

70

COUNTRY

Char

3

N/A

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

Char

3

N/A

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

Char

18

N/A

N/A

The fax number.

73

SPHONE

Char

18

N/A

N/A

The shipping phone number.

74

SPHONE2

Char

18

N/A

N/A

The shipping fax number.

75

SEMAIL

Char

50

N/A

N/A

The shipping e-mail address.

76

ORDERTYPE

Char

6

N/A

N/A

The order type code.

77

INPART

Char

1

N/A

N/A

The invoice part letter code.

78

TITLE

Char

40

N/A

N/A

The title of the bill-to name; e.g., president, manager.

79

SALU

Char

6

N/A

N/A

The salutation for the bill-to name.

80

HONO

Char

6

N/A

N/A

The honorific for the bill-to name

81

EXT

Char

5

N/A

N/A

Phone extension for the bill-to name.

82

EXT2

Char

5

N/A

N/A

Alternate phone extension for the bill-to name.

83

STITLE

Char

40

N/A

N/A

The title for the ship-to name.

84

SSALU

Char

6

N/A

N/A

The salutation for the ship-to name.

85

SHONO

Char

6

N/A

N/A

The honorific for the ship-to name.

86

SEXT

Char

5

N/A

N/A

Phone extension for the ship-to name.

87

SEXT2

Char

5

N/A

N/A

Alternate phone extension for the ship-to name.

88

SHIP_WHEN

Datetime

N/A

23

3

Scheduled date for shipment (optional)

89

GREETING3

Char

35

N/A

N/A

3rd line of Box label greeting (Optional).

90

GREETING4

Char

35

N/A

N/A

4th line of Box label greeting (Optional).

91

GREETING5

Char

35

N/A

N/A

5th line of Box label greeting (Optional).

92

GREETING6

Char

35

N/A

N/A

6th line of Box label greeting (Optional).

93

PASSWORD

Char

20

N/A

N/A

SiteLINK Customer Password

94

CUSTOM01

Char

240

N/A

N/A

Custom Information (if any) for 1st item in the order.

95

CUSTOM02

Char

240

N/A

N/A

Custom Information (if any) for 2nd item in the order.

96

CUSTOM03

Char

240

N/A

N/A

Custom Information (if any) for 3rd item in the order.

97

CUSTOM04

Char

240

N/A

N/A

Custom Information (if any) for 4th item in the order.

98

CUSTOM05

Char

240

N/A

N/A

Custom Information (if any) for 5th item in the order.

99

RCODE

Char

3

N/A

N/A

For Use with MOM SiteLink Gateway only.

100

APPROVAL

Char

10

N/A

N/A

For Use with MOM SiteLink Gateway only.

101

AVS

Char

2

N/A

N/A

For Use with MOM SiteLink Gateway only.

102

ANTRANS_ID

Char

30

N/A

N/A

For Use with MOM SiteLink Gateway only.

103

AUTH_AMT

Numeric

N/A

11

2

For Use with MOM SiteLink Gateway only.

104

AUTH_TIME

Datetime

N/A

23

3

For Use with MOM SiteLink Gateway only.

105

INTERNETID

 

Char

32

N/A

N/A

Order number assigned to the order by SiteLINK when the customer checks out of your web store.

106

ORDNOTE1

Char

240

N/A

N/A

1st line of Order Notes (Optional).

107

ORDNOTE2

Char

240

N/A

N/A

2nd line of Order Notes (Optional).

108

ORDNOTE3

Char

240

N/A

N/A

3rd line of Order Notes (Optional).

109

ORDNOTE4

Char

240

N/A

N/A

4th line of Order Notes (Optional).

110

ORDNOTE5

Char

240

N/A

N/A

5th line of Order Notes (Optional).

111

FULFILL1

Char

240

N/A

N/A

1st line of Fulfillment Instructions (Optional).

112

FULFILL2

Char

240

N/A

N/A

2nd line of Fulfillment Instructions (Optional).

113

FULFILL3

Char

240

N/A

N/A

3rd line of Fulfillment Instructions (Optional).

114

FULFILL4

Char

240

N/A

N/A

4th line of Fulfillment Instructions (Optional).

115

FULFILL5

Char

240

N/A

N/A

5th line of Fulfillment Instructions (Optional)

116

INTERNET

Bit

N/A

1

0

Designates web orders with a
'T' or 'F'.

117

PRIORITY

Char

1

N/A

N/A

Order Priority.  'H' for High Priority or blank.

118

NOMAIL

Bit

N/A

1

0

No correspondence will print for the customer.

119

NORENT

Bit

N/A

1

0

Customer name will not be to a List Management list.

120

NOEMAIL

Bit

N/A

1

0

No email correspondence will be sent to the customer.

121

PONUMBER

Char

25

N/A

N/A

PO number for the order.

122

ADDRESS3

Char

40

N/A

N/A

UK Only.

123

SADDRESS3

Char

40

N/A

N/A

UK Only.

124

CC_OTHER

Char

4

N/A

N/A

Credit Card ID.

125

PROMO_CODE

Char

10

N/A

N/A

Order Promotion Code. Not for use with SiteLINK.

126

BEST_PROMO

Bit

N/A

1

0

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

Char

70

N/A

N/A

Order Memo (Optional).

128

ORDERMEMO2

Char

70

N/A

N/A

Order Memo (Optional).

129

ORDERMEMO3

Char

70

N/A

N/A

Order Memo (Optional).

130

MULTISHIP

Bit

N/A

1

0

For Use with MOM SiteLink Gateway only. Designates   Ship Ahead on web orders with a 'T' or 'F'.

131

R_CODE01

Char

1

N/A

N/A

Return code for PRODUCT01

132

R_CODE02

Char

1

N/A

N/A

Return code for PRODUCT02

133

R_CODE03

Char

1

N/A

N/A

Return code for PRODUCT03

134

R_CODE04

Char

1

N/A

N/A

Return code for PRODUCT04

135

R_CODE05

Char

1

N/A

N/A

Return code for PRODUCT5

136

CARDHOLDER

Char

30

N/A

N/A

Account Holder's Name for Payment

137

ISSUE_NUM

Char

2

N/A

N/A

UK Only.

138

FRDATE

Char

5

N/A

N/A

UK Only.

139

UPDATEADDR

Bit

N/A

1

0

RESERVED.

139

ALTIT_ID01

Char

20

N/A

N/A

RESERVED.

140

ALTIT_ID02

Char

20

N/A

N/A

RESERVED.

141

ALTIT_ID03

Char

20

N/A

N/A

RESERVED.

142

ALTIT_ID04

Char

20

N/A

N/A

RESERVED.

143

ALTIT_ID05

Char

20

N/A

N/A

RESERVED.

144

ROUTINGNUM

Char

10

N/A

N/A

Bank's Routing Number for eCheck Payment.

145

ACCOUNTNUM

Char

  20

N/A

N/A

Account Number for eCheck Payment.

146

ACCTTYPE

Char

  10

N/A

N/A

Account Type for eCheck Payment.

147

BANKNAME

Char

30

N/A

N/A

Bank's Name for eCheck Payment.

148

SECURITYKY

Char

10

N/A

N/A

UK Only.

149

PAYPALID

Char

30

N/A

N/A

PayPal Account Email Address.

150

TX_CODE

Char

40

N/A

N/A

UK Only.

151

PREAUTH

Bit

N/A

1

0

UK Only.

152

BESTTTC

Char

13

N/A

N/A

Best Time to Call.

153

NOCALL

Bit

N/A

1

0

Do Not Call Request Indicator.

154

NOFAX

Bit

N/A

1

0

Do Not Fax Request Indicator.

155

CERTID

Numeric

N/A

12

0

Gift Certificate ID.

156

GC_RECIP

Char

40

N/A

N/A

Gift Certificate Recipient.

157

GC_NOTE

Char

100

N/A

N/A

Gift Certificate Message.

158

GC_EXPDATE

Datetime

N/A

23

3

Gift Certificate Expiration Date.

159

PTS_AMT01

Numeric

N/A

12

2

Amount of Points Redeemed for Line Item 1 or Amount of Points Redeemed for Order Level Point Redemption.

160

PTS_USED01

Bit

N/A

1

0

Indicates that Points are being redeemed for Line Item 1 or when using   Order Level Point Redemption; for the entire order amount.

161

PTS_AMT02

Numeric

N/A

12

2

Amount of Points Redeemed for Line Item 2.

162

PTS_USED02

Bit

N/A

1

0

Indicates that Points are being redeemed for Line Item 2.

163

PTS_AMT03

Numeric

N/A

12

2

Amount of Points Redeemed for Line Item 3.

164

PTS_USED03

Bit

N/A

1

0

Indicates that Points are being redeemed for Line Item 3.

165

PTS_AMT04

Numeric

N/A

12

2

Amount of Points Redeemed for Line Item 4.

166

PTS_USED04

Bit

N/A

1

0

Indicates that Points are being redeemed for Line Item 4.

167

PTS_AMT05

Numeric

N/A

12

2

Amount of Points Redeemed for Line Item 5.

168

PTS_USED05

Bit

N/A

1

0

Indicates that Points are being redeemed for Line Item 5.

169

SHIP_HOLD

Datetime

N/A

23

3

 

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)