Table 86 "Exch. Rate Adjmt. Reg."

Base Application · Microsoft.Finance.Currency · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Exch. Rate Adjmt. Reg.
DataClassification	CustomerContent
DrillDownPageId	Exchange Rate Adjmt. Register

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	No. Δ BC29	Integer	Specifies the number of the involved entry or record, according to the specified number series.
2	Creation Date Δ BC29	Date	Specifies the posting date for the exchange rate adjustment register.
3	Account Type Δ BC29	Enum “Exch. Rate Adjmt. Account Type”	Specifies the account type that was adjusted for exchange rate fluctuations when you ran the Adjust Exchange Rates batch job.	enum Enum 596 “Exch. Rate Adjmt. Account Type”
4	Posting Group Δ BC24 Δ BC29	Code[20]	Specifies the posting group of the exchange rate adjustment register on this line.	TableRelation Table 277 “Bank Account Posting Group”, Table 5221 “Employee Posting Group”, Table 92 “Customer Posting Group” (if (“Account Type” = const(Customer)) “Customer Posting Group” else if (“Account Type” = const(Vendor)) “Vendor Posting Group” else if (“Account Type” = const(“Bank Account”)) “Bank Account Posting Group” else if (“Account Type” = const(Employee)) “Employee Posting Group”)
5	Currency Code Δ BC29	Code[10]	Specifies the code for the currency whose exchange rate was adjusted.	TableRelation Table 4 “Currency”
6	Currency Factor Δ BC28	Decimal	—
7	Adjusted Base Δ BC29	Decimal	Specifies the amount that was adjusted by the batch job for customer, vendor and/or bank ledger entries.
8	Adjusted Base (LCY) Δ BC28	Decimal	Specifies the amount in LCY that was adjusted by the batch job for G/L, customer, vendor and/or bank ledger entries. via Page 106 “Exchange Rate Adjmt. Register”
9	Adjusted Amt. (LCY) Δ BC28	Decimal	Specifies the amount by which the batch job has adjusted G/L, customer, vendor and/or bank ledger entries for exchange rate fluctuations. via Page 106 “Exchange Rate Adjmt. Register”
10	Adjusted Base (Add.-Curr.)	Decimal	Specifies the additional-reporting-currency amount the batch job has adjusted G/L, customer, and other entries for exchange rate fluctuations. via Page 106 “Exchange Rate Adjmt. Register”
11	Adjusted Amt. (Add.-Curr.)	Decimal	Specifies the additional-reporting-currency amount the batch job has adjusted G/L, customer, and other entries for exchange rate fluctuations. via Page 106 “Exchange Rate Adjmt. Register”
14	Journal Template Name	Code[10]	—
15	Journal Batch Name	Code[10]	—
21	Adjusted Customers Δ BC29	Integer	Specifies the number of customer ledger entries with remaining amount that was adjusted.	FlowField: count(“Detailed Cust. Ledg. Entry” where(“Exch. Rate Adjmt. Reg. No.” = field(“No.”))); not editable
22	Adjusted Vendors Δ BC29	Integer	Specifies the number of vendor ledger entries with remaining amount that was adjusted.	FlowField: count(“Detailed Vendor Ledg. Entry” where(“Exch. Rate Adjmt. Reg. No.” = field(“No.”))); not editable
23	Adjustment Amount Δ BC28 Δ BC29	Decimal	Specifies the total adjustment amount of exchange rate adjustment ledger entries.	FlowField: sum(“Exch. Rate Adjmt. Ledg. Entry”.“Adjustment Amount” where(“Register No.” = field(“No.”))); not editable
24	Adjusted Employees + BC24 Δ BC29	Integer	Specifies the number of emplooyee ledger entries with remaining amount that was adjusted.	FlowField: count(“Detailed Employee Ledger Entry” where(“Exch. Rate Adjmt. Reg. No.” = field(“No.”))); not editable

Keys

Key1: No. (clustered)

Procedures

1 local procedures, no public ones.

Triggers

OnDelete

Relations

drill-down page Page 106 “Exchange Rate Adjmt. Register”
lookup page Page 106 “Exchange Rate Adjmt. Register”
Adjustment Amount: CalcFormula Table 186 “Exch. Rate Adjmt. Ledg. Entry”
Posting Group: TableRelation Table 277 “Bank Account Posting Group” (conditional)
Adjusted Customers: CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
Adjusted Vendors: CalcFormula Table 380 “Detailed Vendor Ledg. Entry”
Currency Code: TableRelation Table 4 “Currency”
Posting Group: TableRelation Table 5221 “Employee Posting Group” (conditional)
Adjusted Employees: CalcFormula Table 5223 “Detailed Employee Ledger Entry”
Posting Group: TableRelation Table 92 “Customer Posting Group” (conditional)
Posting Group: TableRelation Table 93 “Vendor Posting Group” (conditional)

Referenced by

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

Table 379 “Detailed Cust. Ledg. Entry”: Exch. Rate Adjmt. Reg. No.
Table 380 “Detailed Vendor Ledg. Entry”: Exch. Rate Adjmt. Reg. No.
Table 383 “Detailed CV Ledg. Entry Buffer”: Exch. Rate Adjmt. Reg. No.
Table 5223 “Detailed Employee Ledger Entry”: Exch. Rate Adjmt. Reg. No.

Pages and codeunits on this table

Page 106 “Exchange Rate Adjmt. Register” (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: "Exch. Rate Adjmt. Reg."), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.