Module List >
Module Tax tables
TX30000
You are currently viewing the COMPANY
database.
Change
|
COMPANY..TX30000 Table Definition
(COMPANY..Tax History)
Field Definitions:
What is the 'source' column?
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
PM10000.DOCTYPE
|
|
|
| SERIES |
smallint
0
|
1 = SOPbr ...(more) Join Now
|
|
|
|
| RCTRXSEQ |
numeric(19,5)
0.00
|
|
|
|
|
| SEQNUMBR |
int
0
|
Sequence N...(more) Join Now
|
DTA10200.SEQNUMBR
|
|
|
| TAXDTLID |
char(15)
''
|
Tax Detail...(more) Join Now
|
|
|
|
| TXDTLPCT |
numeric(19,5)
0.00
|
Tax Detail...(more) Join Now
|
|
|
|
| TXDTLAMT |
numeric(19,5)
0.00
|
Tax Detail...(more) Join Now
|
|
|
|
| ACTINDX |
int
0
|
Account In...(more) Join Now
|
|
|
join ... more text available
|
| 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
|
POP30300.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
|
|
|
|
| ORDOCAMT |
numeric(19,5)
0.00
|
Orig Docum...(more) Join Now
|
|
|
|
| ECTRX |
tinyint
0
|
EC Transac...(more) Join Now
|
RM20101.ECTRX
|
|
|
| VOIDSTTS |
smallint
0
|
Void Statu...(more) Join Now
|
|
|
|
| CustomerVendor_ID |
char(15)
''
|
|
|
|
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
CM20200.CURRNIDX
|
|
join ... more text available
|
| Included_On_Return |
tinyint
0
|
|
|
|
|
| Tax_Return_ID |
char(21)
''
|
|
|
|
|
| TXORGN |
smallint
0
|
|
|
|
|
| TXDTLTYP |
smallint
0
|
Tax Detail...(more) Join Now
|
|
|
|
| TRXSTATS |
char(1)
''
|
|
|
|
|
| RETNUM |
char(17)
''
|
|
|
|
|
| YEAR1 |
smallint
0
|
Year...(more) Join Now
|
SY40100.YEAR1
|
|
|
| INVATRET |
tinyint
0
|
|
|
|
|
| VATCOLCD |
char(3)
''
|
|
|
|
|
| VATRPTID |
char(9)
''
|
|
|
|
|
| Revision_Number |
smallint
0
|
Revision N...(more) Join Now
|
POP10100.Revision_Number
|
|
|
| PERIODID |
smallint
0
|
Period ID...(more) Join Now
|
SY40100.PERIODID
|
|
|
| ISGLTRX |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|