Table 30121 "Shpfy Orders to Import"

Shopify · Microsoft.Integration.Shopify · captioned “Shopify Orders to Import” · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 30121 “Shpfy Orders to Import” (1 Learn page).

Properties

Property	Value
Caption	Shopify Orders to Import
Access	Internal
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	Entry No.	Integer	—	not editable; AutoIncrement; DataClassification SystemMetadata
2	Shop Id	Integer	—	not editable
3	Shop Code	Code[20]	Specifies the Shopify Shop from which the order originated. via Page 30121 “Shpfy Orders to Import”	TableRelation Table 30102 “Shpfy Shop” (“Shpfy Shop”.Code where(“Shop Id” = field(“Shop Id”)))
4	Id	BigInteger	Specifies the id for the order in Shopify. via Page 30121 “Shpfy Orders to Import”	not editable
5	Order No.	Text[50]	Specifies the order number from Shopify. via Page 30121 “Shpfy Orders to Import”
6	Created At	DateTime	Specifies the autogenerated date and time when the order was created in Shopify. via Page 30121 “Shpfy Orders to Import”	not editable
7	Updated At	DateTime	Specifies the date and time when the order was last modified in Shopify. via Page 30121 “Shpfy Orders to Import”	not editable
8	Test	Boolean	Specifies if this is an test order. via Page 30121 “Shpfy Orders to Import”	not editable
9	Confirmed	Boolean	Specifies whether the order has been confirmed. via Page 30121 “Shpfy Orders to Import”	not editable
10	Fully Paid	Boolean	Specifies the order from Shopify is fully paid. via Page 30121 “Shpfy Orders to Import”	not editable
11	Unpaid	Boolean	Specifies the order from Shopify is unpaid. via Page 30121 “Shpfy Orders to Import”	not editable
12	Risk Level	enum “Shpfy Risk Level”	—	obsolete Removed 28.0; #if not CLEANSCHEMA28; enum Enum 30126 “Shpfy Risk Level”; not editable
13	Financial Status	enum “Shpfy Financial Status”	Specifies the status of payments associated with the order. Valid values are: pending, authorized, partially_paid, paid, partially_refunded, refunded, voided. via Page 30121 “Shpfy Orders to Import”	enum Enum 30117 “Shpfy Financial Status”; not editable
14	Fulfillment Status	enum “Shpfy Order Fulfill. Status”	Specifies the order’s status in terms of fulfilled line items. Valid values are: Fulfilled, null, partial, restocked. via Page 30121 “Shpfy Orders to Import”	enum Enum 30113 “Shpfy Order Fulfill. Status”; not editable
15	Order Amount	Decimal	Specifies the sum of the line amounts on all lines in the document minus any discount amounts. via Page 30121 “Shpfy Orders to Import”	not editable
16	Currency Code	Code[10]	Specifies the currency code from Shopify. via Page 30121 “Shpfy Orders to Import”	not editable
17	Total Quantity of Items	Integer	Specifies the sum of the line quantities on all lines in the document. via Page 30121 “Shpfy Orders to Import”	not editable
18	Number of Order Lines	Integer	—	not editable
19	Tags	Text[2048]	Specifies the tags that are set on this Shopify order. via Page 30121 “Shpfy Orders to Import”	not editable
20	Attribute Key Filter	Text[100]	—	FlowFilter
21	Attribute Key Exists	Boolean	—	FlowField: exist(“Shpfy Order Attribute” where(“Order Id” = field(Id), “Key” = field(“Attribute Key Filter”)))
22	Channel Name	Text[100]	Specifies the name of the channel where you sell your products. A channel can be a platform or a marketplace such as an online store or POS. via Page 30121 “Shpfy Orders to Import”	TableRelation Table 30160 “Shpfy Sales Channel” (“Shpfy Sales Channel”.Name where(“Shop Code” = field(“Shop Code”))); not editable; DataClassification SystemMetadata
23	Purchasing Entity	Enum “Shpfy Order Purchasing Entity”	Specifies the purchasing entity from Shopify. via Page 30121 “Shpfy Orders to Import”	enum Enum 30150 “Shpfy Order Purchasing Entity”; not editable
24	High Risk	Boolean	—	not editable; DataClassification SystemMetadata
25	Sell-to Country/Region Code	Code[20]	—
26	Ship-to Country/Region Code	Code[20]	—
27	Bill-to Country/Region Code	Code[20]	—
28	VAT Amount	Decimal	—	DataClassification SystemMetadata
29	Presentment VAT Amount	Decimal	—	DataClassification SystemMetadata
30	Channel Liable Taxes	Boolean	Specifies if any tax line on the order is liable to be collected by the sales channel. via Page 30121 “Shpfy Orders to Import”	not editable; DataClassification SystemMetadata
100	Import Action	Enum “Shpfy Import Action”	Specifies the action to take for this order. via Page 30121 “Shpfy Orders to Import”	enum Enum 30100 “Shpfy Import Action”; not editable
102	Has Error	Boolean	Specifies if this order have processing errors. via Page 30121 “Shpfy Orders to Import”	not editable; DataClassification SystemMetadata
103	Error Message	Blob	—	DataClassification SystemMetadata
104	Error Call Stack	Blob	—	DataClassification SystemMetadata

Keys

PK: Entry No. (clustered)
Idx1: Id, Shop Id

Procedures

SetErrorInfo() (internal): Description for SetErrorMessage.
GetErrorMessage(): Text (internal): Description for GetErrorMessage.
GetErrorCallStack(): Text (internal): Description for GetErrorCallStack.

Relations

Shop Code: TableRelation Table 30102 “Shpfy Shop”
Attribute Key Exists: CalcFormula Table 30116 “Shpfy Order Attribute”
Channel Name: TableRelation Table 30160 “Shpfy Sales Channel”

Pages and codeunits on this table

Page 30121 “Shpfy Orders to Import” (source table)
Codeunit 30161 “Shpfy Import Order” (codeunit runs on it)

Deprecations

field Risk Level: Removed 28.0 (#if not CLEANSCHEMA28), “This field is not imported. Use field”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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 Orders to Import"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.