Table 15 G/L Account
73 fields
| Id | Name | Type | Versions |
|---|---|---|---|
| 1 | No. | Code[20] | 17-29 |
| 2 | Name | Text[100] | 17-29 |
| 3 | Search Name | Code[100] | 17-29 |
| 4 | Account Type | Enum "G/L Account Type" | 17-29changed in 19 |
| 6 | Global Dimension 1 Code | Code[20] | 17-29 |
| 7 | Global Dimension 2 Code | Code[20] | 17-29 |
| 8 | Account Category | Enum "G/L Account Category" | 17-29 |
| 9 | Income/Balance | Enum "G/L Account Report Type" | 17-29changed in 26 |
| 10 | Debit/Credit | Option | 17-29 |
| 11 | No. 2 | Code[20] | 17-29 |
| 12 | Comment | Boolean | 17-29 |
| 13 | Blocked | Boolean | 17-29 |
| 14 | Direct Posting | Boolean | 17-29 |
| 16 | Reconciliation Account | Boolean | 17-29 |
| 17 | New Page | Boolean | 17-29 |
| 18 | No. of Blank Lines | Integer | 17-29 |
| 19 | Indentation | Integer | 17-29 |
| 20 | Source Currency Code | Code[10] | new in 24 |
| 21 | Source Currency Posting | Enum "G/L Source Currency Posting" | new in 24 |
| 22 | Source Currency Revaluation | Boolean | new in 24 |
| 23 | Unrealized Revaluation | Boolean | new in 24 |
| 25 | Last Modified Date Time | DateTime | 17-29 |
| 26 | Last Date Modified | Date | 17-29 |
| 28 | Date Filter | Date | 17-29 |
| 29 | Global Dimension 1 Filter | Code[20] | 17-29 |
| 30 | Global Dimension 2 Filter | Code[20] | 17-29 |
| 31 | Balance at Date | Decimal | 17-29 |
| 32 | Net Change | Decimal | 17-29 |
| 33 | Budgeted Amount | Decimal | 17-29 |
| 34 | Totaling | Text[250] | 17-29 |
| 35 | Budget Filter | Code[10] | 17-29 |
| 36 | Balance | Decimal | 17-29 |
| 37 | Budget at Date | Decimal | 17-29 |
| 39 | Consol. Translation Method | Option | 17-29 |
| 40 | Consol. Debit Acc. | Code[20] | 17-29 |
| 41 | Consol. Credit Acc. | Code[20] | 17-29 |
| 42 | Business Unit Filter | Code[20] | 17-29 |
| 43 | Gen. Posting Type | Enum "General Posting Type" | 17-29 |
| 44 | Gen. Bus. Posting Group | Code[20] | 17-29 |
| 45 | Gen. Prod. Posting Group | Code[20] | 17-29 |
| 46 | Picture | Blob | 17-29 |
| 47 | Debit Amount | Decimal | 17-29 |
| 48 | Credit Amount | Decimal | 17-29 |
| 49 | Automatic Ext. Texts | Boolean | 17-29 |
| 52 | Budgeted Debit Amount | Decimal | 17-29 |
| 53 | Budgeted Credit Amount | Decimal | 17-29 |
| 54 | Tax Area Code | Code[20] | 17-29 |
| 55 | Tax Liable | Boolean | 17-29 |
| 56 | Tax Group Code | Code[20] | 17-29 |
| 57 | VAT Bus. Posting Group | Code[20] | 17-29 |
| 58 | VAT Prod. Posting Group | Code[20] | 17-29 |
| 59 | VAT Amt. | Decimal | 17-29 |
| 60 | Additional-Currency Net Change | Decimal | 17-29 |
| 61 | Add.-Currency Balance at Date | Decimal | 17-29 |
| 62 | Additional-Currency Balance | Decimal | 17-29 |
| 63 | Exchange Rate Adjustment | Enum "Exch. Rate Adjustment Type" | 17-29changed in 20 |
| 64 | Add.-Currency Debit Amount | Decimal | 17-29 |
| 65 | Add.-Currency Credit Amount | Decimal | 17-29 |
| 66 | Default IC Partner G/L Acc. No | Code[20] | 17-29 |
| 70 | Omit Default Descr. in Jnl. | Boolean | 17-29 |
| 75 | Source Currency Net Change | Decimal | new in 24 |
| 76 | Source Curr. Balance at Date | Decimal | new in 24 |
| 77 | Source Currency Balance | Decimal | new in 24 |
| 80 | Account Subcategory Entry No. | Integer | 17-29 |
| 81 | Account Subcategory Descript. | Text[80] | 17-29 |
| 82 | VAT Reporting Date Filter | Date | new in 21 |
| 83 | Exclude From Consolidation | Boolean | new in 24 |
| 90 | Spend Request Required | Enum "Spend Request Required" | new in 29 |
| 400 | Dimension Set ID Filter | Integer | 17-29 |
| 1100 | Cost Type No. | Code[20] | 17-29 |
| 1700 | Default Deferral Template Code | Code[10] | 17-29 |
| 8000 | Id | Guid | gone after 25 |
| Removed, tag 22.0, obsolete since 17: This functionality will be replaced by the systemID field | |||
| 9000 | API Account Type | Enum "G/L Account Type" | 17-29 |