Shpfy Order Line #30119

Other table in Microsoft Dynamics 365 Business Central. 28 fields, 0 records in Cronus demo.

The Shpfy Order Line table (ID 30119) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 28 fields, with a primary key of Shopify Order Id, Line Id. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Shopify Order Id, Line Id.

All fields (28)

Shpfy Order Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Shopify Order Id PK	BigInteger	Normal
2	Line Id PK	BigInteger	Normal
3	Shopify Product Id	BigInteger	Normal
4	Description	Text	Normal
5	Quantity	Decimal	Normal
6	Unit Price	Decimal	Normal
7	Discount Amount	Decimal	Normal
8	Shopify Variant Id	BigInteger	Normal
9	Variant Description	Text	Normal
11	Fulfillment Service	Text	Normal
12	Taxable	Boolean	Normal
13	Gift Card	Boolean	Normal
14	Product Exists	Boolean	Normal
15	Fulfillable Quantity	Decimal	Normal
16	Tip	Boolean	Normal
17	Location Id	BigInteger	Normal
18	Presentment Unit Price	Decimal	Normal
19	Presentment Discount Amount	Decimal	Normal
20	Delivery Method Type	Option	Normal
21	Weight	Decimal	Normal
1000	Item No.	Code	Normal	→ Item #27
1001	Variant Code	Code	Normal	→ Item Variant #5401
1002	Unit of Measure Code	Code	Normal	→ Item Unit of Measure #5404
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (4)

Tables referenced by fields on the Shpfy Order Line table through TableRelation properties.

Item

#27 · Inventory · via Item No.

Item Variant

#5401 · Other · via Variant Code

Item Unit of Measure

#5404 · Other · via Unit of Measure Code