Other table in Microsoft Dynamics 365 Business Central. 38 fields, 0 records in Cronus demo.
The Hist. Sales Trx. Header table (ID 40902) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 38 fields, with a primary key of Primary Key. 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: Primary Key.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Primary Key PK | Integer | Normal | |
| 2 | No. | Code | Normal | |
| 3 | Sales Type | Option | Normal | |
| 4 | Sales Trx. Status | Option | Normal | |
| 5 | Currency Code | Code | Normal | |
| 6 | Sub Total | Decimal | Normal | |
| 7 | Tax Amount | Decimal | Normal | |
| 8 | Trade Discount Amount | Decimal | Normal | |
| 9 | Freight Amount | Decimal | Normal | |
| 10 | Miscellaneous Amount | Decimal | Normal | |
| 11 | Payment Received Amount | Decimal | Normal | |
| 12 | Discount Taken Amount | Decimal | Normal | |
| 13 | Total | Decimal | Normal | |
| 14 | Document Date | Date | Normal | |
| 15 | Due Date | Date | Normal | |
| 16 | Actual Ship Date | Date | Normal | |
| 17 | Customer No. | Text | Normal | |
| 18 | Customer Name | Text | Normal | |
| 19 | Ship-to Code | Code | Normal | |
| 20 | Ship-to Name | Text | Normal | |
| 21 | Ship-to Address | Text | Normal | |
| 22 | Ship-to Address 2 | Text | Normal | |
| 23 | Ship-to City | Text | Normal | |
| 24 | Ship-to State | Text | Normal | |
| 25 | Ship-to Zipcode | Text | Normal | |
| 26 | Ship-to Country | Text | Normal | |
| 27 | Contact Person Name | Text | Normal | |
| 28 | Salesperson No. | Code | Normal | |
| 29 | Sales Territory | Text | Normal | |
| 30 | Customer Purchase No. | Code | Normal | |
| 31 | Original No. | Code | Normal | |
| 32 | Ship Method | Text | Normal | |
| 33 | Audit Code | Code | 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 |