PA11800 - PA Combined History Header file | Prospr

PA11800 - PA Combined History Header file

Query Builder

Select * from PA11800

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	View
PADocnumber20	PA Document No.	String	18	View
PATRXType	PA TRX Type	Integer	2	View
PADOCDT	PA Document Date	Date	4	View
USERID	User ID	String	16	View
BACHNUMB	Batch Number	String	16	View
PAREFNO	PA Reference Document No.	String	18	View
PAUD1	PA User Defined 1	String	22	View
PAUD2	PA User Defined 2	String	22	View
VENDORID	Vendor ID	String	16	View
PACOSTOWNER	PA Cost Owner	String	32	View
PAREPD	PA Reporting Period	Integer	2	View
PAREPDT	PA Reporting Date	Date	4	View
PAreptsuff	PA Reporting Suffix	String	6	View
PAYR	PA Year	Integer	2	View
PAVENINVNO	PA Vendor Invoice Number	String	22	View
PAVENADDRESSID	PA Vendor Address ID	String	16	View
PACOMM	PA Comment	String	52	View
PYMTRMID	Payment Terms ID	String	22	View
DUEDATE	Due Date	Date	4	View
DSCDLRAM	Discount Dollar Amount	Currency	10	View
DISCDATE	Discount Date	Date	4	View
DISAMTAV	Discount Amount Available	Currency	10	View
PRCTDISC	Percent Discount	Integer	2	View
CURNCYID	Currency ID	String	16	View
SHIPMTHD	Shipping Method	String	16	View
PATQTY	PA Total Quantity	Currency	10	View
PAtotcosts	PA Total Costs	Currency	10	View
BKTPURAM	Backout Purchases Amount	Currency	10	View
PATACRV	PA Total Accrued Revenues	Currency	10	View
TRDISAMT	Trade Discount Amount	Currency	10	View
PAFreight_Taxable_P	PA Freight Taxable - Purchase	Integer	2	View
FRTSCHID	Freight Schedule ID	String	16	View
FRTAMNT	Freight Amount	Currency	10	View
FRTTXAMT	Freight Tax Amount	Currency	10	View
PAMisc_Taxable_P	PA Misc Taxable - Purchase	Integer	2	View
MSCSCHID	Misc Schedule ID	String	16	View
MSCCHAMT	Misc Charges Amount	Currency	10	View
MSCTXAMT	Misc Tax Amount	Currency	10	View
TAXAMNT	Tax Amount	Currency	10	View
DOCAMNT	Document Amount	Currency	10	View
TEN99AMNT	1099 Amount	Currency	10	View
UN1099AM	Unapplied 1099 Amount	Currency	10	View
CASHAMNT	Cash Amount	Currency	10	View
CAMCBKID	Cash Amount Checkbook ID	String	16	View
CDOCNMBR	Cash Document Number	String	22	View
CAMTDATE	Cash Amount Date	Date	4	View
CAMPMTNM	Cash Amount Payment Number	String	22	View
CHEKAMNT	Check Amount	Currency	10	View
CHEKNMBR	Check Number	String	22	View
CHEKDATE	Check Date	Date	4	View
CAMPYNBR	Check Amount Payment Number	String	22	View
CHAMCBID	Check Amount Checkbook ID	String	16	View
CRCRDAMT	Credit Card Amount	Currency	10	View
CARDNAME	Card Name	String	16	View
CRCARDDT	Credit Card Date	Date	4	View
CCAMPYNM	Credit Card Amount Payment Number	String	22	View
CCRCTNUM	Credit Card Receipt Number	String	22	View
DISTKNAM	Discount Taken Amount	Currency	10	View
CHRGAMNT	Charge Amount	Currency	10	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
PAPD	PA Post Date	Date	4	View
VOIDSTTS	Void Status 0 = Document has not been voided. 1 = Document has been voided. 2 = Document has been marked NSF and voided.	Integer	2	View
VOIDDATE	Void Date	Date	4	View
NOTEINDX	Note Index	Currency	10	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
PAORIGTOTCOSTS	PA Originating Total Costs	Currency	10	View
PAORIACCRREV	PA Originating Accrued Revenues	Currency	10	View
DISAVAMT	Discount Available Amount	Currency	10	View
TAXSCHID	Tax Schedule ID	String	16	View
PYMNTTRM	Payment Terms	String	16	View
POPTYPE	POP Type	Integer	2	View
VNDDOCNM	Vendor Document Number	String	22	View
ACTLSHIP	Actual Ship Date	Date	4	View
GLPOSTDT	GL Posting Date	Date	4	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
TRXSORCE	TRX Source	String	14	View
VCHRNMBR	Voucher Number	String	22	View

PA11800 - PA Combined History Header file

Query Builder

Customer Service

Information

My Account

Contact Us