Module List >
Module GL tables
GL10300
You are currently viewing the COMPANY
database.
Change
|
COMPANY..GL10300 Table Definition
(COMPANY..General Ledger Tax Work)
Field Definitions:
What is the 'source' column?
| JRNENTRY |
int
0
|
Journal En...(more) Join Now
|
DTA10100.JRNENTRY
|
|
|
| RCTRXSEQ |
numeric(19,5)
0.00
|
Recurring ...(more) Join Now
|
GL10000.RCTRXSEQ
|
|
|
| SQNCLINE |
numeric(19,5)
0.00
|
Sequence L...(more) Join Now
|
GL10000.SQNCLINE
|
|
|
| SQNCLINE2 |
numeric(19,5)
0.00
|
|
|
|
|
| TAXDTLID |
char(15)
''
|
Tax Detail...(more) Join Now
|
PM10500.TAXDTLID
|
|
|
| DOCDATE |
datetime
'1/1/1900'
|
The date a...(more) Join Now
|
|
|
|
| Tax_Date |
datetime
'1/1/1900'
|
Tax Date: ...(more) Join Now
|
RM20101.Tax_Date
|
|
|
| PSTGDATE |
datetime
'1/1/1900'
|
Posting Da...(more) Join Now
|
PM10000.PSTGDATE
|
|
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
RM20101.TAXAMNT
|
|
|
| ORTAXAMT |
numeric(19,5)
0.00
|
Orig Tax A...(more) Join Now
|
POP10300.ORTAXAMT
|
|
|
| Taxable_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| Originating_Taxable_Amt |
numeric(19,5)
0.00
|
|
|
|
|
| DOCAMNT |
numeric(19,5)
0.00
|
Source Doc...(more) Join Now
|
PM10000.DOCAMNT
|
|
|
| ORDOCAMT |
numeric(19,5)
0.00
|
Orig Docum...(more) Join Now
|
SOP10100.ORDOCAMT
|
|
|
| TXDTLPCT |
numeric(19,5)
0.00
|
Tax Detail...(more) Join Now
|
TX00201.TXDTLPCT
|
|
|
| TXDTLAMT |
numeric(19,5)
0.00
|
Tax Detail...(more) Join Now
|
TX00201.TXDTLAMT
|
|
|
| TXDTLTYP |
smallint
0
|
Tax Detail...(more) Join Now
|
TX00201.TXDTLTYP
|
|
|
| ACTINDX |
int
0
|
Account In...(more) Join Now
|
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
CM20200.CURRNIDX
|
|
join ... more text available
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|