PA10601 - PA Purchase Order Line | Prospr - Dynamics GP Table Reference

PA10601 - PA Purchase Order Line

Query Builder

Select * from PA10601

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
DATEVAL	DateValue	Date	4	View
FRTAMNT	Freight Amount	Currency	10	View
ITMTSHID	Item Tax Schedule ID	String	16	View
MSCCHAMT	Misc Charges 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
PABase_Qty	PA Base Qty	Currency	10	View
PABase_Unit_Cost	PA Base Unit Cost	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
PAORGBSUNITCST	PA Originating Base Unit Cost	Currency	10	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
PostedSubtotal	Posted Subtotal	Currency	10	View
PRICELVL	Price Level	String	16	View
TRDISAMT	Trade Discount Amount	Currency	10	View
UOMSCHDL	U Of M Schedule	String	12	View

PA10601 - PA Purchase Order Line

Query Builder

Customer Service

Information

My Account

Contact Us