Label | ID | Type | UI Workbook | SuiteScript / SuiteTalk REST Web Services | Connect |
---|---|---|---|---|---|
Amount | amount | currency | Yes | Yes | Yes |
Auth. Code | authcode | text | Yes | Yes | Yes |
AVS Street Match | avsstreetmatch | select | Yes | Yes | Yes |
AVS Zip Match | avszipmatch | select | Yes | Yes | Yes |
Cancelable | cancelable | checkbox | Yes | Yes | Yes |
Cardholder Name | cardnameoncard | text | Yes | Yes | No |
Card Street | cardstreet | text | Yes | Yes | No |
Card Street | cardtokensubcard | text | Yes | Yes | Yes |
Card Zip Code | cardzipcode | text | Yes | Yes | No |
CSC Match | cscmatch | select | Yes | Yes | Yes |
Date | eventdate | datetime | Yes | Yes | Yes |
Details | statusreasondetails | text | Yes | Yes | Yes |
Expiration Date | cardtokensubcardexpdate | mmyydate | Yes | Yes | Yes |
Expires (MM/YYYY) | cardexpirationdate | mmyydate | Yes | Yes | No |
External ID | externalid | text | Yes | Yes | Yes |
Handling Mode | handlingmode | select | Yes | Yes | Yes |
Initial Use Reference | initialusereference | text | Yes | Yes | Yes |
Instrument Preserved on File | preservedonfileinstrument | checkbox | Yes | Yes | Yes |
Internal ID | id | integer | Yes | Yes | Yes |
Is Initial Use | isinitialuse | checkbox | Yes | Yes | Yes |
ISO Date | isodate | text | Yes | Yes | Yes |
Last event | lastevent | checkbox | Yes | Yes | Yes |
Mask | paymentinstrumentmask | text | Yes | Yes | No |
Masked Card | maskedcard | text | Yes | Yes | No |
Merchant Print Block | merchantprintblock | textarea | Yes | Yes | Yes |
Mit Purpose | mitpurpose | select | Yes | Yes | Yes |
New Initial Use Reference | newinitialusereference | text | Yes | Yes | Yes |
P/N Ref. | pnrefnum | text | Yes | Yes | Yes |
Payment Initiator | paymentinitiator | select | Yes | Yes | Yes |
Payment Operation | paymentoperation | select | Yes | Yes | Yes |
Payment processing profile | paymentprocessingprofile | select | Yes | Yes | Yes |
Payment Request ID | paymentrequestid | text | Yes | Yes | Yes |
Payment Status | paymentstatus | select | Yes | Yes | Yes |
Processed with Adjusted Expiration Date | isadjustedexpirationdate | checkbox | Yes | Yes | Yes |
Raw Request | request | textarea | Yes | Yes | Yes |
Raw Response | response | textarea | Yes | Yes | Yes |
Reason | statusreason | select | Yes | Yes | Yes |
Recurring Payment | isrecurringpayment | checkbox | Yes | Yes | Yes |
Redirect URL | redirecturl | text | Yes | Yes | Yes |
Shopper Print Block | shopperprintblock | textarea | Yes | Yes | Yes |
Signature Required | signaturerequired | checkbox | Yes | Yes | Yes |
State | paymentinstrumentstate | select | Yes | Yes | Yes |
Test Mode | testmode | checkbox | Yes | Yes | Yes |
Token Expiration Date | cardtokenexpirationdate | mmyydate | Yes | Yes | Yes |
Token Expiration Date | tokenexpirationdate | mmyydate | Yes | Yes | Yes |
Transaction | doc | select | Yes | Yes | Yes |
Type | paymentinstrumenttype | select | Yes | Yes | Yes |
Join | Target Record | UI Workbook | SuiteScript / SuiteTalk REST Web Services | Connect |
---|---|---|---|---|
Payment Event to Match Code (verificationMatchCode.key) | payment event (paymentevent, paymentevent.avsstreetmatch) | Yes | Yes | Yes |
Payment Event to Match Code (verificationMatchCode.key) | payment event (paymentevent, paymentevent.avszipmatch) | Yes | Yes | Yes |
Payment Event to Match Code (verificationMatchCode.key) | payment event (paymentevent, paymentevent.cscmatch) | Yes | Yes | Yes |
Payment Event to Transaction (transaction.id) | payment event (paymentevent, paymentevent.doc) | No | Yes | Yes |
Payment Event to Handling Mode (paymentHandlingMode.key) | payment event (paymentevent, paymentevent.handlingmode) | Yes | Yes | Yes |
Payment Event to Mit Purpose (mitPurpose.key) | payment event (paymentevent, paymentevent.mitpurpose) | Yes | Yes | Yes |
Payment Event to Payment Initiator (paymentInitiator.key) | payment event (paymentevent, paymentevent.paymentinitiator) | Yes | Yes | Yes |
Payment Event to Type (paymentInstrumentStateType.key) | payment event (paymentevent, paymentevent.paymentinstrumentstate) | Yes | Yes | Yes |
Payment Event to Type (paymentInstrumentType.key) | payment event (paymentevent, paymentevent.paymentinstrumenttype) | Yes | Yes | Yes |
Payment Event to Type (paymentOperation.key) | payment event (paymentevent, paymentevent.paymentoperation) | Yes | Yes | Yes |
Payment Event to Payment processing profile (paymentProcessingProfile.id) | payment event (paymentevent, paymentevent.paymentprocessingprofile) | No | Yes | Yes |
Payment Event to Payment Status (paymentStatus.key) | payment event (paymentevent, paymentevent.paymentstatus) | Yes | Yes | Yes |
Payment Event to Payment Status Reason (paymentStatusReason.key) | payment event (paymentevent, paymentevent.statusreason) | Yes | Yes | Yes |