Module List > Module PA tables PA33202
You are currently viewing the COMPANY database.
Change

COMPANY..PA33202 Table Definition

(COMPANY..PA Billing Sub-Detail HIST FF)

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'

PACOSTCATID char(15)
''
PA Cost Ca...(more) Join Now
PAAcctgMethod smallint
0
Useful in ...(more) Join Now
PATOTCST numeric(19,5)
0.00

PATQTY numeric(19,5)
0.00

PAPercentCompleted numeric(19,5)
0.00

PAFFbillamount numeric(19,5)
0.00

PARetentionFeeAmount numeric(19,5)
0.00
PA Retenti...(more) Join Now
PAbillnoteidx numeric(19,5)
0.00
PA Billing...(more) Join Now
PAbilltaxscheduleid char(15)
''
PA Billing...(more) Join Now
PAFFtaxamt numeric(19,5)
0.00

LNITMSEQ int
0
Line Item ...(more) Join Now
PABACKBILL numeric(19,5)
0.00

PATU smallint
0
PA Transac...(more) Join Now
PACostPcntCompleted numeric(19,5)
0.00
PA Cost Pe...(more) Join Now
PAQuantityPcntCompleted numeric(19,5)
0.00
PA Quantit...(more) Join Now
PAObservedPcntCompleted numeric(19,5)
0.00

PAAmount_Earned numeric(19,5)
0.00

PAPreviously_Billed numeric(19,5)
0.00

PARetainer_Fee_Amount numeric(19,5)
0.00
PA Project...(more) Join Now
PAAR_IDX int
0
From the R...(more) Join Now
PABillRevAcctIdx int
0

PA_Trade_Discount_Amount numeric(19,5)
0.00

PA_Retention_IDX int
0

PAORIGTOTCOST numeric(19,5)
0.00

PAOrigBillingAmtFF numeric(19,5)
0.00

PAOrigRetentionFeeAmt numeric(19,5)
0.00

PAOrigTaxAmtFF numeric(19,5)
0.00

PAOrigBackoutBillAmt numeric(19,5)
0.00

PAOrigAmtEarned numeric(19,5)
0.00

PAOrigPrevBill numeric(19,5)
0.00

PAOrigTradeDiscAmt 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
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