Legal Entity [sn_fin_legal_entity] table

The Legal Entity [sn_fin_legal_entity] table stores information about legal entities used in financial and organizational structures.

This table extends the Organization [sn_fin_organization] table and contains the following fields.

Field Data type Description Clearing account String Clearing account associated with the legal entity. Trading partner String Trading partner associated with the legal entity. Legal name String Legal name of the entity corresponding to the location in which it operates. Inherited from the Organization [sn_fin_organization] table. Display name String System-generated display name of the entity. Inherited from the Organization [sn_fin_organization] table. Global company Reference Main company to which this entity belongs at a global level. Inherited from the Organization [sn_fin_organization] table. Region Choice Region from which the entity operates. The options are AMS, APAC, EMEA, or LATAM. Inherited from the Organization [sn_fin_organization] table. Industry Reference Industry to which the entity belongs. Inherited from the Organization [sn_fin_organization] table. Local currency Reference Local currency of the entity. Inherited from the Organization [sn_fin_organization] table. Active Boolean Indicates whether the entity is active or onboarded. Inherited from the Organization [sn_fin_organization] table. Parent entity Reference Parent entity of this legal entity. Inherited from the Organization [sn_fin_organization] table. Street address String Street address of the entity’s location. Inherited from the Organization [sn_fin_organization] table. City String City of the entity’s location. Inherited from the Organization [sn_fin_organization] table. State / Province String State or province of the entity’s location. Inherited from the Organization [sn_fin_organization] table. Zip / Postal code String Zip or postal code of the entity’s location. Inherited from the Organization [sn_fin_organization] table. PO box number String PO box number to which supplier correspondence and payments are sent. Inherited from the Organization [sn_fin_organization] table. County / District String Specific area within a state or a province. Inherited from the Organization [sn_fin_organization] table. Country String Country of the entity’s location. Inherited from the Organization [sn_fin_organization] table. Website URL Official website of the entity. Inherited from the Organization [sn_fin_organization] table. Owner Reference User who owns this entity record. Inherited from the Organization [sn_fin_organization] table. ERP company code String Company code of the entity in the ERP system. Inherited from the Organization [sn_fin_organization] table. Status Choice Business relationship designated to the entity. Inherited from the Organization [sn_fin_organization] table. Reporting currency Reference Reporting currency of the entity. Inherited from the Organization [sn_fin_organization] table. Alternate currency Reference Alternate currency of the entity. Inherited from the Organization [sn_fin_organization] table. ERP source Reference ERP source system associated with the entity. Inherited from the Organization [sn_fin_organization] table. Image Image Image of the entity’s logo. Inherited from the Organization [sn_fin_organization] table.

Parent Topic:Primary data tables for Sourcing and Procurement Operations

Related topics

{Fixed Asset [sn_fin_fixed_asset] table}[]

{Finance Exchange Rates [sn_fin_fx_rate] table}[]

{Ledger Account table}[]

{GL rule [sn_fin_gl_rule] table}[]

{Threshold rule [sn_fin_gl_threshold_rule] table}[]

{Industry [sn_fin_industry] table}[]

{Ledger [sn_fin_ledger] table}[]

{Office Location table}[]

{Organization [sn_fin_organization] table}[]

{Approval Group [sn_shop_approval_group] table}[]

{Approval Rule [sn_shop_approval_rule] table}[]

{Approval Rule Composition table}[]

{Attribute [sn_shop_attribute] table}[]

{Attribute Set [sn_shop_attribute_set] table}[]

{Attribute Type [sn_shop_attribute_type] table}[]

{Delivery Location [sn_shop_delivery_location] table}[]

{Job Code [sn_shop_job_code] table}[]

{Payment Terms [sn_shop_payment_term] table}[]

{Price Break [sn_shop_price_break] table}[]

{Pricing [sn_shop_m2m_product_contract] table}[]

{Product group [sn_shop_product_group] table}[]

{Product Visuals [sn_shop_supplier_product_artifact] table}[]

{Shipping methods [sn_shop_shipping_method] table}[]