Table 7000004 "Closed Cartera Doc." (ES)

ES country layer · Microsoft.Finance.ReceivablesPayables · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property	Value
Caption	Closed Cartera Doc.
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	Type	Enum “Cartera Document Type”	—	enum Cartera Document Type
2	Entry No.	Integer	—
3	No.	Code[20]	—
4	Posting Date	Date	—
5	Document No.	Code[20]	—
6	Description	Text[100]	—
7	Bank Account No.	Code[20]	—	TableRelation Bank Account
8	Dealing Type	Enum “Cartera Dealing Type”	—	enum Cartera Dealing Type; not editable
9	Amount for Collection	Decimal	—
10	Amt. for Collection (LCY)	Decimal	—
11	Due Date	Date	—
12	Payment Method Code	Code[10]	—	TableRelation Payment Method
13	Accepted	Option	—	OptionCaption: Not Required,Yes
14	Place	Boolean	—
15	Collection Agent	Option	—	OptionCaption: Direct,Bank
16	Bill Gr./Pmt. Order No.	Code[20]	—	TableRelation if (Type = const(Receivable)) “Closed Bill Group”.“No.” else if (Type = const(Payable)) “Closed Payment Order”.“No.”
18	Account No.	Code[20]	—	TableRelation if (Type = const(Receivable)) Customer else if (Type = const(Payable)) Vendor
19	Currency Code	Code[10]	—	TableRelation Currency
20	Cust./Vendor Bank Acc. Code	Code[20]	—	TableRelation if (Type = const(Receivable)) “Customer Bank Account”.Code where(“Customer No.” = field(“Account No.”)) else if (Type = const(Payable)) “Vendor Bank Account”.Code where(“Vendor No.” = field(“Account No.”))
21	Pmt. Address Code	Code[10]	—	obsolete Removed 25.0; #if not CLEANSCHEMA25
22	Global Dimension 1 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
23	Global Dimension 2 Code	Code[20]	—	TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))
24	Status	Enum “Cartera Document Status”	—	enum Cartera Document Status
25	Honored/Rejtd. at Date	Date	—
26	Remaining Amount	Decimal	—
27	Remaining Amt. (LCY)	Decimal	—
28	Redrawn	Boolean	—
29	Original Amount	Decimal	—
30	Original Amount (LCY)	Decimal	—
40	Document Type	Enum “Cartera Document Doc. Type”	—	enum Cartera Document Doc. Type; not editable
42	Factoring	Option	—	OptionCaption: ,Unrisked,Risked; not editable
49	From Journal	Boolean	—
480	Dimension Set ID	Integer	—	TableRelation Dimension Set Entry; not editable
10700	Original Document No.	Code[20]	—

Keys

Key1: Type, Entry No. (clustered)
Key2: Type, Document No.
Key3: Account No., Honored/Rejtd. at Date
Key4: Type, Collection Agent, Bill Gr./Pmt. Order No., Currency Code, Status, Redrawn
Key5: Bank Account No., Dealing Type, Currency Code, Status, Redrawn, Due Date, Honored/Rejtd. at Date
Key6: Type, Bill Gr./Pmt. Order No., Global Dimension 1 Code, Global Dimension 2 Code, Currency Code, Status, Redrawn
Key7: Bank Account No., Global Dimension 1 Code, Global Dimension 2 Code, Currency Code, Dealing Type, Status, Redrawn, Due Date, Honored/Rejtd. at Date, Document Type
Key8: Type, Bank Account No., Bill Gr./Pmt. Order No., Currency Code, Status, Redrawn, Document Type
Key9: Type, Original Document No.

Procedures

ShowDimensions()

Deprecations

field Pmt. Address Code: Removed 25.0 (#if not CLEANSCHEMA25), “Address is taken from the fields Address, City, etc. of Customer/Vendor table.”

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: "Closed Cartera Doc."), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

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