PA30601 - PA Purchase Order Line History | Prospr

PA30601 - PA Purchase Order Line History

Query Builder

Select * from PA30601

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PApurordnum	PA Purchase Order No.	String	18	View
ORD	Ord	Long Integer	4	View
BRKFLD1	Break Field 1	Integer	2	View
ITEMNMBR	Item Number	String	32	View
VNDITNUM	Vendor Item Number	String	32	View
BackoutTradeDiscTax	Backout Trade Discount Tax Amount	Currency	10	View
Capital_Item	Capital Item	Boolean	2	View
CURNCYID	Currency ID	String	16	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
FRTAMNT	Freight Amount	Currency	10	View
ITMTSHID	Item Tax Schedule ID	String	16	View
ITMTRKOP	Item Tracking Option 1. None 2. Serial Numbers 3. Lot Numbers	Integer	2	View
MSCCHAMT	Misc Charges Amount	Currency	10	View
OrigBackoutTradeDiscTax	Originating Backout Trade Discount Tax Amount	Currency	10	View
ORFRTAMT	Originating Freight Amount	Currency	10	View
OMISCAMT	Originating Misc Charges Amount	Currency	10	View
ORTDISAM	Originating Trade Discount Amount	Currency	10	View
PAbillnoteidx	PA Billing Note Index	Currency	10	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
PACOSTCATID	PA Cost Category ID	String	16	View
PAIV_Item_Checkbox	PA IV Item Checkbox	Boolean	2	View
PALineItemSeq	PA Line Item Sequence	Long Integer	4	View
PAprojname	PA Project Name	String	32	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
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	View
PACGBWIPIDX	PA WIP IDX	Long Integer	4	View
PRICELVL	Price Level	String	16	View
QTYCMTBASE	QTY Committed In Base	Currency	10	View
QTYUNCMTBASE	QTY Uncommitted In Base	Currency	10	View
RATECALC	Rate Calc Method	Integer	2	View
TRDISAMT	Trade Discount Amount	Currency	10	View

PA30601 - PA Purchase Order Line History

Query Builder

Customer Service

Information

My Account

Contact Us