TABLE DETAIL REFERENCE: BuildAssemblyComponentItemLine
(USA 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
ThisFiscalYear
ThisFiscalYearToDate
Yesterday
LastWeek
LastWeekToDate
LastMonth
LastMonthToDate
LastCalendarQuarter
LastCalendarQuarterToDate
LastFiscalQuarter
LastFiscalQuarterToDate
LastCalendarYear
LastCalendarYearToDate
LastFiscalYear
LastFiscalYearToDate
NextWeek
NextFourWeeks
NextMonth
NextCalendarQuarter
NextCalendarYear
NextFiscalQuarter
NextFiscalYear
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
ComponentItemLineSerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
ComponentItemLineLotNumber12 VARCHAR 40TrueTrueTrueFalse%s
ComponentItemLineDesc12 VARCHAR 4095TrueFalseFalseFalse%s
ComponentItemLineQuantityOnHand3 DECIMAL 18TrueFalseFalseFalse%10.5f
ComponentItemLineQuantityNeeded3 DECIMAL 18TrueFalseFalseFalse%10.5f
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey