| HSTYEAR |
smallint
0
|
|
|
|
|
| JRNENTRY |
int
0
|
Journal En...(more) Join Now
|
DTA10100.JRNENTRY
|
|
|
| RCTRXSEQ |
numeric(19,5)
0.00
|
Recurring ...(more) Join Now
|
GL10000.RCTRXSEQ
|
|
|
| SOURCDOC |
char(11)
''
|
span style...(more) Join Now
|
|
|
|
| REFRENCE |
char(31)
''
|
Reference:...(more) Join Now
|
POP30300.REFRENCE
|
|
|
| DSCRIPTN |
char(31)
''
|
Descriptio...(more) Join Now
|
CM20300.DSCRIPTN
|
|
|
| TRXDATE |
datetime
'1/1/1900'
|
TrxDate Transaction Date used when the transaction was posted
|
CM20502.TRXDATE
|
|
|
| ACTINDX |
int
0
|
Account In...(more) Join Now
|
|
|
join ... more text available
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| POLLDTRX |
tinyint
0
|
|
|
|
|
| LASTUSER |
char(15)
''
|
Last User:...(more) Join Now
|
GL10000.LASTUSER
|
|
|
| LSTDTEDT |
datetime
'1/1/1900'
|
Last Date ...(more) Join Now
|
GL10000.LSTDTEDT
|
|
|
| USWHPSTD |
char(15)
''
|
User Who P...(more) Join Now
|
GL10000.USWHPSTD
|
|
|
| ORGNTSRC |
char(15)
''
|
Originatin...(more) Join Now
|
GL20000.ORGNTSRC
|
|
|
| ORGNATYP |
smallint
0
|
Originatin...(more) Join Now
|
GL20000.ORGNATYP
|
|
|
| QKOFSET |
smallint
0
|
Quick Off ...(more) Join Now
|
GL20000.QKOFSET
|
|
|
| SERIES |
smallint
0
|
Seriesbr /...(more) Join Now
|
|
|
|
| ORTRXTYP |
smallint
0
|
Originatin...(more) Join Now
|
GL10001.ORTRXTYP
|
|
|
| ORCTRNUM |
char(21)
''
|
Originatin...(more) Join Now
|
GL10001.ORCTRNUM
|
|
|
| ORMSTRID |
char(31)
''
|
Originatin...(more) Join Now
|
GL10001.ORMSTRID
|
|
|
| ORMSTRNM |
char(65)
''
|
Originatin...(more) Join Now
|
GL10001.ORMSTRNM
|
|
|
| ORDOCNUM |
char(21)
''
|
Originatin...(more) Join Now
|
GL10001.ORDOCNUM
|
|
|
| ORPSTDDT |
datetime
'1/1/1900'
|
Note Index...(more) Join Now
|
GL10000.ORPSTDDT
|
|
|
| ORTRXSRC |
char(13)
0
|
Originatin...(more) Join Now
|
|
|
|
| OrigDTASeries |
smallint
0
|
Period ID:...(more) Join Now
|
GL10000.OrigDTASeries
|
|
|
| OrigSeqNum |
int
0
|
Originatin...(more) Join Now
|
GL10001.OrigSeqNum
|
|
|
| SEQNUMBR |
int
0
|
Sequence N...(more) Join Now
|
DTA10200.SEQNUMBR
|
|
|
| DTA_GL_Status |
smallint
0
|
DTA GL Sta...(more) Join Now
|
GL10001.DTA_GL_Status
|
|
|
| DTA_Index |
numeric(19,5)
0.00
|
DTA Index:...(more) Join Now
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
CM20000
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
CM20200.CURRNIDX
|
|
join ... more text available
|
| RATETPID |
char(15)
''
|
A valid Ra...(more) Join Now
|
|
|
|
| EXGTBLID |
char(15)
''
|
Exchange T...(more) Join Now
|
CM20200.EXGTBLID
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
CM20200.XCHGRATE
|
|
|
| EXCHDATE |
datetime
'1/1/1900'
|
Exchange D...(more) Join Now
|
CM20200.EXCHDATE
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time see ...(more) Join Now
|
CM20200.TIME1
|
|
|
| RTCLCMTD |
smallint
0
|
Rate Calcu...(more) Join Now
|
CM20200.RTCLCMTD
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| ICTRX |
tinyint
0
|
IC TRX: Im...(more) Join Now
|
PM10000.ICTRX
|
|
|
| ORCOMID |
char(5)
''
|
Originatin...(more) Join Now
|
GL10000.ORCOMID
|
|
|
| ORIGINJE |
int
0
|
Originatin...(more) Join Now
|
GL10000.ORIGINJE
|
|
|
| PERIODID |
smallint
0
|
Period ID:...(more) Join Now
|
|
|
|
| CRDTAMNT |
numeric(19,5)
0.00
|
Credit Amo...(more) Join Now
|
GL10001.CRDTAMNT
|
|
|
| DEBITAMT |
numeric(19,5)
0.00
|
Debit Amou...(more) Join Now
|
|
|
|
| ORCRDAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
GL10001.ORCRDAMT
|
|
|
| ORDBTAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
GL10001.ORDBTAMT
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
The date a...(more) Join Now
|
|
|
|
| PSTGNMBR |
int
0
|
|
|
|
|
| PPSGNMBR |
int
0
|
|
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
CM20200.DENXRATE
|
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
CM20200.MCTRXSTT
|
|
|
| CorrespondingUnit |
char(5)
''
|
Correspond...(more) Join Now
|
GL10001.CorrespondingUnit
|
|
|
| VOIDED |
tinyint
0
|
Voided TRU...(more) Join Now
|
CM20100.VOIDED
|
|
|
| Back_Out_JE |
int
0
|
|
|
|
|
| Back_Out_JE_Year |
smallint
0
|
|
|
|
|
| Correcting_JE |
int
0
|
|
|
|
|
| Correcting_JE_Year |
smallint
0
|
|
|
|
|
| Original_JE |
int
0
|
Original J...(more) Join Now
|
GL10000.Original_JE
|
|
|
| Original_JE_Seq_Num |
numeric(19,5)
0.00
|
Original J...(more) Join Now
|
|
|
|
| Original_JE_Year |
smallint
0
|
Original J...(more) Join Now
|
GL10000.Original_JE_Year
|
|
|
| Ledger_ID |
smallint
0
|
Ledger ID:...(more) Join Now
|
GL10000.Ledger_ID
|
|
|
| Adjustment_Transaction |
tinyint
0
|
Adjustment...(more) Join Now
|
GL10000.Adjustment_Transaction
|
|
|
| APRVLUSERID |
char
''
|
Approval U...(more) Join Now
|
SOP30100.APRVLUSERID
|
|
|
| DEX_ROW_TS |
datetime
(getutcdate())
|
Time Stamp...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
| APPRVLDT |
datetime
'1/1/1900'
|
Approval D...(more) Join Now
|
SOP30100.APPRVLDT
|
|
|