TABLE DETAIL REFERENCE: TransferInventoryLine
(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
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
RefNumber12 VARCHAR 11TrueTrueTrueFalse%s
FromInventorySiteListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
FromInventorySiteFullName12 VARCHAR 31TrueTrueTrueTrue%s Yes
ToInventorySiteListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
ToInventorySiteFullName12 VARCHAR 31TrueTrueTrueTrue%s Yes
Memo12 VARCHAR 4095TrueTrueTrueFalse%s
ExternalGUID12 VARCHAR 40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
TransferInventorySeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
TransferInventoryLineTxnLineID12 VARCHAR 36TrueTrueFalseFalse%s
TransferInventoryLineItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TransferInventoryLineItemRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
TransferInventoryLineFromInventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TransferInventoryLineFromInventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
TransferInventoryLineToInventorySiteLocationRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
TransferInventoryLineToInventorySiteLocationRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
TransferInventoryLineQuantityToTransfer3 DECIMAL 18FalseTrueTrueFalse%10.5f
TransferInventoryLineQuantityTransferred3 DECIMAL 18TrueFalseFalseFalse%10.5f
TransferInventoryLineSerialNumber12 VARCHAR 4095TrueTrueTrueFalse%s
TransferInventoryLineLotNumber12 VARCHAR 40TrueTrueTrueFalse%s
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey