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. Integer
2 Entry No. Integer
3 Account Type Option
4 Account No. Code20
5 Applies-to Entry No. Integer
6 Transfer Date Date
7 Currency Code Code10
8 Transfer Amount Decimal
9 Transaction ID Text35
10 Canceled Boolean FlowField
11 Recipient Bank Acc. No. Code50
12 Message to Recipient Text140

Keys

# Fields
0 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. 1..n
Currency Code Currency Code 1..n
Applies-to Entry No. Cust. Ledger Entry Entry No. 1..n
Account No. Customer No. 1..n
Account No. Vendor No. 1..n
Applies-to Entry No. Vendor Ledger Entry Entry No. 1..n

Table Relations From Other Tables

From Table From Field