Table 5805 "Item Charge Assignment (Purch)"
Base Application · Microsoft.Purchases.Document
Across versions
- BC23present
- BC241 events added
- BC25-27unchanged
- BC2812 fields changed, 1 procedures added
- BC29-30unchanged
Neighbourhood 9 connected objects and pages
Base Application · Microsoft.Purchases.Document · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 5805 “Item Charge Assignment (Purch)” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Item Charge Assignment (Purch) |
| 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 | Enum “Purchase Document Type” | — | enum Enum 38 “Purchase Document Type” |
| 2 | Document No. | Code[20] | — | TableRelation Table 38 “Purchase Header” (“Purchase Header”.“No.” where(“Document Type” = field(“Document Type”))) |
| 3 | Document Line No. | Integer | — | TableRelation Table 39 “Purchase Line” (“Purchase Line”.“Line No.” where(“Document Type” = field(“Document Type”), “Document No.” = field(“Document No.”))) |
| 4 | Line No. | Integer | — | |
| 5 | Item Charge No. | Code[20] | — | TableRelation Table 5800 “Item Charge” (Item Charge); NotBlank |
| 6 | Item No. Δ BC28 | Code[20] | Specifies the item number on the document line that this item charge is assigned to. | TableRelation Table 27 “Item” |
| 7 | Description Δ BC28 | Text[100] | Specifies a description of the item on the document line that this item charge is assigned to. | |
| 8 | Qty. to Assign Δ BC28 | Decimal | Specifies how many units of the item charge will be assigned to the document line. If the document has more than one line of type Item, then this quantity reflects the distribution that you selected when you chose the Suggest Item Charge Assignment action. | |
| 9 | Qty. Assigned Δ BC28 | Decimal | Specifies the number of units of the item charge will be assigned to the document line. | not editable |
| 10 | Unit Cost Δ BC28 | Decimal | — | |
| 11 | Amount to Assign Δ BC28 | Decimal | Specifies the value of the item charge that is going to be assigned to the document line. | |
| 12 | Applies-to Doc. Type Δ BC28 | Enum “Purchase Applies-to Document Type” | Specifies the type of the document that this document or journal line will be applied to when you post, for example to register payment. | enum Enum 5805 “Purchase Applies-to Document Type” |
| 13 | Applies-to Doc. No. Δ BC28 | Code[20] | Specifies the number of the document that this document or journal line will be applied to when you post, for example to register payment. | TableRelation Table 38 “Purchase Header” (if (“Applies-to Doc. Type” = const(Order)) “Purchase Header”.“No.” where(“Document Type” = const(Order)) else if (“Applies-to Doc. Type” = const(Invoice)) “Purchase Header”.“No.” where(“Document Type” = const(Invoice)) else if (“Applies-to Doc. Type” = const(“Return Order”)) “Purchase Header”.“No.” …) |
| 14 | Applies-to Doc. Line No. Δ BC28 | Integer | Specifies the number of the line on the document that this document or journal line will be applied to when you post, for example to register payment. | TableRelation Table 39 “Purchase Line” (if (“Applies-to Doc. Type” = const(Order)) “Purchase Line”.“Line No.” where(“Document Type” = const(Order), “Document No.” = field(“Applies-to Doc. No.”)) else if (“Applies-to Doc. Type” = const(Invoice)) “Purchase Line”.“Line No.” where(“Document Type” = const(Invoice), “Document No.” = field(“Appl…) |
| 15 | Applies-to Doc. Line Amount Δ BC28 | Decimal | — | |
| 16 | Qty. to Handle Δ BC28 | Decimal | Specifies how many items the item charge will be assigned to on the line. It can be either equal to Qty. to Assign or to zero. If it is zero, the item charge will not be assigned to the line. | |
| 17 | Amount to Handle Δ BC28 | Decimal | Specifies the value of the item charge that will be actually assigned to the document line. |
Keys
- Key1: Document Type, Document No., Document Line No., Line No. (clustered)
- Key2: Applies-to Doc. Type, Applies-to Doc. No., Applies-to Doc. Line No.
- Key3: Applies-to Doc. Type
Events published
OnValidateQtyToAssignOnBeforeTestFieldAppliesToDocLineNo(var ItemChargeAssignmentPurch: Record "Item Charge Assignment (Purch)"; var IsHandled: Boolean)+ BC24 (integration)
Procedures
PurchLineInvoiced(): BooleanCheckAssignment(AppliesToDocumentType: Enum "Purchase Applies-to Document Type"; AppliesToDocumentNo: Code[20]; AppliesToDocumentLineNo: Integer)
Plus 2 local procedures.
Triggers
OnDelete
Relations
- Item No.: TableRelation Table 27 “Item”
- Applies-to Doc. No.: TableRelation Table 38 “Purchase Header” (conditional)
- Document No.: TableRelation Table 38 “Purchase Header”
- Applies-to Doc. Line No.: TableRelation Table 39 “Purchase Line” (conditional)
- Document Line No.: TableRelation Table 39 “Purchase Line”
- Item Charge No.: TableRelation Table 5800 “Item Charge”
Referenced by
3 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 39 “Purchase Line”: Item Charge Qty. to Handle, Qty. Assigned, Qty. to Assign
Pages and codeunits on this table
- Page 5805 “Item Charge Assignment (Purch)” (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: "Item Charge Assignment (Purch)"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.