Show / Hide Table of Contents

    IQ Hist. Gen. Jnl. Lines

    Object Definition

    Object TypePage
    Object ID70314196
    Object NameQWESR IQ Hist. Gen. Jnl. Lines
    Source TableQWESR IQ Hist. Gen. Jnl. Line
    Read-onlyYes

    Controls

    Type Caption ToolTip
    Field Integration Queue Entry No. Specifies the entry number for the Integration Queue History that this line is connected to.
    Field Line No. Specifies the number for this line.
    Field Journal Template Name Specifies the name of the journal template to link to the transaction.
    Field Journal Batch Name Specifies the name of the journal batch to link to the transaction.
    Field Document No. Specifies the document number of the transaction in the general ledger.
    Field Posting Date Specifies the date of the transaction in the general ledger, and thereby the fiscal year and period.
    Field Account Type Specifies the type of account that the line will be posted to.
    Field Account No. Specifies the account that the line will be posted to.
    Field Amount Specifies the total amount that the line consists of. The amount can include VAT, especially if Copy VAT Setup to Jnl. Lines is enabled.
    Field Amount (LCY) Specifies the total amount in local currency that the line consists of. The amount can include VAT, especially if Copy VAT Setup to Jnl. Lines is enabled.
    Field Applies-to Doc. No. Specifies the number of the posted document that this line will be applied to when you post, for example to register a payment.
    Field Applies-to Doc. Type Specifies the type of the posted document that this line will be applied to when you post, for example to register a payment.
    Field Bal. Account No. Specifies the number of the account that the balancing entry is posted to, such as a general ledger, customer, vendor, or bank account.
    Field Bal. Account Type Specifies the type of account that the balancing entry is posted to, such as Bank Account for a cash account.
    Field 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.
    Field Bal. Gen. Posting Type Specifies the general posting type associated with the balancing account that will be used when you post the entry.
    Field 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.
    Field Bal. VAT Amount Specifies the amount of balancing VAT included in the total amount.
    Field Bal. VAT Base Amount Specifies the balancing net amount. Useful for entering an amount excluding VAT.
    Field Bal. VAT Bus. Posting Group Specifies the VAT business posting group code associated with the balancing account that will be used when you post the entry.
    Field Bal. VAT Prod. Posting Group Specifies the VAT product posting group code associated with the balancing account that will be used when you post the entry.
    Field Bank Payment Type Specifies the code for the payment type to be used for the entry.
    Field Business Unit Code Specifies the code of the business unit that the entry is linked to.
    Field Country/Region Code Specifies the code of the country or region.
    Field Credit Amount Specifies the credit amount. Amounts entered in this field will automatically be entered with the opposite sign in the Amount field.
    Field Currency Code Specifies the code of the currency for the amounts on the line.
    Field Debit Amount Specifies the debit amount. Amounts entered in this field will automatically be entered with the same sign in the Amount field.
    Field Deferral Code Specifies the deferral template that controls how expenses or revenues are deferred to the different accounting periods in which the expenses or revenues occurred.
    Field 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.
    Field Description Specifies the description of the line.
    Field Dimension 1 Value Specifies the code for the dimension configured for this integration.
    Field Dimension 2 Value Specifies the code for the dimension configured for this integration.
    Field Dimension 3 Value Specifies the code for the dimension configured for this integration.
    Field Dimension 4 Value Specifies the code for the dimension configured for this integration.
    Field Dimension 5 Value Specifies the code for the dimension configured for this integration.
    Field Dimension 6 Value Specifies the code for the dimension configured for this integration.
    Field Dimension 7 Value Specifies the code for the dimension configured for this integration.
    Field Dimension 8 Value Specifies the code for the dimension configured for this integration.
    Field Dimension 9 Value Specifies the code for the dimension configured for this integration.
    Field Dimension 10 Value Specifies the code for the dimension configured for this integration.
    Field Document Date Specifies the origin date of the related record.
    Field Document Type Specifies the type of document that the entry on the line is.
    Field Due Date Specifies the date when the related record should be paid.
    Field External Document No. Specifies a document number that refers to the customer's or vendor's numbering system.
    Field FA Posting Date Specifies the posting date of the related fixed asset transaction, such as a depreciation.
    Field FA Posting Type Specifies the type of transaction, if the Account Type field contains Fixed Asset.
    Field G/L Register No. Specifies the number of the G/L Register.
    Field 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.
    Field Gen. Posting Type Specifies the type of transaction it is when VAT is posted.
    Field Gen. Prod. Posting Group Specifies the product's type to link transactions made for this product with the appropriate general ledger account according to the general posting setup.
    Field IC Direction Specifies the direction of the intercompany transaction.
    Field IC Partner G/L Acc. No. Specifies the account number in your IC partner's company that corresponds to the G/L account on the line.
    Field Incoming Document Entry No. Specifies the number of the incoming document that this line is created for.
    Field Job Currency Code Specifies the job's currency code.
    Field Job Currency Factor Specifies the job's currency factor.
    Field Job Line Amount Specifies the line amount that will be posted to the job ledger entries.
    Field Job Line Discount % Specifies the line discount percentage that will be posted to the job ledger entries.
    Field Job Line Discount Amount Specifies the line discount amount that will be posted to the job ledger entries.
    Field Job Line Type Specifies the type of planning line to create when a job ledger entry is created. If the field is empty, no planning lines are created.
    Field Job No. Specifies the number of the related job.
    Field Job Quantity Specifies the quantity for the job ledger entry that is derived from posting the line. If the Job Quantity is 0, the total amount on the job ledger entry will also be 0.
    Field Job Task No. Specifies the number of the related job task.
    Field 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.
    Field Job Unit Price Specifies the job unit price for the selected account type and account number on the line.
    Field 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.
    Field On Hold Specifies if the entry should be set to On Hold in the vendor ledger entries or customer ledger entries depending on the Account Type. An entry set to On Hold will be paused for payment.
    Field Payment Discount % Specifies the payment discount percentage.
    Field Payment Terms Code Specifies the code that represents when the payment is due.
    Field Pmt. Discount Date Specifies the date of the payment discount.
    Field Posted Entry No. Specifies the Entry No. in the general ledger entries.
    Field Posting Group Specifies the posting group.
    Field Quantity Specifies the quantity of the products on the line.
    Field Reason Code Specifies the code that represents why the record is created. Useful for audit trails.
    Field Salespers./Purch. Code Specifies the code that represents the salesperson or purchaser who is linked to the line.
    Field Source Code Specifies the code that represents the origin of the record. Useful for audit trails.
    Field VAT Amount Specifies the amount of VAT that is included in the total amount.
    Field VAT Base Amount Specifies the net amount. Useful for entering an amount excluding VAT.
    Field 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.
    Field VAT Prod. Posting Group Specifies the VAT specification of the involved product to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.
    Field Manually Changed Specifies if the line has been manually modified by a user after the file was imported, but before posting.

    This documentation is generated from Spider v27.0

    Back to top Copyright © 2020 SmartApps
    Generated by DocFX