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

Table 11000003 "Detail Line" (NL)

NL country layer · Microsoft.Bank.Payment

Open in Claude11000003-nl.mdSource on GitHub

Across versions

  1. BC23-27not present
  2. BC28-30present

NL country layer · Microsoft.Bank.Payment · BC28-30 · source at ea08af5e · facts from BC29

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

Properties

Property Value
Caption Detail Line
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 Account Type Option — OptionCaption: Customer,Vendor,Employee; not editable
2 Serial No. (Entry) Integer — TableRelation if (“Account Type” = const(Customer)) “Cust. Ledger Entry”.“Entry No.” else if (“Account Type” = const(Vendor)) “Vendor Ledger Entry”.“Entry No.”; NotBlank
3 Account No. Code[20] — TableRelation if (“Account Type” = const(Customer)) Customer.“No.” else if (“Account Type” = const(Vendor)) Vendor.“No.”; not editable
4 Date Date — not editable
5 Status Option — OptionCaption: Proposal,In process,Posted,Correction; not editable
6 Bank 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.”)); not editable
7 Our Bank Code[20] — TableRelation “Bank Account”.“No.”; not editable
8 Transaction Mode Code[20] — TableRelation “Transaction Mode”.Code where(“Account Type” = field(“Account Type”)); not editable
9 Order Option — OptionCaption: Both,Debit,Credit; not editable
10 Amount Decimal —
11 Transaction No. Integer — not editable
12 Connect Lines Integer — TableRelation if (Status = const(Proposal)) “Proposal Line”.“Line No.” where(“Our Bank No.” = field(“Our Bank”)) else if (Status = const(“In process”)) “Payment History Line”.“Line No.” where(“Our Bank” = field(“Our Bank”), “Run No.” = field(“Connect Batches”)); not editable
13 Connect Batches Code[20] — TableRelation if (Status = const(“In process”)) “Payment History”.“Run No.”; not editable
14 Description Text[32] —
15 Currency Code Code[10] — TableRelation Currency.Code; not editable
16 Amount (Entry) Decimal —
17 Currency Code (Entry) Code[10] — not editable

Keys

  • Key1: Transaction No. (clustered)
  • Key2: Account Type, Serial No. (Entry), Status, Date, Connect Batches, Connect Lines, Our Bank
  • Key3: Account Type, Account No., Bank, Transaction Mode, Currency Code, Date
  • Key4: Our Bank, Status, Connect Batches, Connect Lines, Date

Events published

  • OnAfterCalculatePartOfBalance(DetailLineRec: Record "Detail Line"; var Percent: Decimal) (integration)
  • OnAfterCalculateBalance(DetailLine: Record "Detail Line"; var Balance: Decimal) (integration)
  • OnAfterSetKeyForCalculateTotalAmount(var DetailLine: Record "Detail Line") (integration)
  • OnBeforeFillVendorDescription(var DetailLine: Record "Detail Line"; Vendor: Record Vendor; VendorLedgerEntry: Record "Vendor Ledger Entry"; var IsHandled: Boolean) (integration)
  • OnBeforeSerialnoPostingLookup(var DetailLine: Record "Detail Line") (integration)
  • OnCalculateBalanceOnBeforeConvertToCurrency(var DetailLineRec: Record "Detail Line"; var VendLedgEntry: Record "Vendor Ledger Entry"; var CustLedgEntry: Record "Cust. Ledger Entry"; var Balance: Decimal) (integration)
  • OnCalculateTotalAmountOnBeforeCalcSums(var DetailLineRec: Record "Detail Line"; var DetailLine: Record "Detail Line"; var VendLedgEntry: Record "Vendor Ledger Entry"; var CustLedgEntry: Record "Cust. Ledger Entry") (integration)
  • OnSerialnoPostingLookupOnAfterGetVendLedgEntry(var DetailLineRec: Record "Detail Line"; var VendorLedgerEntry: Record "Vendor Ledger Entry") (integration)
  • OnSerialnoPostingLookupOnAfterCustEntryGetRecord(var DetailLine: Record "Detail Line"; var CustLedgerEntry: Record "Cust. Ledger Entry") (integration)
  • OnSerialnoPostingLookupOnBeforeVenEntryRunModal(var VendorLedgerEntry: Record "Vendor Ledger Entry") (integration)
  • OnValidateAmountEntryOnAfterCalcShowExceedMessage(var DetailLine: Record "Detail Line"; Difference: Decimal; RemainingAmount: Decimal; var ShowExceedMessage: Boolean) (integration)
  • OnValidateSerialNoEntryOnOnAfterGetVendorEntries(var DetailLine: Record "Detail Line"; VendorLedgerEntry: Record "Vendor Ledger Entry"; CurrFieldNo: Integer) (integration)
  • OnValidateSerialNoEntryOnBeforeValidateAmountFromCustLedgEntry(var DetailLineRec: Record "Detail Line"; TrMode: Record "Transaction Mode"; CustLedgEntry: Record "Cust. Ledger Entry"; var IsHandled: Boolean) (integration)
  • OnValidateSerialNoEntryOnBeforeValidateAmountFromVendLedgEntry(var DetailLineRec: Record "Detail Line"; TrMode: Record "Transaction Mode"; VendLedgEntry: Record "Vendor Ledger Entry"; CurrFieldNo: Integer; var IsHandled: Boolean) (integration)
  • OnValidateSerialNoEntryOnBeforeValidateAmountFromEmplLedgEntry(var DetailLineRec: Record "Detail Line"; TrMode: Record "Transaction Mode"; EmplLedgEntry: Record "Employee Ledger Entry"; var IsHandled: Boolean) (integration)
  • OnUpdateConnectionOnAfterGetProposalLine(var DetailLine: Record "Detail Line"; var ProposalLine: Record "Proposal Line"; ConnectedDetailLine: Record "Detail Line") (integration)
  • OnUpdateConnectionOnBeforeModifyProposalLine(var DetailLine: Record "Detail Line"; var ProposalLine: Record "Proposal Line"; ConnectedDetailLine: Record "Detail Line") (integration)

Procedures

  • CalculateBalance(UseCurrency: Code[10]): Decimal
  • CalculateTotalAmount(UseCurrency: Code[10]): Decimal
  • CalculatePartOfBalance(): Decimal
  • GetCustomerEntries(): Boolean
  • GetVendorEntries(): Boolean
  • GetEmployeeEntries(): Boolean
  • UpdateConnection()
  • InitRecord()
  • CalculateVariation(): Decimal
  • IsDifferentSign(FirstAmount: Decimal; SecondAmount: Decimal): Boolean

Plus 6 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

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

A NL 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