Class IM_Physical_bus

Inherits

CI_Constant, CI_ItemCode_val, CI_ProductLine_val, CI_Warehouse_val, SY_Maint, SY_MaintSet

Properties

LOCAL cIsSysDB=isFALSE  
LOCAL cMainTable$="IM_Physical"  
LOCAL cRestartFile$  
PROPERTY FromCancel  
PROPERTY IM_RequireMultipleWarehouses$   * Read Only *
PROPERTY PhysicalQtyChanged   * Read Only *
PROPERTY QtyMask$  
PROPERTY LotSerUserAllowChangeDate   * Read Only *

[boolean] Flag for corresponding security event to allow the modification to Lot/Serial Expiration Date

PROPERTY RequireExpirationDate   * Read Only *

[boolean] Flag to indicate the current item requires a lot/serial expiration date to be entered

PROPERTY TrackLotSerialExpiration   * Read Only *

[boolean] Flag to indicate the lot/serial expiration dates are being tracked for the current item

Methods

FUNCTION AddLines()  
FUNCTION AddToPhysical(whse$, item$, bin$, lotSerial$, lotSerialExpDate$, qty)  
FUNCTION AddToPhysical(whse$, item$, bin$, lotSerial$, lotSerialExpDate$, qty, isLotSerial)  
FUNCTION AddToPhysical(whse$, item$, bin$, lotSerial$, lotSerialExpDate$, qty, isLotSerial, delRow)  

Create record for new item the the IM_Physical table

ParameterDescription
whse$ [input, string] Warehouse Code to use for Item
item$ [input, string] Item code to create
bin$ [input, string] BinLocation to use for new item
lotSerial$ [input, string] Lot/Serial Number for new item
lotSerialExpDate$ [input, date] Lot/Serial Expiration Date for new item, if Track Expiration Date option is enabled for item
Qty [input, number] Quantity counted
isLotSerial [out, int] boolean used to indicate whether item is has valuation of Lot/Serial
delRow [out, int] *Optional* record number of row removed from memory file
ValueDescription
retSUCCESS(1) If create of new item record was successfully
retFAILURE(0) If create of new item record failed
FUNCTION CheckForMissingExpirationDates(firstMissing$)  

Checks through current line detail memory file for an expiration date that is missing if TrackLotSerExpiration is turned on and is required for item

ParameterDescription
firstMissing$ [output, string] key of the first row that is missing a date
Returns [integer] count of the number of rows missing dates, to be used for messaging
FUNCTION CheckLotSerDates(expDate$, lotSerNo$)  

Check Lot/Serial Expiration Date @prarm expDate$ [input, date] Lot Serial Expiration date to be used in calculation and comparisons

ParameterDescription
lotSerNo$ [input, string] Lot Serial Number being tested. This is used only in messaging
Returns [boolean]
ValueDescription
retWARNING(-1) If date is outside the range and the user HAS rights to override
retSUCCESS If there are no dates to check against or date is in acceptable range.
FUNCTION CheckPhysicalForItemCode(item$, whse$, bin$)  

Validates new item being added, to see if already frozen, in item table whether item is discontinued, check to see if item/warehouse combination is on file

ParameterDescription
item$ [input, string] Item code to be validated
whse$ [input, string] Warehouse Code to be use for Item/Warehouse table check
bin$ [input, string] BinLocation passed back if in Item/Warehouse table
Returns -2 Warning item is discontinued and not found in item/warehouse table
Returns -1 Warning if item is discontinued
Returns 0 Failure if item is not on file or already frozen
Returns 1 Success item is also in item/warehouse table and bin to be passed back
Returns 2 Success but item is new to the given warehouse.
FUNCTION CheckPhysicalForLotSerial(item$, whse$, lotSerial$)  
FUNCTION CheckTrackLotSerialExpiration(item$)  

Check TrackLotSerialExpiration for specified item code

ParameterDescription
item$ [input, string] Item code to check
Returns [boolean] -> returns retSUCCESS if TrackLotSerialExpiration or retFAILURE if NOT TrackLotSerialExpiration
FUNCTION ClearPhysical()  
FUNCTION ClearSetFiles()  
FUNCTION CommitRow()  
FUNCTION CreateWarehouseLock(whse$)  
FUNCTION GetCalculatedValues()  

To populate read-only/calculated fields value while perform VI Import/Export, Since they are not available in VI for processing

Returns [boolean] -> returns retSUCCESS if method success or retFAILURE if method failure
FUNCTION ResetLotSerialDates(resetDate$)  

This function will reset the LotSerialExpirationDate back to the given date.

ParameterDescription
resetDate$ [input, date] Date to reset the LotSerialExpirationDate back to
Returns Always returns retSUCCESS(1)
FUNCTION ResetRow(key$)  

Overrides base class function from SY_MaintSet. This is done to add logic to table index choice. key$ [input, string] key of record to reset

Returns [boolean] True if successful, False if method fails
FUNCTION SetKey(key$)  
FUNCTION SetPhysicalDefaults(tmpSortOption$)  

Set Physical Count Defaults. Will only write the defaults record if there have been no physical count records created from the Physical Count Worksheet. tmpSortOptions$ [input, string] selected sort option for entry

Returns [boolean] True if the defaults record is written, False if the defaults records already exists
FUNCTION ValidateGroupTrackExpiration()  

Validation group method to test whether expiration dates are being tracked for this item or at all for the system

Returns [boolean]
ValueDescription
retSUCCESS(1) If item is tracking expiration dates for lot/serial items
retFAILURE(0) If item is not tracking expiration dates or option is turned off in IM_Options

Properties inherited from: CI_Constant

itmREGULAR$, itmSPECIAL$, itmCHARGE$, itmCOMMENT$, itmMISC$, valSTANDARD$, valAVERAGE$, valFIFO$, valLIFO$, valLOT$, valSERIAL$, typFINISHEDGOODS$, typRAWMATERIALS$, typDISCONTINUED$, typKIT$, proMAKE$, proBUY$, proSUBCONTRACT$, proMAKETOORDER$, proBUYTOORDER$, tierFIFO$, tierLIFO$, tierLOT$, tierSERIAL$, upceanTYPENONE$, upceanTYPEOTHER$

Properties inherited from: CI_ItemCode_val

cItemTypes$, cAllowAliasItems, cAliasItemTypes$, cItemCodeDescCol$, cItemTypeCol$, cExtDescKeyCol$, ItemTypes$, AllowAliasItems, AliasItemTypes$, ExtendedDescriptionBusiness, ItemCodeDescCol$, AllowPhantom, AllowEngineering, AllowInactive, InvalidPurchase, IMIntegrated

Properties inherited from: SY_Maint

cActionWrite, cActionDelete, cActivityLogFilePrefix$, DocDateWarnDisplayed, DocDateWarnStatus, EditState, RecordChanged, FirstFailure$, DocumentTotal, ReadOnlyReason$, UDTValidation$, ViewOnly, CurrentPrecision, DocDateWarnForceOff, DocDateWarnObject, ScriptObject, ImportTest, SkipNullCheck$, AFSRequiredFields$

Properties inherited from: SY_MaintSet

FileChanged

Methods inherited from: CI_Constant

GetCalendarEndingDate(), GetDefaultExtendedDescriptionKey$(), UPCEANCheckDigit(), UPCEANFetch(), UPCEANUpdate()

Methods inherited from: CI_ItemCode_val

Write(), PERFORM CheckForAlias(), PERFORM CheckUseIn(), CheckValidBill(), ClassOverrideDescription(), ClassOverrideItemCode(), ClassValidateDescription(), ClassValidateItemCode(), ItemTypeSetDefaults(), PERFORM ItemTypeSetDefaults(), UpdateGridExtendedDescKey(), ValidateGroupNotCurrentItemType()

Methods inherited from: CI_ProductLine_val

ClassValidateProductLine()

Methods inherited from: CI_Warehouse_val

SetAllowInactiveRestrictedWhse(), ClassValidateWarehouse(), GetClassName$()

Methods inherited from: SY_Maint

ChangedRecordCompare(), ChangedRecordInfo(), Clear(), ClearRecord(), ConfirmDelete(), CopyFrom(), ExportToCSV(), GetColumnInfo(), GetColumnProperties$(), GetDefaults(), GetOrigRecord$(), GetPropertyValue(), GetValidationGroups$(), ResetDocDateWarnState(), SetCopyKeyValue(), SetDocDateWarnDisplayed(), SetDocDateWarnOff(), SetKey(), SetKeyValue(), SetPartialRecord(), SetRecord(), SetToReadOnly(), SetValue(), SetValues(), Write(), ActivityLogCreateFile(), ActivityLogPrepare(), ActivityLogSetMessage$(), ActivityLogWrite(), CallScript(), CheckForAdvancedFieldSettings(), CheckForScripts(), CheckNullRequiredField(), PERFORM ChildValidate(), ClassValidateDate(), ClassValidateTelephoneNo(), ClearSetFiles(), ColInfoInitAll(), ColInfoInitDefaults(), CommitRow(), GetPropertyCommon(), InitColInfo(), InitScriptEngine(), InitSearchForUpdate(), InitWorkTable(), IsColInIOList(), IsValid(), LoadColInfo(), OpenMainTable(), ParseExtField(), PreWriteScripts(), RemoveColToSkip(), ResetRow(), RetrieveColInfo(), SetDefaults(), SetFilter(), SetMode(), SetParentHandle(), SetValueNoValidate(), StoreColToSkip(), ValidateAll(), ValidateAllRecord(), ValidateColInfo(), ValidateRule()

Methods inherited from: SY_MaintSet

ClearSetFiles(), CommitRow(), QuickRowLoad(), ResetRow(), SeedDetailRow(), SetFilter(), SetMode()