Job Ledger Entry

    API Details

    Property Value
    Endpoint /tablesRealEstate/empireJobLedgerEntries
    Table name Empire Job Ledger Entry
    Table id 11030476
    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 Job No. Code 20 Empire Project
    postingDate Posting Date Date 4
    documentNo Document No. Code 20
    type Type Option 4 Resource, Item, G/L Account
    jobType Projecttype Code 20 Empire Projecttype
    no No. Code 20
    description Description Text 100
    quantity Quantity Decimal 12
    directUnitCost Direct Unit Cost Decimal 12
    unitCost Unit Cost Decimal 12
    totalCost Total Cost Decimal 12
    unitPrice Unit Price Decimal 12
    totalPrice Total Price Decimal 12
    resourceGroupNo Resource Group No. Code 20 Resource Group
    unitOfMeasureCode Unit of Measure Code Code 10
    locationCode Location Code Code 10
    chargeable Chargeable Boolean 4
    dueDate Due Date Date 4
    nrHoofdproject Nr. Hoofdproject Code 20
    jobPostingGroup Job Posting Group Code 20
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    workTypeCode Work Type Code Code 20 Empire Werksoort
    customerPriceGroup Customer Price Group Code 10 Customer Price Group
    userID User ID Code 50 User
    sourceCode Source Code Code 10 Source Code
    relatedToBudget Related to Budget Boolean 4
    wipAmtInclVAT Realization Decimal 12
    realisatieInclBTW Realization incl. VAT Decimal 12
    amtRecognized Amt. Recognized Decimal 12
    entryType Entry Type Option 4 Usage, Sale
    positive Positive Boolean 4
    open Open Boolean 4
    remainingAmount Remaining Amount Decimal 12
    closedByEntryNo Closed by Entry No. Integer 4 Empire Job Ledger Entry
    closedAtDate Closed at Date Date 4
    closedByAmount Closed by Amount Decimal 12
    appliestoID Applies-to ID Code 20
    journalBatchName Journal Batch Name Code 10
    reasonCode Reason Code Code 10 Reason Code
    countryCode Country 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
    documentDate Document Date Date 4
    externalDocumentNo External Document No. Code 35
    noSeries No. Series Code 20 No. Series
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    description2 Description 2 Text 50
    variantCode Variant Code Code 10
    qtyPerUnitOfMeasure Qty. per Unit of Measure Decimal 12
    hoursPosted Geboekt Boolean 4
    budgetlineNo Budget Line No. Integer 4
    budgetdetaillineNo Budget Detail Line No. Integer 4
    cluster Cluster Code 20 Cluster
    hoursOK Approved Option 4 , Ja, Nee
    geaccoordeerdDoor Approved by Code 50
    workTypePostingGroup Work Type Posting Group Code 10 Werksoortboekingsgroep
    totalCostExclVAT Total Cost excl. VAT Decimal 12
    wipAmtExclVAT Realization excl. VAT Decimal 12
    gekoppAanSubsidieordernr Linked to Subsidy/Order No. Code 20
    gekoppeldAanRegelnr Linked to Line No. Integer 4
    interestentry Interest Entry Boolean 4
    interestEnddate Interest End Date Date 4
    interestBaseAmount Interest base amount Decimal 12
    projectfase Project Phase Code 10
    conversionEntry Conversion Entry Boolean 4
    totalPriceInclVAT Total Price incl. VAT Decimal 12
    vergoeding Compensation Boolean 4
    vatBusPostingGroup VAT Bus. Posting Group Code 20 VAT Business Posting Group
    vatProdPostingGroup VAT Prod. Posting Group Code 20 VAT Product Posting Group
    maintenanceService Maintenance Service Boolean 4
    componentModelNo Component Model No. Code 20 Projectmodel
    vendorNo Vendor No. Code 20 Vendor
    distributionKeyID Distribution Key ID Integer 4
    distributionReferenceDate Distribution Reference Date Date 4
    realtyObjectNo Realty Object No. Code 20 OGE
    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