Other table in Microsoft Dynamics 365 Business Central. 38 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Id.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Id PK | BigInteger | Normal | |
| 2 | ProductId | BigInteger | Normal | |
| 3 | CreatedAt | DateTime | Normal | |
| 4 | Updated At | DateTime | Normal | |
| 5 | Available For Sales | Boolean | Normal | |
| 6 | Barcode | Text | Normal | |
| 7 | Compare at Price | Decimal | Normal | |
| 8 | Display Name | Text | Normal | |
| 9 | Inventory Policy | Option | Normal | |
| 10 | Position | Integer | Normal | |
| 11 | Price | Decimal | Normal | |
| 12 | SKU | Text | Normal | |
| 13 | Tax Code | Code | Normal | |
| 14 | Taxable | Boolean | Normal | |
| 15 | Title | Text | Normal | |
| 16 | Weight | Decimal | Normal | |
| 17 | Option 1 Name | Text | Normal | |
| 18 | Option 1 Value | Text | Normal | |
| 19 | Option 2 Name | Text | Normal | |
| 20 | Option 2 Value | Text | Normal | |
| 21 | Option 3 Name | Text | Normal | |
| 22 | Option 3 Value | Text | Normal | |
| 23 | Unit Cost | Decimal | Normal | |
| 24 | Image Id | BigInteger | Normal | |
| 100 | Shop Code | Code | Normal | → Shpfy Shop #30102 |
| 101 | Item SystemId | GUID | Normal | |
| 102 | Item Variant SystemId | GUID | Normal | |
| 103 | Last Updated by BC | DateTime | Normal | |
| 104 | Item No. ⚡ FLOW | Code | FlowField | |
| 105 | Variant No. ⚡ FLOW | Code | FlowField | |
| 106 | UoM Option Id | Integer | Normal | |
| 107 | Mapped By Item | Boolean | Normal | |
| 108 | Image Hash | Integer | Normal | |
| 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 |
Tables referenced by fields on the Shpfy Variant table through TableRelation properties.