Other table in Microsoft Dynamics 365 Business Central. 11 fields, 0 records in Cronus demo.
The Sales Prepayment % table (ID 459) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 11 fields, with a primary key of Item No., Sales Type, Sales Code, Starting Date. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Item No., Sales Type, Sales Code, Starting Date.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Item No. PK | Code | Normal | → Item #27 |
| 2 | Sales Type PK | Option | Normal | |
| 3 | Sales Code PK | Code | Normal | |
| 4 | Starting Date PK | Date | Normal | |
| 5 | Ending Date | Date | Normal | |
| 6 | Prepayment % | Decimal | 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 Sales Prepayment % table through TableRelation properties.