ARRefundCreditCard Table

Back to list of tables.

Column	Data type	Data type name	Length	Can be queried?	Can be updated?	Can be inserted?	Mandatory when inserting?	Format	Refers To	Version introduced in	Edition available in
TxnID	12	VARCHAR	36	True	False	False	False	%s		1.0	US, CA, UK
TimeCreated	93	TIMESTAMP	23	True	False	False	False	CCCC-MM-DDThh:mm:ssZ		1.0	US, CA, UK
TimeModified	93	TIMESTAMP	23	True	False	False	False	CCCC-MM-DDThh:mm:ssZ		1.0	US, CA, UK
EditSequence	12	VARCHAR	16	True	False	False	False	%s		1.0	US, CA, UK
TxnNumber	4	INTEGER	9	True	False	False	False	%11.0f		1.0	US, CA, UK
CustomerRef_ListID	12	VARCHAR	36	True	False	True	True	%s	ListID	1.0	US, CA, UK
CustomerRef_FullName	12	VARCHAR	209	True	False	True	True	%s	FullName	1.0	US, CA, UK
RefundFromAccountRef_ListID	12	VARCHAR	36	True	False	True	False	%s	ListID	1.0	US, CA, UK
RefundFromAccountRef_FullName	12	VARCHAR	159	True	False	True	False	%s	FullName	1.0	US, CA, UK
ARAccountRef_ListID	12	VARCHAR	36	True	False	True	False	%s	ListID	1.0	US, CA, UK
ARAccountRef_FullName	12	VARCHAR	159	True	False	True	False	%s	FullName	1.0	US, CA, UK
CurrencyRef_ListID	12	VARCHAR	36	True	False	True	False	%s	ListID	9.0	US, CA, UK
CurrencyRef_FullName	12	VARCHAR	64	True	False	True	False	%s	Name	9.0	US, CA, UK
ExchangeRate	2	NUMERIC	18	True	False	False	False	%10.2f		1.0	US, CA, UK
TotalAmountInHomeCurrency	2	NUMERIC	15	True	False	False	False	%10.2f		1.0	US, CA, UK
TxnDate	91	DATE	10	True	False	True	False	CCCC-MM-DD		1.0	US, CA, UK
TxnDateMacro	12	VARCHAR	25	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYear ThisFiscalYearToDate Yes -->terday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear		1.0	US, CA, UK
RefNumber	12	VARCHAR	11	True	False	True	False	%s		1.0	US, CA, UK
TotalAmount	2	NUMERIC	15	True	False	False	False	%10.2f		1.0	US, CA, UK
Address_Addr1	12	VARCHAR	41	True	False	True	False	%s		1.0	US, CA, UK
Address_Addr2	12	VARCHAR	41	True	False	True	False	%s		1.0	US, CA, UK
Address_Addr3	12	VARCHAR	41	True	False	True	False	%s		1.0	US, CA, UK
Address_Addr4	12	VARCHAR	41	True	False	True	False	%s		2.0	US, CA, UK
Address_Addr5	12	VARCHAR	41	True	False	True	False	%s		6.0	US, CA, UK
Address_City	12	VARCHAR	31	True	False	True	False	%s		1.0	US, CA, UK
Address_State	12	VARCHAR	21	True	False	True	False	%s		1.0	US, CA, UK
Address_PostalCode	12	VARCHAR	13	True	False	True	False	%s		1.0	US, CA, UK
Address_Country	12	VARCHAR	31	True	False	True	False	%s		1.0	US, CA, UK
Address_Note	12	VARCHAR	41	True	False	True	False	%s		6.0	US, CA, UK
AddressBlock_Addr1	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
AddressBlock_Addr2	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
AddressBlock_Addr3	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
AddressBlock_Addr4	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
AddressBlock_Addr5	12	VARCHAR	41	True	False	False	False	%s		6.0	US, CA, UK
PaymentMethodRef_ListID	12	VARCHAR	36	True	False	True	False	%s	ListID	1.0	US, CA, UK
PaymentMethodRef_FullName	12	VARCHAR	31	True	False	True	False	%s	Name	1.0	US, CA, UK
Memo	12	VARCHAR	4095	True	False	True	False	%s		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardNumber	12	VARCHAR	25	True	False	True	False	%s		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_ExpirationMonth	4	INTEGER	9	True	False	True	False	%11.0f		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_ExpirationYear	4	INTEGER	9	True	False	True	False	%11.0f		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_NameOnCard	12	VARCHAR	41	True	False	True	False	%s		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardAddress	12	VARCHAR	41	True	False	True	False	%s		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardPostalCode	12	VARCHAR	18	True	False	True	False	%s		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CommercialCardCode	12	VARCHAR	24	True	False	True	False	%s		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_TransactionMode	12	VARCHAR	14	True	False	True	False	CardNotPresent CardPresent		6.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnInputInfo_CreditCardTxnType	12	VARCHAR	18	True	False	True	False	Authorization Capture Charge Refund VoiceAuthorization		7.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_ResultCode	4	INTEGER	9	True	False	True	False	%11.0f		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_ResultMessage	12	VARCHAR	60	True	False	True	False	%s		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_CreditCardTransID	12	VARCHAR	24	True	False	True	False	%s		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_MerchantAccountNumber	12	VARCHAR	32	True	False	True	False	%s		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_AuthorizationCode	12	VARCHAR	12	True	False	True	False	%s		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_AVSStreet	12	VARCHAR	12	True	False	True	False	Pass Fail NotAvailable		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_AVSZip	12	VARCHAR	12	True	False	True	False	Pass Fail NotAvailable		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_CardSecurityCodeMatch	12	VARCHAR	12	True	False	True	False	Pass Fail NotAvailable		6.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_ReconBatchID	12	VARCHAR	84	True	False	True	False	%s		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_PaymentGroupingCode	4	INTEGER	9	True	False	True	False	%11.0f		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_PaymentStatus	12	VARCHAR	9	True	False	True	False	Unknown Completed		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_TxnAuthorizationTime	93	TIMESTAMP	23	True	False	True	False	CCCC-MM-DDThh:mm:ssZ		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_TxnAuthorizationStamp	4	INTEGER	9	True	False	True	False	%11.0f		1.0	US, CA, UK
CreditCardTxnInfo_CreditCardTxnResultInfo_ClientTransID	12	VARCHAR	16	True	False	True	False	%s		6.0	US, CA, UK
ExternalGUID	12	VARCHAR	40	True	False	True	False	%s		9.0	US, CA, UK

Back to list of tables.

• About Easysoft

• Contact us
• About us
• Clients
• Blog
• Careers

• Products

• ODBC drivers
• JDBC drivers
• Bridges and gateways
• In development

• Services

• Consultancy
• Training
• Custom development

• Licensing

• Product licenses
• Prices

• Support

• Support home
• Solution wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer area
• Client applications

• Legal

• Privacy statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
•