CT00003 - IC COST Standard Item Defaults | Prospr

CT00003 - IC COST Standard Item Defaults

Select * from CT00003

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CMPANYID	Company ID	Integer	2	View
ITEMNMBR	Item Number	String	32	View
ITEMDESC	Item Description	String	102	View
ITMCLSCD	Item Class Code	String	12	View
MODIFDT	Modified Date	Date	4	View
MDFUSRID	Modified User ID	String	16	View
COST_I	Cost	Currency	10	View
EFFECTIVEDATE_I	Effective Date0	Date	4	View
FIXAMTORPCT_I	Fixed Amount or Percent	Integer	2	View
Fixed_Overhead_Amount	Fixed Overhead Amount	Currency	10	View
FIXOHDPCT_I	Fixed Overhead Percent	Long Integer	4	View
FIXOHDEFFDATE_I	Fixed Overhead Effective Date	Date	4	View
VARAMTORPCT_I	Variable Amount or Percent	Integer	2	View
Variable_Overhead_Amount	Variable Overhead Amount	Currency	10	View
VAROHDPCT_I	Variable Overhead Percent	Long Integer	4	View
VAROHDEFFDATE_I	Variable Overhead Effective Date	Date	4	View
PENDINGCOST_I	Pending Cost	Currency	10	View
PENDEFFDATE_I	Pending Effective Date	Date	4	View
PENDFIXAMTORPCT_I	Pending Fixed Amount or Percent	Integer	2	View
PENDFIXOHDAMT_I	Pending Fixed Overhead Amount	Currency	10	View
PENDFIXOHDPCT_I	Pending Fixed Overhead Percent	Long Integer	4	View
PENDFIXOHDEFFDATE_I	Pending Fixed Overhead Effective Date	Date	4	View
PENDVARAMTORPCT_I	Pending Variable Amount or Percent	Integer	2	View
PENDVAROHDAMT_I	Pending Variable Overhead Amount	Currency	10	View
PENDVAROHDPCT_I	Pending Variable Overhead Percent	Long Integer	4	View
PENDVAROHDEFFDATE_I	Pending Variable Overhead Effective Date	Date	4	View