TABLE DETAIL REFERENCE: ModifyOutwardGroupLine
(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
ModifyOutwardGroupLineType12 VARCHAR 11TrueFalseTrueFalseItemType
ModifyOutwardGroupLineGroupTxnLineID12 VARCHAR 36TrueTrueTrueFalse%s
ModifyOutwardGroupLineGroupItemGroupRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineGroupItemGroupRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineGroupDesc12 VARCHAR 4095TrueTrueTrueFalse%s
ModifyOutwardGroupLineGroupQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
ModifyOutwardGroupLineGroupUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineGroupOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
ModifyOutwardGroupLineGroupOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
ModifyOutwardGroupLineGroupIsPrintItemsInGroup-7 BIT 1TrueFalseTrueFalse
1
0
true
false
ModifyOutwardGroupLineGroupTotalAmount3 DECIMAL 15TrueFalseFalseFalse%10.2f
ModifyOutwardGroupLineGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
ModifyOutwardGroupLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ModifyOutwardGroupLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineItemRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineDesc12 VARCHAR 4095TrueTrueTrueFalse%s
ModifyOutwardGroupLineQuantity3 DECIMAL 18TrueTrueTrueFalse%10.5f
ModifyOutwardGroupLineUnitOfMeasure12 VARCHAR 31TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineOverrideUOMSetRefListID12 VARCHAR 36TrueTrueFalseFalse%s Yes
ModifyOutwardGroupLineOverrideUOMSetRefFullName12 VARCHAR 31TrueTrueFalseFalse%s Yes
ModifyOutwardGroupLineRate3 DECIMAL 18TrueTrueTrueFalse%10.5f
ModifyOutwardGroupLineRatePercent3 DECIMAL 18TrueTrueTrueFalse%10.5f
ModifyOutwardGroupLinePriceLevelRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLinePriceLevelRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineAmount3 DECIMAL 15TrueTrueTrueFalse%10.2f
ModifyOutwardGroupLineOptionForPriceRuleConflict12 VARCHAR 23FalseTrueTrueFalse
Zero
BasePrice
ModifyOutwardGroupLineInventorySiteRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineInventorySiteRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineInventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineInventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineSerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
ModifyOutwardGroupLineLotNumber12 VARCHAR 40TrueTrueTrueFalse%s
ModifyOutwardGroupLineServiceDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
ModifyOutwardGroupLineSalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineSalesTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineOverrideItemAccountRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineOverrideItemAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineCustomFieldOther112 VARCHAR 29TrueTrueTrueFalse%s
ModifyOutwardGroupLineCustomFieldOther212 VARCHAR 29TrueTrueTrueFalse%s
FQPrimaryKey12 VARCHAR 110TrueFalseFalseFalseFQPrimaryKey