TABLE DETAIL REFERENCE: ModifyOutwardGroupLine
(Online 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 10TrueFalseFalseFalse%s
ModifyOutwardGroupLineType12 VARCHAR 11TrueFalseTrueFalseItemType
ModifyOutwardGroupLineGroupTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ModifyOutwardGroupLineGroupItemGroupRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineGroupItemGroupRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineGroupDesc12 VARCHAR 4000TrueFalseTrueFalse%s
ModifyOutwardGroupLineGroupQuantity3 DECIMAL 16TrueTrueTrueFalse%8.5f
ModifyOutwardGroupLineGroupIsPrintItemsInGroup-7 BIT 1TrueFalseTrueFalse
1
0
true
false
ModifyOutwardGroupLineGroupTotalAmount3 DECIMAL 13TrueFalseFalseFalse%8.2f
ModifyOutwardGroupLineGroupSeqNo4 INTEGER 4TrueFalseFalseFalseSubSeqNo
ModifyOutwardGroupLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
ModifyOutwardGroupLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineItemRefFullName12 VARCHAR 100TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineDesc12 VARCHAR 4000TrueTrueTrueFalse%s
ModifyOutwardGroupLineQuantity3 DECIMAL 16TrueTrueTrueFalse%8.5f
ModifyOutwardGroupLineRate3 DECIMAL 16TrueTrueTrueFalse%8.5f
ModifyOutwardGroupLineRatePercent3 DECIMAL 15TrueTrueTrueFalse%7.5f
ModifyOutwardGroupLinePriceLevelRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLinePriceLevelRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ModifyOutwardGroupLineAmount3 DECIMAL 13TrueTrueTrueFalse%8.2f
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