View Name:contr_itm_lst
View Number:5517
Group:Sales Mgr
Description:Used by JSP page account_quote_overview.jsp
Flags:VIEW_OPTIMIZED 
Baseline/Custom:Baseline

Fields:

View Field NameTable NameField NameCommentGeneric Field Id
objidcontr_itmobjidcontract line item internal record number 3 (UNIQUE)
line_nocontr_itmline_noContract line item line no 
unit_typecontr_itmunit_typeThe type of unit the contract is delivered by; e.g., day, case, etc 
units_purchcontr_itmunits_purchThe number of units purchased for the line item 
units_usedcontr_itmunits_usedThe number of line item units which remaining 
units_availcontr_itmunits_availThe number of line item units which still unused 
pricecontr_itmprcThe price which was copied from the price schedule (price_inst) 
net_pricecontr_itmnet_prcThe price after all adjustments (price factors) have been applied 
quote_itemcontr_itmquote_itemDefines whether the line item is to be priced on the quote worksheet; i.e., 0=no, 1=yes, default=1 
pro_pricecontr_itmpro_prcThe prorated price of the item 
extensioncontr_itmextnThe extended price of the item before price factors were applied. It is determined by quantity * price or quantity * rate as appropriate 
quantitycontr_itmquantityContracted/Quoted quantity of the part 
productpart_numpart_numberContract line item part number 
mod_level_objidmod_levelobjidMod_level internal record number 
revmod_levelmod_levelContract line item mod level 
descriptionpart_numdescriptionContract line item description 
sched_objidcontr_scheduleobjidContr_schedule internal record number 
child_cntcontr_itmchild_cntFor a parent line, the number of child parent lines under it 
part_num_objidpart_numobjidPart_num internal record number 
line_no_txtcontr_itmline_no_txtConcatination of parent and child line numbers delimited by a period 
tot_adjcontr_itmtot_adjThe sum of all adjustments against the line 
rollup_prccontr_itmrollup_prcThe sum of the net_prc field on all child items and the current item. If no child items, it is the same as the net_prc value of the current item 
handling_costcontr_itmhandling_costThe sum of all handling costs for the item. Used where contract.struct_type=2 
tot_ship_amtcontr_itmtot_ship_amtThe sum of all shipping charges for the item 
statuscontr_itmstatusCurrent status of an order line item. This is a user-defined popup with default name Order Line Status 
total_tax_amtcontr_itmtotal_tax_amtThe sum of all taxes applied to the item. Used where contract.struct_type=2 
valid_prc_indcontr_itmvalid_prc_indIndicates whether a valid price for the item was found; i.e., 0=no valid price found; 1=valid price found, default=1. Used in re-pricing 
gross_prccontr_itmgross_prcFor childless items this is the item's non-extended base price, for child items this is the sum of the extended base prices of all its child items plus its own non-extended base price 
line_keycontr_itmline_keyThe Configurator line item identifier corresponding to the contract schedule line item 
domainpart_numdomainName of the domain for the part num. See object prt_domain 

Joins:

Join FromJoin To
(contr_itm).contr_itm2contr_schedule(contr_schedule).schedule2contr_itm
(contr_itm).contr_itm2mod_level(mod_level).part_info2contr_itm
(mod_level).part_info2part_num(part_num).part_num2mod_level
My Recent Objects
contr_itm_lst