Contract

Field Name	Data Type	Description
bisg_param.auth	Character	THISNODE
bisg_param.rec_num	Integer	504
bisg_param.flag[1]	Logical	Transfer Service Contracts from QAD ERP to QAD CRM
bisg_param.flag[2]	Logical	Allow Creation of Contracts in QAD CRM


CRM Field Name	CRM Field Label	ERP Field Name	ERP Field Label	ERP > CRM	CRM > ERP
contract_hdr.auth	Unit ID	sa_mstr.sa_domain	Domain	Yes	No
contract_hdr.contract_no	Contract no.	sa_mstr.sa_nbr	Number	Yes	No
contract_hdr.contract_type	Contract type	sa_mstr.sa_type	Type	Yes	No
contract_hdr.service_type	Service type	sa_mstr.sa_sv_code	Service Type	Yes	No
contract_hdr.integration_type	Integration type	MFG	-	-	-
contract_hdr.txt	Remarks	QAD ERP	-	-	-
contract_hdr.project	Project	sa_mstr.sa_project	Project	Yes	No
contract_hdr.fix_rate	Fixed rate	sa_mstr.sa_fix_rate	Fixed Rate	Yes	No
contract_hdr.channel	Channel	sa_mstr.sa_channel	Channel	Yes	No
contract_hdr.site	Site	sa_mstr.sa_site	Site	Yes	No
contract_hdr.ctr_lang	Language	sa_mstr.sa_lang	Language	Yes	No
contract_hdr.taxable	Taxable	sa_mstr.sa_taxable	Taxable	Yes	No
contract_hdr.price_list	Price list	sa_mstr.sa_pr_list	Price List	Yes	No
contract_hdr.credit_term	Credit terms	sa_mstr.sa_cr_terms	Credit Terms	Yes	No
contract_hdr.trl3_amt	Trailer amount 3	sa_mstr.sa_trl3_amt	Trailer Amt 3	Yes	No
contract_hdr.trl2_amt	Trailer amount 2	sa_mstr.sa_trl2_amt	Trailer Amt 2	Yes	No
contract_hdr.trl1_amt	Trailer amount 1	sa_mstr.sa_trl1_amt	Trailer Amt 1	Yes	No
contract_hdr.trl3_cd	Trailer 3	sa_mstr.sa_trl3_cd	Trailer 3	Yes	No
contract_hdr.trl2_cd	Trailer 2	sa_mstr.sa_trl2_cd	Trailer 2	Yes	No
contract_hdr.trl1_cd	Trailer 1	sa_mstr.sa_trl1_cd	Trailer 1	Yes	No
contract_hdr.disc	Discount %	sa_mstr.sa_disc_pct	Disc %	Yes	No
contract_hdr.exch_rate	Exchange rate	sa_mstr.sa_ex_rate	Exch Rate	Yes	No
contract_hdr.curr_code	Currency	sa_mstr.sa_curr	Currency	Yes	No
contract_hdr.cancellation_date	Cancellation date	sa_mstr.sa_cancel	Cancel Date	Yes	No
contract_hdr.next_bill	Next bill	sa_mstr.sa_nxt_bill	Next Bill	Yes	No
contract_hdr.last_bill	Last billed	sa_mstr.sa_last_bill	Last Billed	Yes	No
contract_hdr.bill_freq	Bill frequency	sa_mstr.sa_cycle	Billing Cycle	Yes	No
contract_hdr.po_no	Purchase order	sa_mstr.sa_po	Purchase Order	Yes	No
contract_hdr.end_date	End date	sa_mstr.sa_end_date	End Date	Yes	No
contract_hdr.start_date	Start date	sa_mstr.sa_st_date	Start Date	Yes	No
contract_hdr.order_date	Order date	sa_mstr.sa_ord_date	Order Date	Yes	No
contract_hdr.created_by	Created By	global_userid	-	-	-
contract_hdr.modified_by	Modified By	global_userid	-	-	-


CRM Field Name	CRM Field Label	ERP Field Name	ERP Field Label	ERP > CRM	CRM > ERP
contract_line.auth	Unit ID	sad_det.sad_domain	Domain	Yes	No
contract_line.contract_no	Contract no.	sad_det.sad_nbr	Contract	Yes	No
contract_line.contract_type	Contract type	sad_det.sad_prefix	Pf	Yes	No
contract_line.line_no	Line no.	sad_det.sad_line	Contract Line	Yes	No
contract_line.service_type	Service type	sad_det.sad_sv_code	Service Type	Yes	No
contract_line.bill_freq	Bill frequency	sad_det.sad_cycle	Billing Cycle	Yes	No
contract_line.end_date	End date	sad_det.sad_end_date	End Date	Yes	No
contract_line.start_date	Start date	sad_det.sad_st_date	Start Date	Yes	No
contract_line.qty_per	Duration	sad_det.sad_qty_per	Duration	Yes	No
contract_line.line_type	Line type	sad_det.sad_line_type	Line Type	Yes	No
contract_line.curr_code	Currency	sad_det.sad_curr	Currency	Yes	No
contract_line.exch_rate	Exchange Rate	sad_det.sad_ex_rate	Exch Rate	Yes	No
contract_line.disc	Discount %	sad_det.sad_disc_pct	Disc %	Yes	No
contract_line.unit_price	Unit price	sad_det.sad_list_pr	List Price	Yes	No
contract_line.net_price	Net price	sad_det.sad_price	Net Price	Yes	No
contract_line.serial_no	Serial no.	sad_det.sad_serial	Lot/Serial	Yes	No
contract_line.qty	Quantity	sad_det.sad_qty_item	Item Quantity	Yes	No
contract_line.prod_line	Product line	sad_det.sad_prodline	Product Line	Yes	No
contract_line.prod_id	Product ID	sad_det.sad_for	Supported Item	Yes	No
contract_line.created_by	Created By	global_userid	-	-	-
contract_line.modified_by	Modified By	global_userid	-	-	-