Diagrams


Table

Direct Debit Collection

DynamicsDocs.comDirect Debit Collection«Table 1207»Direct Debit CollectionNo. [PK]IdentifierCreated Date-TimeCreated by UserStatus; [New,Canceled,File Created,Pos...No. of TransfersTo Bank Account No.To Bank Account NameMessage IDPartner Type; [,Company,Person]«Table 1208»Direct Debit Collection EntryDirect Debit Collection No. [PK]Entry No. [PK]Customer No.Applies-to Entry No.Transfer DateCurrency CodeTransfer AmountTransaction IDSequence Type; [One Off,First,Recurrin...Status; [New,File Created,Rejected,Pos...Mandate IDMandate Type of Payment; [One Off,Recu...Customer NameApplies-to Entry Document No.Applies-to Entry DescriptionApplies-to Entry Posting DateApplies-to Entry Currency CodeApplies-to Entry AmountApplies-to Entry Rem. AmountApplies-to Entry OpenDirect Debit Collection Status; [New,C...«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...<Created by User><To Bank Account No.><Direct Debit Collection No.>

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

Fields

# Name Type
1 No. Integer
2 Identifier Code20
3 Created Date-Time DateTime
4 Created by User Code50
5 Status Option
6 No. of Transfers Integer FlowField
7 To Bank Account No. Code20
8 To Bank Account Name Text50 FlowField
9 Message ID Code35
10 Partner Type Option Editable: No

Keys

# Fields
0 No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
To Bank Account No. Bank Account No. 1..n
Created by User User User Name 1..n

Table Relations From Other Tables

From Table From Field
Direct Debit Collection Entry Direct Debit Collection No. 1..n