peoplesoft quick invoice to create vouchers

#PEOPLESOFT QUICK INVOICE TO CREATE VOUCHERS MANUAL#

2%/10 ENTERED_DT Date Voucher entered date MANUAL_CLOSE_DT Date Manual close date DESCR254_MIXED Char 254 Voucher commentsĢ VOUCHER_LINE * BUSINESS_UNIT Char 5 Always = UIOWA VOUCHER_LINE_NUM Num 5 Voucher line number LINE_NBR Num 5 PO line number DESCR Char 30 Voucher line description MERCHANDISE_AMT Num 17 Voucher line amount QTY_VCHR Num 17 Quantity vouchered UNIT_OF_MEASURE Char 3 Unit of measure UNIT_PRICE Num 17 Unit price WTHD_SW Char 1 Y = 1099 applicable N = not 1099 applicable WTDH_CD Char 5 Withholding code - Either blank or a 2 digit code if the vendor is 1099 reportable. * = Key field TABLE FIELD NAMES FORMAT DESCRIPTION VOUCHER * BUSINESS_UNIT Char 5 Always = UIOWA INVOICE_ID Char 30 Invoice number INVOICE_DT Date Invoice date VENDOR_ID Char 10 Vendor number VNDR_LOC Char 10 Vendor location number ADDRESS_SEQ_NUM Num 3 Address number GRP_AP_ID Char 6 AP's internal control group number OPRID Char 8 AP operator entering voucher CLOSE_STATUS Char 1 C = Closed O = Open ENTRY_STATUS Char 1 C = Complete O = Open P = Postable R = Recycle S = Scheduled for Payment X = Deleted ACCOUNTING_DT Date Accounting date POST_STATUS_AP Char 1 P = Posted U = Unposted GROSS_AMT Num 17 Gross invoice amount DSCNT_AMT Num 17 Discount amount FREIGHT_AMT Num 17 Freight amount PYMNT_TERMS_CD Char 5 Payment Terms - i.e. Access returns values rather than descriptions.

1 PEOPLESOFT VOUCHER TABLES IN THE DATA WAREHOUSE These are the commonly used and most useful fields from these tables.

Peoplesoft quick invoice to create vouchers