Table 10834 "Payment Header Archive FR" (FR)

FR country layer · Microsoft.Bank.Payment · captioned “Payment Header Archive” · BC29-30 · source at ea08af5e · facts from BC29

An object of the FR localization, not part of W1.

Properties

Property	Value
Caption	Payment Header Archive
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	No.	Code[20]	—
2	Currency Code	Code[10]	—	TableRelation Currency
3	Currency Factor	Decimal	—
4	Posting Date	Date	—
5	Document Date	Date	—
6	Payment Class	Text[30]	—	TableRelation Payment Class FR
7	Status No.	Integer	—	TableRelation “Payment Status FR”.Line where(“Payment Class” = field(“Payment Class”))
8	Status Name	Text[50]	—	FlowField: lookup(“Payment Status FR”.Name where(“Payment Class” = field(“Payment Class”), Line = field(“Status No.”))); not editable
9	Shortcut Dimension 1 Code	Code[20]	—
10	Shortcut Dimension 2 Code	Code[20]	—
11	Payment Class Name	Text[50]	—	FlowField: lookup(“Payment Class FR”.Name where(Code = field(“Payment Class”))); not editable
12	No. Series	Code[20]	—
13	Source Code	Code[10]	—	TableRelation Source Code
14	Account Type	enum “Gen. Journal Account Type”	—	enum Enum 81 “Gen. Journal Account Type”
15	Account No.	Code[20]	—	TableRelation if (“Account Type” = const(“G/L Account”)) “G/L Account” else if (“Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Account Type” = const(“Bank Account”)) “Bank Account” else if (“Account Type” = const(“Fixed Asset”)) “Fixed Asset”
16	Amount (LCY)	Decimal	—	FlowField: sum(“Payment Line Archive FR”.“Amount (LCY)” where(“No.” = field(“No.”))); not editable
17	Amount	Decimal	—	FlowField: sum(“Payment Line Archive FR”.Amount where(“No.” = field(“No.”))); not editable
18	Bank Branch No.	Text[20]	—
19	Bank Account No.	Text[30]	—
20	Agency Code	Text[20]	—
21	RIB Key	Integer	—
22	RIB Checked	Boolean	—	not editable
23	Bank Name	Text[100]	—
24	Bank Post Code	Code[20]	—	TableRelation Post Code
25	Bank City	Text[30]	—
26	Bank Name 2	Text[50]	—
27	Bank Address	Text[100]	—
28	Bank Address 2	Text[50]	—
29	Bank Contact	Text[100]	—
30	Bank County	Text[30]	—
31	Bank Country/Region Code	Code[10]	—	TableRelation Country/Region
32	National Issuer No.	Code[6]	—
50	IBAN	Code[50]	—
51	SWIFT Code	Code[20]	—
480	Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable

Keys

Key1: No. (clustered)
Key2: Posting Date

Procedures

ShowDimensions()

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: "Payment Header Archive FR"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A FR country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.