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

COMPANY..PA33203 Table Definition

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

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PABILLTRXT smallint
0

PADocnumber20 char(17)
''

PACOSTDOCNO char(17)
''

PACOSTSEQNO int
0

PASSN int
0

LNITMSEQ int
0
Line Item ...(more) Join Now
PAReference_Line_Seq_N int
0

PAPROJNUMBER char(15)
''
PA Project...(more) Join Now
join ... more text available
PATU smallint
0
PA Transac...(more) Join Now
PACOSTCATID char(15)
''
PA Cost Ca...(more) Join Now
PAbllngtype smallint
0
1=Billable...(more) Join Now
PACOSTDATE datetime
'1/1/1900'

PACOSTOWNER char(31)
''

PAUnit_of_Measure char(9)
''
PA Unit of...(more) Join Now
PAUNITCOST numeric(19,5)
0.00
PA Unit Co...(more) Join Now
PAProfitType smallint
0
PA Profit ...(more) Join Now
PABILRATE numeric(19,5)
0.00

PAMARKPERCENT numeric(19,5)
0.00

PAQtyQ numeric(19,5)
0.00

PAACREV numeric(19,5)
0.00

PATOTCST numeric(19,5)
0.00

PAWrite_UpDown_Amount numeric(19,5)
0.00
PA Write U...(more) Join Now
PAWrite_UpDown_Percenta int
0

PAApproved_Quantity numeric(19,5)
0.00
PA Approve...(more) Join Now
PAAPPROVBILLRATE numeric(19,5)
0.00

PAAPPROVMKUPPCT numeric(19,5)
0.00

PAApproved_Billing_Amou numeric(19,5)
0.00

PARecognizedRevenue numeric(19,5)
0.00

PAbillnoteidx numeric(19,5)
0.00
PA Billing...(more) Join Now
PATMtaxamt numeric(19,5)
0.00

PAbilltaxscheduleid char(15)
''
PA Billing...(more) Join Now
PABACKBILL 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
PACogs_Idx int
0
ACTIDX of ...(more) Join Now
PARev_IDX int
0

PAUnbilled_AR_Idx int
0

PAUnbilled_Proj_Rev_Idx int
0

PACGBWIPIDX int
0
ACTIDX of ...(more) Join Now
PA_Trade_Discount_Amount numeric(19,5)
0.00

PA_Variance tinyint
0

PA_Variance_Accrued_Reve numeric(19,5)
0.00

PAOrigUnitCost numeric(19,5)
0.00

PAORIGBILLRATE numeric(19,5)
0.00

PAORIACCRREV numeric(19,5)
0.00

PAORIGTOTCOST numeric(19,5)
0.00

PAOrigWUDAmt numeric(19,5)
0.00

PAOrigApprBillAmt numeric(19,5)
0.00

PAOrigApprBillRate numeric(19,5)
0.00

PAOrigRecogRevenue numeric(19,5)
0.00

PAOrigTaxAmtTM_ numeric(19,5)
0.00

PAOrigBackoutBillAmt numeric(19,5)
0.00

PAOrigTradeDiscAmt numeric(19,5)
0.00

PAOrigVarAccruedRev numeric(19,5)
0.00

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