|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|