Resource

    API Details

    Property Value
    Endpoint /tablesRealEstate/resources
    Table name Resource
    Table id 156
    Table caption Resource
    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
    no No. Code 20 *
    type Type Option 4 Person, Machine
    name Name Text 100
    searchName Search Name Code 100
    name2 Name 2 Text 50
    address Address Text 100
    address2 Address 2 Text 50
    city City Text 30
    socialSecurityNo Social Security No. Text 30
    jobTitle Job Title Text 30
    education Education Text 30
    contractClass Contract Class Text 30
    employmentDate Employment Date Date 4
    resourceGroupNo Resource Group No. Code 20 Resource Group
    globalDimension1Code Global Dimension 1 Code Code 20
    globalDimension2Code Global Dimension 2 Code Code 20
    baseUnitOfMeasure Base Unit of Measure Code 10 Unit of Measure
    directUnitCost Direct Unit Cost Decimal 12
    indirectCostPct Indirect Cost % Decimal 12
    unitCost Unit Cost Decimal 12
    profitPct Profit % Decimal 12
    priceProfitCalculation Price/Profit Calculation Option 4 Profit=Price-Cost, Price=Cost+Profit, No Relationship
    unitPrice Unit Price Decimal 12
    vendorNo Vendor No. Code 20 Vendor
    lastDateModified Last Date Modified Date 4
    blocked Blocked Boolean 4
    genProdPostingGroup Gen. Prod. Posting Group Code 20 Gen. Product Posting Group
    postCode Post Code Code 20
    county County Text 30
    automaticExtTexts Automatic Ext. Texts Boolean 4
    noSeries No. Series Code 20 No. Series
    taxGroupCode Tax Group Code Code 20 Tax Group
    vatProdPostingGroup VAT Prod. Posting Group Code 20 VAT Product Posting Group
    countryRegionCode Country/Region Code Code 10 Country/Region
    icPartnerPurchGLAccNo IC Partner Purch. G/L Acc. No. Code 20 IC G/L Account
    image Image Media 16
    privacyBlocked Privacy Blocked Boolean 4
    useTimeSheet Use Time Sheet Boolean 4
    timeSheetOwnerUserID Time Sheet Owner User ID Code 50 User Setup
    timeSheetApproverUserID Time Sheet Approver User ID Code 50 User Setup
    defaultDeferralTemplateCode Default Deferral Template Code Code 10 Deferral Template
    serviceZoneFilter Service Zone Filter Code 10 Service Zone
    telefoon Telefoon Text 30
    userID Gebruikers-ID Code 50 User
    currentWeekNo Huidig weeknr. Integer 4
    currentYear Huidig jaar Integer 4
    workHourTemplate Werkurensjabloon Code 10 Work-Hour Template
    useTimesheet Gebruik weekbon Boolean 4
    eMail E-Mail Text 80
    toeslagAfval Toeslag afval Decimal 12
    toeslagKleinMateriaal Toeslag klein materiaal Decimal 12
    surchargeSmallMaterialsAmt Fixed order surcharge small material charge Decimal 12
    postCodeHouseNo Post Code + House No. Code 20
    workman Workman Boolean 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