| OPENYEAR |
smallint
0
|
Open Year:...(more) Join Now
|
|
|
|
| JRNENTRY |
int
0
|
Journal En...(more) Join Now
|
|
|
|
| RCTRXSEQ |
numeric(19,5)
0.00
|
Recurring ...(more) Join Now
|
|
|
|
| SOURCDOC |
char(11)
''
|
span style...(more) Join Now
|
|
|
|
| REFRENCE |
char(31)
''
|
Reference:...(more) Join Now
|
|
|
|
| DSCRIPTN |
char(31)
''
|
Descriptio...(more) Join Now
|
|
|
|
| TRXDATE |
datetime
'1/1/1900'
|
TRX Date: ...(more) Join Now
|
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| ACTINDX |
int
0
|
Account In...(more) Join Now
|
|
|
join ... more text available
|
| POLLDTRX |
tinyint
0
|
|
|
|
|
| LASTUSER |
char(15)
''
|
Last User:...(more) Join Now
|
|
|
|
| LSTDTEDT |
datetime
'1/1/1900'
|
Last Date ...(more) Join Now
|
|
|
|
| USWHPSTD |
char(15)
''
|
User Who P...(more) Join Now
|
|
|
|
| ORGNTSRC |
char(15)
''
|
Originatin...(more) Join Now
|
|
|
|
| ORGNATYP |
smallint
0
|
Originatin...(more) Join Now
|
|
|
|
| QKOFSET |
smallint
0
|
Quick Off ...(more) Join Now
|
|
|
|
| SERIES |
smallint
0
|
Seriesbr /...(more) Join Now
|
|
|
|
| ORTRXTYP |
smallint
0
|
Originatin...(more) Join Now
|
|
|
|
| ORCTRNUM |
char(21)
''
|
Originatin...(more) Join Now
|
|
|
|
| ORMSTRID |
char(31)
''
|
Originatin...(more) Join Now
|
|
|
|
| ORMSTRNM |
char(65)
''
|
Originatin...(more) Join Now
|
|
|
|
| ORDOCNUM |
char(21)
''
|
Originatin...(more) Join Now
|
|
|
|
| ORPSTDDT |
datetime
'1/1/1900'
|
Originatio...(more) Join Now
|
|
|
|
| ORTRXSRC |
char(13)
0
|
Originatin...(more) Join Now
|
|
|
|
| OrigDTASeries |
smallint
0
|
Originatin...(more) Join Now
|
|
|
|
| OrigSeqNum |
int
0
|
Originatin...(more) Join Now
|
|
|
|
| SEQNUMBR |
int
0
|
Sequence L...(more) Join Now
|
|
|
|
| DTA_GL_Status |
smallint
0
|
DTA GL Sta...(more) Join Now
|
|
|
|
| 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
|
|
|
join ... more text available
|
| RATETPID |
char(15)
''
|
Rate Type ...(more) Join Now
|
|
|
|
| EXGTBLID |
char(15)
''
|
Exchange T...(more) Join Now
|
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| EXCHDATE |
datetime
'1/1/1900'
|
Exchange D...(more) Join Now
|
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time: The ...(more) Join Now
|
|
|
|
| RTCLCMTD |
smallint
0
|
Rate Calcu...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| ICTRX |
tinyint
0
|
IC TRX: T...(more) Join Now
|
|
|
|
| ORCOMID |
char(5)
''
|
Originatin...(more) Join Now
|
|
|
|
| ORIGINJE |
int
0
|
Originati...(more) Join Now
|
|
|
|
| PERIODID |
smallint
0
|
Period ID:...(more) Join Now
|
|
|
|
| CRDTAMNT |
numeric(19,5)
0.00
|
Credit Amo...(more) Join Now
|
|
|
|
| DEBITAMT |
numeric(19,5)
0.00
|
Debit Amou...(more) Join Now
|
|
|
|
| ORCRDAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| ORDBTAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
Document D...(more) Join Now
|
|
|
|
| PSTGNMBR |
int
0
|
|
|
|
|
| PPSGNMBR |
int
0
|
|
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
|
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
|
|
|
| CorrespondingUnit |
char(5)
''
|
Correspond...(more) Join Now
|
|
|
|
| VOIDED |
tinyint
0
|
Voided: ...(more) Join Now
|
|
|
|
| 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
|
|
|
|
| Original_JE_Seq_Num |
numeric(19,5)
0.00
|
Original J...(more) Join Now
|
|
|
|
| Original_JE_Year |
smallint
0
|
Original J...(more) Join Now
|
|
|
|
| Ledger_ID |
smallint
0
|
Ledger ID:...(more) Join Now
|
|
|
|
| Adjustment_Transaction |
tinyint
0
|
Adjustment...(more) Join Now
|
|
|
|
| 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
|
|
|