Table 10868 "Payment Line Archive" (FR)

FR country layer · Microsoft.Bank.Payment · 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
ObsoleteState	Pending
ObsoleteTag	28.0
ObsoleteReason	Moved to the Payment Management FR first-party app

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
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
17	Status No.	Integer	—	TableRelation “Payment Status”.Line where(“Payment Class” = field(“Payment Class”)); not editable
18	Status Name	Text[50]	—	FlowField: lookup(“Payment Status”.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”.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()

Deprecations

object: Pending 28.0 (#if not CLEANSCHEMA31), “Moved to the Payment Management FR first-party app”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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"), 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.