Commitment View Entry

    API Details

    Property Value
    Endpoint /tablesFinance/commitmentViewEntries
    Table name Commitment View Entry
    Table id 11024403
    Table caption Commitment View Entry
    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
    entryNo Entry No. Integer 4 *
    glAccountNo G/L Account No. Code 20 G/L Account
    type Type Option 4 , Onderhoud, Prolongatie, Afrekening, Project, Planmatig, , , , , , , , , , , , , Verkoop, Terugkoop
    documentType Document Type Option 4 Quote, Order, Invoice, Credit Memo, Blanket Order, Return Order, , , , , Maintenance Order
    documentNo Document No. Code 20
    postingDate Posting Date Date 4
    buyfromVendorNo Buy-from Vendor No. Code 20 Vendor
    buyfromVendorName Buy-from Vendor Name Text 100
    vendorDocumentNo Vendor Document No. Code 35
    description Description Text 100
    amount Amount Decimal 12
    amountVAT Amount VAT Decimal 12
    amountIncludingVAT Amount Including VAT Decimal 12
    vatProdPostingGroup VAT Prod. Posting Group Code 20 VAT Product Posting Group
    shortcutDimension1Code Shortcut Dimension 1 Code Code 20
    shortcutDimension2Code Shortcut Dimension 2 Code Code 20
    shortcutDimension3Code Shortcut Dimension 3 Code Code 20
    shortcutDimension4Code Shortcut Dimension 4 Code Code 20
    shortcutDimension5Code Shortcut Dimension 5 Code Code 20
    shortcutDimension6Code Shortcut Dimension 6 Code Code 20
    shortcutDimension7Code Shortcut Dimension 7 Code Code 20
    shortcutDimension8Code Shortcut Dimension 8 Code Code 20
    postingStatus Posting Status Option 4 Unposted, Commitment Posted
    status Status Option 4 Open, Released, Pending Approval, Pending Prepayment
    expectedInvoiceDate Expected Invoice Date Date 4
    commitmentAmountLCY Commitment Amount (LCY) Decimal 12
    empireJobNo Project No. Code 20 Empire Project
    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