Table 346 "Reservation Wksh. Line"
Base Application · Microsoft.Inventory.Tracking
Across versions
- BC23-24present
- BC251 events added
- BC26-27unchanged
- BC2827 fields changed
- BC29-30unchanged
Neighbourhood 14 connected objects and pages
Base Application · Microsoft.Inventory.Tracking · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Reservation Wksh. 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 | Journal Batch Name | Code[10] | — | TableRelation Table 345 “Reservation Wksh. Batch” (Reservation Wksh. Batch) |
| 2 | Line No. Δ BC28 | Integer | Specifies the line number of the source document. | |
| 10 | Source Type Δ BC28 | Integer | Specifies the type of source document on the demand line. | TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Table)) |
| 11 | Source Subtype | Integer | — | |
| 12 | Source ID Δ BC28 | Code[20] | Specifies the number the source document on the demand line. | |
| 13 | Source Batch Name | Code[10] | — | |
| 14 | Source Prod. Order Line | Integer | — | |
| 15 | Source Ref. No. | Integer | — | |
| 17 | Record ID | RecordId | — | |
| 21 | Item No. Δ BC28 | Code[20] | Specifies the number of the item on the demand line. | TableRelation Table 27 “Item” |
| 22 | Variant Code Δ BC28 | Code[10] | Specifies the variant of the item on the demand line. | TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No.”))) |
| 23 | Location Code Δ BC28 | Code[10] | Specifies the location code on the demand line. | TableRelation Table 14 “Location” |
| 24 | Sell-to Customer No. Δ BC28 | Code[20] | Specifies the number of the customer, if any, on the demand line. | TableRelation Customer.“No.” |
| 25 | Sell-to Customer Name Δ BC28 | Text[100] | Specifies the name of the customer, if any, on the demand line. | TableRelation Customer.Name |
| 26 | Priority Δ BC28 | Integer | Specifies the priority of the customer. | |
| 29 | Description Δ BC28 | Text[100] | Specifies text that describes the entry. | |
| 30 | Description 2 Δ BC28 | Text[100] | Specifies information in addition to the description. | |
| 31 | Demand Date Δ BC28 | Date | Specifies the demand date, which is the shipment date for sales orders and the due date for production components. | |
| 32 | Unit of Measure Code Δ BC28 | Code[10] | Specifies how each unit of the item is measured. | TableRelation Table 5404 “Item Unit of Measure” (“Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”))); NotBlank |
| 33 | Qty. per Unit of Measure Δ BC28 | Decimal | — | |
| 41 | Remaining Qty. to Reserve Δ BC28 | Decimal | Specifies how many units of the item on the demand line are not reserved from inventory. | |
| 42 | Rem. Qty. to Reserve (Base) Δ BC28 | Decimal | — | |
| 43 | Qty. to Reserve Δ BC28 | Decimal | Specifies how many units of the item on the demand line you want to reserve. | |
| 44 | Qty. to Reserve (Base) Δ BC28 | Decimal | — | |
| 51 | Available Qty. to Reserve Δ BC28 | Decimal | Specifies how many units of the item on the demand line can be reserved from inventory. This takes into account the Qty. to Reserve field on other demand lines with the same item number, location code, and variant code. | |
| 52 | Avail. Qty. to Reserve (Base) Δ BC28 | Decimal | — | |
| 61 | Qty. in Stock Δ BC28 | Decimal | Specifies the current stock quantity for the item. | |
| 62 | Qty. in Stock (Base) Δ BC28 | Decimal | — | |
| 63 | Qty. Reserved in Stock Δ BC28 | Decimal | Specifies the quantity that has been reserved from stock for this item. | |
| 64 | Qty. Reserv. in Stock (Base) Δ BC28 | Decimal | Qty. Reserved from Stock (Base) caption | |
| 65 | Qty. in Whse. Handling Δ BC28 | Decimal | Specifies the quantity that is currently in warehouse handling for this item. | |
| 66 | Qty. in Whse. Handling (Base) Δ BC28 | Decimal | Qty. in Warehouse Handling (Base) caption | |
| 100 | Accept Δ BC28 | Boolean | Specifies if you want to reserve this demand line. | |
| 6501 | Serial No. | Code[50] | — | |
| 6502 | Lot No. | Code[50] | — | |
| 6503 | Package No. | Code[50] | — |
Keys
- Key1: Journal Batch Name, Line No. (clustered)
- Key2: Journal Batch Name, Source Type, Source Subtype, Source ID, Source Ref. No., Source Batch Name, Source Prod. Order Line
- Key3: Journal Batch Name, Item No., Variant Code, Location Code
Events published
OnIsOutdated(ReservationWkshLine: Record "Reservation Wksh. Line"; var Outdated: Boolean)+ BC25 (integration)- subscribers: Codeunit 6485 “Serv. Get Demand To Reserve” OnIsOutdated, Codeunit 929 “Asm. Get Demand To Reserve” OnIsOutdated, Codeunit 99000839 “Sales Get Demand To Reserve” OnIsOutdated, Codeunit 99000846 “Trans. Get Demand To Reserve” OnIsOutdated, Codeunit 99000847 “Job Planning Line Get Demand” OnIsOutdated, Codeunit 99000858 “Mfg. Get Demand To Reserve” OnIsOutdated
Procedures
IsOutdated(): BooleanGetLastLineNo(): Integer
Plus 3 local procedures.
Relations
- Location Code: TableRelation Table 14 “Location”
- Item No.: TableRelation Table 27 “Item”
- Journal Batch Name: TableRelation Table 345 “Reservation Wksh. Batch”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 345 “Reservation Wksh. Batch”: No. of Lines
Pages and codeunits on this table
- Page 305 “Reservation Worksheet” (source table)
- Page 330 “Reservation Wksh. Factbox” (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: "Reservation Wksh. Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.