Table 459 "Sales Prepayment %"

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

Learn documents this table through its pages: Page 664 “Sales Prepayment Percentages” (1 Learn page).

Properties

Property	Value
Caption	Sales Prepayment %
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	Item No. Δ BC28	Code[20]	Specifies the number of the item for which the prepayment percentage is valid.	TableRelation Table 27 “Item”; NotBlank
2	Sales Type Δ BC28	Option	Specifies the sales type of the prepayment percentage.	OptionCaption: Customer,Customer Price Group,All Customers
3	Sales Code Δ BC28	Code[20]	Specifies the code that belongs to the sales type.	TableRelation Table 18 “Customer”, Table 6 “Customer Price Group” (if (“Sales Type” = const(Customer)) Customer else if (“Sales Type” = const(“Customer Price Group”)) “Customer Price Group”)
4	Starting Date Δ BC28	Date	Specifies the date from which the prepayment percentage is valid.
5	Ending Date Δ BC28	Date	Specifies the date to which the prepayment percentage is valid.
6	Prepayment % Δ BC28	Decimal	Specifies the prepayment percentage to use to calculate the prepayment for sales.

Keys

Key1: Item No., Sales Type, Sales Code, Starting Date (clustered)
Key2: Sales Type, Sales Code

Procedures

1 local procedures, no public ones.

Triggers

OnInsert

Relations

Sales Code: TableRelation Table 18 “Customer” (conditional)
Item No.: TableRelation Table 27 “Item”
Sales Code: TableRelation Table 6 “Customer Price Group” (conditional)

Pages and codeunits on this table

Page 664 “Sales Prepayment Percentages” (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: "Sales Prepayment %"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.