PC_PO_TO_PC_AET (SQL Table)	Index Back
Purchasing Integration State State record for Purchasing Integration. The PC_STD_AET is getting to large, so creating another state record for Purchasing Integration specific fields.

PC_PO_TO_PC_AET

(SQL Table)

Purchasing Integration State

State record for Purchasing Integration. The PC_STD_AET is getting to large, so creating another state record for Purchasing Integration specific fields.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 GM_CSR_PO_CCA Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - Close Adj

3 GM_CSR_PO_CRV Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - COM Reversal

4 GM_CSR_PO_PO Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - Purchase Ord

5 GM_CSR_PO_REQ Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - Requisition

6 GM_CSR_PO_RRV Character(3) VARCHAR2(3) NOT NULL Cost Sharing PO - REQ Reversal

7 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).

8 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

9 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	GM_CSR_PO_CCA	Character(3)	VARCHAR2(3) NOT NULL	Cost Sharing PO - Close Adj
3	GM_CSR_PO_CRV	Character(3)	VARCHAR2(3) NOT NULL	Cost Sharing PO - COM Reversal
4	GM_CSR_PO_PO	Character(3)	VARCHAR2(3) NOT NULL	Cost Sharing PO - Purchase Ord
5	GM_CSR_PO_REQ	Character(3)	VARCHAR2(3) NOT NULL	Cost Sharing PO - Requisition
6	GM_CSR_PO_RRV	Character(3)	VARCHAR2(3) NOT NULL	Cost Sharing PO - REQ Reversal
7	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
8	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
9	ROW_COUNT	Number(8,0)	INTEGER NOT NULL	Number to Purge