# View: Contract Pricing

RotoID: IC0274
Table: ICCUPR
Protocol: Flat
DLL: ICCUPR

## Compositions: 6

RotoID | Tables | Title | DLL
--- | --- | --- | ---
AR0024 | ARCUS | Customers | ARCUS
IC0310 | ICITEM | Items | ICITEM
IC0210 | ICCATG | Categories | ICCATG
IC0390 | ICPCOD | Price List Codes | ICPCOD
IC0480 | ICPRIC | Item Pricing | ICPRIC
IC0290 | ICILOC | Location Details | ICILOC

## Keys: 4

Title | Fields
--- | ---
Customer Number | CUSTNO, PRICEBY, CATEGORY, ITEMNO, PRICELIST
Price By | PRICEBY, ITEMNO, CATEGORY, CUSTNO, PRICELIST
Item Number | ITEMNO, PRICEBY, CUSTNO, PRICELIST
Category | CATEGORY, PRICEBY, CUSTNO

## Fields: 29

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
CUSTNO | 1 | String*12 | Customer Number | E A K R | Mask: %-12C
PRICEBY | 2 | Integer | Price By | E A K R | List: 2 entries
1 | = | Category Code
2 | = | Item Number
CATEGORY | 3 | String*6 | Category Code | E A K R | Mask: %-6N
ITEMNO | 4 | String*24 | Item Number | E A K R | Mask: %-24C
PRICELIST | 5 | String*6 | Price List | E A K R | Mask: %-6N
EXPIRE | 6 | Date | Expiration Date | E A |
PRICETYPE | 7 | Integer | Price Type | E A P | List: 6 entries
1 | = | Customer Type
2 | = | Discount Percentage
3 | = | Discount Amount
4 | = | Cost Plus a Percentage
5 | = | Cost Plus Fixed Amount
6 | = | Fixed Price
CUSTTYPE | 8 | Integer | Customer Type | E A | List: 6 entries
1 | = | Base
2 | = | A
3 | = | B
4 | = | C
5 | = | D
6 | = | E
DISCPER | 9 | BCD*5.5 | Discount Percentage | E A |
DISCAMT | 10 | BCD*10.6 | Discount Amount | E A |
COSTMETHOD | 11 | Integer | Costing Method | E A P | List: 6 entries
1 | = | Markup Cost
2 | = | Standard Cost
3 | = | Most Recent Cost
4 | = | Average Cost
5 | = | Last Unit Cost
6 | = | Landed
PLUSAMT | 12 | BCD*10.6 | Plus Amount | E A |
PLUSPER | 13 | BCD*5.5 | Plus Percentage | E A |
FIXPRICE | 14 | BCD*10.6 | Fixed Price | E A |
STARTDATE | 15 | Date | Start Date | E A |
USELOWEST | 16 | Boolean | Use Lowest Price | E A | List: 2 entries
0 | = | No
1 | = | Yes
CALCPRICE | 50 | BCD*10.6 | Calculated Unit Price | E A C |
CALCDECS | 51 | Integer | Calculated Price Decimals | E A C |
FMTITEMNO | 52 | String*24 | Formatted Item Number | E A C |
CUSTDESC | 53 | String*60 | Customer Name | E A C |
CATDESC | 54 | String*60 | Category Description | E A C |
ITEMDESC | 55 | String*60 | Item Description | E A C |
PRLSTDESC | 56 | String*60 | Price List Description | E A C |
CURRDESC | 57 | String*3 | Currency Code | E A C |
PRUNTDESC | 58 | String*10 | Price Unit Description | E A C |
LOCATION | 59 | String*6 | Location | E A C |
CALCVALID | 60 | Boolean | Calculated Unit Price is Valid | E A C |
PRICPRICBY | 61 | Integer | Pricing Price By | E A C | List: 2 entries
1 | = | Quantity
2 | = | Weight
CHECKITEM | 62 | Boolean | Check Item Existence | E A C | List: 2 entries
0 | = | No
1 | = | Yes

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.