Diagrams


Table

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><Currency Id><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

Fields

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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field