Organization [sn_fin_organization] table
The Organization [sn_fin_organization] table stores information about organizational entities such as companies and legal entities.
This table contains the following fields.
| Field | Data type | Description |
|---|---|---|
| Type | Choice | Table class name that indicates the specific type of organization record. |
| Display name | String | System-generated display name of the organization. |
| Legal name | String | Legal name of the entity corresponding to the location in which it operates. |
| Short description | String | Short description of the organization. |
| Global company | Reference | Main company to which this entity belongs at a global level. |
| Region | Choice | Region from which the entity operates. The options are AMS, APAC, EMEA, or LATAM. |
| Industry | Reference | Industry to which the entity belongs. |
| Local currency | Reference | Local currency of the entity. |
| Active | Boolean | Indicates whether the entity is active. |
| Parent entity | Reference | Parent entity of this organization. |
| Street address | String | Street address of the entity's location. |
| City | String | City of the entity's location. |
| State / Province | String | State or province of the entity's location. |
| Zip / Postal code | String | Zip or postal code of the entity's location. |
| PO box number | String | PO box number to which supplier correspondence and payments are sent. |
| County / District | String | Specific area within a state or a province. |
| Country | String | Country of the entity's location. |
| Website | URL | Official website of the entity. |
| Owner | Reference | User who owns this organization record. |
| ERP company code | String | Company code of the entity in the ERP system. |
| Status | Choice | Business relationship designated to the entity. |
| Reporting currency | Reference | Reporting currency of the entity. |
| Alternate currency | Reference | Alternate currency of the entity. |
| ERP source | Reference | ERP source system associated with the entity. |
| Image | Image | Image of the entity's logo. |
| Is transform map running? | Boolean | Internal flag that indicates whether a transformation is in progress. |