GM_MS_AET(SQL Table) |
Index Back |
|---|---|
Milestone AE State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |