Other table in Microsoft Dynamics 365 Business Central. 30 fields, 0 records in Cronus demo.
The Pstd. Phys. Invt. Record Line table (ID 5882) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 30 fields, with a primary key of Order No., Recording No., Line No.. 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: Order No., Recording No., Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Order No. PK | Code | Normal | → Pstd. Phys. Invt. Order Hdr #5879 |
| 2 | Recording No. PK | Integer | Normal | → Pstd. Phys. Invt. Record Hdr #5881 |
| 3 | Line No. PK | Integer | Normal | |
| 16 | Order Line No. | Integer | Normal | → Phys. Invt. Order Line #5876 |
| 17 | Recorded without Order | Boolean | Normal | |
| 20 | Item No. | Code | Normal | → Item #27 |
| 21 | Variant Code | Code | Normal | → Item Variant #5401 |
| 22 | Location Code | Code | Normal | → Location #14 |
| 23 | Bin Code | Code | Normal | → Bin #7354 |
| 30 | Description | Text | Normal | |
| 31 | Description 2 | Text | Normal | |
| 32 | Unit of Measure | Text | Normal | |
| 40 | Unit of Measure Code | Code | Normal | → Item Unit of Measure #5404 |
| 41 | Quantity | Decimal | Normal | |
| 42 | Quantity (Base) | Decimal | Normal | |
| 43 | Qty. per Unit of Measure | Decimal | Normal | |
| 45 | Recorded | Boolean | Normal | |
| 53 | Use Item Tracking | Boolean | Normal | |
| 99 | Shelf No. | Code | Normal | |
| 100 | Date Recorded | Date | Normal | |
| 101 | Time Recorded | Time | Normal | |
| 102 | Person Recorded | Code | Normal | → Employee #5200 |
| 130 | Serial No. | Code | Normal | |
| 131 | Lot No. | Code | Normal | |
| 132 | Package No. | 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 |
Tables referenced by fields on the Pstd. Phys. Invt. Record Line table through TableRelation properties.