Locations CSV files
Understand the correct structure for a CSV file that contains location data.
| Attribute 1 | Attribute 2 | Attribute 3 | Attribute 4 |
|---|---|---|---|
| SRM_SaaS_ES |
TLSMLOCES |
Use AddChange by default. Add and Change are also supported. |
EN |
| Location attribute 1 |
Location attribute 2 |
Location attribute 3 |
Location attribute 4... |
| Data for location attribute 1 |
Data for location attribute 2 |
Data for location attribute 3 |
Data for location attribute 4... |
If you use a spreadsheet program such as Microsoft Excel to create your CSV file, the program adds a comma for each blank cell. To avoid errors when importing the data, use a text editor to delete the extra commas in the first row of the CSV file.
Required attributes
| Attribute | Description |
|---|---|
| AUTOWOGEN |
Flag that indicates whether to start the wogen process when meter frequency is reached for a location |
| CHANGEBY |
Last Changed by user |
| CHANGEDATE |
Last Change date |
| DISABLED |
Is this record active? |
| ISDEFAULT |
Specifies whether this storeroom is the default storeroom for the site. When this value is set to 1 (yes), Maximo reserves items for this storeroom if a job plan or work order does not specify a storeroom. When this value is set to 0 (no, The default setting), this storeroom is not used as the default storeroom when work orders are generated with no storeroom information. |
| LOCATION |
Storeroom where the item is stored. |
| LOCATIONSID |
Unique Identifier |
| ORGID |
Organization Identifier |
| STATUSDATE |
Date the Locations status was last changed. |
| TYPE |
Type of location |
| USEINPOPR |
Specifies whether this storeroom can be used to supply and reserve inventory items and tools for use with internal purchase requisitions and internal purchase orders. If the check box is selected, you can order and reserve items or tools from this storeroom on internal POs and PRs. If the check box is cleared (the default), this storeroom cannot be used to supply items or tools internally. |
Optional attributes
| Attribute | Description |
|---|---|
| BILLTOADDRESSCODE |
Default Bill To Address Code |
| BILLTOLABORCODE |
Default Bill To Labor Code |
| CLASSSTRUCTUREID |
Class Structure Identifier |
| CONTROLACC |
Default GL account that Maximo applies to items in this storeroom during GL transactions such as issues, returns, receipts, transfers, and adjustments. |
| CURVARACC |
Account containing the differences between the PO price and the invoice price that result from changes in the exchange rate. If, as a result of an exchange rate change, the invoice cost in base currency exceeds the receipt cost in base currency, then the transaction amount is positive. If the invoice cost in base currency is less than the receipt cost in base currency, then the transaction amount is negative. This account is paired with the GL control account; when the currency variance account's value decreases, the inventory control account's value decreases. Variance accounts track price variances by storeroom location, not by item. |
| DESCRIPTION |
Describes the location. |
| EXTERNALREFID |
External Reference ID |
| GISPARAM1 |
Graphical Information System interface parameter 1 |
| GISPARAM2 |
Graphical Information System interface parameter 2 |
| GISPARAM3 |
Graphical Information System interface parameter 3 |
| GLACCOUNT |
Default GL Account |
| INTLABREC |
Internal Labor Control GL Account |
| INVCOSTADJACC |
Account that tracks changes in either the average price or the standard price from manual inventory price adjustments. These changes result from using the Adjust Average Cost and Adjust Standard Cost actions, respectively. |
| INVOICEVARACC |
Debit account used to track variances in the price, expressed in the vendor's currency, between receipt and invoice for this storeroom. The transaction amount is positive when the invoice line cost is greater than the receipt cost. |
| OLDCONTROLACC |
Last inventory/transit control account. |
| OLDINVCOSTADJACC |
Last inventory cost adjustment account for manual inventory price adjustments. |
| OLDSHRINKAGEACC |
Last shrinkage cost account for manual adjustment for inventory quantity. |
| OWNERSYSID |
Owner System ID |
| PURCHVARACC |
Account used to track fluctuations in purchase costs for items (or the variance between PO and original Last and Standard price). Not used with any MAXIMO transactions. Click the Select Value button to choose a GL account. |
| RECEIPTVARACC |
Debit account to track the variance between PO and Invoice exchange rates. This account contains the differences between the inventory standard cost and the receipt cost (specific to the storeroom) for any items in the associated storeroom location. It is used for standard costing only. |
| SENDERSYSID |
Column used by ERP-Integration (APIs) |
| SERVICEADDRESSCODE |
Service Address Code |
| SHIPTOADDRESSCODE |
Default address code to ship items to when reorders are processed for this storeroom. |
| SHIPTOLABORCODE |
Default labor code to ship items to when reorders are processed for this storeroom. |
| SHRINKAGEACC |
Credit account used when manually adjusting the inventory quantity. The transaction is positive when the actual inventory quantity is greater than the MAXIMO-calculated current balance. |
| SITEID |
Specifies the site where this location or storeroom resides. |
| SOURCESYSID |
Source System ID |
| STATUS |
STATUS |
| TOOLCONTROLACC |
Default debit account for capitalized tools. |