Field Name

Field Format

Rqd

Description

FirstName

String

Yes

Customer First Name

LastName

String

Yes

Customer Last Name

Address1

String

Yes

Customer Address 1

Address2

String

Customer Address 2

City

String

Yes

Customer City

Country

String (2)

Yes

Customer Country

State

String (2)

Yes

Customer State

Zip

String

Yes

Customer Postal Code

HomePhone

String

Customer Home Phone

CellPhone

String

Customer Cell Phone

WorkPhone

String

Customer Work Phone

Email

String

Yes

Customer Email

DNNLogin

String

Yes

Customer  DNN Login

CompanyName

String

Customer Company Name

OrderID

String

Yes

Order ID

OrderDate

DateTime (MMDDYYYY)

Yes

Populate with today’s date if no input value exists

OrderStatus

String

Yes

Status of the Order (Open, Closed, Cancelled, Shipped, Warehouse , BillMeLater)

ShipFirstName

String

ShipLastName

String

ShipAddress1

String

ShipAddress2

String

ShipCity

String

ShipState

String

ShipZipcode

String

ShipCountry

String

ShipMethod

String

ShippingTotal

Decimal

HandlingCharge

Decimal

TaxTotal

Decimal

Yes

Surcharge

Decimal

CouponId

Integer

Discount

Decimal

MemberDiscount

Decimal

MemberRole

String

AffiliateId

String

ProductID

String

Yes

ProductName

String

Yes

ProductSKU

String

Yes

Quantity

Integer

Yes

Populate with 1 if no input value exists

UnitCost

Decimal

Yes

TaxRate

Decimal

SerialNumber

String

BillingName

String

Yes

BillingAddress

String

Yes

BillingCity

String

Yes

BillingState

String

Yes

BillingZip

String

Yes

BillingCountry

String

Yes

PayType

String

Yes

OrderTotal

Decimal

Yes

AccountNumber

String

Yes

ExpRoute

String (MMYY)

Yes

CVV

String

Credit card security code

TransID

String

Yes

Payment transaction id

Notes

String

Payment processing notes

PaymentStatus

String

Yes

Approved or Declined

AuthCode

String

Payment authorization code

InvoiceNo

String

No

Invoice number used on payment

PONumber

String

No

Purchase order number used for payment