Table 751 Standard General Journal Line in 22
- App
- Base Application
Fields, 76Keys, 1Procedures, 7Events, 12
Versions171819202122232425262728latest
Source29
Fields, 76
| Id | Name | Type | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| 1 | Journal Template Name | Code[10] | - | ||||
| 2 | Line No. | Integer | - | ||||
| 3 | Account Type | Enum Gen. Journal Account Type | - | ||||
| 4 | Account No. | Code[20] | - | ||||
| 6 | Document Type | Enum Gen. Journal Document Type | - | ||||
| 8 | Description | Text[100] | - | ||||
| 10 | VAT % | Decimal | - | ||||
| 11 | Bal. Account No. | Code[20] | - | ||||
| 12 | Currency Code | Code[10] | - | ||||
| 13 | Amount | Decimal | - | ||||
| 14 | Debit Amount | Decimal | - | ||||
| 15 | Credit Amount | Decimal | - | ||||
| 16 | Amount (LCY) | Decimal | - | ||||
| 17 | Balance (LCY) | Decimal | - | ||||
| 18 | Currency Factor | Decimal | - | ||||
| 19 | Sales/Purch. (LCY) | Decimal | - | ||||
| 20 | Profit (LCY) | Decimal | - | ||||
| 21 | Inv. Discount (LCY) | Decimal | - | ||||
| 22 | Bill-to/Pay-to No. | Code[20] | - | ||||
| 23 | Posting Group | Code[20] | - | ||||
| 24 | Shortcut Dimension 1 Code | Code[20] | - | ||||
| 25 | Shortcut Dimension 2 Code | Code[20] | - | ||||
| 26 | Salespers./Purch. Code | Code[20] | - | ||||
| 29 | Source Code | Code[10] | - | ||||
| 34 | On Hold | Code[3] | - | ||||
| 35 | Applies-to Doc. Type | Enum Gen. Journal Document Type | - | ||||
| 40 | Payment Discount % | Decimal | - | ||||
| 42 | Job No. | Code[20] | - | ||||
| 43 | Quantity | Decimal | - | ||||
| 44 | VAT Amount | Decimal | - | ||||
| 47 | Payment Terms Code | Code[10] | - | ||||
| 50 | Business Unit Code | Code[20] | - | ||||
| 51 | Standard Journal Code | Code[10] | - | ||||
| 52 | Reason Code | Code[10] | - | ||||
| 57 | Gen. Posting Type | Enum General Posting Type | - | ||||
| 58 | Gen. Bus. Posting Group | Code[20] | - | ||||
| 59 | Gen. Prod. Posting Group | Code[20] | - | ||||
| 60 | VAT Calculation Type | Enum Tax Calculation Type | - | ||||
| 63 | Bal. Account Type | Enum Gen. Journal Account Type | - | ||||
| 64 | Bal. Gen. Posting Type | Enum General Posting Type | - | ||||
| 65 | Bal. Gen. Bus. Posting Group | Code[20] | - | ||||
| 66 | Bal. Gen. Prod. Posting Group | Code[20] | - | ||||
| 67 | Bal. VAT Calculation Type | Enum Tax Calculation Type | - | ||||
| 68 | Bal. VAT % | Decimal | - | ||||
| 69 | Bal. VAT Amount | Decimal | - | ||||
| 70 | Bank Payment Type | Enum Bank Payment Type | - | ||||
| 71 | VAT Base Amount | Decimal | - | ||||
| 72 | Bal. VAT Base Amount | Decimal | - | ||||
| 73 | Correction | Boolean | - | ||||
| 77 | External Document No. | Code[35] | - | ||||
| 78 | Source Type | Option | - | ||||
| 79 | Source No. | Code[20] | - | ||||
| 80 | Posting No. Series | Code[20] | - | ||||
| 82 | Tax Area Code | Code[20] | - | ||||
| 83 | Tax Liable | Boolean | - | ||||
| 84 | Tax Group Code | Code[20] | - | ||||
| 85 | Use Tax | Boolean | - | ||||
| 86 | Bal. Tax Area Code | Code[20] | - | ||||
| 87 | Bal. Tax Liable | Boolean | - | ||||
| 88 | Bal. Tax Group Code | Code[20] | - | ||||
| 89 | Bal. Use Tax | Boolean | - | ||||
| 90 | VAT Bus. Posting Group | Code[20] | - | ||||
| 91 | VAT Prod. Posting Group | Code[20] | - | ||||
| 92 | Bal. VAT Bus. Posting Group | Code[20] | - | ||||
| 93 | Bal. VAT Prod. Posting Group | Code[20] | - | ||||
| 110 | Ship-to/Order Address Code | Code[10] | - | ||||
| 111 | VAT Difference | Decimal | - | ||||
| 112 | Bal. VAT Difference | Decimal | - | ||||
| 113 | IC Partner Code | Code[20] | - | ||||
| 116 | IC Partner G/L Acc. No. | Code[20] | Pending 22.0 | ||||
| This field will be replaced by IC Account No. | |||||||
| 118 | Sell-to/Buy-from No. | Code[20] | - | ||||
| 130 | IC Account Type | Enum IC Journal Account Type | - | ||||
| 131 | IC Account No. | Code[20] | - | ||||
| 480 | Dimension Set ID | Integer | - | ||||
| 5050 | Campaign No. | Code[20] | - | ||||
| 5616 | Index Entry | Boolean | - | ||||
Keys, 1
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Journal Template Name, Standard Journal Code, Line No. | - |
Procedures, 7
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| ValidateShortcutDimCode | (Integer, var Code[20]) | public | - | ||||
| LookupShortcutDimCode | (Integer, var Code[20]) | public | - | ||||
| ShowShortcutDimCode | (var Code[20]) | public | - | ||||
| ShowDimensions | () | public | - | ||||
| CreateDim | (Integer, Code[20], Integer, Code[20], Integer, Code[20], Integer, Code[20], Integer, Code[20]) | public | Pending 20.0 | ||||
| Replaced by CreateDim(DefaultDimSource:List of [Dictionary of [Integer, Code[20]]]) | |||||||
| CreateDim | (List) | public | - | ||||
| CreateDimFromDefaultDim | (Integer) | public | - | ||||
Events, 12
| Kind | Name | Parameters | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| Integration event | OnAfterCreateDimTableIDs | (var Record Standard General Journal Line, Integer, var Integer, var Code[20]) | Pending 20.0 | ||||
| Replaced by OnAfterInitDefaultDimensionSources() | |||||||
| Integration event | OnAfterGetGLAccount | (var Record Standard General Journal Line, Record G/L Account) | - | ||||
| Integration event | OnAfterValidateShortcutDimCode | (var Record Standard General Journal Line, var Record Standard General Journal Line, Integer, var Code[20]) | - | ||||
| Integration event | OnBeforeCreateDim | (var Record Standard General Journal Line, var Boolean, Integer) | - | ||||
| Integration event | OnBeforeLookupShortcutDimCode | (var Record Standard General Journal Line, Record Standard General Journal Line, Integer, var Code[20], var Boolean) | - | ||||
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Standard General Journal Line, var Record Standard General Journal Line, Integer, var Code[20]) | - | ||||
| Integration event | OnAfterCreateDim | (var Record Standard General Journal Line, Integer) | - | ||||
| Integration event | OnAfterShowDimensions | (var Record Standard General Journal Line) | - | ||||
| Integration event | OnValidateVATProdPostingGroupOnBeforeVATCalculationCheck | (var Record Standard General Journal Line, var Record VAT Posting Setup, var Boolean) | - | ||||
| Integration event | OnValidateBalVATProdPostingGroupOnBeforeBalVATCalculationCheck | (var Record Standard General Journal Line, var Record VAT Posting Setup, var Boolean) | - | ||||
| Integration event | OnAfterInitDefaultDimensionSources | (var Record Standard General Journal Line, var List, Integer) | - | ||||
| Integration event | OnBeforeShowDimensions | (var Record Standard General Journal Line, Record Standard General Journal Line) | - | ||||