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 |