Class IM_ItemWarehouse_svc

Services routines for Item by warehouse

Constructor

Gets the column length for itemcode. Gets the QuantityAvailableToInclude parameter.

Inherits

SY_Service

Properties

LOCAL cMainTable$="IM_ItemWarehouse"  
[constant, string] Used by service object. Sets the main table name that will be opened on cFH
LOCAL cIsSysDB  
[constant, boolean] Used by service object. Set to false because this is not a system database

Methods

FUNCTION AdjustQuantity(item$, whse$, record$, iolist$)  

Checks to see if item exists in other warehouses than that passed in

ParameterDescription
item$ [input, string] Item code
whse$ [input, string] warehouse
record$ [input, string] warehouse
iolist$ [input, string] warehouse
Returns [boolean] Success or Failure
FUNCTION CalcQuantityAvailable(item$, whse$)  

Calculates an item's quantity available for a given warehouse

ParameterDescription
item$ [input, string] Item code
whse$ [input, string] warehouse
Returns [integer] Quantity available
FUNCTION CalcQuantityOnHand(itemCode$)  

Calculates an item's quantity on hand from the qtys in all warehouses.

ParameterDescription
itemCode$ [input, string] Item code
Returns [integer] Quantity on hand from all warehouses
FUNCTION CheckAlternateWarehouses(item$, whse$)  

Checks to see if item exists in other warehouses than that passed in

ParameterDescription
item$ [input, string] Item code
whse$ [input, string] warehouse
Returns [boolean] True is if does, false if it doesn't
FUNCTION CheckNonDefaultQuantities()  

Checks to see if there are any quantities belonging to any warehouses other than '000'.

Returns [boolean] Success or Failure

Properties inherited from: SY_Service

BOF, CurrentBrowseIndex$, CurrentIndex$, EOF, SecurityAccess

Methods inherited from: SY_Service

BindVariable(), CheckMainTable(), Clear(), Find(), FindById(), GetChildHandle(), GetChildKeyReference$(), GetColumns$(), GetDataSources$(), GetDataSourcesAddl$(), GetJson$(), GetKey$(), GetKeyColumns$(), GetKeyPadded$(), GetPartialRecord(), GetRecord(), GetRecordCount(), GetRecordEx(), GetResultSets(), GetTable$(), GetTablePath$(), GetValue(), GetValues(), IsValid(), MoveFirst(), MoveLast(), MoveNext(), MovePrevious(), ReadAdditional(), SetBrowseFilter(), SetBrowseIndex(), SetCacheMode(), SetIndex(), SetKeyValue(), SetParentColumns(), SetParentHandle(), SetUIHandle(), PERFORM ClearEditRcd(), FormatJson$(), GetAddlDataSources(), GetDateColumns$(), InitChildCollection(), MoveFirstLast(), MoveNextPrevious(), OpenMainTable(), ParseKeyDef(), PrepareKeyDef(), ReadRec(), ResolveColumnList$(), SetControls(), SetCurrentKey(), UseKeyColl()