Table 5883 "Phys. Invt. Comment Line"
Base Application · Microsoft.Inventory.Counting.Comment
Across versions
- BC23present
- BC24declaration changed
- BC25-27unchanged
- BC285 fields changed
- BC29-30unchanged
Neighbourhood 10 connected objects and pages
Base Application · Microsoft.Inventory.Counting.Comment · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Phys. Invt. Comment 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 | Document Type | Option | — | OptionCaption: Order,Recording,Posted Order,Posted Recording |
| 2 | Order No. Δ BC28 | Code[20] | Specifies the document number of the physical inventory order to which the comment applies. | TableRelation Table 5875 “Phys. Invt. Order Header”, Table 5877 “Phys. Invt. Record Header”, Table 5879 “Pstd. Phys. Invt. Order Hdr” (if (“Document Type” = const(Order)) “Phys. Invt. Order Header” else if (“Document Type” = const(Recording)) “Phys. Invt. Record Header”.“Order No.” else if (“Document Type” = const(“Posted Order”)) “Pstd. Phys. Invt. Order Hdr” else if (“Document Type” = const(“Posted Recording”)) “Pstd. Phys. Invt….) |
| 3 | Recording No. Δ BC28 | Integer | Specifies the document number of the physical inventory recording to which the comment applies. | TableRelation Table 5877 “Phys. Invt. Record Header”, Table 5881 “Pstd. Phys. Invt. Record Hdr” (if (“Document Type” = const(Recording)) “Phys. Invt. Record Header”.“Recording No.” where(“Order No.” = field(“Order No.”)) else if (“Document Type” = const(“Posted Recording”)) “Pstd. Phys. Invt. Record Hdr”.“Recording No.” where(“Order No.” = field(“Order No.”))) |
| 4 | Line No. | Integer | — | |
| 10 | Date Δ BC28 | Date | Specifies the date when the comment was created. | |
| 11 | Code Δ BC28 | Code[10] | Specifies a code for the comment. | |
| 12 | Comment Δ BC28 | Text[80] | Specifies the comment itself. |
Keys
- Key1: Document Type, Order No., Recording No., Line No. (clustered)
Events published
OnAfterSetUpNewLine(var PhysInvtCommentLineRec: Record "Phys. Invt. Comment Line"; var PhysInvtCommentLineFilter: Record "Phys. Invt. Comment Line")(integration)
Procedures
SetUpNewLine()
Triggers
OnInsert
Relations
- drill-down page Page 5892 “Phys. Inventory Comment List”
- lookup page Page 5892 “Phys. Inventory Comment List”
- Order No.: TableRelation Table 5875 “Phys. Invt. Order Header” (conditional)
- Order No.: TableRelation Table 5877 “Phys. Invt. Record Header” (conditional)
- Recording No.: TableRelation Table 5877 “Phys. Invt. Record Header” (conditional)
- Order No.: TableRelation Table 5879 “Pstd. Phys. Invt. Order Hdr” (conditional)
- Recording No.: TableRelation Table 5881 “Pstd. Phys. Invt. Record Hdr” (conditional)
Referenced by
4 fields in 4 objects relate to this table (TableRelation or CalcFormula).
- Table 5875 “Phys. Invt. Order Header”: Comment
- Table 5877 “Phys. Invt. Record Header”: Comment
- Table 5879 “Pstd. Phys. Invt. Order Hdr”: Comment
- Table 5881 “Pstd. Phys. Invt. Record Hdr”: Comment
Pages and codeunits on this table
- Page 5891 “Phys. Inventory Comment Sheet” (source table)
- Page 5892 “Phys. Inventory Comment List” (source table)
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: "Phys. Invt. Comment Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.