Module List >
Module PA tables
PA11700
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PA11700 Table Definition
(COMPANY..PA Billing Subline Tax Detail)
Field Definitions:
What is the 'source' column?
| PADocnumber20 |
char(17)
''
|
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| PABillSubDetailType |
smallint
0
|
|
|
|
|
| PABILLSUBLINESEQ |
int
0
|
|
|
|
|
| PATU |
smallint
0
|
PA Transac...(more) Join Now
|
|
|
|
| TAXDTLID |
char(15)
''
|
|
|
|
|
| SEQNUMBR |
int
0
|
Sequence N...(more) Join Now
|
SEE30303.SEQNUMBR
|
|
|
| ACTINDX |
int
0
|
Account In...(more) Join Now
|
WO010702.ACTINDX
|
|
join ... more text available
|
| TAXAMNT |
numeric(19,5)
0.00
|
Tax Amount...(more) Join Now
|
|
|
|
| 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
|
|
|
| PABilledTax |
numeric(19,5)
0.00
|
|
|
|
|
| PAtotbillings |
numeric(19,5)
0.00
|
|
|
|
|
| PATotalTaxableBillings |
numeric(19,5)
0.00
|
|
|
|
|
| ORTAXAMT |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
PTE30501.ORTAXAMT
|
|
|
| ORFRTTAX |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
POP10100.ORFRTTAX
|
|
|
| ORMSCTAX |
numeric(19,5)
0.00
|
Originatin...(more) Join Now
|
POP10100.ORMSCTAX
|
|
|
| PAOrigBilledTax |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigTotalBilings |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigTotalTaxableBill |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|