QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
mfslsd_det
MFS Last Sync Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
mfslsd__qadc01
 
 
x(24)
 
 
mfslsd__qadc02
 
 
x(24)
 
 
mfslsd_deviceid
Device ID
 
x(30)
 
 
mfslsd_domain
Domain
 
x(8)
 
 
mfslsd_lastsync
Last Sync
 
99/99/9999 HH:MM:SS.SSS
 
 
mfslsd_mod_date
Modified Date
Mod Date
99/99/99
 
 
mfslsd_mod_userid
User ID
 
x(8)
 
 
mfslsd_user1
User Field Character 1
 
x(24)
 
 
mfslsd_user2
User Field Character 2
 
x(24)
 
 
mfslsd_userid
User ID
 
x(20)
 
 
oid_mfslsd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mfslsd_userid
yes
mfslsd_domain
yes
no
 
 
 
mfslsd_userid
yes
no
 
 
 
mfslsd_deviceid
yes
no
 
oid_mfslsd_det
yes
oid_mfslsd_det
yes
no
mfssld_det
MFS Sync Log Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
mfssld__qadc01
 
 
x(24)
 
 
mfssld__qadc02
 
 
x(24)
 
 
mfssld_api_status
API Status
 
x(8)
 
 
mfssld_deviceid
Device ID
 
x(30)
 
 
mfssld_domain
Domain
 
x(8)
 
 
mfssld_last_updated_record_id
Last Updated Record Key
 
x(24)
 
 
mfssld_last_updated_record_typ
Last Updated Record Type
 
x(8)
 
 
mfssld_mod_date
Modified Date
Mod Date
99/99/99
 
 
mfssld_mod_userid
User ID
 
x(8)
 
 
mfssld_sync_api_end_time
API Sync End Time
 
99/99/9999 HH:MM:SS.SSS
 
 
mfssld_sync_api_start_time
API Sync Start Time
 
99/99/9999 HH:MM:SS.SSS
 
 
mfssld_sync_apiname
Sync API Name
 
x(24)
 
 
mfssld_sync_method
Sync Method
 
x(8)
 
 
mfssld_sync_version
Client Version
 
x(12)
 
 
mfssld_user1
User Field Character 1
 
x(24)
 
 
mfssld_user2
User Field Character 2
 
x(24)
 
 
mfssld_userid
User ID
 
x(20)
 
 
oid_mfssld_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
mfssld_device_user
no
mfssld_deviceid
yes
no
 
 
 
mfssld_userid
yes
no
 
 
 
mfssld_sync_api_start_time
yes
no
 
 
 
mfssld_sync_apiname
yes
no
mfssld_sync_start
yes
mfssld_domain
yes
no
 
 
 
mfssld_sync_api_start_time
yes
no
 
 
 
mfssld_userid
yes
no
 
 
 
mfssld_deviceid
yes
no
 
 
 
mfssld_sync_apiname
yes
no
 
mfssld_user_device
no
mfssld_userid
yes
no
 
 
 
mfssld_deviceid
yes
no
 
 
 
mfssld_sync_api_start_time
yes
no
 
 
 
mfssld_sync_apiname
yes
no
 
oid_mfssld_det
yes
oid_mfssld_det
yes
no
mfsu_mstr
MFS User Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
mfsu__qadc01
 
 
x(24)
 
 
mfsu__qadc02
 
 
x(24)
 
 
mfsu_active_dir_enabled
Active Directory Enabled
 
yes/no
 
 
mfsu_active_dir_userid
Active Directory Userid
 
x(64)
 
 
mfsu_active_reason
Active Reason
 
x(8)
 
 
mfsu_failed_attempts
Password Failed Attempts
 
>>9
 
 
mfsu_force_change
Password Force Change
 
yes/no
 
 
mfsu_last_date
Date Password Last Changed
 
99/99/99
 
 
mfsu_ldap_dn
Ldap Username
 
x(256)
 
 
mfsu_ldap_instance
LDAP Instance Name
 
x(36)
 
 
mfsu_mail_address
E-mail Address
 
x(60)
 
 
mfsu_mail_address_login
E-mail Address Login
 
yes/no
 
 
mfsu_mod_date
Modified Date
Mod Date
99/99/99
 
 
mfsu_mod_userid
User ID
 
x(8)
 
 
mfsu_passwd
Password
 
x(16)
 
 
mfsu_user1
User Field Character 1
 
x(24)
 
 
mfsu_user2
User Field Character 2
 
x(24)
 
 
mfsu_userid
User ID
 
x(20)
 
 
mfsu_usr_enabled
Sync User Enabled
 
yes/no
 
 
oid_mfsu_mstr
OID
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
mfsu_ad_userid
no
mfsu_active_dir_userid
yes
no
 
mfsu_mail_address
no
mfsu_mail_address
yes
no
mfsu_userid
yes
mfsu_userid
yes
no
 
oid_mfsu_mstr
yes
oid_mfsu_mstr
yes
no
MirroringGL
Mirror Account
 
 
Field Name
Label
Col-Label
Format
Dec
 
Company_ID
Entity
 
-99999999999
 
 
Domain_ID
Domain
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
Mirror1CostCentre_ID
Mirror 1 Cost Center
 
-99999999999
 
 
Mirror1Division_ID
Mirror 1 Sub-Account
 
-99999999999
 
 
Mirror1GL_ID
Mirror 1 Account
 
-99999999999
 
 
Mirror1Project_ID
Mirror 1 Project
 
-99999999999
 
 
Mirror2CostCentre_ID
Mirror 2 Cost Center
 
-99999999999
 
 
Mirror2Division_ID
Mirror 2 Sub-Account
 
-99999999999
 
 
Mirror2GL_ID
Mirror 2 Account
 
-99999999999
 
 
Mirror2Project_ID
Mirror 2 Project
 
-99999999999
 
 
MirroringGL_ID
Record ID
 
-99999999999
 
 
MirroringGLSplitGLType
Account Split Type
 
x(20)
 
 
MirroringGLTrans1Journal
Transaction 1 Daybook
 
x(20)
 
 
MirroringGLTrans2Journal
Transaction 2 Daybook
 
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Source1CostCentre_ID
Source 1 Cost Center
 
-99999999999
 
 
Source1Division_ID
Source 1 Sub-Account
 
-99999999999
 
 
Source1GL_ID
Source 1 Account Type
Source 1 Account Type
-99999999999
 
 
Source1Project_ID
Source 1 Project
 
-99999999999
 
 
Source2CostCentre_ID
Source 2 Cost Center
 
-99999999999
 
 
Source2Division_ID
Source 2 Sub-Account
 
-99999999999
 
 
Source2GL_ID
Source 2 Account Type
 
-99999999999
 
 
Source2Project_ID
Source 2 Project
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CC1Idx
no
Mirror1CostCentre_ID
yes
no
 
CC2Idx
no
Mirror2CostCentre_ID
yes
no
 
Div1Idx
no
Mirror1Division_ID
yes
no
 
Div2Idx
no
Mirror2Division_ID
yes
no
 
GL1Idx
no
Mirror1GL_ID
yes
no
 
GL2Idx
no
Mirror2GL_ID
yes
no
 ∗
Prim
yes
MirroringGL_ID
yes
no
 
Prj1Idx
no
Mirror1Project_ID
yes
no
 
Prj2Idx
no
Mirror2Project_ID
yes
no
 
SrcCC1Idx2
no
Source1CostCentre_ID
yes
no
 
SrcCC2Idx2
no
Source2CostCentre_ID
yes
no
 
SrcDiv1Idx2
no
Source1Division_ID
yes
no
 
SrcDiv2Idx2
no
Source2Division_ID
yes
no
 
SrcGL1Idx2
no
Source1GL_ID
yes
no
 
SrcGL2Idx2
no
Source2GL_ID
yes
no
 
SrcPrj1Idx2
no
Source1Project_ID
yes
no
 
SrcPrj2Idx2
no
Source2Project_ID
yes
no
 
UniqueIdx
yes
Domain_ID
yes
no
 
 
 
Company_ID
yes
no
 
 
 
Source1GL_ID
yes
no
 
 
 
Source1Division_ID
yes
no
 
 
 
Source1CostCentre_ID
yes
no
 
 
 
Source1Project_ID
yes
no
 
 
 
Source2GL_ID
yes
no
 
 
 
Source2Division_ID
yes
no
 
 
 
Source2CostCentre_ID
yes
no
 
 
 
Source2Project_ID
yes
no
MirroringJournal
Mirror Daybook
 
 
Field Name
Label
Col-Label
Format
Dec
 
Company_ID
Entity
 
-99999999999
 
 
Domain_ID
Domain
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
MirroringJournal_ID
Record ID
 
-99999999999
 
 
MirrorJournal_ID
Mirror Daybook Control
Mirror Daybook Ctrl
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
SourceJournal_ID
Source Daybook Control
Source Daybook Ctrl
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Company
no
Company_ID
yes
no
 
Domains
no
Domain_ID
yes
no
 
MirrorJrnl
no
MirrorJournal_ID
yes
no
 ∗
Prim
yes
MirroringJournal_ID
yes
no
 
SourceJrnl
no
SourceJournal_ID
yes
no
 
UniqueIdx
yes
Domain_ID
yes
no
 
 
 
Company_ID
yes
no
 
 
 
SourceJournal_ID
yes
no
mnd_det
Menu Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
mnd__qadc01
 
 
x(8)
 
 
mnd_canrun
Access codes
 
x(189)
 
 
mnd_exec
Execution File
Exec File
x(14)
 
 
mnd_fkey
F Key
Key
>>9
 
 
mnd_help
Help File
 
x(12)
 
 
mnd_label
Selection Label
 
x(40)
 
 
mnd_name
Name
 
x(8)
 
 
mnd_nbr
Menu
 
x(16)
 
 
mnd_select
Selection
Sel
>9
 
 
mnd_uri
Uniform Resource Identifier
URI
x(256)
 
 
mnd_user1
Ufld1
 
x(8)
 
 
mnd_user2
Ufld2
 
x(8)
 
 
oid_mnd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
mnd_exec
no
mnd_exec
yes
no
 
mnd_name
no
mnd_name
yes
no
mnd_nbr
yes
mnd_nbr
yes
no
 
 
 
mnd_select
yes
no
 
mnd_uri
no
mnd_uri
yes
no
 
oid_mnd_det
yes
oid_mnd_det
yes
no
mnp_det
Service/Support Custom Program Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
mnp__qadc01
 
 
x(8)
 
 
mnp_domain
Domain
 
x(8)
 
 
mnp_exec
Program to Execute
 
x(12)
 
 
mnp_menu
Menu
 
x(12)
 
 
mnp_prog_type
Program Type
 
x(8)
 
 
mnp_program
Program
 
x(12)
 
 
mnp_repeat_group
Repeat Group
 
x(8)
 
 
mnp_select
Selection
 
>>9
 
 
mnp_sequence
Sequence
Seq
>>>9
 
 
mnp_system
System
 
yes/no
 
 
mnp_user1
Ufld1
 
x(8)
 
 
mnp_user2
Ufld2
 
x(8)
 
 
mnp_userid
User ID
 
x(8)
 
 
oid_mnp_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mnp_program
yes
mnp_domain
yes
no
 
 
 
mnp_program
yes
no
 
 
 
mnp_userid
yes
no
 
 
 
mnp_sequence
yes
no
 
 
 
mnp_prog_type
yes
no
 
oid_mnp_det
yes
oid_mnp_det
yes
no
mnt_det
Menu Title Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
mnt__qadc01
 
 
x(8)
 
 
mnt_label
Selection Label
 
x(40)
 
 
mnt_lang
Language
 
x(2)
 
 
mnt_nbr
Menu
 
x(16)
 
 
mnt_select
Selection
 
>9
 
 
mnt_user1
Ufld1
 
x(8)
 
 
mnt_user2
Ufld2
 
x(8)
 
 
oid_mnt_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
mnt_lang
no
mnt_lang
yes
no
mnt_nsl
yes
mnt_nbr
yes
no
 
 
 
mnt_select
yes
no
 
 
 
mnt_lang
yes
no
 
oid_mnt_det
yes
oid_mnt_det
yes
no
mpd_det
Master Specification Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
mpd__chr01
 
 
x(8)
 
 
mpd__chr02
 
 
x(8)
 
 
mpd__chr03
 
 
x(8)
 
 
mpd__chr04
 
 
x(8)
 
 
mpd__chr05
 
 
x(8)
 
 
mpd__dec01
 
 
>>>,>>>,>>9.99
10
 
mpd__dec02
 
 
>>>,>>>,>>9.99
10
 
mpd_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
mpd_domain
Domain
 
x(8)
 
 
mpd_label
Characteristic
 
x(24)
 
 
mpd_nbr
Document
 
x(8)
 
 
mpd_tol
Specification
 
x(26)
 
 
mpd_tol_type
Measure
 
x(12)
 
 
mpd_type
Number
 
x(8)
 
 
mpd_user1
Ufld1
 
x(8)
 
 
mpd_user2
Ufld2
 
x(8)
 
 
oid_mpd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mpd_nbr
yes
mpd_domain
yes
no
 
 
 
mpd_nbr
yes
no
 
 
 
mpd_type
yes
no
 
oid_mpd_det
yes
oid_mpd_det
yes
no
mph_hist
Master Specification Test History
 
 
Field Name
Label
Col-Label
Format
Dec
 
mph__chr01
 
 
x(8)
 
 
mph__chr02
 
 
x(8)
 
 
mph__chr03
 
 
x(8)
 
 
mph__chr04
 
 
x(8)
 
 
mph__chr05
 
 
x(8)
 
 
mph__dec01
 
 
>>>,>>>,>>9.99
10
 
mph__dec02
 
 
>>>,>>>,>>9.99
10
 
mph_attribute
Attribute
 
X(8)
0
 
mph_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
mph_date
Test Date
 
99/99/99
 
 
mph_domain
Domain
 
x(8)
 
 
mph_lot
ID/Batch
 
x(8)
 
 
mph_mch
Machine
 
x(8)
 
 
mph_op
Operation
Op
>>>>>9
 
 
mph_op_trnbr
Trans
 
>>>>>9
 
 
mph_part
Item Number
 
x(18)
 
 
mph_pass
Pass
 
yes/no
 
 
mph_procedure
Document
 
x(8)
 
 
mph_routing
Routing/Procedure
 
x(18)
 
 
mph_rsult
Results
Actual Results
x(25)
 
 
mph_test
Characteristic
 
x(24)
 
 
mph_testmthd
Test Method
 
X(8)
0
 
mph_user1
Ufld1
 
x(8)
 
 
mph_user2
Ufld2
 
x(8)
 
 
mph_wr_nbr
Order Number
 
x(18)
 
 
oid_mph_hist
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mph_lot
yes
mph_domain
yes
no
 
 
 
mph_lot
yes
no
 
 
 
mph_part
yes
no
 
 
 
mph_routing
yes
no
 
 
 
mph_op
yes
no
 
 
 
mph_test
yes
no
 
oid_mph_hist
yes
oid_mph_hist
yes
no
mps_mstr
Master Production Schedule
 
 
Field Name
Label
Col-Label
Format
Dec
 
mps__qadc01
 
 
x(8)
 
 
mps_bom_code
BOM/Formula
 
x(18)
 
 
mps_domain
Domain
 
x(8)
 
 
mps_due_date
Due Date
 
99/99/99
 
 
mps_line
Production Line
Line
x(8)
 
 
mps_part
Item Number
 
x(18)
 
 
mps_qty_cons
Qty Consumed
 
->,>>>,>>9.9<<<<<<<<
10
 
mps_qty_req
Qty Scheduled
 
->,>>>,>>9.9<<<<<<<<
10
 
mps_record
 
 
>>>>>>9
 
 
mps_rel_date
Release
Rel Date
99/99/99
 
 
mps_routing
Routing Code
 
x(18)
 
 
mps_site
Site
 
x(8)
 
 
mps_user1
Ufld1
 
x(8)
 
 
mps_user2
Ufld2
 
x(8)
 
 
oid_mps_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mps_part
yes
mps_domain
yes
no
 
 
 
mps_part
yes
no
 
 
 
mps_site
yes
no
 
 
 
mps_line
yes
no
 
 
 
mps_due_date
yes
no
 
mps_record
yes
mps_domain
yes
no
 
 
 
mps_record
yes
no
 
mps_site
yes
mps_domain
yes
no
 
 
 
mps_site
yes
no
 
 
 
mps_part
yes
no
 
 
 
mps_line
yes
no
 
 
 
mps_due_date
yes
no
 
oid_mps_mstr
yes
oid_mps_mstr
yes
no
mp_mstr
Master Specification
 
 
Field Name
Label
Col-Label
Format
Dec
 
mp__chr01
 
 
x(8)
 
 
mp__chr02
 
 
x(8)
 
 
mp__chr03
 
 
x(8)
 
 
mp__chr04
 
 
x(8)
 
 
mp__chr05
 
 
x(8)
 
 
mp__dec01
 
 
>>>,>>>,>>9.99
10
 
mp__dec02
 
 
>>>,>>>,>>9.99
10
 
mp_desc
Description
 
x(24)
 
 
mp_domain
Domain
 
x(8)
 
 
mp_expire
Expire Date
 
99/99/99
 
 
mp_nbr
Document
 
x(8)
 
 
mp_user1
Ufld1
 
x(8)
 
 
mp_user2
Ufld2
 
x(8)
 
 
oid_mp_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mp_nbr
yes
mp_domain
yes
no
 
 
 
mp_nbr
yes
no
 
oid_mp_mstr
yes
oid_mp_mstr
yes
no
mrpc_ctrl
Material Requirements Planning Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
mrpc__qadc01
 
 
x(8)
 
 
mrpc__qadi01
 
 
->>>>>>>9
 
 
mrpc_domain
Domain
 
x(8)
 
 
mrpc_drp
MRP/DRP Combined
MRP/DRP
yes/no
 
 
mrpc_horizon
MRP Horizon
 
->,>>>,>>9
 
 
mrpc_op_yield
Enable Op Based Yield
 
yes/no
 
 
mrpc_reldays
Order Release Horizon
Rel Horizon
>>9
 
 
mrpc_sum_def
Summary Default
D
>
 
 
mrpc_user1
Ufld1
 
x(8)
 
 
mrpc_user2
Ufld2
 
x(8)
 
 
oid_mrpc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mrpc_index1
yes
mrpc_domain
yes
no
 
oid_mrpc_ctrl
yes
oid_mrpc_ctrl
yes
no
mrpp_det
Material Requirements Planning Pegging Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
mrpp__qadc01
 
 
x(24)
 
 
mrpp__qadc02
 
 
x(24)
 
 
mrpp_demand_due_date
Demand Due Date
 
99/99/99
 
 
mrpp_demand_mrp_keyid
Demand ID
 
>>>>>>>>9
 
 
mrpp_domain
Domain
 
x(8)
 
 
mrpp_mod_date
Modified Date
Mod Date
99/99/99
 
 
mrpp_mod_userid
User ID
 
x(8)
 
 
mrpp_qty_pegged
Qty Pegged
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
mrpp_supply_due_date
Supply Due Date
 
99/99/99
 
 
mrpp_supply_mrp_keyid
Supply ID
 
>>>>>>>>9
 
 
mrpp_user1
User Field Character 1
 
x(24)
 
 
mrpp_user2
User Field Character 2
 
x(24)
 
 
oid_mrpp_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
mrpp_demand
no
mrpp_domain
yes
no
 
 
 
mrpp_demand_mrp_keyid
yes
no
 
 
 
mrpp_supply_due_date
yes
no
mrpp_det
yes
mrpp_domain
yes
no
 
 
 
mrpp_demand_mrp_keyid
yes
no
 
 
 
mrpp_supply_mrp_keyid
yes
no
 
mrpp_supply
no
mrpp_domain
yes
no
 
 
 
mrpp_supply_mrp_keyid
yes
no
 
 
 
mrpp_demand_due_date
yes
no
 
oid_mrpp_det
yes
oid_mrpp_det
yes
no
mrp_det
Material Requirements Planning Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
mrp__qad01
 
 
yes/no
 
 
mrp_dataset
Data Set
 
x(12)
 
 
mrp_detail
Detail
 
x(24)
 
 
mrp_domain
Domain
 
x(8)
 
 
mrp_due_date
Due Date
 
99/99/99
 
 
mrp_keyid
Key ID
 
>>>>>>>>9
 
 
mrp_line
Line/ID
 
x(8)
 
 
mrp_line2
Reference
Ref
x(8)
 
 
mrp_nbr
Order
Order Number
x(18)
 
 
mrp_ord_site
Order Site
Ord Site
x(8)
 
 
mrp_part
Item Number
 
x(18)
 
 
mrp_qty
Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
mrp_rel_date
Release Date
 
99/99/99
 
 
mrp_site
Site
 
x(8)
 
 
mrp_type
Order Type
 
x(8)
 
 
mrp_user1
Ufld1
 
x(8)
 
 
mrp_user2
Ufld2
 
x(8)
 
 
oid_mrp_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mrp_det
yes
mrp_domain
yes
no
 
 
 
mrp_dataset
yes
no
 
 
 
mrp_part
yes
no
 
 
 
mrp_nbr
yes
no
 
 
 
mrp_line
yes
no
 
 
 
mrp_line2
yes
no
 
mrp_keyid
no
mrp_domain
yes
no
 
 
 
mrp_keyid
yes
no
 
mrp_nbr
yes
mrp_domain
yes
no
 
 
 
mrp_dataset
yes
no
 
 
 
mrp_nbr
yes
no
 
 
 
mrp_line
yes
no
 
 
 
mrp_line2
yes
no
 
 
 
mrp_part
yes
no
 
mrp_partdate
no
mrp_domain
yes
no
 
 
 
mrp_part
yes
no
 
 
 
mrp_due_date
yes
no
 
 
 
mrp_type
no
no
 
mrp_site_due
no
mrp_domain
yes
no
 
 
 
mrp_site
yes
no
 
 
 
mrp_part
yes
no
 
 
 
mrp_due_date
yes
no
 
 
 
mrp_type
yes
no
 
mrp_sitetype
no
mrp_domain
yes
no
 
 
 
mrp_site
yes
no
 
 
 
mrp_part
yes
no
 
 
 
mrp_type
yes
no
 
 
 
mrp_due_date
yes
no
 
 
 
mrp_qty
yes
no
 
oid_mrp_det
yes
oid_mrp_det
yes
no
MsgBrokerSetting
Message Broker Setting
 
 
Field Name
Label
Col-Label
Format
Dec
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
MsgBrokerSetting_ID
Record ID
 
-99999999999
 
 
MsgBrokerSettingAdapterCs
Adaptor Connection String
 
x(255)
 
 
MsgBrokerSettingBrokerCs
Broker Connection String
 
x(255)
 
 
MsgBrokerSettingName
Name
 
x(40)
 
 
MsgBrokerSettingPassword
Password
 
x(40)
 
 
MsgBrokerSettingUser
User
 
x(40)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
MsgBrokerSet
yes
MsgBrokerSetting_ID
yes
no
 
Name
yes
MsgBrokerSettingName
yes
no
msg_mstr
Message Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
msg__qadc01
 
 
x(8)
 
 
msg_desc
Message
 
x(64)
 
 
msg_explanation[11]
Explanation
 
x(76)
 
 
msg_lang
Language
 
x(2)
 
 
msg_nbr
Message Number
Msg
>>>>9
 
 
msg_type
Type
 
x(8)
 
 
msg_user1
Ufld1
 
x(8)
 
 
msg_user2
Ufld2
 
x(8)
 
 
oid_msg_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
msg_ln
yes
msg_lang
yes
no
 
 
 
msg_nbr
yes
no
 
oid_msg_mstr
yes
oid_msg_mstr
yes
no
mu_mstr
Monetary Union Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
mu__qadc01
 
 
x(8)
 
 
mu__qadd01
 
 
->>>>,>>>,>>9.99
10
 
mu__qadl01
 
 
yes/no
 
 
mu__qadt01
 
 
99/99/99
 
 
mu_domain
Domain
 
x(8)
 
 
mu_end_date
End
 
99/99/99
 
 
mu_member_curr
Member Currency
Member
x(3)
 
 
mu_mod_date
Modified Date
Mod Date
99/99/99
 
 
mu_mod_userid
User ID
 
x(8)
 
 
mu_start_date
Start
 
99/99/99
 
 
mu_union_curr
Union Currency
Union
x(3)
 
 
mu_user1
Ufld1
 
x(8)
 
 
mu_user2
Ufld2
 
x(8)
 
 
oid_mu_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
mu_member_curr
yes
mu_domain
yes
no
 
 
 
mu_member_curr
yes
no
 
 
 
mu_start_date
no
no
 
oid_mu_mstr
yes
oid_mu_mstr
yes
no
nfad_det
Address information related to legal document address codes
 
 
Field Name
Label
Col-Label
Format
Dec
 
nfad__qadc01
 
 
x(24)
 
 
nfad__qadc02
 
 
x(24)
 
 
nfad__qadl01
 
 
yes/no
 
 
nfad__qadt01
 
 
99/99/99
 
 
nfad_ad_type
List Type
List
x(8)
 
 
nfad_addr
Address
 
x(8)
 
 
nfad_city
City
 
x(20)
 
 
nfad_city_code
City Code
 
x(20)
 
 
nfad_country
Country
 
x(28)
 
 
nfad_county
County
 
x(20)
 
 
nfad_ctry
Country Code
Ctry
x(3)
 
 
nfad_gst_id
Tax ID - Federal
 
x(18)
 
 
nfad_line1
Address
 
x(36)
 
 
nfad_line2
Address
 
x(36)
 
 
nfad_line3
Address
 
x(36)
 
 
nfad_misc1_id
Tax ID - Misc 1
 
x(18)
 
 
nfad_misc2_id
Tax ID - Misc 2
 
x(18)
 
 
nfad_misc3_id
Tax ID - Misc 3
 
x(18)
 
 
nfad_mod_date
Last Modified Date
Mod Date
99/99/99
 
 
nfad_mod_userid
Last Modified User Id
 
x(8)
 
 
nfad_name
Name
 
x(60)
 
 
nfad_phone
Telephone
 
x(20)
 
 
nfad_pst_id
Tax ID - State
 
x(18)
 
 
nfad_state
State
St
x(4)
 
 
nfad_user1
User Field Character 1
 
x(24)
 
 
nfad_user2
User Field Character 2
 
x(24)
 
 
nfad_zip
Post
 
x(10)
 
 
oid_lgd_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_nfad_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_lgd_mstr
no
oid_lgd_mstr
yes
no
 
 
 
nfad_addr
yes
no
 
 
 
nfad_ad_type
yes
no
oid_nfad_det
yes
oid_nfad_det
yes
no
nfcib_det
Initial amount data for FCI calculation
 
 
Field Name
Label
Col-Label
Format
Dec
 
nfcib__qadc01
 
 
x(24)
 
 
nfcib__qadc02
 
 
x(24)
 
 
nfcib__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
nfcib__qadt01
 
 
99/99/99
 
 
nfcib_domain
Domain
 
x(8)
 
 
nfcib_imp_price
Imported Portion Unit Price
 
->>>,>>>,>>9.9999
10
 
nfcib_mod_date
Last Modified Date
Mod Date
99/99/99
 
 
nfcib_mod_userid
Last Modified User Id
 
x(8)
 
 
nfcib_out_inter_price
Imported Portion Unit Price
 
->>>,>>>,>>9.9999
10
 
nfcib_part
Item Code
 
x(18)
 
 
nfcib_site
Site
 
x(8)
 
 
nfcib_user1
User Field Character 1
 
x(24)
 
 
nfcib_user2
User Field Character 2
 
x(24)
 
 
oid_nfcib_det
Unique application generated record identifier.
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
nfcib_part_site
yes
nfcib_domain
yes
no
 
 
 
nfcib_part
yes
no
 
 
 
nfcib_site
yes
no
 
oid_nfcib_det
yes
oid_nfcib_det
yes
no
nfdfci_det
FCI calculated data
 
 
Field Name
Label
Col-Label
Format
Dec
 
nfdfci__qadc01
 
 
x(24)
 
 
nfdfci__qadc02
 
 
x(24)
 
 
nfdfci__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
nfdfci__qadt01
 
 
99/99/99
 
 
nfdfci_calc_date
Calc Date
 
99/99/99
 
 
nfdfci_calc_time
Calc time
 
>>>>>>>9
 
 
nfdfci_domain
Domain
 
x(8)
 
 
nfdfci_fci_code
FCI Code
 
x(36)
 
 
nfdfci_imp_ctt_pct
% Importation Content
 
->>9.9999
10
 
nfdfci_imp_price
Imported Portion Unit Price
 
->>>,>>>,>>9.9999
10
 
nfdfci_mod_date
Last Modified Date
Mod Date
99/99/99
 
 
nfdfci_mod_userid
Last Modified User Id
 
x(8)
 
 
nfdfci_out_inter_price
Imported Portion Unit Price
 
->>>,>>>,>>9.9999
10
 
nfdfci_part
Item code
 
x(18)
 
 
nfdfci_rec_code
Receipt Code
 
x(36)
 
 
nfdfci_rec_date
Receipt Date
 
99/99/99
 
 
nfdfci_rec_time
Receipt time
 
>>>>>>>9
 
 
nfdfci_site
Site code
 
x(8)
 
 
nfdfci_user1
User Field Character 1
 
x(24)
 
 
nfdfci_user2
User Field Character 2
 
x(24)
 
 
nfdfci_val_date
Validation Date
 
99/99/99
 
 
nfdfci_val_time
Validation time
 
>>>>>>>9
 
 
oid_nfdfci_det
Unique application generated record identifier.
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
nfdfci_part_site
yes
nfdfci_domain
yes
no
 
 
 
nfdfci_part
yes
no
 
 
 
nfdfci_site
yes
no
 
oid_nfdfci_det
yes
oid_nfdfci_det
yes
no
nfdft_det
Additional foreign trade information for legal documents
 
 
Field Name
Label
Col-Label
Format
Dec
 
nfdft__qadc01
 
 
x(24)
 
 
nfdft__qadc02
 
 
x(24)
 
 
nfdft__qadd01
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<
10
 
nfdft__qadt01
 
 
99/99/99
 
 
nfdft_add_seq_nbr
Addition Sequence Number
Add Seq Nbr
>>9
 
 
nfdft_addition_nbr
Addition number
Add Nbr
>>9
 
 
nfdft_doc_date
Doc Date
 
99/99/9999
 
 
nfdft_doc_disc_amt
Doc Discount Amount
Doc Disc Amt
->>>,>>>,>>9.99<<
10
 
nfdft_doc_nbr
Document Number
Doc Number
x(12)
 
 
nfdft_drawback_cons
Drawback Cons Act
Draw Cons
x(11)
 
 
nfdft_exp_prim_effdate
Orig Eff Date
 
99/99/99
 
 
nfdft_exp_prim_key_nbr
Access Key Number
Acc Key
x(44)
 
 
nfdft_exp_prim_nbr
Orig Doc Nbr
 
x(12)
 
 
nfdft_exp_prim_shipfrom
Orig Ship From
 
x(8)
 
 
nfdft_exp_prim_shipto
Orig Ship To
 
x(8)
 
 
nfdft_exp_qty
Exported Quantity
Exp Qty
->,>>>,>>9.9<<<
10
 
nfdft_mod_date
Last Modified Date
Mod Date
99/99/99
 
 
nfdft_mod_userid
Last Modified User Id
 
x(8)
 
 
nfdft_seq
Sequence number
Seq
>>9
 
 
nfdft_user1
User Field Character 1
 
x(24)
 
 
nfdft_user2
User Field Character 2
 
x(24)
 
 
oid_lgdd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_nfd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_nfdft_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
oid_lgdd_det
no
oid_lgdd_det
yes
no
 
 
 
nfdft_seq
yes
no
 
oid_nfd_det
no
oid_nfd_det
yes
no
 
oid_nfdft_det
yes
oid_nfdft_det
yes
no
nfd_det
Nota Fiscal Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
nfd__qadc01
 
 
x(24)
 
 
nfd__qadc02
 
 
x(24)
 
 
nfd__qadd01
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
nfd__qadt01
 
 
99/99/99
 
 
nfd_afrmm_amt
AFRMM Amount
AFRMM amt
->>>>,>>>,>>9.99<
10
 
nfd_cofins_cst
COFINS CST
 
x(8)
 
 
nfd_est_tot_tax_amt
Estimated total Tax amount
Est Tot Tax Amt
->>>>,>>>,>>9.99<
10
 
nfd_exp_memo
Memorandum
 
x(10)
 
 
nfd_fci_code
FCI Code
 
x(36)
 
 
nfd_freight_nature
Freight Nature
 
x(1)
 
 
nfd_ipi_rsn_code
IPI Reason Code
 
x(8)
 
 
nfd_mfgr
Manufacturer
Mfg
x(8)
 
 
nfd_mod_date
Last Modified Date
Mod Date
99/99/99
 
 
nfd_mod_userid
Last Modified User Id
 
x(8)
 
 
nfd_mun_serv_code
Municipal Service Code
 
x(10)
 
 
nfd_nfe_tax_unit_price
Tax Unit Price
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
nfd_nfe_taxable_qty
Taxable Qty
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
nfd_nfe_taxable_um
Taxable UM
 
x(6)
 
 
nfd_nve1_code
NVE code
 
x(6)
 
 
nfd_nve2_code
NVE code
 
x(6)
 
 
nfd_nve3_code
NVE code
 
x(6)
 
 
nfd_nve4_code
NVE code
 
x(6)
 
 
nfd_nve5_code
NVE code
 
x(6)
 
 
nfd_nve6_code
NVE code
 
x(6)
 
 
nfd_nve7_code
NVE code
 
x(6)
 
 
nfd_nve8_code
NVE code
 
x(6)
 
 
nfd_phy_mov
Physical Move
 
X(1)
 
 
nfd_pis_cst
PIS CST
 
x(8)
 
 
nfd_rec_icmssub_base_amt
Rec ICMS Sub base amt
 
->>,>>>,>>9.99
10
 
nfd_rec_icmssub_tax_amt
Rec ICMS Sub tax Amt
 
->>,>>>,>>9.99
10
 
nfd_user1
User Field Character 1
 
x(24)
 
 
nfd_user2
User Field Character 2
 
x(24)
 
 
oid_lgdd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_nfd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
nfd_oid_lgdd_det
yes
oid_lgdd_det
yes
no
 
oid_nfd_det
yes
oid_nfd_det
yes
no
nfecs_det
Electronic Nota Fiscal Configuration by Site
 
 
Field Name
Label
Col-Label
Format
Dec
 
nfecs__qadc01
 
 
x(24)
 
 
nfecs__qadc02
 
 
x(24)
 
 
nfecs__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
nfecs__qadt01
 
 
99/99/99
 
 
nfecs_cert_dir
Certificate Directory
 
x(50)
 
 
nfecs_cert_file
Certificate File
 
x(20)
 
 
nfecs_cert_passwd
Certificate Password
 
x(20)
 
 
nfecs_comm_file
Comm Config File
 
x(120)
 
 
nfecs_con_cmtindx
Contingency Reason Comment
Comment
>>>>>>>9
 
 
nfecs_con_date
Contingency Date
 
99/99/99
 
 
nfecs_con_time
Contingency Time
 
>>>>>>>>9
 
 
nfecs_domain
Domain
 
x(8)
 
 
nfecs_env_type
Environment Type
 
x(2)
 
 
nfecs_in_dir
Inbound XML Files Dir
 
x(120)
 
 
nfecs_iss_type
Issue Type
 
x(2)
 
 
nfecs_layout_ver
NFe layout Version
 
x(4)
 
 
nfecs_mod_date
Last Modified Date
Mod Date
99/99/99
 
 
nfecs_mod_userid
Last Modified User Id
 
x(8)
 
 
nfecs_nbr_retry
Number of Retries
 
>>>9
 
 
nfecs_out_dir
Outbound XML Files Dir
 
x(120)
 
 
nfecs_pub_key
Public Certificate Key
 
x(20)
 
 
nfecs_pvt_key
Private Certificate Key
 
x(20)
 
 
nfecs_schema_dir
XML Schema Dir
 
x(120)
 
 
nfecs_site
Site
 
x(8)
 
 
nfecs_synch_rec
Synchronous response
 
yes/no
 
 
nfecs_timeout
Comm Timeout
 
>>>9
 
 
nfecs_type
Config Type
 
x(8)
 
 
nfecs_user1
User Field Character 1
 
x(24)
 
 
nfecs_user2
User Field Character 2
 
x(24)
 
 
oid_nfecs_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
nfecs_site_type
yes
nfecs_domain
yes
no
 
 
 
nfecs_site
yes
no
 
 
 
nfecs_type
yes
no
 
oid_nfecs_det
yes
oid_nfecs_det
yes
no