Click a star to rate this topic

Click a star to rate this topic

Click a star to rate this topic

Click a star to rate this topic

Click a star to rate this topic

Configurator Tables

tblCfCategory -- holds categories of configurations and is used to create new Item IDs

Column Name	Column Type	Length	Default Value	Description	Enumeration
CategoryId	nvarchar	10
CategoryDescr	pDescription	255
CF	XML
ts	timestamp

tblCfConfigConstraint -- holds constraint information (exceptions in processing)

Column Name	Column Type	Length	Default Value	Description	Enumeration
ConstraintId	bigint
ConfigId	bigint
SeqNum	int
ConstraintType	tinyint		0		0=Message;1=Required;2=Exclude;3=Update
ConstraintDescr	pDescription	255
ConstraintCondition	pDescription	255
ActiveFrom	datetime
ActiveThru	datetime
ConstraintAction	nvarchar	255
ConstraintText	pDescription	255
ConstraintCat	nvarchar	15
CF	XML
ts	timestamp

tblCfConfigField -- holds detail information on the questions being asked in the configuration

Column Name	Column Type	Length	Default Value	Description	Enumeration
FieldId	bigint
GroupId	bigint
FieldCode	nvarchar	50
Label	nvarchar	75
TabOrder	int
LineType	tinyint		0		0=Information;1=Action;2=Inventory
DataType	tinyint		0		0=Text;1=Numeric;2=Yes/No;3=List;4=DescriptionOnly; 5=Picture;6=Drawing;7=Date
ListOptions	nvarchar	255
TextLength	int
AllowQty	bit		0
MultipleSelect	bit		0
LimitToList	bit		0
DisplayWhen	nvarchar	200
HelpText	nvarchar	200
Precision	int		0
NumMinValue	pDec		0
NumMaxValue	pDec		0
NumIncrement	int
NumWarnYN	bit		0
DefaultValue	nvarchar	50
FieldPrice	pDec		0
PriceOption	tinyint		0		0=Fixed Price;1=Price + Value;2=Price – Value;3=Price * Value;4=Price / Value
DefaultPlus	bit
RequiredYN	bit		0
LongDescr	text
PictureId	image
CF	XML
ts	timestamp

tblCfConfigFieldAction -- holds Actions to be taken based on answers to questions

Column Name	Column Type	Length	Default Value	Description	Enumeration
ActionId	bigint
FieldId	bigint
SeqNum	int
ActionEvent	tinyint		0		0=With Value;1=Before Field;2=After Field
FieldValue	nvarchar	50
ActionType	tinyint		0		0=Add Material;1=Add Labor;2=Add Freight;3=Add Text Line;4=Display Message;5=Update Field;6=Go To Field
Action	nvarchar	50
MessageText	nvarchar	200
VariableId	bigint
VariableSetTo	nvarchar	200
CF	XML
ts	timestamp

tblCfconfigFieldActionLbr -- holds detail information about Labor operations

Column Name	Column Type	Length	Default Value	Description	Enumeration
Id	int
ActionId	bigint
RtgType	tinyint
Descr	pDescription	255
SubContractorId	pVendorID	10
SubUnitCost	pDec		0
OperationType	tinyint
WorkCenterId	nvarchar	10
LaborTypeId	nvarchar	10
SetupLaborTypeId	nvarchar	10
MachineGroupId	nvarchar	10
OverlapYN	bit		0
Media	nvarchar	10
QueueTime	pDec		0
QueueTimeIn	smallint		1
MachSetup	pDec		0
MachSetupIn	smallint		1
LaborSetup	pDec		0
LaborSetupIn	smallint		1
MachRunTime	pDec		0
MachRunTimeIn	smallint		1
LaborRunTime	pDec		0
LaborRunTimeIn	smallint		1
WaitTime	pDec		0
WaitTimeIn	smallint		1
MoveTime	pDec		0
MoveTimeIn	smallint		1
CostGroupId	nvarchar	6
MaxQuantity	pDec		0
YieldPct	pDec		0
Notes	nvarchar	max
LeadTime	int
CF	XML
ts	timestamp

tblCfCinfigFieldActionMtl -- holds detail information for BOM materials

Column Name	Column Type	Length	Default Value	Description	Enumeration
Id	int
ActionId	bigint
CompRevisionNo	nvarchar	3
LocId	pLocId	10
Uom	pUOM	5
UsageType	tinyint
DetailType	tinyint
Qty	pDec		0
ScrapPct	pDec		0
UnitCost	pDec		0
CostGroupId	nvarchar	6
MGID	nvarchar	10
Notes	nvarchar	max
CF	XML
ts	timestamp

tblCfConfigFieldActionSo -- holds detail information for Sales Order line items

Column Name	Column Type	Length	Default Value	Description	Enumeration
Id	int
ActionId	bigint
LocId	pLocId	10
UOM	pUOM	5
Qty	pDec		0
UnitCost	pDec		0
Notes	nvarchar	max
CF	XML
ts	timestamp

tblCfConfigFieldMedia -- holds media list for fields

Column Name	Column Type	Length	Default Value	Description	Enumeration
MediaId	bigint
FieldId	bigint
MediaCode	nvarchar	10
SeqNum	int		0
Link	nvarchar	max
Notes	nvarchar	max
CF	XML
ts	timestamp

tblCfConfigFieldValue -- holds list values for fields

Column Name	Column Type	Length	Default Value	Description	Enumeration
ValueId	bigint
FieldId	bigint
ValueDescr	nvarchar	50
FieldPrice	pDec		0
ItemId	pItemID	24
LocID	pLocID	10
Uom	pUOM	5
Quantity	pDec
LongDescr	text
PictureId	image
ItemPictureYn	bit		No
CF	XML
ts	timestamp

tblCfConfigFieldValueMedia -- holds media for field values when using a list field type (used to be tblCfConfigFieldsDtlMedia)

Column Name	Column Type	Length	Default Value	Description	Enumeration
MediaId	bigint
ValueId	bigint
MediaCode	nvarchar	10
SeqNum	int		0
Link	nvarchar	max
Notes	nvarchar	max
CF	XML
ts	timestamp

tblCfConfigGroup -- holds groups used on configurations

Column Name	Column Type	Length	Default Value	Description	Enumeration
GroupId	bigint
ConfigId	bigint
GroupCode	nvarchar	5
Descr	pDescr	255
GroupOrder	int
CF	XML
ts	timestamp

tblCfConfigHeader -- holds header information for configuration maintenance

Column Name	Column Type	Length	Default Value	Description	Enumeration
ConfigId	bigint
ConfigDesc	nvarchar	50
ConfigType	tinyint		0		0 = MO – Manufacturing Orders;1 = SO – Sales Orders;2 = KO – Kitted Orders;3 = RO – Service Repair Orders;4 = SD – Service Inspections
ConfigCategory	nvarchar	10
BaseItemId	pItemId	24
CustId	pCustId	10
ActiveFrom	datetime
ActiveThru	datetime
DefaultAssyWIPD	nvarchar	50
DefaultOperation	nvarchar	10
ConfigItemDescType	int		0		0 = Fixed;1 = Fixed + Values;3 = Values Only
ConfigItemDesc	PDescr	255
CustomOutput	nvarchar	255
PriceOption	tinyint		0		0 = Default Price;1 = Dflt + Option Price
InventoryPriceOption	tinyint		0		0 = Base Item Price;1 = Base + Option Price
ConfigPriceOption	tinyint		0		0 = Default Pricing;1 = Dflt + Option Price
ConfigPriceFrom	tinyint		0		0 = Inventory;1 = Config Detail;2 = Inv. Then Config
DefaultPrice	pDec		0
PictureId	nvarchar	50
ApproveYN	bit		0
LastValidate	datetime
ValidateOK	bit		0
CF	XML
ts	timestamp

tblCfTransHeader -- holds transaction header information for configuration front end

Column Name	Column Type	Length	Default Value	Description	Enumeration
TransId	bigint
SourceType	tinyint				0 = MP;1 = SO;2 = BM;3 = SR;4 = SD
SourceTransId	pTransId	8
SourceEntryNum	bigint
ConfigId	bigint
ConfigType	tinyint
CustId	pCustId	10
TransDate	datetime		getdate
BasePrice	pDecimal		0
BasePriceFgn	pDecimal		0
OptionsPrice	pDecimal		0
OptionsPriceFgn	pDecimal		0
Discount	pDecimal		0
DiscountFgn	pDecimal		0
TotalPrice	pDecimal		0
TotalPriceFgn	pDecimal		0
CF	XML
ts	timestamp

tblCfTransDetail -- holds transaction detail information for configuration front end

Column Name	Column Type	Length	Default Value	Description	Enumeration
DetailId	bigint
TransId	bigint
FieldId	bigint
Question	nvarchar	75
DataType	tinyint
Answer	nvarchar	max
Uom	pUOM	5
Quantity	pDecimal
UnitPrice	pDecimal
UnitPriceFgn	pDecimal
RequiredYn	bit		No
SelectedYn	bit		No
Notes	text
CF	XML
ts	timestamp

tblCfTransDetailExt -- holds extended transaction detail information for configuration front end

Column Name	Column Type	Length	Default Value	Description	Enumeration
SeqNum	int
DetailId	bigint
ValueId	bigint
Answer	nvarchar	50
ItemId	pItemID	24
LocId	pLocID	10
Uom	pUOM	5
Quantity	pDecimal
UnitPrice	pDecimal
UnitPriceFgn	pDecimal
SelectedYn	bit		No
Notes	text
CF	XML
ts	timestamp

tblCfHistHeader -- holds historical header information for configuration front end

Column Name	Column Type	Length	Default Value	Description	Enumeration
PostRun	pPostRun
TransId	bigint
ItemId	pItemId			If SO or KO, this is the item that was generated
SourceType	tinyint				0 = MP;1 = SO;2 = BM;3 = SR;4 = SD
SourceTransId	pTransId	8
SourceEntryNum	bigint
ConfigId	bigint
ConfigType	tinyint
CustId	pCustId	10
TransDate	datetime		getdate
BasePrice	pDecimal		0
BasePriceFgn	pDecimal		0
OptionsPrice	pDecimal		0
OptionsPriceFgn	pDecimal		0
Discount	pDecimal		0
DiscountFgn	pDecimal		0
TotalPrice	pDecimal		0
TotalPriceFgn	pDecimal		0
CF	XML
ts	timestamp

tblCfHistDetail -- holds historical detail information for configuration front end

Column Name	Column Type	Length	Default Value	Description	Enumeration
PostRun	pPostRun
DetailId	bigint
TransId	bigint
FieldId	bigint
Question	nvarchar	75
DataType	tinyint
Answer	nvarchar	50
Uom	pUOM	5
Quantity	pDecimal
UnitPrice	pDecimal
UnitPriceFgn	pDecimal
RequiredYn	bit		No
SelectedYn	bit		No
Notes	text
CF	XML
ts	timestamp

tblCfHistDetailExt -- holds extended historical detail information for configuration front end

Column Name	Column Type	Length	Default Value	Description	Enumeration
PostRun	pPostRun
SeqNum	int
DetailId	bigint
ValueId	bigint
Answer	nvarchar	50
ItemId	pItemID	24
LocId	pLocID	10
Uom	pUOM	5
Quantity	pDecimal
UnitPrice	pDecimal
UnitPriceFgn	pDecimal
SelectedYn	bit		No
Notes	text
CF	XML
ts	timestamp

tblCfConfigVariable -- holds information on variables associated with configuration setup

Column Name	Column Type	Length	Default Value	Description	Enumeration
VariableId	bigint
ConfigId	bigint
VariableCode	nvarchar	50
VariableType	tinyint		0		0 = Text;1 = Number;2 = Date;3 = Yes/No
TextLength	int
Descr	nvarchar	50
CF	XML
ts	timestamp