TABLE DETAIL REFERENCE: CreditCardCharge

(UK VERSION)

>>

<<

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
TxnID	12	VARCHAR	36	True	False	False	False	%s
TimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeModified	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
EditSequence	12	VARCHAR	16	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
AccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
AccountRefFullName	12	VARCHAR	159	True	True	True	True	%s	Yes
PayeeEntityRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayeeEntityRefFullName	12	VARCHAR	209	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYe  R  X< °ÖeüTà™ ‘T
Amount	3	DECIMAL	15	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	True	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	True	%s	Yes
ExchangeRate	3	DECIMAL	15	True	True	True	False	%6.6f
AmountInHomeCurrency	3	DECIMAL	15	True	False	False	False	%10.2f
RefNumber	12	VARCHAR	11	True	True	True	False	%s
Memo	12	VARCHAR	4095	True	True	True	False	%s
IsTaxIncluded	-7	BIT	1	True	True	True	False	1 0 true false
SalesTaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesTaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
TaxCodeRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
TaxCodeRefFullName	12	VARCHAR	3	True	True	True	False	%s	Yes
Tax1Total	3	DECIMAL	15	True	False	False	False	%10.2f
Tax2Total	3	DECIMAL	15	True	False	False	False	%10.2f
AmountIncludesVAT	-7	BIT	1	True	False	False	False	1 0 true false