|
Field Name
|
Data Type
|
Description
|
|
bisg_param.auth
|
Character
|
THISNODE
|
|
bisg_param.rec_num
|
Integer
|
501
|
|
bisg_param.flag[1]
|
Logical
|
Transfer Master comments from QAD ERP to QAD CRM
|
|
bisg_param.flag[3]
|
Logical
|
Transfer Product Information from QAD ERP to QAD CRM
|
|
bisg_param.flag[4]
|
Logical
|
Allow Addition of Product Information in QAD CRM
|
|
bisg_param.flag[2]
|
Logical
|
Transfer Product information from QAD CRM to QAD ERP
|
|
bisg_param.flag[6]
|
Logical
|
Transfer Product comments from QAD CRM to QAD ERP
|
|
bisg_param.ch_1[1]
|
Character
|
Comment Type
|
|
bisg_param.ch_1[2]
|
Character
|
Comment Language
|
|
CRM Field Name
|
CRM Field Label
|
ERP Field Name
|
ERP Field Label
|
ERP > CRM
|
CRM > ERP
|
|
product.auth
|
Unit ID
|
pt_mstr.pt_domain
|
Domain
|
Yes
|
No
|
|
product.prod_id
|
Product ID
|
pt_mstr.pt_part
|
Item Number
|
Yes
|
No
|
|
product.prod_line
|
Product Line
|
pt_mstr.pt_prod_line
|
Prod Line
|
Yes
|
No
|
|
product.break_cat
|
Break Cat
|
pt_mstr.pt_break_cat
|
Price Break Cat
|
Yes
|
No
|
|
product.unit_price
|
List Price
|
pt_mstr.pt_price
|
Price
|
Yes
|
No
|
|
product.prod_desc
|
Desc
|
pt_mstr.pt_desc1) + ' ':U + trim(pt_mstr.pt_desc2
|
Description
|
Yes
|
Yes
|
|
product.vat_code
|
VAT Code
|
pt_mstr.pt_taxc
|
Tax Class
|
Yes
|
No
|
|
product.create_date
|
Create date
|
pt_mstr.pt_added
|
Added
|
Yes
|
No
|
|
product.valid_from
|
Valid from
|
pt_mstr.pt_added
|
Added
|
Yes
|
No
|
|
product.product_status
|
Product Status
|
pt_mstr.pt_status
|
Status
|
Yes
|
Yes
|
|
product.txt
|
Notes
|
Master comments attached to the Product—cd_det.cd_cmmt
|
Comment Data
|
Yes
|
Yes
|
|
product.prod_grp
|
Product Group
|
pt_mstr.pt_group
|
Group
|
Yes
|
Yes
|
|
product.prod_type
|
Product Type
|
pt_mstr.pt_part_type
|
Item Type
|
Yes
|
Yes
|
|
product.external_seq
|
Page Sequence
|
Master Comments page no—cd_det.cd_seq
|
Page
|
Yes
|
Yes
|
|
product.um
|
UOM
|
pt_mstr.pt_um
|
UM
|
Yes
|
Yes
|
|
product.udf_char01
|
Site
|
pt_mstr.pt_site
|
Site
|
Yes
|
Yes
|
|
product.udf_char02
|
Configuration
|
pt_mstr.pt_cfg_type
|
Configuration
|
Yes
|
Yes
|
|
product.udf_char03
|
Pur/Mfg
|
pt_mstr.pt_pm_code
|
Pur/Mfg
|
Yes
|
Yes
|
|
product.udf_char04
|
Freight class
|
pt_mstr.pt_fr_class
|
Freight class
|
Yes
|
Yes
|
|
product.udf_char05
|
Ship weight UM
|
pt_mstr.pt_ship_wt_um
|
Ship weight UM
|
Yes
|
Yes
|
|
product.udf_char06
|
Location
|
pt_mstr.pt_loc
|
Location
|
Yes
|
Yes
|
|
product.udf_dec01
|
Ship weight
|
pt_mstr.pt_ship_wt
|
Ship weight
|
Yes
|
Yes
|
|
product.udf_dec02
|
Mfg LT
|
pt_mstr.pt_mfg_lead
|
Mfg LT
|
Yes
|
Yes
|
|
product.udf_log01
|
Tax
|
pt_mstr.pt_taxable
|
Tax
|
Yes
|
Yes
|
|
product.cost_price
|
Cost Price
|
sct_det.sct_cst_tot
|
Cost Total
|
Yes
|
No
|
|
product.created_by
|
Created By
|
global_userid
|
-
|
-
|
-
|
|
product.modified_by
|
Modified By
|
global_userid
|
-
|
-
|
-
|
|
product.integration_type
|
Integration Type
|
MFG
|
-
|
-
|
-
|
|
CRM Field Name
|
CRM Field Label
|
ERP Field Name
|
ERP Field Label
|
ERP > CRM
|
CRM > ERP
|
|
prodline.auth
|
Unit ID
|
pt_mstr.pt_domain
|
Domain
|
Yes
|
No
|
|
prodline.prod_line
|
Product Line
|
pt_mstr.pt_prod_line
|
Prod Line
|
Yes
|
No
|
|
prodline.line_desc
|
Description
|
pl_mstr.pl_desc
|
Description
|
Yes
|
No
|
|
prodline.created_by
|
Created By
|
global_userid
|
-
|
-
|
-
|
|
prodline.modified_by
|
Modified By
|
global_userid
|
-
|
-
|
-
|
|
CRM Field Name
|
CRM Field Label
|
ERP Field Name
|
ERP Field Label
|
ERP > CRM
|
CRM > ERP
|
|
uom.auth
|
Unit ID
|
um_mstr.um_domain
|
Domain
|
Yes
|
No
|
|
uom.um
|
UOM
|
um_mstr.um_um
|
Unit of Measure
|
Yes
|
No
|
|
uom.alt_um
|
Alternate UOM
|
um_mstr.um_alt_um
|
Alternate UM
|
Yes
|
No
|
|
uom.conv
|
UM Conversion
|
um_mstr.um_conv
|
UM Conversion
|
Yes
|
No
|
|
uom.prod_id
|
Product ID
|
um_mstr.um_part
|
Item Number
|
Yes
|
No
|
|
uom.um_desc
|
Description
|
um_mstr.um_desc
|
Description
|
Yes
|
No
|
|
uom.created_by
|
Created By
|
global_userid
|
-
|
-
|
-
|
|
uom.modified_by
|
Modified By
|
global_userid
|
-
|
-
|
-
|