Other table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.
The GP Item Transactions table (ID 4104) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 17 fields, with a primary key of Item Number, Transaction Location, Date Received, Quantity, Receipt Number, Serial Number, Lot Number, Receipt SEQ 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: Item Number, Transaction Location, Date Received, Quantity, Receipt Number, Serial Number, Lot Number, Receipt SEQ Number.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Item Number PK | Code | Normal | |
| 2 | Transaction Location PK | Text | Normal | |
| 3 | Date Received PK | Date | Normal | |
| 4 | Quantity PK | Decimal | Normal | |
| 5 | Receipt Number PK | Text | Normal | |
| 6 | Serial Number PK | Text | Normal | |
| 7 | Lot Number PK | Text | Normal | |
| 8 | Expiration Date | Date | Normal | |
| 9 | Unit Cost | Decimal | Normal | |
| 10 | Current Cost | Decimal | Normal | |
| 11 | Standard Cost | Decimal | Normal | |
| 12 | Receipt SEQ Number PK | 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 |