Prol. Document

    API Details

    Property Value
    Endpoint /tablesHousing/prolHeaders
    Table name Prol Header
    Table id 11024146
    Table caption Prol. Document
    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
    documentType Document Type Option 4 Quote, Order, Invoice, Credit Memo, Blanket Order, Return Order
    selltoCustomerNo Customer No. Code 20 Customer
    no No. Code 20 *
    billtoCustomerNo Bill-to Customer No. Code 20 Customer
    billtoName Bill-to Name Text 100
    billtoName2 Bill-to Name 2 Text 50
    billtoAddress Bill-to Address Text 100
    billtoAddress2 Bill-to Address 2 Text 50
    billtoCity Bill-to City Text 30
    billtoContact Bill-to Contact Text 100
    yourReference Your Reference Text 30
    postingDate Posting Date Date 4
    postingDescription Posting Description Text 50
    paymentTermsCode Payment Terms Code Code 10 Payment Terms
    dueDate Due Date Date 4
    paymentDiscountPct Payment Discount % Decimal 12
    pmtDiscountDate Pmt. Discount Date Date 4
    shortcutDimension1Code Shortcut Dimension 1 Code Code 20
    shortcutDimension2Code Shortcut Dimension 2 Code Code 20
    customerPostingGroup Customer Posting Group Code 20 Customer Posting Group
    languageCode Language Code Code 10 Language
    salespersonCode Salesperson Code Code 20 Salesperson/Purchaser
    noPrinted No. Printed Integer 4
    onHold On Hold Code 3 On Hold Code
    appliestoDocType Applies-to Doc. Type Option 4 , Payment, Invoice, Credit Memo, Finance Charge Memo, Reminder, Refund, Storno, Arrangement, Arrangement Term
    appliestoDocNo Applies-to Doc. No. Code 20
    balAccountNo Bal. Account No. Code 20
    invoice Invoice Boolean 4
    postingNo Posting No. Code 20
    lastPostingNo Last Posting No. Code 20
    vatRegistrationNo VAT Registration No. Text 20
    combineShipments Combine Shipments Boolean 4
    reasonCode Reason Code Code 10 Reason Code
    genBusPostingGroup Gen. Bus. Posting Group Code 20 Gen. Business Posting Group
    selltoCustomerName Sell-to Customer Name Text 100
    selltoCustomerName2 Sell-to Customer Name 2 Text 50
    selltoAddress Sell-to Address Text 100
    selltoAddress2 Sell-to Address 2 Text 50
    selltoCity Sell-to City Text 30
    selltoContact Sell-to Contact Text 100
    billtoPostCode Bill-to Post Code Code 20 Post Code
    billtoCounty Bill-to County Text 30
    billtoCountryCode Bill-to Country Code Code 10 Country/Region
    selltoPostCode Sell-to Post Code Code 20 Post Code
    selltoCounty Sell-to County Text 30
    selltoCountryCode Sell-to Country Code Code 10 Country/Region
    balAccountType Bal. Account Type Option 4 G/L Account, Bank Account
    correction Correction Boolean 4
    documentDate Document Date Date 4
    externalDocumentNo External Document No. Code 35
    paymentMethodCode Payment Method Code Code 10 Payment Method
    noSeries No. Series Code 20 No. Series
    postingNoSeries Posting No. Series Code 10 No. Series
    vatBusPostingGroup VAT Bus. Posting Group Code 20 VAT Business Posting Group
    appliestoID Applies-to ID Code 20
    sendICDocument Send IC Document Boolean 4
    icStatus IC Status Option 4 New, Pending, Sent
    selltoICPartnerCode Sell-to IC Partner Code Code 20 IC Partner
    billtoICPartnerCode Bill-to IC Partner Code Code 20 IC Partner
    icDirection IC Direction Option 4 Outgoing, Incoming
    dimensionSetID Dimension Set ID Integer 4 Dimension Set Entry
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    factuurtype Invoice Type Option 4 None, Invoice, Invoice + OLA, OLA
    leegstandsboekingsgroep Vacancy Posting Group Code 10 VacancyPostingGroupFDN
    eenheidnr Realty Object No. Code 20 OGE
    contractvolgnr Contract Line No. Integer 4
    prolongatierunnr Prolongation Run No. Integer 4
    vereffeningBinnenProlongatie Applies-to within Prolongation Boolean 4
    naam3 Name 3 Text 30
    naam4 Name 4 Text 30
    factuurnaam3 Invoice Name 3 Text 30
    factuurnaam4 Invoice Name 4 Text 30
    batchboeken Batch Posting Boolean 4
    renteBerekenenTot Calculatie Interest until Date 4
    clusternr Cluster No. Code 20 Cluster
    weigeringsbedrag Amount Refused Decimal 12
    eersteFactuur First Invoice Boolean 4
    soortContract Invoice Option Option 4 , Huur, Erfpacht, , Onderh.tlv huurder, Onderh.tlv derden, 1e verhuurnota
    backdatedCorrection Backdated Correction Boolean 4
    verkoopregelAanwezig Sales line present Boolean 4
    paymentInfoUpdate Update Payment Info Boolean 4
    paymentInfoPresent Payment Info Present Boolean 4
    transactionModeCode Transaction Mode Code Code 20
    bankAccountCode Bank Account Code Code 20
    sortingID Sorting ID Code 20
    postingStatus Posting Status Option 4 Unposted, Posted, Error
    juridicalContractNo Juridical Contract No. Code 20
    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