Sales & Receivables Setup

    API Details

    Property Value
    Endpoint /tablesHousing/salesReceivablesSetups
    Table name Sales & Receivables Setup
    Table id 311
    Table caption Sales & Receivables Setup
    Data per company True
    Group Housing

    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
    primaryKey Primary Key Code 10 *
    discountPosting Discount Posting Option 4 No Discounts, Invoice Discounts, Line Discounts, All Discounts
    creditWarnings Credit Warnings Option 4 Both Warnings, Credit Limit, Overdue Balance, No Warning
    stockoutWarning Stockout Warning Boolean 4
    shipmentOnInvoice Shipment on Invoice Boolean 4
    invoiceRounding Invoice Rounding Boolean 4
    extDocNoMandatory Ext. Doc. No. Mandatory Boolean 4
    customerNos Customer Nos. Code 20 No. Series
    quoteNos Quote Nos. Code 20 No. Series
    orderNos Order Nos. Code 20 No. Series
    invoiceNos Invoice Nos. Code 20 No. Series
    postedInvoiceNos Posted Invoice Nos. Code 20 No. Series
    creditMemoNos Credit Memo Nos. Code 20 No. Series
    postedCreditMemoNos Posted Credit Memo Nos. Code 20 No. Series
    postedShipmentNos Posted Shipment Nos. Code 20 No. Series
    reminderNos Reminder Nos. Code 20 No. Series
    issuedReminderNos Issued Reminder Nos. Code 20 No. Series
    finChrgMemoNos Fin. Chrg. Memo Nos. Code 20 No. Series
    issuedFinChrgMNos Issued Fin. Chrg. M. Nos. Code 20 No. Series
    postedPrepmtInvNos Posted Prepmt. Inv. Nos. Code 20 No. Series
    postedPrepmtCrMemoNos Posted Prepmt. Cr. Memo Nos. Code 20 No. Series
    blanketOrderNos Blanket Order Nos. Code 20 No. Series
    calcInvDiscount Calc. Inv. Discount Boolean 4
    applnBetweenCurrencies Appln. between Currencies Option 4 None, EMU, All
    copyCommentsBlanketToOrder Copy Comments Blanket to Order Boolean 4
    copyCommentsOrderToInvoice Copy Comments Order to Invoice Boolean 4
    copyCommentsOrderToShpt Copy Comments Order to Shpt. Boolean 4
    allowVATDifference Allow VAT Difference Boolean 4
    calcInvDiscPerVATID Calc. Inv. Disc. per VAT ID Boolean 4
    logoPositionOnDocuments Logo Position on Documents Option 4 No Logo, Left, Center, Right
    checkPrepmtWhenPosting Check Prepmt. when Posting Boolean 4
    prepmtAutoUpdateFrequency Prepmt. Auto Update Frequency Option 4 Never, Daily, Weekly
    defaultPostingDate Default Posting Date Option 4 Work Date, No Date
    defaultQuantityToShip Default Quantity to Ship Option 4 Remainder, Blank
    postWithJobQueue Post with Job Queue Boolean 4
    jobQueueCategoryCode Job Queue Category Code Code 10 Job Queue Category
    jobQueuePriorityForPost Job Queue Priority for Post Integer 4
    postPrintWithJobQueue Post & Print with Job Queue Boolean 4
    jobQPrioForPostPrint Job Q. Prio. for Post & Print Integer 4
    notifyOnSuccess Notify On Success Boolean 4
    vatBusPostingGrPrice VAT Bus. Posting Gr. (Price) Code 20 VAT Business Posting Group
    directDebitMandateNos Direct Debit Mandate Nos. Code 20 No. Series
    allowDocumentDeletionBefore Allow Document Deletion Before Date 4
    reportOutputType Report Output Type Option 4 PDF, Print
    documentDefaultLineType Document Default Line Type Option 4 , G/L Account, Item, Resource, Fixed Asset, Charge (Item), Allocation Account, Element
    defaultItemQuantity Default Item Quantity Boolean 4
    createItemFromDescription Create Item from Description Boolean 4
    archiveQuotes Archive Quotes Option 4 Never, Question, Always
    archiveOrders Archive Orders Boolean 4
    archiveBlanketOrders Archive Blanket Orders Boolean 4
    archiveReturnOrders Archive Return Orders Boolean 4
    createItemFromItemNo Create Item from Item No. Boolean 4
    copyCustomerNameToEntries Copy Customer Name to Entries Boolean 4
    ignoreUpdatedAddresses Ignore Updated Addresses Boolean 4
    skipManualReservation Skip Manual Reservation Boolean 4
    disableSearchByName Disable Search by Name Boolean 4
    allowMultiplePostingGroups Allow Multiple Posting Groups Boolean 4
    checkMultiplePostingGroups Check Multiple Posting Groups Option 4 Alternative Groups
    quoteValidityCalculation Quote Validity Calculation DateFormula 32
    sInvoiceTemplateName Sales Invoice Journal Template Code 10
    sCrMemoTemplateName Sales Cr. Memo Journal Template Code 10
    sPrepInvTemplateName Sales Prep. Invoice Template Name Code 10
    sPrepCrMemoTemplateName Sales Prep. Cr. Memo Template Name Code 10
    icSalesInvoiceTemplateName IC Sales Invoice Template Name Code 10
    icSalesCrMemoTemplName IC Sales Cr. Memo Template Name Code 10
    finChargeJnlTemplateName Finance Charge Journal Template Name Code 10
    reminderJournalTemplateName Reminder Journal Template Name Code 10
    reminderJournalBatchName Reminder Journal Batch Name Code 10
    copyLineDescrToGLEntry Copy Line Descr. to G/L Entry Boolean 4
    finChargeJnlBatchName Finance Charge Journal Batch Name Code 10
    canceledIssuedReminderNos Canceled Issued Reminder Nos. Code 20 No. Series
    cancIssFinChMemNos Canceled Issued Fin. Charge Memo Nos. Code 20 No. Series
    writeinProductType Write-in Product Type Option 4 Item, Resource
    writeinProductNo Write-in Product No. Code 20
    autoPostNonInvtViaWhse Auto Post Non-Invt. via Whse. Option 4 None, Attached/Assigned, All
    postedReturnReceiptNos Posted Return Receipt Nos. Code 20 No. Series
    copyCmtsRetOrdToRetRcpt Copy Cmts Ret.Ord. to Ret.Rcpt Boolean 4
    copyCmtsRetOrdToCrMemo Copy Cmts Ret.Ord. to Cr. Memo Boolean 4
    returnOrderNos Return Order Nos. Code 20 No. Series
    returnReceiptOnCreditMemo Return Receipt on Credit Memo Boolean 4
    exactCostReversingMandatory Exact Cost Reversing Mandatory Boolean 4
    priceCalculationMethod Price Calculation Method Option 4 , Lowest Price, Test Price, Test Price (not Implemented)
    priceListNos Price List Nos. Code 20 No. Series
    allowEditingActivePrice Allow Editing Active Price Boolean 4
    defaultPriceListCode Default Price List Code Code 20
    useCustomizedLookup Use Your Custom Lookup Boolean 4
    customerGroupDimensionCode Customer Group Dimension Code Code 20 Dimension
    salespersonDimensionCode Salesperson Dimension Code Code 20 Dimension
    freightGLAccNo Freight G/L Account No. Code 20 G/L Account
    linkDocDateToPostingDate Link Doc. Date to Posting Date Boolean 4
    orders Orders Boolean 4
    klachtnrs Klachtnrs. Code 20 No. Series
    sleutelnrs Key Nos. Code 20 No. Series
    verhuurfactuurnrs Rental Invoice Nos. Code 20 No. Series
    verhuurfactuurnrsGeboekt Rental Invoice Nos. (Posted) Code 20 No. Series
    verhuurcreditnotanrs Rental Credit Memo Nos. Code 20 No. Series
    verhuurcreditnotanrsGeboekt Rental Credit Memos (Posted) Code 20 No. Series
    leegstandsnrs Vacancy Nos. Code 20 No. Series
    leegstandsnrsGeboekt Vacancy Nos. (Posted) Code 20 No. Series
    primaireZoeknaam Primary Search Name Option 4 , Naam, Postcode + Huisnr., Telefoonnr.
    vastePeriodes Vaste periodes Boolean 4
    maandberekening Maandberekening Option 4 30 Dagen, Werkelijk aantal
    deurwaarderdossiernrs Bailiff Dossier Nos. Code 20 No. Series
    betalingsregelingnrs Payment Scheme Nos. Code 20 No. Series
    ihSaanvraagnrs IHS Request Nos. Code 20 No. Series
    namensBeheergeverAfdrukken Print On Behalf Of Administrator Boolean 4
    hurenSpreiden Huren spreiden Boolean 4
    sVafrekeningnrs SC Statement Nos. Code 20 No. Series
    adminKostenberekening Service Charge Calc. Option 4 , Percentage, Amount, Percentage per Element
    pctBedragAdminKosten %/Amount Service Charge Decimal 12
    administratiekosten Service Charge Text 10
    minimumbedragAdminKosten Min. Service Charge Amount Decimal 12
    betalingsconditie Payment Term Code 10 Payment Terms
    ondergrensSVafrfactuur Minimal Amount SC Stat. Invoice Decimal 12
    betalingswijzeOndergrens Payment Method Minimal Amount Code 10 Payment Method
    meterReadingStatementNos Meter Reading Statement Nos. Code 20 No. Series
    clusterGrpTypeSUStatement Cluster Group Type S&&C Statement Code 10 Cluster Group Type
    dailyAllowanceElement Daily Allowance Element Text 10
    vatBusPostingGroupRates VAT Bus. Posting Group Rates Code 20 VAT Business Posting Group
    opslagPctCanonVerkoop Opslag % canonverkoop Decimal 12
    percentageAfkoop Percentage afkoop Decimal 12
    moedercontractnrs Parent Contract Nos. Code 20 No. Series
    verkaanbiedingsnrs Sales Proposal Nos. Code 20 No. Series
    eenheidnrs Realty Object Nos. Code 20 No. Series
    erfpachtelementnr Erfpachtelementnr. Code 10
    terugkoopnrs Repurchase Nos. Code 20 No. Series
    inflatieindexPct Inflation Index % Decimal 12
    standaardbudgetOnderhoud Standaardbudget niet. planm. onderhoud Code 10 G/L Budget Name
    standaardbudgetInkoop Standaardbudget inkoop Code 10 G/L Budget Name
    mutatiebevestigingAlg General Modification Confirmation Boolean 4
    budgetcontroleUit Budgetcontrole uitschakelen Boolean 4
    boekingsgroepLeegstTerugk Posting Group Vacancy Contract (Repurchase) Code 30 VacancyPostingGroupFDN
    factuurtypeTWKmutatie Factuurtype TWK-mutatie Option 4 Geen, Factuur, Factuur + OLA, OLA
    transactiewijzeTWKmutatie Transactiewijze TWK-mutatie Code 20
    factuurtype1eVerhuurnota Factuurtype 1e verhuurnota Option 4 Geen, Factuur, Factuur + OLA, OLA
    transactiewijze1eVerhNota Transactiewijze 1e verhuurnota Code 20
    factuurtypeHandmFactuur Factuurtype handm. factuur Option 4 Geen, Factuur, Factuur + OLA, OLA
    transactiewijzeHandmFactuur Transactiewijze handm. factuur Code 20
    hsElement Rent Addition Element Text 10
    huursElemProlTot Huursubsidie-elementen prolongeren tot Date 4
    standaardbudgetPO Standaardbudget planmatig onderhoud Code 10 G/L Budget Name
    factuurtypeDoorbelasten Factuurtype doorbelasten Option 4 Geen, Factuur, Factuur + OLA, OLA
    transactiewijzeDoorbelasten Transactiewijze doorbelasten Code 20
    maxPctDoorbelastingLeegstand Max. % Charge Vacancy Decimal 12
    ondergrensSVAfrCreditnota Minimal Amount SC Stat. Credit Memo Decimal 12
    methodeOpslagOmschrijving Method Option 4 Kostensoortomschrijving, Vaste omschrijving
    omschrijvingOpslagSV Raise SC Text 50
    blancoBankcodeKlant Blank Bank Code Customer Code 20
    omschrijvingOpslagVT Raise PS Text 50
    beperkingAanmakenInkoopkop Purchase Header Creation Restriction Boolean 4
    minBedragVerhuuraanmaning Min. bedrag verhuuraanmaning Decimal 12
    btWcorrectieDoorbelasting BTW-correctie doorbelasting Boolean 4
    omschrGBpostBTWcorrectie Omschr. GB-post BTW-correctie Text 50
    stdReasonEndPaymArrang Default Reason Payment Scheme Termination Code 20 Termination Code Paymnt.Scheme
    controlesoort Fixture Check Type Option 4 , , , ConstructionPart, Part
    controleGarantiePer Controle Garantie/ZAV + Extern per Option 4 , Cluster, Eenheid, Beide
    budgethouderDagelijksOnderh Budgethouder dagelijks onderhoud Code 50 User Setup
    deurwaarderdossierAanmaken Create Bailiff File Option 4 Nooit, Bij aanmaken aanmaning, Bij verzenden aanmaning
    sleuteladmAutomAanmaken Sleuteladm. autom. aanmaken Boolean 4
    targetRentMethod Target Rent Method Option 4 Dynamisch, Statisch, Puntprijs
    inkoopFiatterenVerplicht Inkooporders fiatteren verplicht Boolean 4
    doFiatterenVerplicht NPO inkooporders fiatteren verplicht Boolean 4
    poFiatterenVerplicht PO inkooporders fiatteren verplicht Boolean 4
    projectFiatterenVerplicht Project inkooporders fiatteren verplicht Boolean 4
    klachtNietMuterenVanStatus Klacht niet muteren van status Option 4 , Ingevoerd, Toestemming aangevraagd, Toestemming, Afwijzing, Afgewezen, Opdracht, Offerte, Opdracht gegund, Onderhoudsdienst, Opdracht gereed, Afgehandeld
    omschrFormaatAanmaning Reminder Description Format Option 4 , <Eenheidnr.>
    bankgegevensCorpAfdrukken Print Bank Account Details Company Boolean 4
    aanmaningsniveauBijwerken Allow Reminder Level Modification Boolean 4
    btwProdGrpDoorbelLeegst VAT Prod. Posting Group Charging Vacancy Code 20 VAT Product Posting Group
    alleenKostensoortpostTBVSV Only Cost Type Entries Boolean 4
    prolongatieposten Only Prolongation Entries Boolean 4
    bedrijfsbgroepLeegstand Vacancy Business Posting Group Code 20 Gen. Business Posting Group
    btwBedrijfsbGroepLeegstand Vacancy VAT Business Posting Group Code 20 VAT Business Posting Group
    warnOnExistingNewContract Warn on Existing New Contract Boolean 4
    reistijd Create Travel Time Line Boolean 4
    herzienAanmBijBetalReg Modify Reminders On Payment Scheme Boolean 4
    commitmentPosting Commitment Posting Boolean 4
    clustersoortTbvOppervlaktes Clustersoort t.b.v. oppervlaktes Code 20 Cluster Type
    surfaceCode Surface Code Code 20 Realty Object Function
    factuurtypeSVfactuur Invoice Type SC Invoice Option 4 Geen, Factuur, Factuur + OLA, OLA
    transactiewijzeSVfactuur Transaction Mode SC Invoice Code 20
    methodeSVfactuur Method SC Invoice Option 4 Overnemen van huurder, Instellingen ingeven
    deleteOfferedContracts Verwijder aanbiedingsregel(s) met aanbieding Option 4 Never, Confirm, Always
    useOldOfferedContracts Gebruik aanwezige aanbiedingsregel(s) bij nieuwe aanbieding Option 4 Always, Confirm, Never
    leegstandscodeVerkocht Vacancy Code 'Sold' Code 30 VacancyPostingGroupFDN
    einddatumHuurvastMuteerbaar Einddatum huurvast muteerbaar Boolean 4
    noOfRoomsM2 No. of rooms (m2) Decimal 12
    verhuurmutatieregister Rent Price Mutation Log Option 4 , Accorderen, Fiatteren, Accorderen en fiatteren
    automatischPostenToevoegen Automatisch posten toevoegen aan deurwaarderdossier Boolean 4
    showDocument Show Document Boolean 4
    locAttachTenantComplaints Location Attachment Complaints Text 250
    locAttachRepairRequests Location Attachments Repair Requests Text 250
    clustersrtVerhElemntSjabln Cluster Type Rental Element Template Code 20 Cluster Type
    correctionJobJournalTempl Correction Job Journal Template Code 10
    correctionJobJournalBatch Correctie Projectdagboekbatch Code 10
    archivePropertyValuation Archive Property Valuation Boolean 4
    showAllElements Toon alle elementen Boolean 4
    vvEnaamCluster VvE-naam overnemen van cluster Boolean 4
    afwcodeBetalingsregeling On Hold Code Payment Scheme Code 3 On Hold Code
    afwcodeDeurwaarderdossier On Hold Code Bailiff Dossier Code 3 On Hold Code
    invCrMemoEntry Inv. / Cr. Memo Entry Option 4 , Entry Form, Donau
    defaultPostGroupEmptyUnit Default Post. Group Empty Unit Code 30 VacancyPostingGroupFDN
    huurtoeslagControleren Huurtoeslag controleren Boolean 4
    huurtoeslagProlongeren Huurtoeslag prolongeren Boolean 4
    datumformuleAfspraakdatum Datumformule afspraakdatum DateFormula 32
    huurbeleid Rent Policy Option 4 Hoogste bedrag, Streefhuur, Elementsjabloon, Huidige huur, Markthuurwaarde
    clustersoortContactbeheer Cluster Type Contact Management Code 20 Cluster Type
    stdActionTenantToDo Default Action To-do Code 10 Livability Action
    sortingTenant Sortering actieregels Option 4 Line Created, Date ascending, Date descending
    stdActieMelding Default Action Call Code 10 Livability Action
    contactpersonenUniek Controle unieke contactpersoon per functie Boolean 4
    functieVerhuurmakelaar Functie verhuurmakelaar Code 10 Job Responsibility
    controleaantalUitgiftedagb Controleaantal uitgiftedagboek Integer 4
    sVafrekeningenFiatteren Approve Boolean 4
    autWaarborgsommenVerrekenen Waarborgsom en rente automatisch verrekenen op eindafrekening Boolean 4
    mutatieproces Change Process Based On Option 4 Opzeggingen, Alle mutaties
    huurbeleidNietBijLeegstand Don't Apply Rent Policy for Vacancy Boolean 4
    teFiatterenMutaties Rent Price Mutations to be Authorized Option 4 Alle, Huurverlaging
    prolTextCodeUnit Text Code Realty Object Code 10 Standard Text
    prolTextCodePeriod Text Code Period Code 10 Standard Text
    prolTextCodeConcerning Text Code Concerns Code 10 Standard Text
    offerteopmNaarArchief Quote Comment in Archive Boolean 4
    orderopmNaarArchief Order Comment to Archive Boolean 4
    gasElektraContrVerplicht Gas/Electricity Check Required Boolean 4
    eindinspectieVerplicht End Inspection Check Required Boolean 4
    oldCalcPropertyValuation Use old property valuation calculation Boolean 4
    checkPaymentDetails Check Payment Details Boolean 4
    vendorNoMaintenanceService Vendor No. Maintenance Service Code 20 Vendor
    renteWaarborgsommen Rente waarborgsommen Option 4 Enkelvoudig, Samengesteld
    paymntSchInclBailiffEntry Paymnt Scheme incl. Bailiff Entries Boolean 4
    contractNos Contract Nos. Code 20 No. Series
    clusterTypeSales Cluster Type Sales Code 20 Cluster Type
    clusterTypeRepurchase Cluster Type Repurchase Code 20 Cluster Type
    purchaseStatusMgt Inkoopstatusdetails Boolean 4
    vatProdPostGrpRaiseColl VAT Prod. Posting Group Raise Collection Cost Code 20 VAT Product Posting Group
    maxAmtCollCost Max. Amount Collection Cost Decimal 12
    minAmtCollCost Min. Amount Collection Cost Decimal 12
    vatProdPostGrpCollCost VAT Prod. Posting Group Collection Cost Code 20 VAT Product Posting Group
    defaultWOZDeviationReason Default WOZ Deviation Reason Code 10 Prop.Val. WOZ Deviation Reason
    systemCreatingBailiffEntry Systematically add Entries to the Bailiff Dossier Option 4 Never, Immediately, If sent
    prolTransitoAllocationCode Transito Allocation Code Code 10 Transito Allocation
    applyStatementResult Apply SC Statement Result Automatically Boolean 4
    clusterTypeOwnerStatement Cluster Type Owner Statement Code 20 Cluster Type
    clusterGrpTypeOwnrStatemnt Cluster Group Type Owner Statement Code 10 Cluster Group Type
    vatProdPostGrpOwnrStatemnt VAT Prod. Posting Group Owner Statement i.c.o. Reverse Charge VAT Code 20 VAT Product Posting Group
    moduleLivabilityProactive Module Livability Proactive Boolean 4
    stdActieContractinformatie Default Action Contract Information Code 10 Livability Action
    stdActieKeuring Default Action Inspection Code 10 Livability Action
    stdActieVeroorzakers Default Action Initiators Code 10 Livability Action
    codeAfhKeuringGoed Code Service Call Settlement 'Good' Code 20 Service Call Settlement Code
    codeAfhKeuringNietGoed Code Service Call Settlement 'Not Good' Code 20 Service Call Settlement Code
    stdDossierstatusActionLine Default Dossier Status Action Line Code 10 Liv. Dossier Status
    locAttachPictures Location Attachments Rep. Req. Pict. Text 250
    pictureMask Afbeeldingsformaat Option 4 jpg, bmp, jpeg
    thumbnailAdd Toevoeging kleine afbeeldingen Text 30
    jobTypeCheckHorizon Job Type Check Horizon DateFormula 32
    restrictedLivDossierAccess Beperkte Leefbaarheidsdossiertoegang Boolean 4
    stdActionRepairRequest Default Action Maintenance Request Code 10 Livability Action
    storageLocationPictures Storage Location Pictures Text 250
    defInspDurRepairMaint Default Inspection Duration Repair Maintenance Duration 8
    mandateNos Mandate Nos. Code 20 No. Series
    balanceAccountNo Balance Account No. Code 20
    sourceCode Source Code Code 10 Source Code
    paymentReferenceNo Payment Reference Nos. Code 20 No. Series
    paymentServiceProvider Payment Service Provider Option 4 AcceptEasy, Postex
    methodChargingInvoice Method Charging Invoice Option 4 SetupManually, CopyFromTenant
    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