Table 30152 "Shpfy Catalog"
Shopify · Microsoft.Integration.Shopify
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 14 connected objects and pages
Shopify · Microsoft.Integration.Shopify · captioned “Shopify Catalog” · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 30159 “Shpfy Catalogs” (1 Learn page), Page 30174 “Shpfy Market Catalogs” (1).
Properties
| Property | Value |
|---|---|
| Caption | Shopify Catalog |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Id | BigInteger | Specifies the unique identifier for the catalog in Shopify. | not editable; DataClassification SystemMetadata |
| 2 | Company SystemId | Guid | — | not editable; DataClassification SystemMetadata |
| 3 | Company Name | Text[500] | Specifies the name of the company that the catalog belongs to. | FlowField: lookup(“Shpfy Company”.Name where(SystemId = field(“Company SystemId”))) |
| 4 | Name | Text[500] | Specifies the catalog’s name. | not editable |
| 5 | Shop Code | Code[20] | — | TableRelation Table 30102 “Shpfy Shop” (Shpfy Shop); not editable |
| 6 | Customer Price Group | Code[10] | Specifies which Customer Price Group is used to calculate the prices in the catalog. | TableRelation Table 6 “Customer Price Group” (Customer Price Group); DataClassification SystemMetadata |
| 7 | Customer Discount Group | Code[20] | Specifies which Customer Discount Group is used to calculate the prices in the catalog. | TableRelation Table 340 “Customer Discount Group” (Customer Discount Group); DataClassification SystemMetadata |
| 8 | Gen. Bus. Posting Group | Code[20] | Specifies which Gen. Bus. Posting Group is used to calculate the prices in the catalog. | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group) |
| 9 | VAT Bus. Posting Group | Code[20] | Specifies which VAT. Bus. Posting Group is used to calculate the prices in the catalog. | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 10 | Tax Area Code | Code[20] | Specifies which Tax Area Code is used to calculate the prices in the catalog. | TableRelation Table 318 “Tax Area” (Tax Area) |
| 11 | Tax Liable | Boolean | Specifies if Tax Liable is used to calculate the prices in the catalog. | |
| 12 | VAT Country/Region Code | Code[10] | Specifies which VAT Country/Region Code is used to calculate the prices in the catalog. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 13 | Customer Posting Group | Code[20] | Specifies which Customer Posting Group is used to calculate the prices in the catalog. | TableRelation Table 92 “Customer Posting Group” (Customer Posting Group) |
| 14 | Prices Including VAT | Boolean | Specifies if the prices are Including VAT. | |
| 15 | Allow Line Disc. | Boolean | Specifies if line discount is allowed while calculating prices for the catalog. | |
| 16 | Sync Prices | Boolean | Specifies if the prices are synced to Shopify. | |
| 17 | Customer No. | Code[20] | Specifies the customer number assigned to the catalog. When a customer no. is assigned, ‘Customer Discount Group’, ‘Customer Price Group’, and ‘Allow Line Discount’ settings of the customer take precedence over catalog settings. | TableRelation Table 18 “Customer” |
| 18 | Catalog Type | Enum “Shpfy Catalog Type” | — | enum Enum 30169 “Shpfy Catalog Type” |
| 19 | Currency Code | Code[10] | Specifies the currency code for the catalog. | TableRelation Table 4 “Currency” |
Keys
- PK: Id, Company SystemId (clustered)
Procedures
3 local procedures, no public ones.
Triggers
OnDelete
Relations
- Customer No.: TableRelation Table 18 “Customer”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Shop Code: TableRelation Table 30102 “Shpfy Shop”
- Company Name: CalcFormula Table 30150 “Shpfy Company”
- Tax Area Code: TableRelation Table 318 “Tax Area”
- VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- Customer Discount Group: TableRelation Table 340 “Customer Discount Group”
- Currency Code: TableRelation Table 4 “Currency”
- Customer Price Group: TableRelation Table 6 “Customer Price Group”
- VAT Country/Region Code: TableRelation Table 9 “Country/Region”
- Customer Posting Group: TableRelation Table 92 “Customer Posting Group”
Pages and codeunits on this table
- Page 30159 “Shpfy Catalogs” (source table)
- Page 30174 “Shpfy Market Catalogs” (source table)
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Shpfy Catalog"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.