|
Field Name
|
Data Type
|
Description
|
|
bisg_param.auth
|
Character
|
THISNODE
|
|
bisg_param.rec_num
|
Integer
|
503
|
|
bisg_param.flag[1]
|
Logical
|
Transfer Installed Base information from QAD ERP to QAD CRM
|
|
bisg_param.flag[2]
|
Logical
|
Transfer Parents
|
|
bisg_param.flag[3]
|
Logical
|
Transfer Components
|
|
bisg_param.flag[6]
|
Logical
|
Transfer unconfigured Products
|
|
bisg_param.flag[4]
|
Logical
|
Allow addition of Installed Base information in QAD CRM
|
|
bisg_param.flag[5]
|
Logical
|
Allow deletion of Installed Base information in QAD CRM
|
|
CRM Field Name
|
CRM Field Label
|
ERP Field Name
|
ERP Field Label
|
ERP > CRM
|
CRM > ERP
|
|
profitem.auth
|
Unit ID
|
isb_mstr.isb_domain
|
Domain
|
Yes
|
No
|
|
profitem.prod_id
|
Product ID
|
isb_mstr.isb_part
|
Item Number
|
Yes
|
No
|
|
profitem.rec_owner
|
Record Owner
|
M
|
-
|
-
|
-
|
|
profitem.integration_type
|
Integration Type
|
MFG
|
-
|
-
|
-
|
|
profitem.item_status
|
Status
|
Isb_mstr.isb_status
|
Status
|
Yes
|
No
|
|
profitem.qty
|
Quantity
|
isb_mstr.isb_qty
|
Qty
|
Yes
|
No
|
|
profitem.install_date
|
Installed date
|
isb_mstr.isb_ins_date
|
Install Date
|
Yes
|
No
|
|
profitem.curr_code
|
Currency
|
ih_hist.ih_curr
|
Currency
|
Yes
|
No
|
|
profitem.sale_order_no
|
Sales Order No
|
isb_mstr.isb_so_nbr
|
Sales Order
|
Yes
|
No
|
|
profitem.invoice_no
|
Invoice number
|
isb_mstr.isb_inv_nbr
|
Invoice
|
Yes
|
No
|
|
profitem.pm_days
|
PM Days
|
isb_mstr.isb_pm_days
|
PM days
|
Yes
|
No
|
|
profitem.last_pm_date
|
Last PM Date
|
isb_mstr.isb_last_pm
|
Last PM date
|
Yes
|
No
|
|
profitem.warr_exp_date
|
Warranty Expire Date
|
isb_mstr.isb_warr_exp
|
Warranty Expiration
|
Yes
|
No
|
|
profitem.next_pm_date
|
Next PM Date
|
isb_mstr.isb_next_pm
|
Next PM Date
|
Yes
|
No
|
|
profitem.warr_code
|
Warranty Code
|
isb_mstr.isb_warr_cd
|
Warranty Code
|
Yes
|
No
|
|
profitem.model
|
Model/Version
|
isb_mstr.isb_model
|
Model
|
Yes
|
No
|
|
profitem.serial_no
|
Serial No
|
isb_mstr.isb_serial
|
Serial
|
Yes
|
No
|
|
profitem.ref
|
Reference
|
string(isb_mstr.isb_ref)
|
Ref
|
Yes
|
No
|
|
profitem.udf_char01
|
Ownership
|
isb_mstr.isb_owner
|
Ownership
|
Yes
|
No
|
|
profitem.udf_char02
|
Item Type
|
isb_mstr.isb_sys_type
|
Item Type
|
Yes
|
No
|
|
profitem.created_by
|
Created By
|
global_userid
|
-
|
-
|
|