TABLE DETAIL REFERENCE: BuildAssemblyComponentItemLine
(UK 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 16TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
ItemInventoryAssemblyRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
ItemInventoryAssemblyRefFullName12 VARCHAR 159TrueFalseTrueTrue%s Yes
InventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
InventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
InventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
SerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
LotNumber12 VARCHAR 40TrueTrueTrueFalse%s
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
TxnDateMacro12 VARCHAR 23TrueFalseFalseFalse
All
Today
ThisWeek
ThisWeekToDate
ThisMonth
ThisMonthToDate
ThisCalendarQuarter
ThisCalendarQuarterToDate
ThisFiscalQuarter
ThisFiscalQuarterToDate
ThisCalendarYear
ThisCalendarYearToDate
ThisFiscalYeRX<eTT
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
IsPending-7 BIT 1TrueFalseFalseFalse
1
0
true
false
QuantityToBuild3 DECIMAL 18TrueTrueTrueTrue%10.5f
QuantityCanBuild3 DECIMAL 18TrueFalseFalseFalse%10.5f
QuantityOnHand3 DECIMAL 18TrueFalseFalseFalse%10.5f
QuantityOnSalesOrder3 DECIMAL 18TrueFalseFalseFalse%10.5f
MarkPendingIfRequired-7 BIT 1TrueTrueTrueFalse
1
0
true
false
RemovePending-7 BIT 1TrueTrueFalseFalse
1
0
true
false
ComponentItemLineSeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
ComponentItemLineItemRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ComponentItemLineItemRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
ComponentItemLineInventorySiteRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ComponentItemLineInventorySiteRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
ComponentItemLineInventorySiteLocationRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
ComponentItemLineInventorySiteLocationRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
ComponentItemLineDesc12 VARCHAR 4095TrueFalseFalseFalse%s
ComponentItemLineQuantityOnHand3 DECIMAL 18TrueFalseFalseFalse%10.5f
ComponentItemLineQuantityNeeded3 DECIMAL 18TrueFalseFalseFalse%10.5f
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey