|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Entity
|
|
-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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SharedSet_ID
|
Shared Set
|
|
-99999999999
|
|
|
|
UsrRole_ID
|
User Role
|
|
-99999999999
|
|
|
|
UsrRoleScope_ID
|
Record ID
|
|
-99999999999
|
|
|
|
UsrRoleScopeValue
|
Role Scope Value
|
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
UsrRoleScope_ID
|
yes
|
no
|
|
|
SharedSet
|
no
|
SharedSet_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
UsrRoleScopeValue
|
yes
|
no
|
|
|
|
|
Company_ID
|
yes
|
no
|
|
|
|
|
SharedSet_ID
|
yes
|
no
|
|
|
|
|
UsrRole_ID
|
yes
|
no
|
|
|
UsrRole
|
no
|
UsrRole_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_usrw_wkfl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
usrw__qadc01
|
|
|
x(8)
|
|
|
|
usrw_charfld[15]
|
|
|
x(8)
|
|
|
|
usrw_datefld[4]
|
|
|
99/99/99
|
|
|
|
usrw_decfld[15]
|
|
|
->>,>>9.99
|
10
|
|
|
usrw_domain
|
Domain
|
|
x(8)
|
|
|
|
usrw_intfld[15]
|
|
|
->,>>>,>>9
|
|
|
|
usrw_key1
|
|
|
x(8)
|
|
|
|
usrw_key2
|
|
|
x(8)
|
|
|
|
usrw_key3
|
|
|
x(8)
|
|
|
|
usrw_key4
|
|
|
x(8)
|
|
|
|
usrw_key5
|
|
|
x(8)
|
|
|
|
usrw_key6
|
|
|
x(8)
|
|
|
|
usrw_logfld[15]
|
|
|
yes/no
|
|
|
|
usrw_user1
|
Ufld1
|
|
x(8)
|
|
|
|
usrw_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_usrw_wkfl
|
yes
|
oid_usrw_wkfl
|
yes
|
no
|
|
∗
|
usrw_index1
|
yes
|
usrw_domain
|
yes
|
no
|
|
|
|
|
usrw_key1
|
yes
|
no
|
|
|
|
|
usrw_key2
|
yes
|
no
|
|
|
usrw_index2
|
no
|
usrw_domain
|
yes
|
no
|
|
|
|
|
usrw_key3
|
yes
|
no
|
|
|
|
|
usrw_key4
|
yes
|
no
|
|
|
usrw_index3
|
no
|
usrw_domain
|
yes
|
no
|
|
|
|
|
usrw_key5
|
yes
|
no
|
|
|
|
|
usrw_key6
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_usr_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
usr__qad01
|
|
|
x(8)
|
|
|
|
usr__qad02
|
|
|
x(8)
|
|
|
|
usr__qadc01
|
QAD Character Field
|
|
X(8)
|
|
|
|
usr__qadc02
|
QAD Character Field
|
|
X(8)
|
|
|
|
usr__qadc03
|
QAD Character Field
|
|
x(8)
|
|
|
|
usr__qadc04
|
QAD Character Field
|
|
X(8)
|
|
|
|
usr__qadc05
|
|
|
x(24)
|
|
|
|
usr__qadi01
|
QAD Integer Field
|
|
>>>9
|
|
|
|
usr__qadi02
|
QAD Integer Field
|
|
>>9
|
|
|
|
usr__qadl01
|
QAD Logical Field
|
|
yes/no
|
|
|
|
usr__qadl02
|
QAD Logical Field
|
|
yes/no
|
|
|
|
usr__qadl03
|
|
|
yes/no
|
|
|
|
usr_access_loc
|
Access Location
|
|
x(8)
|
|
|
|
usr_access_type
|
Access Type
|
|
x(8)
|
|
|
|
usr_active
|
Active
|
Active
|
yes/no
|
|
|
|
usr_active_by
|
Active By
|
Active Changed By!User ID
|
x(8)
|
|
|
|
usr_active_date
|
Active Date
|
Active!Chg Date
|
99/99/99
|
|
|
|
usr_active_dir_enabled
|
Active Directory Enabled
|
|
yes/no
|
|
|
|
usr_active_dir_userid
|
Active Directory Userid
|
|
x(64)
|
|
|
|
usr_active_reason
|
Active Reason
|
Reason!Code
|
x(8)
|
|
|
|
usr_addr
|
Address
|
|
x(8)
|
|
|
|
usr_ctry_code
|
Country Code
|
Ctry
|
x(3)
|
|
|
|
usr_enabled
|
User Enabled
|
|
yes/no
|
|
|
|
usr_failed_attempts
|
Password Failed Attempts
|
Passwd Failed!Attempts
|
>>9
|
|
|
|
usr_force_change
|
Password Force Change
|
Passwd!Force!Change
|
yes/no
|
|
|
|
usr_initials
|
Initials
|
Init
|
x(20)
|
|
|
|
usr_lang
|
Language
|
Lang
|
x(2)
|
|
|
|
usr_last_date
|
Date Password Last Changed
|
Changed
|
99/99/99
|
|
|
|
usr_last_time
|
|
|
>>>>9
|
|
|
|
usr_ldap_dn
|
Ldap Username
|
|
x(256)
|
|
|
|
usr_ldap_instance
|
LDAP Instance Name
|
|
x(36)
|
|
|
|
usr_logon_date
|
Last Logon Date
|
Logon Date
|
99/99/99
|
|
|
|
usr_logon_time
|
Last Logon Time
|
Logon Time
|
>>>>9
|
|
|
|
usr_logon_timezone
|
Last Logon Time Zone
|
Server!Time!Zone
|
x(8)
|
|
|
|
usr_mail_address
|
E-mail Address
|
E-mail
|
x(60)
|
|
|
|
usr_mail_address_login
|
E-mail address login
|
|
yes/no
|
|
|
|
usr_name
|
User Name
|
|
x(35)
|
|
|
|
usr_passwd
|
Password
|
|
x(78)
|
|
|
|
usr_remark
|
Remark
|
|
x(60)
|
|
|
|
usr_restrict
|
Restricted
|
|
yes/no
|
|
|
|
usr_site
|
Site
|
|
x(8)
|
|
|
|
usr_timezone
|
Time Zone
|
|
x(8)
|
|
|
|
usr_type
|
User Type
|
|
x(8)
|
|
|
|
usr_tzdb
|
Time Zone DB
|
|
x(16)
|
|
|
|
usr_user1
|
Ufld1
|
|
x(8)
|
|
|
|
usr_user2
|
Ufld2
|
|
x(8)
|
|
|
|
usr_userid
|
User ID
|
|
x(8)
|
|
|
|
usr_variant_code
|
Variant
|
|
x(6)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_usr_mstr
|
yes
|
oid_usr_mstr
|
yes
|
no
|
|
|
usr_ad_userid
|
no
|
usr_active_dir_userid
|
yes
|
no
|
|
|
usr_mail_address
|
no
|
usr_mail_address
|
yes
|
no
|
|
∗
|
usr_userid
|
yes
|
usr_userid
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
TxuTaxUsage
|
Tax Usage
|
|
x(8)
|
|
|
|
Vat_ID
|
Record ID
|
|
-99999999999
|
|
|
|
VatAVRType
|
AVR Code
|
|
x(20)
|
|
|
|
VatCode
|
Tax Code
|
|
x(20)
|
|
|
|
VatDescription
|
Description
|
|
x(40)
|
|
|
|
VatInOut
|
Tax In/Out
|
In/Out
|
x(20)
|
|
|
|
VatInvoiceText
|
Tax Text on Invoice
|
|
x(2000)
|
|
|
|
VatIsAbsorbed
|
Absorbed
|
|
yes/no
|
|
|
|
VatIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
VatIsDelay
|
Delay
|
|
yes/no
|
|
|
|
VatIsGlobalTax
|
Global Tax
|
|
yes/no
|
|
|
|
VatIsRetained
|
Retained
|
|
yes/no
|
|
|
|
VatPercentageLevel
|
Tax Percentage Level
|
Pct Level
|
x(20)
|
|
|
|
VatTransactionType
|
Transaction Type
|
Trans Type
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
IsGlobal
|
no
|
VatIsGlobalTax
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Vat_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Domain_ID
|
yes
|
no
|
|
|
|
|
VatCode
|
yes
|
no
|
|
|
|
|
VatInOut
|
yes
|
no
|
|
|
VatCodeIdx
|
no
|
VatCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
VatIsActive
|
yes
|
no
|
|
|
|
|
VatCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Country_ID
|
Tax Country Code
|
Country
|
-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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
VatBox_ID
|
Record ID
|
|
-99999999999
|
|
|
|
VatBoxCode
|
Tax Box Code
|
Tax Box
|
x(20)
|
|
|
|
VatBoxDescription
|
Description
|
|
x(40)
|
|
|
|
VatBoxIsActive
|
Active
|
|
yes/no
|
|
|
|
VatBoxType
|
Tax Box Type
|
Type
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BoxCode
|
yes
|
VatBoxCode
|
yes
|
no
|
|
|
Country
|
no
|
Country_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
VatBox_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
VatBoxIsActive
|
yes
|
no
|
|
|
|
|
VatBoxCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
Country_ID
|
Link to Country
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
->,>>>,>>9
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
VatExport_ID
|
Record ID
|
|
-99999999999
|
|
|
|
VatExportEstimate
|
Estimated Declaration
|
|
->>,>>>,>>>,>>9
|
|
|
|
VatExportFileName
|
File Name
|
|
x(255)
|
|
|
|
VatExportMessageIdentity
|
Message ID
|
|
x(20)
|
|
|
|
VatExportPeriodType
|
Tax Period Type
|
|
x(20)
|
|
|
|
VatNumber_ID
|
Link to VatNumber
|
|
-99999999999
|
|
|
|
VatPeriod_ID
|
GL Period
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
Country
|
no
|
Country_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
VatExport_ID
|
yes
|
no
|
|
|
Unique2Idx
|
yes
|
VatExportMessageIdentity
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
VatExportPeriodType
|
yes
|
no
|
|
|
|
|
VatPeriod_ID
|
yes
|
no
|
|
|
|
|
Country_ID
|
yes
|
no
|
|
|
VatNumber
|
no
|
VatNumber_ID
|
yes
|
no
|
|
|
VatPeriod
|
no
|
VatPeriod_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
DiscountGLProfile_ID
|
Discount GL Profile
|
|
-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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
VatGroup_ID
|
Record ID
|
|
-99999999999
|
|
|
|
VatGroupCode
|
Tax Group Code
|
|
x(20)
|
|
|
|
VatGroupDescription
|
Description
|
|
x(40)
|
|
|
|
VatGroupIsActive
|
Active
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
VatGroupCode
|
yes
|
no
|
|
|
DiscountGLProfile
|
no
|
DiscountGLProfile_ID
|
yes
|
no
|
|
∗
|
prim
|
yes
|
VatGroup_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
VatGroupIsActive
|
yes
|
no
|
|
|
|
|
VatGroupCode
|
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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
VatBox_ID
|
Tax Box Code
|
|
-99999999999
|
|
|
|
VatGroup_ID
|
Link to VatGroup
|
|
-99999999999
|
|
|
|
VatGroupBoxLink_ID
|
Record ID
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
VatGroupBoxLink_ID
|
yes
|
no
|
|
|
VatBox
|
no
|
VatBox_ID
|
yes
|
no
|
|
|
VatGroup
|
no
|
VatGroup_ID
|
yes
|
no
|
|
|
VatGrpVatBox
|
yes
|
VatGroup_ID
|
yes
|
no
|
|
|
|
|
VatBox_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BusinessRelation_ID
|
Link to BusinessRelation
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
DeclarationCountry_ID
|
Country Tax Declaration
|
Country Tax Decl
|
-99999999999
|
|
|
|
IdentityCountry_ID
|
Country Tax Identification
|
Country Tax Ident
|
-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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
VatNumber_ID
|
Record ID
|
|
-99999999999
|
|
|
|
VatNumberDeclaration
|
Tax Declaration Number
|
Tax Declaration No
|
x(20)
|
|
|
|
VatNumberIdentity
|
Tax Identification Number
|
Tax Identification No
|
x(20)
|
|
|
|
VatNumberIsActive
|
Active
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BusinessRelation
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
Country
|
no
|
IdentityCountry_ID
|
yes
|
no
|
|
|
DeclaCountryIdx
|
no
|
DeclarationCountry_ID
|
yes
|
no
|
|
|
Indentity
|
no
|
VatNumberIdentity
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
VatNumber_ID
|
yes
|
no
|
|
|
VatNumberUniqueIdx
|
yes
|
BusinessRelation_ID
|
yes
|
no
|
|
|
|
|
VatNumberIdentity
|
yes
|
no
|
|
|
|
|
IdentityCountry_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
VatNumberIsActive
|
yes
|
no
|
|
|
|
|
VatNumberIdentity
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
VatPercent_ID
|
Record ID
|
|
-99999999999
|
|
|
|
VatPercentCode
|
Tax Percent Code
|
|
x(20)
|
|
|
|
VatPercentDescription
|
Description
|
|
x(40)
|
|
|
|
VatPercentIsActive
|
Active
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
VatPercentCode
|
yes
|
no
|
|
∗
|
prim
|
yes
|
VatPercent_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
VatPercentIsActive
|
yes
|
no
|
|
|
|
|
VatPercentCode
|
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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
VatPercent_ID
|
Link to VatPercent
|
|
-99999999999
|
|
|
|
VatPercentLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
VatPercentLineFromDate
|
Valid from
|
|
99/99/9999
|
|
|
|
VatPercentLinePercentage
|
Percentage
|
|
>>9.99
|
2
|
|
|
VatPercentLineTillDate
|
Valid to
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
prim
|
yes
|
VatPercentLine_ID
|
yes
|
no
|
|
|
VatPercent
|
no
|
VatPercent_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PeriodMark_ID
|
Mark
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
VatPeriod_ID
|
Record ID
|
|
-99999999999
|
|
|
|
VatPeriodEndDate
|
End Date
|
|
99/99/9999
|
|
|
|
VatPeriodIsReportChecked
|
Checked/Reported
|
|
yes/no
|
|
|
|
VatPeriodPeriod
|
Tax Period
|
Tax Pd
|
99
|
|
|
|
VatPeriodStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
VatPeriodStatus
|
Status
|
|
x(20)
|
|
|
|
VatPeriodYear
|
Tax Year
|
|
9999
|
|
|
|
VatPeriodYearPeriod
|
Tax Year/GL Period
|
Tax Year/GL Pd
|
999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
EndDate
|
no
|
VatPeriodEndDate
|
yes
|
no
|
|
|
PeriodMark
|
no
|
PeriodMark_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
VatPeriod_ID
|
yes
|
no
|
|
|
StartDate
|
no
|
VatPeriodStartDate
|
yes
|
no
|
|
|
VatPeriod
|
no
|
VatPeriodPeriod
|
yes
|
no
|
|
|
VatYear
|
no
|
VatPeriodYear
|
yes
|
no
|
|
|
YearPeriod
|
no
|
VatPeriodYearPeriod
|
yes
|
no
|
|
|
YearPeriodCompany
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
VatPeriodYear
|
yes
|
no
|
|
|
|
|
VatPeriodPeriod
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AbsorbedCreditNVatGroup_ID
|
Tax Group Code
|
|
-99999999999
|
|
|
|
AbsorbedInvoiceVatGroup_ID
|
Tax Group Code
|
|
-99999999999
|
|
|
|
CreditNoteGLProfile_ID
|
CN GL Profile
|
|
-99999999999
|
|
|
|
CreditNoteVatGroup_ID
|
Credit Note Tax Group
|
|
-99999999999
|
|
|
|
CreditVoucherVatGroup_ID
|
Tax Group Code
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
DelayedGLProfile_ID
|
Delayed GL Profile
|
|
-99999999999
|
|
|
|
InvoiceGLProfile_ID
|
Invoice GL Profile
|
|
-99999999999
|
|
|
|
InvoiceVatGroup_ID
|
Invoice Tax Group
|
|
-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)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RetainCVoucherVatGroup_ID
|
Tax Group Code
|
|
-99999999999
|
|
|
|
RetainVoucherVatGroup_ID
|
Tax Group Code
|
|
-99999999999
|
|
|
|
Vat_ID
|
Link to Vat
|
|
-99999999999
|
|
|
|
VatPercent_ID
|
Tax Percentage
|
|
-99999999999
|
|
|
|
VatRule_ID
|
Record ID
|
|
-99999999999
|
|
|
|
VatRuleBaseFull
|
Base/Full
|
|
x(20)
|
|
|
|
VatRuleDelayCorrection
|
Delay Correction
|
|
9
|
|
|
|
VatRuleDescription
|
Description
|
|
x(40)
|
|
|
|
VatRuleIsDelayed
|
Delayed
|
|
yes/no
|
|
|
|
VatRuleIsPassBaseValue
|
Base Value
|
|
yes/no
|
|
|
|
VatRuleIsPosting
|
Posting
|
|
yes/no
|
|
|
|
VatRuleMovementType
|
Activity Type
|
|
x(20)
|
|
|
|
VatRuleOperator
|
Operator
|
Opr
|
x(1)
|
|
|
|
VatRuleRef1
|
Reference 1
|
Ref 1
|
x(20)
|
|
|
|
VatRuleRef2
|
Reference 2
|
Ref 2
|
x(20)
|
|
|
|
VatRuleRounding
|
Rounding
|
|
x(20)
|
|
|
|
VatRuleSequence
|
Sequence
|
Seq
|
->,>>>,>>9
|
|
|
|
VatRuleUsage
|
Usage
|
|
x(20)
|
|
|
|
VatRuleValue
|
Value
|
|
->>,>>>,>>>,>>9.9999
|
4
|
|
|
VoucherVatGroup_ID
|
Tax Group Code
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AbsCNVatGrpIdx
|
no
|
AbsorbedCreditNVatGroup_ID
|
yes
|
no
|
|
|
AbsInvVatGrpIdx
|
no
|
AbsorbedInvoiceVatGroup_ID
|
yes
|
no
|
|
|
BaseFull
|
no
|
VatRuleBaseFull
|
yes
|
no
|
|
|
CreditNoteGLProfile
|
no
|
CreditNoteGLProfile_ID
|
yes
|
no
|
|
|
CreditNoteVatGroup
|
no
|
CreditNoteVatGroup_ID
|
yes
|
no
|
|
|
CredVatGrpIdx
|
no
|
CreditVoucherVatGroup_ID
|
yes
|
no
|
|
|
DiscountGLProfile
|
no
|
DelayedGLProfile_ID
|
yes
|
no
|
|
|
InvoiceGLProfileIdx
|
no
|
InvoiceGLProfile_ID
|
yes
|
no
|
|
|
InvoiceVatGroup
|
no
|
InvoiceVatGroup_ID
|
yes
|
no
|
|
|
LogicalKeyUniqueIdx
|
yes
|
VatRuleBaseFull
|
yes
|
no
|
|
|
|
|
VatRuleSequence
|
yes
|
no
|
|
|
|
|
Vat_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
VatRule_ID
|
yes
|
no
|
|
|
RetCNVatGrpIdx
|
no
|
RetainCVoucherVatGroup_ID
|
yes
|
no
|
|
|
RetInvVatGrpIdx
|
no
|
RetainVoucherVatGroup_ID
|
yes
|
no
|
|
|
Vat
|
no
|
Vat_ID
|
yes
|
no
|
|
|
VatPercIdx
|
no
|
VatPercent_ID
|
yes
|
no
|
|
|
VoucherVatGrpIdx
|
no
|
VoucherVatGroup_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_vdf_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
vdf__qadc01
|
|
|
x(24)
|
|
|
|
vdf__qadc02
|
|
|
x(24)
|
|
|
|
vdf__qadc03
|
|
|
x(24)
|
|
|
|
vdf__qadc04
|
|
|
x(24)
|
|
|
|
vdf__qadc05
|
|
|
x(24)
|
|
|
|
vdf__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
vdf__qadd02
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
vdf__qadi01
|
|
|
->>>>>>>9
|
|
|
|
vdf__qadi02
|
|
|
->>>>>>>9
|
|
|
|
vdf__qadl01
|
|
|
yes/no
|
|
|
|
vdf__qadl02
|
|
|
yes/no
|
|
|
|
vdf__qadt01
|
|
|
99/99/99
|
|
|
|
vdf__qadt02
|
|
|
99/99/99
|
|
|
|
vdf_addr
|
Supplier
|
|
x(8)
|
|
|
|
vdf_birthcity
|
Birth City
|
|
x(20)
|
|
|
|
vdf_birthday
|
Birth Date
|
|
99/99/99
|
|
|
|
vdf_domain
|
Domain
|
|
x(8)
|
|
|
|
vdf_fiscal_code
|
Fiscal Code
|
|
x(16)
|
|
|
|
vdf_for_fiscal_code
|
Foreign Fiscal Code
|
|
x(16)
|
|
|
|
vdf_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
vdf_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
vdf_rsn_code
|
Reason Code
|
|
x(8)
|
|
|
|
vdf_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
vdf_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
vdf_userc03
|
User Field Character 3
|
|
x(24)
|
|
|
|
vdf_userc04
|
User Field Character 4
|
|
x(24)
|
|
|
|
vdf_userc05
|
User Field Character 5
|
|
x(24)
|
|
|
|
vdf_userd01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
vdf_userd02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
vdf_useri01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
vdf_useri02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
vdf_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
vdf_userl02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
vdf_usert01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
vdf_usert02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
vdf_withholdtax
|
Withholding Tax
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_vdf_mstr
|
yes
|
oid_vdf_mstr
|
yes
|
no
|
|
∗
|
vdf_addr
|
yes
|
vdf_domain
|
yes
|
no
|
|
|
|
|
vdf_addr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_order_reference
|
Reference OID
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_vd_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_vdnb_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_vdnbd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
vdnbd__qadc01
|
|
|
x(24)
|
|
|
|
vdnbd__qadc02
|
|
|
x(24)
|
|
|
|
vdnbd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
vdnbd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
vdnbd_order_ref_table
|
Reference Table
|
|
x(14)
|
|
|
|
vdnbd_orig_qty
|
Original Quantity
|
|
>>,>>>,>>9.9<<<<<<<
|
10
|
|
|
vdnbd_pallet_qty
|
Pallet Quantity
|
|
>>9
|
|
|
|
vdnbd_reference
|
Reference
|
|
x(24)
|
|
|
|
vdnbd_schd_qty
|
Scheduled Quantity
|
|
>>,>>>,>>9.9<<<<<<<
|
10
|
|
|
vdnbd_sequence
|
Sequence
|
|
>>>>>>9
|
|
|
|
vdnbd_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
vdnbd_user2
|
User Field Character2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_order_reference
|
no
|
oid_order_reference
|
yes
|
no
|
|
|
oid_vdnbd_det
|
yes
|
oid_vdnbd_det
|
yes
|
no
|
|
∗
|
vdnbd_det_sequence
|
yes
|
oid_vdnb_mstr
|
yes
|
no
|
|
|
|
|
vdnbd_sequence
|
yes
|
no
|
|
|
|
|
oid_order_reference
|
yes
|
no
|
|
|
vdnbd_det_vendor
|
no
|
oid_vdnb_mstr
|
yes
|
no
|
|
|
|
|
oid_vd_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_tm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_vdnb_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
vdnb__qadc01
|
|
|
x(24)
|
|
|
|
vdnb__qadc02
|
|
|
x(24)
|
|
|
|
vdnb_bill_date
|
Pick up Date
|
|
99/99/99
|
|
|
|
vdnb_bill_id
|
Bill ID
|
|
x(16)
|
|
|
|
vdnb_bill_volume
|
Current Volume
|
|
>>>,>>>,>>9.9<<<
|
10
|
|
|
vdnb_bill_volume_um
|
UM
|
|
x(2)
|
|
|
|
vdnb_bill_weight
|
Current Weight
|
|
>>>,>>>,>>9.9<<<
|
10
|
|
|
vdnb_bill_weight_um
|
UM
|
|
x(2)
|
|
|
|
vdnb_carrier
|
Carrier
|
|
x(8)
|
|
|
|
vdnb_domain
|
Domain
|
|
x(8)
|
|
|
|
vdnb_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
vdnb_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
vdnb_network_id
|
Network ID
|
|
x(18)
|
|
|
|
vdnb_pallet_locations
|
Pallet Floor Locations Consumed
|
|
>>9
|
|
|
|
vdnb_site
|
Site
|
|
x(8)
|
|
|
|
vdnb_status
|
Pickup Sheet Status
|
|
x(8)
|
|
|
|
vdnb_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
vdnb_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_vdnb_mstr
|
yes
|
oid_vdnb_mstr
|
yes
|
no
|
|
∗
|
vdnb_mstr_bill_id
|
yes
|
vdnb_domain
|
yes
|
no
|
|
|
|
|
vdnb_site
|
yes
|
no
|
|
|
|
|
vdnb_bill_id
|
yes
|
no
|
|
|
vdnb_mstr_status
|
no
|
vdnb_domain
|
yes
|
no
|
|
|
|
|
vdnb_status
|
yes
|
no
|
|
|
|
|
vdnb_site
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_vdn_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_vdns_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
vdns__qadc01
|
|
|
X(24)
|
|
|
|
vdns__qadc02
|
|
|
X(24)
|
|
|
|
vdns_domain
|
Domain
|
|
x(8)
|
|
|
|
vdns_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
vdns_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
vdns_order
|
Purchase Order
|
|
x(8)
|
|
|
|
vdns_pickup_dock
|
Pickup Dock
|
|
x(8)
|
|
|
|
vdns_pickup_end
|
Pickup End
|
|
99:99
|
|
|
|
vdns_pickup_start
|
Pickup Start
|
|
99:99
|
|
|
|
vdns_sequence
|
Sequence
|
|
>>9
|
|
|
|
vdns_user1
|
User Field Character 1
|
|
X(24)
|
|
|
|
vdns_user2
|
User Field Character 2
|
|
X(24)
|
|
|
|
vdns_vendor
|
Supplier
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_vdns_det
|
yes
|
oid_vdns_det
|
yes
|
no
|
|
∗
|
vdns_det
|
yes
|
oid_vdn_mstr
|
yes
|
no
|
|
|
|
|
vdns_vendor
|
yes
|
no
|
|
|
|
|
vdns_order
|
yes
|
no
|
|
|
vdns_sequence
|
no
|
oid_vdn_mstr
|
yes
|
no
|
|
|
|
|
vdns_sequence
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_tm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_vdn_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_vdnt_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
vdnt__qadc01
|
|
|
X(24)
|
|
|
|
vdnt__qadc02
|
|
|
X(24)
|
|
|
|
vdnt_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
vdnt_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
vdnt_primary
|
Primary
|
|
yes/no
|
|
|
|
vdnt_user1
|
User Field Character 1
|
|
X(24)
|
|
|
|
vdnt_user2
|
User Field Character 2
|
|
X(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_vdnt_det
|
yes
|
oid_vdnt_det
|
yes
|
no
|
|
∗
|
vdnt_det
|
yes
|
oid_vdn_mstr
|
yes
|
no
|
|
|
|
|
oid_tm_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_vdn_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
vdn__qadc01
|
|
|
X(24)
|
|
|
|
vdn__qadc02
|
|
|
X(24)
|
|
|
|
vdn_desc
|
Description
|
|
x(24)
|
|
|
|
vdn_domain
|
Domain
|
|
x(8)
|
|
|
|
vdn_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
vdn_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
vdn_network_id
|
Network ID
|
|
x(18)
|
|
|
|
vdn_planner
|
Planner
|
|
x(8)
|
|
|
|
vdn_rule_id
|
Optimization Rule
|
|
x(2)
|
|
|
|
vdn_site
|
Site
|
|
x(8)
|
|
|
|
vdn_start
|
Start
|
|
99/99/99
|
|
|
|
vdn_user1
|
User Field Character 1
|
|
X(24)
|
|
|
|
vdn_user2
|
User Field Character 2
|
|
X(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_vdn_mstr
|
yes
|
oid_vdn_mstr
|
yes
|
no
|
|
∗
|
vdn_mstr
|
yes
|
vdn_domain
|
yes
|
no
|
|
|
|
|
vdn_network_id
|
yes
|
no
|
|
|
|
|
vdn_site
|
yes
|
no
|
|
|
|
|
vdn_start
|
yes
|
no
|
|
|
vdn_planner
|
no
|
vdn_domain
|
yes
|
no
|
|
|
|
|
vdn_planner
|
yes
|
no
|
|
|
|
|
vdn_site
|
yes
|
no
|
|
|
|
|
vdn_network_id
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_btr_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_vd_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
vd__chr01
|
|
|
x(8)
|
|
|
|
vd__chr02
|
|
|
x(8)
|
|
|
|
vd__chr03
|
|
|
x(8)
|
|
|
|
vd__chr04
|
|
|
x(8)
|
|
|
|
vd__chr05
|
|
|
x(8)
|
|
|
|
vd__chr06
|
|
|
x(8)
|
|
|
|
vd__chr07
|
|
|
x(8)
|
|
|
|
vd__chr08
|
|
|
x(8)
|
|
|
|
vd__chr09
|
|
|
x(8)
|
|
|
|
vd__chr10
|
|
|
x(8)
|
|
|
|
vd__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
vd__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
vd__dte01
|
|
|
99/99/99
|
|
|
|
vd__dte02
|
|
|
99/99/99
|
|
|
|
vd__log01
|
|
|
yes/no
|
|
|
|
vd__qadc01
|
QAD Field
|
|
X(8)
|
0
|
|
|
vd__qadc02
|
QAD Field
|
|
X(8)
|
0
|
|
|
vd__qadc03
|
QAD Field
|
|
X(8)
|
0
|
|
|
vd__qadc04
|
QAD Field
|
|
X(8)
|
0
|
|
|
vd__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
vd__qadd02
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
vd__qadi01
|
|
|
>>>>>>9
|
|
|
|
vd__qadi02
|
|
|
>>>>>>9
|
|
|
|
vd__qadl01
|
|
|
yes/no
|
|
|
|
vd__qadl02
|
|
|
yes/no
|
|
|
|
vd__qadl03
|
|
|
yes/no
|
|
|
|
vd__qadl04
|
|
|
yes/no
|
|
|
|
vd__qadt01
|
|
|
99/99/99
|
|
|
|
vd__qadt02
|
|
|
99/99/99
|
|
|
|
vd_1099
|
Tax Report
|
Tax Rpt
|
yes/no
|
|
|
|
vd_active
|
Active
|
|
yes/no
|
|
|
|
vd_addr
|
Supplier
|
|
x(8)
|
|
|
|
vd_ap_acct
|
AP Account
|
AP Acct
|
x(8)
|
|
|
|
vd_ap_cc
|
AP Cost Ctr
|
CC
|
x(4)
|
|
|
|
vd_ap_cntct
|
AP Contact
|
|
x(24)
|
|
|
|
vd_ap_sub
|
AP Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
vd_balance
|
Balance
|
|
->>>,>>>,>>9.99
|
10
|
|
|
vd_bank
|
Bank
|
|
x(2)
|
|
|
|
vd_buyer
|
Buyer
|
|
x(8)
|
|
|
|
vd_carrier_id
|
Carrier
|
|
x(8)
|
|
|
|
vd_ckfrm
|
Check Form
|
Ck
|
x(2)
|
|
|
|
vd_conrep_logic
|
Consume/Replace Logic
|
|
x(1)
|
|
|
|
vd_cr_terms
|
Cr Terms
|
|
x(8)
|
|
|
|
vd_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
vd_data_complete
|
Data Complete
|
|
yes/no
|
|
|
|
vd_daybookset
|
Daybook Set
|
Dybk Set
|
x(8)
|
|
|
|
vd_db
|
DB Number
|
|
x(16)
|
|
|
|
vd_debtor
|
Debtor Number
|
Debtor
|
x(10)
|
|
|
|
vd_disc_pct
|
Disc %
|
|
->9.99%
|
10
|
|
|
vd_domain
|
Domain
|
|
x(8)
|
|
|
|
vd_drft_bal
|
Draft Balance
|
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
vd_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
vd_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
vd_fob
|
FOB
|
|
x(20)
|
|
|
|
vd_fr_list
|
Freight List
|
Frt List
|
x(8)
|
|
|
|
vd_fr_min_wt
|
Min Frt Wt
|
|
->>>,>>>,>>9
|
0
|
|
|
vd_fr_terms
|
Freight Terms
|
Fr Terms
|
x(8)
|
|
|
|
vd_gst_id
|
Tax ID - Federal
|
|
x(18)
|
|
|
|
vd_hold
|
Payment Hold
|
Hold
|
yes/no
|
|
|
|
vd_kanban_supplier
|
Kanban Supplier
|
|
yes/no
|
|
|
|
vd_lang
|
Language
|
|
x(2)
|
|
|
|
vd_last_ck
|
Last Check
|
|
99/99/99
|
|
|
|
vd_lc_bal
|
LC Balance
|
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
vd_misc_cr
|
Miscellaneous Creditor
|
|
yes/no
|
|
|
|
vd_misc1_id
|
Tax ID - Misc 1
|
|
x(18)
|
|
|
|
vd_misc2_id
|
Tax ID - Misc 2
|
|
x(18)
|
|
|
|
vd_misc3_id
|
Tax ID - Misc 3
|
|
x(18)
|
|
|
|
vd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
vd_partial
|
Partial OK
|
Partial
|
yes/no
|
|
|
|
vd_pay_spec
|
Pay Specification
|
Pay Spec
|
yes/no
|
|
|
|
vd_pr_list
|
Disc Tbl
|
|
x(8)
|
|
|
|
vd_pr_list2
|
Price Tbl
|
Pr Tbl
|
x(8)
|
|
|
|
vd_prepay
|
Prepayment Balance
|
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
vd_promo
|
Promotion Group
|
|
x(8)
|
|
|
|
vd_pst_id
|
Tax ID - State
|
|
x(18)
|
|
|
|
vd_pur_acct
|
Pur Acct
|
|
x(8)
|
|
|
|
vd_pur_cc
|
Pur Cost Ctr
|
CC
|
x(4)
|
|
|
|
vd_pur_cntct
|
Purchase Contact
|
|
x(24)
|
|
|
|
vd_pur_sub
|
Pur Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
vd_rcv_held_so
|
Send Credit Held SO
|
Rec Cr Hd
|
yes/no
|
|
|
|
vd_rcv_so_price
|
Send SO Price
|
Rec Ext Price
|
yes/no
|
|
|
|
vd_remit
|
Remit-to
|
|
x(8)
|
|
|
|
vd_rmks
|
Remarks
|
|
x(40)
|
|
|
|
vd_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
vd_site
|
Site
|
|
x(8)
|
|
|
|
vd_sort
|
Sort Name
|
|
x(28)
|
|
|
|
vd_tax_id
|
Tax ID
|
|
x(18)
|
|
|
|
vd_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
vd_tax_in_city
|
In City
|
|
yes/no
|
|
|
|
vd_tax_usage
|
Tax Usage
|
Tax Use
|
x(8)
|
|
|
|
vd_tax_zone
|
Tax Zone
|
|
x(16)
|
|
|
|
vd_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
vd_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
vd_tid_notice
|
TID Notice
|
T!N
|
x(1)
|
|
|
|
vd_tot_terms_code
|
Terms of Trade
|
|
x(8)
|
|
|
|
vd_tp_pct
|
SO Price Reduction
|
Ext %
|
>>9.99%
|
10
|
|
|
vd_tp_use_pct
|
Use SO Reduction Price
|
Use Trans Price
|
yes/no
|
|
|
|
vd_type
|
Type
|
|
x(4)
|
|
|
|
vd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
vd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
vd_userid
|
User ID
|
|
x(8)
|
|
|
|
vd_vt_id
|
VAT ID
|
|
x(18)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_vd_mstr
|
yes
|
oid_vd_mstr
|
yes
|
no
|
|
|
vd_active
|
no
|
vd_domain
|
yes
|
no
|
|
|
|
|
vd_active
|
yes
|
no
|
|
∗
|
vd_addr
|
yes
|
vd_domain
|
yes
|
no
|
|
|
|
|
vd_addr
|
yes
|
no
|
|
|
vd_datacomplete
|
no
|
vd_domain
|
yes
|
no
|
|
|
|
|
vd_data_complete
|
yes
|
no
|
|
|
vd_remit
|
no
|
vd_domain
|
yes
|
no
|
|
|
|
|
vd_remit
|
yes
|
no
|
|
|
|
|
vd_addr
|
yes
|
no
|
|
|
vd_sort
|
no
|
vd_domain
|
yes
|
no
|
|
|
|
|
vd_sort
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_vecd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
vecd__qadc01
|
QAD Field
|
|
X(8)
|
0
|
|
|
vecd__qadc02
|
QAD Field
|
|
X(8)
|
0
|
|
|
vecd__qadc03
|
QAD Field
|
|
X(8)
|
0
|
|
|
vecd__qadc04
|
QAD Field
|
|
X(8)
|
0
|
|
|
vecd__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
vecd__qadd02
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
vecd__qadi01
|
|
|
>>>>>>9
|
|
|
|
vecd__qadi02
|
|
|
>>>>>>9
|
|
|
|
vecd__qadl01
|
|
|
yes/no
|
|
|
|
vecd__qadl02
|
|
|
yes/no
|
|
|
|
vecd__qadt01
|
|
|
99/99/99
|
|
|
|
vecd__qadt02
|
|
|
99/99/99
|
|
|
|
vecd_category
|
Category
|
|
x(8)
|
|
|
|
vecd_domain
|
Domain
|
|
x(8)
|
|
|
|
vecd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
vecd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
vecd_percent
|
Percent
|
|
>>9.99
|
10
|
|
|
vecd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
vecd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
vecd_user3
|
|
|
x(8)
|
|
|
|
vecd_user4
|
|
|
x(8)
|
|
|
|
vecd_value_from
|
Value From
|
|
->>>>,>>9.99
|
10
|
|
|
vecd_value_to
|
Value To
|
|
->>>>,>>9.99
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_vecd_det
|
yes
|
oid_vecd_det
|
yes
|
no
|
|
∗
|
vecd_category
|
yes
|
vecd_domain
|
yes
|
no
|
|
|
|
|
vecd_category
|
yes
|
no
|
|
|
|
|
vecd_value_from
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_vec_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
vec__qadc01
|
QAD Field
|
|
X(8)
|
0
|
|
|
vec__qadc02
|
QAD Field
|
|
X(8)
|
0
|
|
|
vec__qadc03
|
QAD Field
|
|
X(8)
|
0
|
|
|
vec__qadc04
|
QAD Field
|
|
X(8)
|
0
|
|
|
vec__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
vec__qadd02
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
vec__qadi01
|
|
|
>>>>>>9
|
|
|
|
vec__qadi02
|
|
|
>>>>>>9
|
|
|
|
vec__qadl01
|
|
|
yes/no
|
|
|
|
vec__qadl02
|
|
|
yes/no
|
|
|
|
vec__qadt01
|
|
|
99/99/99
|
|
|
|
vec__qadt02
|
|
|
99/99/99
|
|
|
|
vec_active_flag
|
Use Category
|
|
yes/no
|
|
|
|
vec_category
|
Category
|
|
x(8)
|
|
|
|
vec_comp_method
|
Computation Method
|
|
X(12)
|
|
|
|
vec_desc
|
Description
|
|
x(24)
|
|
|
|
vec_discrete_type
|
Discrete Type
|
|
Add/Deduct
|
|
|
|
vec_domain
|
Domain
|
|
x(8)
|
|
|
|
vec_max_points
|
Maximum Points
|
|
->,>>>,>>9
|
|
|
|
vec_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
vec_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
vec_name
|
Name
|
|
x(12)
|
|
|
|
vec_pp_counter
|
Parts-Per Counter
|
|
Events/Quantity
|
|
|
|
vec_pp_factor
|
Parts-Per Factor
|
|
>,>>>,>>>,>>9
|
|
|
|
vec_table_lookup_flag
|
Use Lookup Table
|
|
yes/no
|
|
|
|
vec_threshold_points
|
Threshold Points
|
|
->,>>>,>>9
|
|
|
|
vec_user1
|
Ufld1
|
|
x(8)
|
|
|
|
vec_user2
|
Ufld2
|
|
x(8)
|
|
|
|
vec_user3
|
|
|
x(8)
|
|
|
|
vec_user4
|
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_vec_mstr
|
yes
|
oid_vec_mstr
|
yes
|
no
|
|
∗
|
vec_category
|
yes
|
vec_domain
|
yes
|
no
|
|
|
|
|
vec_category
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_vee_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
vee__qadc01
|
QAD Field
|
|
X(8)
|
0
|
|
|
vee__qadc02
|
QAD Field
|
|
X(8)
|
0
|
|
|
vee__qadc03
|
QAD Field
|
|
X(8)
|
0
|
|
|
vee__qadc04
|
QAD Field
|
|
X(8)
|
0
|
|
|
vee__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
vee__qadd02
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
vee__qadi01
|
|
|
>>>>>>9
|
|
|
|
vee__qadi02
|
|
|
>>>>>>9
|
|
|
|
vee__qadl01
|
|
|
yes/no
|
|
|
|
vee__qadl02
|
|
|
yes/no
|
|
|
|
vee__qadt01
|
|
|
99/99/99
|
|
|
|
vee__qadt02
|
|
|
99/99/99
|
|
|
|
vee_desc
|
Description
|
|
x(24)
|
|
|
|
vee_domain
|
Domain
|
|
x(8)
|
|
|
|
vee_event
|
Event Code
|
|
x(8)
|
|
|
|
vee_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
vee_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
vee_name
|
Name
|
|
x(12)
|
|
|
|
vee_points
|
Points
|
|
>>>>,>>9.99
|
10
|
|
|
vee_user1
|
Ufld1
|
|
x(8)
|
|
|
|
vee_user2
|
Ufld2
|
|
x(8)
|
|
|
|
vee_user3
|
|
|
x(8)
|
|
|
|
vee_user4
|
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_vee_mstr
|
yes
|
oid_vee_mstr
|
yes
|
no
|
|
∗
|
vee_event
|
yes
|
vee_domain
|
yes
|
no
|
|
|
|
|
vee_event
|
yes
|
no
|