Sales Price #7002

Pricing & Discounts table in Microsoft Dynamics 365 Business Central. 20 fields, 0 records in Cronus demo.

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: Item No., Sales Code, Currency Code, Starting Date, Sales Type, Minimum Quantity, Unit of Measure Code, Variant Code.

All fields (20)

Sales Price — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Item No. PK	Code	Normal	→ Item #27
2	Sales Code PK	Code	Normal
3	Currency Code PK	Code	Normal	→ Currency #4
4	Starting Date PK	Date	Normal
5	Unit Price	Decimal	Normal
7	Price Includes VAT	Boolean	Normal
10	Allow Invoice Disc.	Boolean	Normal
11	VAT Bus. Posting Gr. (Price)	Code	Normal	→ VAT Business Posting Group #323
13	Sales Type PK	Option	Normal
14	Minimum Quantity PK	Decimal	Normal
15	Ending Date	Date	Normal
721	Coupled to Dynamics 365 Sales ⚡ FLOW	Boolean	FlowField
5400	Unit of Measure Code PK	Code	Normal	→ Item Unit of Measure #5404
5700	Variant Code PK	Code	Normal	→ Item Variant #5401
7001	Allow Line Disc.	Boolean	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

Related tables (6)

Tables referenced by fields on the Sales Price table through TableRelation properties.

Item

#27 · Inventory · via Item No.

Currency

#4 · General Ledger · via Currency Code

VAT Business Posting Group

#323 · Other · via VAT Bus. Posting Gr. (Price)

Item Unit of Measure

#5404 · Other · via Unit of Measure Code

Item Variant

#5401 · Other · via Variant Code