Account Credit Card Payment Formats
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.
EIGEN
| Max Length | Content |
|---|---|
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 |
Edgil
| Record | Length | Field |
|---|---|---|
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) |
EdgCapture
| Record | Length | Field |
|---|---|---|
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) |
ICVerify (“Retail” or “MOTO”)
| Field | Sample Output |
|---|---|
“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 ... |
Paymentech Header Record (first record in each file)
| Col | Field | Length | Description |
|---|---|---|---|
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) |
Paymentech Detail Records (one for each payment/refund)
| Col | Field | Length | Description |
|---|---|---|---|
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) |
Paymentech Trailer Record (one trailer record after the last detail record)
| Col | Field | Length | Description |
|---|---|---|---|
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) |
POS-Partner 2000
| Field | Sample Output |
|---|---|
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 |
Skipjack
| Field | Sample Output |
|---|---|
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~||> |
TransFirst Transaction Central
| # | Name | Type | Valid Characters | Description |
|---|---|---|---|---|
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) |
| # | Name | Type | Valid Characters | Description |
|---|---|---|---|---|
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 |
| # | Name | Type | Valid Characters | Description |
|---|---|---|---|---|
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 |
viaWARP
| Record | Format | Value |
|---|---|---|
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 |
Virtual Terminal
| Field Name | Position | Length | Description |
|---|---|---|---|
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. |
VISANET
| Field | Sample Output |
|---|---|
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” |
American Express
| Field | Length | Position | Description |
|---|---|---|---|
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” |
Last updated
