Pos

Fieldname

Req.

Type

Max Width

Dec. Places

Field Description

1

RESERVED

N

Character

n/a

This field will be blank

2

CUSTOMER_NUMBER

Y

Character

50

Source System's Customer Number.  Please add your assigned vendor prefix code and a "-" to beginning of all customer #s

3

BILL_LAST_NAME

Y

Character

50

Last Name (billing address)

4

BILL_FIRST_NAME

Y

Character

30

First Name

5

BILL_COMPANY

N

Character

255

Company Name

6

BILL_ADDRESS1

Y

Character

255

First Address Line

7

BILL_ADDRESS2

N

Character

255

Second Address Line

8

BILL_CITY

Y

Character

50

City

9

BILL_STATE

Y

Character

20

State/Province (USE STATE ABBREVIATION)

10

BILL_ZIPCODE

Y

Character

20

ZIP Code/Postal Code. Format for US: ##### or #####-####. Format for Canada: XXX XXX.

11

RESERVED

N

Character

n/a

reserved for future use

12

BILL_PHONE_NUMBER

Y

Character

30

Required Format: (###) ###-####

13

ACH_BANK_NAME

Y for ACH Orders

Character

255

Bank Name (CK, PC pay methods only)

14

NO_SOLICITING

N

Numeric

1

If the customer should not be solicited pass a "1"

15

RESERVED

N

Character

n/a

This field will be blank

16

PAYMENT_TYPE

N

Character

4

For paid credit card orders, this field must contain 'AUTH' for authorized payments or 'SALE' for settled/captured payments, otherwise leave blank. 
When populated, the following additional fields will also need to be populated:  AMOUNT_ALREADY_PAID, MERCHANT_TRANSACTION_ID.

17

TOKEN

N

Character

255

If the order was processed using credit card tokenization, put the value here. 
OrderLogix will determine in advance the exact format and data to place in this field depending on the tokenization service.

18

PAY_PROC_ACCT

N

Character

50

If using TOKEN this pass the name of the payment processing account to use. 
This value is defined in OrderLogix and will be provided in advance.

19

CC_TYPE

Y for CC Orders

Character

2

Credit Card type.  Please use the following codes for the supported card brands:
 V=Visa, MC=MasterCard, D=Discover, A = American Express

20

CC_NUMBER

Y for CC Orders

Character

30

Credit Card Number

21

EXP_DATE

Y for CC Orders

Character

50

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

22

DNIS

Y

Character

50

The source code for this order. Please Enter the DNIS, Source Code or Telephone # dialed by customer. 
Values for this field will be provided in advance by the OrderLogix Client.

23

KEY_CODE

N

Character

25

Keycode (Promo Code) for the order.  Values for this field will be provided in advance by the OrderLogix Client.

24

EMP_NUMBER

Y

Character

50

The employee number the order belongs to. 
Values for this field will be provided in advance by the OrderLogix Client.

25

RESERVED

N

Character

n/a

This field will be blank

26

RESERVED

N

Character

n/a

This field will be blank

27

SHIPPING_METHOD

Y

Character

10

Designated shipping method for order. "REG" = Standard shipping, "RSH" = Rush Shipping or other provided shipping method codes. 
Any other valid shipping method codes will be provided in advance by the OrderLogix Client.

28

ORDER_ALREADY_FULLFILLED

N

Character

1

This field will be blank for unshipped orders, and filled in with either "X" or "Y" for orders which have already shipped
You must enter values is fields 90-92 (TRACKING_NUM, SHIPPING_CARRIER, SHIPPING_DATE) if you are passing "X" or "Y" in this field.

29

AMOUNT_ALREADY_PAID

N

Numeric

9

2

This field will be blank for unpaid orders, and filled in with the total amount charged for paid orders.  If you pass 0.00, we will assume the order was paid for prior to importing and it will ship without payment processing. 
Multi-Pay Offers have special Logic.  Please consult OrderLogix for amount to pass when order contains multi-pay offers

30

CONTINUED

N

Character

1

Indicate with a “Y” if this record is a continuation of the prior record. This is used when more then 5 products are required for a given order, otherwise it will be "N"

31

ORDER_DATE

Y

Date

8

The entry date of the order. The format will be MM/DD/YY.  This must be the current date or a date before the current date. Can include a time stamp (optional) in the format MM/DD/YY HH:MM:SS.

32

ORDER_NUMBER

Y

Character

50

Call Center's Order Number.  Can be more than 8 and can be alpha.  Please add your assigned call center code and a "-" to beginning of all order #s.  This will be stored in the 'Web Order #" when importing into OLX

33

PRODUCT01

Y

Character

255

The 1st product code on the order.
Note: this must exactly match the Product Offer name as it appears in OLX if orders are being imported into OLX using this specification.

34

QUANTITY01

Y

Numeric

8

The quantity of this product being ordered. This field is required if field 33 (PRODUCT01) is populated, otherwise leave blank or set to zero.  Must be a whole #/integer, decimals are not allowed.

35

PRODUCT02

N

Character

255

The 2nd product code on the order.
Note: this must exactly match the Product Offer name as it appears in OLX if orders are being imported into OLX using this specification.

36

QUANTITY02

N

Numeric

8

The quantity of this product being ordered. This field is required if field 35 (PRODUCT02) is populated, otherwise leave blank or set to zero.  Must be a whole #/integer, decimals are not allowed.

37

PRODUCT03

N

Character

255

The 3rd product code on the order.
Note: this must exactly match the Product Offer name as it appears in OLX if orders are being imported into OLX using this specification.

38

QUANTITY03

N

Numeric

8

The quantity of this product being ordered. This field is required if field 37 (PRODUCT03) is populated, otherwise leave blank or set to zero.  Must be a whole #/integer, decimals are not allowed.

39

PRODUCT04

N

Character

255

The 4th product code on the order.
Note: this must exactly match the Product Offer name as it appears in OLX if orders are being imported into OLX using this specification.

40

QUANTITY04

N

Numeric

8

The quantity of this product being ordered. This field is required if field 39 (PRODUCT04) is populated, otherwise leave blank or set to zero.  Must be a whole #/integer, decimals are not allowed.

41

PRODUCT05

N

Character

255

The 5th product code on the order.
Note: this must exactly match the Product Offer name as it appears in OLX if orders are being imported into OLX using this specification.

42

QUANTITY05

N

Numeric

8

The quantity of this product being ordered. This field is required if field 41 (PRODUCT05) is populated, otherwise leave blank or set to zero.  Must be a whole #/integer, decimals are not allowed.

43

SHIP_TO_LAST_NAME

Y

Character

50

Last name for shipping address

44

SHIP_TO_FIRST_NAME

Y

Character

50

First name for shipping address

45

SHIP_TO_COMPANY

N

Character

255

Company name

46

SHIP_TO_ADDRESS1

Y

Character

255

Ship-to First Address line

47

SHIP_TO_ADDRESS2

N

Character

255

Ship-to Second address line

48

SHIP_TO_CITY

Y

Character

50

Ship-to City

49

SHIP_TO_STATE

Y

Character

50

Ship-to State/Province

50

SHIP_TO_ZIP

Y

Character

50

Ship-to ZIP Code/Postal Code. Format for US: ##### or #####-####. Format for Canada: XXX XXX.

51

ORDER_HOLD_DATE

N

Date

8

For hold orders, enter the release date here.  Order will not be payment processed until this date.  This must be a date in the future if passed.

52

PAYMENT_METHOD

Y

Character

2

Method of Payment. This may be one of 4 codes "CC" for credit card, "CK" for Telecheck/check by phone, "PC" for paper check, "IN" for invoice, "MO" for money order.

53

ACH_ROUTING_NUMBER

Y for ACH Orders

Numeric

50

Routing #  (CK, PC pay methods only)

54

ACH_ACCOUNT_NUMBER

Y for ACH Orders

Character

50

Account #  (CK, PC pay methods only)

55

RESERVED

N

Character

n/a

This field will be blank

56

USE_PRICES

Y

Character

1

This field will have a "Y" indicating that the prices are to follow for each of the products starting at field position 73. 
If “N” is passed, the prices that are defined for the items inside the OrderLogix system will be used instead. Please consult with the OrderLogix Client to determine the value for this field.

57

PRICE01

N

Numeric

9

2

The price to assign to the 1st product code. This field is required if field 33 (PRODUCT01) is populated, otherwise leave blank or set to zero.  This is the price before any discount is applied.

58

DISCOUNT01

N

Numeric

9

2

Corresponding discount amount in dollars.  Must be less than or equal to the product price or set to blank or zero if not applicable.

59

PRICE02

N

Numeric

9

2

The price assigned to the 2nd product code. This field is required if field 35 (PRODUCT02) is populated, otherwise leave blank or set to zero.  This is the price before any discount is applied.

60

DISCOUNT02

N

Numeric

9

2

Corresponding discount amount in dollars.  Must be less than or equal to the product price or set to blank or zero if not applicable.

61

PRICE03

N

Numeric

9

2

The price to assign to the 3rd product code. This field is required if field 37 (PRODUCT03) is populated, otherwise leave blank or set to zero.  This is the price before any discount is applied.

62

DISCOUNT03

N

Numeric

9

2

Corresponding discount amount in dollars.  Must be less than or equal to the product price or set to blank or zero if not applicable.

63

PRICE04

N

Numeric

9

2

The price to assign to the 4th product code. This field is required if field 39 (PRODUCT04) is populated, otherwise leave blank or set to zero.  This is the price before any discount is applied.

64

DISCOUNT04

N

Numeric

9

2

Corresponding discount amount in dollars.  Must be less than or equal to the product price or set to blank or zero if not applicable.

65

PRICE05

N

Numeric

9

2

The price to assign to the 5th product code. This field is required if field 41 (PRODUCT05) is populated, otherwise leave blank or set to zero.  This is the price before any discount is applied.

66

DISCOUNT05

N

Numeric

9

2

Corresponding discount amount in dollars.  Must be less than or equal to the product price or set to blank or zero if not applicable.

67

USE_SHIPPING

Y

Character

1

this field will have a “Y” to indicate that the shipping charges for the order are to follow in field 69. 
If “N” is passed, the shipping charges that are defined for the items inside the OrderLogix system will be used instead. Please consult with the OrderLogix Client to determine the value for this field.

68

SHIPPING

N

Numeric

9

2

The shipping charges to assign to the order if the USE_SHIPPING field is used. 
Note that this amount applies to the entire order and must match the value in SHIPPING01

69

EMAIL

N

Character

255

Customer’s E-mail address.

70

MERCHANT_TRANSACTION_ID

N

Character

50

For approved pre-authed or settled orders, enter the TransactionID received from the merchant processor; leave blank if order is unpaid.  This value will be used for settlement of pre-auths or crediting of settled orders when applicable

71

COUNTRY USA = 001

Y

Character

3

Country code for the billing address on an order. Country codes "001" for US, "034" for Canada

72

SCOUNTRY USA = 001

Y

Character

3

Country code for the shipping address on an order. Country codes "001" for US, "034" for Canada.

73

BILL_PHONE_2

N

Character

20

Billing PM Phone number. Required Format: (###) ###-####

74

SHIP_TO_PHONE

Y

Character

30

The shipping phone number. Required Format: (###) ###-####

75

DESCRIPTION01

N

Character

100

Line Item Description to assign to the 1st Product Code and will only be used if USE_PRICES (Field56)=Y.  If USE_PRICES (Field56)=Y and value is blank, the default description from OLX will be used

76

DESCRIPTION02

N

Character

100

Line Item Description to assign to the 2nd Product Code and will only be used if USE_PRICES (Field56)=Y.  If USE_PRICES (Field56)=Y and value is blank, the default description from OLX will be used

77

DESCRIPTION03

N

Character

100

Line Item Description to assign to the 3rd Product Code and will only be used if USE_PRICES (Field56)=Y.  If USE_PRICES (Field56)=Y and value is blank, the default description from OLX will be used

78

DESCRIPTION04

N

Character

100

Line Item Description to assign to the 4th Product Code and will only be used if USE_PRICES (Field56)=Y.  If USE_PRICES (Field56)=Y and value is blank, the default description from OLX will be used

79

CUSTOM_1

N

Character

50

Custom1.  Please enter the value to put into  the custom1 field here.  This Custom field must be enabled in advance by the OrderLogix Client before data can be passed.

80

CUSTOM_2

N

Character

50

Custom2.  Please enter the value to put into  the custom2 field here.  This Custom field must be enabled in advance by the OrderLogix Client before data can be passed.

81

CUSTOM_3

N

Character

50

Custom3.  Please enter the value to put into  the custom3 field here.  This Custom field must be enabled in advance by the OrderLogix Client before data can be passed.

82

CUSTOM_4

N

Character

50

Custom4.  Please enter the value to put into  the custom4 field here.  This Custom field must be enabled in advance by the OrderLogix Client before data can be passed.

83

CUSTOM_5

N

Character

50

Custom5.  Please enter the value to put into  the custom5 field here.  This Custom field must be enabled in advance by the OrderLogix Client before data can be passed.

84

COUPON_CODE01

N

Character

255

The coupon code for PRODUCT01

85

COUPON_CODE02

N

Character

255

The coupon code for PRODUCT02

86

COUPON_CODE03

N

Character

255

The coupon code for PRODUCT03

87

COUPON_CODE04

N

Character

255

The coupon code for PRODUCT04

88

COUPON_CODE05

N

Character

255

The coupon code for PRODUCT05

89

DESCRIPTION05

N

Character

100

Line Item Description to assign to the 5th Product Code and will only be used if USE_PRICES (Field56)=Y.  If USE_PRICES (Field56)=Y and value is blank, the default description from OLX will be used

90

TRACKING_NUM

N

Character

35

If the order is fulfilled then provide the tracking number, otherwise, leave blank

91

SHIPPING_CARRIER

N

Character

35

If the order is fulfilled then provide the shipping carrier, otherwise, leave blank

92

SHIPPING_DATE

N

Date

8

If the order is fulfilled then provide the transaction date, otherwise, leave blank

93

CLIENT_TRANSACTION_ID

N

Character

35

If the order is fulfilled then provide the client transaction id from the fulfillment software, otherwise, leave blank

94

CVV_CODE

N

Character

4

Credit Card CVV code.
For an order that has already had an authorization or settlement processed, DO NOT pass the CVV.  Only pass the CVV for an order that needs to have a payment transaction processed in the OrderLogix system.

95

VOICE_RECORDING_ID

N

Character

50

Voice Log ID.  Please enter the recording transaction # here

96

ACH_CHECK_NUMBER

Y for ACH

Numeric

50

Check #  (CK, PC pay methods only)

97

ORDER_STATE_SALES_TAX

N

Numeric

9

2

State Tax  (when applicable).  OLX can be configured to allow tax to be split over the items or to put all the tax on the first item.  This is a dollar value and not a percentage. 
Note that this amount applies to the entire order

98

ORDER_FEDERAL_SALES_TAX

N

Numeric

9

2

Secondary tax amount to add to the order.  This is a dollar value and not a percentage. 
Note that this amount applies to the entire order

99

CUSTOMER_COMMENTS

N

Character

4000

Customer Notes

100

ACH_IS_SAVINGS_ACCOUNT

N

Numeric

1

for CK/ACH orders, pass a "1" if the account is a Savings Account

101

CUSTOMER_AGE

N

Numeric

4

conditionally required based on DNIS

102

CUSTOMER_DOB

N

Date

8

conditionally required based on DNIS, format as mm/dd/yy

103

CUSTOMER_GENDER

N

Character

50

conditionally required based on DNIS, format as "male" or "female"

104

CUSTOMER_SSN

N

Character

50

conditionally required based on DNIS, format as ###-##-####

105

PACKING_SLIP_COMMENTS

N

Character

4000

not required

106

ORDER_COMMENTS

N

Character

4000

not required

107

LOCATION_CODE

N

Character

10

location where order is captured
If used for the given campaign, this value will be provided in advance by the OrderLogix Client.

108

SHIPPING01

N

Numeric

9

2

The shipping to assign to the 1st product code. 
This value will be ignored if the value of USE_PRICES = “N”

109

TAX_RATE01

N

Numeric

9

4

The tax rate to assign to the 1st product code.  Please specify up to 4 digits of precision after the decimal point.  For example 9.3725 would represent 9.3725% and 10.0000 would represent 10%.
This value will be ignored if the value of USE_TAX = “N”

110

TAX_PROD01

N

Numeric

9

2

The product tax to assign to the 1st product code. Total tax for total QTY purchased.
This value will be ignored if the value of USE_TAX = “N”

111

TAX_SHIPPING_PROD01

N

Numeric

9

2

The shipping tax to assign to the 1st product code. 
This value will be ignored if the value of USE_TAX = “N”

112

PAID_PRICE_PROD01

N

Numeric

9

2

The product price that was already paid for the 1st product code. 
PRICE01 * QUANTITY01 = PAID_PRICE_PROD01
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

113

PAID_SHIPPING_PROD01

N

Numeric

9

2

The shipping amount that was already paid for the 1st product code. This value will match the value in SHIPPING field.
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

114

PAID_TAX_PROD01

N

Numeric

9

2

The tax amount that was already paid for the 1st product code. 
TAX_PROD01 + TAX_SHIPPING_PROD01 = PAID_TAX_PROD01
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

115

SHIPPING02

N

Numeric

9

2

The shipping to assign to the 2nd product code. 
This value will be ignored if the value of USE_PRICES = “N”

116

TAX_RATE02

N

Numeric

9

4

The tax rate to assign to the 2nd product code.  Please specify up to 4 digits of precision after the decimal point.  For example 9.3725 would represent 9.3725% and 10.0000 would represent 10%.
This value will be ignored if the value of USE_TAX = “N”

117

TAX_PROD02

N

Numeric

9

2

The product tax to assign to the 2nd product code. Total tax for total QTY purchased.
This value will be ignored if the value of USE_TAX = “N”

118

TAX_SHIPPING_PROD02

N

Numeric

9

2

The shipping tax to assign to the 2nd product code. 
This value will be ignored if the value of USE_TAX = “N”

119

PAID_PRICE_PROD02

N

Numeric

9

2

The product price that was already paid for the 2nd product code. PRICE02 * QUANTITY02 = PAID_PRICE_PROD02
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

120

PAID_SHIPPING_PROD02

N

Numeric

9

2

The shipping amount that was already paid for the 2nd product code. 
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

121

PAID_TAX_PROD02

N

Numeric

9

2

The tax amount that was already paid for the 2nd product code. 
TAX_PROD02 + TAX_SHIPPING_PROD02 = PAID_TAX_PROD02
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

122

SHIPPING03

N

Numeric

9

2

The shipping to assign to the 3rd product code. 
This value will be ignored if the value of USE_PRICES = “N”

123

TAX_RATE03

N

Numeric

9

4

The tax rate to assign to the 3rd product code.  Please specify up to 4 digits of precision after the decimal point.  For example 9.3725 would represent 9.3725% and 10.0000 would represent 10%.
This value will be ignored if the value of USE_TAX = “N”

124

TAX_PROD03

N

Numeric

9

2

The product tax to assign to the 3rd product code. 
This value will be ignored if the value of USE_TAX = “N”

125

TAX_SHIPPING_PROD03

N

Numeric

9

2

The shipping tax to assign to the 3rd product code. 
This value will be ignored if the value of USE_TAX = “N”

126

PAID_PRICE_PROD03

N

Numeric

9

2

The product price that was already paid for the 3rd product code. 
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

127

PAID_SHIPPING_PROD03

N

Numeric

9

2

The shipping amount that was already paid for the 3rd product code. 
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

128

PAID_TAX_PROD03

N

Numeric

9

2

The tax amount that was already paid for the 13rd product code. 
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

129

SHIPPING04

N

Numeric

9

2

The shipping to assign to the 4th product code. 
This value will be ignored if the value of USE_PRICES = “N”

130

TAX_RATE04

N

Numeric

9

4

The tax rate to assign to the 4th product code.  Please specify up to 4 digits of precision after the decimal point.  For example 9.3725 would represent 9.3725% and 10.0000 would represent 10%.
This value will be ignored if the value of USE_TAX = “N”

131

TAX_PROD04

N

Numeric

9

2

The product tax to assign to the 4th product code. 
This value will be ignored if the value of USE_TAX = “N”

132

TAX_SHIPPING_PROD04

N

Numeric

9

2

The shipping tax to assign to the 4th product code. 
This value will be ignored if the value of USE_TAX = “N”

133

PAID_PRICE_PROD04

N

Numeric

9

2

The product price that was already paid for the 4th product code. 
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

134

PAID_SHIPPING_PROD04

N

Numeric

9

2

The shipping amount that was already paid for the 4th product code. 
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

135

PAID_TAX_PROD04

N

Numeric

9

2

The tax amount that was already paid for the 4th product code. 
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

136

SHIPPING05

N

Numeric

9

2

The shipping to assign to the 5th product code. 
This value will be ignored if the value of USE_PRICES = “N”

137

TAX_RATE05

N

Numeric

9

4

The tax rate to assign to the 5th product code.  Please specify up to 4 digits of precision after the decimal point.  For example 9.3725 would represent 9.3725% and 10.0000 would represent 10%.
This value will be ignored if the value of USE_TAX = “N”

138

TAX_PROD05

N

Numeric

9

2

The product tax to assign to the 5th product code. 
This value will be ignored if the value of USE_TAX = “N”

139

TAX_SHIPPING_PROD05

N

Numeric

9

2

The shipping tax to assign to the 5th product code. 
This value will be ignored if the value of USE_TAX = “N”

140

PAID_PRICE_PROD05

N

Numeric

9

2

The product price that was already paid for the 5th product code. 
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

141

PAID_SHIPPING_PROD05

N

Numeric

9

2

The shipping amount that was already paid for the 5th product code. 
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

142

PAID_TAX_PROD05

N

Numeric

9

2

The tax amount that was already paid for the 5th product code. 
This value will be used if the value of PAYMENT_TYPE = “AUTH” or “SALE”

143

USE_TAXES

N

Character

1

Whether or not to use the tax amounts provided

144

ORDER_SUBTOTAL

N

Numeric

9

2

The sum of all products on the order using formula quantity * (unit price – discount).

145

ORDER_TOTAL

N

Numeric

9

2

The sum of all products, shipping and tax on the order using formula (quantity * (unit price – discount)) + shipping + tax.