Other table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.
The GPSOPBinQuantityWorkHist table (ID 4067) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 17 fields, with a primary key of SOP Number, SOP Type, Line Item Sequence, Component Sequence, 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 Number, SOP Type, Line Item Sequence, Component Sequence, Sequence Number.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | SOP Number PK | Text | Normal | |
| 2 | SOP Type PK | Option | Normal | |
| 3 | Line Item Sequence PK | Integer | Normal | |
| 4 | Component Sequence PK | Integer | Normal | |
| 5 | Sequence Number PK | Integer | Normal | |
| 6 | Item Number | Text | Normal | |
| 7 | Location Code | Text | Normal | |
| 8 | Bin | Text | Normal | |
| 9 | QTY Type | Option | Normal | |
| 10 | QTY | Decimal | Normal | |
| 11 | Posted | Boolean | Normal | |
| 12 | 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 |