Sales Price and Line Disc Buff #1304

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

26
Fields
0
Records
14
Primary key
0
FlowFields
4
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Code, Sales Code, Currency Code, Starting Date, Sales Type, Minimum Quantity, Type, Line Type, Loaded Item No., Loaded Disc. Group, Loaded Customer No., Loaded Price Group, Unit of Measure Code, Variant Code.

All fields (26)

Sales Price and Line Disc Buff — FIELDS
NO.FIELDTYPECLASSRELATION
1 Code PK Code Normal
2 Sales Code PK Code Normal
3 Currency Code PK Code Normal → Currency #4
4 Starting Date PK Date Normal
5 Line Discount % Decimal Normal
6 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
21 Type PK Option Normal
1300 Line Type PK Option Normal
1301 Loaded Item No. PK Code Normal
1302 Loaded Disc. Group PK Code Normal
1303 Loaded Customer No. PK Code Normal
1304 Loaded Price Group PK Code Normal
5400 Unit of Measure Code PK Code Normal
5700 Variant Code PK Code Normal
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 (3)

Tables referenced by fields on the Sales Price and Line Disc Buff table through TableRelation properties.

Currency
#4 · General Ledger · via Currency Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Gr. (Price)