Search Results for

    Show / Hide Table of Contents

    Acctivate Code List

    Simple codes are used within the Acctivate database to represent various record types or categories rather than the more user friendly descriptor found in the software.

    The tables below contain the code and the description it represents.

    Note

    These codes may be used in more than one database table and they may use different field names depending on the table.

    Refer to our Database Views Resource Guide for more information about the database views and the data they contain.

    Product Item Type

    The product Item Type code is found in the following database Views ([View].[FieldName]):

    • Product.ItemType
    Code Description
    0 Non inventoried
    1 Inventoried
    2 Drop Ship only
    3 Special Order only
    100 Labor
    101 Other Charges
    102 Shipping

    Product Control Type

    The Product Control Type is found in the following database Views ([View].[FieldName]):

    • CustomerProduct.InventoryControlType
    • INVLotSerialTrace.InventoryControlType
    • InvoiceDetail.InventoryControlType
    • OrderDetail.InventoryControlType
    • PicklistDetail.InventoryControlType
    • Product.InventoryControlType
    • ProductControlType.InventoryControlType
    • ProductExport.InventoryControlType
    Code Description
    S Standard
    L Lot Numbered
    # Serial Numbered
    N Number when invoiced

    Product Bill of Materials

    The Product Bill of Materials is found in the following database Views ([View].[FieldName]):

    • INVTransaction.AssemblyType
    • Product.AssemblyType
    • ProductExport.AssemblyType
    • ShipmentOrderDetail.AssemblyType
    • ShipmentOrderDetailToPack.AssemblyType
    Code Description
    A Assembly
    C Assembly (Custom)
    V Assembly (Process)
    K Kit (Standard)
    B Kit (Custom)
    S Assortment

    Product Cost Method

    The Product Cost Method is found in the following database Views ([View].[FieldName]):

    • INVTransactionDetail.FromCostMethod
    • INVTransactionDetail.ToCostMethod
    • Product.CostMethod
    • ProductCostMethod.CostMethod
    • ProductExport.CostMethod
    Code Description
    A Average
    S Standard
    L LIFO
    F FIFO
    C Actual (Lot/Serial only)
    [Blank] None (Non-inventoried)

    Product Price Type

    The Product Price Type is found in the following database Views ([View].[FieldName]):

    • InvoiceDetail.ListPriceType
    • Product.ListPriceType
    • ProductExport.ListPriceType
    • ProductPrice.PriceType
    Code Description
    P Price
    S% Mgmt Cost + Percent
    S$ Mgmt Cost + Amount
    M% Last Cost + Percent
    M$ Last Cost + Amount
    C% Average Cost + Percent
    C$ Average Cost + Amount
    L% List Price - Percent
    L$ List Price + Amount

    Sales Order Type

    The Sales Order Type is found in the following database Views ([View].[FieldName]):

    • Orders.Type
    • OrdersAvailableToShip.Type
    • ShipmentOrderToPack.Type
    Code Description
    O Order
    C Credit Memo
    Q Quote
    S Service

    Sales Quote Status

    The Sales Quote Status is found in the following database Views ([View].[FieldName]):

    • Orders.OrderStatus
    Code Description
    Q Quote
    R Rejected
    X Canceled

    Sales Order Status

    The Sales Order Status is found in the following database Views ([View].[FieldName]):

    • Orders.OrderStatus
    Code Description
    B Booked
    S Scheduled
    K Backordered
    C Completed
    X Canceled

    Sales Order Origin Type

    The Sales Order Origin Type is found in the following database Views ([View].[FieldName]):

    • Orders.OriginType
    • OrdersAvailableToShip.OriginType
    • ShipmentOrderToPack.OriginType
    Code Description
    M Manually entered
    E EDI
    W Web store
    I Import
    Q From QuickBooks

    Sales and Purchase Detail Line Type

    Sales orders and purchase orders use the same Line Types. This field can be found in the following database Views ([View].[FieldName]):

    • BusinessActivityTimeAndMaterials.LineType
    • CustomerProduct.LineType
    • INVLotSerialTraceDetail.LineType
    • InvoiceDetail.LineType
    • OrderDetail.LineType
    • PODetail.LineType
    • PODetailSimple.LineType
    • POInvoiceDetail.LineType
    • ProductDocumentHistory.LineType
    • ShipmentOrderDetailToPack.LineType
    Code Description
    P Product from inventory (Inventoried and Non-inventoried products)
    N Non-Standard
    C Charge (Other Charge, Shipping, and Labor)
    S Special Order
    D Drop Ship
    * Note

    Sales Order Workflow Status

    The Sales Order Workflow Status is found in the following database Views ([View].[FieldName]):

    • OrderManagementSummary.WorkflowStatus
    • Orders.WorkFlowStatus
    • OrdersAvailableToShip.WorkFlowStatus
    • OrderWorkFlowStatus.WorkFlowStatus
    • PicklistOrder.WorkFlowStatus
    Code Description
    / Cancelled
    B Partially Invoiced
    C Completed
    D Pick Pending
    H Pick on Hold
    I Pick in Progress
    K Packaging
    N Not Ready to Pick
    O Booked
    P Picked
    R Ready to Pick
    S Shipped
    X No Pick Required

    Sales Order Price Code

    The system price codes found in the table below and any user defined price codes can be found in the following database Views ([View].[FieldName]):

    • OrderDetail.PriceCode
    • CustomerProduct.PriceCode
    Code Description
    * List Price
    ! Customer specific price
    – Manual Price override

    Picklist Status

    The Picklist Status is found in the following database Views ([View].[FieldName]):

    • Picklist.PicklistStatus
    Code Description
    O Ready to Pick
    B In Progress (Being Picked)
    H On Hold
    C Picked (Completed)
    P Partially Invoiced
    I Invoiced
    X Cancelled

    Shipment Status

    The Shipment Status is found in the following database Views ([View].[FieldName]):

    • Shipment.ShipmentStatus
    • ShipmentAssociatedOrderDetails.ShipmentStatus
    • ShipmentItem.ShipmentStatus
    • ShipmentOrderDetail.ShipmentStatus
    • ShipmentPicklist.ShipmentStatus
    • ShipmentSummary.ShipmentStatus
    Code Description
    C Created
    P Packaged
    S Shipped
    X Canceled

    Sales Invoice Type

    The Sales Invoice Type is found in the following database Views ([View].[FieldName]):

    • Invoice.Type
    Code Description
    O Order
    C Credit Memo
    S Service
    R Voided

    Customer Payment Invoice Link Type

    The Customer Payment Link Type is used to identify the type of link between a customer's payment or refund record and an accounts receivable record. The Link Type is found in the following database Views ([View].[FieldName]):

    • CustomerPaymentInvoice.LinkType
    Code Description
    P Payment
    C Credit
    D Deposit
    F Credit card refund
    J General Journal
    K Non-credit card refund
    S Statement Charge
    X A credit memo can be refunded to a customer as a payment, e.g., a -100 refund check may be issued for a -100 credit memo. The "X" link type is used to reverse the refund amount to a positive amount so that it can be applied to the credit memo.

    Purchase Order Type

    The Purchase Order Type is found in the following database Views ([View].[FieldName]):

    • PO.Type
    • PODetail.POType
    Code Description
    D Drop Ship
    S Standard PO
    P Special Order

    Purchase Order Status

    The Purchase Order Status is found in the following database Views ([View].[FieldName]):

    • PO.POStatus
    • PODetail.POStatus
    Code Description
    E Entered
    Q Request for Quote
    A Pending approval
    I Issued
    C Completed
    X Canceled

    Inventory Session Type

    The Inventory Session Type is found in the following database Views ([View].[FieldName]):

    • INVRegister.Source
    • InventoryJournal.SessionType
    • InventoryJournalDetail.SessionType
    • INVTransaction.DocumentType
    Code Description
    A Adjustment
    I Issue
    L Landed Cost
    N Count
    P Assembly
    R Receipt
    S Sale
    V Balance Adjustment
    X Transfer

    Inventory Transaction Detail Types

    The Inventory Transaction Type is found in the following database Views ([View].[FieldName]):

    • INVLotSerialTraceDetail.RecordType
    • INVTransactionDetail.TransactionType
    Code Description
    A Adjustment
    C Assembly (Component)
    G COGS Adj (Legacy)
    I Issue
    L Landed Cost
    M Cost Method change (Legacy, no longer used)
    N Count adjustment
    P Assembly (Finished Goods)
    R Receipt
    S Sale
    V Balance Adjustment
    X Transfer
    Z FIFO/LIFO Adj (Legacy)

    Business Activity Related Item

    The Business Activity related item code is found in the following database Views ([View].[FieldName]):

    • BusinessActivityRelatedItems.XrefType
    • IssueXref.RelatedItem (legacy)
    Code Description
    # Lot/Serial Number
    C Customer
    CL Customer Ship-To Location
    I Business Activity
    INV Inventory Transaction
    IT Track and Trace session
    L External Link
    P Product
    O Credit Memo, Sales Order, Sales Quote, Service Order
    PO Purchase Order
    V Vendor
    X Other Contact

    Note Type

    The Note Type is used to identify which document a note or email is linked to. The Note Type is found in the following database Views ([View].[FieldName]):

    • Notes.NoteType
    Code Description
    A Customer Account
    C Customer Credit
    I Product
    L Customer Ship
    N Customer Invoice/Credit
    O Sales Order
    P Purchase Order
    S Business Activity
    T Track & Trace

    Document Type

    The Document Type refers to the type of note; e.g., an email or note. The Document Type is found in the following database Views ([View].[FieldName]):

    • Notes.DocType
    Code Description
    E Email attached to a document
    N Note

    Attachment Link Type

    File attachments are stored in the Document view and the type of record they are attached to is identified by the Link Type. The Link Type is found in the following database Views ([View].[FieldName]):

    • Document.LinkType
    Code Description
    E Attachment linked to an Email
    N Attachment linked to a Note

    Salesperson Link Type

    The Salesperson Link Type is used to identify which type of record the salesperson is linked to. It can be found in the following database Views ([View].[FieldName]):

    • SalespersonInfo.LinkType
    Code Description
    E Employee
    O Other Name
    V Vendor
    In This Article
    Back to top © 2023 Alterity, Inc. All rights reserved