Module List >
Module GL tables
>
GL20001
DynDeveloper Table Reference is now in Wiki format! Registered users have the ability to improve the table reference, add comments, and make the world a better place
|
You are currently viewing the COMPANY
database.
Change
|
COMPANY..GL20001 Table Definition
(COMPANY..)
Field Definitions:
What is the 'source' column?
* the version information goes back to GP 9
| TranslationCurrencyID | char |
|
| GP 2010 |
|
|
| OPENYEAR | smallint |
|
| GP 2010 |
|
|
| JRNENTRY | int |
|
PAM60601.JRNENTRY
| GP 2010 |
|
|
| SOURCDOC | char |
Join Now
|
| GP 2010 |
|
|
| REFRENCE | char |
|
| GP 2010 |
|
|
| TRXDATE | datetime |
|
PAM30502.TRXDATE
| GP 2010 |
|
|
| TRXSORCE | char |
Transactio...(more) Join Now
|
| GP 2010 |
|
|
| ACTINDX | int |
|
PAM10610.ACTINDX
| GP 2010 |
|
join GL00100 on GL00100.ACTINDX = GL20001.ACTINDX
|
| SEQNUMBR | int |
Sequence N...(more) Join Now
|
HR2EMP02.SEQNUMBR
| GP 2010 |
|
|
| PERIODID | smallint |
|
PAM40302.PERIODID
| GP 2010 |
|
|
| Ledger_ID | smallint |
|
| GP 2010 |
|
|
| CURNCYID | char |
Currency I...(more) Join Now
|
RM20102.CURNCYID
| GP 2010 |
|
join DYNAMICS..MC40200 on MC40200.CURNCYID = GL20001.CURNCYID
|
| Original_Exchange_Rate | numeric |
|
| GP 2010 |
|
|
| ORGNTSRC | char |
|
| GP 2010 |
|
|
| CRDTAMNT | numeric |
|
PAM50600.CRDTAMNT
| GP 2010 |
|
|
| DEBITAMT | numeric |
|
PAM50600.DEBITAMT
| GP 2010 |
|
|
| ORCRDAMT | numeric |
|
| GP 2010 |
|
|
| ORDBTAMT | numeric |
|
| GP 2010 |
|
|
| TranslationCreditAmount | numeric |
|
| GP 2010 |
|
|
| TranslationDebitAmount | numeric |
|
| GP 2010 |
|
|
| CURRNIDX | smallint |
Currency I...(more) Join Now
|
RM20102.CURRNIDX
| GP 2010 |
|
join DYNAMICS..MC40200 on MC40200.CURRNIDX = GL20001.CURRNIDX
|
| DECPLCUR | smallint |
Decimal Pl...(more) Join Now
|
POP10110.DECPLCUR
| GP 2010 |
|
|
| RATETPID | char |
|
PAM30900.RATETPID
| GP 2010 |
|
|
| EXGTBLID | char |
Exchange T...(more) Join Now
|
MC00100.EXGTBLID
| GP 2010 |
|
|
| XCHGRATE | numeric |
Exchange R...(more) Join Now
|
MC00100.XCHGRATE
| GP 2010 |
|
|
| EXCHDATE | datetime |
Exchange D...(more) Join Now
|
MC00100.EXCHDATE
| GP 2010 |
|
|
| TIME1 | datetime |
|
PM20100.TIME1
| GP 2010 |
|
|
| RTCLCMTD | smallint |
Rate calcu...(more) Join Now
|
MC40300.RTCLCMTD
| GP 2010 |
|
|
| DENXRATE | numeric |
|
PAM10501.DENXRATE
| GP 2010 |
|
|
| MCTRXSTT | smallint |
|
| GP 2010 |
|
|
| CurrencyTranslationType | smallint |
|
| GP 2010 |
|
|
| Identity_Column | int |
|
| GP 2010 |
|
|
| DEX_ROW_ID | int |
|
MC40200.DEX_ROW_ID
| GP 2010 |
|
|
|