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

COMPANY..PA13203 Table Definition

(COMPANY..PA Billing Sub-Detail WORK 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
PATU smallint
0
PA Transac...(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

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

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

PAPreviously_Billed numeric(19,5)
0.00

PAAmount_Earned numeric(19,5)
0.00

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

PAAR_IDX int
0
From the R...(more) Join Now
PABillRevAcctIdx int
0

PABPSE binary(4)
0

PARetentionFeeAmount numeric(19,5)
0.00
PA Retenti...(more) Join Now
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

PAOrigTaxAmtFF numeric(19,5)
0.00

PAOrigPrevBill numeric(19,5)
0.00

PAOrigAmtEarned numeric(19,5)
0.00

PAOrigBackoutBillAmt numeric(19,5)
0.00

PAOrigRetentionFeeAmt 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