Diagrams

Table

Credit Transfer Entry

DynamicsDocs.comCredit Transfer Entry«Table 1206»Credit Transfer EntryCredit Transfer Register No. [PK]Entry No. [PK]Account Type; [Customer,Vendor]Account No.Applies-to Entry No.Transfer DateCurrency CodeTransfer AmountTransaction IDCanceledRecipient Bank Acc. No.Message to Recipient«Table 1205»Credit Transfer RegisterNo. [PK]IdentifierCreated Date-TimeCreated by UserStatus; [Canceled,File Created,File Re...No. of TransfersFrom Bank Account No.From Bank Account NameExported File«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 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«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 25»Vendor Ledger EntryEntry No. [PK]Vendor No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Purchase [LCY]Inv. Discount [LCY]Buy-from Vendor No.Vendor Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodePurchaser CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Rcd.[LCY]PositiveClosed by Entry No....«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]...<Credit Transfer Register No.><Account No.><Account No.><Applies-to Entry No.><Applies-to Entry No.><Currency Code><Currency Code><Currency Filter><Customer Filter><Bill-to Customer No.><Customer No.><Sell-to Customer No.><Bal. Account No.><Bal. Account No.><Currency Code><Currency Filter><Vendor Filter><Pay-to Vendor No.><Bal. Account No.><Vendor No.><Buy-from Vendor No.><Bal. Account No.><Currency Code><Closed by Currency Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Currency Code><Closed by Currency Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.>

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

Fields

# Name Type
1 Credit Transfer Register No. (Credit Transfer Register No.) Integer
2 Entry No. (Entry No.) Integer
3 Account Type (Account Type) Option
4 Account No. (Account No.) Code20
5 Applies-to Entry No. (Applies-to Entry No.) Integer
6 Transfer Date (Transfer Date) Date
7 Currency Code (Currency Code) Code10
8 Transfer Amount (Transfer Amount) Decimal
9 Transaction ID (Transaction ID) Text35
10 Canceled (Canceled) Boolean FlowField
11 Recipient Bank Acc. No. (Recipient Bank Acc. No.) Code50
12 Message to Recipient (Message to Recipient) Text140

Keys

# Fields
0 Credit Transfer Register No.,Entry No. (Credit Transfer Register No.,Entry No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Credit Transfer Register No. (Credit Transfer Register No.) Credit Transfer Register No. (No.) 1..n
Currency Code (Currency Code) Currency Code (Code) 1..n
Applies-to Entry No. (Applies-to Entry No.) Cust. Ledger Entry Entry No. (Entry No.) 1..n
Account No. (Account No.) Customer No. (No.) 1..n
Account No. (Account No.) Vendor No. (No.) 1..n
Applies-to Entry No. (Applies-to Entry No.) Vendor Ledger Entry Entry No. (Entry No.) 1..n

Table Relations From Other Tables

From Table From Field