Module List >
Module PA tables
PA33602
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PA33602 Table Definition
(COMPANY..PA Applied Sub Detail History File)
Field Definitions:
What is the 'source' column?
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
RVLPD029.DOCNUMBR
|
|
|
| PADocnumber20 |
char(17)
''
|
|
|
|
|
| PABILLTRXT |
smallint
0
|
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| PASource_Type |
smallint
0
|
|
|
|
|
| PArecordid |
char(15)
''
|
This recor...(more) Join Now
|
PA43001.PArecordid
|
|
|
| PACOSTDOCNO |
char(17)
''
|
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| PABillingAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PAFAA |
numeric(19,5)
0.00
|
|
|
|
|
| PACCAA |
numeric(19,5)
0.00
|
|
|
|
|
| PAWA |
numeric(19,5)
0.00
|
|
|
|
|
| PATTA |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Tax_Applied_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Terms_Taken_Tax_Amt |
numeric(19,5)
0.00
|
PA Terms T...(more) Join Now
|
|
|
|
| PA_Write_Off_Tax_Amount |
numeric(19,5)
0.00
|
PA Write O...(more) Join Now
|
|
|
|
| PA_Credit_Retainer_App |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|