Page 6407 "Gen. Journal Line Entity"
Base Application · Microsoft.Integration.Entity
Across versions
- BC23-30present
Neighbourhood 1 connected objects and pages
Base Application · Microsoft.Integration.Entity · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | ‘workflowGenJournalLines’, Locked = true |
| SourceTable | Gen. Journal Line |
| PageType | List |
Fields on this page
Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control’s own, else the bound field’s (marked).
| Group | Control | Shows | ToolTip |
|---|---|---|---|
| Group | journalTemplateName | Journal Template Name | — |
| lineNumber | Line No. | — | |
| accountType | Account Type | Specifies the type of account that the entry on the journal line will be posted to. from the table field | |
| accountNumber | Account No. | Specifies the account number that the entry on the journal line will be posted to. from the table field | |
| postingDate | Posting Date | Specifies the posting date for the entry. from the table field | |
| documentType | Document Type | Specifies the type of document that the entry on the journal line is. from the table field | |
| documentNumber | Document No. | Specifies a document number for the journal line. from the table field | |
| description | Description | Specifies a description of the entry. from the table field | |
| vatPercent | VAT % | Specifies the relevant VAT rate for the particular combination of VAT business posting group and VAT product posting group. Do not enter the percent sign, only the number. For example, if the VAT rate is 25 %, enter 25 in this field. from the table field | |
| balAccountNumber | Bal. Account No. | Specifies the number of the general ledger, customer, vendor, or bank account that the balancing entry is posted to, such as a cash account for cash purchases. from the table field | |
| currencyCode | Currency Code | Specifies the code of the currency for the amounts on the journal line. from the table field | |
| amount | Amount | Specifies the total amount (including VAT) that the journal line consists of. from the table field | |
| debitAmount | Debit Amount | Specifies the total of the ledger entries that represent debits. from the table field | |
| creditAmount | Credit Amount | Specifies the total of the ledger entries that represent credits. from the table field | |
| amountLcy | Amount (LCY) | — | |
| balanceLcy | Balance (LCY) | — | |
| currencyFactor | Currency Factor | — | |
| salesPurchLcy | Sales/Purch. (LCY) | — | |
| profitLcy | Profit (LCY) | — | |
| invDiscountLcy | Inv. Discount (LCY) | — | |
| billToPayToNumber | Bill-to/Pay-to No. | Specifies the number of the bill-to customer or pay-to vendor that the entry is linked to. from the table field | |
| postingGroup | Posting Group | Specifies the posting group that will be used in posting the journal line.The field is used only if the account type is either customer or vendor. from the table field | |
| shortcutDimension1Code | Shortcut Dimension 1 Code | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. from the table field | |
| shortcutDimension2Code | Shortcut Dimension 2 Code | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. from the table field | |
| salespersPurchCode | Salespers./Purch. Code | Specifies the salesperson or purchaser who is linked to the journal line. from the table field | |
| sourceCode | Source Code | — | |
| systemCreatedEntry | System-Created Entry | — | |
| onHold | On Hold | Specifies that the related entry represents an unpaid invoice for which either a payment suggestion, a reminder, or a finance charge memo exists. from the table field | |
| appliesToDocType | Applies-to Doc. Type | Specifies the type of the posted document that this document or journal line will be applied to when you post, for example to register payment. from the table field | |
| appliesToDocNumber | Applies-to Doc. No. | Specifies the number of the posted document that this document or journal line will be applied to when you post, for example to register payment. from the table field | |
| dueDate | Due Date | Specifies the due date on the entry. from the table field | |
| pmtDiscountDate | Pmt. Discount Date | Specifies the date on which the amount in the entry must be paid for a payment discount to be granted. from the table field | |
| paymentDiscountPercent | Payment Discount % | Specifies the payment discount percent granted if payment is made on or before the date in the Pmt. Discount Date field. from the table field | |
| jobNumber | Job No. | Specifies the number of the related project. from the table field | |
| quantity | Quantity | Specifies the quantity of items to be included on the journal line. from the table field | |
| vatAmount | VAT Amount | Specifies the amount of VAT that is included in the total amount. from the table field | |
| vatPosting | VAT Posting | — | |
| paymentTermsCode | Payment Terms Code | Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount. from the table field | |
| appliesToId | Applies-to ID | Specifies the ID of entries that will be applied to when you choose the Apply Entries action. from the table field | |
| businessUnitCode | Business Unit Code | Specifies the code of the business unit that the entry derives from in a consolidated company. from the table field | |
| journalBatchName | Journal Batch Name | — | |
| reasonCode | Reason Code | Specifies the reason code, a supplementary source code that enables you to trace the entry. from the table field | |
| recurringMethod | Recurring Method | Specifies a recurring method if the Recurring field of the General Journal Template table indicates the journal is recurring. from the table field | |
| expirationDate | Expiration Date | Specifies the last date the recurring journal will be posted, if you have indicated in the journal is recurring. from the table field | |
| recurringFrequency | Recurring Frequency | Specifies a recurring frequency if the Recurring field of the General Journal Template table indicates the journal is recurring. from the table field | |
| allocatedAmtLcy | Allocated Amt. (LCY) | — | |
| genPostingType | Gen. Posting Type | Specifies the type of transaction. from the table field | |
| genBusPostingGroup | Gen. Bus. Posting Group | Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. from the table field | |
| genProdPostingGroup | Gen. Prod. Posting Group | Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. from the table field | |
| vatCalculationType | VAT Calculation Type | — | |
| eu3PartyTrade | EU 3-Party Trade | Specifies whether the entry was part of a 3-party trade. If it was, there is a check mark in the field. from the table field | |
| allowApplication | Allow Application | — | |
| balAccountType | Bal. Account Type | Specifies the type of account that a balancing entry is posted to, such as BANK for a cash account. from the table field | |
| balGenPostingType | Bal. Gen. Posting Type | Specifies the general posting type associated with the balancing account that will be used when you post the entry on the journal line. from the table field | |
| balGenBusPostingGroup | Bal. Gen. Bus. Posting Group | Specifies the general business posting group code associated with the balancing account that will be used when you post the entry. from the table field | |
| balGenProdPostingGroup | Bal. Gen. Prod. Posting Group | Specifies the general product posting group code associated with the balancing account that will be used when you post the entry. from the table field | |
| balVatCalculationType | Bal. VAT Calculation Type | — | |
| balVatPercent | Bal. VAT % | — | |
| balVatAmount | Bal. VAT Amount | Specifies the amount of Bal. VAT included in the total amount. from the table field | |
| bankPaymentType | Bank Payment Type | Specifies the code for the payment type to be used for the entry on the journal line. from the table field | |
| vatBaseAmount | VAT Base Amount | — | |
| balVatBaseAmount | Bal. VAT Base Amount | — | |
| correction | Correction | Specifies the entry as a corrective entry. You can use the field if you need to post a corrective entry to an account. from the table field | |
| checkPrinted | Check Printed | Specifies whether a check has been printed for the amount on the payment journal line. from the table field | |
| documentDate | Document Date | Specifies the date when the related document was created. from the table field | |
| externalDocumentNumber | External Document No. | Specifies a document number that refers to the customer’s or vendor’s numbering system. from the table field | |
| sourceType | Source Type | — | |
| sourceNumber | Source No. | — | |
| postingNumberSeries | Posting No. Series | — | |
| taxAreaCode | Tax Area Code | Specifies the tax area that is used to calculate and post sales tax. from the table field | |
| taxLiable | Tax Liable | Specifies if the customer or vendor is liable for sales tax. from the table field | |
| taxGroupCode | Tax Group Code | Specifies the tax group that is used to calculate and post sales tax. from the table field | |
| useTax | Use Tax | Specifies that the purchase is subject to use tax. Use tax is a sales tax that is paid on items that are purchased by a company and are used by that company instead of being sold to a customer. from the table field | |
| balTaxAreaCode | Bal. Tax Area Code | — | |
| balTaxLiable | Bal. Tax Liable | — | |
| balTaxGroupCode | Bal. Tax Group Code | — | |
| balUseTax | Bal. Use Tax | — | |
| vatBusPostingGroup | VAT Bus. Posting Group | Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. from the table field | |
| vatProdPostingGroup | VAT Prod. Posting Group | Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. from the table field | |
| balVatBusPostingGroup | Bal. VAT Bus. Posting Group | Specifies the code of the VAT business posting group that will be used when you post the entry on the journal line. from the table field | |
| balVatProdPostingGroup | Bal. VAT Prod. Posting Group | Specifies the code of the VAT product posting group that will be used when you post the entry on the journal line. from the table field | |
| additionalCurrencyPosting | Additional-Currency Posting | — | |
| faAddCurrencyFactor | FA Add.-Currency Factor | — | |
| sourceCurrencyCode | Source Currency Code | — | |
| sourceCurrencyAmount | Source Currency Amount | — | |
| sourceCurrVatBaseAmount | Source Curr. VAT Base Amount | — | |
| sourceCurrVatAmount | Source Curr. VAT Amount | — | |
| vatBaseDiscountPercent | VAT Base Discount % | — | |
| vatAmountLcy | VAT Amount (LCY) | — | |
| vatBaseAmountLcy | VAT Base Amount (LCY) | — | |
| balVatAmountLcy | Bal. VAT Amount (LCY) | — | |
| balVatBaseAmountLcy | Bal. VAT Base Amount (LCY) | — | |
| reversingEntry | Reversing Entry | — | |
| allowZeroAmountPosting | Allow Zero-Amount Posting | — | |
| shipToOrderAddressCode | Ship-to/Order Address Code | Specifies the address code of the ship-to customer or order-from vendor that the entry is linked to. from the table field | |
| vatDifference | VAT Difference | Specifies the difference between the calculated VAT amount and a VAT amount that you have entered manually. from the table field | |
| balVatDifference | Bal. VAT Difference | Specifies the difference between the calculate VAT amount and the VAT amount that you have entered manually. from the table field | |
| icPartnerCode | IC Partner Code | — | |
| icDirection | IC Direction | — | |
| icPartnerTransactionNumber | IC Partner Transaction No. | — | |
| icAccountType | IC Account Type | Specifies the type of the account that you want to use for the transaction with your IC partner. | |
| icAccountNo | IC Account No. | Specifies the number of the general ledger or bank account that the IC transaction is posted to. | |
| sellToBuyFromNumber | Sell-to/Buy-from No. | — | |
| vatRegistrationNumber | VAT Registration No. | — | |
| countryRegionCode | Country/Region Code | — | |
| prepayment | Prepayment | — | |
| financialVoid | Financial Void | — | |
| incomingDocumentEntryNumber | Incoming Document Entry No. | Specifies the number of the incoming document that this general journal line is created for. from the table field | |
| creditorNumber | Creditor No. | Specifies the vendor who sent the purchase invoice. from the table field | |
| paymentReference | Payment Reference | Specifies the payment of the purchase invoice. from the table field | |
| paymentMethodCode | Payment Method Code | Specifies how to make payment, such as with bank transfer, cash, or check. from the table field | |
| appliesToExtDocNumber | Applies-to Ext. Doc. No. | Specifies the external document number that will be exported in the payment file. from the table field | |
| recipientBankAccount | Recipient Bank Account | Specifies the bank account that the amount will be transferred to after it has been exported from the payment journal. from the table field | |
| messageToRecipient | Message to Recipient | Specifies the message exported to the payment file when you use the Export Payments to File function in the Payment Journal window. from the table field | |
| exportedToPaymentFile | Exported to Payment File | Specifies that the payment journal line was exported to a payment file. from the table field | |
| hasPaymentExportError | Has Payment Export Error | Specifies that an error occurred when you used the Export Payments to File function in the Payment Journal window. from the table field | |
| dimensionSetId | Dimension Set ID | — | |
| jobTaskNumber | Job Task No. | Specifies the number of the related project task. from the table field | |
| jobUnitPriceLcy | Job Unit Price (LCY) | — | |
| jobTotalPriceLcy | Job Total Price (LCY) | — | |
| jobQuantity | Job Quantity | Specifies the quantity for the project ledger entry that is derived from posting the journal line. If the Project Quantity is 0, the total amount on the project ledger entry will also be 0. from the table field | |
| jobUnitCostLcy | Job Unit Cost (LCY) | — | |
| jobLineDiscountPercent | Job Line Discount % | Specifies the line discount percentage of the project ledger entry that is related to the purchase line. from the table field | |
| jobLineDiscAmountLcy | Job Line Disc. Amount (LCY) | — | |
| jobUnitOfMeasureCode | Job Unit Of Measure Code | Specifies the unit of measure code that is used to determine the unit price. This code specifies how the quantity is measured, for example, by the box or by the piece. The application retrieves this code from the corresponding item or resource card. from the table field | |
| jobLineType | Job Line Type | Specifies the type of planning line to create when a project ledger entry is posted. If the field is empty, no planning lines are created. from the table field | |
| jobUnitPrice | Job Unit Price | Specifies the unit price for the selected account type and account number on the journal line. from the table field | |
| jobTotalPrice | Job Total Price | Specifies the total price for the journal line. The value is calculated as follows: Quantity x Unit Price (LCY). from the table field | |
| jobUnitCost | Job Unit Cost | Specifies the project cost of one unit of the item or resource on the journal line. The value is calculated as follows: Project Total Cost (LCY) / Project Quantity. from the table field | |
| jobTotalCost | Job Total Cost | Specifies if you have assigned a project number and a project task number to the journal line. It shows the amount excluding VAT divided by the project quantity for the journal line. The amount is shown in the currency specified for the project. The value field is calculated as follows: (Amount - VA… from the table field | |
| jobLineDiscountAmount | Job Line Discount Amount | Specifies the line discount amount of the project ledger entry. from the table field | |
| jobLineAmount | Job Line Amount | Specifies the line amount of the project ledger entry. from the table field | |
| jobTotalCostLcy | Job Total Cost (LCY) | — | |
| jobLineAmountLcy | Job Line Amount (LCY) | — | |
| jobCurrencyFactor | Job Currency Factor | — | |
| jobCurrencyCode | Job Currency Code | — | |
| jobPlanningLineNumber | Job Planning Line No. | Specifies the project planning line number that the usage should be linked to when the project journal is posted. You can only link to project planning lines that have the Apply Usage Link option enabled. from the table field | |
| jobRemainingQty | Job Remaining Qty. | Specifies the quantity that remains to complete a project. from the table field | |
| directDebitMandateId | Direct Debit Mandate ID | Specifies the identification of the direct-debit mandate that is being used on the journal lines to process a direct debit collection. from the table field | |
| dataExchEntryNumber | Data Exch. Entry No. | — | |
| payerInformation | Payer Information | Specifies payer information that is imported with the bank statement file. from the table field | |
| transactionInformation | Transaction Information | Specifies transaction information that is imported with the bank statement file. from the table field | |
| dataExchLineNumber | Data Exch. Line No. | — | |
| appliedAutomatically | Applied Automatically | Specifies that the general journal line has been automatically applied with a matching payment using the Apply Automatically function. from the table field | |
| deferralCode | Deferral Code | Specifies the deferral template that governs how expenses or revenue are deferred to the different accounting periods when the expenses or revenue were incurred. from the table field | |
| deferralLineNumber | Deferral Line No. | — | |
| campaignNumber | Campaign No. | Specifies the number of the campaign that the journal line is linked to. from the table field | |
| prodOrderNumber | Prod. Order No. | — | |
| faPostingDate | FA Posting Date | Specifies the posting date of the related fixed asset transaction, such as a depreciation. from the table field | |
| faPostingType | FA Posting Type | Specifies the posting type, if Account Type field contains Fixed Asset. from the table field | |
| depreciationBookCode | Depreciation Book Code | Specifies the code for the depreciation book to which the line will be posted if you have selected Fixed Asset in the Type field for this line. from the table field | |
| salvageValue | Salvage Value | Specifies the estimated residual value of a fixed asset when it can no longer be used. from the table field | |
| numberOfDepreciationDays | No. of Depreciation Days | Specifies the number of depreciation days if you have selected the Depreciation or Custom 1 option in the FA Posting Type field. from the table field | |
| deprUntilFaPostingDate | Depr. until FA Posting Date | Specifies if depreciation should be calculated until the FA posting date of the line. from the table field | |
| deprAcquisitionCost | Depr. Acquisition Cost | Specifies if, when this line was posted, the additional acquisition cost posted on the line was depreciated in proportion to the amount by which the fixed asset had already been depreciated. from the table field | |
| maintenanceCode | Maintenance Code | Specifies a maintenance code. from the table field | |
| insuranceNumber | Insurance No. | Specifies an insurance code if you have selected the Acquisition Cost option in the FA Posting Type field. from the table field | |
| budgetedFaNumber | Budgeted FA No. | Specifies the number of a fixed asset with the Budgeted Asset check box selected. When you post the journal or document line, an additional entry is created for the budgeted fixed asset where the amount has the opposite sign. from the table field | |
| duplicateInDepreciationBook | Duplicate in Depreciation Book | Specifies a depreciation book code if you want the journal line to be posted to that depreciation book, as well as to the depreciation book in the Depreciation Book Code field. from the table field | |
| useDuplicationList | Use Duplication List | Specifies whether the line is to be posted to all depreciation books, using different journal batches and with a check mark in the Part of Duplication List field. from the table field | |
| faReclassificationEntry | FA Reclassification Entry | Specifies if the entry was generated from a fixed asset reclassification journal. from the table field | |
| faErrorEntryNumber | FA Error Entry No. | Specifies the number of a posted FA ledger entry to mark as an error entry. from the table field | |
| indexEntry | Index Entry | — | |
| sourceLineNumber | Source Line No. | — | |
| comment | Comment | Specifies a comment about the activity on the journal line. Note that the comment is not carried forward to posted entries. from the table field | |
| checkExported | Check Exported | — | |
| checkTransmitted | Check Transmitted | — | |
| id | Rec.SystemId |
— | |
| accountId | Account Id | — | |
| customerId | Customer Id | — | |
| appliesToInvoiceId | Applies-to Invoice Id | — | |
| contactGraphId | Contact Graph Id | — | |
| lastModifiedDatetime | Last Modified DateTime | — | |
| journalBatchId | Journal Batch Id | — |
Relations
- source table Table 81 “Gen. Journal Line”
Ask your agent
Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "page", object_name: "Gen. Journal Line Entity"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.