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 |