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 |
|
|