TABLE DETAIL REFERENCE: RecurringCreditMemoLine
(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
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
CustomerRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
CustomerMemo12 VARCHAR 4000TrueTrueTrueFalse%s
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CurrencyRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CurrencyRefFullName12 VARCHAR 64TrueTrueTrueFalse%s Yes
ExchangeRate3 DECIMAL 13TrueFalseTrueFalse%11.7f
BillAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
BillAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
BillAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressState12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
BillAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
BillAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr112 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr212 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr312 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr412 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressAddr512 VARCHAR 500TrueTrueTrueFalse%s
ShipAddressCity12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressState12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressPostalCode12 VARCHAR 30TrueTrueTrueFalse%s
ShipAddressCountry12 VARCHAR 255TrueTrueTrueFalse%s
ShipAddressNote12 VARCHAR 500TrueTrueTrueFalse%s
Subtotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
SalesTaxPercentage3 DECIMAL 15TrueFalseFalseFalse%10.7f
SalesTaxTotal3 DECIMAL 13TrueFalseFalseFalse%11.2f
TotalAmount3 DECIMAL 15TrueFalseFalseFalse%11.2f
CreditRemaining3 DECIMAL 13TrueFalseFalseFalse%11.2f
Memo12 VARCHAR 4000TrueTrueTrueFalse%s
IsToBePrinted-7 BIT 1TrueTrueTrueFalse
1
0
true
false
EmailStatus12 VARCHAR 13TrueTrueTrueFalse
NotSet
NeedToSend
EmailSent
BillEmailAddress12 VARCHAR 1000TrueTrueTrueFalse%s
HomeBalance3 DECIMAL 13TrueFalseFalseFalse%11.2f
CustomFieldOther12 VARCHAR 29TrueTrueTrueFalse%s
GlobalTaxCalculation12 VARCHAR 15TrueTrueTrueFalse
TaxExcluded
TaxIncluded
NotApplicable
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
CreditMemoLineType12 VARCHAR 11TrueFalseFalseFalseItemType
CreditMemoLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
CreditMemoLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
CreditMemoLineDetailType12 VARCHAR 4000TrueTrueTrueFalse%s
CreditMemoLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineItemRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CreditMemoLineDesc12 VARCHAR 4000TrueTrueTrueFalse%s
CreditMemoLineUnitPrice3 DECIMAL 18TrueTrueTrueFalse%10.7f
CreditMemoLineQuantity3 DECIMAL 16TrueTrueTrueFalse%10.7f
CreditMemoLineRate3 DECIMAL 18TrueTrueTrueFalse%10.7f
CreditMemoLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%10.7f
CreditMemoLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CreditMemoLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
CreditMemoLineServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
CreditMemoLineIsTaxable-7 BIT 1TrueTrueTrueFalse
1
0
true
false
CreditMemoLineTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CreditMemoLineTaxCodeRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
CreditMemoLineItemAccountRefListID12 VARCHAR 36TrueFalseTrueFalse%s Yes
CreditMemoLineItemAccountRefFullName12 VARCHAR 1000TrueFalseTrueFalse%s Yes
DiscountLineAmount3 DECIMAL 15TrueTrueTrueFalse%11.2f
DiscountLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%11.7f
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
ShippingLineAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ShippingLineAccountRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
FQSaveToCache-7 BIT 1TrueFalseTrueFalseFQSaveToCache
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey
FQTxnLinkKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey