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