Job Journal Line

    API Details

    Property Value
    Endpoint /tablesRealEstate/jobJournalLines
    Table name Job Journal Line
    Table id 210
    Table caption Job Journal Line
    Data per company True
    Group RealEstate

    Schema

    erd

    Properties

    Property Table Fieldname Type Max.Length Key Options Table relation Version introduced Version removed Obsolete state Obsolete reason
    id System Id GUID 16
    journalTemplateName Journal Template Name Code 10 * Job Journal Template
    lineNo Line No. Integer 4 *
    jobNo1 Job No. Code 20 Job
    postingDate Posting Date Date 4
    documentNo Document No. Code 20
    type Type Option 4 Resource, Item, G/L Account
    no No. Code 20
    description Description Text 100
    quantity Quantity Decimal 12
    directUnitCostLCY Direct Unit Cost (LCY) Decimal 12
    unitCostLCY Unit Cost (LCY) Decimal 12
    totalCostLCY Total Cost (LCY) Decimal 12
    unitPriceLCY Unit Price (LCY) Decimal 12
    totalPriceLCY Total Price (LCY) Decimal 12
    resourceGroupNo Resource Group No. Code 20 Resource Group
    unitOfMeasureCode Unit of Measure Code Code 10
    qtyRoundingPrecision Qty. Rounding Precision Decimal 12
    qtyRoundingPrecisionBase Qty. Rounding Precision (Base) Decimal 12
    locationCode Location Code Code 10
    chargeable Chargeable Boolean 4
    postingGroup Posting Group Code 20
    shortcutDimension1Code Shortcut Dimension 1 Code Code 20
    shortcutDimension2Code Shortcut Dimension 2 Code Code 20
    workTypeCode Work Type Code Code 10 Work Type
    customerPriceGroup Customer Price Group Code 10 Customer Price Group
    appliestoEntry Applies-to Entry Integer 4
    shptMethodCode Shpt. Method Code Code 10 Shipment Method
    entryType Entry Type Option 4 Usage, Sale
    sourceCode Source Code Code 10 Source Code
    journalBatchName Journal Batch Name Code 10 *
    reasonCode Reason Code Code 10 Reason Code
    recurringMethod Recurring Method Option 4 , Fixed, Variable
    expirationDate Expiration Date Date 4
    recurringFrequency Recurring Frequency DateFormula 32
    genBusPostingGroup Gen. Bus. Posting Group Code 20 Gen. Business Posting Group
    genProdPostingGroup Gen. Prod. Posting Group Code 20 Gen. Product Posting Group
    transactionType Transaction Type Code 10 Transaction Type
    transportMethod Transport Method Code 10 Transport Method
    countryRegionCode Country/Region Code Code 10 Country/Region
    entryExitPoint Entry/Exit Point Code 10 Entry/Exit Point
    documentDate Document Date Date 4
    externalDocumentNo External Document No. Code 35
    area Area Code 10 Area
    transactionSpecification Transaction Specification Code 10 Transaction Specification
    serialNo Serial No. Code 50
    postingNoSeries Posting No. Series Code 20 No. Series
    sourceCurrencyCode Source Currency Code Code 10 Currency
    sourceCurrencyTotalCost Source Currency Total Cost Decimal 12
    sourceCurrencyTotalPrice Source Currency Total Price Decimal 12
    sourceCurrencyLineAmount Source Currency Line Amount Decimal 12
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    timeSheetNo Time Sheet No. Code 20 Time Sheet Header
    timeSheetLineNo Time Sheet Line No. Integer 4
    timeSheetDate Time Sheet Date Date 4
    jobTaskNo Job Task No. Code 20
    totalCost Total Cost Decimal 12
    unitPrice Unit Price Decimal 12
    lineType Line Type Option 4 , Budget, Billable, Both Budget and Billable
    appliesfromEntry Applies-from Entry Integer 4
    jobPostingOnly Job Posting Only Boolean 4
    lineDiscountPct Line Discount % Decimal 12
    lineDiscountAmount Line Discount Amount Decimal 12
    currencyCode Currency Code Code 10 Currency
    lineAmount Line Amount Decimal 12
    currencyFactor Currency Factor Decimal 12
    unitCost Unit Cost Decimal 12
    lineAmountLCY Line Amount (LCY) Decimal 12
    lineDiscountAmountLCY Line Discount Amount (LCY) Decimal 12
    totalPrice Total Price Decimal 12
    costFactor Cost Factor Decimal 12
    description2 Description 2 Text 50
    ledgerEntryType Ledger Entry Type Option 4 , Resource, Item, G/L Account
    ledgerEntryNo Ledger Entry No. Integer 4
    jobPlanningLineNo Job Planning Line No. Integer 4
    remainingQty Remaining Qty. Decimal 12
    remainingQtyBase Remaining Qty. (Base) Decimal 12
    variantCode Variant Code Code 10
    binCode Bin Code Code 20
    qtyPerUnitOfMeasure Qty. per Unit of Measure Decimal 12
    quantityBase Quantity (Base) Decimal 12
    serviceOrderNo Service Order No. Code 20
    postedServiceShipmentNo Posted Service Shipment No. Code 20
    lotNo Lot No. Code 50
    packageNo Package No. Code 50
    priceCalculationMethod Price Calculation Method Option 4 , Lowest Price, Test Price, Test Price (not Implemented)
    costCalculationMethod Cost Calculation Method Option 4 , Lowest Price, Test Price, Test Price (not Implemented)
    jobType Job Type Option 4 , Maintenance Task, Planned Maintenance, Project, Improductivity, Maintenance Order
    volgnummerAfspraak Appointment Entry No. Integer 4
    reistijd Travel time Boolean 4
    urenAccoord Hours approved Boolean 4
    tijdvak Period Code 20 Period
    postedQuantity Posted Quantity Decimal 12
    realQuantity Real Quantity Decimal 12
    improductivityJournal Improductivity Journal Boolean 4
    resourceNoUsage Resource No. Usage Code 20 Resource
    crossReferenceNo Item Reference No. Code 50 Item Reference
    newCostCode New Cost Code Text 10 Cost Code
    livDossierNo Liv. Dossier No. Code 20 Livability Dossier
    costCodeToCorrect New Cost Code Text 10 Cost Code
    postJobEntryOnly Post Job Entry Only Boolean 4
    travelTime Travel Time (2) Boolean 4
    empireJobNo Project No. (Emp.) Code 20 Empire Project
    budgetregelnr Budget Line No. Integer 4
    werksoortboekingsgroep Work Type Posting Group Code Code 10 Werksoortboekingsgroep
    empireJobType Project Type Code Code 20 Empire Projecttype
    projectfase Project Phase Code Code 10
    vatProdPostingGroup VAT Prod. Posting Group Code 10 VAT Product Posting Group
    maintenanceRequestNo Maintenance Request No. Code 20
    chargedFromJobLedgEntryNo Charged From Job Ledger Entry No. Integer 4 Job Ledger Entry
    chargeToCustomer Charge to Customer Boolean 4
    externalCostsExclVAT External Costs excl. VAT Decimal 12
    externalVATProdPostingGrp External VAT Prod. Posting Group Code 10 VAT Product Posting Group
    taskSpecificationType Task Specification Type Option 4 , Arbeid, Materiaal, Voorrijkosten, Diverse kosten
    takeAwayMaterialNo Take Away Material No. Integer 4 Connect-It Take Away Material
    hourlyRatesCode Hourly Rates Code Code 20 Hourly Rates
    distributionKeyID Distribution Key ID Integer 4
    distributionReferenceDate Distribution Reference Date Date 4
    jobNo2 Job No. Code 20
    systemId System ID GUID 16
    systemCreatedAt Created At DateTime 8
    systemCreatedBy Created By GUID 16 User
    systemModifiedAt Modified At DateTime 8
    systemModifiedBy Modified By GUID 16 User
    lastModifiedDateTime Last Modified Date Time DateTime 8