CP_ORD_LINE_VW(SQL View) |
Index Back |
|---|---|
CP Order Line View - MaintCP Order Line View - Maint |
| SELECT BUSINESS_UNIT , ORDER_NO , CP_MODE , CP_MODE FROM PS_CP_ORD_HEADER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BUMGOP_NONVW |
| 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
Default Value: NEXT |
| 3 | CP_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Order Type Field
M=Direct Production Order R=Direct Requisition Order Default Value: M |
| 4 | CP_MODE |
Character(1) | VARCHAR2(1) NOT NULL |
Rule Processing Modes Field
A=CRM Internal C=Model Tester M=Direct Production Order R=Direct Requisition Order S=Sales Order W=CRM External Default Value: M |