Diagrams


Table

SEPA Direct Debit Mandate

DynamicsDocs.comSEPA Direct Debit Mandate«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«Table 112»Sales Invoice HeaderSell-to Customer No. [NN]No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupCurrency Code...«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 172»Standard Customer Sales CodeCustomer No. [PK,NN]Code [PK,NN]DescriptionValid From DateValid To datePayment Method CodePayment Terms CodeDirect Debit Mandate IDBlocked«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 36»Sales HeaderDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.No. [PK]Bill-to Customer No. [NN]Bill-to NameBill-to Name 2Bill-to AddressBill-to Address 2Bill-to CityBill-to ContactYour ReferenceShip-to CodeShip-to NameShip-to Name 2Ship-to AddressShip-to Address 2Ship-to CityShip-to ContactOrder DatePosting DateShipment DatePosting DescriptionPayment Terms CodeDue DatePayment Discount %Pmt. Discount DateShipment Method CodeLocation CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting Group...«Table 81»Gen. Journal LineJournal Template Name [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeSystem-Created EntryOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Due Date...«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 287»Customer Bank AccountCustomer No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityPost CodeContactPhone No.Telex No.Bank Branch No.Bank Account No.Transit No.Currency CodeCountry/Region CodeCountyFax No.Telex Answer BackLanguage CodeE-MailHome PageIBANSWIFT CodeBank Clearing CodeBank Clearing Standard«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<Customer No.><Customer Bank Account Code><No. Series><Direct Debit Mandate ID><Mandate ID><Direct Debit Mandate ID><Direct Debit Mandate ID><Direct Debit Mandate ID><Direct Debit Mandate ID><Sell-to Customer No.><Bill-to Customer No.><Pre-Assigned No. Series><No. Series><Order No. Series><Prepayment No. Series><Cust. Ledger Entry No.><Last Posting No.><Last Prepayment No.><Customer No.><Applies-to Entry No.><Customer No.><Customer No.><Sell-to Customer No.><Bal. Account No.><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><No. Series><Recipient Bank Account><Sell-to Customer No.><Bill-to Customer No.><No. Series><Posting No. Series><Shipping No. Series><Prepayment No. Series><Prepmt. Cr. Memo No. Series><Return Receipt No. Series><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Posting No. Series><Recipient Bank Account><Bill-to Customer No.><No. Series><Preferred Bank Account><Customer No.>

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

Fields

# Name Type
1 ID Code35
2 Customer No. Code20 NotBlank: Yes
3 Customer Bank Account Code Code10 NotBlank: Yes
4 Valid From Date
5 Valid To Date
6 Date of Signature Date NotBlank: Yes
7 Type of Payment Option
8 Blocked Boolean
9 Expected Number of Debits Integer
10 Debit Counter Integer Editable: No
11 No. Series Code10
12 Closed Boolean Editable: No

Keys

# Fields
0 ID Clustered: Yes
1 Customer No.

Table Relations To Other Tables

Field Related Table Related Field
Customer No. Customer No. 1..n
Customer Bank Account Code Customer Bank Account Code 1..n
No. Series No. Series Code 1..n

Table Relations From Other Tables

From Table From Field
Cust. Ledger Entry Direct Debit Mandate ID 1..n
Direct Debit Collection Entry Mandate ID 1..n
Gen. Journal Line Direct Debit Mandate ID 1..n
Sales Header Direct Debit Mandate ID 1..n
Sales Invoice Header Direct Debit Mandate ID 1..n
Standard Customer Sales Code Direct Debit Mandate ID 1..n