BUSINESS_UNITORDER_NOORDER_INT_LINE_NOSCHED_LINE_NBRREASON_CDPrompt Table: CHANGE_RSN_VW
DATETIME_ADDEDSPF_REQ_REASON(SQL Table) |
Index Back |
|---|---|
SP Req Chg Reason CodesTHIS RECORD WILL NOT BE USED IN 8.0. THIS WILL BE USED IN THE FUTURE. This table records all changes to and order line and the reason code indicating why the change was made. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ORDER_NO |
Character(10) | VARCHAR2(10) NOT NULL | Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop |
| 3 | ORDER_INT_LINE_NO |
Number(5,0) | INTEGER NOT NULL | Order Line |
| 4 | SCHED_LINE_NBR |
Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 5 | REASON_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table: CHANGE_RSN_VW |
| 6 | DATETIME_ADDED |
DateTime(26) | TIMESTAMP | DateTime Added |
| 7 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 8 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |