Subsidie Header

    API Details

    Property Value
    Endpoint /tablesRealEstate/subsidyHeaders
    Table name Subsidiekop
    Table id 11030482
    Table caption Subsidie Header
    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 *
    buyfromVendorNo Buy-from Vendor No. Code 20 Vendor
    paytoVendorNo Pay-to Vendor No. Code 20 Vendor
    paytoName Pay-to Name Text 100
    paytoName2 Pay-to Name 2 Text 50
    paytoAddress Pay-to Address Text 100
    paytoAddress2 Pay-to Address 2 Text 50
    paytoCity Pay-to City Text 30
    paytoContact Pay-to Contact Text 30
    yourReference Your Reference Text 30
    noPrinted No. Printed Integer 4
    reasonCode Reason Code Code 10 Reason Code
    buyfromVendorName Buy-from Vendor Name Text 100
    buyfromVendorName2 Buy-from Vendor Name 2 Text 50
    buyfromAddress Buy-from Address Text 100
    buyfromAddress2 Buy-from Address 2 Text 50
    buyfromCity Buy-from City Text 30
    buyfromContact Buy-from Contact Text 30
    paytoPostCode Pay-to Post Code Code 20
    paytoCounty Pay-to County Text 30
    paytoCountryCode Pay-to Country Code Code 10 Country/Region
    buyfromPostCode Buy-from Post Code Code 20
    buyfromCounty Buy-from County Text 30
    buyfromCountryCode Buy-from Country Code Code 10 Country/Region
    noSeries No. Series Code 20 No. Series
    buyfromContactNo Buy-from Contact No. Code 20 Contact
    paytoContactNo Pay-to Contact No. Code 20 Contact
    responsibilityCenter Responsibility Center Code 10 Responsibility Center
    empireProjectnr Job No. Code 20 Empire Project
    empireProjecttype Job Type Code 20 Empire Projecttype
    empireNoEmailSent No. E-mail Sent Integer 4
    empireDateEmailSent Date E-mail Sent Date 4
    empireTimeEmailSent Time E-mail Sent Time 4
    empireIngevoerdDoor Inserted By Code 50
    empireWerksoort Work Type Code 20 Empire Werksoort
    empireBudgetregelnr Budget Line No. Integer 4
    empireBudgetdetailregelnr Budget Detail Line No. Integer 4
    empireWerksoortboekingsgroep Work Type Posting Group Code 10 Werksoortboekingsgroep
    empireOmschrijving Description Text 30
    empireDatumAanvraag Date Request Date 4
    empireDatumToewijzenVoor Date Allocate For Date 4
    empireStartdatumWerk Start Date Work Date 4
    empireOpleverdatumWerk Produce Date Work Date 4
    empireSubsidienrInstantie Subsidy No. Office Code 20
    empireStatus Status Option 4 , Ingediend, Bevestiging, Afgewezen, Toegewezen, Geboekt
    empireDatumStatusWijziging Change Date Status Date 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