PA31102 - PA PO Receipt Line History | Prospr

PA31102 - PA PO Receipt Line History

Query Builder

Select * from PA31102

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PAVIDN	PA Vendor Invoice Document No.	String	18	View
RCPTLNNM	Receipt Line Number	Long Integer	4	View
PApurordnum	PA Purchase Order No.	String	18	View
ITEMNMBR	Item Number	String	32	View
BackoutTradeDiscTax	Backout Trade Discount Tax Amount	Currency	10	View
CURRNIDX	Currency Index	Integer	2	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXGTBLID	Exchange Table ID	String	16	View
GLPOSTDT	GL Posting Date	Date	4	View
ITMTSHID	Item Tax Schedule ID	String	16	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
ORD	Ord	Long Integer	4	View
OrigBackoutTradeDiscTax	Originating Backout Trade Discount Tax Amount	Currency	10	View
ORTDISAM	Originating Trade Discount Amount	Currency	10	View
PAAcctgMethod	PA Accounting Method	Integer	2	View
PAACREV	PA Accrued Revenues	Currency	10	View
PAApproved_Billing_Amou	PA Approved Billing Amount	Currency	10	View
PAAPPROVBILLRATE	PA Approved Billing Rate	Currency	10	View
PAAPPROVMKUPPCT	PA Approved Markup Percentage	Currency	10	View
PAApproved_Quantity	PA Approved Quantity	Currency	10	View
PA_Base_Billing_Rate	PA Base Billing Rate	Currency	10	View
PABaseOvhdCost	PA Base Overhead Cost	Currency	10	View
PABase_Qty	PA Base Qty	Currency	10	View
PABase_Unit_Cost	PA Base Unit Cost	Currency	10	View
PABilled_Amount	PA Billed Amount	Currency	10	View
PABilled_Discount	PA Billed Discount	Currency	10	View
PA_Billed_Profit_Amount_	PA Billed Profit Amount Average	Currency	10	View
PABilledProfitPercentage	PA Billed Profit Percentage Average	Currency	10	View
PA_Billed_Status	PA Billed Status	Boolean	2	View
PABilled_QtyN	PA Billed Qty	Currency	10	View
PABilledTax	PA Billed Tax	Currency	10	View
PAbillnoteidx	PA Billing Note Index	Currency	10	View
PABILRATE	PA Billing Rate	Currency	10	View
PABilling_StatusN	PA Billing Status 1 = Billable 2 = In Process 3 = Closed 4 = Non-Billable 5 = Fixed Fee Trx	Integer	2	View
PAbllngtype	PA Billing Type	Integer	2	View
PACBADDFRMFLY	PA CB From Add On The Fly	Boolean	2	View
PACHGORDNO	PA Change Order Number	String	18	View
PACogs_Idx	PA COGS IDX	Long Integer	4	View
PAContra_Account_IDX	PA Contra Account IDX	Long Integer	4	View
PACONTNUMBER	PA Contract Number	String	12	View
PACOSTCATID	PA Cost Category ID	String	16	View
PACOSTCATNME	PA Cost Category Name	String	32	View
PAIV_Item_Checkbox	PA IV Item Checkbox	Boolean	2	View
PALineItemSeq	PA Line Item Sequence	Long Integer	4	View
PAMARKPERCENT	PA Markup Percentage	Currency	10	View
PA_MC_Accrued_Revenue	PA MC Accrued Revenue	Currency	10	View
PA_MC_Base_Billing_Rate	PA MC Base Billing Rate	Currency	10	View
PA_MC_Billing_Rate	PA MC Billing Rate	Currency	10	View
PAMCCURNCYID	PA MC Currency ID	String	16	View
PA_MC_VarianceAccruedRev	PA MC Variance Accrued Revenues	Currency	10	View
PAORIACCRREV	PA Originating Accrued Revenues	Currency	10	View
PAORIGBASEOVRHCST	PA Originating Base Overhead Cost	Currency	10	View
PAORIGBILLRATE	PA Originating Billing Rate	Currency	10	View
PAORIGOVHDAMT	PA Originating Overhead Amount	Currency	10	View
PAORIGPROFAMT	PA Originating Profit Amount	Currency	10	View
PAOrigSEC	PA Originating Shipment Extended Cost	Currency	10	View
PAORIGTOTOVRHD	PA Originating Total Overhead	Currency	10	View
PAORIGTOTPROF	PA Originating Total Profit	Currency	10	View
PAOrigVarExt	PA Originating Variance Accrued Revenues	Currency	10	View
PAOverhead_Amount	PA Overhead Amount	Currency	10	View
PAOverhead_IDX	PA Overhead IDX	Long Integer	4	View
PAOverheaPercentage	PA Overhead Percentage	Currency	10	View
PAPO_Line_Errors	PA PO Line Errors	Long Integer	4	View
PAProfitAmount	PA Profit Amount	Currency	10	View
PAProfitPercent	PA Profit Percent	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
PAPROJNUMBER	PA Project Number	String	16	View
PAProjectType	PA Project Type	Integer	2	View
PAPurchase_Tax_Options	PA Purchase Tax Options	Integer	2	View
PAReference_Line_Seq_N	PA Reference Line Seq No	Long Integer	4	View
PAShipmentExtCost	PA Shipment Extended Cost	Currency	10	View
PATOTALOVERH	PA Total Overhead	Currency	10	View
PATotalProfit	PA Total Profit	Currency	10	View
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	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
PAUD1	PA User Defined 1	String	22	View
PAUD2	PA User Defined 2	String	22	View
PA_Variance_Cost	PA Variance Cost	Boolean	2	View
PA_Variance_Accrued_Reve	PA Variance Accrued Revenues	Currency	10	View
PA_Variance_QTY_Accrued_	PA Variance QTY Accrued Revenues	Currency	10	View
PAvendid	PA Vendor ID	String	16	View
PACGBWIPIDX	PA WIP IDX	Long Integer	4	View
POTYPE	PO Type 1 = Standard 2 = Drop Ship 3 = Blanket 4 = Blanket Drop Ship	Integer	2	View
POPTYPE	POP Type	Integer	2	View
PRICELVL	Price Level	String	16	View
RATECALC	Rate Calc Method	Integer	2	View
RATETPID	Rate Type ID	String	16	View
receiptdate	Receipt Date	Date	4	View
TIME1	Time	Time	4	View
TRDISAMT	Trade Discount Amount	Currency	10	View
UOMSCHDL	U Of M Schedule	String	12	View

PA31102 - PA PO Receipt Line History

Query Builder

Customer Service

Information

My Account

Contact Us