Objects/Tables/Table 15 G/L Account
Table 15 G/L Account in 26
Jonas Paprotka, Base Application 26.5.38752.40541, checked
- App
- Base Application
- Namespace
- Microsoft.Finance.GeneralLedger.Account
Fields, 71Keys, 10Procedures, 10Events, 7
Versions171819202122232425262728latest
Source29
Fields, 71
| Id | Name | Type | Obsolete |
|---|
| 1 | No. | Code[20] | - |
| 2 | Name | Text[100] | - |
| 3 | Search Name | Code[100] | - |
| 4 | Account Type | Enum G/L Account Type | - |
| 6 | Global Dimension 1 Code | Code[20] | - |
| 7 | Global Dimension 2 Code | Code[20] | - |
| 8 | Account Category | Enum G/L Account Category | - |
| 9 | Income/Balance | Enum G/L Account Report Type | - |
| 10 | Debit/Credit | Option | - |
| 11 | No. 2 | Code[20] | - |
| 12 | Comment | Boolean | - |
| 13 | Blocked | Boolean | - |
| 14 | Direct Posting | Boolean | - |
| 16 | Reconciliation Account | Boolean | - |
| 17 | New Page | Boolean | - |
| 18 | No. of Blank Lines | Integer | - |
| 19 | Indentation | Integer | - |
| 20 | Source Currency Code | Code[10] | - |
| 21 | Source Currency Posting | Enum G/L Source Currency Posting | - |
| 22 | Source Currency Revaluation | Boolean | - |
| 23 | Unrealized Revaluation | Boolean | - |
| 25 | Last Modified Date Time | DateTime | - |
| 26 | Last Date Modified | Date | - |
| 28 | Date Filter | Date | - |
| 29 | Global Dimension 1 Filter | Code[20] | - |
| 30 | Global Dimension 2 Filter | Code[20] | - |
| 31 | Balance at Date | Decimal | - |
| 32 | Net Change | Decimal | - |
| 33 | Budgeted Amount | Decimal | - |
| 34 | Totaling | Text[250] | - |
| 35 | Budget Filter | Code[10] | - |
| 36 | Balance | Decimal | - |
| 37 | Budget at Date | Decimal | - |
| 39 | Consol. Translation Method | Option | - |
| 40 | Consol. Debit Acc. | Code[20] | - |
| 41 | Consol. Credit Acc. | Code[20] | - |
| 42 | Business Unit Filter | Code[20] | - |
| 43 | Gen. Posting Type | Enum General Posting Type | - |
| 44 | Gen. Bus. Posting Group | Code[20] | - |
| 45 | Gen. Prod. Posting Group | Code[20] | - |
| 46 | Picture | Blob | - |
| 47 | Debit Amount | Decimal | - |
| 48 | Credit Amount | Decimal | - |
| 49 | Automatic Ext. Texts | Boolean | - |
| 52 | Budgeted Debit Amount | Decimal | - |
| 53 | Budgeted Credit Amount | Decimal | - |
| 54 | Tax Area Code | Code[20] | - |
| 55 | Tax Liable | Boolean | - |
| 56 | Tax Group Code | Code[20] | - |
| 57 | VAT Bus. Posting Group | Code[20] | - |
| 58 | VAT Prod. Posting Group | Code[20] | - |
| 59 | VAT Amt. | Decimal | - |
| 60 | Additional-Currency Net Change | Decimal | - |
| 61 | Add.-Currency Balance at Date | Decimal | - |
| 62 | Additional-Currency Balance | Decimal | - |
| 63 | Exchange Rate Adjustment | Enum Exch. Rate Adjustment Type | - |
| 64 | Add.-Currency Debit Amount | Decimal | - |
| 65 | Add.-Currency Credit Amount | Decimal | - |
| 66 | Default IC Partner G/L Acc. No | Code[20] | - |
| 70 | Omit Default Descr. in Jnl. | Boolean | - |
| 75 | Source Currency Net Change | Decimal | - |
| 76 | Source Curr. Balance at Date | Decimal | - |
| 77 | Source Currency Balance | Decimal | - |
| 80 | Account Subcategory Entry No. | Integer | - |
| 81 | Account Subcategory Descript. | Text[80] | - |
| 82 | VAT Reporting Date Filter | Date | - |
| 83 | Exclude From Consolidation | Boolean | - |
| 400 | Dimension Set ID Filter | Integer | - |
| 1100 | Cost Type No. | Code[20] | - |
| 1700 | Default Deferral Template Code | Code[10] | - |
| 9000 | API Account Type | Enum G/L Account Type | - |
Keys, 10
| Name | Fields | Obsolete |
|---|
| Key1, clustered | No. | - |
| Key2 | Search Name | - |
| Key3 | Reconciliation Account | - |
| Key4 | Gen. Bus. Posting Group | - |
| Key5 | Gen. Prod. Posting Group | - |
| Key6 | Consol. Debit Acc., Consol. Translation Method | - |
| Key7 | Consol. Credit Acc., Consol. Translation Method | - |
| Key8 | Name | - |
| Key9 | Account Type | - |
| Key10 | Account Category | - |
Procedures, 10
| Name | Parameters | Returns | Access | Obsolete |
|---|
| ShowPriceListLines | (Enum Price Type, Enum Price Amount Type) | | public | - |
| SetupNewGLAcc | (Record G/L Account, Boolean) | | public | - |
| CheckGLAcc | () | | public | - |
| ValidateAccountSubCategory | (Text[80]) | | public | - |
| LookupAccountSubCategory | () | | public | - |
| GetCurrencyCode | () | Code[10] | public | - |
| ValidateShortcutDimCode | (Integer, var Code[20]) | | public | - |
| TranslationMethodConflict | (var Record G/L Account) | Boolean | public | - |
| IsTotaling | () | Boolean | public | - |
| CheckGenProdPostingGroup | () | | public | - |
Events, 7
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnAfterCheckGLAcc | (var Record G/L Account) | - |
| Integration event | OnAfterSetupNewGLAcc | (var Record G/L Account) | - |
| Integration event | OnAfterValidateShortcutDimCode | (var Record G/L Account, var Record G/L Account, Integer, var Code[20]) | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record G/L Account, var Record G/L Account, Integer, var Code[20]) | - |
| Integration event | OnBeforeCheckGenProdPostingGroup | (var Record G/L Account, var Boolean) | - |
| Integration event | OnBeforeOnDelete | (var Record G/L Account, var Boolean) | - |
| Integration event | OnBeforeCheckSalesOrdersPrepmtToDeduct | (var Record G/L Account, var Boolean) | - |