tableFinanceofficial - Microsoftderived - from the source, no model text

Table 11510 "Swiss QR-Bill Buffer" (CH)

CH country layer · Microsoft.Bank.Payment

Across versions

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

CH country layer · Microsoft.Bank.Payment · captioned “QR-Bill Buffer” · BC29-30 · source at ea08af5e · facts from BC29

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

Properties

Property Value
Caption QR-Bill Buffer
DataClassification CustomerContent
Permissions TableData “Sales Invoice Header” = rm, TableData “Cust. Ledger Entry” = 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 Entry No. Integer — AutoIncrement
2 IBAN Code[50] —
3 Amount Decimal —
4 Currency Code[10] — TableRelation Currency where(“ISO Code” = filter(‘CHF’ | ‘EUR’))
5 Payment Reference Type Enum “Swiss QR-Bill Payment Reference Type” Reference Type caption enum Swiss QR-Bill Payment Reference Type
6 Payment Reference Code[50] — not editable
7 Unstructured Message Text[140] —
8 Billing Information Text[140] —
9 Alt. Procedure Name 1 Text[10] Name caption
10 Alt. Procedure Value 1 Text[100] Value caption
11 Alt. Procedure Name 2 Text[10] Name caption
12 Alt. Procedure Value 2 Text[100] Value caption
14 IBAN Type enum “Swiss QR-Bill IBAN Type” — enum Swiss QR-Bill IBAN Type
15 Language Code Code[10] — TableRelation Language where(“Windows Language ID” = filter(1033 | 2055 | 4108 | 2064))
16 Format Region Text[80] — TableRelation “Language Selection”.“Language Tag”
20 Creditor Address Type Enum “Swiss QR-Bill Address Type” Address Type caption enum Swiss QR-Bill Address Type
21 Creditor Name Text[70] Name caption
22 Creditor Street Or AddrLine1 Text[70] Street Or Address Line 1 caption
23 Creditor BuildNo Or AddrLine2 Text[70] Building Number Or Address Line 2 caption
24 Creditor Postal Code Code[16] Postal Code caption TableRelation if (“Creditor Country” = const(‘’)) “Post Code” else “Post Code” where(“Country/Region Code” = field(“Creditor Country”))
25 Creditor City Text[30] City caption TableRelation if (“Creditor Country” = const(‘’)) “Post Code”.City else “Post Code”.City where(“Country/Region Code” = field(“Creditor Country”))
26 Creditor Country Code[2] Country caption TableRelation Country/Region
30 UCreditor Address Type Enum “Swiss QR-Bill Address Type” Address Type caption enum Swiss QR-Bill Address Type
31 UCreditor Name Text[70] Name caption
32 UCreditor Street Or AddrLine1 Text[70] Street Or Address Line 1 caption
33 UCreditor BuildNo Or AddrLine2 Text[70] Building Number Or Address Line 2 caption
34 UCreditor Postal Code Code[16] Postal Code caption TableRelation if (“UCreditor Country” = const(‘’)) “Post Code” else “Post Code” where(“Country/Region Code” = field(“UCreditor Country”))
35 UCreditor City Text[30] City caption TableRelation if (“UCreditor Country” = const(‘’)) “Post Code”.City else “Post Code”.City where(“Country/Region Code” = field(“UCreditor Country”))
36 UCreditor Country Code[2] Country caption TableRelation Country/Region
40 UDebtor Address Type Enum “Swiss QR-Bill Address Type” Address Type caption enum Swiss QR-Bill Address Type
41 UDebtor Name Text[70] Name caption
42 UDebtor Street Or AddrLine1 Text[70] Street Or Address Line 1 caption
43 UDebtor BuildNo Or AddrLine2 Text[70] Building Number Or Address Line 2 caption
44 UDebtor Postal Code Code[16] Postal Code caption TableRelation if (“UDebtor Country” = const(‘’)) “Post Code” else “Post Code” where(“Country/Region Code” = field(“UDebtor Country”))
45 UDebtor City Text[30] City caption TableRelation if (“UDebtor Country” = const(‘’)) “Post Code”.City else “Post Code”.City where(“Country/Region Code” = field(“UDebtor Country”))
46 UDebtor Country Code[2] Country caption TableRelation Country/Region
100 QR-Code Image Media —
102 File Name Text[250] QR-Bill PDF File Name caption
104 QR-Bill Layout Code[20] — TableRelation Swiss QR-Bill Layout
105 Source Record Printed Boolean —
106 Customer Ledger Entry No. Integer Customer Ledger Entry caption

Keys

  • PK: Entry No. (clustered)

Events published

  • OnBeforeValidateIBAN(var IBAN: Code[50]) (integration)
  • OnBeforeGetReferenceNo(var SwissQRBillBuffer: Record "Swiss QR-Bill Buffer"; UpdateLastUsed: Boolean; var Result: Code[50]; var IsHandled: Boolean) (integration)
  • OnAfterValidateIBAN(var IBAN: Code[50]) (integration)
  • OnAfterSetSourceRecord(var SwissQRBillBuffer: Record "Swiss QR-Bill Buffer"; var SwissQRBillLayout: Record "Swiss QR-Bill Layout") (integration)

Procedures

  • AddBufferRecord(SourceSwissQRBillBuffer: Record "Swiss QR-Bill Buffer")
  • InitBuffer(QRBillLayoutCode: Code[20])
  • SetQRCodeImage(TempBlob: Codeunit "Temp Blob") (internal)
  • SetCompanyInformation() (internal)
  • SetCreditorInfo(Customer: Record Customer) (internal)
  • SetUltimateCreditorInfo(Customer: Record Customer) (internal)
  • SetUltimateDebitorInfo(Customer: Record Customer) (internal)
  • SetUltimateDebitorInfo(DocumentRecRef: RecordRef) (internal)
  • GetCreditorInfo(var Customer: Record Customer): Boolean
  • GetUltimateCreditorInfo(var Customer: Record Customer): Boolean (internal)
  • GetUltimateDebitorInfo(var Customer: Record Customer): Boolean
  • LoadLayout(QRBillLayoutCode: Code[20]) (internal)
  • CheckLimitForUnstrAndBillInfoText()
  • InitSourceRecord(RecRef: RecordRef) (internal)
  • SetSourceRecord(CustomerLedgerEntryNo: Integer)
  • PrepareForPrint()
  • EnableEditingOfAlreadyPrinted() (internal)

Plus 9 local procedures.

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: "Swiss QR-Bill Buffer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

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