|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
act__qadc01
|
|
|
x(8)
|
|
|
|
act_charge_type
|
Charge Type
|
Charge!Type
|
x(8)
|
|
|
|
act_cont_part
|
Alternate Container
|
|
x(18)
|
|
|
|
act_domain
|
Domain
|
|
x(8)
|
|
|
|
act_line
|
|
|
>>9
|
|
|
|
act_nbr
|
Alternate Container
|
|
x(8)
|
|
|
|
act_ord_mult
|
Std Pack Qty
|
|
>>,>>>,>>9
|
|
|
|
act_user1
|
Ufld1
|
|
x(8)
|
|
|
|
act_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_act_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
act_order
|
yes
|
act_domain
|
yes
|
no
|
|
|
|
|
act_nbr
|
yes
|
no
|
|
|
|
|
act_line
|
yes
|
no
|
|
|
|
|
act_cont_part
|
yes
|
no
|
|
|
oid_act_mstr
|
yes
|
oid_act_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ac__chr01
|
|
|
x(8)
|
|
|
|
ac__chr02
|
|
|
x(8)
|
|
|
|
ac__chr03
|
|
|
x(8)
|
|
|
|
ac__chr04
|
|
|
x(8)
|
|
|
|
ac__dte01
|
|
|
99/99/99
|
|
|
|
ac__dte02
|
|
|
99/99/99
|
|
|
|
ac__log01
|
|
|
yes/no
|
|
|
|
ac__log02
|
|
|
yes/no
|
|
|
|
ac__qad01
|
|
|
99/99/99
|
|
|
|
ac__qad03
|
Calc Unrealized Gain/Loss
|
|
x(1)
|
|
|
|
ac__qad04
|
|
|
x(8)
|
|
|
|
ac_active
|
Active
|
Act
|
yes/no
|
|
|
|
ac_canrun
|
Users/Roles
|
|
x(189)
|
|
|
|
ac_code
|
Account
|
|
x(8)
|
|
|
|
ac_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
ac_desc
|
Description
|
|
x(24)
|
|
|
|
ac_domain
|
Domain
|
|
x(8)
|
|
|
|
ac_fpos
|
Format Position
|
Format
|
>>>>>9
|
|
|
|
ac_fx_index
|
Curr Translation Index
|
Ind
|
x(1)
|
|
|
|
ac_gl_system_type
|
GL Account System Type
|
|
x(20)
|
|
|
|
ac_gl_type
|
GL Account Type
|
|
x(20)
|
|
|
|
ac_match_seq
|
Matching Sequence
|
|
x(24)
|
|
|
|
ac_modl_only
|
Sub-Module Entries Only
|
Sub!Only
|
yes/no
|
|
|
|
ac_stat_acc
|
Statistical Account
|
Stat Acc
|
x(8)
|
|
|
|
ac_stat_cc
|
Statistical Cost Ctr
|
CC
|
x(4)
|
|
|
|
ac_type
|
Type
|
T
|
x(1)
|
|
|
|
ac_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ac_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ac_xctr
|
Book Type
|
Book!Type
|
x(1)
|
|
|
|
ac_xret_acc
|
|
|
x(8)
|
|
|
|
ac_xret_cc
|
|
|
x(4)
|
|
|
|
oid_ac_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ac_active
|
no
|
ac_domain
|
yes
|
no
|
|
|
|
|
ac_active
|
yes
|
no
|
|
|
|
|
ac_code
|
yes
|
no
|
|
∗
|
ac_code
|
yes
|
ac_domain
|
yes
|
no
|
|
|
|
|
ac_code
|
yes
|
no
|
|
|
ac_curr
|
no
|
ac_domain
|
yes
|
no
|
|
|
|
|
ac_curr
|
yes
|
no
|
|
|
ac_desc
|
no
|
ac_domain
|
yes
|
no
|
|
|
|
|
ac_desc
|
yes
|
no
|
|
|
|
|
ac_code
|
yes
|
no
|
|
|
ac_fpos
|
no
|
ac_domain
|
yes
|
no
|
|
|
|
|
ac_fpos
|
yes
|
no
|
|
|
|
|
ac_code
|
yes
|
no
|
|
|
ac_type
|
no
|
ac_domain
|
yes
|
no
|
|
|
|
|
ac_type
|
yes
|
no
|
|
|
|
|
ac_code
|
yes
|
no
|
|
|
oid_ac_mstr
|
yes
|
oid_ac_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
adc__qadc01
|
|
|
x(8)
|
|
|
|
adc__qadi01
|
|
|
->>>>>>>9
|
|
|
|
adc_domain
|
Domain
|
|
x(8)
|
|
|
|
adc_format
|
Format
|
|
>9
|
|
|
|
adc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
adc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_adc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
adc_index1
|
yes
|
adc_domain
|
yes
|
no
|
|
|
oid_adc_ctrl
|
yes
|
oid_adc_ctrl
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Address_ID
|
Record ID
|
|
-99999999999
|
|
|
|
AddressCity
|
City
|
|
X(20)
|
|
|
|
AddressCityCode
|
City Code
|
|
x(20)
|
|
|
|
AddressCounty
|
County
|
|
x(40)
|
|
|
|
AddressEMail
|
E-Mail
|
|
x(48)
|
|
|
|
AddressExternalValidationCode
|
External Validation Code
|
|
x(1)
|
|
|
|
AddressFax
|
Fax
|
|
x(40)
|
|
|
|
AddressFormat
|
Format
|
|
->,>>>,>>9
|
|
|
|
AddressIsSendToPostal
|
Send Documents
|
|
yes/no
|
|
|
|
AddressIsTaxable
|
Taxable Address
|
|
yes/no
|
|
|
|
AddressIsTaxInCity
|
Tax in City
|
|
yes/no
|
|
|
|
AddressIsTaxIncluded
|
Tax Is Included
|
|
yes/no
|
|
|
|
AddressIsTemporary
|
Temporary
|
Temp
|
yes/no
|
|
|
|
AddressLogicKeyString
|
Logic Key String
|
|
x(40)
|
|
|
|
AddressName
|
Name
|
|
x(36)
|
|
|
|
AddressPostalAddress1
|
Postal Address
|
|
x(40)
|
|
|
|
AddressPostalAddress2
|
Postal Address
|
|
x(40)
|
|
|
|
AddressPostalCity
|
City
|
|
x(20)
|
|
|
|
AddressPostalZip
|
Zip/City
|
Zip Code
|
x(40)
|
|
|
|
AddressSearchName
|
Search Name
|
|
x(28)
|
|
|
|
AddressState
|
State
|
|
x(20)
|
|
|
|
AddressStreet1
|
Address
|
|
x(36)
|
|
|
|
AddressStreet2
|
Address
|
|
x(36)
|
|
|
|
AddressStreet3
|
Address
|
|
x(36)
|
|
|
|
AddressTaxDeclaration
|
Tax Declaration
|
|
->,>>>,>>9
|
|
|
|
AddressTaxIDFederal
|
Federal Tax
|
|
x(18)
|
|
|
|
AddressTaxIDMisc1
|
Miscellaneous Tax 1
|
|
x(18)
|
|
|
|
AddressTaxIDMisc2
|
Miscellaneous Tax 2
|
|
x(18)
|
|
|
|
AddressTaxIDMisc3
|
Miscellaneous Tax 3
|
|
x(18)
|
|
|
|
AddressTaxIDState
|
State Tax
|
|
x(18)
|
|
|
|
AddressTelephone
|
Telephone
|
|
x(40)
|
|
|
|
AddressType_ID
|
Address Type
|
Type
|
-99999999999
|
|
|
|
AddressWebSite
|
Internet
|
|
x(60)
|
|
|
|
AddressZip
|
Zip/City
|
Zip Code
|
x(10)
|
|
|
|
BusinessRelation_ID
|
Link to BusinessRelation
|
|
-99999999999
|
|
|
|
Country_ID
|
Country Format
|
|
-99999999999
|
|
|
|
County_ID
|
Description
|
|
-99999999999
|
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo10
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo11
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo12
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo13
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo14
|
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)
|
|
|
|
CustomShort10
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort11
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort12
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort13
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort14
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort15
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort16
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort17
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort18
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort19
|
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)
|
|
|
|
Lng_ID
|
Language Code
|
Lang
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
State_ID
|
Description
|
|
-99999999999
|
|
|
|
TxclTaxCls
|
Tax Class
|
|
x(3)
|
|
|
|
TxuTaxUsage
|
Tax Usage
|
|
x(8)
|
|
|
|
TxzTaxZone
|
Tax Zone
|
|
x(16)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AddressType
|
no
|
AddressType_ID
|
yes
|
no
|
|
|
BusinesRelation
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
City
|
no
|
AddressCity
|
yes
|
no
|
|
|
Country
|
no
|
Country_ID
|
yes
|
no
|
|
|
CountryIdx
|
no
|
County_ID
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
LngIdx
|
no
|
Lng_ID
|
yes
|
no
|
|
|
NameIdx
|
no
|
AddressName
|
yes
|
no
|
|
|
PostalCode
|
no
|
AddressZip
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Address_ID
|
yes
|
no
|
|
|
SNameIdx
|
no
|
AddressSearchName
|
yes
|
no
|
|
|
StateIdx
|
no
|
State_ID
|
yes
|
no
|
|
|
TaxClass
|
no
|
TxclTaxCls
|
yes
|
no
|
|
|
TaxIDs
|
no
|
AddressTaxIDFederal
|
yes
|
no
|
|
|
|
|
AddressTaxIDState
|
yes
|
no
|
|
|
TaxZone
|
no
|
TxzTaxZone
|
yes
|
no
|
|
|
UniqueKey
|
yes
|
BusinessRelation_ID
|
yes
|
no
|
|
|
|
|
AddressType_ID
|
yes
|
no
|
|
|
|
|
AddressLogicKeyString
|
yes
|
no
|
|
|
UniqueKeyAddress
|
yes
|
AddressStreet1
|
yes
|
no
|
|
|
|
|
AddressStreet2
|
yes
|
no
|
|
|
|
|
AddressStreet3
|
yes
|
no
|
|
|
|
|
AddressZip
|
yes
|
no
|
|
|
|
|
AddressCity
|
yes
|
no
|
|
|
|
|
BusinessRelation_ID
|
yes
|
no
|
|
|
|
|
AddressType_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AddressType_ID
|
Record ID
|
|
-99999999999
|
|
|
|
AddressTypeCode
|
Address Type
|
Type
|
x(20)
|
|
|
|
AddressTypeDescription
|
Description
|
|
x(40)
|
|
|
|
AddressTypeIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
AddressTypeIsSystemDefined
|
System-Owned
|
System
|
yes/no
|
|
|
|
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
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
AddressTypeCode
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
AddressType_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
AddressTypeIsActive
|
yes
|
no
|
|
|
|
|
AddressTypeCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
adx__qadc01
|
|
|
x(8)
|
|
|
|
adx__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
adx__qadi01
|
|
|
>>>>>>9
|
|
|
|
adx__qadl01
|
|
|
yes/no
|
|
|
|
adx__qadt01
|
|
|
99/99/99
|
|
|
|
adx_domain
|
Domain
|
|
x(8)
|
|
|
|
adx_ext_appl
|
External Application
|
|
x(12)
|
|
|
|
adx_ext_ref1
|
Ext Reference 1
|
|
x(32)
|
|
|
|
adx_ext_ref2
|
Ext Reference 2
|
|
x(32)
|
|
|
|
adx_mfg_addr
|
MFG/PRO Address Code
|
Address
|
x(8)
|
|
|
|
adx_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
adx_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
adx_user1
|
User Field 1
|
|
x(24)
|
|
|
|
adx_user2
|
User Field 2
|
|
x(24)
|
|
|
|
oid_adx_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
adx_det
|
yes
|
adx_domain
|
yes
|
no
|
|
|
|
|
adx_ext_appl
|
yes
|
no
|
|
|
|
|
adx_ext_ref1
|
yes
|
no
|
|
|
|
|
adx_ext_ref2
|
yes
|
no
|
|
|
adx_ext_refs
|
no
|
adx_domain
|
yes
|
no
|
|
|
|
|
adx_ext_appl
|
yes
|
no
|
|
|
|
|
adx_mfg_addr
|
yes
|
no
|
|
|
|
|
adx_ext_ref1
|
yes
|
no
|
|
|
|
|
adx_ext_ref2
|
yes
|
no
|
|
|
adx_mfg_addr
|
no
|
adx_domain
|
yes
|
no
|
|
|
|
|
adx_mfg_addr
|
yes
|
no
|
|
|
|
|
adx_ext_appl
|
yes
|
no
|
|
|
|
|
adx_ext_ref1
|
yes
|
no
|
|
|
|
|
adx_ext_ref2
|
yes
|
no
|
|
|
oid_adx_det
|
yes
|
oid_adx_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ad__chr01
|
|
|
x(8)
|
|
|
|
ad__chr02
|
|
|
x(8)
|
|
|
|
ad__chr03
|
|
|
x(8)
|
|
|
|
ad__chr04
|
|
|
x(8)
|
|
|
|
ad__chr05
|
|
|
x(8)
|
|
|
|
ad__qad01
|
|
|
x(8)
|
|
|
|
ad__qad02
|
|
|
x(8)
|
|
|
|
ad__qad03
|
|
|
x(8)
|
|
|
|
ad__qad04
|
|
|
x(8)
|
|
|
|
ad__qad05
|
|
|
x(8)
|
|
|
|
ad_addr
|
Address
|
|
x(8)
|
|
|
|
ad_address_id
|
Business Relation Address
|
|
-99999999999
|
|
|
|
ad_alt_um
|
Alternate UM
|
UM
|
x(2)
|
|
|
|
ad_asn_data
|
ASN Default Data
|
|
x(8)
|
|
|
|
ad_attn
|
Attention
|
|
x(24)
|
|
|
|
ad_attn2
|
Attention
|
|
x(24)
|
|
|
|
ad_barlbl_prt
|
Barcode Label Print Program
|
|
x(10)
|
|
|
|
ad_barlbl_val
|
Barcode Validation Program
|
|
x(10)
|
|
|
|
ad_bk_acct1
|
Bank Acct 1
|
|
x(24)
|
|
|
|
ad_bk_acct2
|
Bank Acct 2
|
|
x(24)
|
|
|
|
ad_bus_relation
|
Business Relation
|
|
x(20)
|
|
|
|
ad_calendar
|
Calendar
|
|
x(8)
|
|
|
|
ad_city
|
City
|
|
x(20)
|
|
|
|
ad_city_code
|
City Code
|
|
x(20)
|
|
|
|
ad_coc_reg
|
CoC Number
|
CoC
|
x(8)
|
|
|
|
ad_conrep
|
Netting Logic
|
C/R
|
x(1)
|
|
|
|
ad_country
|
Country
|
|
x(28)
|
|
|
|
ad_county
|
County
|
|
x(20)
|
|
|
|
ad_ctry
|
Country Code
|
Ctry
|
x(3)
|
|
|
|
ad_date
|
Added
|
|
99/99/99
|
|
|
|
ad_domain
|
Domain
|
|
x(8)
|
|
|
|
ad_edi_ctrl[5]
|
EDI Control
|
|
x(50)
|
|
|
|
ad_edi_id
|
Trading Prtnr EDI ID
|
|
x(24)
|
|
|
|
ad_edi_level
|
EDI Standard Level
|
|
x(8)
|
|
|
|
ad_edi_std
|
EDI Standard
|
|
x(8)
|
|
|
|
ad_edi_tpid
|
Trading Prtnr Interface ID
|
|
x(24)
|
|
|
|
ad_email
|
Email
|
|
x(48)
|
|
|
|
ad_email2
|
Email
|
|
x(48)
|
|
|
|
ad_ext
|
Ext
|
|
x(4)
|
|
|
|
ad_ext2
|
Ext
|
|
x(4)
|
|
|
|
ad_fax
|
Fax/Telex
|
|
x(20)
|
|
|
|
ad_fax2
|
Fax/Telex
|
|
x(20)
|
|
|
|
ad_format
|
Format
|
|
>9
|
|
|
|
ad_gst_id
|
Tax ID - Federal
|
|
x(18)
|
|
|
|
ad_intr_division
|
IntraStat Division
|
|
x(3)
|
|
|
|
ad_inv_mthd
|
Invoices Via
|
|
x(1)
|
|
|
|
ad_lang
|
Language
|
|
x(2)
|
|
|
|
ad_last_file
|
Last Filing
|
|
yes/no
|
|
|
|
ad_line1
|
Address
|
|
x(36)
|
|
|
|
ad_line2
|
Address
|
|
x(36)
|
|
|
|
ad_line3
|
Address
|
|
x(36)
|
|
|
|
ad_loadseq
|
Load Sequence
|
Load!Sequence
|
X(8)
|
|
|
|
ad_misc1_id
|
Tax ID - Misc 1
|
|
x(18)
|
|
|
|
ad_misc2_id
|
Tax ID - Misc 2
|
|
x(18)
|
|
|
|
ad_misc3_id
|
Tax ID - Misc 3
|
|
x(18)
|
|
|
|
ad_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ad_name
|
Name
|
|
x(36)
|
|
|
|
ad_name_control
|
Name Control
|
|
x(4)
|
|
|
|
ad_ns_pr_list
|
Non-Sales Price List
|
NSO Price List
|
x(8)
|
|
|
|
ad_phone
|
Telephone
|
|
x(20)
|
|
|
|
ad_phone2
|
Telephone
|
|
x(20)
|
|
|
|
ad_pick_by_date
|
Pick By Date
|
Pick!By Date
|
yes/no
|
|
|
|
ad_po_mthd
|
Purchase Orders Via
|
|
x(1)
|
|
|
|
ad_priority
|
Priority
|
|
X(8)
|
|
|
|
ad_profile
|
Profile
|
Prof
|
x(8)
|
|
|
|
ad_pst_id
|
Tax ID - State
|
|
x(18)
|
|
|
|
ad_ref
|
Reference
|
|
x(8)
|
|
|
|
ad_route
|
Route
|
|
X(8)
|
|
|
|
ad_sch_mthd
|
Schedules Via
|
|
x(2)
|
|
|
|
ad_sort
|
Sort Name
|
|
x(28)
|
|
|
|
ad_state
|
State
|
St
|
x(4)
|
|
|
|
ad_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
ad_tax_in_city
|
In City
|
|
yes/no
|
|
|
|
ad_tax_report
|
Tax Report
|
|
yes/no
|
|
|
|
ad_tax_type
|
Tax Type
|
|
x(3)
|
|
|
|
ad_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
ad_tax_zone
|
Tax Zone
|
|
x(16)
|
|
|
|
ad_taxable
|
Taxable
|
|
yes/no
|
|
|
|
ad_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
ad_temp
|
Temporary
|
Temp
|
yes/no
|
|
|
|
ad_timezone
|
Time Zone
|
|
x(8)
|
|
|
|
ad_tp_loc_code
|
Trd Partner Location Code
|
|
x(24)
|
|
|
|
ad_type
|
List Type
|
List
|
x(8)
|
|
|
|
ad_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ad_user2
|
Ufld2
|
|
x(8)
|
|
|
|
ad_userid
|
User ID
|
|
x(8)
|
|
|
|
ad_vat_reg
|
VAT Registration
|
|
x(18)
|
|
|
|
ad_wk_offset
|
Week Offset
|
|
9
|
|
|
|
ad_zip
|
Post
|
|
x(10)
|
|
|
|
oid_ad_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ad_addr
|
yes
|
ad_domain
|
yes
|
no
|
|
|
|
|
ad_addr
|
yes
|
no
|
|
|
ad_address_id
|
no
|
ad_address_id
|
yes
|
no
|
|
|
ad_edi_tpid
|
no
|
ad_domain
|
yes
|
no
|
|
|
|
|
ad_edi_tpid
|
yes
|
no
|
|
|
ad_gst
|
yes
|
ad_domain
|
yes
|
no
|
|
|
|
|
ad_gst_id
|
yes
|
no
|
|
|
|
|
ad_addr
|
yes
|
no
|
|
|
|
|
ad_sort
|
yes
|
no
|
|
|
ad_ref
|
no
|
ad_domain
|
yes
|
no
|
|
|
|
|
ad_ref
|
yes
|
no
|
|
|
|
|
ad_addr
|
yes
|
no
|
|
|
ad_sort
|
yes
|
ad_domain
|
yes
|
no
|
|
|
|
|
ad_sort
|
yes
|
no
|
|
|
|
|
ad_addr
|
yes
|
no
|
|
|
ad_type
|
yes
|
ad_domain
|
yes
|
no
|
|
|
|
|
ad_type
|
yes
|
no
|
|
|
|
|
ad_addr
|
yes
|
no
|
|
|
ad_zip
|
no
|
ad_domain
|
yes
|
no
|
|
|
|
|
ad_zip
|
yes
|
no
|
|
|
|
|
ad_addr
|
yes
|
no
|
|
|
oid_ad_mstr
|
yes
|
oid_ad_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Agent_ID
|
Record ID
|
|
-99999999999
|
|
|
|
AgentCalculationBase
|
Calculation Base
|
|
x(20)
|
|
|
|
AgentCode
|
Code
|
|
x(20)
|
|
|
|
AgentCommisionMode
|
Calculation Mode
|
|
x(20)
|
|
|
|
AgentDescription
|
Description
|
|
x(40)
|
|
|
|
AgentIsActive
|
Active
|
|
yes/no
|
|
|
|
BusinessRelation_ID
|
Business Relation
|
|
-99999999999
|
|
|
|
Company_ID
|
Entity
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ActiveIdx
|
no
|
AgentIsActive
|
yes
|
no
|
|
|
BusRelIdx
|
no
|
BusinessRelation_ID
|
yes
|
no
|
|
|
CodeIdx
|
yes
|
AgentCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Agent_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
AgentIsActive
|
yes
|
no
|
|
|
|
|
AgentCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AIMCharFld[15]
|
|
|
x(8)
|
|
|
|
AIMDateFld[4]
|
|
|
99/99/99
|
|
|
|
AIMDecFld[15]
|
|
|
->>,>>9.99
|
10
|
|
|
AIMKey1
|
|
|
x(8)
|
|
|
|
AIMKey2
|
|
|
x(8)
|
|
|
|
AIMKey3
|
|
|
x(8)
|
|
|
|
AIMKey4
|
|
|
x(8)
|
|
|
|
AIMKey5
|
|
|
x(8)
|
|
|
|
AIMKey6
|
|
|
x(8)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
oid_AIMW
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC05
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC06
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC07
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC08
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC09
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC10
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD04
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI04
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadL03
|
QAD Field
|
|
yes/no
|
|
|
|
QadL04
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT04
|
QAD Field
|
|
99/99/99
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 1
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
AIMIndex1
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
AIMKey1
|
yes
|
no
|
|
|
|
|
AIMKey2
|
yes
|
no
|
|
|
AIMIndex2
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
AIMKey3
|
yes
|
no
|
|
|
|
|
AIMKey4
|
yes
|
no
|
|
|
AIMIndex3
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
AIMKey5
|
yes
|
no
|
|
|
|
|
AIMKey6
|
yes
|
no
|
|
|
oid_AIMW
|
yes
|
oid_AIMW
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ald__qad01
|
|
|
99/99/99
|
|
|
|
ald__qad02
|
|
|
x(8)
|
|
|
|
ald_acc
|
Account
|
|
x(8)
|
|
|
|
ald_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
ald_code
|
Allocation Code
|
Allocatn
|
x(8)
|
|
|
|
ald_domain
|
Domain
|
|
x(8)
|
|
|
|
ald_pct
|
Percentage
|
Percent
|
->>9.999
|
10
|
|
|
ald_project
|
Project
|
|
x(8)
|
|
|
|
ald_sub
|
Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
ald_user1
|
Ufld1
|
|
x(8)
|
|
|
|
ald_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_ald_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ald_index
|
yes
|
ald_domain
|
yes
|
no
|
|
|
|
|
ald_code
|
yes
|
no
|
|
|
|
|
ald_acc
|
yes
|
no
|
|
|
|
|
ald_sub
|
yes
|
no
|
|
|
|
|
ald_cc
|
yes
|
no
|
|
|
|
|
ald_project
|
yes
|
no
|
|
|
oid_ald_det
|
yes
|
oid_ald_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Addr
|
Address
|
|
x(8)
|
|
|
|
AlgoNbr
|
Algorithm
|
Algo
|
>>9
|
|
|
|
AlgoSeq
|
Seq
|
|
>>9
|
|
|
|
AlgoType
|
Algorithm Type
|
Algo!Type
|
X(2)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
oid_AlgoAssD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
PartType
|
Warehouse Item Type
|
Warehouse!Item Type
|
x(8)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
TrType
|
Transaction Type
|
Tran Type
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
AlgdIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
AlgoType
|
yes
|
no
|
|
|
|
|
TrType
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
PartType
|
yes
|
no
|
|
|
|
|
Addr
|
yes
|
no
|
|
|
|
|
AlgoSeq
|
yes
|
no
|
|
|
|
|
AlgoNbr
|
yes
|
no
|
|
|
oid_AlgoAssD
|
yes
|
oid_AlgoAssD
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Addr
|
Address
|
|
x(8)
|
|
|
|
AlgoType
|
Algorithm Type
|
Algo!Type
|
X(2)
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Custom
|
Custom
|
Cust
|
yes/no
|
|
|
|
CustomProg
|
Custom Program
|
|
x(10)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_AlgoAssM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
PartType
|
Warehouse Item Type
|
Warehouse!Item Type
|
x(8)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
TrType
|
Transaction Type
|
Tran Type
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
AlgmIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
AlgoType
|
yes
|
no
|
|
|
|
|
TrType
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
PartType
|
yes
|
no
|
|
|
|
|
Addr
|
yes
|
no
|
|
|
oid_AlgoAssM
|
yes
|
oid_AlgoAssM
|
yes
|
no
|
|
|
Part
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
AlgoType
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Active
|
Active
|
Act
|
yes/no
|
|
|
|
AlgoNbr
|
Algorithm
|
Algo
|
>>9
|
|
|
|
AlgoType
|
Type
|
|
X(2)
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(64)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_AlgoM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
AlgoNbr
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
AlgoType
|
yes
|
no
|
|
|
|
|
AlgoNbr
|
yes
|
no
|
|
|
oid_AlgoM
|
yes
|
oid_AlgoM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AlgoType
|
Type
|
|
X(2)
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(24)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_AlgoTypeM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Verbosity
|
Verbosity Level
|
Verb
|
>9
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
AlgoType
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
AlgoType
|
yes
|
no
|
|
|
oid_AlgoTypeM
|
yes
|
oid_AlgoTypeM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Allocation_ID
|
Record ID
|
|
-99999999999
|
|
|
|
AllocationCode
|
Allocation Code
|
Alloc Code
|
x(20)
|
|
|
|
AllocationDenominAmountBy
|
Amt By
|
|
x(20)
|
|
|
|
AllocationDenominAmountFr
|
From Amt
|
|
x(20)
|
|
|
|
AllocationDenominatorLcQty
|
Value Of
|
|
x(20)
|
|
|
|
AllocationDescription
|
Description
|
Alloc Desc
|
x(40)
|
|
|
|
AllocationFractionConstant
|
Constant Fraction
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
AllocationFractionType
|
Fraction Type
|
|
x(20)
|
|
|
|
AllocationIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
AllocationNumeratAmountBy
|
Amt By
|
|
x(20)
|
|
|
|
AllocationNumeratAmountFr
|
From Amt
|
|
x(20)
|
|
|
|
AllocationNumeratorLcQty
|
Value Of
|
|
x(20)
|
|
|
|
AllocationSourceAmountBy
|
Amt By
|
|
x(20)
|
|
|
|
AllocationSourceAmountFrom
|
From Amt
|
|
x(20)
|
|
|
|
AllocationSourceAmountLC
|
BC Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
AllocationSourceLcQty
|
Value Of
|
|
x(20)
|
|
|
|
AllocationSourcePRICE
|
BC Price
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
AllocationSourceQTY
|
Quantity
|
Qty
|
->>>,>>>,>>9.99999
|
10
|
|
|
AllocationSourceType
|
Source Type
|
|
x(20)
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
DenominatorBudgetWBS_ID
|
Denominator WBS
|
|
-99999999999
|
|
|
|
Journal_ID
|
Daybook Code
|
|
-99999999999
|
|
|
|
NumeratorBudgetWBS_ID
|
WBS Seq
|
|
-99999999999
|
|
|
|
PostingTemplate_ID
|
Template Code
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SourceBudgetWBS_ID
|
WBS Seq
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Active
|
no
|
AllocationIsActive
|
yes
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
DenomBudgetWBS
|
no
|
DenominatorBudgetWBS_ID
|
yes
|
no
|
|
|
Journal
|
no
|
Journal_ID
|
yes
|
no
|
|
|
NumeratorBudgetWBS
|
no
|
NumeratorBudgetWBS_ID
|
yes
|
no
|
|
|
PostingTemplate
|
no
|
PostingTemplate_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Allocation_ID
|
yes
|
no
|
|
|
SourceBudgetWBS
|
no
|
SourceBudgetWBS_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
AllocationCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
AllocationIsActive
|
yes
|
no
|
|
|
|
|
AllocationCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AllocationBatch_ID
|
Record ID
|
|
-99999999999
|
|
|
|
AllocationBatchCode
|
Allocation Batch Code
|
|
x(20)
|
|
|
|
AllocationBatchDescription
|
Description
|
|
x(40)
|
|
|
|
AllocationBatchIsActive
|
Active
|
|
yes/no
|
|
|
|
Company_ID
|
Link to Company
|
|
-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
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
IsActive
|
no
|
AllocationBatchIsActive
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
AllocationBatch_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
AllocationBatchCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
AllocationBatchIsActive
|
yes
|
no
|
|
|
|
|
AllocationBatchCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Allocation_ID
|
Allocation Code
|
Alloc Code
|
-99999999999
|
|
|
|
AllocationBatch_ID
|
Link to AllocationBatch
|
|
-99999999999
|
|
|
|
AllocationBatchLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
AllocationBatchLineGroup
|
JE Group
|
|
x(20)
|
|
|
|
AllocationBatchLineSeq
|
Seq
|
|
->,>>>,>>9
|
|
|
|
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
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Alloc
|
no
|
Allocation_ID
|
yes
|
no
|
|
|
AllocBat
|
no
|
AllocationBatch_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
AllocationBatchLine_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
AllocationBatch_ID
|
yes
|
no
|
|
|
|
|
AllocationBatchLineSeq
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Allocation_ID
|
Link to Allocation
|
|
-99999999999
|
|
|
|
AllocationLayer_ID
|
Record ID
|
|
-99999999999
|
|
|
|
AllocationLayerFor
|
Layer of
|
Layer linked to
|
x(20)
|
|
|
|
Layer_ID
|
Layer Code
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
AllocationLayer_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Allocation_ID
|
yes
|
no
|
|
|
|
|
AllocationLayerFor
|
yes
|
no
|
|
|
|
|
Layer_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AllocationBatch_ID
|
Link to AllocationBatch
|
|
-99999999999
|
|
|
|
AllocationBatchLine_ID
|
Link to AllocationBatchLine
|
|
-99999999999
|
|
|
|
AllocationPosting_ID
|
Record ID
|
|
-99999999999
|
|
|
|
Posting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
SourcePeriod_ID
|
Link to Period
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AllocBat
|
no
|
AllocationBatch_ID
|
yes
|
no
|
|
|
AllocBatLn
|
no
|
AllocationBatchLine_ID
|
yes
|
no
|
|
|
Posting
|
no
|
Posting_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
AllocationPosting_ID
|
yes
|
no
|
|
|
SourcePd
|
no
|
SourcePeriod_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
SourcePeriod_ID
|
yes
|
no
|
|
|
|
|
AllocationBatchLine_ID
|
yes
|
no
|
|
|
|
|
Posting_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Allocation_ID
|
Link to Allocation
|
|
-99999999999
|
|
|
|
AllocationProportional_ID
|
Record ID
|
|
-99999999999
|
|
|
|
CostCentre_ID
|
Cost Center Code
|
|
-99999999999
|
|
|
|
Division_ID
|
Sub-Account Code
|
Sub-Acct
|
-99999999999
|
|
|
|
Project_ID
|
Project
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Saf_ID
|
SAF Concept Code
|
|
-99999999999
|
|
|
|
SafConcept_ID
|
Link to SafConcept
|
|
-99999999999
|
|
|
|
SafStructure_ID
|
Structure Code
|
Structure
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Alloc
|
no
|
Allocation_ID
|
yes
|
no
|
|
|
CostC
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
Div
|
no
|
Division_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
AllocationProportional_ID
|
yes
|
no
|
|
|
Proj
|
no
|
Project_ID
|
yes
|
no
|
|
|
Saf
|
no
|
Saf_ID
|
yes
|
no
|
|
|
SafC
|
no
|
SafConcept_ID
|
yes
|
no
|
|
|
SafStr
|
no
|
SafStructure_ID
|
yes
|
no
|
|
|
UniIdx
|
yes
|
Allocation_ID
|
yes
|
no
|
|
|
|
|
Division_ID
|
yes
|
no
|
|
|
|
|
Project_ID
|
yes
|
no
|
|
|
|
|
CostCentre_ID
|
yes
|
no
|
|
|
|
|
Saf_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
alm__qadc01
|
|
|
x(8)
|
|
|
|
alm_date
|
Date Create
|
Date
|
99/99/99
|
|
|
|
alm_domain
|
Domain
|
|
x(8)
|
|
|
|
alm_lead
|
Leading Characters
|
Leading Char
|
x(12)
|
|
|
|
alm_len
|
Sequence Length
|
Len
|
>9
|
|
|
|
alm_lot_grp
|
Lot Group
|
Lot Grp
|
x(8)
|
|
|
|
alm_pgm
|
Execution File
|
|
x(14)
|
|
|
|
alm_seq
|
Sequence Number
|
Sequence
|
>>>>>>>>>9
|
10
|
|
|
alm_site
|
Site
|
|
x(8)
|
|
|
|
alm_trail
|
Trailing Characters
|
Trailing Char
|
x(12)
|
|
|
|
alm_user1
|
Ufld1
|
|
x(8)
|
|
|
|
alm_user2
|
Ufld2
|
|
x(8)
|
|
|
|
alm_userid
|
User ID
|
|
x(8)
|
|
|
|
oid_alm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
alm_lot_grp
|
yes
|
alm_domain
|
yes
|
no
|
|
|
|
|
alm_lot_grp
|
yes
|
no
|
|
|
|
|
alm_site
|
yes
|
no
|
|
|
oid_alm_mstr
|
yes
|
oid_alm_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AltCOAGroup_ID
|
Alternate COA Group ID
|
|
-99999999999
|
|
|
|
AltCOAGroupCode
|
Alternate COA Group Code
|
|
x(20)
|
|
|
|
AltCOAGroupDescription
|
Description
|
|
x(40)
|
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
AltCOAGroup_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
AltCOAGroupCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AltCOAStruct_ID
|
Alternate COA Structure
|
|
-99999999999
|
|
|
|
AltCOAStructCode
|
Alternate COA Structure Code
|
|
x(20)
|
|
|
|
AltCOAStructDescription
|
Description
|
|
x(40)
|
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Mod Date
|
Last Modified Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Mod Time
|
Last Modified Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Mod User
|
Last Modified User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
AltCOAStruct_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
AltCOAStructCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AltCOAGroup_ID
|
Alternate COA Group
|
|
-99999999999
|
|
|
|
AltCOAStruct_ID
|
Alternate COA Structure
|
|
-99999999999
|
|
|
|
AltCOAStructDet_ID
|
Alternate COA
|
|
-99999999999
|
|
|
|
AltCOAStructDetCode
|
Alternate COA
|
|
x(20)
|
|
|
|
AltCOAStructDetColLabel
|
Column Label
|
|
x(20)
|
|
|
|
AltCOAStructDetDescription
|
Description
|
|
x(40)
|
|
|
|
AltCOAStructDetIsLeaf
|
Leaf
|
|
yes/no
|
|
|
|
AltCOAStructDetLevel
|
Level
|
|
->,>>>,>>9
|
|
|
|
AltCOAStructDetSeq
|
Sequence
|
|
x(60)
|
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Mod Date
|
Last Modified Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Mod Time
|
Last Modified Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Mod User
|
Last Modified User
|
x(20)
|
|
|
|
ParentAltCOAStructDet_ID
|
Parent Alternate COA Structure Detail
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
GrpIdx
|
no
|
AltCOAGroup_ID
|
yes
|
no
|
|
|
ParIdx
|
no
|
ParentAltCOAStructDet_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
AltCOAStructDet_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
AltCOAStruct_ID
|
yes
|
no
|
|
|
|
|
AltCOAStructDetCode
|
yes
|
no
|