Table 11510 "Swiss QR-Bill Buffer" (CH)
CH country layer · Microsoft.Bank.Payment
Across versions
- BC23-28not present
- 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): BooleanGetUltimateCreditorInfo(var Customer: Record Customer): Boolean(internal)GetUltimateDebitorInfo(var Customer: Record Customer): BooleanLoadLayout(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.