Diagrams


Table

Deferral Header

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. Template Name (Gen. Jnl. Template Name) Code10
3 Gen. Jnl. Batch Name (Gen. Jnl. Batch Name) Code10
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
14 Initial Amount to Defer (Initial Amount to Defer) Decimal
15 Currency Code (Currency Code) Code10
20 Schedule Line Total (Schedule Line Total) Decimal FlowField

Keys

# Fields
0 Deferral Doc. Type,Gen. Jnl. Template Name,Gen. Jnl. Batch Name,Document Type,Document No.,Line No. (Deferral Doc. Type,Gen. Jnl. Template Name,Gen. Jnl. Batch Name,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

Table Relations From Other Tables

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