TABLE DETAIL REFERENCE: Transaction

(USA 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 LiabilityAdjustment Paycheck PayrollLiabilityCheck PurchaseOrder ReceivePayment SalesOrder SalesReceipt SalesTaxPaymentCheck Transfer VendorCredit YTDAdjustment ARRefundCreditCard
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 ThisFiscalYear ThisFiscalYearToDate Yesterday LastWeek LastWeekToDate LastMonth LastMonthToDate LastCalendarQuarter LastCalendarQuarterToDate LastFiscalQuarter LastFiscalQuarterToDate LastCalendarYear LastCalendarYearToDate LastFiscalYear LastFiscalYearToDate NextWeek NextFourWeeks NextMonth NextCalendarQuarter NextCalendarYear NextFiscalQuarter NextFiscalYear
RefNumber	12	VARCHAR	20	True	False	False	False	%s
Amount	3	DECIMAL	18	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	17	True	False	False	False	%6.8f
AmountInHomeCurrency	3	DECIMAL	18	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