TABLE DETAIL REFERENCE: RecurringRefundReceiptLine
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
PrivateNote12 VARCHAR 4000TrueTrueTrueFalse%s
TxnTaxDetailTxnTaxCodeRef12 VARCHAR 11TrueTrueTrueFalse%8.2f
TxnTaxDetailTotalTax3 DECIMAL 13TrueTrueTrueFalse%10.7f
TxnTaxDetailTaxLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
TxnTaxDetailTaxLineDetailType12 VARCHAR 11TrueTrueTrueFalse
TaxLineDetail
TxnTaxDetailTaxLineTaxLineDetailTaxRateRef12 VARCHAR 11TrueTrueTrueFalse
NotBillable
TxnTaxDetailTaxLineTaxLineDetailPercentBased-7 BIT 1TrueTrueTrueFalse
1
0
true
false
TxnTaxDetailTaxLineTaxLineDetailTaxPercent3 DECIMAL 13TrueTrueTrueFalse%10.7f
TxnTaxDetailTaxLineTaxLineDetailNetAmountTaxable3 DECIMAL 13TrueTrueTrueFalse%11.2f
CustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
CustomerMemo12 VARCHAR 1000TrueTrueTrueFalse%s
BillAddrTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
BillAddrLine112 VARCHAR 100TrueTrueTrueFalse%s
BillAddrLine212 VARCHAR 100TrueTrueTrueFalse%s
BillAddrLine312 VARCHAR 100TrueTrueTrueFalse%s
BillAddrLat12 VARCHAR 100TrueTrueTrueFalse%s
BillAddrLong12 VARCHAR 100TrueTrueTrueFalse%s
ShipAddrTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ShipAddrLine112 VARCHAR 100TrueTrueTrueFalse%s
ShipAddrLine212 VARCHAR 100TrueTrueTrueFalse%s
ShipAddrLine312 VARCHAR 100TrueTrueTrueFalse%s
ShipAddrLat12 VARCHAR 100TrueTrueTrueFalse%s
ShipAddrLong12 VARCHAR 100TrueTrueTrueFalse%s
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
TotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
HomeTotalAmt3 DECIMAL 13TrueFalseFalseFalse%11.2f
ApplyTaxAfterDiscount-7 BIT 1TrueTrueTrueFalse
1
0
true
false
PrintStatus12 VARCHAR 1000TrueTrueTrueFalse%s
EmailStatus12 VARCHAR 13TrueTrueTrueFalse
NotSet
NeedToSend
EmailSent
BillEmailAddress12 VARCHAR 1000TrueTrueTrueFalse%s
Balance3 DECIMAL 13TrueTrueTrueFalse%11.2f
HomeBalance3 DECIMAL 13TrueFalseFalseFalse%11.2f
PaymentMethodRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
DepositToAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
SalesTaxPercentage3 DECIMAL 15TrueTrueTrueFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueTrueTrueFalse%11.2f
AppliedAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
BalanceRemaining3 DECIMAL 15TrueFalseFalseFalse%11.2f
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
IsPaid-7 BIT 1TrueFalseFalseFalse
1
0
true
false
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
RecurringObjectType12 VARCHAR 15TrueTrueTrueFalse
Bill
CreditMemo
Deposit
Estimate
Invoice
JournalEntry
Purchase
PurchaseOrder
RefundReceipt
SalesReceipt
Transfer
VendorCredit
RecurringInfoName12 VARCHAR 1000TrueTrueTrueFalse%s
RecurringInfoType12 VARCHAR 1000TrueTrueTrueFalse%s
RecurringInfoActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
RecurringInfoScheduleInfoIntervalType12 VARCHAR 15TrueTrueTrueFalse
Daily
Weekly
Monthly
Yearly
RecurringInfoScheduleInfoNumInterval12 VARCHAR 15TrueTrueTrueFalse%s
RecurringInfoScheduleInfoDayOfMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurringInfoScheduleInfoDayOfWeek4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurringInfoScheduleInfoWeekOfMonth4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurringInfoScheduleInfoMonthOfYear4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurringInfoScheduleInfoNextDate12 VARCHAR 27TrueTrueTrueFalse%s
RecurringInfoScheduleInfoPreviousDate12 VARCHAR 27TrueTrueTrueFalse%s
RecurringInfoScheduleInfoStartDate12 VARCHAR 27TrueTrueTrueFalse%s
RecurringInfoScheduleInfoEndDate12 VARCHAR 27TrueTrueTrueFalse%s
RecurringInfoScheduleInfoMaxOccurrences4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurringInfoScheduleInfoRemindDays4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurringInfoScheduleInfoDaysBefore4 INTEGER 4TrueTrueTrueFalse%11.0f
RecurDataRefListID12 VARCHAR 36TrueTrueTrueFalse%s
RecurDataRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s
RefundReceiptLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
RefundReceiptLineLineNum12 VARCHAR 11TrueTrueTrueFalse%8.2f
RefundReceiptLineDescription12 VARCHAR 4000TrueTrueTrueFalse%s
RefundReceiptLineDetailType12 VARCHAR 30TrueTrueTrueFalse
SalesItemLineDetail
SubTotalLineDetail
DiscountLineDetail
RefundReceiptLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
RefundReceiptLineItemRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
RefundReceiptLineUnitPrice3 DECIMAL 18TrueTrueTrueFalse%10.7f
RefundReceiptLineQuantity3 DECIMAL 13TrueTrueTrueFalse%10.7f
RefundReceiptLineRate3 DECIMAL 18TrueTrueTrueFalse%10.7f
RefundReceiptLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
RefundReceiptLineClassRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
RefundReceiptLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
RefundReceiptLineServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
RefundReceiptLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
RefundReceiptLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
RefundReceiptLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
RefundReceiptLineItemAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
RefundReceiptLineItemAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
DiscountLineLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
DiscountLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%11.7f
DiscountLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
DiscountLineAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
DiscountLineAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
SalesTaxLineAmount3 DECIMAL 15TrueFalseTrueFalse%11.2f
SalesTaxLineRatePercent3 DECIMAL 15TrueFalseTrueFalse%10.7f
SalesTaxLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ShippingLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey