Module List > Module PA tables GST00105
You are currently viewing the COMPANY database.
Change

COMPANY..GST00105 Table Definition

(COMPANY..PA Purchasing Tax History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PAVIDN char(17)
''

RCPTLNNM int
0
Receipt Li...(more) Join Now POP10500.RCPTLNNM
TAXDTLID char(15)
''
Tax Detail...(more) Join Now TX00201.TAXDTLID
ACTINDX int
0
Account In...(more) Join Now UPR00100.ACTINDX
join ... more text available
TAXAMNT numeric(19,5)
0.00
Tax Amount...(more) Join Now RM20101.TAXAMNT
ORTAXAMT numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.ORTAXAMT
TAXPURCH numeric(19,5)
0.00

ORGTXPCH numeric(19,5)
0.00

TOTPURCH numeric(19,5)
0.00
Total Purc...(more) Join Now POP10160.TOTPURCH
ORTOTPUR numeric(19,5)
0.00
Originatin...(more) Join Now POP30360.ORTOTPUR
TRXSORCE char(13)
''
Transactio...(more) Join Now
POP_Tax_Note_ID_Array_1 numeric(19,5)
0.00
POP Tax No...(more) Join Now POP10160.POP_Tax_Note_ID_Array_1
POP_Tax_Note_ID_Array_2 numeric(19,5)
0.00
Currency I...(more) Join Now POP10160.POP_Tax_Note_ID_Array_2
PCTAXAMT numeric(19,5)
0.00
Purchase T...(more) Join Now PM30700.PCTAXAMT
FRTTXAMT numeric(19,5)
0.00
Freight Ta...(more) Join Now POP10100.FRTTXAMT
MSCTXAMT numeric(19,5)
0.00
Misc Tax A...(more) Join Now POP10100.MSCTXAMT
TXDTTPUR numeric(19,5)
0.00
Tax Detail...(more) Join Now PM30700.TXDTTPUR
TDTTXPUR numeric(19,5)
0.00
Tax Detail...(more) Join Now PM30700.TDTTXPUR
CURRNIDX smallint
0
Currency I...(more) Join Now CM20200.CURRNIDX
join ... more text available
BKOUTTAX tinyint
0

ORPURTAX numeric(19,5)
0.00
Originatin...(more) Join Now PM30700.ORPURTAX
ORFRTTAX numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.ORFRTTAX
ORMSCTAX numeric(19,5)
0.00
Originatin...(more) Join Now POP10100.ORMSCTAX
PAOTDTP numeric(19,5)
0.00

PAOTDTT numeric(19,5)
0.00

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3