GM_MS_AET

(SQL Table)
Index Back

Milestone AE State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 MILESTONE_ID Character(6) VARCHAR2(6) NOT NULL Milestone_ID identifies the milestones that can be referenced from multiple functional areas.
5 MILESTONE_TYPE Character(5) VARCHAR2(5) NOT NULL Milestone Type
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
7 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
8 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
9 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
10 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
11 DATE_FROM Date(10) DATE Date From
12 DATE_TO Date(10) DATE Date To
13 GM_CI_RETURN Number(3,0) SMALLINT NOT NULL CI Return
14 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
15 PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Processing Flag
16 MILESTONE_STAT Character(3) VARCHAR2(3) NOT NULL Milestone Status

Prompt Table: GM_MILE_STATUS