| objid | price_prog | objid | Price program internal record number | 3 (UNIQUE) |
| currency_objid | currency | objid | Currency internal record number | |
| name | price_prog | name | Name for the pricing program | |
| description | price_prog | description | Description of the pricing program | |
| display | price_prog | display | If true, display pricing program for ClearLogistics in list box on parts look-up form; i.e., 0=false, 1=true. Default=0 | |
| type | price_prog | type | Price type; i.e., 0=Standard Cost, 1=Proposed Std. Cost, 2=Transfer Price, 3=List Price, 4=Repair Price, 5= Exchange Price, 6=Other, default=0 | |
| effective_date | price_prog | effective_date | Date the price program becomes effective | |
| expire_date | price_prog | expire_date | Last date the price program is effective | |
| active | price_prog | active | Indicates whether the price program is active; i.e., 0=inactive, 1=active, default=1 | |
| displaycc | price_prog | displaycc | If true, display pricing program in Clear Contracts; i.e., 0=false, 1=true. Default=1 | |
| displaycs | price_prog | displaycs | If true, display pricing program in ClearSales; i.e., 0=false, 1=true. Default=1 | |
| dev | price_prog | dev | Row version number for mobile distribution purposes | |
| currency_name | currency | name | Name of the currency | |
| currency_symbol | currency | symbol | Symbol for the currency; e.g., $ for US dollar | |
| currency_description | currency | description | Description of the currency | |