Module List >
Module JC tables
JC10500
You are currently viewing the COMPANY
database.
Change
|
COMPANY..JC10500 Table Definition
(COMPANY..JC_RFP_Tax_WORK)
Field Definitions:
What is the 'source' column?
| VENDORID |
char(15)
|
Vendor ID:...(more) Join Now
|
PM10000.VENDORID
|
|
join ... more text available
|
| VCHRNMBR |
char(21)
|
Voucher Nu...(more) Join Now
|
POP30300.VCHRNMBR
|
|
|
| DOCTYPE |
smallint
|
Document T...(more) Join Now
|
PM10000.DOCTYPE
|
|
|
| SEQNUMBR |
int
|
Sequence L...(more) Join Now
|
GL20000.SEQNUMBR
|
|
|
| BACHNUMB |
char(15)
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| TAXDTLID |
char(15)
|
Tax Detail...(more) Join Now
|
TX00201.TAXDTLID
|
|
|
| BKOUTTAX |
tinyint
|
|
|
|
|
| TAXAMNT |
numeric(19,5)
|
Tax Amount...(more) Join Now
|
RM20101.TAXAMNT
|
|
|
| ORTAXAMT |
numeric(19,5)
|
Orig Tax A...(more) Join Now
|
POP10300.ORTAXAMT
|
|
|
| PCTAXAMT |
numeric(19,5)
|
Purchase T...(more) Join Now
|
PM30700.PCTAXAMT
|
|
|
| ORPURTAX |
numeric(19,5)
|
Originatin...(more) Join Now
|
PM30700.ORPURTAX
|
|
|
| FRTTXAMT |
numeric(19,5)
|
Freight Ta...(more) Join Now
|
POP10300.FRTTXAMT
|
|
|
| ORFRTTAX |
numeric(19,5)
|
Orig Freig...(more) Join Now
|
POP10300.ORFRTTAX
|
|
|
| MSCTXAMT |
numeric(19,5)
|
Misc Tax A...(more) Join Now
|
POP30300.MSCTXAMT
|
|
|
| ORMSCTAX |
numeric(19,5)
|
Orig Misc ...(more) Join Now
|
POP30300.ORMSCTAX
|
|
|
| ACTINDX |
int
|
Account In...(more) Join Now
|
UPR00100.ACTINDX
|
|
join ... more text available
|
| TRXSORCE |
char(13)
|
Transactio...(more) Join Now
|
|
|
|
| TDTTXPUR |
numeric(19,5)
|
Tax Detail...(more) Join Now
|
PM30700.TDTTXPUR
|
|
|
| ORTXBPUR |
numeric(19,5)
|
Originatin...(more) Join Now
|
PM30700.ORTXBPUR
|
|
|
| TXDTTPUR |
numeric(19,5)
|
Tax Detail...(more) Join Now
|
PM30700.TXDTTPUR
|
|
|
| ORTOTPUR |
numeric(19,5)
|
Originatin...(more) Join Now
|
POP30360.ORTOTPUR
|
|
|
| CURRNIDX |
smallint
|
Currency I...(more) Join Now
|
CM20200.CURRNIDX
|
|
join ... more text available
|
| POSTED |
tinyint
|
Posted: S...(more) Join Now
|
RM10301.POSTED
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|