Table 751 Standard General Journal Line in 18
- App
- Base Application
Fields, 73Keys, 1Procedures, 5Events, 10
Versions171819202122232425262728latest
Source29
Fields, 73
| 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 | - |
| 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] | - |
| 118 | Sell-to/Buy-from 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, 5
| 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 | - |
Events, 10
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterCreateDimTableIDs | (var Record Standard General Journal Line, Integer, var Integer, var Code[20]) | - |
| 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) | - |