M18 ERP XML Config & Usage

Version: 1.1 | Release Date: 7/12/2018

aitype

Usage

Define the debtor/creditor type in finance modules.

Attributes

Name	Description	Example	Required	Default Value
module	Define the module of debtor/creditor.	cus	Y
mess	Define the messCode used for debtor/creditor.	ce01_core.cus	Y
lookupType	Define the lookup type for header.	approvedSalesCus	Y
footerLookupType	Define the lookup type for footer.	approvedSalesCus	N
isCreditorType	Indicate if this is creditor type.	false	N	true
isDebtorType	Indicate if this is debtor type.	false	N	true
typeHandler	Define the handler for the current debtor/creditor type. The handler should implement IAITypeHandler.	N
extend	Indicate if the current element is the extension of any existing element.	true	N	false
disableFields	Define the fields/tab that need to be disabled when the current debtor/creditor type is selected. Value should be in the format like position:name. position: m represent main header while t means tab. name means column name or tab name. ; separated.	m:manId;m:position	N

asavechk

Usage

Used in com.multiable.erp.core.ejb.checker.MySaveChecker for the pupose of defining logical rules in related modules.

Attributes

Name	Description	Example	Required	Default Value
module	Define the module that need to be saved.	oldso	Y
extend	Indicate if the current element is the extension of any existing element.	false	N	false
chkCond	Compare operator of chkField and refField.	!=, &gt; means > , &lt; means <.	Y
chkTable	Define the table in the current module used to join the related module.	mainso	Y
chkKeyCol	Define the column name in chkTable used to join the refKeyCol in refTable.	id	Y
chkCodeCol	Define the code column in the current module.	code	N	code
chkField	Define the column that need to check in the current module.	curId	Y
chkAlias	Define the table alias used for chkField.	M means mian table. F means footer table.	N	M
refType	Define the related module.	dn	Y
refTable	Define the related table.	dnt	Y
refKeyCol	Define the column in refTable used to join the chkKeyCol in chkTable.	hId	Y
refCodeCol	Define the code's column name in related module.	code	N	code
refField	Define the column that need to check in related module.	curId	Y
refAlias	Define the table alias used for refField.	M means mian table. F means footer table.	N	F
chkOrder	Define the check order.	1	Y
expired	Indicate if this logical rule is expired.	false	N	false
errorMess	Define messCode to describe the error when chkField and refField satisfied chkCond.	ce01_core.asavechk_not_same	Y
refMess	Define the messCode to describe the refField.	ce01_core.cur	N
chkMess	Define the messCode to describe the chkField.	ce01_core.cur	N
addCond	Define the additional condition need to join chkTable and refTable together. a means current module's main table. b means current module's footer table. c means related module footer table. d means related module's main table.	c.sourceType='oldso'	N

Example

<item chkCond="!=" chkTable="mainso" chkKeyCol="id" chkField="curId" refType="dn" refTable="dnt" refKeyCol="sourceId" refField="curId" refAlias="M" addCond="c.sourceType='oldso'" chkOrder="1" errorMess="ce01_core.asavechk_not_same"/>

The above snippet used to check if the currencies used in sales order and delivery note are the same.

barcodeSetting

Usage

Default setting of [Product Label Printing]. Used to define the data source of product label.

Attributes

Name	Description	Example	Required	Default Value
module	Define the module that supports printing product label.	pro	Y
ejbClass	Define the EJB class used to load data.	BarcodeSettingEJB	Y
ejbMethod	Define the method in ejbClass to load data.	loadData	Y
filterSearch	Define the default filter criteria for the current module in [Product Label Printing].	proBarcodeFilter	N
extend	Indicate if the current element is the extension of any existing element.	false	N	false

batchGenSetting

Usage

Default setting of [Turbo Document Generation].

Attributes

Element	Name	Description	Example	Required	Default Value
module	name	Define the module's name.	po	Y
module	viewListener	Define the class used to handle the data and function related to the UI of current module. It has to implement the interface BatchGenModuleListener.		Y
module	extend	Indicate if the current element is the extension of any existing element.	true	N	false
optionField	fieldName	Define the field name of functional field displayed in UI.	upOrigin	Y
optionField	fieldMess	Define the messcode of this functional field	ce01_trdg.upOrigin	Y
optionField	editType	Define the input type of this functional field. The input type contains : inputCheck, inputCombo, inputNum, inputText, lookupField, commandButton	inputCombo	Y
optionField	pattern	Define the Pattern of this functional field.		N
optionField	showCond	Define the condition of showing this functional field.	false|var.xxxxx	N	true
optionField	requiredCond	Define the condition to judge if this field is compulsory.	true|var.xxxxx	N	false
optionField	expired	Indicate if this field is expired.	true	N	false
optionField	extend	Indicate if the current element is the extension of any existing element.	true	N	false
showField	fieldName	Define the field name in the footer table in this editor of this module.		Y
showField	fieldMess	Define the Messcode of current field		Y
showField	editType	Define the input type of this field. The input type contains :cawDate, cawLookup, cawNum, cawCheckbox, cawText, cawButton		Y
showField	pattern	Define the Pattern of this field.		Y
showField	fieldClass	Define the SqlTable data type of this field. The type contains : LONG, DATE, DOUBLE, BOOLEAN and STRING		N
showField	showAfter	Define the name of field which current field displayed behind.		N
showField	showCond	Define the condition of showing this field.	false|var.xxxxx	N	true
showField	readonlyCond	Define the condition to judge if this field is read-only.	true|var.xxxxx	N	false
showField	requiredCond	Define the condition to judge if this field is compulsory.	true|var.xxxxx	N	false
showField	expired	Indicate if this field is expired.	true	N	false
showField	footerField	Indicate if this field is from footer table of this module.		N	false
showField	batchUpdate	Indicate if this field supports "batch update"(the Copy Column function of EditTable).		N	false
showField	extend	Indicate if the current element is the extension of any existing element.	true	N	false
source	moduleName	Define the module name of data source.	pro	Y
source	viewListener	Define the class used to handle the data and function related to the UI of source module. It has to implement the interface BatchGenSourceListener.		Y
source	expired	Indicate if this source is expired.	true	N	false
source	extend	Indicate if the current element is the extension of any existing element.	true	N	false

Example

<module name="po" viewListener="com.multiable.erp.trdg.bean.batchgen.GenPoListener">
		<optionField fieldName="upOrigin" fieldMess="ce01_trdg.upOrigin" editType="inputCombo" pattern=""/>
		<optionField fieldName="descOrigin" fieldMess="ce01_trdg.descOrigin" editType="inputCombo" pattern=""/>
		<optionField fieldName="venScore" fieldMess="ce01_trdg.venSelctionBy" editType="inputCombo" pattern=""/>
		<optionField fieldName="sumProQty" fieldMess="ce01_trdg.summaryProQty" editType="inputCombo" pattern="trdg_summaryPro"/>
		<optionField fieldName="considerMpqMoq" fieldMess="ce01_trdg.considerMpqMoq" editType="inputCheck" pattern=""/>
		<optionField fieldName="refreshScore" fieldMess="ce01_trdg.refreshScore" editType="commandButton" pattern=""/>
		
		<showField fieldName="virDeptId" fieldMess="ce01_core.virDept" editType="cawLookup" pattern="core_virDept" showCond="var.enableVirDept" requiredCond="var.enableVirDept" readonlyCond="false" batchUpdate="true"/>
		<showField fieldName="cnDeptId" fieldMess="ce01_core.cnDept" editType="cawLookup" pattern="cnDept" readonlyCond="false" batchUpdate="true"/>
		<showField fieldName="doctypeId" fieldMess="ce01_core.doctype" editType="cawLookup" pattern="approvedDoctype" readonlyCond="false" batchUpdate="true"/>	
		
		<showField fieldName="sourceType" fieldMess="ce01_trdg.proDataSource" editType="cawCombo" pattern="trdg_poSourceType" />
		<showField fieldName="sourceId" fieldMess="ce01_core.sourceTransaction" editType="cawLookup" pattern="erp_import_id" />
		<showField fieldName="sourceDate" fieldMess="ce01_core.sourceTransactionDate" editType="cawDate" pattern="date" />
		<showField fieldName="proId" fieldMess="ce01_trdg.product" editType="cawLookup" pattern="trdgpro" requiredCond="true"/>
		<showField fieldName="sourceLot" fieldMess="ce01_trdg.proDataSourceLot" editType="cawText" pattern="ce01_lot" />
		<showField fieldName="bDesc" fieldMess="ce01_core.bDesc" editType="cawText" pattern="charDesc" />
		
		<showField fieldName="ref_inventoryItem" fieldMess="ce01_core.inventoryItem" editType="cawCheckbox" pattern="check" />
		<showField fieldName="ref_attrib" fieldMess="ce01_core.attrib" editType="cawCombo" pattern="attrib" />
		
		<showField fieldName="ref_qty" fieldMess="ce01_trdg.refQty" editType="cawNum" pattern="n_number15_8"/>
		<showField fieldName="qty" fieldMess="ce01_core.qty" editType="cawNum" pattern="n_number15_8" readonlyCond="false" requiredCond="true"/>
		<showField fieldName="unitId" fieldMess="ce01_core.unit" editType="cawLookup" pattern="proUnit" readonlyCond="false" requiredCond="true"/>
		
		<showField fieldName="ref_dDate" fieldMess="ce01_trdg.refETD" editType="cawDate" pattern="date" />
		<showField fieldName="dDate" fieldMess="ce01_trdg.ETA" editType="cawDate" pattern="date" footerField="true" readonlyCond="false" batchUpdate="true"/>
		
		<source moduleName="pro" viewListener="com.multiable.erp.trdg.bean.batchgen.PoSourceProListener"/>
		<source moduleName="oldso" viewListener="com.multiable.erp.trdg.bean.batchgen.PoSourceSoListener"/>
	</module>	

bsflow

Usage

Used to define the source transaction in different modules. Module defined in this XML will be shown in [Business Process Configuration].

Attributes

Element	Name	Description	Example	Required	Default Value
flow	module	Define the current module.	oldso	Y
flow	compId	Define the component's id used to store the lookup data. If the lookup field is inside an edittable, please use the id of the edittable.	mainFooter	N	mainFooter
flow	skipModule	Define the module that must included in data source.	pro	N
flow	extend	Indicate if the current element is the extension of any existing element.	false	N	false
flow	disablePro	If true and target module set to current module in [Business Process Configuration], <Allow Product/Material in Data Destination without Data Source> will be false and disabled.	false	N	false
item	sourceType	Define the source transaction type.	oldqu	Y
item	mess	Define the messCode to describe the source transaction type.	ce01_trdg.salesQu	N	message code of the module.
item	moduleLookupType	Define the lookup type used for the source transaction.	multiqu	Y
item	keyLookupType	Define the lookup type used for the product.	qufooter	Y
item	skipCheckLoad	If false, when open the source transaction, if it has been loaded to the module in flow, the transaction is prohibited from changing the customer/vendor/business flow/currency/rate.	true	N	false
item	singleFlowType	Indicate if same source type can only assigned to one module in the same business flow setting.	true	N	false
item	loadOutstanding	Indicate if outstanding quantity should be loaded.	true	N	false
item	loadDataHelper	Define the handler used when retrieving data from source transaction.	TradeOSHelper	N
item	loadDisc	Indicate if discount or charge should be loaded.	true	N	false
item	loadRemarks	Indicate if remarks should be loaded.	true	N	false
item	useOrigin	Indicate if price origin and description origin should be used.	true	N	false
item	checkFK	Indicate if source transaction can be deleted if used in the the current module.	true	N	true
item	checkSFFlag	Define the SF that determines if this transaction type is available	p (represents QC function is bought)	N

bsFlowAcc

Usage

Default setting of [Business Process Setup (Finance)].

Attributes

Element	Name	Description	Example	Required	Default Value
flow	module	Define the module's name.	recReg	Y
flow	invoiceTable	Define the table for invoice.		N
flow	depositTable	Define the table for deposit received.	N
flow	depUtilisedTable	Define the table for deposit used.	recregdepo	N
flow	hasPosting	Indicate if voucher should be generated.	true	N	false
flow	extend	Indicate if the current element is the extension of any existing element.	true	N	false
invoice	module	Define the invoice's module name.	arTran	Y
invoice	mess	Define the messCode to describe the invoice type.	ce01_ac.arTran	N
invoice	AIType	Define the invoice's debtor/creditor type.	cus	N
invoice	lookupType	Define the invoice's lookup type.	invArTran	N
invoice	ledger	Define the nature of the invoice/deposit in [AR-AP Offset]. Options:arInvoice, apInvoice, arDepo, apDepo	arInvoice	N
deposit	module	Define the deposit's module name.	oldso	Y
deposit	mess	Define the messCode to describe the deposit type.	ce01_trdg.so	N
deposit	AIType	Define the deposit's debtor/creditor type.	cus	N
deposit	lookupType	Define the deposit's lookup type.	oldso	N
deposit	ledger	Define the nature of the invoice/deposit in [AR-AP Offset]. Options:arInvoice, apInvoice, arDepo, apDepo	arDepo	N
depUtilised	module	Define the deposit used's module name.	recReg	Y
depUtilised	mess	Define the deposit used type's messCode.	ce01_ac.recReg	N
depUtilised	AIType	Define the deposit used's debtor/creditor type.	cus	N
depUtilised	lookupType	Define the deposit used's lookup type.	recRegInfo	N
depUtilised	ledger	Define the nature of the invoice/deposit in [AR-AP Offset]. Options:arInvoice, apInvoice, arDepo, apDepo	arDepo	N

bsrule

Usage

Check if the data is valid based on the defined business rules when transactions is saved or deleted. Default setting of [Business Rule Configuration].

Attributes

Element	Name	Description	Example	Required	Default Value
rule	module	Define the current module.	oldso	Y
rule	extend	Indicate if the current element is the extension of any existing element.	false	N	false
item	name	Define the business rule's name.	overShip	Y
item	mess	Define the business rule's messCode displayed in user interface.	ce01_core.bsrule_overship(so)	Y
item	formula	Define the business rule's formula. If this formula return positive value, the transaction cannot be saved or deleted.	[minUp] > (1+[tolerance]/100) * [netup]	Y
item	chkOrder	Define the business rule's checking order when saving the transaction.	1	Y
item	retype	Define the return type.	numeric	Y
item	retFormula	Define the return formula.	[minUp] > (1+[tolerance]/100) * [netup]	Y
item	ejbClass	Define the EJB class for this checking.	xxx.OverShipChecker	Y
item	ejbMethod	Define the mehtod in ejbClass to run this checking.	overShip	Y
item	retValue	Define the return value.	max	N
item	chkTable	Define the table needed to be checked in this module.	sot	N
item	errorKey	Define the error code. Reference to the key of < message-case> in app.xml.	ce01_core_103000	N
item	mapping	Indicate if data mapping is avaliable in [Business Rule Setting].	true	N	false
item	extend	Indicate if the current element is the extension of any existing element.	true	N	false
formulaParam	name	Define the variable name used in formula	minUp	Y
formulaParam	mess	Define the variable's messCode displayed in the user interface.	ce01_core.minUp	Y
formulaParam	ejbClass	Define the EJB class used to handle the parameter.		N
formulaParam	ejbMethod	Define the method in ejbClass to handle the parameter.		N
formulaParam	type	Define the type of parameter.	numeric	N
condParam	name	Define the name of the condition. The business rule will be processed only when the condition is passed.	sot_proId_code	Y
condParam	mess	Define the condition's messCode.	ce01_core.proCode	Y
condParam	tableName	Define the table used in the condition.	sot	Y
condParam	columnName	Define the column name used in the condition.	proId	Y
condParam	type	Define the type of condition. Options: sql, boolean.	sql	Y
condParam	ejbClass	Define the EJB class name to handle the condition.	xxx. OverShipChecker	N
condParam	ejbMethod	Define the method in ejbClass to handle the condition.	oldsoValidProCode	N

closedSetting

Usage

Default setting of [Close Transaction] and used to handle the process of loadData() and updateData() in ClosedSetting EJB.

Attributes

Name	Description	Example	Required	Default Value
module	Define the module's name.	oldso	Y
extend	Indicate if the current element is the extension of any existing element.	false	N	false
ejbClass	Define the EJB's handler class name to process the request.	xxx.ClosedSettingData	N
ejbMethod1	Define the method used in ejbClass for loading data.	loadData	N
ejbMethod2	Define the method used in ejbClass for updating data.	updateData	N
filterSearch	Define the default filter criteria for the current module in [Close Transaction].	soClosedFilter	N
jsfClass	Define the backing bean of the footer table.	xxx.TrdgClosedSettingBean	N
jsfXhtml	Define the view file of the footer table such that when users choose the current module, the footer table will be changed as defined in this view file.	/xxx/TrdgClosedSetting.xhtml	N
auto	Indicate if this transaction will be closed automatically. (AP should check this flag and do the closing in checker)	true (e.g. [AR Transaction] will be closed when it is fully settled)	N	false

jlConf

Usage

Define the default setting of voucher configuration.

Attributes

Element	Name	Description	Example	Required	Default Value
config	module	Define the module's name.	arTran	Y
config	extend	Indicate if the current element is the extension of any existing element.	true	N	false
item	type	Define the type of the current item.	arTran_arAcc_debit	Y
item	mess	Define messCode used to show the description in user interface.	ac.arTranVoucherMess1	N
item	order	Define the order shown in the user interface.	1	Y
item	sourceTable	Define the table of source transaction.	mainartran	Y
item	curField	Define the column name of currency.	mainartran.curId	N
item	rateField	Define the column name of rate.	mainartran.rate	N
item	dateField	Define the column name of date.	mainartran.tDate	Y
item	accFormula	Define the formula for the account used in current item when generating the voucher.	artrant.accId	N
item	amtFormula	Define the formula for the amount used in current item when generating the voucher.	@D_mainartran_amt	Y
item	domAmtFormula	Define the formula for amount(entity currency) in current item when generating the voucher.	@D_mainartran_amt	N
item	direction	Define if the item is in debit/credit side. Option: 1 means credit, -1 means debit.	1	Y
item	accDescFormula	Define the formula to describe the account in this item when generating the voucher.	@D_mainartran_accDesc	N
item	particularFormula	Define the formula to describe the transaction in this item when generating the voucher.	@D_remartran_particular	N
item	aiRefModuleField	Define the column name of source transaction type.	sTranType	N
item	aiRefIdField	Define the column name of source transaction.	sTranId	N
item	aiRefLotField	Define the column name of source transaction's lot.	N
item	useSourceAcc	Indicate if account should be retrieved from source transaction.	true	N	false
item	sourceAccMapping	Define the mapping fields in sourceTable to map with tranType, tranId, and lot fields in table accdfsource. ; separated. Order of these 3 fields cannot be changed.	ce01Module;hId;lot。	N
item	isAdj	Indicate if the amount is adjustable.	true	N	false
item	isStock	Indicate if the current module related to stock.	true	N	false
item	app	Define the app that must exists. If not exists, the current item will not appear in user interface.	ce01_trdg	N	ce01_ac
item	enable	Indicate if this item is enabled.	false	N	true
item	autoMapping	Indicate if the fields in [Journal Voucher] and sourceTable or the main table in module should be auto mapped.	true	N	false
item	extend	Indicate if the current element is the extension of any existing element.	true	N	false
item	chkVarCond	Define the variable used to determine if this item will appear in user interface. If getVariable(xxx) in Java Bean is set to true, this item will appear in user interface. ; separated.	disabledVatPerItem，	N
cond	field	Define the field used in the condition.	art.qty	Y
cond	operator	Define the condition operator.	>	Y
cond	value	Define the value for comparsion.	0	Y
mapping	fieldName	Define the field name in voucher.	debtorType	Y
mapping	fieldType	Define the field type. Options: source means field in sourceTable, field means field in other table, value means a pre-defined value.	source	N
mapping	mappingField	Define the field mapped to the voucher.	maintar.cusId	N
mapping	defValue	Define the default value if the value is not exists.	cus	N
mappingFieldHandler	className	Define the class to handle the mapping.	FinanceMappingHandler	Y

lockDate

Usage

Default setting of [Frozen Period Configuration].

Attributes

Element	Name	Description	Example	Required	Default Value
chkDate	name	Define the name of the frozen period type.	02	Y
chkDate	mess	Define the messCode to show the description.	ce01_core.lockDateSc	Y
chkDate	updateType	Define the update type	upStkCost	Y
chkDate	updateMess	Define the update type's messCode.	ce01_trdg.upStkCost	Y
module	name	Define the module name in [Frozen Period Setting]	dn	Y
module	chkDate	Define the frozen period type used for this module.	02	Y
module	skipChk	Indicate if this module should skip the checking of frozen period.	true	N	false
chkField	tableName	Define the table name of the date field for frozen period checking.	maindn	Y
chkField	columnName	Define the column name of the date field in tableName.	tDate	Y

Example

<chkDate name="02" mess="ce01_core.lockDateSc" updateType="upStkCost" updateMess="ce01_trdg.upStkCost"/>
<module name ="dn" chkDate="02">
		<chkField tableName="maindn" columnName="tDate"/>
</module>

Above snippet defined a frozen period type with name = 02. Delivery note(dn) cannot be saved or deleted if tDate is within the frozen period type = 02.

multiflow

Usage

Default setting of [Flow Thru Setup].

Attributes

Element	Name	Description	Example	Required	Default Value
flow	srcModule	Define the source module.	oldso	Y
flow	tarModule	Define the target module.	po	Y
flow	ejbClass	Define the EJB class to handle the process.	xxx.OrderMultiFactory	Y
flow	extend	Indicate if the current element is the extension of any existing element.	ture	N	false
functionField	tableName	Define the table processed by functionHandler.	pot	Y
functionField	fieldName	Define the column processed by functionHandler.	refCode	Y
functionHandler	handlerMethod	Define the method used in handlerClass to handle functionField.	handlerHardcodeField	Y
functionHandler	handlerClass	Define the EJB class to handle functionField.		N	=ejbClass
fieldOption	tableName	Define the table name used in Step4.	pomat	Y
fieldOption	fieldName	Define the field name.	sourceType	Y
fieldOption	optionItem	Define the value of the current option.	pro	Y
fieldOption	optionMess	Define the messcode of the current option.	ce01_core.pro	Y
fieldOption	optionClass	Define the class to handle the option.		Y
fieldOption	optionMethod	Define the method in optionClass to handle the option.		Y
mapping	tarTableName	Define the target table name that the field in the table will be mapped.	pot	Y
mapping	srcTableName	Define the table name used to mapped with the column in tarTableName.	sot	Y
mapping	autoMapping	Indicate if auto mapping should be enabled.	true	N	false
mapping	extend	Indicate if the current element is the extension of any existing element.	true	N	false
field	tarFieldName	Define the target column name to be mapped.	sourceType	Y
field	srcFieldName	Define the column name used to mapped with tarGieldName.	sourceType	N
field	defValue	Define the default value of the target column.		N
field	defFormula	Define the default formula to calculate the value of target column.		N
field	defOption	Define the default fieldOption of the target column.		N
field	skipAutoMapping	Indicate if auto mapping should be skipped.	true	N	false
percentHander	handlerMethod	Define the method name in handlerClass to handle the split percentage.	handlerFooterPercent	Y
percentHander	handlerClass	Define the class to handle the split percentage.	N	=ejbClass
dataOption	name	Define the time when the business flow is created.	save	Y
dataOption	mess	Define the messcode of the time.	core.save	Y

origin

Usage

Define the options of <Price Origin> and <Description Origin> in transaction modules.

Attributes

Element	Name	Description	Example	Required	Default Value
origin	name	Define the origin's name.	PRO	Y
origin	mess	Define the messCode to describe the origin.	ce01_trdg.proMaster	Y
origin	behavior	Define the operation when no data can be retrieved from origin. Options: loadZero means return 0, loadSec means load the data from the second origin.	loadZero	N
origin	extend	Indicate if the current element is the extension of any existing element.	ture	N	false
last	module	Define the source module when origin was set to retrieved from last transaction.	siso	Y
last	selected	Indicate if current item is selected.	true	N	true
last	priority	Define the priority.	1	N
last	extend	Indicate if the current element is the extension of any existing element.	true	N	false

originSetting

Usage

Default setting of Price Origin & Description Origin in [Preference Setup (Trade)].

Attributes

Element	Name	Description	Example	Required	Default Value
price	module	Define the module name.	oldso	Y
price	defValue	Define the default value for the price origin.	SOLAST	N
price	display	Indicate if price origin should be shown.	false	N	true
price	extend	Indicate if the current element is the extension of any existing element.	ture	N	false
desc	module	Define the module name.	oldso	Y
desc	defValue	Define the default value for the description origin.	SOLAST	N
desc	display	Indicate if description origin should be shown.	false	N	true
desc	extend	Indicate if the current element is the extension of any existing element.	true	N	false
option	origin	Define the name of rht price/description origin.	UPLIST	Y
option	ejbClass	Define the EJB class to handle the origin setting.		N
option	ejbMethod	Define the method in ejbClass to handle the origin setting.		N
option	label	Define messCode displayed for the option.		N
option	priority	Define the priority of the options.	1	N	0
option	nonApproved	Indicate if non-approved record should be considered.	true	N	false

refcode

Usage

Define how the customer/vendor reference code is retrieved from the transaction.

Attributes

Element	Name	Description	Example	Required	Default Value
module	name	Define the module's name.	oldso	Y
module	ejbClass	Define the EJB's class name used for retrieving data of Customer/Vendor Part No.	xxx.RefCodeData	N
module	ejbMethod	Define the method name in ejbClass for retrieving data of Customer/Vendor Part No.	getLastRefCode	N
module	extend	Indicate if the current element is the extension of any existing element.	ture	N	false

stkChk

Usage

Define checking logic before stock closed.

Attributes

Element	Name	Description	Example	Required	Default Value
chkItem	name	Define the item's name.	chkApv	Y
chkItem	mess	Define the messCode to describe the item.	ce01_trdg.stkChkApv	Y
chkItem	ejbClass	Define the EJB class to handle the checking.	xxx.StockCheckUtil	Y
chkItem	ejbMethod	Define the method in ejbClass to handle the checking.	chkApv	Y

stkMth

Usage

Define inventory's costing method in [Product/Material].

Attributes

Name	Description	Example	Required	Default Value
name	Define the item's name.	avg	Y
mess	Define messCode for the description.	ce01_core.cost_avg	Y
rendered	Indicate if this item's should be shown in user interface.	true	Y
ejbClass	Define the EJB class for the calculation.	xxx. ERPCostCalc	Y
ejbMethod	Define the mehod in ejbClass for the calculation.	calc_avg	Y

Example

<?xml version="1.0"?>
<stkMth xmlns="http://www.multiable.com/erp/stkMth">
	<stkItem name="avg" mess="ce01_core.cost_avg" rendered="true" ejbClass="com.multiable.erp.trdg.ejb.util.cost.ERPCostCalc" ejbMethod="calc_avg"/>
	<stkItem name="mavg" mess="ce01_core.cost_mavg" rendered="true" ejbClass="com.multiable.erp.trdg.ejb.util.cost.ERPCostCalc" ejbMethod="calc_moving_avg"/>
	<stkItem name="fifo" mess="ce01_core.cost_fifo" rendered="true" ejbClass="com.multiable.erp.trdg.ejb.util.cost.ERPCostCalc" ejbMethod="calc_fifo"/>
	<stkItem name="exact" mess="ce01_core.cost_exact" rendered="#{corePro.getExactUsed()}" ejbClass="com.multiable.erp.trdg.ejb.util.cost.ERPCostCalc" ejbMethod="calc_lotno"/>
</stkMth>

The above code defined 4 commons calculations.

tradeUcOption

Usage

Options of <Exceptions> in [Physical Stock Configuration]. Define the calculation of Inventory Cost when Inventory Cost = 0.

Attributes

Name	Description	Example	Required	Default Value
name	Define the item's name.	an	Y
mess	Define the messCode to describe the item.	ce01_trdg.latestGrn	Y
ejbClass	Define the EJB class to calculate the unit cost.	xxx. TradeUcUtil	Y
ejbMethod	Define the method in ejbClass to calculate the unit cost.	getBaseUc	Y

vatConfig

Usage

Define the formula of fields related to taxation. Default setting of [Tax Recalculation Settings].

Attributes

Element	Name	Description	Example	Required	Default Value
app	name	Define the app name.	ce01_core	Y
app	order	Define the app's order such that the smaller the number of the order, the earlier the formula in the app will be used.	1	Y
fType	code	Define the footer type of the table.	pro	Y
fType	mess	Define messCode to describe the footer type.	ce01_trdg.product	N
var	code	Define the variable's code.	qty	Y
var	mess	Define messCode to describe the variable.	ce01_core.qty	Y
var	value	Define the variable's value.	qty	N
var	fType	Define the footer type that this variable can be used. ; separated.	pro	N
defFormula	fType	Define the footer type that this formula can be used.	pro	Y
defFormula	sField	Define the var that trigger this formula.	qty	Y
defFormula	eField	Define the var that the output of this formula will be assigned to.	preTaxUp	Y
defFormula	enabled	Indicate if this formula is enabled by default.	true	N	false
defFormula	formula	Define the formula.	@D_preTaxUp * @D_qty	N
defFormula	priority	Define the priority of this formula. The lower the number, the earlier it will be triggered.	100	N	0
info	table	Define the table name. if template is true, define the template name.	sot	Y
info	fType	Define which fType will be used.	pro	Y
info	extend	Indicate if the current element is the extension of any existing element.	true	N	false
info	template	Indicate if this info is a template.	N	false
inherit	name	Define the template used.	trdg_template	Y
varmap	code	Define the code in var. Used in field mapping.	afterTaxUp	Y
varmap	field	Define the field name in the table table in info.	up	Y
varmap	alsoTriggeredBy	Define the field that also triggere the same calculation.	unitId	N

Example

<vatConfig xmlns="http://www.multiable.com/vat/vatConfig">

	<fType code="pro" mess="ce01_trdg.product"/>
	
	<var code="preTaxUp" value="preTaxUp" mess="ce01_ztrdgvat.preTaxUp" fType="pro"/>
	<var code="afterTaxUp" value="afterTaxUp" mess="ce01_ztrdgvat.afterTaxUp" fType="pro"/>
	<var code="vatPer" value="vatPer" mess="ce01_vat.vatPer" fType="pro"/>

	<defFormula fType="pro" sField="afterTaxUp" eField="preTaxUp" enabled="true" formula="@D_afterTaxUp/ (1+@D_vatPer/100)" priority="100"/>
	<defFormula fType="pro" sField="afterTaxUp" eField="preTaxAmt" enabled="true" formula="@D_preTaxUp*@D_qty*(1-@D_disc/100)" priority="200"/>
	<defFormula fType="pro" sField="afterTaxUp" eField="afterTaxAmt" enabled="true" formula="@D_afterTaxUp*@D_qty*(1-@D_disc/100)" priority="300"/>
	<defFormula fType="pro" sField="afterTaxUp" eField="taxAmt" enabled="true" formula="@D_afterTaxAmt-@D_preTaxAmt" priority="400"/>

	<info table="trdg_template" template="true" fType="pro">
		<varmap code="qty" field="qty"/>
		<varmap code="preTaxUp" field="preTaxUp"/>
		<varmap code="afterTaxUp" field="up" alsoTriggeredBy="unitId"/>
		<varmap code="disc" field="disc"/>
		<varmap code="vatPer" field="vatPer"/>
		<varmap code="preTaxAmt" field="preTaxAmt"/>
		<varmap code="afterTaxAmt" field="amt"/>
		<varmap code="taxAmt" field="taxAmt"/>	
	</info>
	
	<info table="sot" template="false" fType="pro">
		<inherit name="trdg_template"/>
	</info>
</vatConfig>	

The above XML definded 1 footer type with code = pro, 3 variables, 4 formulas, 1 template and 1 table. The template trdg_template mapped the variables to the real table's field name while the table sot used the template. When variable afterTaxUp or field unitId changed in user interface, it will triggered the formulas and the output will assigned to preTaxUp, preTaxAmt, afterTaxAmt and taxAmt accordingly.

venScore

Usage

Used to generate the options of combo box Vendor in [Turbo Document Generation] and [MRP Generation].

Attributes

Element	name	Description	Example	Required	Default Value
score	name	Define the name of option.	lowestVQuPrice	Y
score	mess	Define the messcode of option.	ce01_trdg.lowestVQuPrice	Y
score	ejbClass	Define the name of the ejbClass to search data of this option		Y
score	ejbMethod	Define the name of the ejbMethod to search data of this option		Y
module	name	Define the module's name	po	Y
module	defValue	Define the default value of combo box	lowestVQuPrice	Y
module-score	name	Define the name of option that corresponds to score's name.	lowestVQuPrice	Y

voucherOption

Usage

Define the options to be grouped when Multiple Transaction is enabled in [Voucher Configuration].

Attributes

Element	Name	Description	Example	Required	Default Value
option	optionValue	Define the option's value.	AIId	Y
option	optionMess	Define messCode to describe the options.	ce01_ac.isSameAIId	Y
option	disabled	Indicate if the option should be disabled.	true	N	false
option	optionCond	Define the variable that determine if the current option should be shown. If getVariable(xxx) in Java Bean return true, it will be shown.	var.enableVirDept	N
config	module	Define the module name.	siso	Y
optionMapping	optionValue	Define the optionValue in option used for mapping.	AIId	Y
optionMapping	optionField	Define the field mapped to optionValue in optionMapping.	cusId	Y

Example

<voucherOption xmlns="http://www.multiable.com/ac/voucherOption">

	<option optionValue="AIId" optionMess="ce01_ac.isSameAIId"/>
	<option optionValue="doctypeId" optionMess="ce01_ac.isSameDocType"/>
	<option optionValue="staffId" optionMess="ce01_ac.isSameStaff" />
	<option optionValue="virDeptId" optionMess="ce01_ac.isSameVirDept" optionCond="var.enableVirDept"/>
	
	<config module="siso">
		<optionMapping optionValue="AIId" optionField="cusId"/>
	</config>
	
	<config module="pi">
		<optionMapping optionValue="AIId" optionField="venId"/>
	</config>
	
</voucherOption>

The above code defined 4 options. cusId in sales invoice is used to map with AIId while venId in purchase invoice is used to map with AIId when generating the vouchers.

acMultiFlow

Usage

Default setting of [Flow Thru Setup (AR&AP)].

Attributes

Element	Name	Description	Example	Required	Default Value
flow	srcModule	Define the source module.	arTran	Y
flow	tarModule	Define the target module.	apTran	Y
flow	ejbClass	Define the EJB class to handle the process.	AcMultiFactory	Y
flow	extend	Indicate if the current element is the extension of any existing element.	true	N	false
mapping	srcTableName	Define the source table. For formula data items.	mainartran	Y
mapping	tarTableName	Define the target table. For destination fields.	mainaptran	Y
mapping	skipSrcFields	Define skip source fields. Not displayed in formula data items.	AIId,AIType	N
mapping	skipTarFields	Define skip target fields. Not displayed in destination fields.	AIId,AIType	N
field	fieldName	Define default field.	mainaptran.code	Y
field	defFormula	Define default formula.	@D_mainartran_code	N

chequeSetting

Usage

Default setting of [Cheque Payment Management]. Used to define the data source of cheque.

Attributes

Element	Name	Description	Example	Required	Default Value
setting	module	Define the cheque module.	jl	Y
setting	mainTable	Define the main table.	maint	Y
setting	payeeTable	Define the cheque table.	t	Y
setting	filterSearch	Define the default filter criteria for the cheque module.	jlChequeFilter	N
setting	ejbClass	Define the EJB class to load data.	ChequeSettingEJB	N
setting	ejbMethod	Define the mehtod in ejbClass to load data.	loadData	N
setting	extend	Indicate if the current element is the extension of any existing element.	true	N	false
filterField	tableName	Define the table used in the filter.	maint	Y
filterField	fieldName	Define the field used in the filter.	id	Y
filterField	mess	Define the messcode of field.	ce01_ac.journalVoucher	N
filterField	pattern	Define the pattern of field.	jl	N

bsflowProd

Usage

Used to define the source transaction in different modules. Module defined in this XML will be shown in [Business Process Setup (Production)].

Attributes

element	attribute	Description	Example	Required	Default Value
flow	module	Define the current module.	prodMjob	Y
flow	compId	Define the component's id used to store the lookup data. If the lookup field is inside an edittable, please use the id of the edittable.	mainFooter_proId	N	mainfooter
flow	skipModule	Define the module that must included in data source.	pro	N
flow	extend	Indicate if the current element is the extension of any existing element.	false	N	false
flow	disablePro	If true and target module set to current module in [Business Process Setup (Production)], <Allow Product/Material in Data Destination without Data Source> will be false and disabled.	false	N	false
flow	proCompId	Define the component's id used to store the lookup data. If the product field is not on the same table as the source document field, you need to set it.	mainFooter_proId	N	mainfooter
item	sourceType	Define the source transaction type.	oldqu	Y
item	mess	Define the messCode to describe the source transaction type.	ce01_trdg.salesQu	N	=sourceType的mess
item	moduleLookupType	Define the lookup type used for the source transaction.	multiqu	Y
item	moduleField	Define the lookup field used for the source transaction.	jobId	N	sourceId
item	midLookupType	Define the lookup type used for the midField.	prodJobMulti	N
item	midField	Define the lookup field used for the middle transaction.For example, [Shop Floor Material Pickingt] reads [Work Process Dispatch Note], and the middle layer lookup is [Job Order], so it is set to jobId.	jobId	N
item	keyLookupType	key field的lookup type	sofooter	Y
item	singleFlowType	Indicate if same source type can only assigned to one module in the same business flow setting.	true	N	false
item	loadDataHelper	Define the handler used when retrieving data from source transaction.	TradeOSHelper	N
item	checkFlowType	Need to check the business process	false	N	true
item	loadOutstanding	Indicate if outstanding quantity should be loaded.	true	N	false
item	loadDisc	Indicate if discount or charge should be loaded.	true	N	false
item	loadRemarks	Indicate if remarks should be loaded.	true	N	false
item	useOrigin	Indicate if price origin and description origin should be used.	true	N	false
item	skipCheckLoad	If false, when open the source transaction, if it has been loaded to the module in flow, the transaction is prohibited from changing the customer/vendor/business flow/currency/rate.	true	N	false
item	checkSFFlag	Indicate if source transaction can be deleted if used in the the current module.	p:Representative purchased QC function	N
item	checkFK	Define the SF that determines if this transaction type is available	true	N	true

fkCheck

Usage

Define a foreign key check for a source document and a target document.

Attributes

element	attribute	Description	Example	Required	Default Value
checker	module	Define the current module.	prodPdn	Y
checker	extend	Indicate if the current element is the extension of any existing element.	false	N	false
item	checkId	Check project name	prodPdn_prodPw_proId	Y
item	srcTable	Source table name	prodpdnt	Y
item	refTable	Target table name	prodpwt	Y
item	chkKeyCol	Source field name	hId;proId;lot	Y
item	refKeyCol	Target field name	sourceId;proId;sourceLot	Y
item	keyField	Source document field name of the target document	sourceId	Y
item	chkField	The source document corresponds to the field name of the header table.	hId	Y
item	refField	The target document corresponds to the field name of the header table.	hId	Y
item	chkCond	Conditions of the source document footer table.		N
item	refCond	Conditions of the target document footer table.	b.sourceType in ('prodPdn')	N
item	refMainTable	The header table name of the target document	prodmainpw	Y
item	refMainKeyCol	The code field name of the target document	code	Y
item	refMainField	The id field name of the target document	id	Y
item	refMainCond	Conditions of the target document header table.		N

prodOriginSetting

Usage

The default configuration of the process price setting in [Preference Setup (Trade)].

Attributes

element	attribute	Description	Example	Required	Default Value
processPrice	module	Define the module name.	pdcoreSjob	Y
processPrice	defValue	Define the default value for the price origin.	PROCESSLAST	N
processPrice	display	Indicate if price origin should be shown.	false	N	true
processPrice	extend	Indicate if the current element is the extension of any existing element.	ture	N	false
option	origin	Define the name of rht price origin.	SQUPROCESS	Y
option	ejbClass	Define the EJB class to handle the origin setting.		N
option	ejbMethod	Define the method in ejbClass to handle the origin setting.		N
option	label	Define messCode displayed for the option.		N
option	priority	Define the priority of the options.	1	N	0
option	nonApproved	Indicate if non-approved record should be considered.	true	N	false

moduleStatus

Usage

The option of [User Defined Status Setup] defines the state that a module can be configured.

Attributes

element	attribute	Description	Example	Required	Default Value
module	name	Define the module name.	oldso	Y
module	extend	Indicate if the current element is the extension of any existing element.	ture	N	false
optionField	fieldName	'Display in Field' field name	shipedStatus	Y
optionField	fieldMess	'Display in Field' field label	ce01_trdg.shipedStatus	Y
optionField	defaultUpdateMethod	Default status update method	autoUpdate	N
optionField	extend	Indicate if the current element is the extension of any existing element.	ture	N	false
optionStatus	statusName	Status Code	notYetDelivered	Y
optionStatus	statusMess	Status Name	ce01_trdg.notYetDelivered	Y
optionStatus	infoMess	Status Condition	ce01_trdg.notYetDeliveredInfo	N
optionStatus	moduleStatusHelper	State processing interface	SOShipmentStatus	Y
optionStatus	refModules	Relevant Modules	oldso,dn,siso	Y
optionStatus	udfComboPattern	The pattern name of 'Extended Option'.	trdg_soShipmentOption	Y
optionStatus	defaultOrder	Priority for sorting the status	30	Y
optionStatus	defaultModuleFilter	Module filter condition		N
optionStatus	extend	Indicate if the current element is the extension of any existing element.	ture	N	false

prqGenSetting

Usage

Target module configuration of [MRP Generation].

Attributes

element	attribute	Description	Example	Required	Default Value
module	name	Define the module name.	oldso	Y
module	menuParam	The module parameter is used to filter the parameters displayed by the target module.	prod	N	pur
module	genFooterName	The footer table name of target module.	pot	N	The footer table name of the target module
module	extend	Indicate if the current element is the extension of any existing element.	ture	N	false
optionField	fieldName	Module Option Setting: field name	virDeptId	Y
optionField	fieldMess	Module Option Setting: field label	ce01_core.virDept	Y
optionField	editType	Module Option Setting: field type	lookupField	Y
optionField	pattern	Module Option Setting: field pattern	core_virDept	Y
optionField	showCond	Module Option Setting: visible	var.enableVirDept	N
optionField	requiredCond	Module Option Setting: required	var.enableVirDept	N
optionField	expired	Module Option Setting: expired	true	N	false
optionField	extend	Indicate if the current element is the extension of any existing element.	ture	N	false
showField	fieldName	Footer table: field name	virDeptId	Y
showField	fieldMess	Footer table: field label	ce01_core.virDept	Y
showField	editType	Footer table: field type	cawLookup	Y
showField	pattern	Footer table: field pattern	core_virDept	Y
showField	fieldClass	Footer table: java type	Long	N
showField	showAfter	Footer table: the current field is placed after the set field	virDeptId	N
showField	showCond	Footer table: visible	var.enableVirDept	N
showField	readonlyCond	Footer table: read only	false	N
showField	requiredCond	Footer table: required	var.enableVirDept	N
showField	expired	expired	true	N
showField	footerField	Whether it is the footer table field (when the same name as the header table)	true	N	false
showField	batchUpdate	Whether the field supports batch update	true	N	false
showField	extend	Indicate if the current element is the extension of any existing element.	ture	N	false