Warehouse table in Microsoft Dynamics 365 Business Central. 41 fields, 0 records in Cronus demo.
The Posted Invt. Pick Line table (ID 7343) is part of the Warehouse area in Microsoft Dynamics 365 Business Central. It contains 41 fields, with a primary key of 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: No., Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 2 | No. PK | Code | Normal | |
| 3 | Line No. PK | Integer | Normal | |
| 4 | Source Type | Integer | Normal | |
| 5 | Source Subtype | Option | Normal | |
| 6 | Source No. | Code | Normal | |
| 7 | Source Line No. | Integer | Normal | |
| 8 | Source Subline No. | Integer | Normal | |
| 9 | Source Document | Option | Normal | |
| 11 | Location Code | Code | Normal | → Location #14 |
| 12 | Shelf No. | Code | Normal | |
| 13 | Sorting Sequence No. | Integer | Normal | |
| 14 | Item No. | Code | Normal | → Item #27 |
| 15 | Variant Code | Code | Normal | → Item Variant #5401 |
| 16 | Unit of Measure Code | Code | Normal | → Item Unit of Measure #5404 |
| 17 | Qty. per Unit of Measure | Decimal | Normal | |
| 18 | Description | Text | Normal | |
| 19 | Description 2 | Text | Normal | |
| 20 | Quantity | Decimal | Normal | |
| 21 | Qty. (Base) | Decimal | Normal | |
| 31 | Shipping Advice | Option | Normal | |
| 34 | Due Date | Date | Normal | |
| 39 | Destination Type | Option | Normal | |
| 40 | Destination No. | Code | Normal | |
| 41 | Whse. Activity No. | Code | Normal | |
| 42 | Shipping Agent Code | Code | Normal | → Shipping Agent #291 |
| 43 | Shipping Agent Service Code | Code | Normal | → Shipping Agent Services #5790 |
| 44 | Shipment Method Code | Code | Normal | → Shipment Method #10 |
| 6500 | Serial No. | Code | Normal | |
| 6501 | Lot No. | Code | Normal | |
| 6502 | Warranty Date | Date | Normal | |
| 6503 | Expiration Date | Date | Normal | |
| 6515 | Package No. | Code | Normal | |
| 7300 | Bin Code | Code | Normal | |
| 7301 | Zone Code | Code | Normal | → Zone #7300 |
| 7305 | Action Type | Option | Normal | |
| 7312 | Special Equipment Code | Code | Normal | → Special Equipment #7305 |
| 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 Posted Invt. Pick Line table through TableRelation properties.