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)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3