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

Table 31009 "Purch. Adv. Letter Entry CZZ" (CZ)

CZ country layer · Microsoft.Finance.AdvancePayments

Open in Claude31009-cz.mdSource on GitHub

Across versions

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

CZ country layer · Microsoft.Finance.AdvancePayments · captioned “Purchase 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 Purchase Adv. Letter Entry
DataClassification CustomerContent
LookupPageId Purch. Adv. Letter Entries CZZ
DrillDownPageId Purch. 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 Purch. Adv. Letter No. Code[20] — TableRelation Purch. 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 —
34 Original Document VAT Date Date —
35 VAT Entry No. Integer — TableRelation VAT Entry
38 Vendor Ledger Entry No. Integer — TableRelation Vendor Ledger Entry
39 Det. Vendor Ledger Entry No. Integer Detailed Vendor Ledger Entry No. caption TableRelation Detailed Vendor 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 Purch. 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))
65 External Document No. Code[35] —
70 Non-Deductible VAT % Decimal Non-Deductible VAT %” caption
80 Auxiliary Entry Boolean — not editable
480 Dimension Set ID Integer — TableRelation Dimension Set Entry; not editable

Keys

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

Events published

  • OnBeforePrintRecords(var ReportSelections: Record "Report Selections"; var PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ"; ShowRequestPage: Boolean; var IsHandled: Boolean) (integration)
  • OnAfterInitNewEntry(var PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ") (integration)
  • OnAfterInitRelatedEntry(RelatedPurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ"; var PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ") (integration)
  • OnAfterInitVendorLedgerEntry(VendorLedgerEntry: Record "Vendor Ledger Entry"; var PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ") (integration)
  • OnAfterInitDetailedVendorLedgerEntry(DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry"; var PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ") (integration)
  • OnAfterCopyFromGenJnlLine(GenJournalLine: Record "Gen. Journal Line"; var PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ") (integration)
  • OnAfterCopyFromVATPostingSetup(VATPostingSetup: Record "VAT Posting Setup"; var PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ") (integration)
  • OnAfterCopyFromPurchAdvLetterHeader(PurchAdvLetterHeaderCZZ: Record "Purch. Adv. Letter Header CZZ"; var PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ") (integration)
  • OnBeforeInsertNewEntry(WriteToDatabase: Boolean; var PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ") (integration)
  • OnAfterInsertNewEntry(WriteToDatabase: Boolean; var PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ") (integration)
  • OnAfterRemainingAmount(PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ"; BalanceAtDate: Date; var RemainingAmount: Decimal) (integration)
  • OnAfterRemainingAmountLCY(PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ"; BalanceAtDate: Date; var RemainingAmountLCY: Decimal) (integration)

Procedures

  • ShowDimensions()
  • PrintRecords(ShowRequestPage: Boolean)
  • CalcUsageVATAmountLines(var PurchInvHeader: Record "Purch. Inv. Header"; var VATAmountLine: Record "VAT Amount Line")
  • CalcDocumentAmount(): Decimal
  • InitNewEntry()
  • InitRelatedEntry(EntryNo: Integer)
  • InitRelatedEntry(PurchAdvLetterEntryCZZ: Record "Purch. Adv. Letter Entry CZZ")
  • InitVendorLedgerEntry(VendorLedgerEntry: Record "Vendor Ledger Entry")
  • InitDetailedVendorLedgerEntry(DetailedVendorLedgEntryNo: Integer)
  • InitDetailedVendorLedgerEntry(DetailedVendorLedgEntry: Record "Detailed Vendor Ledg. Entry")
  • CopyFromGenJnlLine(GenJournalLine: Record "Gen. Journal Line")
  • CopyFromVATPostingSetup(VATPostingSetup: Record "VAT Posting Setup")
  • CopyFromPurchAdvLetterHeader(PurchAdvLetterHeaderCZZ: Record "Purch. Adv. Letter Header CZZ")
  • InsertNewEntry(WriteToDatabase: Boolean): Integer
  • GetRemainingAmount(): Decimal
  • GetRemainingAmount(BalanceAtDate: Date): Decimal
  • GetRemainingAmountLCY(): Decimal
  • GetRemainingAmountLCY(BalanceAtDate: Date): Decimal
  • IsNonDeductibleVATAllowed(): Boolean (internal)
  • CheckNonDeductibleVATAllowed() (internal)
  • 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: "Purch. 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