Note: All of the interfaces described in this section require a separate license fee to use. Contact the Newscycle Support Center for more information.
Location: /dti/exchange/cm/secure.
File types: Account credit card payments can be exported in the following formats:
Edgil and EdgCapture—Edgil and EdgCapture files are fixed format. The file name will be “ed[batch].[date][sequence#]”, where [date] is the batch date in DDMMYYYY format, and [sequence#] is the number of times the Edgil export has been run on that date.
EIGEN—The EIGEN file is tab delimited. The file name will be “ei[batch]”, where [batch] is the name of the account payment batch.
ICVerify—The ICVerify file is comma-delimited with fields in double quotes. The file name will be “ic[batch]”.
Paymentech—The Paymentech file is comma-delimited. If a field needs to contain a comma as data, it must be coded as <COMMA>. The use of new lines or double quotes is not allowed in any field.
The file name will be “pt[BatchID].csv” for payments or “ptref[BatchID].csv” for batch refunds. In addition, if the Business Rules— Should customer service payments create separate batches by publication? and Should credit card refunds create separate export files by publication?, are set to “yes”, the publication will also be appended to the file name as follows: “pt[BatchID][Publication].csv” or “ptref[BatchID][Publication].csv”.
Customer Service refunds are exported one at a time and not in a batch. The file name for Customer Service refunds will be “ptref[SubscriptionID]-[unique number].csv”.
POS-Partner 2000—The POS-Partner 2000 file is comma-delimited, with no quotes around each field. There are no batch or file header or trailer records. POS-partner 2000 is an upgrade of the POS-partner 2.24 file format (called VISANET in the system), so there are similarities between the two formats. The file name will be “pos[batch name].txt”.
Skipjack—The Skipjack file is variable length, with each line followed by a carriage return and line feed. The file name will be “sj[batch ID]”
TransFirst Transaction Central—The export file name is as follows: <YY><MM><DD><Sequence Number>.CCK, where Sequence Number = 01-999. For example, an entire file name might be 10052101.CCK. The export file is comma-delimited with quotation marks around the text.
Note:
Typically, credit card export files can be split out by publication via Business Rules. However, this is not possible with TransFirst Transaction Central due to the file-naming requirements.
viaWARP—The viaWARP file is comma-delimited, with fields in double quotes. The file name will be “vw[BatchID]”.
Virtual Terminal—The Virtual Terminal file is comma-delimited with no quotes around the fields with each transaction on its own line. There are no batch or file header or trailer records.
The file name will be “vt[BatchID].txt” for payments or “vtref[BatchID].txt” for batch refunds. In addition, if the Business Rules— Should customer service payments create separate batches by publication? and Should credit card refunds create separate export files by publication?, are set to “yes”, the publication will also be appended to the file name as follows: “vt[BatchID][Publication].txt” or “vtref[BatchID][Publication].txt”.
VISANET—The VISANET format is comma-delimited, with fields in double quotes. The file name will be “vs[batch name].txt”.
American Express—Credit card payments may be exported to a separate American Express file (based on Business Rules), which is fixed length. The American Express file will be named “ae[batch]”, where [batch] is the name of the account payment batch.
Business Rules govern which format is used.
16
Term ID Group (from Business Rules)
2
“12” (Transaction Code)
19
Credit Card Number
4
Expire Date (format yymm)
9
Payment Amount (no decimal, last two characters are cents)
8
Approval Code (blank)
40
Account ID or Subscriber ID
Control Record
1
H (Control Record begins)
8
System date, format DDMMYYYY
1
Merchant ID (from Business Rules)
1
Filler (spaces)
2
Sequence number (number of Edgil exports so far on this date)
1
OEP ID (from Business Rules)
1
1 (held transaction option)
65
Filler (spaces)
Detail Record
1
1 (Detail Record begins)
4
Transaction sequence (the order of the payment in the file)
2
Transaction code (“SA”)
1
OEP ID (from Business Rules)
1
Merchant ID (from Business Rules)
8
System date, format DDMMYYYY
2
Sequence number (from the Control record)
4
Transaction sequence (the order of the payment in the file)
2
Filler (spaces)
24
Credit card number
6
Credit card expiration date, format MMYY plus 2 spaces
7
Payment amount, including cents, format 9999999
8
Authorization code (spaces)
2
Card holder state (spaces)
8
Filler (spaces)
Detail Record 2
1
2 (Detail Record 2 begins)
4
Transaction sequence (the order of the payment in the file)
19
Account’s or subscriber’s first name plus last name
1
Octal 35 (GS-1)
19
Account’s or subscriber’s address, line 1
1
Octal 35 (GS-2)
20
Account’s or subscriber’s address, line 2
9
Account’s or subscriber’s Zip code plus extension
6
Filler (spaces)
Detail Record 3
1
3 (Detail Record 3 begins)
4
Transaction sequence (the order of the payment in the file)
15
Account’s or subscriber’s primary phone number, format (999)999-9999, plus 2 spaces
15
Account or subscriber number
12
Account’s or subscriber’s city
10
Account or subscriber number
4
ID of user who entered payments
5
Payment batch ID
4
Payment sequence (the order of the payment in the batch)
10
Filler (spaces)
Trailer Record
1
T (Trailer Record begins)
4
Total number of detail records in batch (detail 1 + 2 + 3)
9
Total amount of all payments in batch
66
Filler (spaces)
Control Record
1
H (Control record begins)
8
System date, format DDMMYYYY
1
Merchant ID (from Business Rules)
1
Filler (space)
2
Sequence number (number of EdgCapture exports so far on this date)
1
OEP ID (from Business Rules)
1
2 (held transaction option)
65
Filler (spaces)
Detail Record
1
1 (Detail record begins)
4
Transaction sequence (the order of the payment in the file)
2
Transaction code (“SA” sale for payments and “CR” credit for refunds)
1
OEP ID (from Business Rules)
1
Merchant ID (from Business Rules)
8
System date, format DDMMYYYY
2
Sequence number (from the Control record)
4
Transaction sequence (the order of the payment in the file)
2
Filler (spaces)
24
Subscriber’s credit card or bank account number
6
Credit card expiration date, format MMYY plus 2 spaces
7
Payment amount, including cents, format 9999999
8
Authorization code (spaces)
2
Card holder state (spaces)
8
Filler (spaces)
Detail Record 2
1
2 (Detail Record 2 begins)
4
Transaction sequence (the order of the payment in the file)
19
Subscriber’s first name plus last name
1
ASCII 29 (GS-1)
19
Subscriber’s address, line 1
1
ASCII 29 (GS-2)
20
Subscriber’s address, line 2
9
Subscriber’s ZIP Code plus ZIP extension
6
Filler (spaces)
Detail Record 3
1
3 (Detail Record 3 begins)
4
Transaction sequence (the order of the payment in the file)
15
Subscriber’s primary phone number, format 9999999999, plus 5 spaces
15
Subscription account number
12
Subscriber’s city
10
Subscription account number
6
ID of user who entered payments
10
Subscription payment batch ID
7
Payment sequence (the order of the payment in the batch)
Detail Record 4
1
4 (Detail Record 4 begins)
4
Transaction sequence (the order of the payment in the file)
75
Filler (spaces)
Detail Record 5
1
5 (Detail Record 5 begins)
4
Transaction sequence (the order of the payment in the file)
9
Subscriber’s bank routing number
1
B (direct debit) if auto renew payment, otherwise A (check draft)
1
A if client type entered with payment is “personal” or blank, B if client type is “business”
64
Filler (spaces)
Trailer Record
1
T (Trailer Record begins)
4
Total number of detail records in batch (detail 1 + 2 + 3 + 4 + 5)
9
Total amount of all payments in batch
66
Filler (spaces)
“C1” (beginning of payment batch record)
“C1”
User ID of operator who processed payments
“tomk”
Account or subscription ID
“4726A”
Credit card number
“57483773”
Expiration date of credit card (YYMM or MMYY format, depending on Business Rules)
“9901”
Payment amount including tip (use decimal point—e.g. 2.33)
“50.09”
MOTO only: Placeholder for “recurring” yes/no flag. Currently blank.
blank
Account or subscriber Zip code
“55443”
Account or subscriber house number (0 if house number is blank)
“412”
14 blank fields
““,””,””,””, etc ...
——————————————————————————————
——————————
“ST” (beginning of close batch record)
“ST”
21 blank fields
““,””,””,””, etc ...
1
Line Type
1
Value = H (Header record). (Required, Alphanumeric)
2
Line Number
N/A
Value = 1 (Row number). Will always be 1 for the Header record. (Required, Number)
3
Format Version
5
Stored in Business Rules (Subscriber Payments and Accounts Payments sections). (Required, Alphanumeric)
4
User Name
32
Must be all upper case. Stored in Business Rules (Subscriber Payments and Account Payments sections). (Required, Alphanumeric)
5
File Name
32
Must match the name of the uploaded file, minus the file extension. Must be all lower case. For example, if the uploaded file is “ptBATCH.csv”, the File Name field would be “ptbatch”. (Required, Alphanumeric)
6
Detail Record Total
6
Total of all lines with Line Type = D. The “Line Number” of the final D record should contain the same value as this field. (Required, Number)
1
Line Type
1
Value = D (Detail record). (Required, Alphanumeric)
2
Line Number
6
The first detail record will always be 1 and increment by 1 for each subsequent record. The final D record line number must equal the Detail Record Total in the Header record. (Required, Number)
3
Line Subset Type
Reserved for future use.
4
Line Subset Number
Reserved for future use.
5
Transaction Type
3
Value = O (the letter O, not zero) for New Order. (Required, Alphanumeric)
6
Transaction New Order Transaction Type
2
Value for payments = AC (Authorization and mark for capture). Value for refunds = R (Refund Request). (Required, Alphanumeric)
7
Order Number
22
Subscription ID for subscriber payments/refunds, Account ID for account payments. (Required, Alphanumeric)
8
Industry Type
2
Value = MO (Mail Order Transaction). (Required, Alphanumeric)
9
Transaction Amount
12
Payment/refund amount. Store “$5.00” as “500”. (Required, Number)
10
Credit Card Number
19
Credit Card Number. Although this field can be left blank for ECP payments, since ECP payments are not exported, this field is required in the DTI batch file. (Conditional, Number)
11
Card Type/Brand
2
Not used. (Conditional, Number)
12
Card Expiration Date
4
Card Expiration Date. Format = MMYY. Since this may be left blank only for ECP payments, it is required in the DTI batch file. (Conditional, Number)
13
N/A
N/A
N/A
14
Switch – Solo Issue Number
2
Not used. (Conditional, Number)
15
Switch – Solo Card Start Date
4
Not used. (Conditional, Number)
16
ECP Bank Routing and Transit Number
9
Not used. (Conditional, Number)
17
ECP Customer DDA Account Number
17
Not used. (Conditional, Alphanumeric)
18
ECP Bank Account Deposit Type
1
Not used. (Conditional, Alphanumeric)
19
ECP Authorization Method
1
Not used. (Conditional, Alphanumeric)
20
ECP Payment Delivery Method
1
Not used. (Conditional, Alphanumeric)
21
Cardholder Billing Address Zip Code
10
Subscriber or account’s Zip code. Format = 99999 or 99999-9999. (Optional, Alphanumeric)
22
Cardholder Billing Address Line 1
30
Subscriber or account’s first address line. (Optional, Alphanumeric)
23
Cardholder Billing Address Line 2
30
Subscriber or account’s second address line. (Optional, Alphanumeric)
24
Cardholder Billing City
20
Subscriber or account’s city. (Optional, Alphanumeric)
25
Cardholder Billing State
2
Subscriber or account’s state. (Optional, Alphanumeric)
26
Cardholder Billing Name
30
Subscriber or account’s first name, middle initial, last name, and name suffix (“John P Smith Jr”). (Optional, Alphanumeric)
27
Cardholder Billing Address Country Code
2
Subscriber or account’s country. “US” for United States, “CA” for Canada, “GB” for Great Britain, “UK” for United Kingdom, Blank for all other countries. (Optional, Alphanumeric)
28
Use Profile Customer Reference Number
22
Not used. (Conditional, Alphanumeric)
29
Profile Order From Indicator
1
Not used. (Conditional, Alphanumeric)
30
Profile Customer Reference Number
22
Not used. (Conditional, Alphanumeric)
31
Profile Order Override Indicator
2
Not used. (Conditional, Alphanumeric)
32
N/A
N/A
N/A
33
N/A
N/A
N/A
34
Prior Authorization Code
6
Not used. (Optional, Alphanumeric)
35
Comments
64
Payment or refund’s transaction number. (Optional, Number)
36
Shipping Tracking Reference Number
40
Not used. (Optional, Alphanumeric)
37
Tax Indicator
1
“0” for all account payments and subscriber refunds. “1” for subscriber payments that have a non-zero tax amount. “2” for subscriber payments that have a zero tax amount. Newscycle does not store tax data for account payments or subscriber refunds, so this field will be “0” for all account payments and subscriber refunds. Tax data are available for subscriber payments. (Conditional, Number)
38
Tax Amount
12
“0” for all account payments and subscriber refunds. Newscycle does not store tax data for account payments or subscriber refunds, so this field will be “0” for all account payments and subscriber refunds. Tax data are available for subscriber payments. (Conditional, Number)
39
Customer Purchase Order Number
17
Blank for account payments and subscriber refunds. For subscriber payments, store the PurchaseNumber field from the Subscription table. Newscycle does not have a purchase order number associated with accounts. For subscribers, a purchase order number can be entered with a start or a billing change, and it is stored in the Subscription record. (Conditional, Alphanumeric)
40
Shipping to: Zip Code
10
Not used. (Conditional, Alphanumeric)
41
Ship to: Name
30
Not used. (Conditional, Alphanumeric)
42
Ship to: Address Line 1
30
Not used. (Conditional, Alphanumeric)
43
Ship to: Address Line 2
30
Not used. (Conditional, Alphanumeric)
44
Ship to: City
20
Not used. (Conditional, Alphanumeric)
45
Ship to: State
2
Not used. (Conditional, Alphanumeric)
46
Amex Purchasing Card Data Addendum #1
40
Not used. (Conditional, Alphanumeric)
47
Amex Purchasing Card Data Addendum #2
40
Not used. (Conditional, Alphanumeric)
48
Amex Purchasing Card Data Addendum #3
40
Not used. (Conditional, Alphanumeric)
49
Amex Purchasing Card Data Addendum #4
40
Not used. (Conditional, Alphanumeric)
50
N/A
N/A
N/A
51
Trace Number for Retry Logic
16
Payment or refund’s transaction number. Unique identifier for this transaction that tells Paymentech not to process the transaction again if it appears in a subsequent file. (Optional, Number)
52
Soft Descriptor Merchant Name
25
Not used. (Conditional, Alphanumeric)
53
Soft Descriptor Product Description
18
Not used. (Conditional, Alphanumeric)
54
Soft Descriptor Merchant City
13
Not used. (Optional, Alphanumeric)
55
Soft Descriptor Merchant Phone
12
Not used. (Conditional, Alphanumeric)
56
Soft Descriptor Merchant Email
13
Not used. (Conditional, Alphanumeric)
57
Soft Description Merchant URL
13
Not used. (Conditional, Alphanumeric)
58
Recurring Indicator
2
Not used. (Conditional, Alphanumeric)
59
European Direct Debit Bank Sort Code
10
Not used. (Conditional, Alphanumeric)
60
European Direct Debit Country Code
2
Not used. (Conditional, Alphanumeric)
61
European Direct Debit RIB
2
Not used. (Optional, Alphanumeric)
1
Line Type
1
Value = T (Trailer Record). (Required, Alphanumeric)
2
Line Number
6
Value = 1 (the row number). This will always be 1 for the trailer record. (Required, Number)
V Number (from Business Rules)
12345678
Credit Card Account Number
4.8E+15
Expiration Date (mmyy)
807
Transaction Amount
36
Transaction Type
“Pending Authorization” for payments; “Credit” for refunds
Billing Address 1 (account house number)
377
Billing Zip code (account Zip code)
55107
Card Not Present
N
Ship Date (mm/dd/yy) (payment date)
08/30/06
Invoice Number (batch name and account ID, or batch name and subscriber ID)
AR00784 1230002 or CS06083074 1230002
Name
sjname=<firstname+lastname>&
Email Address
email=<occupant email address>& If no occupant email address exists, the value will be “email=none@skipjack.com&”
StreetAddress
streetaddress=<housenumber>& If no house number exists, the value will be “streetaddress=none&”
City
city=<city>&
State
state=<state>&
Zip Code
zipcode=<Zip code>&
Credit Card Account Number
accountnumber=<credit card number>&
Credit Card Expiration Month
month=<month credit card expires>&
Credit Card Expiration Year
year=<year credit card expires>&
Amount of Transaction
Transactionamount=<total amount of payment>& This amount includes any subscription amount, tips and subscriber payment adjustments associated with the payment. Must use a decimal with the amount.
Ship to phone number
shiptophone=<area code+phone number>& If no phone exists, the value will be “shiptophone=none&”
Order Number
ordernumber=<account ID>&
Transaction ID
transactionid=<CashTransaction.TranNumber>&
Application Name
App=CM&
Orderstring
orderstring=<itemnum1~itemdesc1~1~0.00~N~||>
1
Description
X(10)
Alphanumeric (a-z, A-Z, 0-9) . # , ’ / ( ) - and Space
Required for ACH and appears on bank statements. “cc” for credit card payments and refunds; otherwise, the bank description.
2
Type
X(2)
Alpha (CC, CK, SA)
CC (credit card), CK (checking account), or SA (savings account)
3
Trans Code
9(2)
0-9
00 (debit credit card), 01 (credit card), 27 (debit checking), 37 (debit savings)
4
ABA Expire
9(4/9)
0-9
Expire date CC (MMYY) / ABA Routing No - checking or savings
5
Account No
9(17)
0-9
Account number (credit card, checking, or savings)
6
Account Name
X(30)
Alphanumeric (a-z, A-Z, 0-9) and Space
Name on account (credit card, checking or savings). Note: Do not include commas.
7
Ref ID
X(50)
Alphanumeric (a-z, A-Z, 0-9) . = [ # : _ * / @ ; \ - , ’ / ] - and Space
User’s unique reference ID (subscription ID for subscription transactions; account ID for account transactions).
8
Amount
Currency (8)
Numeric (0-9) and .
Transaction amount with decimal point (no double quotes)
9
Address
X(30)
Alphanumeric (a-z, A-Z, 0-9) . # , ‘ / ( ) - and Space
Street address of account holder AVS (Address Verification System)
10
Zip Code
9(10)
0-9
Zip code of account holder (no dashes) - AVS
11
SECC Code
X(3)
Alpha PPD, CCD, WEB, TEL
NACHA SECC code indicating the type of transaction (e.g., PPD, CCD, WEB, TEL)
12
PO Number
X(16)
Alphanumeric (a-z, A-Z, 0-9)
Purchase order number (required for Card Not Present transactions (MOPO, E-Commerce) and Corporate Business & Purchase Card transactions
13
Tax Amount
Currency (8)
Numeric (0-9) and .
Sales Tax Amount (with decimal point, enclosed within double quotes)
14
Tax Indicator
9(1)
Numeric (0-2)
0 (Non Taxable), 1 (Taxable), or 2 (Tax Exempt)
15
Company Name
X(16)
Alphanumeric (a-z, A-Z, 0-9)
Merchant name will be used if field is omitted. Required for ACH; appears on bank statement
Card Number
9999999999999999 (16 dig.)
Credit card number
Expiration Date
MM/YY
Credit card expiration date
Amount
9999999999.99 (10.2 dig.)
Payment amount
Transaction Type
X(9)
Value=”SALE” for a single payment, “REFUND” for a refund, or “RECURRING” for a recurring payment.
Street Address
X(20)
Account or subscriber’s street address
Zip Code
X(9)
Account or subscriber’s Zip + Zip extension
Customer Code
X(17)
Account ID or Subscription ID
Sales Tax
9999999999 (10 dig.)
Blank
Invoice Number
X(25)
Blank
CVV2 Indicator
9
CVV2Indicator=<9> Value=”1” if CVV2 is present Value=”0” if CVV2 is not present
CVV2 Value
9999
CVV2Value=<9999> CVV2 value, if available; otherwise blank.
Approval Code
X(6)
Blank
User Defined Field 0
newspaper defined
Blank
User Defined Field 1
newspaper defined
Blank
User Defined Field 2
newspaper defined
Blank
User Defined Field 3
newspaper defined
newspaper defined
User Defined Field 4
newspaper defined
newspaper defined
User Defined Field 5
newspaper defined
newspaper defined
User Defined Field 6
newspaper defined
newspaper defined
User Defined Field 7
newspaper defined
newspaper defined
User Defined Field 8
newspaper defined
newspaper defined
User Defined Field 9
newspaper defined
Current date in MMYY format
Transaction Type
1
x (1)
The desired transaction type. Valid values: S or 0 = Sale C or 1 = Credit This is a required field.
Credit Card Account Number
2
x (16)
The credit card account number. This is a required field.
Expiration Date
3
4 (MMYY)
The credit card’s expiration date in MMYY format. This is a required field. Example: 1009
Transaction Amount
4
9 (10.2)
Amount of payment or refund. This is a required field.
Invoice Number
5
x (20)
Batch ID and subscriber or account ID. This is a required field.
Billing Address
6
x (50)
This is the cardholder’s street address. First line of street address (up to 50 characters). This is a required field.
Billing Zip
7
x (5)
This is the cardholder’s Zip code. This is a required field.
Customer ID
8
x (20)
This is an optional field.
Customer Email
9
x (50)
This is an optional field.
E/C Indicator
10
x (2)
EC, MO This is an optional field.
Discretionary Transaction Fields 1 – 6
Nov-16
x (30)
These are optional fields.
Comment
17
x (50)
This is an optional field.
First Name
18
x (50)
Subscriber’s full name, such as “John Q Smith Jr”.
Last Name
19
x (50)
The cardholder’s last name. This is an optional field.
Billing Address Line 2
20
x (50)
Second line of the cardholder’s street address. This is an optional field.
Billing City
21
x (30)
This is the cardholder’s city. This is an optional field.
Billing State
22
x (2)
This is the cardholder’s state. This is an optional field.
Shipping Address
23
x (50)
This is the cardholder’s shipping street address. This is an optional field.
Shipping Address Line 2
24
x (50)
Second line of the cardholder’s shipping street address. This is an optional field.
Shipping City
25
x (30)
This is the cardholder’s shipping city. This is an optional field.
Shipping State
26
x (2)
This is the cardholder’s shipping state. This is an optional field.
Shipping Zip
27
9 (5)
This is the cardholder’s shipping Zip code. This is an optional field.
Tax
28
9 (10.2)
Must be within the following range.1-22% X the sale amount of the transaction, per Visa rules. A value of 0.00 will cause any corporate cards that come through to downgrade, causing the merchant to pay a higher processing fee. This is an optional field.
Customer Code/PO#
29
x (17)
The cardholder’s customer code for a commercial card transaction. This is an optional field.
Credit Card Account Number
“444444444”
Expire Date (mmyy)
“0802”
Merchant ID (from Business Rules)
“975463102”
Transaction Amount (including tip and cash payment adjustments)
“36.00”
Transaction Status
“Pending Authorization” for payments; “Credit” for refunds.
Cardholder ID (account house number and ZIP)
“377 55107”
Cardholder ID Code (N)
“N”
Transaction Date (mm/dd/yy)
“08/02/98”
Mail Order Transaction ID (1)
“1”
Purchase ID (batch name, record number of payment in batch, and subscriber ID)
“080202 17 123002”
Purchase ID Code (0)
“0”
Total Amount (same as Transaction Amount)
“36.00”
User Comments (CIRC)
“CIRC”
Record type
3
01-Mar
“CRQ”
Originator Reference Number
7
04-Oct
Account ID or Subscription ID
Unit Separator
1
11
“/”
Accounting System Code
1
12
“0”
Transaction Type
2
13-14
“05”
Merchant ID
10
15-24
The merchant ID defined in Business Rules
Unit Separator
1
25
“/”
Condition Code
1
26
“0”
App Code
1
27
“2”
Card Issue Code
2
28-29
“AX”
Account Information
15
30-44
The account’s or subscriber’s credit card number
Unit Separator
1
45
“/”
Expire Date
4
46-49
The credit card expiration date, format “mmyy”
Unit Separator
1
50
“/”
Authorization Amount
8
51-58
Account payment including tip, or subscriber payment including tip and cash payment adjustment. Last two positions are for ¢
Currency Code
3
59-61
“USD”