|
Field Name
|
Data Type
|
Description
|
|
bisg_param.auth
|
Character
|
THISNODE
|
|
bisg_param.rec_num
|
Integer
|
506
|
|
bisg_param.flag[1]
|
Logical
|
Transfer Customer Address from QAD ERP to QAD CRM
|
|
bisg_param.flag[2]
|
Logical
|
Transfer Customer Ship-to Address from QAD ERP to QAD CRM
|
|
bisg_param.flag[3]
|
Logical
|
Transfer Customer Enduser Address from QAD ERP to QAD CRM
|
|
bisg_param.flag[4]
|
Logical
|
Transfer Supplier Address from QAD ERP to QAD CRM
|
|
bisg_param.flag[5]
|
Logical
|
Transfer Supplier Remit-to Address from QAD ERP to QAD CRM
|
|
bisg_param.flag[6]
|
Logical
|
Transfer Profile from QAD CRM to QAD ERP
|
|
bisg_param.flag[7]
|
Logical
|
Transfer site_adr(Remit-to and Ship-to) from QAD CRM to QAD ERP
|
|
CRM Field Name
|
CRM Field Label
|
ERP Field Name
|
ERP Field Label
|
ERP > CRM
|
CRM > ERP
|
|
prospect.auth
|
Unit ID
|
cm_mstr.cm_domain
|
Domain
|
Yes
|
Yes
|
|
prospect.integration_type
|
Integration Type
|
MFG
|
-
|
-
|
-
|
|
prospect.erp_status
|
ERP Status
|
CUSTOMER
|
-
|
-
|
-
|
|
prospect.type
|
Type
|
prospect.type + cm_mstr.cm_type
|
Type
|
Yes
|
No
|
|
prospect.cust_no
|
Cust. No
|
cm_mstr.cm_addr
|
Customer
|
Yes
|
No
|
|
prospect.acnt_mngr
|
Ext A/C Mgr
|
If available users then cm_slspsn
|
-
|
Yes
|
Yes
|
|
prospect.alias_name
|
Alias name
|
cm_mstr.cm_sort
|
Sort Name
|
Yes
|
Yes
|
|
prospect.cred_limit
|
Cr Limit
|
cm_mstr.cm_cr_limit
|
Credit Limit
|
Yes
|
No
|
|
prospect.nme
|
Profile Name
|
ad_mstr.ad_name
|
Name
|
Yes
|
Yes
|
|
prospect.curr_code
|
Currency
|
cm_mstr.cm_curr
|
Currency
|
Yes
|
Yes
|
|
prospect.adres[1]
|
Address[1]
|
ad_mstr.ad_line1
|
Address
|
Yes
|
Yes
|
|
prospect.adres[2]
|
Address[2]
|
ad_mstr.ad_line2
|
Address
|
Yes
|
Yes
|
|
prospect.adres[3]
|
Address[3]
|
ad_mstr.ad_line3
|
Address
|
Yes
|
Yes
|
|
prospect.twn
|
Town/City
|
ad_mstr.ad_city
|
City
|
Yes
|
Yes
|
|
prospect.state
|
State
|
ad_mstr.ad_state
|
State
|
Yes
|
Yes
|
|
prospect.cty
|
County
|
ad_mstr.ad_county
|
County
|
Yes
|
Yes
|
|
prospect.ctry
|
Country
|
ad_mstr.ad_ctry
|
Country Code
|
Yes
|
Yes
|
|
prospect.cde
|
Post Code
|
ad_mstr.ad_zip
|
Post
|
Yes
|
Yes
|
|
prospect.tel[1]
|
Tel No[1]
|
ad_mstr.ad_phone
|
Telephone
|
Yes
|
Yes
|
|
prospect.tel[2]
|
Tel No[2]
|
ad_mstr.ad_phone2
|
Telephone
|
Yes
|
Yes
|
|
prospect.tel[1]
|
Tel No[1]
|
ad_mstr.ad_ext
|
Ext
|
Yes
|
Yes
|
|
prospect.tel[2]
|
Tel No[2]
|
ad_mstr.ad_ext2
|
Ext
|
Yes
|
Yes
|
|
prospect.fax
|
Fax No
|
ad_mstr.ad_fax
|
Fax/Telex
|
Yes
|
Yes
|
|
prospect.tzone_code
|
Time zone
|
ad_mstr.ad_timezone
|
Time Zone
|
Yes
|
Yes
|
|
prospect.bill_to
|
Bill to
|
cm_mstr.cm_bill
|
Bill-To
|
Yes
|
Yes
|
|
prospect.reg
|
Region
|
cm_mstr.cm_region
|
Region
|
Yes
|
No
|
|
prospect.credit_hold
|
Credit Hold
|
cm_mstr.cm_cr_hold
|
Credit Hold
|
Yes
|
No
|
|
prospect.udf_char01
|
Credit Rating
|
cm_mstr.cm_cr_rating
|
Credit Rating
|
Yes
|
No
|
|
prospect.udf_char02
|
Terms
|
cm_mstr.cm_cr_terms
|
Terms
|
Yes
|
No
|
|
prospect.udf_char03
|
DB Number
|
cm_mstr.cm_db
|
DB Number
|
Yes
|
No
|
|
prospect.udf_char04
|
Site
|
cm_mstr.cm_site
|
Site
|
Yes
|
No
|
|
prospect.udf_char05
|
Stmt Cycle
|
cm_mstr.cm_stmt_cyc
|
Stmt Cycle
|
Yes
|
No
|
|
prospect.udf_char07
|
Customer Type
|
cm_mstr.cm_type
|
Type
|
Yes
|
Yes
|
|
prospect.udf_char08
|
Customer Class
|
cm_mstr.cm_class
|
Class
|
Yes
|
Yes
|
|
prospect.udf_date01
|
Last Credit Review
|
cm_mstr.cm_cr_review
|
Last Credit Review
|
Yes
|
No
|
|
prospect.udf_date02
|
Last Credit Updated
|
cm_mstr.cm_cr_update
|
Last Credit Updated
|
Yes
|
No
|
|
prospect.udf_dec01
|
Disc %
|
cm_mstr.cm_disc_pct
|
Disc%
|
Yes
|
No
|
|
prospect.udf_log01
|
Dun Letter
|
cm_mstr.cm_dun
|
Dun Letter
|
Yes
|
No
|
|
prospect.udf_log02
|
Finance Chg
|
cm_mstr.cm_fin
|
Finance Chg
|
Yes
|
No
|
|
prospect.udf_log03
|
PO Required
|
cm_mstr.cm_po_reqd
|
PO Required
|
Yes
|
No
|
|
prospect.udf_log04
|
Statement
|
cm_mstr.cm_stmt
|
Statement
|
Yes
|
No
|
|
prospect.created_by
|
Created By
|
global_userid
|
-
|
-
|
-
|
|
prospect.modified_by
|
Modified By
|
global_userid
|
-
|
-
|
-
|
|
CRM Field Name
|
CRM Field Label
|
ERP Field Name
|
ERP Field Label
|
ERP > CRM
|
CRM > ERP
|
|
site_adr.auth
|
Unit ID
|
ad_mstr.ad_domain
|
Domain
|
Yes
|
No
|
|
site_adr.adr_type
|
Address Type
|
ls_mstr.ls_type
|
List Type
|
Yes
|
No
|
|
site_adr.nme
|
Profile Name
|
ad_mstr.ad_name
|
Name
|
Yes
|
Yes
|
|
site_adr.adres[1]
|
Address[1]
|
ad_mstr.ad_line1
|
Address
|
Yes
|
Yes
|
|
site_adr.adres[2]
|
Address[2]
|
ad_mstr.ad_line2
|
Address
|
Yes
|
Yes
|
|
site_adr.adres[3]
|
Address[3]
|
ad_mstr.ad_line3
|
Address
|
Yes
|
Yes
|
|
site_adr.twn
|
Town/City
|
ad_mstr.ad_city
|
City
|
Yes
|
Yes
|
|
site_adr.state
|
State
|
ad_mstr.ad_state
|
State
|
Yes
|
Yes
|
|
site_adr.cty
|
County
|
ad_mstr.ad_county
|
County
|
Yes
|
Yes
|
|
site_adr.ctry
|
Country
|
ad_mstr.ad_ctry
|
Country Code
|
Yes
|
Yes
|
|
site_adr.cde
|
Post Code
|
ad_mstr.ad_zip
|
Post
|
Yes
|
Yes
|
|
site_adr.tel[1]
|
Tel No[1]
|
ad_mstr.ad_phone
|
Telephone
|
Yes
|
Yes
|
|
site_adr.tel[2]
|
Tel No[2]
|
ad_mstr.ad_phone2
|
Telephone
|
Yes
|
Yes
|
|
site_adr.tel[1]
|
Tel No[1]
|
ad_mstr.ad_ext
|
Ext
|
Yes
|
Yes
|
|
site_adr.tel[2]
|
Tel No[2]
|
ad_mstr.ad_ext2
|
Ext
|
Yes
|
Yes
|
|
site_adr.fax
|
Fax
|
ad_mstr.ad_fax
|
Fax/Telex
|
Yes
|
Yes
|
|
site_adr.external_id
|
External Id
|
ad_mstr.ad_addr
|
Address
|
Yes
|
No
|
|
site_adr.reference
|
Reference
|
ad_mstr.ad_ref
|
Reference
|
Yes
|
No
|
|
site_adr.tzone_code
|
Time zone
|
ad_mstr.ad_timezone
|
Time Zone
|
Yes
|
No
|
|
site_adr.created_by
|
Created By
|
global_userid
|
-
|
-
|
-
|
|
site_adr.modified_by
|
Modified By
|
global_userid
|
-
|
-
|
-
|
|
site_adr.alias_name
|
Alias Name
|
ad_mstr.ad_sort
|
Sort Name
|
Yes
|
Yes
|
|
CRM Field Name
|
CRM Field Label
|
ERP Field Name
|
ERP Field Label
|
ERP > CRM
|
CRM > ERP
|
|
prospect.auth
|
Unit ID
|
vd_mstr.vd_domain
|
Domain
|
Yes
|
No
|
|
prospect.integration_type
|
Integration Type
|
MFG
|
-
|
-
|
-
|
|
prospect.erp_status
|
ERP Status
|
“SUPPLIER”
|
-
|
-
|
-
|
|
prospect.type
|
Type
|
prospect.type + 'Supplier'
|
-
|
-
|
-
|
|
prospect.cust_no
|
Cust. No
|
vd_mstr.vd_addr
|
Supplier
|
Yes
|
No
|
|
prospect.curr_code
|
Currency
|
vd_mstr.vd_curr
|
Currency
|
Yes
|
No
|
|
prospect.alias_name
|
Alias name
|
vd_mstr.vd_sort
|
Sort Name
|
Yes
|
Yes
|
|
prospect.nme
|
Profile Name
|
ad_mstr.ad_name
|
Name
|
Yes
|
Yes
|
|
prospect.adres[1]
|
Address[1]
|
ad_mstr.ad_line1
|
Address
|
Yes
|
Yes
|
|
prospect.adres[2]
|
Address[2]
|
ad_mstr.ad_line2
|
Address
|
Yes
|
Yes
|
|
prospect.adres[3]
|
Address[3]
|
ad_mstr.ad_line3
|
Address
|
Yes
|
Yes
|
|
prospect.twn
|
Town/City
|
ad_mstr.ad_city
|
City
|
Yes
|
Yes
|
|
prospect.state
|
State
|
ad_mstr.ad_state
|
State
|
Yes
|
Yes
|
|
prospect.cty
|
County
|
ad_mstr.ad_county
|
County
|
Yes
|
Yes
|
|
prospect.ctry
|
Country
|
ad_mstr.ad_ctry
|
Country Code
|
Yes
|
Yes
|
|
prospect.cde
|
Post Code
|
ad_mstr.ad_zip
|
Post
|
Yes
|
Yes
|
|
prospect.tel[1]
|
Tel No[1]
|
ad_mstr.ad_phone
|
Telephone
|
Yes
|
Yes
|
|
prospect.tel[2]
|
Tel No[2]
|
ad_mstr.ad_phone2
|
Telephone
|
Yes
|
Yes
|
|
prospect.tel[1]
|
Tel No[1]
|
ad_mstr.ad_ext
|
Ext
|
Yes
|
Yes
|
|
prospect.tel[2]
|
Tel No[2]
|
ad_mstr.ad_ext2
|
Ext
|
Yes
|
Yes
|
|
prospect.fax
|
Fax No
|
ad_mstr.ad_fax
|
Fax/Telex
|
Yes
|
Yes
|
|
prospect.tzone_code
|
Time zone
|
ad_mstr.ad_timezone
|
Time Zone
|
Yes
|
Yes
|
|
prospect.udf_char06
|
Terms
|
vd_mstr.vd_cr_terms
|
Terms
|
Yes
|
No
|
|
prospect.udf_dec02
|
Disc%
|
vd_mstr.vd_disc_pct
|
Disc%
|
Yes
|
No
|
|
prospect.udf_log05
|
Payment Hold
|
vd_mstr.vd_hold
|
Payment Hold
|
Yes
|
No
|
|
prospect.created_by
|
Created By
|
global_userid
|
-
|
-
|
-
|
|
prospect.modified_by
|
Modified By
|
global_userid
|
-
|
-
|
-
|
|
CRM Field Name
|
CRM Field Label
|
ERP Field Name
|
ERP Field Label
|
ERP > CRM
|
CRM > ERP
|
|
site_adr.auth
|
Unit ID
|
ad_mstr.ad_domain
|
Domain
|
Yes
|
No
|
|
site_adr.adr_type
|
Address Type
|
'Remit-to'
|
-
|
-
|
-
|
|
site_adr.nme
|
Profile Name
|
ad_mstr.ad_name
|
Name
|
Yes
|
Yes
|
|
site_adr.adres[1]
|
Address[1]
|
ad_mstr.ad_line1
|
Address
|
Yes
|
Yes
|
|
site_adr.adres[2]
|
Address[2]
|
ad_mstr.ad_line2
|
Address
|
Yes
|
Yes
|
|
site_adr.adres[3]
|
Address[3]
|
ad_mstr.ad_line3
|
Address
|
Yes
|
Yes
|
|
site_adr.twn
|
Town/City
|
ad_mstr.ad_city
|
City
|
Yes
|
Yes
|
|
site_adr.state
|
State
|
ad_mstr.ad_state
|
State
|
Yes
|
Yes
|
|
site_adr.cty
|
County
|
ad_mstr.ad_county
|
County
|
Yes
|
Yes
|
|
site_adr.ctry
|
Country
|
ad_mstr.ad_ctry
|
Country Code
|
Yes
|
Yes
|
|
site_adr.cde
|
Post Code
|
ad_mstr.ad_zip
|
Post
|
Yes
|
Yes
|
|
site_adr.tel[1]
|
Tel No[1]
|
ad_mstr.ad_phone
|
Telephone
|
Yes
|
Yes
|
|
site_adr.tel[2]
|
Tel No[2]
|
ad_mstr.ad_phone2
|
Telephone
|
Yes
|
Yes
|
|
site_adr.tel[1]
|
Tel No[1]
|
ad_mstr.ad_ext
|
Ext
|
Yes
|
Yes
|
|
site_adr.tel[2]
|
Tel No[2]
|
ad_mstr.ad_ext2
|
Ext
|
Yes
|
Yes
|
|
site_adr.fax
|
Fax
|
ad_mstr.ad_fax
|
Fax/Telex
|
Yes
|
Yes
|
|
site_adr.external_id
|
External Id
|
vd_mstr.vd_remit
|
Remit-to
|
Yes
|
No
|
|
site_adr.tzone_code
|
Time zone
|
ad_mstr.ad_timezone
|
Time Zone
|
Yes
|
Yes
|
|
site_adr.alias_name
|
Alias name
|
ad_mstr.ad_sort
|
Sort Name
|
Yes
|
Yes
|
|
site_adr.created_by
|
Created By
|
global_userid
|
-
|
-
|
-
|
|
site_adr.modified_by
|
Modified By
|
global_userid
|
-
|
-
|
-
|
|
CRM Field Name
|
CRM Field Label
|
ERP Field Name
|
ERP Field Label
|
ERP > CRM
|
CRM > ERP
|
|
prospect.auth
|
Unit ID
|
eu_mstr.eu_domain
|
Domain
|
Yes
|
No
|
|
prospect.integration_type
|
Integration Type
|
“MFG“
|
-
|
-
|
-
|
|
prospect.erp_status
|
ERP Status
|
“ENDUSER“
|
-
|
-
|
-
|
|
prospect.type
|
Type
|
prospect.type + 'EndUser'
|
-
|
-
|
-
|
|
prospect.cust_no
|
Cust. No
|
eu_mstr.eu_addr
|
End User
|
Yes
|
No
|
|
prospect.alias_name
|
Alias name
|
eu_mstr.eu_sort
|
Name
|
Yes
|
Yes
|
|
prospect.nme
|
Profile Name
|
ad_mstr.ad_name
|
Name
|
Yes
|
Yes
|
|
prospect.adres[1]
|
Address[1]
|
ad_mstr.ad_line1
|
Address
|
Yes
|
Yes
|
|
prospect.adres[2]
|
Address[2]
|
ad_mstr.ad_line2
|
Address
|
Yes
|
Yes
|
|
prospect.adres[3]
|
Address[3]
|
ad_mstr.ad_line3
|
Address
|
Yes
|
Yes
|
|
prospect.twn
|
Town/City
|
ad_mstr.ad_city
|
City
|
Yes
|
Yes
|
|
prospect.state
|
State
|
ad_mstr.ad_state
|
State
|
Yes
|
Yes
|
|
prospect.cty
|
County
|
ad_mstr.ad_county
|
County
|
Yes
|
Yes
|
|
prospect.ctry
|
Country
|
ad_mstr.ad_ctry
|
Country Code
|
Yes
|
Yes
|
|
prospect.cde
|
Post Code
|
ad_mstr.ad_zip
|
Post
|
Yes
|
Yes
|
|
prospect.tel[1]
|
Tel No[1]
|
ad_mstr.ad_phone
|
Telephone
|
Yes
|
Yes
|
|
prospect.tel[2]
|
Tel No[2]
|
ad_mstr.ad_phone2
|
Telephone
|
Yes
|
Yes
|
|
prospect.tel[1]
|
Tel No[1]
|
ad_mstr.ad_ext
|
Ext
|
Yes
|
Yes
|
|
prospect.tel[2]
|
Tel No[2]
|
ad_mstr.ad_ext2
|
Ext
|
Yes
|
Yes
|
|
prospect.fax
|
Fax No
|
ad_mstr.ad_fax
|
Fax/Telex
|
Yes
|
Yes
|
|
prospect.tzone_code
|
Time zone
|
ad_mstr.ad_timezone
|
Time Zone
|
Yes
|
Yes
|
|
prospect.udf_dec03
|
Disc%
|
eu_mstr.eu_disc_pct
|
Disc%
|
Yes
|
No
|
|
prospect.udf_log06
|
PO Required
|
eu_mstr.eu_po_reqd
|
PO Required
|
Yes
|
No
|
|
prospect.created_by
|
Created By
|
global_userid
|
-
|
-
|
-
|
|
prospect.modified_by
|
Modified By
|
global_userid
|
-
|
-
|
-
|