Diagrams


Table

Posted Deferral Header

DynamicsDocs.comPosted Deferral Header«Table 1704»Posted Deferral HeaderDeferral Doc. Type; [Purchase,Sales,G/...Gen. Jnl. Document No. [PK]Account No. [PK]Document Type [PK]Document No. [PK]Line No. [PK]Deferral Code [NN]Amount to DeferAmount to Defer [LCY]Calc. Method; [Straight-Line,Equal per...Start DateNo. of Periods [NN]Schedule DescriptionCurrency CodeDeferral Account [NN]CustVendorNoPosting DateEntry No.«Table 1705»Posted Deferral LineDeferral Doc. Type; [Purchase,Sales,G/...Gen. Jnl. Document No. [PK]Account No. [PK]Document Type [PK]Document No. [PK]Line No. [PK]Posting Date [PK]DescriptionAmountAmount [LCY]Currency CodeDeferral Account [NN]«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc.Business Unit Filter...«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]...<Account No.><Deferral Account><Currency Code><Deferral Doc. Type><Gen. Jnl. Document No.><Account No.><Document Type><Document No.><Line No.><Deferral Account><Unrealized Gains Acc.><Realized Gains Acc.><Unrealized Losses Acc.><Realized Losses Acc.><Realized G/L Gains Account><Realized G/L Losses Account><Residual Gains Account><Residual Losses Account><Conv. LCY Rndg. Debit Acc.><Conv. LCY Rndg. Credit Acc.>

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

Fields

# Name Type
1 Deferral Doc. Type Option
2 Gen. Jnl. Document No. Code20
3 Account No. Code20
4 Document Type Integer
5 Document No. Code20
6 Line No. Integer
7 Deferral Code Code10 NotBlank: Yes
8 Amount to Defer Decimal
9 Amount to Defer (LCY) Decimal
10 Calc. Method Option
11 Start Date Date
12 No. of Periods Integer NotBlank: Yes
BlankZero: Yes
13 Schedule Description Text50
15 Currency Code Code10
16 Deferral Account Code20 NotBlank: Yes
17 CustVendorNo Code20
18 Posting Date Date
19 Entry No. Integer

Keys

# Fields
0 Deferral Doc. Type,Gen. Jnl. Document No.,Account No.,Document Type,Document No.,Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Currency Code Currency Code 1..n
Deferral Account G/L Account 1..n

Table Relations From Other Tables

From Table From Field
Posted Deferral Line Line No. 1..n