A

customerId

varchar(20)

Y

Your internal customer id for this customer

B

orderId

varchar(20)

Y

Your internal order id for the order associated with this transaction

C

dateCreated

datetime (YYYY-MM-DD HH:MM:SS)

Y

The timestamp of the transaction

D

campaignId

integer

Y

The Konnektive campaignId that indicates which campaign to import this order into.

E

productId

integer

Y

The Konnektive campaign productId that indicates which product within the campaign, the transaction was for. (Found on the campaign page)

F

isActiveRecurring

bit
0=false
1=true

Y

Whether this transaction was made on a currently active continuity product

G

nextBillDate

date (YYYY-MM-DD)

Y - IF isActiveRecurring=1

The next scheduled billing date for the active continuity product

H

paySource

ENUM (CREDITCARD, CHECK, or PREPAID)

Y

How the customer paid for the product

I

cardNumber

integer (max 19)

Y - IF paySource=CREDITCARD

Full credit card number used for payment

J

cardExpiryMonth

integer (MM)

Y - IF paySource=CREDITCARD

Month in which the card expires (must include leading zeros)

K

cardExpiryYear

integer (YYYY)

Y - IF paySource=CREDITCARD

Year in which the card expires (must be 4 digits)

L

achRoutingNumber

integer

Y - IF paySource=CHECK

Routing number of the customer's bank

M

achAccountNumber

integer

Y - if paySource=CHECK

Account number of the customer's bank account

N

achAccountType

ENUM
(SAVINGS or CHECKING)

Y - IF paySource=CHECK

Bank Account Type

O

merchantId

integer

Y

Konnektive Id for the merchant account the transaction was billed against

P

merchantTxnId

varchar(30)

Y

transactionId returned by the merchant processor

Q

txnType

ENUM (SALE, AUTHORIZE, CAPTURE, REFUND)

Y

The type of transaction

R

subTotal

decimal

Y

product price before shipping and taxes applied

S

shipTotal

decimal

Y

shipping charged for the order (total amount charged for shipping & handling)

T

salesTax

decimal

Y

sales tax charged for the order

U

totalAmount

decimal

Y

Sum of salesTax / subTotal / shipTotal (Must add up correctly)

V

responseType

ENUM (SUCCESS or DECLINE)

Y

Result of the transaction, was it successful?

W

responseText

ENUM (SUCCESS or DECLINE)

Y

Any additional response information returned by the processor

X

authCode

varchar(20)

N

Authorization Code returned by the processor

Y

parentTxnId

varchar(30)

Y - If txnType=REFUND or txnType=CAPTURE

The parent transaction against which a refund or capture transaction was run

Z

firstName

varchar(30)

Y

Customer's first name

AA

lastName

varchar(30)

Y

Customer's last name

AB

address1

varchar(30)

Y

Billing Address Line 1

AC

address2

varchar(30)

N

Billing Address Line 2

AD

city

varchar(30)

Y

Billing Address City

AE

state

varchar(30)

Y - If country=US or country=CA

Billing Address State

AF

country

char(2)
-standard ISO 2 country codes

Y

Billing Address Country

AG

postalCode

varchar(20)

Y

Billing Address Postal Code

AH

phoneNumber

numeric (no dashes or parentheses)

Y

Primary Phone number of customer

AI

homePhone

numeric (no dashes or parentheses)

N

Home telephone number

AJ

cellPhone

numeric (no dashes or parentheses)

N

Cellphone number

AK

workPhone

numeric (no dashes or parentheses)

N

Work telephone number

AL

emailAddress

emailAddress (must be valid format)

Y

Customer's email address

AM

billShipSame

bit
0=false
1=true

Y

Whether or not the shipping address is the same as the billing address

AN

shipFirstName

varchar(30)

N

Shipping First Name

AO

shipLastName

varchar(30)

N

Shipping Last Name

AP

shipAddress1

varchar(30)

Y - If billShipSame=0

Shipping Address Line 1

AQ

shipAddress2

varchar(30)

N

Shipping Address Line 2

AR

shipCity

varchar(30)

Y - If billShipSame=0

Shipping Address City

AS

shipState

varchar(30)

Y - If country=US or country=CA

Shipping Address State

AT

shipCountry

char(2)
-standard ISO 2 country codes

Y - If billShipSame=0

Shipping Address Country

AU

shipPostalCode

varchar(20)

Y - If billShipSame=0

Shipping Address Postal Code

AV

affId

varchar(20)

N

Konnektive affId as defined in the CRM

AW

subAffId

varchar(20)

N

Sub affilaite id associated with order

AX

shipDate

date (YYYY-MM-DD)

N

Date on which the order was shipped

AY

shipCarrier

varchar(20) (ex. USPS, FedEx, etc)

N

Carrier responsible for shipment

AZ

shipMethod

varchar(20)

N

Carrier's shipment method (ex. Express, 3-day Ground, etc)

BA

trackingNumber

varchar(20)

N

Order Tracking # assigned by the carrier

BB

isChargedback

Boolean('0' or '1')

N

Indicates that the specific transaction has been charged back by the card holder.

BC

chargebackTotal

Decimal (xx.xx format)

Y-if isChargedback

The amount of the chargeback.

BD

chargebackDate

Date (YYYY-MM-DD)

Y-if isChargedback

The date on which the chargeback was issued.

BE

chargebackReasonCode

varchar(10)

Y-if isChargedback

Card issuer's chargeback code.

BF

externalToken

varchar(50)

N

A token identifying the customer payment source at the 3rd party gateway. This is commonly used to run existing rebills when the full card numbers are unavailable and when gateway-supported. -note: if provided, cardNumber column may be masked with either x's or asterisks.

BG

quantity

integer

N

The quantity of the product.  If not provided or not greater than 0, then it will be set to 1.

BH

variantDetailId

integer

N

The Konnektive variantDetailId that indicates which variant of the product the transaction was for. (Found on the product page).  The variant must exist on the Konnektive product.

BI

password

varchar(30)

N

Membership password for a third-party site

BJ

companyName

varchar(50)

N

Customer's company

A

customerId

varchar(20)

Y

Your internal customer id for this customer.
This must match the customerId in the transactions file

B

dateCreated

datetime (YYYY-MM-DD HH:MM:SS)

Y

the date the note was taken

C

agentName

varchar(20)

N

Name of the individual customer service agent.
(Leave empty for system notes)

D

noteText

varchar(500)

Y

The note itself

A

customerId

varchar(20)

Y

Your internal customer id for this customer.
This must match the customerId in the transactions file

B

loginId

varchar(30)

N

loginId or username for a third-party site

C

password

varchar(30)

N

password for a third-party site

D

custom1

varchar(50)

N

standard custom field 1

E

custom2

varchar(50)

N

standard custom field 2

F

custom3

varchar(50)

N

standard custom field 3

G

custom4

varchar(50)

N

standard custom field 4

H

custom5

varchar(50)

N

standard custom field 5