Direct Debit Collection Entry

DynamicsDocs.comDirect Debit Collection Entry«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 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 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 21»Cust. Ledger EntryEntry No. [PK]Customer No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Sales [LCY]Profit [LCY]Inv. Discount [LCY]Sell-to Customer No.Customer Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeSalesperson CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Given [LCY]Positive...«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«Table 1230»SEPA Direct Debit MandateID [PK]Customer No. [NN]Customer Bank Account Code [NN]Valid FromValid ToDate of Signature [NN]Type of Payment; [OneOff,Recurrent]BlockedExpected Number of DebitsDebit CounterNo. SeriesClosed<Direct Debit Collection No.><Customer No.><Applies-to Entry No.><Currency Code><Applies-to Entry Currency Code><Mandate ID><Currency Code><Currency Filter><Customer Filter><Bill-to Customer No.><Customer No.><Customer No.><Sell-to Customer No.><Bal. Account No.><Currency Code><Closed by Currency Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Direct Debit Mandate ID>

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


# Name Type
1 Direct Debit Collection No. (Direct Debit Collection No.) Integer
2 Entry No. (Entry No.) Integer
3 Customer No. (Customer No.) Code20
4 Applies-to Entry No. (Applies-to Entry No.) Integer
5 Transfer Date (Transfer Date) Date
6 Currency Code (Currency Code) Code10 Editable: No
7 Transfer Amount (Transfer Amount) Decimal
8 Transaction ID (Transaction ID) Text35 Editable: No
9 Sequence Type (Sequence Type) Option Editable: No
10 Status (Status) Option Editable: No
11 Mandate ID (Mandate ID) Code35
12 Mandate Type of Payment (Mandate Type of Payment) Option Editable: No
13 Customer Name (Customer Name) Text50 Editable: No
14 Applies-to Entry Document No. (Applies-to Entry Document No.) Code20 Editable: No
15 Applies-to Entry Description (Applies-to Entry Description) Text50 Editable: No
16 Applies-to Entry Posting Date (Applies-to Entry Posting Date) Date Editable: No
17 Applies-to Entry Currency Code (Applies-to Entry Currency Code) Code10 Editable: No
18 Applies-to Entry Amount (Applies-to Entry Amount) Decimal Editable: No
19 Applies-to Entry Rem. Amount (Applies-to Entry Rem. Amount) Decimal Editable: No
20 Applies-to Entry Open (Applies-to Entry Open) Boolean Editable: No
21 Direct Debit Collection Status (Direct Debit Collection Status) Option FlowField


# Fields
0 Direct Debit Collection No.,Entry No. (Direct Debit Collection No.,Entry No.) Clustered: Yes
1 Applies-to Entry No.,Status (Applies-to Entry No.,Status)

Table Relations To Other Tables

Field Related Table Related Field
Applies-to Entry Currency Code (Applies-to Entry Currency Code) Currency Code (Code) 1..n
Applies-to Entry No. (Applies-to Entry No.) Cust. Ledger Entry () 1..n
Customer No. (Customer No.) Customer No. (No.) 1..n
Direct Debit Collection No. (Direct Debit Collection No.) Direct Debit Collection No. (No.) 1..n
Mandate ID (Mandate ID) SEPA Direct Debit Mandate ID (ID) 1..n

Table Relations From Other Tables

From Table From Field