BC Observatoryunofficial, made by waldo
tableFinanceofficial - Microsoftderived - from the source, no model text

Table 7000002 "Cartera Doc." (ES)

ES country layer · Microsoft.Finance.ReceivablesPayables

Open in Claude7000002-es.mdSource on GitHub

Across versions

  1. BC23-28not present
  2. BC29-30present

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 Cartera Doc.
DataClassification CustomerContent
Permissions TableData “Cartera Doc.” = rm

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] —
9 Remaining Amount Decimal —
10 Remaining Amt. (LCY) Decimal —
11 Due Date Date —
12 Payment Method Code Code[10] — TableRelation Payment Method
13 Accepted Option — OptionCaption: Not Required,Yes,No
14 Place Boolean —
15 Collection Agent Option — OptionCaption: Direct,Bank
16 Bill Gr./Pmt. Order No. Code[20] — TableRelation if (Type = const(Receivable)) “Bill Group”.“No.” else if (Type = const(Payable)) “Payment Order”.“No.”
17 Category Code Code[10] — TableRelation Category Code
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))
29 Original Amount Decimal —
30 Original Amount (LCY) Decimal —
40 Document Type Enum “Cartera Document Doc. Type” — enum Cartera Document Doc. Type; not editable
45 On Hold Boolean — FlowField: exist(“Vendor Ledger Entry” where(“On Hold” = filter(<> ‘’), “Entry No.” = field(“Entry No.”)))
46 Adjusted Boolean —
48 Adjusted Amount Decimal —
49 From Journal Boolean —
50 Elect. Pmts Exported Boolean —
51 Export File Name Text[30] —
52 Transfer Type Option — OptionCaption: National,International,Special
480 Dimension Set ID Integer — TableRelation Dimension Set Entry; not editable
1200 Direct Debit Mandate ID Code[35] — TableRelation “SEPA Direct Debit Mandate”.ID where(“Customer No.” = field(“Account No.”))
10700 Original Document No. Code[20] —

Keys

  • Key1: Type, Entry No. (clustered)
  • Key2: Type, Document No.
  • Key3: Type, Collection Agent, Bill Gr./Pmt. Order No., Currency Code, Accepted, Due Date, Place
  • Key4: Type, Bill Gr./Pmt. Order No., Category Code, Currency Code, Accepted, Due Date
  • Key5: Type, Bill Gr./Pmt. Order No., Global Dimension 1 Code, Global Dimension 2 Code, Currency Code, Accepted, Due Date, Place
  • Key6: Type, Bill Gr./Pmt. Order No., Global Dimension 1 Code, Global Dimension 2 Code, Category Code, Currency Code, Accepted, Due Date
  • Key7: Type, Bill Gr./Pmt. Order No., Category Code, Currency Code, Account No., Due Date, Document Type
  • Key8: Type, Bill Gr./Pmt. Order No., Category Code, Currency Code, Accepted, Account No., Due Date, Document Type
  • Key9: Type, Collection Agent, Bill Gr./Pmt. Order No., Currency Code, Accepted, Due Date, Place, Document Type
  • Key10: Type, Bill Gr./Pmt. Order No., Collection Agent, Due Date, Global Dimension 1 Code, Global Dimension 2 Code, Category Code, Posting Date, Document No., Accepted, Currency Code, Document Type, Payment Method Code
  • Key11: Type, Bill Gr./Pmt. Order No., Transfer Type
  • Key12: Type, Bill Gr./Pmt. Order No., Transfer Type, Account No.
  • Key13: Type, Original Document No.

Events published

  • OnGetDocumentDateFromServiceInvoice(DocumentNo: Code[20]; var DocumentDate: Date) (integration)

Procedures

  • ResetNoPrinted()
  • ShowDimensions()
  • CheckDueDate()
  • UpdatePaymentMethodCode(DocumentNo: Code[20]; AccountNo: Code[20]; BillNo: Code[20]; PaymentMethodCode: Code[10])
  • UpdateDirectDebitMandate()
  • UpdateBankAccountCode()

Plus 1 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

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: "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.

Evidence 1 sources