QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
act_mstr
Alternate Container Master
 
 
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
ac_mstr
Account Master
 
 
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
adc_ctrl
Address Control
 
 
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
Address
Address
 
 
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
AddressType
Address Type
 
 
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
adx_det
External Address Cross-Reference Detail
 
 
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
ad_mstr
Address Master
 
 
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
Agent
Salesperson
 
 
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
AIMW
Warehousing Work Table
 
 
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
ald_det
Allocation Account Detail
 
 
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
AlgoAssD
Warehousing Algorithm Assignment Detail
 
 
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
AlgoAssM
Warehousing Algorithm Assignment Master
 
 
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
AlgoM
Warehousing Algorithm Master
 
 
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
AlgoTypeM
Warehousing Algorithm Type Master
 
 
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
Allocation
Allocation Definition
 
 
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
AllocationBatch
Allocation Batch
 
 
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
AllocationBatchLine
Allocation Batch Line
 
 
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
AllocationLayer
Allocation Layer
 
 
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
AllocationPosting
Allocation Posting
 
 
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
AllocationProportional
Proportional Allocation
 
 
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
alm_mstr
Automatic Lot Master
 
 
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
AltCOAGroup
Alternate COA Group
 
 
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
AltCOAStruct
Alternate COA Structure
 
 
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
AltCOAStructDet
Alternate COA
 
 
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