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

Keys

# Fields
0 Deferral Doc. Type,Gen. Jnl. Document No.,Account No.,Document Type,Document No.,Line No. (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) Currency Code (Code) 1..n
Deferral Account (Deferral Account) G/L Account () 1..n

Table Relations From Other Tables

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