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

COMPANY..PA23203 Table Definition

(COMPANY..PA Billing Sub-Detail OPEN 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

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

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

PARetainer_Fee_Amount numeric(19,5)
0.00
PA Project...(more) Join Now
PAbilltaxscheduleid char(15)
''
PA Billing...(more) Join Now
PABACKBILL numeric(19,5)
0.00

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
CURTRXAM numeric(19,5)
0.00

ORTRXAMT numeric(19,5)
0.00

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

PAOrigApprBillRate numeric(19,5)
0.00

PAOrigApprBillAmt 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

ORCTRXAM numeric(19,5)
0.00

ORORGTRX numeric(19,5)
0.00

PAOrigVarAccruedRev numeric(19,5)
0.00

PACHGORDNO char(17)
''
PA Change ...(more) Join Now
BackoutTradeDisc numeric(19,5)
0.00
Backout Tr...(more) Join Now
OrigBackoutTradeDisc numeric(19,5)
0.00
GPSFO Inte...(more) Join Now
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