About This Guide > AltCOAStructDet
  
AltCOAStructDet
Alternate COA
 
 
Field Name
Label
Col-Label
Format
Dec
 
AltCOAGroup_ID
Alternate COA Group
 
9999999999
 
 
AltCOAStruct_ID
Alternate COA Structure
 
9999999999
 
 
AltCOAStructDet_ID
Alternate COA
 
9999999999
 
 
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
 
9999999999
 
 
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