Approval Entry

    API Details

    Property Value
    Endpoint /tablesFinance/approvalEntries
    Table name Approval Entry
    Table id 454
    Table caption Approval 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
    tableID Table ID Integer 4
    documentType Document Type Option 4 Quote, Order, Invoice, Credit Memo, Blanket Order, Return Order, , Payment
    documentNo Document No. Code 20
    sequenceNo Sequence No. Integer 4
    approvalCode Approval Code Code 20
    senderID Sender ID Code 50 User
    salespersPurchCode Salespers./Purch. Code Code 20
    approverID Approver ID Code 50 User
    status Status Option 4 Created, Open, Canceled, Rejected, Approved,
    dateTimeSentForApproval Date-Time Sent for Approval DateTime 8
    lastDateTimeModified Last Date-Time Modified DateTime 8
    lastModifiedByUserID Last Modified By User ID Code 50 User
    dueDate Approval Due Date Date 4
    amount Amount Decimal 12
    amountLCY Amount (LCY) Decimal 12
    currencyCode Currency Code Code 10 Currency
    approvalType Approval Type Option 4 Workflow User Group, Sales Pers./Purchaser, Approver, Specific, Project, Order, Manual, System
    limitType Limit Type Option 4 Approval Limits, Credit Limits, Request Limits, No Limits
    availableCreditLimitLCY Available Credit Limit (LCY) Decimal 12
    recordIDToApprove Record ID to Approve RecordID 448
    delegationDateFormula Delegation Date Formula DateFormula 32
    entryNo Entry No. Integer 4 *
    workflowStepInstanceID Workflow Step Instance ID GUID 16
    billtoPaytoNo Bill-to/Pay-to No. Code 20
    postingDescription Posting Description Text 100
    externalDocumentNo External Document No. Code 35
    checkAutoApprove Check Auto Approve Boolean 4
    approvedBy Approved By Code 50 User
    originalApproverCode Original Approver Code Code 50 User
    approvalLimit Amount Approval Limit Decimal 12
    approvalLevel Approval Level Integer 4
    unlimitedApproval Unlimited Approval Boolean 4
    sufficientLimit Sufficient Limit Boolean 4
    invoiceTypePurchase Invoice Type (Purchase) Option 4 , Maintenance, , Settlement, , , , , , , , , , , , , , , , Repurchase
    projectsoort Projectsoort Option 4 Project, Planmatig, Niet-planmatig, Standard
    approvalReason Approval Reason Text 250
    companyName Company Name Text 80
    autoApprove Auto Approve When Procuration is OK. Boolean 4
    orderMatchApproval Order Match Approval Boolean 4
    randomVendorCheck Random Vendor Check Boolean 4
    onHold On Hold Boolean 4
    maintOrderCommitment Maint. Order Commitment Decimal 12
    createdFromDailyMaintenance Created From Daily Maintenance Boolean 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