TABLE DETAIL REFERENCE: Transaction

(UK VERSION)

>>

<<

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
TxnType	12	VARCHAR	25	True	False	False	False	Bill BillPaymentCheck BillPaymentCreditCard BuildAssembly Charge Check CreditCardCharge CreditCardCredit CreditMemo Deposit Estimate InventoryAdjustment Invoice ItemReceipt JournalEntry LiabilityAdjusÃÝoNþKvÉÐþø ÄÛ…T ÄÛ…TÐþøHÄÛ…THÄÛ…TžŸžŸ Ðþø
TxnID	12	VARCHAR	36	True	False	False	False	%s
TxnLineID	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
EntityRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
EntityRefFullName	12	VARCHAR	209	True	False	False	False	%s	Yes
AccountRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
AccountRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
TxnDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
TxnDateMacro	12	VARCHAR	23	True	False	False	False	All Today ThisWeek ThisWeekToDate ThisMonth ThisMonthToDate ThisCalendarQuarter ThisCalendarQuarterToDate ThisFiscalQuarter ThisFiscalQuarterToDate ThisCalendarYear ThisCalendarYearToDate ThisFiscalYeCC
RefNumber	12	VARCHAR	20	True	False	False	False	%s
Amount	3	DECIMAL	15	True	False	False	False	%10.2f
CurrencyRefListID	12	VARCHAR	36	True	False	False	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	159	True	False	False	False	%s	Yes
ExchangeRate	3	DECIMAL	15	True	False	False	False	%6.6f
AmountInHomeCurrency	3	DECIMAL	15	True	False	False	False	%10.2f
Memo	12	VARCHAR	4095	True	False	False	False	%s
TransactionDetailLevelFilter	12	VARCHAR	23	True	False	False	False	All SummaryOnly AllExceptSummary
TransactionPostingStatusFilter	12	VARCHAR	23	True	False	False	False	Either NonPosting Posting
TransactionPaidStatusFilter	12	VARCHAR	23	True	False	False	False	Either Closed Open
Empty	12	VARCHAR	25	True	False	False	False	%s
FQTxnLinkKey	12	VARCHAR	184	True	False	False	False	FQPrimaryKey
FQJournalEntryLinkKey	12	VARCHAR	184	True	False	False	False	FQPrimaryKey
FQPrimaryKey	12	VARCHAR	184	True	False	False	False	FQPrimaryKey