Module List > Module Tax tables TX00201
You are currently viewing the COMPANY database.
Change

COMPANY..TX00201 Table Definition

(COMPANY..Sales/Purchases Tax Master)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
TAXDTLID char(15)
''
Tax Detail...(more) Join Now
TXDTLDSC char(31)
''
Tax Detail...(more) Join Now
TXDTLTYP smallint
0
Tax Detail...(more) Join Now
ACTINDX int
0
Account In...(more) Join Now
join ... more text available
TXIDNMBR char(11)
''
Tax ID Num...(more) Join Now PM00200.TXIDNMBR
TXDTLBSE smallint
0
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
TDTLRNDG smallint
0
Tax Detail...(more) Join Now
TXDBODTL char(15)
''
Tax Detail...(more) Join Now
TDTABMIN numeric(19,5)
0.00
Tax Detail...(more) Join Now
TDTABMAX numeric(19,5)
0.00
Tax Detail...(more) Join Now
TDTAXMIN numeric(19,5)
0.00
Tax Detail...(more) Join Now
TDTAXMAX numeric(19,5)
0.00
Tax Detail...(more) Join Now
TDRNGTYP smallint
0
Tax Detail...(more) Join Now
TXDTQUAL smallint
0
Tax Detail...(more) Join Now
TDTAXTAX tinyint
0
Tax Detail...(more) Join Now
TXDTLPDC tinyint
0
Tax Detail...(more) Join Now
TXDTLPCH char(1)
''
Tax Detail...(more) Join Now
TXDXDISC tinyint
0
Tax Detail...(more) Join Now
CMNYTXID char(15)
''
Company Ta...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
NAME char(31)
''
Name: Name...(more) Join Now
CNTCPRSN char(61)
''
Contact Pe...(more) Join Now RM00101.CNTCPRSN
ADDRESS1 char(61)
''
Address 1:...(more) Join Now RM00101.ADDRESS1
ADDRESS2 char(61)
''
Address 2:...(more) Join Now RM00101.ADDRESS2
ADDRESS3 char(61)
''
Address 3:...(more) Join Now RM00101.ADDRESS3
CITY char(35)
''
City: City...(more) Join Now RM00101.CITY
STATE char(29)
''
State: Up...(more) Join Now
ZIPCODE char(11)
''
Zip Code: ...(more) Join Now
COUNTRY char(61)
''
Country: C...(more) Join Now RM00101.COUNTRY
PHONE1 char(21)
''
Phone 1: ...(more) Join Now
PHONE2 char(21)
''
Phone 2: ...(more) Join Now
PHONE3 char(21)
''
Phone 3: ...(more) Join Now RM00101.PHONE3
FAX char(21)
''
Fax: Sam...(more) Join Now
TXUSRDF1 char(21)
''
Tax User D...(more) Join Now
TXUSRDF2 char(21)
''
Tax User D...(more) Join Now
VATREGTX tinyint
0
VAT Regist...(more) Join Now
TaxInvReqd tinyint
0
Tax Invoic...(more) Join Now
TaxPostToAcct smallint
0
Tax Post T...(more) Join Now
TaxBoxes binary(4)
0
Tax Boxes:...(more) Join Now
IGNRGRSSAMNT tinyint
0
Ignore Gro...(more) Join Now
TDTABPCT numeric(19,5)
0.00
Tax Detail...(more) Join Now
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