Objects/Tables/Table 17 G/L Entry
Table 17 G/L Entry in 22
Jonas Paprotka, Base Application 22.5.59966.64723, checked
- App
- Base Application
Fields, 67Keys, 13Procedures, 13Events, 8
Versions171819202122232425262728latest
Source29
Fields, 67
| Id | Name | Type | Obsolete |
|---|
| 1 | Entry No. | Integer | - |
| 3 | G/L Account No. | Code[20] | - |
| 4 | Posting Date | Date | - |
| 5 | Document Type | Enum Gen. Journal Document Type | - |
| 6 | Document No. | Code[20] | - |
| 7 | Description | Text[100] | - |
| 10 | Bal. Account No. | Code[20] | - |
| 17 | Amount | Decimal | - |
| 23 | Global Dimension 1 Code | Code[20] | - |
| 24 | Global Dimension 2 Code | Code[20] | - |
| 27 | User ID | Code[50] | - |
| 28 | Source Code | Code[10] | - |
| 29 | System-Created Entry | Boolean | - |
| 30 | Prior-Year Entry | Boolean | - |
| 41 | Job No. | Code[20] | - |
| 42 | Quantity | Decimal | - |
| 43 | VAT Amount | Decimal | - |
| 45 | Business Unit Code | Code[20] | - |
| 46 | Journal Batch Name | Code[10] | - |
| 47 | Reason Code | Code[10] | - |
| 48 | Gen. Posting Type | Enum General Posting Type | - |
| 49 | Gen. Bus. Posting Group | Code[20] | - |
| 50 | Gen. Prod. Posting Group | Code[20] | - |
| 51 | Bal. Account Type | Enum Gen. Journal Account Type | - |
| 52 | Transaction No. | Integer | - |
| 53 | Debit Amount | Decimal | - |
| 54 | Credit Amount | Decimal | - |
| 55 | Document Date | Date | - |
| 56 | External Document No. | Code[35] | - |
| 57 | Source Type | Enum Gen. Journal Source Type | - |
| 58 | Source No. | Code[20] | - |
| 59 | No. Series | Code[20] | - |
| 60 | Tax Area Code | Code[20] | - |
| 61 | Tax Liable | Boolean | - |
| 62 | Tax Group Code | Code[20] | - |
| 63 | Use Tax | Boolean | - |
| 64 | VAT Bus. Posting Group | Code[20] | - |
| 65 | VAT Prod. Posting Group | Code[20] | - |
| 68 | Additional-Currency Amount | Decimal | - |
| 69 | Add.-Currency Debit Amount | Decimal | - |
| 70 | Add.-Currency Credit Amount | Decimal | - |
| 71 | Close Income Statement Dim. ID | Integer | - |
| 72 | IC Partner Code | Code[20] | - |
| 73 | Reversed | Boolean | - |
| 74 | Reversed by Entry No. | Integer | - |
| 75 | Reversed Entry No. | Integer | - |
| 76 | G/L Account Name | Text[100] | - |
| 78 | Journal Templ. Name | Code[10] | - |
| 79 | VAT Reporting Date | Date | - |
| 480 | Dimension Set ID | Integer | - |
| 481 | Shortcut Dimension 3 Code | Code[20] | - |
| 482 | Shortcut Dimension 4 Code | Code[20] | - |
| 483 | Shortcut Dimension 5 Code | Code[20] | - |
| 484 | Shortcut Dimension 6 Code | Code[20] | - |
| 485 | Shortcut Dimension 7 Code | Code[20] | - |
| 486 | Shortcut Dimension 8 Code | Code[20] | - |
| 495 | Last Dim. Correction Entry No. | Integer | - |
| 496 | Last Dim. Correction Node | Integer | - |
| 497 | Dimension Changes Count | Integer | - |
| 5400 | Prod. Order No. | Code[20] | - |
| 5600 | FA Entry Type | Option | - |
| 5601 | FA Entry No. | Integer | - |
| 5618 | Comment | Text[250] | - |
| 6200 | Non-Deductible VAT Amount | Decimal | - |
| 6201 | Non-Deductible VAT Amount ACY | Decimal | - |
| 8001 | Account Id | Guid | - |
| 8005 | Last Modified DateTime | DateTime | - |
Keys, 13
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Entry No. | - |
| Key2 | G/L Account No., Posting Date | - |
| Key3 | G/L Account No., Global Dimension 1 Code, Global Dimension 2 Code, Posting Date, VAT Reporting Date | - |
| Key4 | G/L Account No., Business Unit Code, Posting Date | - |
| Key5 | G/L Account No., Business Unit Code, Global Dimension 1 Code, Global Dimension 2 Code, Posting Date | - |
| Key6 | Document No., Posting Date | - |
| Key7 | Transaction No. | - |
| Key8 | IC Partner Code | - |
| Key9 | G/L Account No., Job No., Posting Date | - |
| Key10 | Posting Date, G/L Account No., Dimension Set ID | - |
| Key11 | Gen. Bus. Posting Group, Gen. Prod. Posting Group | - |
| Key12 | VAT Bus. Posting Group, VAT Prod. Posting Group | - |
| Key13 | Dimension Set ID | - |
Procedures, 13
| Name | Parameters | Returns | Access | Obsolete |
|---|
| GetLastEntryNo | () | Integer | public | - |
| GetLastEntry | (var Integer, var Integer) | | public | - |
| GetCurrencyCode | () | Code[10] | public | - |
| ShowValueEntries | () | | public | - |
| ShowDimensions | () | | public | - |
| UpdateDebitCredit | (Boolean) | | public | - |
| CopyFromGenJnlLine | (Record Gen. Journal Line) | | public | - |
| CopyPostingGroupsFromGLEntry | (Record G/L Entry) | | public | - |
| CopyPostingGroupsFromVATEntry | (Record VAT Entry) | | public | - |
| CopyPostingGroupsFromGenJnlLine | (Record Gen. Journal Line) | | public | - |
| CopyPostingGroupsFromDtldCVBuf | (Record Detailed CV Ledg. Entry Buffer, Option) | | public | - |
| CopyFromDeferralPostBuffer | (Record Deferral Posting Buffer) | | public | - |
| UpdateAccountID | () | | public | - |
Events, 8
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnAfterCopyGLEntryFromGenJnlLine | (var Record G/L Entry, var Record Gen. Journal Line) | - |
| Integration event | OnAfterCopyFromDeferralPostBuffer | (var Record G/L Entry, Record Deferral Posting Buffer) | - |
| Integration event | OnAfterCopyPostingGroupsFromDtldCVBuf | (var Record G/L Entry, Record Detailed CV Ledg. Entry Buffer) | - |
| Integration event | OnAfterCopyPostingGroupsFromGLEntry | (var Record G/L Entry, Record G/L Entry) | - |
| Integration event | OnAfterCopyPostingGroupsFromGenJnlLine | (var Record G/L Entry, Record Gen. Journal Line) | - |
| Integration event | OnAfterCopyPostingGroupsFromVATEntry | (var Record G/L Entry, Record VAT Entry) | - |
| Integration event | OnBeforeShowValueEntries | (var Record Value Entry, var Record G/L - Item Ledger Relation) | - |
| Integration event | OnAfterUpdateDebitCredit | (var Record G/L Entry, Boolean) | - |