Job Ledger Entry

    API Details

    Property Value
    Endpoint /tablesRealEstate/jobLedgerEntries
    Table name Job Ledger Entry
    Table id 169
    Table caption Job Ledger Entry
    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
    entryNo Entry No. Integer 4 *
    jobNo Maint. Order No./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
    locationCode Location Code Code 10
    jobPostingGroup Posting Group Code 20 Inventory Posting Group
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    workTypeCode Work Type Code Code 10 Work Type
    customerPriceGroup Customer Price Group Code 10 Customer Price Group
    userID User ID Code 50 User
    sourceCode Source Code Code 10 Source Code
    shptMethodCode Shpt. Method Code Code 10 Shipment Method
    amtToPostToGL Amt. to Post to G/L Decimal 12
    amtPostedToGL Amt. Posted to G/L Decimal 12
    entryType Entry Type Option 4 Usage, Sale
    journalBatchName Journal Batch Name Code 10
    reasonCode Reason Code Code 10 Reason Code
    transactionType Transaction Type Code 10 Transaction Type
    transportMethod Transport Method Code 10 Transport Method
    countryRegionCode Country/Region Code Code 10 Country/Region
    genBusPostingGroup Gen. Bus. Posting Group Code 20 Gen. Business Posting Group
    genProdPostingGroup Gen. Prod. Posting Group Code 20 Gen. Product Posting Group
    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
    noSeries No. Series Code 20 No. Series
    additionalCurrencyTotalCost Additional-Currency Total Cost Decimal 12
    addCurrencyTotalPrice Add.-Currency Total Price Decimal 12
    addCurrencyLineAmount Add.-Currency Line Amount Decimal 12
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    jobTaskNo Job Task No. Code 20
    lineAmountLCY Line Amount (LCY) Decimal 12
    unitCost Unit Cost Decimal 12
    totalCost Total Cost Decimal 12
    unitPrice Unit Price Decimal 12
    totalPrice Total Price Decimal 12
    lineAmount Line Amount Decimal 12
    lineDiscountAmount Line Discount Amount Decimal 12
    lineDiscountAmountLCY Line Discount Amount (LCY) Decimal 12
    currencyCode Currency Code Code 10 Currency
    currencyFactor Currency 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
    serialNo Serial No. Code 50
    lotNo Lot No. Code 50
    lineDiscountPct Line Discount % Decimal 12
    lineType Line Type Option 4 , Budget, Billable, Both Budget and Billable
    originalUnitCostLCY Original Unit Cost (LCY) Decimal 12
    originalTotalCostLCY Original Total Cost (LCY) Decimal 12
    originalUnitCost Original Unit Cost Decimal 12
    originalTotalCost Original Total Cost Decimal 12
    originalTotalCostACY Original Total Cost (ACY) Decimal 12
    adjusted Adjusted Boolean 4
    dateTimeAdjusted DateTime Adjusted DateTime 8
    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
    packageNo Package No. Code 50
    jobType Job Type Option 4 , Maintenance, Planned Maintenance, Project, Improductivity, Maintenance Order
    clusternr Cluster No. Code 20 Cluster
    eenheidnr Object No. Code 20 OGE
    correctionCostCode Correction Cost Code Boolean 4
    unitCostExclCharge Cost Price Excl. Surcharge Decimal 12
    resourceNoUsage Resource No. Usage Code 20
    livDossierNo Livability Dossier No. Code 20 Livability Dossier
    livability Livability Boolean 4
    travelTime Travel Time Boolean 4
    approvedBy Approved By Code 20
    empireJobLedgerEntryNo Empire Job Ledger Entry No. Integer 4
    vatProdPostingGroup VAT Prod. Posting Group Code 20 VAT Product Posting Group
    maintenanceRequestNo Maintenance Request No. Code 20
    commonArea Common Area Boolean 4
    chargedWithJobLedgEntryNo Charged With Job Ledger Entry No. Integer 4 Job Ledger Entry
    externalCostsExclVAT External Costs excl. VAT Decimal 12
    externalVATProdPostingGrp External VAT Prod. Posting Group Code 20 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
    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