Module List >
Module SOP tables
SOP10105
You are currently viewing the COMPANY
database.
Change
|
COMPANY..SOP10105 Table Definition
(COMPANY..Sales Taxes Work and History)
Field Definitions:
What is the 'source' column?
| SOPTYPE |
smallint
0
|
SOP Type: ...(more) Join Now
|
|
|
|
| SOPNUMBE |
char(21)
''
|
SOP Number...(more) Join Now
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| TAXDTLID |
char(15)
''
|
Tax Detail...(more) Join Now
|
|
|
|
| ACTINDX |
int
0
|
Account In...(more) Join Now
|
|
|
join ... more text available
|
| BKOUTTAX |
tinyint
0
|
Backout Ta...(more) Join Now
|
|
|
|
| TXABLETX |
tinyint
0
|
Taxable Ta...(more) Join Now
|
|
|
|
| STAXAMNT |
numeric(19,5)
0.00
|
Sales Tax ...(more) Join Now
|
|
|
|
| ORSLSTAX |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| FRTTXAMT |
numeric(19,5)
0.00
|
Freight Ta...(more) Join Now
|
|
|
|
| ORFRTTAX |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| MSCTXAMT |
numeric(19,5)
0.00
|
Misc Tax A...(more) Join Now
|
|
|
|
| ORMSCTAX |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| TAXDTSLS |
numeric(19,5)
0.00
|
Tax Detail...(more) Join Now
|
|
|
|
| ORTOTSLS |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| TDTTXSLS |
numeric(19,5)
0.00
|
table bord...(more) Join Now
|
|
|
|
| ORTXSLS |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| TXDTOTTX |
numeric(19,5)
0.00
|
Tax Detail...(more) Join Now
|
|
|
|
| OTTAXPON |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
|
|
|
| DELETE1 |
tinyint
0
|
Delete: ...(more) Join Now
|
|
|
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|