File Name
Syntax
MakeLocation(REF type: STRING, REF location_name: STRING)
Parameters
type - type of location (default or not)
location_name - location name
Returns
Nothing
Side Effects
None
Description
This procedure creates a location record.
Dialog Forms Called
None
File Name
Syntax
MapFieldToClassAttrib(REF attributeList: LIST OF Attribute_DefRec, VAL attrib: STRING, VAL attrib_value: STRING, REF PList: LIST OF PhysAttribRec, REF IList: LIST OF IsaAttribRec): BOOLEAN
Parameters
attributeList - list of attribute records
attrib - attribute name
attrib_value - attribute value
PList - pm attribute list
IList - i attribute list
Returns
Boolean: success or failure
Side Effects
None
Description
This procedure takes the attribute list and splits it into a pm attribute list and an i attribute list, for use when mapping attribute values from CSV files to the database table columns.
Dialog Forms Called
None
File Name
Syntax
MapFieldToInvContract(VAL attrib: STRING, VAL attrib_value: STRING, REF ContractList: LIST OF ContractRec, REF KList: LIST OF STRING, REF VList: LIST OF STRING, VAL flag: ValidFlagRec, REF inv: IS_InventoryRec ): BOOLEAN
Parameters
attrib - attribute name
attrib_value - attribute value
contractlist - list of contract records
KList - list of contract numbers
VList - list of contact values
flag - valid flag record for secure mode
inv - inventory record
Returns
Boolean: success or failure
Side Effects
None
Description
This procedure takes vendor and contract column assignments and maps the CSV data to the database table columns.
Dialog Forms Called
None
File Name
Syntax
MapFieldToInventory(VAL attrib: STRING, VAL attrib_value: STRING, REF Inv: IS_InventoryRec, REF PeopleList: LIST OF PeopleRec, REF ConnectionList: LIST OF ConnectionRec, VAL flag: ValidFlagRec): BOOLEAN
Parameters
attrib - attribute name
attrib_value - attribute value
inv - inventory record
PeopleList - people record list
ConnectionList - connection record list
flag - valid record for secure mode
Returns
Boolean: success or failure
Side Effects
None
Description
This procedure takes inventory column assignments and maps the CSV data to the database table columns for inventory, people, and connections.
Dialog Forms Called
None
File Name
Syntax
MapFieldToValuation(VAL attrib: STRING, VAL attrib_value: STRING, REF aVAl: ValuationRec): BOOLEAN
Parameters
attrib - attribute name
attrib_value - attribute value
aVal - valuation record
Returns
Boolean: success or failure
Side Effects
None
Description
This procedure takes valuation column assignments and maps the CSV data to the database table columns.
Dialog Forms Called
None