TABLE DETAIL REFERENCE: CreditCardPayment

(Online 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	10	True	False	False	False	%s
CreditCardAccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
CreditCardAccountRefFullName	12	VARCHAR	1000	True	True	True	True	%s	Yes
BankAccountRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
BankAccountRefFullName	12	VARCHAR	1000	True	True	True	True	%s	Yes
VendorRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
VendorRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TxnDate	9	DATE	6	True	True	True	True	CCCC-MM-DD
Amount	3	DECIMAL	15	True	True	True	True	%11.2f
Memo	12	VARCHAR	4000	True	True	True	False	%s
PrintStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToPrint PrintComplete
CheckNum	12	VARCHAR	1000	True	True	True	False	%s