BillPaymentCheckLine Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ID 12 VARCHAR 75
TxnID 12 VARCHAR 36 True False False False %s TxnID 2.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 2.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 2.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 2.0 US, CA, UK
TxnNumber 4 INTEGER 9 True False False False %12.0f 2.0 US, CA, UK
PayeeEntityRef_ListID 12 VARCHAR 36 True False True True %s ListID 2.0 US, CA, UK
PayeeEntityRef_FullName 12 VARCHAR 209 True False True True %s FullName 2.0 US, CA, UK
APAccountRef_ListID 12 VARCHAR 36 True False True False %s ListID 2.0 US, CA, UK
APAccountRef_FullName 12 VARCHAR 159 True False True False %s FullName 2.0 US, CA, UK
TxnDate 91 DATE 10 True True True False CCCC-MM-DD 2.0 US, CA, UK
TxnDateMacro 12 VARCHAR 25 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
 2.0 US, CA, UK
BankAccountRef_ListID 12 VARCHAR 36 True True True True %s ListID 2.0 US, CA, UK
BankAccountRef_FullName 12 VARCHAR 159 True True True True %s FullName 2.0 US, CA, UK
Amount 2 NUMERIC 15 True True False False %10.2f 2.0 US, CA, UK
CurrencyRef_ListID 12 VARCHAR 36 True False False True %s ListID 8.0 US, CA, UK
CurrencyRef_FullName 12 VARCHAR 159 True False False True %s Name 8.0 US, CA, UK
ExchangeRate 2 NUMERIC 15 True True False False %6.6f 8.0 US, CA, UK
AmountInHomeCurrency 2 NUMERIC 15 True True False False %10.2f 8.0 US, CA, UK
RefNumber 12 VARCHAR 11 True True True True %s 2.0 US, CA, UK
IsToBePrinted -7 BIT 2 True True True True
1
0
true
false
 2.0 US, CA, UK
Memo 12 VARCHAR 4095 True True True False %s 2.0 US, CA, UK
Address_Addr1 12 VARCHAR 41 True False False False %s 2.0 US, CA, UK
Address_Addr2 12 VARCHAR 41 True False False False %s 2.0 US, CA, UK
Address_Addr3 12 VARCHAR 41 True False False False %s 2.0 US, CA, UK
Address_Addr4 12 VARCHAR 41 True False False False %s 2.0 US, CA, UK
Address_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
Address_City 12 VARCHAR 41 True False False False %s 2.0 US, CA, UK
Address_State 12 VARCHAR 21 True False False False %s 2.0 US, CA, UK
Address_PostalCode 12 VARCHAR 13 True False False False %s 2.0 US, CA, UK
Address_Country 12 VARCHAR 31 True False False False %s 2.0 US, CA, UK
Address_Note 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
AddressBlock_Addr1 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
AddressBlock_Addr2 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
AddressBlock_Addr3 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
AddressBlock_Addr4 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
AddressBlock_Addr5 12 VARCHAR 41 True False False False %s 6.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 9.0 US, CA, UK
AppliedToTxn_SeqNo 4 INTEGER 9 True False False False SeqNo 2.0 US, CA, UK
AppliedToTxn_TxnID 12 VARCHAR 36 True True True True %s 2.0 US, CA, UK
AppliedToTxn_PaymentAmount 2 NUMERIC 15 True True True False %10.2f 2.0 US, CA, UK
AppliedToTxn_TxnType 12 VARCHAR 14 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
 2.0 US, CA, UK
AppliedToTxn_TxnDate 91 DATE 10 True False False False CCCC-MM-DD 2.0 US, CA, UK
AppliedToTxn_RefNumber 12 VARCHAR 20 True False False False %s 2.0 US, CA, UK
AppliedToTxn_BalanceRemaining 2 NUMERIC 15 True False False False %10.2f 2.0 US, CA, UK
AppliedToTxn_Amount 2 NUMERIC 15 True False False False %10.2f 2.0 US, CA, UK
AppliedToTxn_SetCredit_CreditTxnID 12 VARCHAR 36 True True True False %s 2.0 US, CA, UK
AppliedToTxn_SetCredit_AppliedAmount 2 NUMERIC 15 True True True False %10.2f 2.0 US, CA, UK
AppliedToTxn_SetCredit_Override -7 BIT 2
AppliedToTxn_DiscountAmount 2 NUMERIC 15 True True True False %10.2f 2.0 US, CA, UK
AppliedToTxn_DiscountAccountRef_ListID 12 VARCHAR 36 True True True False %s ListID 2.0 US, CA, UK
AppliedToTxn_DiscountAccountRef_FullName 12 VARCHAR 159 True True True False %s FullName 2.0 US, CA, UK
AppliedToTxn_DiscountClassRef_ListID 12 VARCHAR 36 True True True False %s ListID 11.0 US, CA, UK
AppliedToTxn_DiscountClassRef_FullName 12 VARCHAR 159 True True True False %s FullName 11.0 US, CA, UK
RQUseCachedID -7 BIT 2