OMC_ORD_LST_TMP

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 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

4 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

6 FREIGHT_CHARGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge

7 FREIGHT_CHARGE_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge (base)

8 FREIGHT_BILLD_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Amount Billed/Posted

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

10 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

11 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

12 BACKGROUND_REQD Character(1) VARCHAR2(1) NOT NULL Background Process Required
E=OMBCKEND Req'd
N=No
P=Pricing Req'd
Y=Yes

13 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order

14 ORDER_STATUS Character(3) VARCHAR2(3) NOT NULL Order Status
C=Closed
O=Open
P=Pending
X=Canceled

15 ORDER_GRP Character(6) VARCHAR2(6) NOT NULL Order Group

16 ORDER_DATE Date(10) DATE Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop

17 SOURCE_CD Character(6) VARCHAR2(6) NOT NULL Source Code

18 ADDTL_ADJUST_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Adjustment Amount (base)

19 ADDTL_ADJUST_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Adjustment %

20 ADDTL_ADJUST_AMT Signed Number(29,4) DECIMAL(27,4) NOT NULL Adjustment Amount

21 DATETIME_ADDED DateTime(26) TIMESTAMP DateTime Added

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	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
4	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
6	FREIGHT_CHARGE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge
7	FREIGHT_CHARGE_BSE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge (base)
8	FREIGHT_BILLD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Freight Amount Billed/Posted
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
11	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag
12	BACKGROUND_REQD	Character(1)	VARCHAR2(1) NOT NULL	Background Process Required E=OMBCKEND Req'd N=No P=Pricing Req'd Y=Yes
13	ORDER_TYPE_CD	Character(3)	VARCHAR2(3) NOT NULL	Order Type QUO=Sales Quote SO=Sales Order
14	ORDER_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Order Status C=Closed O=Open P=Pending X=Canceled
15	ORDER_GRP	Character(6)	VARCHAR2(6) NOT NULL	Order Group
16	ORDER_DATE	Date(10)	DATE	Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
17	SOURCE_CD	Character(6)	VARCHAR2(6) NOT NULL	Source Code
18	ADDTL_ADJUST_BASE	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Adjustment Amount (base)
19	ADDTL_ADJUST_PCT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Adjustment %
20	ADDTL_ADJUST_AMT	Signed Number(29,4)	DECIMAL(27,4) NOT NULL	Adjustment Amount
21	DATETIME_ADDED	DateTime(26)	TIMESTAMP	DateTime Added