PA30500 - PA Employee Expense Header History File | Prospr

PA30500 - PA Employee Expense Header History File

Query Builder

Select * from PA30500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PAertrxtype	PA Empl Expense TRX Type	Integer	2	View
PAerdocnumber	PA Empl Expense Document No.	String	18	View
PDK_EE_No	PDK EE No.	String	32	View
PADOCDT	PA Document Date	Date	4	View
PAPD	PA Post Date	Date	4	View
USERID	User ID	String	16	View
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	View
TRXSORCE	TRX Source	String	14	View
SHIPMTHD	Shipping Method	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
EMPLOYID	Employee ID	String	16	View
PAVENADDRESSID	PA Vendor Address ID	String	16	View
PAStartDate	PA Start Date	Date	4	View
PAEnDate	PA End Date	Date	4	View
PAreptsuff	PA Reporting Suffix	String	6	View
PAYR	PA Year	Integer	2	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
ORDDLRAT	Originating Discount Dollar Amount	Currency	10	View
DISCDATE	Discount Date	Date	4	View
DISAMTAV	Discount Amount Available	Currency	10	View
ODISAMTAV	Originating Discount Amount Available	Currency	10	View
PRCTDISC	Percent Discount	Integer	2	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
PATQTY	PA Total Quantity	Currency	10	View
PAEXTCOST	PA Extended Cost	Currency	10	View
OREXTCST	Originating Extended Cost	Currency	10	View
PAtotcosts	PA Total Costs	Currency	10	View
PAORIGTOTCOSTS	PA Originating Total Costs	Currency	10	View
PAREIMBURSTAXAMT	PA Reimbursable Tax Amount	Currency	10	View
PAORIGREIMTAXAMT	PA Originating Reimbursable Tax Amount	Currency	10	View
BKTPURAM	Backout Purchases Amount	Currency	10	View
PATACRV	PA Total Accrued Revenues	Currency	10	View
PAORIACCRREV	PA Originating Accrued Revenues	Currency	10	View
TRDISAMT	Trade Discount Amount	Currency	10	View
ORTDISAM	Originating 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
ORFRTAMT	Originating Freight Amount	Currency	10	View
FRTTXAMT	Freight Tax Amount	Currency	10	View
ORFRTTAX	Originating 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
OMISCAMT	Originating Misc Charges Amount	Currency	10	View
MSCTXAMT	Misc Tax Amount	Currency	10	View
ORMSCTAX	Originating Misc Tax Amount	Currency	10	View
DOCAMNT	Document Amount	Currency	10	View
ORDOCAMT	Originating Document Amount	Currency	10	View
TEN99AMNT	1099 Amount	Currency	10	View
OR1099AM	Originating 1099 Amount	Currency	10	View
UN1099AM	Unapplied 1099 Amount	Currency	10	View
CASHAMNT	Cash Amount	Currency	10	View
ORCASAMT	Originating 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
CHRGAMNT	Charge Amount	Currency	10	View
OCHGAMT	Originating Charge Amount	Currency	10	View
CHEKAMNT	Check Amount	Currency	10	View
ORCHKAMT	Originating 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
BCKTXAMT	Backout Tax Amount	Currency	10	View
OBTAXAMT	Originating Backout Tax Amount	Currency	10	View
TAXSCHID	Tax Schedule ID	String	16	View
TAXAMNT	Tax Amount	Currency	10	View
ORTAXAMT	Originating Tax Amount	Currency	10	View
CARDNAME	Card Name	String	16	View
CRCRDAMT	Credit Card Amount	Currency	10	View
ORCCDAMT	Originating Credit Card Amount	Currency	10	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
ORDISTKN	Originating Discount Taken Amount	Currency	10	View
ORDAVFRT	Originating Discount Available Freight	Currency	10	View
ORDAVMSC	Originating Discount Available Misc	Currency	10	View
ODAVPUR	Originating Discount Available Purchases	Currency	10	View
PAReimbursableAmount	PA Reimbursable Amount	Currency	10	View
PAOrigReimbursableAmt	PA Originating Reimbursable Amount	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
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
PApostoDynPM	PA Post to Dyn Payables Mgmt	Boolean	2	View
Tax_Date	Tax Date	Date	4	View
NOTEINDX	Note Index	Currency	10	View
TaxInvRecvd	Tax Invoice Received	Boolean	2	View
TaxInvReqd	Tax Invoice Required	Boolean	2	View
Correcting_Trx_Type	Correcting Trx Type	Integer	2	View
PAORIGINLDOCNUM	PA Original Document Number	String	18	View
TEN99TYPE	1099 Type 1 – Not a 1099 vendor 2 – Dividend 3 – Interest 4 - Miscellaneous	Integer	2	View
TEN99BOXNUMBER	1099 Box Number	Integer	2	View
CREATDDT	Created Date	Date	4	View
CRUSRID	Created User ID	String	16	View
POSTEDDT	Posted Date	Date	4	View
PSTUSRID	Post User ID	String	16	View

PA30500 - PA Employee Expense Header History File

Query Builder

Customer Service

Information

My Account

Contact Us