ITSBITS Software Help
Intranet Home
Purpose/OverView
Open ITSBITS SQL diagram
Concepts
Billing Calc. Methods
Billing Types Chart
Historic Data Storage Map
Data Edit/Entry General Instructions
Cancellations
Getting Started w/Data Entry
ITSBITS Portal-Of-Entry
ITSBITS DB Tables Maintenance
Historical Data
Reports
Reports Viewer
Data Processing
ITSBITS System Configuration
User License
System Requirements
Installation
Troubleshooting Guide
|
Page Contents
ActivePolicy Table
AdministrativeFees Table
Company Table
InsuranceCarrier Table
PolicyMaster Table
Receivables Table
Salesmen Table
 |
These charts detail how the system stores its historical information. We hope you never really need them and we strongly urge you to consult with IHS before you make any changes to the data stored in the tables as indicated on these charts. (In fact, ITSBITS does not, in itself, allow you to make changes to these files.) |
| ActivePolicy Table |
| Fields | Store this data |
| AF1-36 | Administrative fee billed to Company (customer) |
| AP1-36 | Policy premium billed to Company (customer) |
| PP1-36 | Policy premium to be paid to insurance carrier |
| AC1-36 | Policy premium amount sent to the insurance carrier |
| CK1-36 | Commission to be kept by us |
| CR1-36 | Commission to be returned to us by insurance carrier |
| SC1-36 | Sales person's commission amount for this policy/month |
Back to top of page
| AdministrativeFees Table |
| Fields | Store this data |
| TR1-36 | Commissions paid to us |
| TC1-36 | Salesman's commission amounts |
| TB1-36 | Administrative Fees billed to the Company (customer) |
| TP1-36 | Administrative Fess paid by the Company (customer) |
Back to top of page
| Company Table |
| Fields | Store this data |
| CP1-36 | Commission paid to ITSBITS + Admin Fees Paid to ITSBITS |
| SC1-36 | Sales-person commission amount |
| BC1-36 | Amount billed to the company(customer) |
| PP1-36 | Amount paid to us by the company (customer) |
Back to top of page
| InsuranceCarrier Table |
| Fields | Store this data |
| CP1-36 | Commissions paid to us by the carrier |
| PC1-36 | Paid by us to the insurance carrier |
Back to top of page
| Policy Master Table |
| Fields | Store this data |
| CR1-36 | Commissions paid to us |
| PI1-36 | Amount paid to the insurance carrier for this policy type |
| IC1-36 | Amount receivable from the insurance carrier |
Back to top of page
| Receivables Table |
| Fields | Store this data |
| PR1-36 | Payment received from company |
Back to top of page
| Salesmen Table |
| Fields | Store this data |
| CO1-36 | Amount paid to the sales person |
|
