| TAXDTLID |
char(15)
''
|
Tax Detail...(more) Join Now
|
|
|
|
| TXDTLDSC |
char(31)
''
|
Tax Detail...(more) Join Now
|
|
|
|
| TXDTLTYP |
smallint
0
|
Tax Detail...(more) Join Now
|
|
|
|
| Account_String |
char(129)
''
|
|
|
|
|
| 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
|
|
|
|
| NAME |
char(31)
''
|
Name: Name...(more) Join Now
|
|
|
|
| CNTCPRSN |
char(31)
''
|
Contact Pe...(more) Join Now
|
RM00101.CNTCPRSN
|
|
|
| ADDRESS1 |
char(31)
''
|
Address 1:...(more) Join Now
|
RM00101.ADDRESS1
|
|
|
| ADDRESS2 |
char(31)
''
|
Address 2:...(more) Join Now
|
RM00101.ADDRESS2
|
|
|
| ADDRESS3 |
char(31)
''
|
Address 3:...(more) Join Now
|
RM00101.ADDRESS3
|
|
|
| CITY |
char(31)
''
|
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(21)
''
|
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
|
|
|
|
| Imported_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Imported_Time |
datetime
'1/1/1900'
|
|
|
|
|
| Migrated |
tinyint
0
|
|
|
|
|
| Migrated_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Migrated_Time |
datetime
'1/1/1900'
|
|
|
|
|
| ERRDESCR |
char(131)
''
|
|
|
|
|
| UMA_Text_Field |
char(255)
''
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|