| ACTINDX |
int
0
|
Account In...(more) Join Now
|
|
|
|
| ACTNUMBR_1 |
char(5)
''
|
Account Nu...(more) Join Now
|
|
|
|
| ACTNUMBR_2 |
char(5)
''
|
Account Nu...(more) Join Now
|
|
|
|
| ACTNUMBR_3 |
char(5)
''
|
Account Nu...(more) Join Now
|
|
|
|
| ACTNUMBR_4 |
char(5)
''
|
Account Nu...(more) Join Now
|
|
|
|
| ACTNUMBR_5 |
char(5)
''
|
Account Nu...(more) Join Now
|
|
|
|
| ACTALIAS |
char(21)
''
|
Account Al...(more) Join Now
|
|
|
|
| ACTNUMBR_6 |
char
''
|
span style...(more) Join Now
|
|
|
|
| ACTNUMBR_7 |
char
''
|
span style...(more) Join Now
|
|
|
|
| MNACSGMT |
char(67)
''
|
Main Accou...(more) Join Now
|
|
|
|
| ACTNUMBR_8 |
char
''
|
span style...(more) Join Now
|
|
|
|
| ACCTTYPE |
smallint
0
|
p>Account ...(more) Join Now
|
|
|
|
| ACTNUMBR_9 |
char
''
|
span style...(more) Join Now
|
|
|
|
| ACTDESCR |
char(51)
''
|
Account De...(more) Join Now
|
|
|
|
| ACTNUMBR_10 |
char
''
|
|
|
|
|
| PSTNGTYP |
smallint
0
|
p>Posting ...(more) Join Now
|
|
|
|
| ACCATNUM |
smallint
0
|
Account Ca...(more) Join Now
|
|
|
|
| ACTIVE |
tinyint
0
|
p>Active:&...(more) Join Now
|
|
|
|
| TPCLBLNC |
smallint
0
|
p>Typical ...(more) Join Now
|
|
|
|
| DECPLACS |
smallint
0
|
Decimal Pl...(more) Join Now
|
|
|
|
| FXDORVAR |
smallint
0
|
p>Fixed Or...(more) Join Now
|
|
|
|
| BALFRCLC |
smallint
0
|
p>Balance ...(more) Join Now
|
|
|
|
| DSPLKUPS |
binary(4)
0
|
Display In...(more) Join Now
|
|
|
|
| CNVRMTHD |
smallint
0
|
Conversion...(more) Join Now
|
|
|
|
| HSTRCLRT |
numeric(19,7)
0.00
|
Historical...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| CREATDDT |
datetime
'1/1/1900'
|
Created Da...(more) Join Now
|
|
|
|
| MODIFDT |
datetime
'1/1/1900'
|
Date the r...(more) Join Now
|
|
|
|
| USERDEF1 |
char(21)
''
|
UserDefine...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
''
|
UserDefine...(more) Join Now
|
|
|
|
| PostSlsIn |
smallint
0
|
Post Sales...(more) Join Now
|
|
|
|
| PostIvIn |
smallint
0
|
Post Inven...(more) Join Now
|
|
|
|
| PostPurchIn |
smallint
0
|
Post Purch...(more) Join Now
|
|
|
|
| PostPRIn |
smallint
0
|
Post Payro...(more) Join Now
|
|
|
|
| ADJINFL |
tinyint
0
|
Adjust for...(more) Join Now
|
|
|
|
| INFLAREV |
int
0
|
Inflation ...(more) Join Now
|
|
|
|
| INFLAEQU |
int
0
|
Inflation ...(more) Join Now
|
|
|
|
| ACCTENTR |
tinyint
0
|
Allow Acco...(more) Join Now
|
|
|
|
| USRDEFS1 |
char(31)
''
|
User Defin...(more) Join Now
|
|
|
|
| USRDEFS2 |
char(31)
''
|
p>User Def...(more) Join Now
|
|
|
|
| Clear_Balance |
tinyint
0
|
0 - Roll B...(more) Join Now
|
|
|
|
| DEX_ROW_TS |
datetime
(getutcdate())
|
Time Stamp...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|