Table 10836 "Payment Line Archive FR" (FR)

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

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

Properties

Property	Value
Caption	Payment Line 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]	—	TableRelation Payment Header Archive FR
2	Line No.	Integer	—
3	Amount	Decimal	—
4	Account Type	enum “Gen. Journal Account Type”	—	enum Enum 81 “Gen. Journal Account Type”
5	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”
6	Posting Group	Code[20]	—	TableRelation if (“Account Type” = const(Customer)) “Customer Posting Group” else if (“Account Type” = const(Vendor)) “Vendor Posting Group” else if (“Account Type” = const(“Fixed Asset”)) “FA Posting Group”
7	Copied To No.	Code[20]	—
8	Copied To Line	Integer	—
9	Due Date	Date	—
10	Acc. Type Last Entry Debit	enum “Gen. Journal Account Type”	—	enum Enum 81 “Gen. Journal Account Type”; not editable
11	Acc. No. Last Entry Debit	Code[20]	—	TableRelation if (“Acc. Type Last Entry Debit” = const(“G/L Account”)) “G/L Account” else if (“Acc. Type Last Entry Debit” = const(Customer)) Customer else if (“Acc. Type Last Entry Debit” = const(Vendor)) Vendor else if (“Acc. Type Last Entry Debit” = const(“Bank Account”)) “Bank Account” else if (“Acc. Type Las…; not editable
12	Acc. Type Last Entry Credit	enum “Gen. Journal Account Type”	—	enum Enum 81 “Gen. Journal Account Type”; not editable
13	Acc. No. Last Entry Credit	Code[20]	—	TableRelation if (“Acc. Type Last Entry Credit” = const(“G/L Account”)) “G/L Account” else if (“Acc. Type Last Entry Credit” = const(Customer)) Customer else if (“Acc. Type Last Entry Credit” = const(Vendor)) Vendor else if (“Acc. Type Last Entry Credit” = const(“Bank Account”)) “Bank Account” else if (“Acc. Type…; not editable
14	P. Group Last Entry Debit	Code[20]	—	not editable
15	P. Group Last Entry Credit	Code[20]	—	not editable
16	Payment Class	Text[30]	—	TableRelation Payment Class FR
17	Status No.	Integer	—	TableRelation “Payment Status FR”.Line where(“Payment Class” = field(“Payment Class”)); not editable
18	Status Name	Text[50]	—	FlowField: lookup(“Payment Status FR”.Name where(“Payment Class” = field(“Payment Class”), Line = field(“Status No.”))); not editable
19	IsCopy	Boolean	—
20	Currency Code	Code[10]	—	TableRelation Currency
21	Entry No. Debit	Integer	—	not editable
22	Entry No. Credit	Integer	—	not editable
23	Entry No. Debit Memo	Integer	—	not editable
24	Entry No. Credit Memo	Integer	—	not editable
25	Bank Account Code	Code[20]	—	TableRelation if (“Account Type” = const(Customer)) “Customer Bank Account”.Code where(“Customer No.” = field(“Account No.”)) else if (“Account Type” = const(Vendor)) “Vendor Bank Account”.Code where(“Vendor No.” = field(“Account No.”))
26	Bank Branch No.	Text[20]	—
27	Bank Account No.	Text[30]	—
28	Agency Code	Text[5]	—
29	RIB Key	Integer	—
30	RIB Checked	Boolean	—	not editable
31	Acceptation Code	Option	—	OptionCaption: LCR,No,BOR,LCR NA
32	Document No.	Code[20]	—
33	Debit Amount	Decimal	—
34	Credit Amount	Decimal	—
35	Applies-to ID	Code[50]	—
36	Currency Factor	Decimal	—
37	Posted	Boolean	—
38	Correction	Boolean	—
39	Bank Account Name	Text[100]	—
40	Payment Address Code	Code[10]	—	TableRelation “Payment Address FR”.Code where(“Account Type” = field(“Account Type”), “Account No.” = field(“Account No.”))
41	Applies-to Doc. Type	Option	—	OptionCaption: ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder; not editable
42	Applies-to Doc. No.	Code[20]	—	not editable
43	External Document No.	Code[35]	—
44	Amount (LCY)	Decimal	—
45	Drawee Reference	Text[10]	—
46	Bank City	Text[30]	—
48	Posting Date	Date	—
50	Payment in Progress	Boolean	—	not editable
55	IBAN	Code[50]	—
56	SWIFT Code	Code[20]	—
480	Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable

Keys

Key1: No., Line No. (clustered)
Key2: Posting Date, Document No.

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 Line 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.