Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Entry No. | Integer | ||
| 2 | G/L Entry No. | Integer |
|
BlankZero: Yes |
| 3 | FA No. | Code20 |
|
|
| 4 | FA Posting Date | Date | ||
| 5 | Posting Date | Date | ||
| 6 | Document Type | Option | [ ,Payment,Invoice,Credit Memo,Finance Charge Memo,Reminder,Refund] | |
| 7 | Document Date | Date | ||
| 8 | Document No. | Code20 | ||
| 9 | External Document No. | Code35 | ||
| 10 | Description | Text50 | ||
| 12 | Amount | Decimal | AutoFormatType: 1 | |
| 13 | Debit Amount | Decimal | AutoFormatType: 1 | |
| 14 | Credit Amount | Decimal | AutoFormatType: 1 | |
| 15 | Quantity | Decimal (0:5) | ||
| 16 | FA No./Budgeted FA No. | Code20 |
|
|
| 17 | FA Subclass Code | Code10 |
|
|
| 18 | FA Location Code | Code10 |
|
|
| 19 | FA Posting Group | Code10 |
|
|
| 20 | Global Dimension 1 Code | Code20 | CaptionClass: '1,1,1'
|
|
| 21 | Global Dimension 2 Code | Code20 | CaptionClass: '1,1,2'
|
|
| 22 | Location Code | Code10 |
|
|
| 24 | User ID | Code50 |
|
|
| 25 | Journal Batch Name | Code10 | ||
| 26 | Source Code | Code10 |
|
|
| 27 | Reason Code | Code10 |
|
|
| 28 | Transaction No. | Integer | ||
| 29 | Bal. Account Type | Option | [G/L Account,Customer,Vendor,Bank Account,Fixed Asset] | |
| 30 | Bal. Account No. | Code20 |
|
|
| 31 | VAT Amount | Decimal | AutoFormatType: 1 | |
| 32 | Gen. Posting Type | Option | [ ,Purchase,Sale,Settlement] | |
| 33 | Gen. Bus. Posting Group | Code10 |
|
|
| 34 | Gen. Prod. Posting Group | Code10 |
|
|
| 35 | FA Class Code | Code10 |
|
|
| 36 | Depreciation Book Code | Code10 |
|
|
| 37 | FA Exchange Rate | Decimal | AutoFormatType: 1 | |
| 38 | Amount (LCY) | Decimal | AutoFormatType: 1 | |
| 39 | Maintenance Code | Code10 |
|
|
| 40 | Correction | Boolean | ||
| 41 | Index Entry | Boolean | ||
| 42 | Automatic Entry | Boolean | ||
| 43 | No. Series | Code10 |
|
|
| 44 | Tax Area Code | Code20 |
|
|
| 45 | Tax Liable | Boolean | ||
| 46 | Tax Group Code | Code10 |
|
|
| 47 | Use Tax | Boolean | ||
| 48 | VAT Bus. Posting Group | Code10 |
|
|
| 49 | VAT Prod. Posting Group | Code10 |
|
|
| 50 | Reversed | Boolean | ||
| 51 | Reversed by Entry No. | Integer |
|
BlankZero: Yes |
| 52 | Reversed Entry No. | Integer |
|
BlankZero: Yes |
| 480 | Dimension Set ID | Integer |
|
Editable: No |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Entry No. | Clustered: Yes | |
| 1 | FA No.,Depreciation Book Code,FA Posting Date | SumIndexFields: Amount | |
| 2 | FA No.,Depreciation Book Code,Posting Date | SumIndexFields: Amount | |
| 3 | FA No.,Depreciation Book Code,Maintenance Code,FA Posting Date | SumIndexFields: Amount | |
| 4 | FA No.,Depreciation Book Code,Maintenance Code,Posting Date | SumIndexFields: Amount | |
| 5 | Document No.,Posting Date | ||
| 6 | G/L Entry No. | ||
| 7 | Transaction No. | ||
| 8 | FA No.,Depreciation Book Code,Document No. |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Bal. Account No. | Bank Account | No. |
|
1..n |
| Bal. Account No. | Customer | No. |
|
1..n |
| Depreciation Book Code | Depreciation Book | Code |
|
1..n |
| Dimension Set ID | Dimension Set Entry |
|
1..n | |
| Global Dimension 2 Code | Dimension Value | Code |
|
1..n |
| FA Class Code | FA Class | Code |
|
1..n |
| FA Location Code | FA Location | Code |
|
1..n |
| FA Posting Group | FA Posting Group | Code |
|
1..n |
| FA Subclass Code | FA Subclass | Code |
|
1..n |
| Bal. Account No. | Fixed Asset | No. |
|
1..n |
| Bal. Account No. | G/L Account | No. |
|
1..n |
| G/L Entry No. | G/L Entry | Entry No. |
|
1..n |
| Gen. Bus. Posting Group | Gen. Business Posting Group | Code |
|
1..n |
| Gen. Prod. Posting Group | Gen. Product Posting Group | Code |
|
1..n |
| Location Code | Location |
|
1..n | |
| Maintenance Code | Maintenance | Code |
|
1..n |
| Reversed Entry No. | Maintenance Ledger Entry | Entry No. |
|
1..n |
| No. Series | No. Series | Code |
|
1..n |
| Reason Code | Reason Code | Code |
|
1..n |
| Source Code | Source Code | Code |
|
1..n |
| Tax Area Code | Tax Area | Code |
|
1..n |
| Tax Group Code | Tax Group | Code |
|
1..n |
| User ID | User | User Name |
|
1..n |
| VAT Bus. Posting Group | VAT Business Posting Group | Code |
|
1..n |
| VAT Prod. Posting Group | VAT Product Posting Group | Code |
|
1..n |
| Bal. Account No. | Vendor | No. |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| FA Register | To Maintenance Entry No. |
|
1..n |
| G/L Entry | FA Entry No. |
|
1..n |
| Maintenance Ledger Entry | Reversed Entry No. |
|
1..n |
| Reversal Entry | Entry No. |
|
1..n |