Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| POSPRODUCT_ID | int | 4 | √ | null |
|
|
Product ID |
||||||||||||||||||||||||||||
| PRODUCT_NAME | varchar | 100 | √ | null |
|
|
Product name |
||||||||||||||||||||||||||||
| PRODUCT_TYPE | varchar | 20 | √ | null |
|
|
Product type (Standard POS Product / Activity Drop In) |
||||||||||||||||||||||||||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
Activity ID if product type is ‘Activity Drop In’ |
||||||||||||||||||||||||||||
| PRODUCT_DESCRIPTION | varchar | 100 | √ | null |
|
|
Product description |
||||||||||||||||||||||||||||
| IMAGE_FILE_ID | int | 4 | √ | null |
|
|
The file ID for the product image |
||||||||||||||||||||||||||||
| IMAGE_FILE_NAME | varchar | 50 | √ | null |
|
|
The file name for the product image |
||||||||||||||||||||||||||||
| UPC | varchar | 30 | √ | null |
|
|
Product UPC code |
||||||||||||||||||||||||||||
| PRODUCT_DEPARTMENT_ID | int | 4 | √ | null |
|
|
The ID of the department to which this product belongs |
||||||||||||||||||||||||||||
| PRODUCT_DEPARTMENT | varchar | 50 | √ | null |
|
|
The name of the department to which this product belongs |
||||||||||||||||||||||||||||
| PRODUCT_CLASS_ID | int | 4 | √ | null |
|
|
The ID of the class category to which this product belongs |
||||||||||||||||||||||||||||
| PRODUCT_CLASS | varchar | 50 | √ | null |
|
|
The name of the class category to which this product belongs |
||||||||||||||||||||||||||||
| PRODUCT_SUBCLASS_ID | int | 4 | √ | null |
|
|
The ID of the subclass category to which this product belongs |
||||||||||||||||||||||||||||
| PRODUCT_SUBCLASS | varchar | 50 | √ | null |
|
|
The name of the subclass category to which this product belongs |
||||||||||||||||||||||||||||
| FEE_AMOUNT | money | 21,4 | √ | null |
|
|
Product price amount |
||||||||||||||||||||||||||||
| DEFAULT_QUANTITY | int | 4 | √ | null |
|
|
Default sale quantity |
||||||||||||||||||||||||||||
| USE_INDIVIDUAL_PRICE | varchar | 5 | √ | null |
|
|
Whether the product’s individual price should be used when included in a bundle (Yes/No) |
||||||||||||||||||||||||||||
| ALLOW_INDIVIDUAL_SALE | varchar | 5 | √ | null |
|
|
Whether the product may be sold individually rather than included in a bundle (Yes/No) |
||||||||||||||||||||||||||||
| IS_FREE_PROMOTIONAL_ITEM | varchar | 5 | √ | null |
|
|
Whether this product is a free promotional item (Yes/No) |
||||||||||||||||||||||||||||
| EXCLUDE_FROM_PAYMENT_PLAN | varchar | 5 | √ | null |
|
|
Whether the fee amount for this product should be excluded from any payment plan (Yes/No) |
||||||||||||||||||||||||||||
| TAXABLE_BY_TAX_1 | varchar | 5 | √ | null |
|
|
Whether tax 1 applies to this product (Yes/No) |
||||||||||||||||||||||||||||
| TAXABLE_BY_TAX_2 | varchar | 5 | √ | null |
|
|
Whether tax 2 applies to this product (Yes/No) |
||||||||||||||||||||||||||||
| TAXABLE_BY_TAX_3 | varchar | 5 | √ | null |
|
|
Whether tax 3 applies to this product (Yes/No) |
||||||||||||||||||||||||||||
| TAXABLE_BY_TAX_4 | varchar | 5 | √ | null |
|
|
Whether tax 4 applies to this product (Yes/No) |
||||||||||||||||||||||||||||
| TAXABLE_BY_TAX_5 | varchar | 5 | √ | null |
|
|
Whether tax 5 applies to this product (Yes/No) |
||||||||||||||||||||||||||||
| TAXABLE_BY_TAX_6 | varchar | 5 | √ | null |
|
|
Whether tax 6 applies to this product (Yes/No) |
||||||||||||||||||||||||||||
| TAXABLE_BY_TAX_7 | varchar | 5 | √ | null |
|
|
Whether tax 7 applies to this product (Yes/No) |
||||||||||||||||||||||||||||
| TAXABLE_BY_TAX_8 | varchar | 5 | √ | null |
|
|
Whether tax 8 applies to this product (Yes/No) |
||||||||||||||||||||||||||||
| PROMPT_FOR_PRICE | varchar | 5 | √ | null |
|
|
Whether the user should be prompted to enter the price of this product (Yes/No) |
||||||||||||||||||||||||||||
| LOG_USAGE | varchar | 5 | √ | null |
|
|
Whether the sale of this product should be logged (Yes/No) |
||||||||||||||||||||||||||||
| NO_RECEIPT | varchar | 5 | √ | null |
|
|
Whether generation of a receipt should be skipped for this product (Yes/No) |
||||||||||||||||||||||||||||
| DISCLAIMER_ID | int | 4 | √ | null |
|
|
Product disclaimer ID |
||||||||||||||||||||||||||||
| DISCLAIMER_NAME | varchar | 30 | √ | null |
|
|
System account package name for the product. |
||||||||||||||||||||||||||||
| IS_DISCOUNTABLE | varchar | 5 | √ | null |
|
|
Whether the fee amount for this product can be discounted (Yes/No) |
||||||||||||||||||||||||||||
| SITE_ID | int | 4 | √ | null |
|
|
The ID of the site that the product belongs to |
||||||||||||||||||||||||||||
| SITE_NAME | varchar | 255 | √ | null |
|
|
The name of the site that the product belongs to |
||||||||||||||||||||||||||||
| IS_RETIRED | varchar | 5 | √ | null |
|
|
Whether this product has been retired from use (Yes/No) |
||||||||||||||||||||||||||||
| IS_DISCOUNT | varchar | 5 | √ | null |
|
|
Whether this product is a discount (Yes/No) |
||||||||||||||||||||||||||||
| DISCOUNT_TYPE | varchar | 10 | √ | null |
|
|
The type of discount (Amount / Percent) |
||||||||||||||||||||||||||||
| DISCOUNT_PERCENT | money | 21,4 | √ | null |
|
|
The default discount percentage |
||||||||||||||||||||||||||||
| DISCOUNT_COUPON_CODE | varchar | 10 | √ | null |
|
|
The coupon code to enter to activate this discount |
||||||||||||||||||||||||||||
| DISCOUNT_ALLOWS_MULTIPLE_USE_PER_CUSTOMER | varchar | 5 | √ | null |
|
|
Whether this discount can be claimed multiple times by the same customer (Yes/No) |
||||||||||||||||||||||||||||
| DISCOUNT_START_DATE | date | 20 | √ | null |
|
|
The first date for when this discount may be used |
||||||||||||||||||||||||||||
| DISCOUNT_END_DATE | date | 20 | √ | null |
|
|
The last date for when this discount may be used |
||||||||||||||||||||||||||||
| GLACCOUNT_ID | int | 4 | √ | null |
|
|
The ID of the GL Account that the product fee amount will be posted to |
||||||||||||||||||||||||||||
| GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
The name of the GL Account that the product fee amount will be posted to |
||||||||||||||||||||||||||||
| GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
The number of the GL Account that the product fee amount will be posted to |
||||||||||||||||||||||||||||
| SYSTEM_GL_ACCOUNT_PACKAGE_ID | int | 4 | √ | null |
|
|
System account package ID for the product |
||||||||||||||||||||||||||||
| SYSTEM_GL_ACCOUNT_PACKAGE_NAME | varchar | 50 | √ | null |
|
|
System account package name for the product. |
||||||||||||||||||||||||||||
| FEATURE_NAME_1 | varchar | 100 | √ | null |
|
|
Feature 1 name to be displayed during sale of this product |
||||||||||||||||||||||||||||
| FEATURE_LIST_1 | varchar | 500 | √ | null |
|
|
Feature 1 options to be selected during sale of this product |
||||||||||||||||||||||||||||
| FEATURE_NAME_2 | varchar | 100 | √ | null |
|
|
Feature 2 name to be displayed during sale of this product |
||||||||||||||||||||||||||||
| FEATURE_LIST_2 | varchar | 500 | √ | null |
|
|
Feature 2 options to be selected during sale of this product |
||||||||||||||||||||||||||||
| TRACK_INVENTORY | varchar | 5 | √ | null |
|
|
Whether inventory should be tracked for this product (Yes/No) |
||||||||||||||||||||||||||||
| TRACK_INVENTORY_BY_CENTER | varchar | 5 | √ | null |
|
|
Whether inventory should be tracked per center for this product (Yes/No) |
||||||||||||||||||||||||||||
| QUANTITY_ON_HAND | int | 4 | √ | null |
|
|
Quantity on hand for this product |
||||||||||||||||||||||||||||
| REORDER_POINT | int | 4 | √ | null |
|
|
Reorder point for this product |
||||||||||||||||||||||||||||
| REORDER_ALERT_EMAIL | varchar | 100 | √ | null |
|
|
Reorder alert email address to be notified when the quantity on hand falls below the reorder point for this product |
||||||||||||||||||||||||||||
| LAST_RECEIVED_QUANTITY | int | 4 | √ | null |
|
|
The quantity of this product received in the last order |
||||||||||||||||||||||||||||
| LAST_PURCHASE_PRICE | money | 21,4 | √ | null |
|
|
The price paid for this product in the last order |
||||||||||||||||||||||||||||
| LAST_RECEIVED_DATE | date | 20 | √ | null |
|
|
The date the last order of this product was received |
||||||||||||||||||||||||||||
| LAST_VENDOR_COMPANY_ID | int | 4 | √ | null |
|
|
The company ID of the vendor for this product |
||||||||||||||||||||||||||||
| LAST_VENDOR_COMPANY_NAME | varchar | 255 | √ | null |
|
|
The company name of the vendor for this product |
||||||||||||||||||||||||||||
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||||||||||||||||||||||||||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
Date and time Hub record was last modified |
|||||||||||||||||||||||||||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The Hub sync process ID |
||||||||||||||||||||||||||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |