Other table in Microsoft Dynamics 365 Business Central. 20 fields, 0 records in Cronus demo.
The GPSOPDistributionWorkHist table (ID 4070) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 20 fields, with a primary key of SOP Type, SOP Number, Sequence Number. 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: SOP Type, SOP Number, Sequence Number.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | SOP Type PK | Option | Normal | |
| 2 | SOP Number PK | Text | Normal | |
| 3 | Sequence Number PK | Integer | Normal | |
| 4 | Distribution Type | Option | Normal | |
| 5 | Distribution Reference | Text | Normal | |
| 6 | Account Index | Integer | Normal | |
| 7 | Debit Amount | Decimal | Normal | |
| 8 | Originating Debit Amount | Decimal | Normal | |
| 9 | Credit Amount | Decimal | Normal | |
| 10 | Originating Credit Amount | Decimal | Normal | |
| 11 | Currency Index | Integer | Normal | |
| 12 | TRX Source | Text | Normal | |
| 13 | Posted | Boolean | Normal | |
| 14 | Contract Exchange Rate | Decimal | Normal | |
| 15 | DEX_ROW_ID | 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 |