T
his section discusses the Transaction Lookup func-tion which is a convenient way to inquire on transacfunc-tions in the X-Charge system. You can print a copy of a receipt or a transaction detail report for a selected transaction.To use this function:
1 From the X-Charge Main screen, click on the Lookup button.
2 You can select either a date range or a batch number to initiate the transaction search.
To look up a transaction by a date range:
Accept the date range displayed, click on the down ar-row button in the Date Range combo box and select a date range from the list, or simply change the Start and End dates by entering the dates (e.g., MM/DD/YYYY) or clicking on the down arrow button to select the date(s) from a pop-up calendar.
Date ranges in the list include Today (default), Yester-day, This Week, Last Week, This Month, Last Month, This Year (calendar), Last Year (calendar), and User De-fined. As you select a date range from the list, the Start and End dates fill in. If you select User Defined in the Date Range field, enter the desired Start and End dates.
To look up a specific merchant number, enter it in the Merchant # combo box or click on the down arrow but-ton and make a selection from the drop-down list that displays, then click on the Search button.
To look up a transaction by a batch number:
Click on the down arrow next to the field title Date Range, then select and click on Batch Number(s). The field name changes to Batch Number(s). Enter the batch numbers you want included in the search. For example, for batches 1, 3, and 5, enter 1,3,5. For all batches from 1 to 5 inclu-sive, enter 1-5.
To look up a specific merchant number, enter it in the Merchant # combo box or click on the down arrow button and make a selection from the drop-down list that dis-plays, then click on the Search button.
3 To look up a specific credit card number, enter it in the Account Number combo box or click on the down arrow button and make a selection from the drop-down list that displays, then click on the Search button.
4 To look up a specific amount, enter it in the Amount combo box or click on the down arrow button and make a selection from the drop-down list that displays, then click on the Search button.
5 To look up a specific transaction type, click on the down arrow button in the Transaction Type combo box and make a selection from the drop-down list that dis-plays, then click on the Search button. Transaction types in the list include CC Adjustment, CC Force, CC Override, CC Pre-Auth, CC Purchase, CC Return, CC Void, CH Veri-fication, DB Purchase, DB Return, and <ALL>.
6 To look up a specific clerk number, enter it in the Clerk combo box or click on the down arrow button and make a selection from the drop-down list that displays, then click on the Search button.
7 To look up a specific receipt number, enter it in the Re-ceipt # combo box or click on the down arrow button and make a selection from the drop-down list that displays, then click on the Search button.
8 To look up a specific approval code, enter it in the Ap-proval Code combo box or click on the down arrow but-ton and make a selection from the drop-down list that dis-plays, then click on the Search button.
9 You can sort the detail displayed in the search by click-ing on the down arrow button in the Sort Field combo
50
11 The transaction type, credit card number, credit card type, expiration date, result, result code, amount, batch total, item number, batch number, approval code, mode of entry, AVS, CVC/CVV2, receipt number, clerk ID, date, and time display (use the scroll bar at the bottom of the screen to view all of the data).
12 To print a receipt for a selected transaction, click on a transaction in the list to highlight it, then click on the Receipt button. A Receipt Preview window displays similar to the following:
Click on the printer icon on the toolbar to print the receipt, or click on the Close button to close the window.
13 Receipts can be printed for approved transactions only. For example, if you click on the Receipt button while a CH Verification type transaction is highlighted, this prompt will display:
SECTION 5
Click on the OK button, then select a valid transaction.
14 To view a detail report for the selected transaction, click on the Item Report button. The report contains the same information as is displayed in the grid for a single transaction in a window similar to the following:
box and selecting the field to sort by. If you select any-thing other than the default of <None>, the Sort Field #2 combo box activates for you to specify a secondary sort field. If you select anything in that field, the Sort Field
#3 combo box activates for you to specify a third sort.
10 Click on the Search button on the toolbar. The results display in the grid similar to the example shown below:
Click on the printer icon in the toolbar to print the report, or click on the Close button to close the window.
15 Click on the Clear button to reset the fields and begin a new lookup.
16 Click on the Exit button to exit and return to the X-Charge Main screen.
A
PPENDIXA - A
UTHORIZATIONA
CTIONC
ODESFollowing are the three-character action codes and verbiage which NDC eCOMMERCE returns to the POS device as part of the transaction response.
For approved credit card responses (code 000, 0NC, 0NE), NDC eCOMMERCE sends a six-character approval code in addition to the verbiage AP. The POS device should display this code as part of the approval message for the approved transaction.
Please note the following:
•
Code 0NC: NDC eCOMMERCE returns this code if the item was not captured on the host (NDC eCOMMERCE’s EDC system is down and item is an EDC card type).•
Code 0NE: NDC eCOMMERCE returns this code for all Authorization-Only approved credit card items. This is re-turned to EDC merchants only on a card type not set up for capture.•
For approved debit card responses (code 0P1), NDC eCOMMERCE does not return an approval code, only the ver-biage.•
For non-approved responses, NDC eCOMMERCE sends verbiage and the corresponding action code to indicate the condition.Note: Verbiage accompanying an action code may vary from this listing depending on issuer requirements.
Code Verbiage Description
00 0 A P Approved or Completed
Successfully
00 1 CALL AE Refer to American Express CALL DC Refer to Diners Club CALL DISCOVER Refer to Discover
CALL JB Refer to JBS
CALL ND Call your Visa/MasterCard Voice Authorization Center
CALL TC Refer to TeleCredit
CALL TK Refer to TeleCheck
CALL WC Refer to Worldcheck
CALL XXXXXXXXXX Call indicated number ISSUER UNAVAIL NDC eCOMMERCE cannot
contact issuing bank for authorization
002 CALL AE Touchtone capture, won’t roll to an operator
003 INVLD MERCH ID Invalid Merchant ID 004 PIC UP Authorization Declined 005 DECLINE Authorization Declined
0 0 6 REVERSED Requested transaction reversal was successful
007 DECLINE-CV2 FAIL Response for CVV2/CVC2 failure; declined
0 0 8 AP WITH ID Approved with positive ID;
host does not capture this transaction
012 INVLD SERV ID Service ID number is incorrect INVALID REQUEST Administrative message
contains a syntax error INVLD TRAN CODE Processing code entered is
incorrect; refer to valid processing code
013 INVLD AMOUNT Amount entered is invalid 014 INVLD ACCT Account number does not pass
issuer’s edit checks
INVLD CODE ACCT Valid account number matched with a transaction code for a different card type
INVLD PREFIX NDC eCOMMERCE’s user tables are set up incorrectly for this account
Code Verbiage Description
0 1 9 PLEASE RETRY NDC eCOMMERCE
GATEWAY requests a retry 054 INVLD EXP DATE Expiration date entered is
incorrect
055 PIN INVALID Incorrect PIN entered
52
Code Verbiage Description
0 P 0 TRAN TYPE INVLD Transaction not supported by EFT Network or card issuer 0 P 1 APPROVED Approved debit card transaction 0 P 2 DB UNAVAIL 02 NDC eCOMMERCE
GATEWAY is down 0 P 3 DB UNAVAIL 03 NDC eCOMMERCE
GATEWAYLink timed out 0 P 4 DB UNAVAIL 04 NDC eCOMMERCE
GATEWAY cannot contact EFT network or EFT Group ID is incorrect
0 P 5 UNAUTH USER Merchant is not set up for debit on NDC eCOMMERCE Merchant Master File 0 P 6 INVALID CARD Debit card not on issuer file 0 P 7 DB ISSUER UNAVAIL EFT network cannot contact
issuer
0 P 8 INVALID POS CARD Card is not eligible for POS 0 P 9 ACCT TYPE INVLD Type of account entered
cannot be accessed (checking, savings, etc.)
0PA INVALID PREFIX No sharing arrangement for this card
0PB INVALID FIID NDC eCOMMERCE
GATEWAY Financial Institution ID not set up 0S0 VERIFY XXXXXXXXX Match on SCAN file;
XXXXXXXXX is routing/
transit number on the negative file
0S1 INVALID LIC License or ID number entered during a check authorization transaction is incorrect
0S2 INVALID STATE CD State code entered is incorrect
0 T 1 EDC UNAVAILABLE EDC application down; try later
0 T 2 DB UNAVAIL 01 Debit application down; try later
0 T 3 SCAN UNAVAILABLE SCAN application is down;
t r y later
0XC DECLINED Error contacting processor 1 2 1 EXCEEDS MAX AMT Exceeds withdrawal amount
limit
1 2 3 EXCEEDS MAX USES Exceeds withdrawal frequency limit
Code Verbiage Description
058 UNAUTH TRANS Merchant not set up for transaction code used 075 MAX PIN RETRIES Maximum PIN number entry
attempts exceeded
094 AP DUPE Transaction entered is a duplicate 0N1 INV ACCT MATCH Account number entered
during a void or adjustment transaction does not match the account number stored in the host for that item
0N2 INV AMT MATCH Amount entered for a void or adjustment transaction does not match the amount stored in the host for that item
0N3 INV ITEM NUM Item number entered for a void or adjustment transaction is incorrect
0N4 ITEM VOIDED An adjustment or item review was ITEM REVERSED attempted on a transaction
previously voided or reversed 0N5 MUST BALANCE NOW Terminal has not been balanced
within time specified in the NDC eCOMMERCE Merchant Master File for this merchant
0N6 USE DUP THEN BAL Terminal has not been balanced within time specified in the NDC eCOMMERCE Merchant Master File for this merchant, but merchant is set up to perform extra transactions before balancing
0N7 NO DUP FOUND Override transaction is attempted on a non-duplicated transaction 0N8 INVALID DATA Format of the transaction is
incorrect
0NA NO TRANS FOUND Reversal transaction is attempted on a transaction that is not in the open batch on the host 0NC AP NOT CAPTURED Approved but not captured
(applies only to credit card transactions)
0NE AP AUTH-ONLY Approved, but this EDC merchant is not set up to capture this card type (applies only to credit card transactions)
0NF INV BANK Acquiring Bank ID entered is incorrect
APPENDIX A
Code Verbiage Description
000 OK Successful settlement - final block OK TEST Successful settlement with test card 002 Will contain Action Check verbiage field for detail record
and Verbiage for error data each detail record
submitted
003 INVLD MERCH ID Invalid Merchant ID 012 INVLD SERV ID Service ID number is incorrect
INVALID REQUEST Administrative message contains a syntax error
INVLD TRAN CODE Processing code entered is incorrect;
refer to valid processing code 013 INVLD AMOUNT Amount entered is invalid 014 INVLD ACCT Account number does not pass
issuer’s edit checks
INVLD CODE ACCT Valid account number matched with a transaction code for a different card type
INVLD PREFIX NDC eCOMMERCE’s user tables are set up incorrectly for this account
043 INV ACQ REF DATA Acquirer Reference Data did not pass NDC eCOMMERCE’s field definition edits as specified in the field descriptions
054 INVLD EXP DATE Expiration date entered is incorrect 095 INVALID BATCH Merchant is marked as inactive on
EDC
0N8 INVALID DATA Format of the transaction is incorrect
0N9 INV BATCH NBR Invalid batch number
Code Verbiage Description
0NB INV BAL/SETL Totals in POS device do not match host totals and there are no reversals, or POS totals do not agree with host totals and the reversals cannot account for the difference
0NF INV BANK Acquiring Bank ID entered is incorrect
0P5 UNAUTH USER Merchant is not set up for debit on NDC eCOMMERCE Merchant Master File
0RC VERIFY XXXX/XXXX Amount and item count do not match the totals in the host. The host reviews the reversed items in the batch and displays the item number(s) for all reversed items in the batch (designated by XXXX/XXXX), followed by the message INVALID BALANCE.
This message length is variable to accommodate the reversed item number(s)
0RD OK DB XXXX/XXXX Settlement is successful, but the amount and item count do not match the totals in the host. The host reviews the reversed items in the batch and displays item number(s) for all reversed items in the batch (designated by XXXX/XXXX), followed by the message NOT PROCESSED. This message length is variable to accommodate the reversed item number(s)
0 T 1 EDC UNAVAILABLE EDC application down; try later
A
PPENDIXB - S
ETTLEMENTA
CTIONC
ODESFollowing are the three-character action codes and verbiage which NDC eCOMMERCE returns to the POS device as part of the transaction response.
For successful balance/settlement responses (code 000), NDC eCOMMERCE sends a nine-digit batch control number.
The POS device should display this number as part of the response.
NDC eCOMMERCE returns Code 0RD (Balance/Settlement) when the POS device’s debit totals do not agree with the host totals due to debit reversals. NDC eCOMMERCE sends a nine-digit batch control number and the verbiage includes the host debit item numbers which were reversed at NDC eCOMMERCE at the time of authorization. These debit items are not included as part of the POS device’s EDC batch. NDC eCOMMERCE’s customer and the merchant must take addi-tional action if debit item(s) were captured by the POS device and reversed at the host. NDC eCOMMERCE’s customer will have to process debit adjustment paperwork on behalf of the merchant to correct this situation.
For Code 0NB (out-of-balance settlement), NDC eCOMMERCE returns the specific items and amounts that do not agree with the host.
54
State Alpha Code
Alabama AL 38
Alaska AK 32
Arizona AZ 09
Arkansas AR 05
California CA 06
Colorado CO 07
Connecticut CT 08
Delaware DE 04
District of Columbia DC 51
Florida FL 30
Georgia GA 10
Hawaii HI 11
Idaho ID 12
Illinois IL 13
Indiana IN 14
Iowa IA 15
Kansas KS 16
Kentucky KY 17
Louisiana LA 18
Maine ME 19
Maryland MD 20
Massachusetts MA 21
Michigan MI 22
Minnesota MN 23
Mississippi MS 24
Missouri MO 25
Montana MT 26
Nebraska NE 27
Nevada NV 28
New Hampshire NH 29
New Jersey NJ 02
New Mexico NM 31
New York NY 03
North Carolina NC 33
State Alpha Code
North Dakota ND 34
Ohio OH 35
Oklahoma OK 36
Oregon OR 37
Pennsylvania PA 01
Rhode Island RI 39
South Carolina SC 40
South Dakota SD 41
Tennessee TN 42
Texas TX 43
Utah UT 44
Vermont VT 45
Virginia VA 46
Washington WA 47
West Virginia WV 48
Wisconsin WI 49
Wyoming WY 50
Alberta AB 52
British Columbia BC 53
Manitoba MB 54
New Brunswick NB 55
Newfoundland NF 56
Northwest Territories NT 57
Nova Scotia NS 58
Ontario ON 59
Prince Edward Island PE 60
Quebec PQ 61
Saskatchewan SK 62
Yukon Territory YT 63
Puerto Rico PR 69
Out of Country OC 70
Social Security # SS 71
Virgin Islands VI 77
MICR Number MR 99
A
PPENDIXC - S
TATE/P
ROVINCEC
ODES56
A
PPENDIXD - X-C
HARGEE
RRORC
ODESFollowing are the three-character error codes and verbiage which are specific to the modem and other internal problems.
Code Description Code Description
H01 Error initializing modem. Check modem and port H02 Error sending data through modem
H03 Error in routing data H04 Invalid parameter passed H05 Invalid sharing right for file H06 Invalid file right given
H07 Error opening transaction or INI file
H08 Error dialing host. Number may be busy. Try again later H09 Error in response message from host
H16 Error resetting modem settings H17 Error writing record to transaction file
H18 Error allocating memory. Probably insufficient memory H19 Error opening port. Check port settings in INI
H20 Port already open. May be in use by some other application H21 Invalid phone number in INI
H22 Busy wait signal H23 No dial tone from modem
H24 ENQ not received from host H25 EOT from host when sent ENQ H32 Connection timed out H33 Could not detect a modem H34 Carrier signal lost H35 No response from host
H36 Busy
H37 No carrier detected H38 Error in modem H39 Error connecting host H40 Unknown error
H41 No dial tone or All routes bad H48 HDACom server not running
H49 Error creating server thread. May not be enough memory H51 Invalid ChType. ChType should be of 1 to 8
58
A
PPENDIXE - G
IFTC
ARDE
RRORC
ODESCode Success/Fail Response Message Description
0007 Fail Field edit error(s) Indicates one or more of the following edit
failures. Specific field errors are noted by an “E”
in the associated field flag.
0008 Fail Unrecognized client, store, or terminal
Used to indicate that the specified client, store or terminal is not supported
0011 Fail Error in processing - try again Used to report a general processing error 0014 Fail Account number not found Used to define that the input account is either
not in the system or is not yet activated or is not a legal value
0015 Fail Illegal Account number Used to define that the input account is either not in the system or is not yet activated or is not a legal value
0019 Fail Unrecognized store Used to indicate that the specified store is not supported
0025 Fail Unrecognized terminal Used to indicate that the specified terminal is not supported
0041 Fail Amount out of limit Used to specify that the amount given is
outside defined limits
0042 Fail Amount incorrect Used to define the specified amount for a
pre-denominated account is incorrect or if no additional balance then redeem too much 0043 Fail Incorrect transaction Used to indicate that the transaction can not be
voided
0044 Fail Can not Void Specified transaction can no longer be voided
0045 Success Approved Used to signify that the previous transaction
was successfully processed
0046 Success Approved with additional balance
Used to signify that the previous transaction approved with add balance
0047 Success Approved with at least one of the multiple account number’s rejected Used to signify that the previous transaction approved but at least one (but not all) account number was not accepted
Datamark can return the following response codes which will be stored in the transaction file and can be viewed in the Gift Card Transaction Detail Report. These response codes are not returned in the answer file. Response codes 0045, 0046, 0047, and 0048 are returned as a successful transaction result. All other transactions are returned as an unsuccessful transaction result.
60
0048 Success Approved multiple issuance Used to signify that the multiple issuance was accepted but actual issuance to the accounts is being done as a background operation with results to be reported on batch closeout reply
0049 Fail Duplicate transmission A duplicate record was received
0050 Fail Illegal Redemption Method If Specified Redemption method is not recognized
APPENDIX E