loc_objid | inv_locatn | objid | Inventory location internal record number | 3 (UNIQUE) |
location_name | inv_locatn | location_name | For physical inventory locations, the name of the location. For GL accounts, the account number | |
location_descr | inv_locatn | location_descr | Description of the inventory location or GL account | |
location_type | inv_locatn | location_type | User-defined types of physical inventory location | |
site_id | site | site_id | Site ID number assigned according to auto-numbering definition | |
site_name | site | name | Site name | |
site_objid | site | objid | Site internal record number | |
reports_to_loc | inv_locatn | reports_to_loc | The parent inventory location name or, if GL account, the parent GL account number | |
role_name | inv_role | role_name | Name of the inventory role | |
gl_acct_no | inv_locatn | gl_acct_no | If the current object is a physical location, the GL account number. If a GL account, the field is either empty, or contains the parent GL account number | |
inv_class | inv_locatn | inv_class | 0=inventory location, 1=capital GL account, 2=expense GL account | |
mdbk | site | mdbk | Used, transiently, to hold the translation of inv_class | |
rank | inv_role | rank | For servicing inventory locations, ranks the order in which locations should be displayed for a given site in the Pick form; e.g., 0=not applicable, 1=first displayed, 2=second displayed, etc., default=0 | |
site_type | site | site_type | Mnemonic representation of the integer site type field | |
region | site | region | Region to which the site belongs | |
address | address | address | Line 1 of address which includes street number, street name, office, building, or suite number, etc | |
city | address | city | The city for the specified address | |
state | address | state | The state for the specified address | |
zip | address | zipcode | The state for the specified address | |
active | inv_locatn | active | Indicates whether the current part authorization is active; i.e., 0=inactive, 1=active, default=1 | |