Approval Entry

    API Details

    Property Value
    Endpoint /tablesFinance/approvalEntriesArchive
    Table name Approval Entry Archive
    Table id 11151818
    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
    lastModifiedByID Last Modified By ID Code 50 User
    dueDate 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
    entryNo ENtry No. Integer 4 *
    versionNo Version No. Integer 4
    docNoOccurrence Doc. No. Occurrence Integer 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
    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