IN_RLS_NOTE_TAO (SQL Table)	Index Back
Order Release Demand Driver This table is used by the Report and Publishing components of the Order Release Process. These include the Pick Plan Report, Shipping Order Release Message, Extract File. This file is cleared at the end of that process along with IN_RLS_DPI_TMP

IN_RLS_NOTE_TAO

(SQL Table)

Order Release Demand Driver

This table is used by the Report and Publishing components of the Order Release Process. These include the Pick Plan Report, Shipping Order Release Message, Extract File. This file is cleared at the end of that process along with IN_RLS_DPI_TMP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PROCESSING_GROUP Number(10,0) DECIMAL(10) NOT NULL A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level.

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUIN_NONVW

4 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order

5 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
Prompt Table: SP_BU_FS_NONVW

6 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

7 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

8 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

9 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

10 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

11 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

12 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID

13 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number

14 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

15 ORD_NOTE_TYPE Character(1) VARCHAR2(1) NOT NULL Order Note Flag

16 STD_NOTE_CD Character(10) VARCHAR2(10) NOT NULL Standard Note Code

17 NOTE_TYPE Character(10) VARCHAR2(10) NOT NULL Note Type

18 DOCUMENT_CD Character(4) VARCHAR2(4) NOT NULL Document Code
ACKN=Order Acknowledgment
ASN=Advance Shipping Notification
BOL=Bill of Lading
CACK=Order Change Acknowledgement
CREN=Buying Agreement Renewal
CSTS=Buying Agreement Status
INCC=Invoice Courtesy Copy
INVC=Invoice
INVN=Invoice Notification
PACK=Packing List
PICK=Picking Plan
PPRC=Product Price List
PRAD=Payment Remittance Advice
QUOT=Quotation
RMA=Return Material Authorization

19 SETID_NOTE Character(5) VARCHAR2(5) NOT NULL SetID

20 IN_PICK_NOTE Character(1) VARCHAR2(1) NOT NULL Pick Plan Note
Y/N Table Edit
Default Value: N

21 IN_BOL_NOTE Character(1) VARCHAR2(1) NOT NULL Bill of Lading Note
Y/N Table Edit
Default Value: N

22 COMMENTS_2000 Long Character CLOB Comment Text

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PROCESSING_GROUP	Number(10,0)	DECIMAL(10) NOT NULL	A group of data to be processed which may be smaller than the group of data identified by the run request. When processing, if the Pass-through Level is greater than the specified Processing Level, the Processing Group should be expanded to include all data at the Pass-through Level.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUIN_NONVW
4	DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order
5	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit Prompt Table: SP_BU_FS_NONVW
6	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
7	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
8	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
9	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
10	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
11	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
12	PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID
13	PICKLIST_LINE_NO	Number(7,0)	INTEGER NOT NULL	Pick List Sorting Line Number
14	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
15	ORD_NOTE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Order Note Flag
16	STD_NOTE_CD	Character(10)	VARCHAR2(10) NOT NULL	Standard Note Code
17	NOTE_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Note Type
18	DOCUMENT_CD	Character(4)	VARCHAR2(4) NOT NULL	Document Code ACKN=Order Acknowledgment ASN=Advance Shipping Notification BOL=Bill of Lading CACK=Order Change Acknowledgement CREN=Buying Agreement Renewal CSTS=Buying Agreement Status INCC=Invoice Courtesy Copy INVC=Invoice INVN=Invoice Notification PACK=Packing List PICK=Picking Plan PPRC=Product Price List PRAD=Payment Remittance Advice QUOT=Quotation RMA=Return Material Authorization
19	SETID_NOTE	Character(5)	VARCHAR2(5) NOT NULL	SetID
20	IN_PICK_NOTE	Character(1)	VARCHAR2(1) NOT NULL	Pick Plan Note Y/N Table Edit Default Value: N
21	IN_BOL_NOTE	Character(1)	VARCHAR2(1) NOT NULL	Bill of Lading Note Y/N Table Edit Default Value: N
22	COMMENTS_2000	Long Character	CLOB	Comment Text