Table 1232 Positive Pay Entry Detail
src/Layers/W1/BaseApp/Bank/PositivePay/PositivePayEntryDetail.Table.al167 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Bank.PositivePay;using Microsoft.Bank.BankAccount;using Microsoft.Finance.Currency;using System.Security.AccessControl;/// <summary>/// Stores individual check details for positive pay entries, providing detailed information about each check in an upload./// This table maintains the detailed check information that was uploaded to the bank for positive pay validation./// </summary>/// <remarks>/// The Positive Pay Entry Detail table stores the individual check records that were submitted to the bank as part of/// a positive pay upload. Each record represents a single check with its complete details including check number, amount,/// payee, and document type. This table provides an audit trail of what check information was sent to the bank and when./// The records are linked to their parent Positive Pay Entry through the bank account and upload date-time fields./// </remarks>table 1232 "Positive Pay Entry Detail"{ Caption = 'Positive Pay Entry Detail'; DataClassification = CustomerContent; fields { /// <summary> /// Bank account number for which this positive pay entry detail was uploaded. /// </summary> field(1; "Bank Account No."; Code[20]) { Caption = 'Bank Account No.'; ToolTip = 'Specifies the bank account number. If you select Balance at Date, the balance as of the last day in the relevant time interval is displayed.'; TableRelation = "Bank Account"."No."; } /// <summary> /// Date and time when this positive pay entry was uploaded to the bank. /// </summary> field(2; "Upload Date-Time"; DateTime) { Caption = 'Upload Date-Time'; TableRelation = "Positive Pay Entry"."Upload Date-Time" where("Bank Account No." = field("Bank Account No.")); } /// <summary> /// Sequential number identifying this detail record within the positive pay upload. /// </summary> field(3; "No."; Integer) { Caption = 'No.'; ToolTip = 'Specifies the number of the involved entry or record, according to the specified number series.'; } /// <summary> /// Check number as it appears on the physical check document. /// </summary> field(5; "Check No."; Code[20]) { Caption = 'Check No.'; ToolTip = 'Specifies the number on the check.'; } /// <summary> /// Currency code for the check amount, typically matching the bank account's currency. /// </summary> field(6; "Currency Code"; Code[10]) { Caption = 'Currency Code'; ToolTip = 'Specifies the currency code for the amount on the line.'; TableRelation = Currency.Code; } /// <summary> /// Type of document indicating whether this is a regular check or a voided check. /// </summary> field(7; "Document Type"; Option) { Caption = 'Document Type'; ToolTip = 'Specifies the type of the document on the line.'; OptionCaption = 'CHECK,VOID'; OptionMembers = CHECK,VOID; } /// <summary> /// Date when the check was issued or printed. /// </summary> field(8; "Document Date"; Date) { Caption = 'Document Date'; ToolTip = 'Specifies the date when the related document was created.'; } /// <summary> /// Monetary amount of the check in the specified currency. /// </summary> field(9; Amount; Decimal) { AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Amount'; ToolTip = 'Specifies the payment amount.'; } /// <summary> /// Name of the individual or organization to whom the check is payable. /// </summary> field(10; Payee; Text[100]) { Caption = 'Payee'; ToolTip = 'Specifies the recipient of the payment.'; DataClassification = EndUserIdentifiableInformation; } /// <summary> /// User ID of the person who created or last updated this positive pay entry detail. /// </summary> field(11; "User ID"; Code[50]) { Caption = 'User ID'; ToolTip = 'Specifies the ID of the user who posted the entry, to be used, for example, in the change log.'; DataClassification = EndUserIdentifiableInformation; TableRelation = User."User Name"; } /// <summary> /// Date when this positive pay entry detail was last updated. /// </summary> field(12; "Update Date"; Date) { Caption = 'Update Date'; ToolTip = 'Specifies when the Positive Pay export was updated.'; } } keys { key(Key1; "Bank Account No.", "Upload Date-Time", "No.") { Clustered = true; } } fieldgroups { } /// <summary> /// Copies data from a Positive Pay Detail record into this entry detail record for tracking purposes. /// </summary> /// <param name="PosPayDetail">The source positive pay detail record to copy data from.</param> /// <param name="BankAcct">The bank account code to associate with this entry detail.</param> /// <remarks> /// This procedure is used to create audit trail records that track what check information was uploaded to the bank. /// It maps document types from the export format to the entry detail format and sets tracking fields. /// </remarks> procedure CopyFromPosPayEntryDetail(PosPayDetail: Record "Positive Pay Detail"; BankAcct: Code[20]) begin "Bank Account No." := BankAcct; "No." := PosPayDetail."Entry No."; "Check No." := PosPayDetail."Check Number"; "Currency Code" := PosPayDetail."Currency Code"; if PosPayDetail."Record Type Code" = 'V' then "Document Type" := "Document Type"::VOID else "Document Type" := "Document Type"::CHECK; "Document Date" := PosPayDetail."Issue Date"; Amount := PosPayDetail.Amount; Payee := PosPayDetail.Payee; "User ID" := CopyStr(UserId(), 1, MaxStrLen("User ID")); "Update Date" := Today; end;}