CP_ORD_LINE (SQL Table)	Index Back
Config Direct Order Entry Config Direct Order Entry

CP_ORD_LINE

(SQL Table)

Config Direct Order Entry

# 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_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

4 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
Default Value: 1

5 CP_ORD_STATUS Character(1) VARCHAR2(1) NOT NULL CP Order Status Field
C=Closed
E=Error
P=Pending
X=Open
Default Value: X

6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: CP_CFG_BUITM_VW

7 QTY_ORDERED Signed Number(16,4) DECIMAL(14,4) NOT NULL Order Qty

8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: INV_UOM_VW

9 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
Prompt Table: CP_CFGCD_PM2_VW

10 CP_PRDN_DUE_DTTM DateTime(26) TIMESTAMP Production Due Date/Time Field
Default Value: %Datetime

11 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: SP_BU_PC_NONVW

12 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJID_BUGL_VW

13 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: PROJ_ACT_FS

14 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field

15 UNIT_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Unit Cost

16 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.

#	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_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
4	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line Default Value: 1
5	CP_ORD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	CP Order Status Field C=Closed E=Error P=Pending X=Open Default Value: X
6	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: CP_CFG_BUITM_VW
7	QTY_ORDERED	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Order Qty
8	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: INV_UOM_VW
9	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator Prompt Table: CP_CFGCD_PM2_VW
10	CP_PRDN_DUE_DTTM	DateTime(26)	TIMESTAMP	Production Due Date/Time Field Default Value: %Datetime
11	BUSINESS_UNIT_PC	Character(5)	VARCHAR2(5) NOT NULL	PC Business Unit Prompt Table: SP_BU_PC_NONVW
12	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJID_BUGL_VW
13	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: PROJ_ACT_FS
14	CP_TEMPLATE_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID Field
15	UNIT_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Unit Cost
16	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.