Table 6027 "Pstd.Exp.Invt.Order.Tracking"
Base Application · Microsoft.Inventory.Counting.Tracking
Across versions
- BC23not present
- BC24added
- BC25-27unchanged
- BC287 fields changed
- BC29-30unchanged
Neighbourhood 4 connected objects and pages
Base Application · Microsoft.Inventory.Counting.Tracking · captioned “Pstd. Exp. Phys. Invt. Track” · BC24-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Pstd. Exp. Phys. Invt. Track |
| 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 | Order No Δ BC28 | Code[20] | Specifies the document number of the Posted Inventory Order. | TableRelation Table 5879 “Pstd. Phys. Invt. Order Hdr” (Pstd. Phys. Invt. Order Hdr); DataClassification SystemMetadata |
| 2 | Order Line No. Δ BC28 | Integer | Specifies the line number of the Posted Inventory Order Line. | TableRelation Table 5880 “Pstd. Phys. Invt. Order Line” (“Pstd. Phys. Invt. Order Line”.“Line No.” where(“Document No.” = field(“Order No”))); DataClassification SystemMetadata |
| 3 | Serial No. Δ BC28 | Code[50] | Specifies the expected Serial No. | DataClassification SystemMetadata |
| 4 | Lot No. Δ BC28 | Code[50] | Specifies the expected Lot No. | DataClassification SystemMetadata |
| 5 | Package No. Δ BC28 | Code[50] | Specifies the expected Package No. | DataClassification SystemMetadata |
| 6 | Expiration Date Δ BC28 | Date | Specifies the expected Expiration Date | DataClassification SystemMetadata |
| 30 | Quantity (Base) Δ BC28 | Decimal | — | DataClassification SystemMetadata |
Keys
- Key1: Order No, Order Line No., Serial No., Lot No., Package No. (clustered)
Relations
- drill-down page Page 6026 “Posted.Exp.Invt.Order.Tracking”
- lookup page Page 6026 “Posted.Exp.Invt.Order.Tracking”
- Order No: TableRelation Table 5879 “Pstd. Phys. Invt. Order Hdr”
- Order Line No.: TableRelation Table 5880 “Pstd. Phys. Invt. Order Line”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 5880 “Pstd. Phys. Invt. Order Line”: Qty. Exp. Tracking (Base)
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: "Pstd.Exp.Invt.Order.Tracking"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.