|
Field Name
|
Data Type
|
Description
|
|
bisg_param.auth
|
Character
|
THISNODE
|
|
bisg_param.rec_num
|
Integer
|
510
|
|
bisg_param.flag[2]
|
Logical
|
Transfer Exchange Rate Information from QAD ERP to QAD CRM
|
|
Field Mapping
CRM Field Name
|
CRM Field Label
|
ERP Field Name
|
ERP Field Label
|
ERP > CRM
|
CRM > ERP
|
|
exchrate.auth
|
Unit ID
|
exr_rate.exr_domain
|
Domain
|
Yes
|
No
|
|
exchrate.curr1
|
Currency 1
|
exr_rate.exr_curr1
|
Curr1
|
Yes
|
No
|
|
exchrate.curr2
|
Currency 2
|
exr_rate.exr_curr2
|
Curr2
|
Yes
|
No
|
|
exchrate.start_date
|
Start Date
|
exr_rate.exr_start_date
|
Start
|
Yes
|
No
|
|
exchrate.end_date
|
End Date
|
exr_rate.exr_end_date
|
End Date
|
Yes
|
No
|
|
exchrate.rate
|
Currency 1 Units
|
exr_rate.exr_rate
|
Units
|
Yes
|
No
|
|
exchrate.rate2
|
Currency 2 Units
|
exr_rate.exr_rate2
|
Units
|
Yes
|
No
|
|
exchrate.rec_owner
|
Record Owner
|
“M“
|
-
|
-
|
-
|
|
exchrate.created_by
|
Created By
|
global_userid
|
-
|
-
|
-
|
|
exchrate.modified_by
|
Modified By
|
global_userid
|
-
|
-
|
-
|