TABLE DETAIL REFERENCE: RecurringEstimate

(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
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
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
TxnStatus	12	VARCHAR	1000	True	False	False	False	%s
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
BillAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
BillAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
BillAddressCity	12	VARCHAR	31	True	True	True	False	%s
BillAddressState	12	VARCHAR	255	True	True	True	False	%s
BillAddressProvince	12	VARCHAR	255	True	True	True	False	%s
BillAddressCounty	12	VARCHAR	255	True	True	True	False	%s
BillAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
BillAddressCountry	12	VARCHAR	31	True	True	True	False	%s
BillAddressNote	12	VARCHAR	500	True	True	True	False	%s
ShipAddressAddr1	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr2	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr3	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr4	12	VARCHAR	41	True	True	True	False	%s
ShipAddressAddr5	12	VARCHAR	500	True	True	True	False	%s
ShipAddressCity	12	VARCHAR	31	True	True	True	False	%s
ShipAddressState	12	VARCHAR	100	True	True	True	False	%s
ShipAddressPostalCode	12	VARCHAR	13	True	True	True	False	%s
ShipAddressCountry	12	VARCHAR	31	True	True	True	False	%s
ShipAddressNote	12	VARCHAR	500	True	True	True	False	%s
ShipMethodRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ShipMethodRefFullName	12	VARCHAR	100	True	True	True	False	%s	Yes
ShipDate	9	DATE	6	True	False	False	False	CCCC-MM-DD
GlobalTaxCalculation	12	VARCHAR	15	True	True	True	False	TaxExcluded TaxIncluded NotApplicable
TotalAmt	3	DECIMAL	13	True	False	False	False	%11.2f
ApplyTaxAfterDiscount	-7	BIT	1	True	False	False	False	1 0 true false
PrintStatus	12	VARCHAR	13	True	False	False	False	NotSet NeedToPrint PrintComplete
EmailStatus	12	VARCHAR	13	True	True	True	False	NotSet NeedToSend EmailSent
BillEmailAddress	12	VARCHAR	1000	True	True	True	False	%s
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
DiscountLineAmount	3	DECIMAL	15	True	False	True	False	%11.2f
DiscountLineRatePercent	3	DECIMAL	15	True	False	True	False	%11.7f
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	False	True	False	%11.2f
ShippingLineAccountRefListID	12	VARCHAR	36	True	False	True	False	%s	Yes
ShippingLineAccountRefFullName	12	VARCHAR	1000	True	False	True	False	%s	Yes