Module List >
Module PA tables
PA33201
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PA33201 Table Definition
(COMPANY..PA Billing Sub-Detail HIST Fee)
Field Definitions:
What is the 'source' column?
| PABILLTRXT |
smallint
0
|
|
|
|
|
| PADocnumber20 |
char(17)
''
|
|
|
|
|
| PAPROJNUMBER |
char(15)
''
|
PA Project...(more) Join Now
|
|
|
join ... more text available
|
| CUTOFDAT |
datetime
'1/1/1900'
|
|
|
|
|
| LNITMSEQ |
int
0
|
Line Item ...(more) Join Now
|
|
|
|
| PAFeeID |
char(15)
''
|
PA Fee ID ...(more) Join Now
|
|
|
|
| PAFeebillamount |
numeric(19,5)
0.00
|
|
|
|
|
| PAFeeAmount |
numeric(19,5)
0.00
|
PA Fee Amo...(more) Join Now
|
|
|
|
| PAPreviously_Billed |
numeric(19,5)
0.00
|
|
|
|
|
| PAbillnoteidx |
numeric(19,5)
0.00
|
PA Billing...(more) Join Now
|
|
|
|
| PAbilltaxscheduleid |
char(15)
''
|
PA Billing...(more) Join Now
|
|
|
|
| PAFeetaxamount |
numeric(19,5)
0.00
|
|
|
|
|
| PABACKBILL |
numeric(19,5)
0.00
|
|
|
|
|
| PAFeeType |
smallint
0
|
In additio...(more) Join Now
|
|
|
|
| PARetainer_Fee_Amount |
numeric(19,5)
0.00
|
PA Project...(more) Join Now
|
|
|
|
| PA_Project_Sales_IDX |
int
0
|
|
|
|
|
| PAAR_IDX |
int
0
|
From the R...(more) Join Now
|
|
|
|
| PA_Deferred_RevIDX |
int
0
|
|
|
|
|
| PACGBWIPIDX |
int
0
|
ACTIDX of ...(more) Join Now
|
|
|
|
| PABProjectBlgsIDX |
int
0
|
|
|
|
|
| PA_FF_AR_IDX |
int
0
|
|
|
|
|
| PABProjectRevenueIDX |
int
0
|
|
|
|
|
| PA_Retention_AR |
int
0
|
|
|
|
|
| PA_FF_Deferred_Rev_IDX |
int
0
|
|
|
|
|
| PA_Trade_Discount_Amount |
numeric(19,5)
0.00
|
|
|
|
|
| PARetentionFeeAmount |
numeric(19,5)
0.00
|
PA Retenti...(more) Join Now
|
|
|
|
| PA_Retention_IDX |
int
0
|
|
|
|
|
| PAUD1 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PAUD2 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PAOrigBillingAmtFee |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigFeeAmount |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigPrevBill |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigTaxAmtFee |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigBackoutBillAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigTradeDiscAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PAOrigRetentionFeeAmt |
numeric(19,5)
0.00
|
|
|
|
|
| PA_Previous_Retention |
numeric(19,5)
0.00
|
|
|
|
|
| PAOPREVRETENTION |
numeric(19,5)
0.00
|
|
|
|
|
| PACHGORDNO |
char(17)
''
|
PA Change ...(more) Join Now
|
|
|
|
| BackoutTradeDisc |
numeric(19,5)
0.00
|
Backout Tr...(more) Join Now
|
RM20101.BackoutTradeDisc
|
|
|
| OrigBackoutTradeDisc |
numeric(19,5)
0.00
|
GPSFO Inte...(more) Join Now
|
SOP10200.OrigBackoutTradeDisc
|
|
|
| PA_Backout_Retention_Amt |
numeric(19,5)
0.00
|
|
|
|
|
| PA_OrigBackRetentionAmt |
numeric(19,5)
0.00
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|