BillItemLine 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 115 True False False False %s
TxnID 12 VARCHAR 36 True False False False %s TxnID 1.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 1.0 US, CA, UK
TxnNumber 4 INTEGER 9 True False False False %11.0f 1.0 US, CA, UK
VendorRef_ListID 12 VARCHAR 36 True True True True %s ListID 1.0 US, CA, UK
VendorRef_FullName 12 VARCHAR 41 True True True True %s Name 1.0 US, CA, UK
VendorAddress_Addr1 12 VARCHAR 41 True True True False %s 13.0 US, CA, UK
VendorAddress_Addr2 12 VARCHAR 41 True True True False %s 13.0 US, CA, UK
VendorAddress_Addr3 12 VARCHAR 41 True True True False %s 13.0 US, CA, UK
VendorAddress_Addr4 12 VARCHAR 41 True True True False %s 13.0 US, CA, UK
VendorAddress_City 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
VendorAddress_State 12 VARCHAR 13 True True True False %s 13.0 US, CA, UK
VendorAddress_PostalCode 12 VARCHAR 36 True True True False %s 13.0 US, CA, UK
VendorAddress_Country 12 VARCHAR 159 True True True False %s 13.0 US, CA, UK
APAccountRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
APAccountRef_FullName 12 VARCHAR 159 True True True False %s FullName 1.0 US, CA, UK
TxnDate 10 DATE 6 True True True False CCCC-MM-DD 1.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
 1.0 US, CA, UK
DueDate 91 DATE 10 True True True False CCCC-MM-DD 1.0 US, CA, UK
AmountDue 2 NUMERIC 15 True False False False %10.2f 1.0 US, CA, UK
CurrencyRef_ListID 12 VARCHAR 36 True False False False %s ListID 8.0 US, CA, UK
CurrencyRef_FullName 12 VARCHAR 64 True False False False %s FullName 8.0 US, CA, UK
ExchangeRate 2 NUMERIC 18 True True True False %6.6f 8.0 US, CA, UK
AmountDueInHomeCurrency 2 NUMERIC 15 True False False False %10.2f 8.0 US, CA, UK
RefNumber 12 VARCHAR 20 True True True False %s 1.0 US, CA, UK
TermsRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
TermsRef_FullName 12 VARCHAR 31 True True True False %s Name 1.0 US, CA, UK
Memo 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
IsPaid -7 BIT 1 True False False False
1
0
true
false
 1.0 US, CA, UK
ExternalGUID 12 VARCHAR 40 True False True False %s 9.0 US, CA, UK
LinkToTxnID 12 VARCHAR 36 True False True False %s 1.0 US, CA, UK
OpenAmount 2 NUMERIC 15 True False False False %10.2f 1.0 US, CA, UK
ItemLineType 12 VARCHAR 10 True False False False ItemType 1.0 US, CA, UK
ItemGroupLine_TxnLineID 12 VARCHAR 36 True True False False %s 1.0 US, CA, UK
ItemGroupLine_ItemGroupRef_ListID 12 VARCHAR 36 True True True True %s ListID 1.0 US, CA, UK
ItemGroupLineItem_GroupRef_FullName 12 VARCHAR 31 True True True True %s FullName 1.0 US, CA, UK
ItemGroupLine_Desc 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
ItemGroupLine_Quantity 4 INTEGER 9 True True True False %10.5f 1.0 US, CA, UK
ItemGroup_UnitOfMeasure 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
ItemGroupLine_InventorySiteRef_ListID 12 VARCHAR 36 True True True False %s 1.0 US, CA, UK
ItemGroupLine_InventorySiteRef_FullName 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
ItemGroupLine_InventorySiteLocationRef_ListID 12 VARCHAR 36 True True True False %s 1.0 US, CA, UK
ItemGroupLine_InventorySiteLocationRef_FullName 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK
ItemGroupLine_OverrideUOMSetRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
ItemGroupLine_OverrideUOMSetRef_FullName 12 VARCHAR 31 True True True False %s Name 1.0 US, CA, UK
ItemGroupLine_TotalAmount 2 NUMERIC 18 True False False False %10.5f 1.0 US, CA, UK
ItemLine_TxnLineID 12 VARCHAR 36 True True False False %s 1.0 US, CA, UK
ItemLine_ItemRef_ListID 12 VARCHAR 36 True True True True %s ListID 1.0 US, CA, UK
ItemLine_ItemRef_FullName 12 VARCHAR 255 True True True True %s FullName 1.0 US, CA, UK
ItemLine_InventorySiteRef_ListID 12 VARCHAR 36 True True True True %s ListID 1.0 US, CA, UK
ItemLine_InventorySiteRef_FullName 12 VARCHAR 31 True True True True %s Name 1.0 US, CA, UK
ItemLine_InventorySiteLocationRef_ListID 12 VARCHAR 36 True True True True %s ListID 1.0 US, CA, UK
ItemLine_InventorySiteLocationRef_FullName 12 VARCHAR 31 True True True True %s Name 1.0 US, CA, UK
ItemLine_SerialNumber 12 VARCHAR 4095 True True True True %s 1.0 US, CA, UK
ItemLine_LotNumber 12 VARCHAR 40 True True True True %s 1.0 US, CA, UK
ItemLine_Desc 12 VARCHAR 255 True True True False %s 1.0 US, CA, UK
ItemLine_Quantity 4 NUMERIC 9 True True True False %10.5f 1.0 US, CA, UK
ItemLine_UnitOfMeasure 12 VARCHAR 255 True True True False %s Name 1.0 US, CA, UK
ItemLine_OverrideUOMSetRef_ListID 12 VARCHAR 36 True True False False %s ListID 1.0 US, CA, UK
ItemLine_OverrideUOMSetRef_FullName 12 VARCHAR 31 True True False False %s Name 1.0 US, CA, UK
ItemLine_Cost 2 NUMERIC 15 True True True False %10.5f 1.0 US, CA, UK
ItemLine_Amount 2 NUMERIC 15 True True True False %10.2f 1.0 US, CA, UK
ItemLine_CustomerRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
ItemLine_CustomerRef_FullName 12 VARCHAR 255 True True True False %s FullName 1.0 US, CA, UK
ItemLine_ClassRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
ItemLine_ClassRef_FullName 12 VARCHAR 159 True True True False %s FullName 1.0 US, CA, UK
ItemLine_BillableStatus 12 VARCHAR 255 True True True False
Billable
NotBillable
HasBeenBilled
 1.0 US, CA, UK
ItemLine_OverrideItemAccountRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
ItemLine_OverrideItemAccountRef_FullName 12 VARCHAR 159 True True True False %s FullName 1.0 US, CA, UK
ItemLine_LinkToTxn_TxnID 12 VARCHAR 36 True False True False %s 1.0 US, CA, UK
ItemLine_LinkToTxn_TxnLineID 12 VARCHAR 36 True False True False %s 1.0 US, CA, UK
ItemLine_SalesRepRef_ListID 12 VARCHAR 36 True False True False %s 1.0 US, CA, UK
ItemLine_SalesRepRef_FullName 12 VARCHAR 5 True False True False %s 1.0 US, CA, UK
RQUseCachedID -7 BIT 2

Back to list of tables.