Table 30151 Shpfy Company Location

Shopify Connector, Microsoft.Integration.Shopify

src/Apps/W1/Shopify/App/src/Companies/Tables/ShpfyCompanyLocation.Table.al154 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Integration.Shopify;using Microsoft.Sales.Customer;/// <summary>/// Table Shpfy Company Location (ID 30151)./// </summary>table 30151 "Shpfy Company Location"{    Caption = 'Shopify Company Location';    DataClassification = CustomerContent;    fields    {        field(1; Id; BigInteger)        {            Caption = 'Id';            DataClassification = SystemMetadata;            Editable = false;            ToolTip = 'Specifies the unique identifier for the company location in Shopify.';        }        field(2; "Company SystemId"; Guid)        {            Caption = 'Company SystemId';            DataClassification = SystemMetadata;            Editable = false;            ToolTip = 'Specifies the unique identifier for the company in Shopify.';        }        field(3; Address; Text[100])        {            Caption = 'Address';            ToolTip = 'Specifies the address of the company location.';        }        field(4; "Address 2"; Text[100])        {            Caption = 'Address 2';            ToolTip = 'Specifies the second address line of the company location.';        }        field(5; Zip; Code[20])        {            Caption = 'Zip';            ToolTip = 'Specifies the postal code of the company location.';        }        field(6; City; Text[50])        {            Caption = 'City';            ToolTip = 'Specifies the city of the company location.';        }        field(7; "Country/Region Code"; Code[2])        {            Caption = 'Country/Region Code';            ToolTip = 'Specifies the country/region code of the company location.';        }        field(8; "Phone No."; Text[30])        {            Caption = 'Phone No.';            ToolTip = 'Specifies the phone number of the company location.';        }        field(9; Name; Text[100])        {            Caption = 'Name';            Editable = false;            ToolTip = 'Specifies the name of the company location.';        }        field(10; "Province Code"; Code[10])        {            Caption = 'Province';            ToolTip = 'Specifies the province code of the company location.';        }        field(11; "Province Name"; Text[50])        {            Caption = 'Province Name';            ToolTip = 'Specifies the province name of the company location.';        }        field(12; "Tax Registration Id"; Text[150])        {            Caption = 'Tax Registration Id';            ToolTip = 'Specifies the tax registration identifier of the company location.';        }        field(13; "Recipient"; Text[100])        {            Caption = 'Company/Attention';            ToolTip = 'Specifies the recipient name for the company location.';        }        field(14; "Default"; Boolean)        {            Caption = 'Default';            ToolTip = 'Specifies whether the location is the default location for the company.';        }        field(15; "Shpfy Payment Terms Id"; BigInteger)        {            Caption = 'Shopify Payment Terms Id';            ToolTip = 'Specifies the Shopify Payment Terms Id which is mapped with Customer''s Payment Terms.';        }        field(16; "Company Name"; Text[500])        {            Caption = 'Company Name';            FieldClass = FlowField;            CalcFormula = lookup("Shpfy Company".Name where(SystemId = field("Company SystemId")));            ToolTip = 'Specifies the name of the company.';        }        field(17; "Shpfy Payment Term"; Text[150])        {            Caption = 'Shopify Payment Term';            FieldClass = FlowField;            CalcFormula = lookup("Shpfy Payment Terms".Description where(Id = field("Shpfy Payment Terms Id")));            ToolTip = 'Specifies the description of the Shopify Payment Term.';        }        field(18; "Sell-to Customer No."; Code[20])        {            Caption = 'Sell-to Customer No.';            TableRelation = Customer;            ToolTip = 'Specifies the customer number, which is used to set the Shopify Orders Sell-to value when importing orders from Shopify.';            trigger OnValidate()            begin                if "Sell-to Customer No." = '' then                    Clear("Bill-to Customer No.");            end;        }        field(19; "Bill-to Customer No."; Code[20])        {            Caption = 'Bill-to Customer No.';            TableRelation = Customer;            ToolTip = 'Specifies the customer number, which is used to set the Shopify Orders Bill-to value when importing orders from Shopify.';            trigger OnValidate()            begin                TestField("Sell-to Customer No.");            end;        }        field(20; "Customer Id"; Guid)        {            Caption = 'Customer Id';            DataClassification = SystemMetadata;            ToolTip = 'Specifies the unique identifier of the customer associated with the company location.';            Editable = false;        }    }    keys    {        key(PK; Id)        {            Clustered = true;        }        key(Idx1; "Company SystemId") { }    }}