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

Table 31006 "Sales Adv. Letter Entry CZZ" (CZ)

CZ country layer · Microsoft.Finance.AdvancePayments

Open in Claude31006-cz.mdSource on GitHub

Across versions

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

CZ country layer · Microsoft.Finance.AdvancePayments · captioned “Sales Adv. Letter Entry” · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property Value
Caption Sales Adv. Letter Entry
DataClassification CustomerContent
LookupPageId Sales Adv. Letter Entries CZZ
DrillDownPageId Sales Adv. Letter Entries CZZ

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 Entry No. Integer —
5 Sales Adv. Letter No. Code[20] — TableRelation Sales Adv. Letter Header CZZ
10 Entry Type Enum “Advance Letter Entry Type CZZ” — enum Advance Letter Entry Type CZZ
13 Document No. Code[20] —
15 VAT Bus. Posting Group Code[20] — TableRelation VAT Business Posting Group
16 VAT Prod. Posting Group Code[20] — TableRelation VAT Product Posting Group
17 VAT % Decimal —
18 VAT Identifier Code[20] —
19 VAT Calculation Type Enum “Tax Calculation Type” — enum Enum 254 “Tax Calculation Type”
25 Currency Code Code[10] — TableRelation Currency
26 Currency Factor Decimal —
27 Additional Currency Factor Decimal — not editable
28 User ID Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
30 Posting Date Date —
33 VAT Date Date —
35 VAT Entry No. Integer — TableRelation VAT Entry
38 Cust. Ledger Entry No. Integer — TableRelation Cust. Ledger Entry
39 Det. Cust. Ledger Entry No. Integer Detailed Cust. Ledger Entry No. caption TableRelation Detailed Cust. Ledg. Entry
40 VAT Base Amount Decimal —
41 VAT Amount Decimal —
42 Amount Decimal —
45 VAT Base Amount (LCY) Decimal —
46 VAT Amount (LCY) Decimal —
47 Amount (LCY) Decimal —
50 Cancelled Boolean —
55 Related Entry Integer — TableRelation Sales Adv. Letter Entry CZZ
60 Global Dimension 1 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(1))
61 Global Dimension 2 Code Code[20] — TableRelation “Dimension Value”.Code where(“Global Dimension No.” = const(2))
70 Customer No. Code[20] — TableRelation Customer; not editable
80 Auxiliary Entry Boolean — not editable
85 External Document No. Code[35] Specifies a document number that refers to the customer’s numbering system.
480 Dimension Set ID Integer — TableRelation Dimension Set Entry; not editable

Keys

  • PK: Entry No. (clustered)
  • Key2: Sales Adv. Letter No., Entry Type
  • Key3: Related Entry
  • Key4: Document No., Posting Date, Cancelled
  • Key5: Posting Date
  • Key6: Det. Cust. Ledger Entry No.

Events published

  • OnBeforePrintRecords(var ReportSelections: Record "Report Selections"; var SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ"; ShowRequestPage: Boolean; var IsHandled: Boolean) (integration)
  • OnBeforeEmailRecords(var ReportSelections: Record "Report Selections"; var SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ"; DocTxt: Text; ShowDialog: Boolean; var IsHandled: Boolean) (integration)
  • OnAfterInitNewEntry(var SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ") (integration)
  • OnAfterInitRelatedEntry(RelatedSalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ"; var SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ") (integration)
  • OnAfterInitCustLedgerEntry(CustLedgerEntry: Record "Cust. Ledger Entry"; var SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ") (integration)
  • OnAfterInitDetailedCustLedgerEntry(DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry"; var SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ") (integration)
  • OnAfterCopyFromGenJnlLine(GenJournalLine: Record "Gen. Journal Line"; var SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ") (integration)
  • OnAfterCopyFromVATPostingSetup(VATPostingSetup: Record "VAT Posting Setup"; var SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ") (integration)
  • OnAfterCopyFromSalesAdvLetterHeader(SalesAdvLetterHeaderCZZ: Record "Sales Adv. Letter Header CZZ"; var SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ") (integration)
  • OnBeforeInsertNewEntry(WriteToDatabase: Boolean; var SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ") (integration)
  • OnAfterInsertNewEntry(WriteToDatabase: Boolean; var SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ") (integration)
  • OnAfterRemainingAmount(SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ"; BalanceAtDate: Date; var RemainingAmount: Decimal) (integration)
  • OnAfterRemainingAmountLCY(SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ"; BalanceAtDate: Date; var RemainingAmountLCY: Decimal) (integration)

Procedures

  • ShowDimensions()
  • PrintRecords(ShowRequestPage: Boolean)
  • EmailRecords(ShowDialog: Boolean)
  • CalcUsageVATAmountLines(var SalesInvoiceHeader: Record "Sales Invoice Header"; var VATAmountLine: Record "VAT Amount Line")
  • CalcDocumentAmount(): Decimal
  • GetCustomerNo(): Code[20] (internal)
  • InitNewEntry()
  • InitRelatedEntry(EntryNo: Integer)
  • InitRelatedEntry(SalesAdvLetterEntryCZZ: Record "Sales Adv. Letter Entry CZZ")
  • InitCustLedgerEntry(CustLedgerEntry: Record "Cust. Ledger Entry")
  • InitDetailedCustLedgerEntry(DetailedCustLedgEntryNo: Integer)
  • InitDetailedCustLedgerEntry(DetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry")
  • CopyFromGenJnlLine(GenJournalLine: Record "Gen. Journal Line")
  • CopyFromVATPostingSetup(VATPostingSetup: Record "VAT Posting Setup")
  • CopyFromSalesAdvLetterHeader(SalesAdvLetterHeaderCZZ: Record "Sales Adv. Letter Header CZZ")
  • InsertNewEntry(WriteToDatabase: Boolean): Integer
  • GetRemainingAmount(): Decimal
  • GetRemainingAmount(BalanceAtDate: Date): Decimal
  • GetRemainingAmountLCY(): Decimal
  • GetRemainingAmountLCY(BalanceAtDate: Date): Decimal
  • GetAdjustedCurrencyFactor(): Decimal

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: "Sales Adv. Letter Entry CZZ"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

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