Table 7323 "Posted Whse. Shipment Line"
Base Application · Microsoft.Warehouse.History
Across versions
- BC23present
- BC24declaration changed
- BC25-27unchanged
- BC2825 fields changed
- BC29-30unchanged
Neighbourhood 11 connected objects and pages
Base Application · Microsoft.Warehouse.History · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 7362 “Posted Whse. Shipment Lines” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Posted Whse. Shipment Line |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | No. Δ BC28 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | not editable |
| 2 | Line No. Δ BC28 | Integer | Specifies the number of the line. | not editable |
| 3 | Source Type | Integer | — | not editable |
| 4 | Source Subtype | Option | — | OptionCaption: 0,1,2,3,4,5,6,7,8,9,10; not editable |
| 6 | Source No. Δ BC28 | Code[20] | Specifies the number of the source document that the entry originates from. | not editable |
| 7 | Source Line No. Δ BC28 | Integer | Specifies the line number of the source document that the entry originates from. | not editable |
| 9 | Source Document Δ BC28 | Enum “Warehouse Activity Source Document” | Specifies the type of document that the line relates to. | enum Enum 5768 “Warehouse Activity Source Document”; not editable |
| 10 | Location Code Δ BC28 | Code[10] | Specifies the code of the location from which the items on the line were shipped. | TableRelation Table 14 “Location”; not editable |
| 11 | Shelf No. Δ BC28 | Code[10] | Specifies the shelf number of the item for informational use. | |
| 12 | Bin Code Δ BC28 | Code[20] | Specifies the bin where the items are picked or put away. | TableRelation Table 7354 “Bin” (if (“Zone Code” = filter(‘’)) Bin.Code where(“Location Code” = field(“Location Code”)) else if (“Zone Code” = filter(<> ‘’)) Bin.Code where(“Location Code” = field(“Location Code”), “Zone Code” = field(“Zone Code”))) |
| 13 | Zone Code Δ BC28 | Code[10] | Specifies the code of the zone where the bin on this posted shipment line is located. | TableRelation Table 7300 “Zone” (Zone.Code where(“Location Code” = field(“Location Code”))) |
| 14 | Item No. Δ BC28 | Code[20] | Specifies the number of the item that has been shipped. | TableRelation Table 27 “Item”; not editable |
| 15 | Quantity Δ BC28 | Decimal | Specifies the quantity that was shipped. | not editable |
| 16 | Qty. (Base) Δ BC28 | Decimal | Specifies the quantity that was shipped, in the base unit of measure. via Page 7362 “Posted Whse. Shipment Lines” | not editable |
| 29 | Unit of Measure Code Δ BC28 | Code[10] | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))); not editable |
| 30 | Qty. per Unit of Measure Δ BC28 | Decimal | Specifies the number of base units of measure, that are in the unit of measure, specified for the item on the line. | not editable |
| 31 | Variant Code Δ BC28 | Code[10] | Specifies the variant of the item on the line. | TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”))); not editable |
| 32 | Description Δ BC28 | Text[100] | Specifies the description of the item on the line. | not editable |
| 33 | Description 2 Δ BC28 | Text[50] | Specifies the a second description of the item on the line, if any. | not editable |
| 36 | Due Date Δ BC28 | Date | Specifies the due date of the line. | |
| 39 | Destination Type Δ BC28 | Enum “Warehouse Destination Type” | Specifies the type of destination associated with the posted warehouse shipment line. | enum Enum 7310 “Warehouse Destination Type”; not editable |
| 40 | Destination No. Δ BC28 | Code[20] | Specifies the number of the customer, vendor, or location to which the items have been shipped. | TableRelation if (“Destination Type” = const(Customer)) Customer.“No.” else if (“Destination Type” = const(Vendor)) Vendor.“No.” else if (“Destination Type” = const(Location)) Location.Code; not editable |
| 44 | Shipping Advice Δ BC28 | Enum “Sales Header Shipping Advice” | Specifies the shipping advice for the posted warehouse shipment line. | enum Enum 3657 “Sales Header Shipping Advice”; not editable |
| 45 | Shipment Date | Date | — | |
| 50 | Qty. Rounding Precision Δ BC28 | Decimal | — | not editable |
| 51 | Qty. Rounding Precision (Base) Δ BC28 | Decimal | — | not editable |
| 60 | Posted Source Document Δ BC28 | Enum “Warehouse Shipment Posted Source Document” | Specifies the type of source document associated with the line. | enum Enum 7323 “Warehouse Shipment Posted Source Document” |
| 61 | Posted Source No. Δ BC28 | Code[20] | Specifies the document number of the posted source document. | |
| 62 | Posting Date | Date | — | |
| 63 | Whse. Shipment No. | Code[20] | — | not editable |
| 64 | Whse Shipment Line No. | Integer | — | not editable |
Keys
- Key1: No., Line No. (clustered)
- Key2: Whse. Shipment No., Whse Shipment Line No.
- Key3: Posted Source No., Posting Date
- Key4: Source Type, Source Subtype, Source No., Source Line No.
Relations
- lookup page Page 7362 “Posted Whse. Shipment Lines”
- Location Code: TableRelation Table 14 “Location”
- Item No.: TableRelation Table 27 “Item”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
- Zone Code: TableRelation Table 7300 “Zone”
- Bin Code: TableRelation Table 7354 “Bin” (conditional)
Pages and codeunits on this table
- Page 7338 “Posted Whse. Shipment Subform” (source table)
- Page 7362 “Posted Whse. Shipment Lines” (source table)
Extended by
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Posted Whse. Shipment Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.