Table 5809 "Item Charge Assignment (Sales)"

Base Application · Microsoft.Sales.Document · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 5814 “Item Charge Assignment (Sales)” (1 Learn page).

Properties

Property	Value
Caption	Item Charge Assignment (Sales)
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 “Sales Document Type”	—	enum Enum 36 “Sales Document Type”
2	Document No.	Code[20]	—	TableRelation Table 36 “Sales Header” (“Sales Header”.“No.” where(“Document Type” = field(“Document Type”)))
3	Document Line No.	Integer	—	TableRelation Table 37 “Sales Line” (“Sales 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 “Sales 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 5809 “Sales 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 36 “Sales Header” (if (“Applies-to Doc. Type” = const(Order)) “Sales Header”.“No.” where(“Document Type” = const(Order)) else if (“Applies-to Doc. Type” = const(Invoice)) “Sales Header”.“No.” where(“Document Type” = const(Invoice)) else if (“Applies-to Doc. Type” = const(“Return Order”)) “Sales Header”.“No.” where(“Do…)
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 37 “Sales Line” (if (“Applies-to Doc. Type” = const(Order)) “Sales Line”.“Line No.” where(“Document Type” = const(Order), “Document No.” = field(“Applies-to Doc. No.”)) else if (“Applies-to Doc. Type” = const(Invoice)) “Sales Line”.“Line No.” where(“Document Type” = const(Invoice), “Document No.” = field(“Applies-to…)
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

OnAfterSalesLineInvoiced(ItemChargeAssignmentSales: Record "Item Charge Assignment (Sales)"; var SalesLine: Record "Sales Line"; var Result: Boolean) (integration)

Procedures

SalesLineInvoiced(): Boolean: Checks whether the applied-to sales line is fully invoiced.
CheckAssignment(AppliesToDocumentType: Enum "Sales Applies-to Document Type"; AppliesToDocumentNo: Code[20]; AppliesToDocumentLineNo: Integer): Checks if item charge assignments exist for the specified document line and raises an error if found.

Plus 2 local procedures.

Triggers

OnDelete

Relations

Item No.: TableRelation Table 27 “Item”
Applies-to Doc. No.: TableRelation Table 36 “Sales Header” (conditional)
Document No.: TableRelation Table 36 “Sales Header”
Applies-to Doc. Line No.: TableRelation Table 37 “Sales Line” (conditional)
Document Line No.: TableRelation Table 37 “Sales Line”
Item Charge No.: TableRelation Table 5800 “Item Charge”

Referenced by

3 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 37 “Sales Line”: Item Charge Qty. to Handle, Qty. Assigned, Qty. to Assign

Pages and codeunits on this table

Page 5814 “Item Charge Assignment (Sales)” (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: "Item Charge Assignment (Sales)"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.