Diagrams

Table

Positive Pay Footer

DynamicsDocs.comPositive Pay Footer«Table 1242»Positive Pay FooterData Exch. Entry No. [PK]Data Exch. Detail Entry No.Account NumberCheck CountCheck TotalVoid CountVoid TotalTotal CountGrand Total«Table 1220»Data Exch.Entry No. [PK]File NameFile ContentData Exch. Def CodeData Exch. Line Def CodeTable FiltersIncoming Entry No.Related Record«Table 1241»Positive Pay DetailData Exch. Entry No. [PK]Entry No. [PK]Account NumberRecord Type CodeVoid Check IndicatorCheck NumberAmountIssue DatePayeeCurrency Code<Data Exch. Entry No.><Data Exch. Detail Entry No.><Data Exch. Entry No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Data Exch. Entry No. (Data Exch. Entry No.) Integer
2 Data Exch. Detail Entry No. (Data Exch. Detail Entry No.) Integer
3 Account Number (Account Number) Text30
4 Check Count (Check Count) Integer BlankZero: Yes
FlowField
5 Check Total (Check Total) Decimal BlankZero: Yes
FlowField
6 Void Count (Void Count) Integer BlankZero: Yes
FlowField
7 Void Total (Void Total) Decimal BlankZero: Yes
FlowField
8 Total Count (Total Count) Integer BlankZero: Yes
FlowField
9 Grand Total (Grand Total) Decimal BlankZero: Yes
FlowField

Keys

# Fields
0 Data Exch. Entry No. (Data Exch. Entry No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Data Exch. Entry No. (Data Exch. Entry No.) Data Exch. Entry No. (Entry No.) 1..1
Data Exch. Detail Entry No. (Data Exch. Detail Entry No.) Positive Pay Detail Data Exch. Entry No. (Data Exch. Entry No.) 1..n

Table Relations From Other Tables

From Table From Field