Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Journal Template Name (Journal Template Name) | Code10 |
|
NotBlank: Yes Editable: No |
2 | Line No. (Line No.) | Integer | NotBlank: Yes Editable: No |
|
3 | Account Type (Account Type) | Option | [G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee] | |
4 | Account No. (Account No.) | Code20 |
|
|
6 | Document Type (Document Type) | Option | [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund] | |
8 | Description (Description) | Text50 | ||
10 | VAT % (VAT %) | Decimal (0:5) | MaxValue: 100 | Editable: No |
11 | Bal. Account No. (Bal. Account No.) | Code20 |
|
|
12 | Currency Code (Currency Code) | Code10 |
|
|
13 | Amount (Amount) | Decimal | AutoFormatType: 1 | |
14 | Debit Amount (Debit Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
BlankZero: Yes |
15 | Credit Amount (Credit Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
BlankZero: Yes |
16 | Amount (LCY) (Amount (LCY)) | Decimal | AutoFormatType: 1 | |
17 | Balance (LCY) (Balance (LCY)) | Decimal | AutoFormatType: 1 | Editable: No |
18 | Currency Factor (Currency Factor) | Decimal (0:15) | Editable: No | |
19 | Sales/Purch. (LCY) (Sales/Purch. (LCY)) | Decimal | AutoFormatType: 1 | |
20 | Profit (LCY) (Profit (LCY)) | Decimal | AutoFormatType: 1 | |
21 | Inv. Discount (LCY) (Inv. Discount (LCY)) | Decimal | AutoFormatType: 1 | |
22 | Bill-to/Pay-to No. (Bill-to/Pay-to No.) | Code20 |
|
|
23 | Posting Group (Posting Group) | Code20 |
|
Editable: No |
24 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
25 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
26 | Salespers./Purch. Code (Salespers./Purch. Code) | Code20 |
|
|
29 | Source Code (Source Code) | Code10 |
|
Editable: No |
34 | On Hold (On Hold) | Code3 | ||
35 | Applies-to Doc. Type (Applies-to Doc. Type) | Option | [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund] | |
40 | Payment Discount % (Payment Discount %) | Decimal (0:5) | MaxValue: 100 | |
42 | Job No. (Job No.) | Code20 |
|
Editable: No |
43 | Quantity (Quantity) | Decimal (0:5) | ||
44 | VAT Amount (VAT Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
47 | Payment Terms Code (Payment Terms Code) | Code10 |
|
|
50 | Business Unit Code (Business Unit Code) | Code20 |
|
|
51 | Standard Journal Code (Standard Journal Code) | Code10 |
|
|
52 | Reason Code (Reason Code) | Code10 |
|
|
57 | Gen. Posting Type (Gen. Posting Type) | Option | [ ,Purchase,Sale,Settlement] | |
58 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code20 |
|
|
59 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code20 |
|
|
60 | VAT Calculation Type (VAT Calculation Type) | Option | [Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax] | Editable: No |
63 | Bal. Account Type (Bal. Account Type) | Option | [G/L Account,Customer,Vendor,Bank Account,Fixed Asset,IC Partner,Employee] | |
64 | Bal. Gen. Posting Type (Bal. Gen. Posting Type) | Option | [ ,Purchase,Sale,Settlement] | |
65 | Bal. Gen. Bus. Posting Group (Bal. Gen. Bus. Posting Group) | Code20 |
|
|
66 | Bal. Gen. Prod. Posting Group (Bal. Gen. Prod. Posting Group) | Code20 |
|
|
67 | Bal. VAT Calculation Type (Bal. VAT Calculation Type) | Option | [Normal VAT,Reverse Charge VAT,Full VAT,Sales Tax] | Editable: No |
68 | Bal. VAT % (Bal. VAT %) | Decimal (0:5) | MaxValue: 100 | Editable: No |
69 | Bal. VAT Amount (Bal. VAT Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
70 | Bank Payment Type (Bank Payment Type) | Option | [ ,Computer Check,Manual Check] | |
71 | VAT Base Amount (VAT Base Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
72 | Bal. VAT Base Amount (Bal. VAT Base Amount) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
|
73 | Correction (Correction) | Boolean | ||
78 | Source Type (Source Type) | Option | [ ,Customer,Vendor,Bank Account,Fixed Asset] | |
79 | Source No. (Source No.) | Code20 |
|
|
80 | Posting No. Series (Posting No. Series) | Code20 |
|
|
82 | Tax Area Code (Tax Area Code) | Code20 |
|
|
83 | Tax Liable (Tax Liable) | Boolean | ||
84 | Tax Group Code (Tax Group Code) | Code20 |
|
|
85 | Use Tax (Use Tax) | Boolean | ||
86 | Bal. Tax Area Code (Bal. Tax Area Code) | Code20 |
|
|
87 | Bal. Tax Liable (Bal. Tax Liable) | Boolean | ||
88 | Bal. Tax Group Code (Bal. Tax Group Code) | Code20 |
|
|
89 | Bal. Use Tax (Bal. Use Tax) | Boolean | ||
90 | VAT Bus. Posting Group (VAT Bus. Posting Group) | Code20 |
|
|
91 | VAT Prod. Posting Group (VAT Prod. Posting Group) | Code20 |
|
|
92 | Bal. VAT Bus. Posting Group (Bal. VAT Bus. Posting Group) | Code20 |
|
|
93 | Bal. VAT Prod. Posting Group (Bal. VAT Prod. Posting Group) | Code20 |
|
|
110 | Ship-to/Order Address Code (Ship-to/Order Address Code) | Code10 |
|
|
111 | VAT Difference (VAT Difference) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
112 | Bal. VAT Difference (Bal. VAT Difference) | Decimal | AutoFormatType: 1 AutoFormatExpr: "Currency Code" |
Editable: No |
113 | IC Partner Code (IC Partner Code) | Code20 |
|
Editable: No |
116 | IC Partner G/L Acc. No. (IC Partner G/L Acc. No.) | Code20 |
|
|
118 | Sell-to/Buy-from No. (Sell-to/Buy-from No.) | Code20 |
|
|
480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
5050 | Campaign No. (Campaign No.) | Code20 |
|
|
5616 | Index Entry (Index Entry) | Boolean |
Keys
# | Fields | ||
---|---|---|---|
0 | Journal Template Name,Standard Journal Code,Line No. (Journal Template Name,Standard Journal Code,Line No.) | Clustered: Yes |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Source No. (Source No.) | Bank Account | No. (No.) |
|
1..n |
Business Unit Code (Business Unit Code) | Business Unit | Code (Code) |
|
1..n |
Campaign No. (Campaign No.) | Campaign | No. (No.) |
|
1..n |
Currency Code (Currency Code) | Currency | Code (Code) |
|
1..n |
Sell-to/Buy-from No. (Sell-to/Buy-from No.) | Customer | No. (No.) |
|
1..n |
Posting Group (Posting Group) | Customer Posting Group | Code (Code) |
|
1..n |
Dimension Set ID (Dimension Set ID) | Dimension Set Entry | () |
|
1..n |
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
Posting Group (Posting Group) | FA Posting Group | Code (Code) |
|
1..n |
Source No. (Source No.) | Fixed Asset | No. (No.) |
|
1..n |
Bal. Account No. (Bal. Account No.) | G/L Account | No. (No.) |
|
1..n |
Bal. Gen. Bus. Posting Group (Bal. Gen. Bus. Posting Group) | Gen. Business Posting Group | Code (Code) |
|
1..n |
Journal Template Name (Journal Template Name) | Gen. Journal Template | Name (Name) |
|
1..n |
Bal. Gen. Prod. Posting Group (Bal. Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
IC Partner G/L Acc. No. (IC Partner G/L Acc. No.) | IC G/L Account | No. (No.) |
|
1..n |
IC Partner Code (IC Partner Code) | IC Partner | Code (Code) |
|
1..n |
Job No. (Job No.) | Job | No. (No.) |
|
1..n |
Posting No. Series (Posting No. Series) | No. Series | Code (Code) |
|
1..n |
Ship-to/Order Address Code (Ship-to/Order Address Code) | Order Address | Code (Code) |
|
1..n |
Payment Terms Code (Payment Terms Code) | Payment Terms | Code (Code) |
|
1..n |
Reason Code (Reason Code) | Reason Code | Code (Code) |
|
1..n |
Salespers./Purch. Code (Salespers./Purch. Code) | Salesperson/Purchaser | Code (Code) |
|
1..n |
Ship-to/Order Address Code (Ship-to/Order Address Code) | Ship-to Address | Code (Code) |
|
1..n |
Source Code (Source Code) | Source Code | Code (Code) |
|
1..n |
Standard Journal Code (Standard Journal Code) | Standard General Journal | Code (Code) |
|
1..n |
Bal. Tax Area Code (Bal. Tax Area Code) | Tax Area | Code (Code) |
|
1..n |
Bal. Tax Group Code (Bal. Tax Group Code) | Tax Group | Code (Code) |
|
1..n |
Bal. VAT Bus. Posting Group (Bal. VAT Bus. Posting Group) | VAT Business Posting Group | Code (Code) |
|
1..n |
Bal. VAT Prod. Posting Group (Bal. VAT Prod. Posting Group) | VAT Product Posting Group | Code (Code) |
|
1..n |
Sell-to/Buy-from No. (Sell-to/Buy-from No.) | Vendor | No. (No.) |
|
1..n |
Posting Group (Posting Group) | Vendor Posting Group | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field |
---|