AM_WC_APVALIDAT (SQL View)	Index Back
AM WorkCenter AP Validation AM/AP Voucher Validation.

AM_WC_APVALIDAT

(SQL View)

AM WorkCenter AP Validation

AM/AP Voucher Validation.

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.DISTRIB_LINE_NUM , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.AM_DISTRIB_STATUS , ' ' , I.POST_STATUS_AP , A.LEDGER_GROUP , A.LEDGER , I.INVOICE_DT , SUM( A.MONETARY_AMOUNT) FROM PS_VCHR_ACCTG_LINE A , PS_VOUCHER I WHERE A.ASSET_FLG = 'Y' AND A.BUSINESS_UNIT = I.BUSINESS_UNIT AND A.VOUCHER_ID = I.VOUCHER_ID AND NOT EXISTS ( SELECT 'X' FROM PS_ASSET_ACQ_DET D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT_AM AND D.VOUCHER_ID = A.VOUCHER_ID AND D.VOUCHER_LINE_NUM = A.VOUCHER_LINE_NUM AND D.DISTRIB_LINE_NUM = A.DISTRIB_LINE_NUM AND D.SYSTEM_SOURCE = 'PAP') GROUP BY A.BUSINESS_UNIT,A.VOUCHER_ID, A.VOUCHER_LINE_NUM, A.DISTRIB_LINE_NUM, A.AM_DISTRIB_STATUS, I.POST_STATUS_AP, A.BUSINESS_UNIT_AM, A.ASSET_ID, A.LEDGER_GROUP, A.LEDGER, I.INVOICE_DT HAVING ( SUM( A.MONETARY_AMOUNT) <> 0)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

6 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

7 AM_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL AM Distribution Status
D=Distributed
I=Ignore
M=Modified
N=Not Distributed
P=Pending
V=Reversed

8 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name

9 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted

10 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

11 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger

12 INVOICE_DT Date(10) DATE Invoice Date

13 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_AP	Character(5)	VARCHAR2(5) NOT NULL	AP Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
4	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
7	AM_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	AM Distribution Status D=Distributed I=Ignore M=Modified N=Not Distributed P=Pending V=Reversed
8	XLATLONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Translate Long Name
9	POST_STATUS_AP	Character(1)	VARCHAR2(1) NOT NULL	Post Status N=Payment Not Applied P=Posted U=Unposted
10	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
11	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger
12	INVOICE_DT	Date(10)	DATE	Invoice Date
13	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.