TABLE DETAIL REFERENCE: ModifyInwardGroupLine
(Canada VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TableName12 VARCHAR 31TrueTrueTrueTrue%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
ModifyInwardGroupLineType12 VARCHAR 11TrueFalseTrueFalseItemType
ModifyInwardGroupLineGroupTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ModifyInwardGroupLineGroupItemGroupRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineGroupItemGroupRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineGroupDesc12 VARCHAR 4095TrueFalseTrueFalse%s
ModifyInwardGroupLineGroupQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
ModifyInwardGroupLineGroupUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineGroupOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
ModifyInwardGroupLineGroupOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
ModifyInwardGroupLineGroupIsPrintItemsInGroup-7 BIT 1TrueFalseTrueFalse
1
0
true
false
ModifyInwardGroupLineGroupTotalAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ModifyInwardGroupLineGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
ModifyInwardGroupLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ModifyInwardGroupLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineItemRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineInventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineInventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineInventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineInventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineSerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
ModifyInwardGroupLineLotNumber12 VARCHAR 40TrueTrueTrueFalse%s
ModifyInwardGroupLineDesc12 VARCHAR 4095TrueTrueTrueFalse%s
ModifyInwardGroupLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
ModifyInwardGroupLineUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
ModifyInwardGroupLineOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
ModifyInwardGroupLineCost3 DECIMAL 18TrueTrueTrueFalse%10.5f
ModifyInwardGroupLineAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
ModifyInwardGroupLineCustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineCustomerRefFullName12 VARCHAR 209TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineBillableStatus12 VARCHAR 13TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
ModifyInwardGroupLineOverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineOverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineSalesRepRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyInwardGroupLineSalesRepRefFullName12 VARCHAR 5TrueTrueTrueFalse%s Yes
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey