APL_UPG_AET

(SQL Table)
Index Back

AP Upgrade AE State Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
3 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
4 WTHD_TYPE Character(5) VARCHAR2(5) NOT NULL Withholding Type
5 WTHD_RPT_ID Character(10) VARCHAR2(10) NOT NULL Withholding Report ID
6 WTHD_CLASS Character(5) VARCHAR2(5) NOT NULL Withholding Class
7 LINE_NO Number(3,0) SMALLINT NOT NULL Line Number
8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
9 WTHD_RULE Character(5) VARCHAR2(5) NOT NULL Withholding Rule
10 EFFDT Date(10) DATE Effective Date

Default Value: %date

11 PRCNT_WTHHLD Number(6,2) DECIMAL(5,2) NOT NULL Percent Withheld
12 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
13 PYMNT_GROUP_CD Character(2) VARCHAR2(2) NOT NULL Pay Group Code
14 UPG_RELEASE Character(4) VARCHAR2(4) NOT NULL Upgrade Application Release
751=7.51 Release
752=7.52 Release
753=7.53 Release
801=8 SP1 Release
803=8 SP3 Release
840=8.40 Release
841=8.40 SP1
880=8.80 Release
15 PUBLIC_SECTOR Character(1) VARCHAR2(1) NOT NULL Public Sector
16 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
17 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
18 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
19 PO_SCHED_NBR Number(3,0) SMALLINT NOT NULL PO Schedule Number
20 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
21 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
22 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
23 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple