~ ClassTypeID | ~ Object Type | ~ System Data | ~ Database Table |
-1 | No Class Type | | |
100 | Action | Yes | |
200 | Navigation Item | Yes | |
300 | Unit | Yes | |
350 | Title | | sql_structure_-_element_table |
360 | System Data | | |
400 | Printer Device Type | | |
500 | System Image | Yes | |
610 | Explorer Query | | |
700 | Store Constant | | sql_structure_-_storeconstant_table |
701 | Store Constant Category | | sql_structure_-_element_table |
800 | Virtual Query | Yes | SQL Structure - SystemData Table |
801 | SQL Function | | |
850 | Generic Template | | |
900 | Web Browser | | |
1000 | Store | | sql_structure_-_store_table |
1100 | Option | | sql_structure_-_useroption_table |
1101 | System Option | | sql_structure_-_useroption_table |
1301 | Commission Rate | | sql_structure_-_commissionrate_table |
1500 | Pricing Graphic | | sql_structure_-_pricinggraphic_table |
1501 | System Graphic | | |
1502 | Graphic | | sql_structure_-_graphic_table |
1503 | Payment Account Graphic | | |
1600 | Selection List Category | | sql_structure_-_pricingelement_table |
1601 | Selection List | | sql_structure_-_selectionlist_table |
1602 | Selection List Item | | sql_structure_-_selectionlistitem_table |
1750 | Activity Pick List | | sql_structure_-_element_table |
1751 | Activity Pick List Item | | sql_structure_-_element_table |
1760 | Calendar Link | | sql_structure_-_calendarlink_table |
1770 | Calendar View | | |
1780 | Calendar Status | | sql_structure_-_calendarstatus_table |
1800 | Activity Time Span | | sql_structure_-_activitytimespan_table |
1810 | Signature Usage Type | | sql_structure_-_element_table |
1811 | Signature Activity | | |
2000 | Company | | sql_structure_-_account_table |
2001 | Company UDF Value | | |
2100 | Vendor | | |
2500 | Service Contract Type | | sql_structure_-_servicecontracttype_table |
2600 | Service Ticket Type | | sql_structure_-_element_table |
2700 | Service Ticket Priority | | sql_structure_-_serviceticketpriority_table |
3000 | Company Contact | | sql_structure_-_accountcontact_table |
3400 | Employee Group | | sql_structure_-_employeegroup_table |
3500 | Employee | | sql_structure_-_employee_table |
3501 | Employee Contact | | sql_structure_-_employeecontact_table |
4000 | Address Type | | sql_structure_-_element_table |
4001 | Address | | sql_structure_-_address_table |
4002 | Address Link | | sql_structure_-_addresslink_table |
4100 | Phone Number | | sql_structure_-_phonenumber_table |
4101 | Phone Number Type | | sql_structure_-_element_table |
5000 | Tax Class | | sql_structure_-_taxclass_table |
5002 | Tax Link | | sql_structure_-_taxlink_table |
5003 | Postal Code Tax Class | | sql_structure_-_postalcodetaxclass_table |
5004 | Postal Code Tax Class List | | sql_structure_-_element_table |
5005 | Product Taxability Code | | sql_structure_-_producttaxabilitycode_table |
5006 | State Tax Exempt Link | | |
5500 | Marking List | | sql_structure_-_element_table |
5501 | Marking List Item | | sql_structure_-_marketinglistitem_table |
5511 | Prospect (Company) Stage | | sql_structure_-_element_table |
5512 | Client (Company) Stage | | sql_structure_-_element_table |
5600 | Disposition List | | sql_structure_-_element_table |
5601 | Disposition | | sql_structure_-_element_table |
6000 | User | | sql_structure_-_username_table |
6002 | Security Right | | |
6003 | Security Link | | SQL Structure - SecurityLink Table |
6004 | Security Right Action | | |
6005 | Lock Time Out | | |
6006 | WebPro Security Right Action | | |
6010 | Security Right Template | | sql_structure_-_element_table |
6020 | Security Right Change | | sql_structure_-_securityrightchange_table |
6030 | Partial Security Right Template | | |
6040 | Partial Security Right | | |
6050 | WebPro Security Right Template | | sql_structure_-_element_table |
6060 | WebPro Security Right | | |
6070 | WebPro Security Right Change | | |
6130 | Shipping Methods | | sql_structure_-_element_table |
7000 | Spped Note | | sql_structure_-_speednote_table |
7100 | PO Speed Note | | sql_structure_-_speednote_table |
7500 | Standard Pricing Formula | | sql_structure_-_speednote_table |
8000 | GL Account Group | | sql_structure_-_glaccount_table |
8001 | GL Account Item | | sql_structure_-_glaccount_table |
8002 | Payment Method | | sql_structure_-_paymentaccount_table |
8050 | Computed Account Group? | | sql_structure_-_glaccount_table |
8051 | Computed Cost Account? | | sql_structure_-_glaccount_table |
8055 | Computed Cost Account? | | sql_structure_-_glaccount_table |
8100 | Bill Payment Method | | sql_structure_-_paymentaccount_table |
8900 | GL Entry | | sql_structure_-_gl_table |
8901 | Inventory Log | | SQL Structure - Depricated? Table| |
8911 | Daily Closeout | | sql_structure_-_journal_table, sql_structure_-_closeout_table |
8912 | Monthly Closeout | | sql_structure_-_journal_table, sql_structure_-_closeout_table |
8913 | Yearly Closeout | | sql_structure_-_journal_table, sql_structure_-_closeout_table |
8914 | Export Closeout | | sql_structure_-_journal_table, sql_structure_-_closeout_table |
8915 | Royalty Closeout | | sql_structure_-_journal_table, sql_structure_-_closeout_table |
8916 | CC Settlement | | sql_structure_-_journal_table, sql_structure_-_closeout_table |
8917 | Weekly Closeout | | sql_structure_-_journal_table, sql_structure_-_closeout_table |
8918 | Quarterly Closeout | | sql_structure_-_journal_table, sql_structure_-_closeout_table |
8919 | Session Closeout | | sql_structure_-_journal_table, sql_structure_-_closeout_table |
8951 | Element | | |
9000 | Contact Manager | | |
9201 | Recurring Activity | | sql_structure_-_recurringactivity_table |
9202 | Recurring Macro Activity | | sql_structure_-_recurringactivity_table |
9750 | Account Reconciliation | | sql_structure_-_journal_table |
10000 | Order/Estimate/Template/Service Tickets | | sql_structure_-_transheader_table |
10001 | Order/Estimate/Template/Service Tickets History | | sql_structure_-_transheaderhistory_table |
10100 | Transaction Detail | | sql_structure_-_transdetail_table |
10101 | Transaction Detail History | | SQL Structure - TransDetailHistory Table |
10200 | Transaction Modifier | | sql_structure_-_transmod_table |
10201 | Transaction Modifier History | | SQL Structure - TransModHistory Table |
10300 | Transaction Part | | sql_structure_-_transpart_table |
10301 | Transaction Part History | | SQL Structure - TransPartHistory Table |
10400 | Transaction Variation | | sql_structure_-_transvariation_table |
10401 | Transaction Variation History | | sql_structure_-_transvariationhistory_table |
10500 | Transaction Tax | | sql_structure_-_transtax_table |
10501 | Transaction Tax History | | SQL Structure - TransTaxHistory Table |
10600 | Transaction Detail Graphic | | sql_structure_-_transdetailgraphic_table |
10601 | Transaction Detail Graphic History | | SQL Structure - TransDetailGraphicHistory Table |
11000 | Purchase Order/Bill/Receiving Document | | sql_structure_-_transheader_table |
11001 | Purchase Order/Bill/Receiving Document History | | sql_structure_-_transheaderhistory_table |
11100 | PO Detail | | sql_structure_-_vendortransdetail_table |
11101 | PO Detail History | | SQL Structure - VendorTransDetailHistory Table |
11200 | PO Part | | |
11201 | PO Part History | | |
11300 | PO Variation | | sql_structure_-_transvariation_table |
11301 | PO Variation History | | sql_structure_-_transvariationhistory_table |
12000 | Product | | sql_structure_-_customergoodsitem_table |
12001 | Product UDF | | sql_structure_-_productuserfield_table |
12010 | Modifier | | sql_structure_-_customergoodsitem_table |
12014 | Part | | sql_structure_-_part_table |
12016 | Part Conversion Item | | sql_structure_-_partinventoryconversion_table |
12020 | Product Category | | sql_structure_-_pricingelement_table |
12030 | Modifier Category | | sql_structure_-_pricingelement_table |
12035 | Part Category | | sql_structure_-_pricingelement_table |
12040 | Product Pricing Plan | | sql_structure_-_pricingplan_table |
12041 | Modifier Pricing Plan | | sql_structure_-_pricingplan_table |
12050 | Pricing Plan Type | | sql_structure_-_pricingelement_table |
12051 | Pricing Level | | sql_structure_-_pricinglevel_table |
12052 | Promotion | | sql_structure_-_promotion_table |
12053 | Sales Goal Month | | sql_structure_-_salesgoal_table |
12054 | Sales Goal Year | | sql_structure_-_salesgoal_table |
12060 | Product Tax Exempt Link | | |
12070 | Product/Modifier Link | | sql_structure_-_prodmodlink_table |
12071 | Product/Part Link | | sql_structure_-_goodsitempartlink_table |
12072 | Modifier/Part Link | | sql_structure_-_goodsitempartlink_table |
12074 | Part/Employee Link | | |
12075 | Part Instance | | sql_structure_-_pricingelement_table |
12076 | Catalog Item | | sql_structure_-_catalogitem_table |
12077 | Assembly Link | | sql_structure_-_assemblylink_table |
12080 | Pricing Method | | |
12090 | Pricing Method Parameter | | |
12095 | Pricing Method Table | | |
12100 | Pricing Family | | sql_structure_-_pricingelement_table |
12200 | Inventory | | sql_structure_-_inventory_table |
12500 | Quick Product | | sql_structure_-_quickproduct_table |
12501 | Quick Product List | | sql_structure_-_pricinglink_table |
13000 | Commission Plan | | sql_structure_-_element_table, SQL Structure - CommissionPlan Table |
14020 | Goods Item Parameter Link | | sql_structure_-_pricinglink_table |
14030 | Transaction Detail Parameter | | sql_structure_-_transdetailparam_table |
14031 | Transaction Detail Parameter History | | SQL Structure - TransDetailParamHistory Table |
14040 | Pricing Table | | sql_structure_-_pricingtable_table |
14041 | Pricing Table Element | | SQL Structure - Depricated Table |
14045 | Pricing Table Category | | sql_structure_-_pricingelement_table |
14050 | Discount Table | | sql_structure_-_discounttable_table |
14051 | Discount Table Item | | sql_structure_-_discounttableitem_table |
14500 | Variable Category | | sql_structure_-_pricingelement_table |
14505 | Variable | | sql_structure_-_variable_table |
14510 | Goods Item Variable Link | | sql_structure_-_pricinglink_table |
14515 | Pricing Plan Variable | | sql_structure_-_variable_table |
15000 | Input Template/Pricing Setup | | sql_structure_-_iotemplate_table |
15001 | Input Template Category | | sql_structure_-_pricingelement_table |
15010 | Output Template | | sql_structure_-_iotemplate_table |
15011 | Output Template Category | | sql_structure_-_pricingelement_table |
15020 | Canvas | | |
15021 | Canvas Category | | |
16000 | Payment Terms | | sql_structure_-_paymentterms_table |
16100 | Payment Plan | | sql_structure_-_paymentplan_table |
16110 | Scheduled Payment | | sql_structure_-_scheduledpayment_table |
17000 | Crystal System Report | | |
17001 | Report Template Category | | |
17002 | Crystal Report Template | | |
17003 | Report Category | | |
17004 | Report Item | | |
17006 | Report Group | | |
17010 | Action Report Template | | |
17011 | Word Report Template | | |
17012 | SMSQR System Report | | |
17100 | Word System Report | | |
17105 | SMS System Report | | |
17200 | Report Menu Change | | sql_structure_-_reportmenuitem_table |
17210 | Report Menu Item | | |
17220 | Report Menu Template | | |
17230 | Report Menu Group | | sql_structure_-_reportmenuitem_table |
17240 | Action Report Menu Item | | sql_structure_-_reportmenuitem_table |
17250 | Word Report Menu Item | | sql_structure_-_reportmenuitem_table |
17260 | SMS Report Menu Item | | sql_structure_-_reportmenuitem_table |
17270 | Crystal Report Menu Item | | sql_structure_-_reportmenuitem_table |
17280 | Report Menu BMP | | |
17290 | SQL Report Menu Item | | sql_structure_-_reportmenuitem_table |
17310 | System Report Menu Item | | |
17330 | System Report Menu Group | | |
17340 | System Action Report Menu Item | | |
17350 | System Word Report Menu Item | | |
17360 | System SMS Report Menu Item | | |
17370 | System Crystal Report Menu Item | | |
17380 | System SQL Report Menu Item | | |
17500 | Cyrious Printer Type | | |
17600 | Custom Report Range | | |
18001 | Time Clock Status | | |
19000 | Database Group | | |
19001 | Database Item | | |
20000 | Master Payment | | sql_structure_-_journal_table, sql_structure_-_payment_table |
20001 | Order Payment | | sql_structure_-_journal_table, sql_structure_-_payment_table |
20002 | Over Payment | | sql_structure_-_journal_table, sql_structure_-_payment_table |
20003 | Change Return | | sql_structure_-_journal_table, sql_structure_-_payment_table |
20004 | Order Refund | | sql_structure_-_journal_table, sql_structure_-_payment_table |
20005 | Credit Refund | | sql_structure_-_journal_table, sql_structure_-_payment_table |
20006 | Order Credit Memo | | sql_structure_-_journal_table, sql_structure_-_payment_table |
20007 | Failed Payment | | sql_structure_-_journal_table, sql_structure_-_payment_table |
20008 | Tip Recorded | | sql_structure_-_journal_table, sql_structure_-_payment_table |
20009 | Bill Payment | | sql_structure_-_journal_table, sql_structure_-_payment_table |
20010 | Credit Adjustment | | sql_structure_-_journal_table |
20011 | Change Over Payment | | |
20015 | Write Off | | sql_structure_-_journal_table |
20020 | Finance Charge | | sql_structure_-_journal_table |
20025 | System Finance Charge | | sql_structure_-_journal_table |
20030 | CC Activity | | sql_structure_-_journal_table |
20035 | Journal Entry | | sql_structure_-_journal_table |
20036 | Deposit | | sql_structure_-_journal_table |
20037 | Master Bill Payment | | sql_structure_-_journal_table, sql_structure_-_payment_table |
20038 | Miscellaneous Receipt | | sql_structure_-_journal_table |
20039 | Vendor Credit Adjustment | | |
20040 | Master Tip Payout | | sql_structure_-_journal_table |
20041 | Detail Tip Payout | | sql_structure_-_journal_table |
20050 | Master Time Card | | sql_structure_-_journal_table, sql_structure_-_timecard_table |
20051 | Detail Time Card | | sql_structure_-_journal_table, sql_structure_-_timecard_table |
20060 | Email Activity | | sql_structure_-_journal_table, sql_structure_-_emailactivity_table |
20061 | Email Activity Template | | sql_structure_-_journal_table, sql_structure_-_emailactivity_table |
20065 | Note Activity | | sql_structure_-_journal_table |
20070 | Viewing CC Number Activity | | sql_structure_-_journal_table |
20075 | JDF Activity | | |
20500 | Transaction Activity | | sql_structure_-_journal_table |
20505 | Line Item Activity | | sql_structure_-_journal_table |
20510 | Company Activity | | sql_structure_-_journal_table |
20515 | Company Stage Change Activity | | sql_structure_-_journal_table |
20520 | Transaction Part Usage Activity | | sql_structure_-_journal_table |
20521 | Station Activity | | sql_structure_-_journal_table |
20522 | Proof Approval Activity | | sql_structure_-_journal_table |
20530 | Inventory Adjustment | | sql_structure_-_journal_table |
20531 | Inventory TransPartDetail | | |
20535 | Global Inventory Adjustment Activity | | sql_structure_-_journal_table |
20536 | Inventory Division Summary Adjustment Header | | |
20540 | Import Activity | | sql_structure_-_journal_table |
20550 | Global Cost Adjustment Activity | | sql_structure_-_journal_table |
20560 | Part Usage Processor | | |
20565 | Part Usage Card | | sql_structure_-_journal_table, sql_structure_-_partusagecard_table |
20566 | Inventory Transfer Header | | |
20567 | Inventory Transfer Detail | | |
20570 | Backup Activity | | sql_structure_-_journal_table |
20580 | Service Item | | sql_structure_-_journal_table |
20590 | Report Activity | | sql_structure_-_journal_table |
20600 | Login Activity | | sql_structure_-_journal_table |
20610 | Logout Activity | | sql_structure_-_journal_table |
20620 | Authentication Activity | | sql_structure_-_journal_table |
20630 | EULA Terms Activity | | |
20700 | Reservation Activity | | sql_structure_-_journal_table |
21000 | Activity Viewer | | |
21100 | Contact Activity | | sql_structure_-_journal_table, sql_structure_-_contactactivity_table |
21150 | Contact Activity Template | | sql_structure_-_journal_table, sql_structure_-_contactactivity_table |
21200 | Macro Activity | | sql_structure_-_journal_table, sql_structure_-_ruleactivity_table |
21250 | Macro Activity Template | | sql_structure_-_journal_table, sql_structure_-_ruleactivity_table |
21300 | Work Assignment | | sql_structure_-_journal_table, sql_structure_-_contactactivity_table |
21350 | Work Assignment Template | | sql_structure_-_journal_table, sql_structure_-_contactactivity_table |
22000 | User Field | | sql_structure_-_userfielddef_table |
22001 | User Field Layout | | sql_structure_-_userfieldlayout_table |
22300 | CCCS Configuration | | |
22500 | Advanced Query Node | | |
22501 | Advanced Query Criteria | | |
22502 | Advanced Query Boolean Node | | |
22503 | Advanced Query Table | | |
22504 | Advanced Query Criteria Category | | |
22505 | Criteria Builder Category | | |
22506 | Advanced Query Macro | | |
22507 | User Field Builder Category | | |
22508 | DB Criteria Builder Category | | |
22509 | Static Criteria Builder Category | | |
22510 | Advanced Query Visual Element | | |
22600 | Advanced Query Manager | | sql_structure_-_advquery_table |
22610 | Advanced Query Manager Category | | |
22700 | User Query Criteria | | sql_structure_-_advquerynode_table |
22701 | User Query Boolean Node | | sql_structure_-_advquerynode_table |
22702 | User Query Table | | sql_structure_-_advquerynode_table |
22703 | User Query Macro | | sql_structure_-_advquerynode_table |
23000 | Macro | | sql_structure_-_rulemacro_table |
23005 | Macro Category | | |
23110 | Contact Acitvity Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
23120 | Email Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
23130 | Report Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
23141 | UDF Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
23144 | Popup Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
23146 | Transaction Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
23148 | Another Macro Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
23150 | Company Activity Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
23160 | Service Contract Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
23170 | Work Assignment Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
23180 | Transaction Update Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
23181 | Transaction Station Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
23182 | Company Stage Action | | sql_structure_-_journal_table, sql_structure_-_ruleaction_table |
24001 | Groom | | |
24002 | Matchmaker | | |
24003 | SSLIP's Client | | |
24010 | SSLIP's Log | | |
24011 | HoneyDoLog | | |
24020 | SSLIP's Region | | |
24021 | SSLIP's User | | |
24030 | HoneyDoSQLBatch | | |
24031 | HoneyDoAuthorize | | |
24040 | HoneyDoGroup | | |
25000 | Language | | |
25010 | Translation Item | | |
26000 | Line Item Stage | | sql_structure_-_element_table |
26001 | Service Ticket Stage | | sql_structure_-_element_table |
26002 | Vendor Stage | | sql_structure_-_element_table |
26100 | Station | | sql_structure_-_station_table |
30000 | Course | | |
30030 | Course Event | | sql_structure_-_courseevent_table |
30050 | Course Contact Link | | sql_structure_-_coursecontactlink_table |
30100 | Course Section Type | | sql_structure_-_pricingelement_table |
30110 | Course Section | | |
30200 | Contract Period | | sql_structure_-_contractperiod_table |
31000 | Dashboard | | sql_structure_-_dashboard_table |
31001 | System Dashboard | | |
31002 | Dashboard Instrument | | |
35250 | Payroll | | sql_structure_-_journal_table |
35300 | Payroll Payment Summary | | sql_structure_-_journal_table, sql_structure_-_payment_table |
35301 | Payroll Payment Detail | | sql_structure_-_journal_table, sql_structure_-_payment_table |