Table 1241 Positive Pay Detail
src/Layers/W1/BaseApp/Bank/PositivePay/PositivePayDetail.Table.al118 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 System.IO;/// <summary>/// Stores detailed check information for positive pay export files, containing individual check data for bank validation./// This table represents the detail records in positive pay files that banks use to verify issued checks./// </summary>/// <remarks>/// The Positive Pay Detail table contains individual check records that are exported to banks for positive pay validation./// Each record represents a single check with its essential attributes including check number, amount, payee, and issue date./// This table is populated during the positive pay export process and is linked to data exchange entries for tracking and processing./// The table supports both regular and voided checks through the void indicator field./// </remarks>table 1241 "Positive Pay Detail"{ Caption = 'Positive Pay Detail'; DataClassification = CustomerContent; fields { /// <summary> /// Links this detail record to the associated data exchange entry for tracking and processing. /// </summary> field(1; "Data Exch. Entry No."; Integer) { Caption = 'Data Exch. Entry No.'; TableRelation = "Data Exch."."Entry No."; } /// <summary> /// Unique sequential number identifying this detail record within the data exchange entry. /// </summary> field(2; "Entry No."; Integer) { Caption = 'Entry No.'; } /// <summary> /// Bank account number for which this positive pay detail is being generated. /// </summary> field(3; "Account Number"; Text[30]) { Caption = 'Account Number'; } /// <summary> /// Code indicating the type of record (typically 'D' for detail records in positive pay files). /// </summary> field(4; "Record Type Code"; Text[1]) { Caption = 'Record Type Code'; } /// <summary> /// Indicator specifying whether this check has been voided ('V' for voided, blank for active). /// </summary> field(5; "Void Check Indicator"; Text[1]) { Caption = 'Void Check Indicator'; } /// <summary> /// The check number as printed on the physical check document. /// </summary> field(6; "Check Number"; Code[20]) { Caption = 'Check Number'; } /// <summary> /// The monetary amount of the check in the account's base currency. /// </summary> field(7; Amount; Decimal) { AutoFormatType = 1; AutoFormatExpression = "Currency Code"; Caption = 'Amount'; } /// <summary> /// The date when the check was issued or printed. /// </summary> field(8; "Issue Date"; Date) { Caption = 'Issue Date'; } /// <summary> /// The name of the individual or organization to whom the check is payable. /// </summary> field(9; Payee; Text[100]) { Caption = 'Payee'; DataClassification = EndUserIdentifiableInformation; } /// <summary> /// Currency code for the check amount, typically matching the bank account's currency. /// </summary> field(10; "Currency Code"; Code[10]) { Caption = 'Currency Code'; } } keys { key(Key1; "Data Exch. Entry No.", "Entry No.") { Clustered = true; } key(Key2; "Void Check Indicator") { } } fieldgroups { }}