Table 10835 "Payment Header FR" (FR)
FR country layer · Microsoft.Bank.Payment
Across versions
- BC23-28not present
- BC29-30present
FR country layer · Microsoft.Bank.Payment · captioned “Payment Header” · BC29-30 · source at ea08af5e · facts from BC29
An object of the FR localization, not part of W1.
Properties
| Property | Value |
|---|---|
| Caption | Payment Header |
| 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 | No. | Code[20] | — | not editable |
| 2 | Currency Code | Code[10] | — | TableRelation Currency |
| 3 | Currency Factor | Decimal | — | |
| 4 | Posting Date | Date | — | |
| 5 | Document Date | Date | — | |
| 6 | Payment Class | Text[30] | — | TableRelation Payment Class FR |
| 7 | Status No. | Integer | — | TableRelation “Payment Status FR”.Line where(“Payment Class” = field(“Payment Class”)) |
| 8 | Status Name | Text[50] | — | FlowField: lookup(“Payment Status FR”.Name where(“Payment Class” = field(“Payment Class”), Line = field(“Status No.”))); not editable |
| 9 | Shortcut Dimension 1 Code | Code[20] | — | |
| 10 | Shortcut Dimension 2 Code | Code[20] | — | |
| 11 | Payment Class Name | Text[50] | — | FlowField: lookup(“Payment Class FR”.Name where(Code = field(“Payment Class”))); not editable |
| 12 | No. Series | Code[20] | — | TableRelation No. Series |
| 13 | Source Code | Code[10] | — | TableRelation Source Code |
| 14 | Account Type | enum “Gen. Journal Account Type” | — | enum Enum 81 “Gen. Journal Account Type” |
| 15 | Account No. | Code[20] | — | TableRelation if (“Account Type” = const(“G/L Account”)) “G/L Account” else if (“Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Account Type” = const(“Bank Account”)) “Bank Account” else if (“Account Type” = const(“Fixed Asset”)) “Fixed Asset” |
| 16 | Amount (LCY) | Decimal | — | FlowField: sum(“Payment Line FR”.“Amount (LCY)” where(“No.” = field(“No.”))); not editable |
| 17 | Amount | Decimal | — | FlowField: sum(“Payment Line FR”.Amount where(“No.” = field(“No.”))); not editable |
| 18 | Bank Branch No. | Text[20] | — | |
| 19 | Bank Account No. | Text[30] | — | |
| 20 | Agency Code | Text[20] | — | |
| 21 | RIB Key | Integer | — | |
| 22 | RIB Checked | Boolean | — | not editable |
| 23 | Bank Name | Text[100] | — | |
| 24 | Bank Post Code | Code[20] | — | TableRelation if (“Bank Country/Region Code” = const(‘’)) “Post Code” else if (“Bank Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Bank Country/Region Code”)) |
| 25 | Bank City | Text[30] | — | TableRelation if (“Bank Country/Region Code” = const(‘’)) “Post Code”.City else if (“Bank Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Bank Country/Region Code”)) |
| 26 | Bank Name 2 | Text[50] | — | |
| 27 | Bank Address | Text[100] | — | |
| 28 | Bank Address 2 | Text[50] | — | |
| 29 | Bank Contact | Text[100] | — | |
| 30 | Bank County | Text[30] | — | |
| 31 | Bank Country/Region Code | Code[10] | — | TableRelation Country/Region |
| 32 | National Issuer No. | Code[6] | — | |
| 40 | File Export Completed | Boolean | — | not editable |
| 41 | No. of Lines | Integer | — | FlowField: count(“Payment Line FR” where(“No.” = field(“No.”))); not editable |
| 42 | No. of Unposted Lines | Integer | — | FlowField: count(“Payment Line FR” where(“No.” = field(“No.”), Posted = const(false))); not editable |
| 43 | Archiving Authorized | Boolean | — | FlowField: lookup(“Payment Status FR”.“Archiving Authorized” where(“Payment Class” = field(“Payment Class”), Line = field(“Status No.”))); not editable |
| 50 | IBAN | Code[50] | — | |
| 51 | SWIFT Code | Code[20] | — | |
| 132 | Partner Type | Enum “Partner Type” | — | enum Enum 134 “Partner Type” |
| 480 | Dimension Set ID | Integer | — | TableRelation Dimension Set Entry; not editable |
Keys
- Key1: No. (clustered)
- Key2: Posting Date
- Key3: Payment Class
Procedures
LookupShortcutDimCode(FieldNo: Integer; var ShortcutDimCode: Code[20])ValidateShortcutDimCode(FieldNo: Integer; var ShortcutDimCode: Code[20])AssistEdit(OldPaymentHeader: Record "Payment Header FR"): BooleanInitBankAccount()TestNbOfLines()InitHeader()DimensionSetup()DimensionCreate()ShowDocDim()PaymentLinesExist(): Boolean
Plus 3 local procedures.
Triggers
OnDelete, OnInsert
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: "Payment Header FR"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.
A FR country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.