SC Statement Line

    API Details

    Property Value
    Endpoint /tablesFinance/scStatementLines
    Table name SC Statement Line
    Table id 11030050
    Table caption SC Statement Line
    Data per company True
    Group Finance

    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
    nr No. Code 20 * SC Statement Header
    soort Type Option 4 * , Service, Usage, Water, Individual
    elementnr Element No. Text 10 *
    costCode Cost Code Text 10 *
    bedrag Amount Decimal 12
    btWbedrag VAT Amount Decimal 12
    ingangsdatumHuurperiode Start Date Rent Period Date 4
    einddatumHuurperiode End Date Rent Period Date 4
    genProdPostingGroup Gen. Prod. Posting Group Code 20 Gen. Product Posting Group
    vatProdPostingGroup VAT Prod. Posting Group Code 20 VAT Product Posting Group
    afrekeningsbatchnaam Settlement Batch Name Code 30
    clusternr Cluster No. Code 20 Cluster
    nieuwVoorschot New Advance Decimal 12
    eenheidnr Object No. Code 20 OGE
    originalStatementNo Original Statement 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