User Setup

    API Details

    Property Value
    Endpoint /tablesGeneral/userSetups
    Table name User Setup
    Table id 91
    Table caption User Setup
    Data per company True
    Group General

    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
    userID User ID Code 50 * User
    allowPostingFrom Allow Posting From Date 4
    allowPostingTo Allow Posting To Date 4
    registerTime Register Time Boolean 4
    allowDeferralPostingFrom Allow Deferral Posting From Date 4
    allowDeferralPostingTo Allow Deferral Posting To Date 4
    salespersPurchCode Sales/Purch. Person Code Code 20
    approverID Approver ID Code 50 User Setup
    salesAmountApprovalLimit Sales Amount Approval Limit Integer 4
    purchaseAmountApprovalLimit Purchase Amount Approval Limit Integer 4
    unlimitedSalesApproval Unlimited Sales Approval Boolean 4
    unlimitedPurchaseApproval Unlimited Purchase Approval Boolean 4
    substitute Substitute Code 50 User Setup
    eMail E-Mail Text 100
    phoneNo Phone No. Text 30
    requestAmountApprovalLimit Request Amount Approval Limit Integer 4
    unlimitedRequestApproval Unlimited Request Approval Boolean 4
    approvalAdministrator Approval Administrator Boolean 4
    allowVATDateFrom Allow VAT Date From Date 4
    allowVATDateTo Allow VAT Date To Date 4
    salesInvoicePostingPolicy Sales Invoice Posting Policy Option 4 Allowed, Prohibited, Mandatory
    purchInvoicePostingPolicy Purch. Invoice Posting Policy Option 4 Allowed, Prohibited, Mandatory
    timeSheetAdmin Time Sheet Admin. Boolean 4
    allowFAPostingFrom Allow FA Posting From Date 4
    allowFAPostingTo Allow FA Posting To Date 4
    salesRespCtrFilter Sales Resp. Ctr. Filter Code 10 Responsibility Center
    purchaseRespCtrFilter Purchase Resp. Ctr. Filter Code 10 Responsibility Center
    serviceRespCtrFilter Service Resp. Ctr. Filter Code 10 Responsibility Center
    responsibilityCenter Responsibility center default value Code 20 Responsibility Center
    globalDimension1Filter Global Dimension 1 Filter Code 80
    deurwaarder Bailiff Boolean 4
    blokkDimwijzGrootboekrek Block Dimension Change For G/L Account Code 250
    grootboekrekfilterLezen G/L Account Filter Read Code 250
    grootboekrekfilterBoeken G/L Account Filter Posting Code 250
    applbeheerderHuurtoeslag Appl. Manager Housing Benefit Boolean 4
    boekingsdatumMutabel Posting Date Changeable Option 4 Nooit, Eventueel, Altijd
    prolongatie Prolongation Boolean 4
    elementpostenVerwijderen Remove Element Entries Boolean 4
    removeCostCodeEntries Remove Cost Code Entries Boolean 4
    approver Approver Boolean 4
    name Sales/Purch. Person Name Text 50
    corrKostSrtRepVrzkMetPosten Correct Cost Type On Repair Request Tasks With Posted Entries Boolean 4
    verhuurmutatiesAccorderen Approve Rent Price Mutations Boolean 4
    registratiedatumWijzigen Change Registration Date Boolean 4
    verhuurmutatiesFiatteren Authorize Rent Price Mutations Boolean 4
    backdatedProlongation Backdated Prolongation Boolean 4
    projecttypefilter Job Type Filter Code 80 Empire Projecttype
    permissieBudgetwkladblok Permission Budget Change Notebook Boolean 4
    permissieHeropenenProject Permission Reopen Job Boolean 4
    permissieIngavePrognose Permission Insert Prognosis Boolean 4
    permissieBlokkeren Block Permission Boolean 4
    permissieWijzigenStatusfase Permission Change Status/Phase Boolean 4
    permissieAccorderenUren Permission Approve Hour Boolean 4
    permissieBoekenUren Permission Post Hour Boolean 4
    permissieBudgetwijzProj Permission Budget Change Job Boolean 4
    permissieHandmInvoerKladbl Permission Manual Insert Notebook Boolean 4
    permissieHandmInvoerProject Permission Manual Insert Job Boolean 4
    reopenAwardedOrder Reopen Awarded Order Boolean 4
    genKenmerkenmodule Gen. Characteristics Module Boolean 4
    blokkerenFinancieringen Block Financing Boolean 4
    accordFinancieringsmodel Approve Financing Concept Boolean 4
    accordFinancieringsvorm Approve Financing Form Boolean 4
    accorderenKasstroom Approve Cash Flow Boolean 4
    accorderenRentepercentage Approve Interest Percentage Boolean 4
    postcodecontroleNegeren Ignore Zip Control Result Boolean 4
    changeComplaintStatus Change Complaint Status Boolean 4
    replacementPurchInvCredit Replacement Purchase Invoice Creditnota Boolean 4
    publicatiecontroleWijzigen Change Publication Check Boolean 4
    gaselektraGecontroleerd Gas/Electra Checked Boolean 4
    permissieHeropenRepVerzoek Permission Reopen Repair Request (Tasks) Boolean 4
    overruleTenantAgreesToCosts Permission to modify charging after tenant agreed Boolean 4
    projectfilter Job Filter Code 250
    sVafrekeningenFiatteren Approve S&&V settlement Boolean 4
    sVafrekeningstatusWijzigen Change S&&V settlement Boolean 4
    bemiddelingsstatusWijzigen Change Mediation Status Boolean 4
    mutprocesToonAfgehandeld Show Finished Boolean 4
    verhuuraanbiedingWijzigen Change Net Rent Offer After Intake Mediation Boolean 4
    bouwnummersVrijgeven Release Building No. Boolean 4
    permissieHeropenProjectfase Permission Reopen Job Phase Boolean 4
    fixtureTypeFilter Fixture Type Code 250
    serviceCallTypeFilter Service Call Type Code 250
    interactionTemplCodeFilter Interaction Template Code Code 250
    dechHomeAddressAllowed Dechecking 'Home Adress' Allowed Boolean 4
    dechOAMemberAllowed Dechecking 'OA Member' Allowed Boolean 4
    changeLibContractInd Change 'Liberalized Contract' Indication Boolean 4
    bailiffNo Bailiff No. Code 50
    manuallyClosePurchaseOrder Manually Close Purchase Order Boolean 4
    wijzigenFinboekingsgroep Change Fin. Posting Group Boolean 4
    wijzigenGeldgeverID Change Financier ID Boolean 4
    wijzigenGrootboekintegratie Change G/L Account Integration Boolean 4
    ignoreMaintenanceErrors Ignore Maintenance Errors Boolean 4
    responsibilityCenterCheck Responsibility center check Code 20 Responsibility Center
    removePermissionsEmPlanner Permission Remove Request and/or Order Em-Planner Boolean 4
    approvalLevel Approval Level Integer 4
    deduplicateContacts Deduplicate Contacts Boolean 4
    createNewRentalJust Create new Rental Justification manually Boolean 4
    activateClusterDistrKey Activate Cluster Distribution Key Boolean 4
    activateProjBudgLnDistrKey Activate Project Budget Line Distribution Key Boolean 4
    activateChangeOGEAdmOwner Activate Change of OGE Administrative Owner 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