TABLE DETAIL REFERENCE: RecurringRefundReceipt

(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
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CurrencyRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CurrencyRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
ExchangeRate	3	DECIMAL	13	True	False	True	False	%11.7f
PrivateNote	12	VARCHAR	4000	True	True	True	False	%s
TxnTaxDetailTxnTaxCodeRef	12	VARCHAR	11	True	True	True	False	%8.2f
TxnTaxDetailTotalTax	3	DECIMAL	13	True	True	True	False	%10.7f
TxnTaxDetailTaxLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
TxnTaxDetailTaxLineDetailType	12	VARCHAR	11	True	True	True	False	TaxLineDetail
TxnTaxDetailTaxLineTaxLineDetailTaxRateRef	12	VARCHAR	11	True	True	True	False	NotBillable
TxnTaxDetailTaxLineTaxLineDetailPercentBased	-7	BIT	1	True	True	True	False	1 0 true false
TxnTaxDetailTaxLineTaxLineDetailTaxPercent	3	DECIMAL	13	True	True	True	False	%10.7f
TxnTaxDetailTaxLineTaxLineDetailNetAmountTaxable	3	DECIMAL	13	True	True	True	False	%11.2f
CustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomerRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
CustomerMemo	12	VARCHAR	1000	True	True	True	False	%s
BillAddrTxnLineID	12	VARCHAR	36	True	True	False	False	%s
BillAddrLine1	12	VARCHAR	100	True	True	True	False	%s
BillAddrLine2	12	VARCHAR	100	True	True	True	False	%s
BillAddrLine3	12	VARCHAR	100	True	True	True	False	%s
BillAddrLat	12	VARCHAR	100	True	True	True	False	%s
BillAddrLong	12	VARCHAR	100	True	True	True	False	%s
ShipAddrTxnLineID	12	VARCHAR	36	True	True	False	False	%s
ShipAddrLine1	12	VARCHAR	100	True	True	True	False	%s
ShipAddrLine2	12	VARCHAR	100	True	True	True	False	%s
ShipAddrLine3	12	VARCHAR	100	True	True	True	False	%s
ShipAddrLat	12	VARCHAR	100	True	True	True	False	%s
ShipAddrLong	12	VARCHAR	100	True	True	True	False	%s
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
HomeTotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
ApplyTaxAfterDiscount	-7	BIT	1	True	True	True	False	1 0 true false
PrintStatus	12	VARCHAR	1000	True	True	True	False	%s
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToSend EmailSent
BillEmailAddress	12	VARCHAR	1000	True	True	True	False	%s
Balance	3	DECIMAL	13	True	True	True	False	%11.2f
HomeBalance	3	DECIMAL	13	True	False	False	False	%11.2f
PaymentMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PaymentMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
DepositToAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepositToAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
SalesTaxPercentage	3	DECIMAL	15	True	True	True	False	%10.7f
SalesTaxTotal	3	DECIMAL	13	True	True	True	False	%11.2f
AppliedAmount	3	DECIMAL	15	True	False	False	False	%11.2f
BalanceRemaining	3	DECIMAL	15	True	False	False	False	%11.2f
Memo	12	VARCHAR	4000	True	True	True	False	%s
IsPaid	-7	BIT	1	True	False	False	False	1 0 true false
IsToBePrinted	-7	BIT	1	True	True	True	False	1 0 true false
RecurringObjectType	12	VARCHAR	15	True	True	True	False	Bill CreditMemo Deposit Estimate Invoice JournalEntry Purchase PurchaseOrder RefundReceipt SalesReceipt Transfer VendorCredit
RecurringInfoName	12	VARCHAR	1000	True	True	True	False	%s
RecurringInfoType	12	VARCHAR	1000	True	True	True	False	%s
RecurringInfoActive	-7	BIT	1	True	True	True	False	1 0 true false
RecurringInfoScheduleInfoIntervalType	12	VARCHAR	15	True	True	True	False	Daily Weekly Monthly Yearly
RecurringInfoScheduleInfoNumInterval	12	VARCHAR	15	True	True	True	False	%s
RecurringInfoScheduleInfoDayOfMonth	4	INTEGER	4	True	True	True	False	%11.0f
RecurringInfoScheduleInfoDayOfWeek	4	INTEGER	4	True	True	True	False	%11.0f
RecurringInfoScheduleInfoWeekOfMonth	4	INTEGER	4	True	True	True	False	%11.0f
RecurringInfoScheduleInfoMonthOfYear	4	INTEGER	4	True	True	True	False	%11.0f
RecurringInfoScheduleInfoNextDate	12	VARCHAR	27	True	True	True	False	%s
RecurringInfoScheduleInfoPreviousDate	12	VARCHAR	27	True	True	True	False	%s
RecurringInfoScheduleInfoStartDate	12	VARCHAR	27	True	True	True	False	%s
RecurringInfoScheduleInfoEndDate	12	VARCHAR	27	True	True	True	False	%s
RecurringInfoScheduleInfoMaxOccurrences	4	INTEGER	4	True	True	True	False	%11.0f
RecurringInfoScheduleInfoRemindDays	4	INTEGER	4	True	True	True	False	%11.0f
RecurringInfoScheduleInfoDaysBefore	4	INTEGER	4	True	True	True	False	%11.0f
RecurDataRefListID	12	VARCHAR	36	True	True	True	False	%s
RecurDataRefFullName	12	VARCHAR	1000	True	True	True	False	%s
DiscountLineLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f
DiscountLineRatePercent	3	DECIMAL	15	True	True	True	False	%11.7f
DiscountLineIsTaxable	-7	BIT	1	True	True	True	False	1 0 true false
DiscountLineAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
DiscountLineAccountRefFullName	12	VARCHAR	1000	True	False	True	False	%s	Yes
SalesTaxLineAmount	3	DECIMAL	15	True	False	True	False	%11.2f
SalesTaxLineRatePercent	3	DECIMAL	15	True	False	True	False	%10.7f
SalesTaxLineAccountRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
SalesTaxLineAccountRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ShippingLineAmount	3	DECIMAL	15	True	True	True	False	%11.2f