PA23203 - PA Billing Sub-Detail OPEN TM | Prospr

PA23203 - PA Billing Sub-Detail OPEN TM

Query Builder

Select * from PA23203

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PABILLTRXT	PA Biller Trx Type	Integer	2	View
PADocnumber20	PA Document No.	String	18	View
PACOSTDOCNO	PA Cost Document No.	String	18	View
PACOSTSEQNO	PA Cost Sequence No.	Long Integer	4	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
PASSN	PA Split Sequence Number	Long Integer	4	View
PAReference_Line_Seq_N	PA Reference Line Seq No	Long Integer	4	View
PAPROJNUMBER	PA Project Number	String	16	View
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	View
PACOSTCATID	PA Cost Category ID	String	16	View
PAbllngtype	PA Billing Type	Integer	2	View
PACOSTDATE	PA Cost Date	Date	4	View
PACOSTOWNER	PA Cost Owner	String	32	View
PAUnit_of_Measure	PA Unit of Measure	String	10	View
PAUNITCOST	PA Unit Cost	Currency	10	View
PAProfitType	PA Profit Type 1 = Billing Rate 2 = Markup 3 = Profit/Unit Fixed 4 = Profit/Unit Variable 5 = Total Profit 6 = % of Baseline 7 = % of Actual 8 = None 9 = Price Level	Integer	2	View
PABILRATE	PA Billing Rate	Currency	10	View
PAMARKPERCENT	PA Markup Percentage	Currency	10	View
PAQtyQ	PA Quantity	Currency	10	View
PAACREV	PA Accrued Revenues	Currency	10	View
PATOTCST	PA Total Cost	Currency	10	View
PAWrite_UpDown_Amount	PA Write Up/Down Amount	Currency	10	View
PAWrite_UpDown_Percenta	PA Write Up/Down Percentage	Long Integer	4	View
PAApproved_Quantity	PA Approved Quantity	Currency	10	View
PAAPPROVBILLRATE	PA Approved Billing Rate	Currency	10	View
PAAPPROVMKUPPCT	PA Approved Markup Percentage	Currency	10	View
PAApproved_Billing_Amou	PA Approved Billing Amount	Currency	10	View
PARecognizedRevenue	PA Recognized Revenue	Currency	10	View
PAbillnoteidx	PA Billing Note Index	Currency	10	View
PATMtaxamt	PA Tax Amt - TM	Currency	10	View
PARetainer_Fee_Amount	PA Retainer Fee Amount	Currency	10	View
PAbilltaxscheduleid	PA Billing Tax Schedule ID	String	16	View
PABACKBILL	PA Backout Bill Amount	Currency	10	View
PAAR_IDX	PA AR IDX	Long Integer	4	View
PACogs_Idx	PA COGS IDX	Long Integer	4	View
PARev_IDX	PA Revenue IDX	Long Integer	4	View
PAUnbilled_AR_Idx	PA Unbilled AR IDX	Long Integer	4	View
PAUnbilled_Proj_Rev_Idx	PA Unbilled Proj Rev IDX	Long Integer	4	View
PACGBWIPIDX	PA WIP IDX	Long Integer	4	View
CURTRXAM	Current Trx Amount	Currency	10	View
ORTRXAMT	Original Trx Amount	Currency	10	View
PA_Trade_Discount_Amount	PA Trade Discount Amount	Currency	10	View
PA_Variance	PA Variance	Boolean	2	View
PA_Variance_Accrued_Reve	PA Variance Accrued Revenues	Currency	10	View
PAOrigUnitCost	PA Originating Unit Cost	Currency	10	View
PAORIGBILLRATE	PA Originating Billing Rate	Currency	10	View
PAORIACCRREV	PA Originating Accrued Revenues	Currency	10	View
PAORIGTOTCOST	PA Originating Total Cost	Currency	10	View
PAOrigWUDAmt	PA Originating Write Up/Down Amt	Currency	10	View
PAOrigApprBillRate	PA Originating Approved Billing Rate	Currency	10	View
PAOrigApprBillAmt	PA Originating Approved Billing Amount	Currency	10	View
PAOrigRecogRevenue	PA Originating Recognized Revenue	Currency	10	View
PAOrigTaxAmtTM_	PA Originating Tax Amt - TM	Currency	10	View
PAOrigBackoutBillAmt	PA Originating Backout Bill Amt	Currency	10	View
PAOrigTradeDiscAmt	PA Originating Trade Discount Amt	Currency	10	View
ORCTRXAM	Originating Current Trx Amount	Currency	10	View
ORORGTRX	Originating Original Trx Amount	Currency	10	View
PAOrigVarAccruedRev	PA Originating Variance Accrued Rev	Currency	10	View
PACHGORDNO	PA Change Order Number	String	18	View
BackoutTradeDisc	Backout Trade Discount Amount	Currency	10	View
OrigBackoutTradeDisc	Originating Backout Trade Discount Amount	Currency	10	View

PA23203 - PA Billing Sub-Detail OPEN TM

Query Builder

Customer Service

Information

My Account

Contact Us