SCON_CREATE_TMP (SQL Table)	Index Back
Create Sales Order Temp Table Date Initials Issue Description 100201 dms R-ANAKIS-XB34M Add order_int_line_no, remove sched_line_nbr

SCON_CREATE_TMP

(SQL Table)

Create Sales Order Temp Table

Date Initials Issue Description 100201 dms R-ANAKIS-XB34M Add order_int_line_no, remove sched_line_nbr

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 REQ_ARRIVAL_DATE Date(10) DATE NOT NULL Requested Arrival Date

2 REQ_ARRIVAL_TIME Time(15) TIMESTAMP Requested Arrival Time

3 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer
Prompt Table: CUST_SLDSHP_VW

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

5 QTY_RELEASE Number(16,4) DECIMAL(15,4) NOT NULL Release Quantity

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REQ_ARRIVAL_DATE	Date(10)	DATE NOT NULL	Requested Arrival Date
2	REQ_ARRIVAL_TIME	Time(15)	TIMESTAMP	Requested Arrival Time
3	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer Prompt Table: CUST_SLDSHP_VW
4	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
5	QTY_RELEASE	Number(16,4)	DECIMAL(15,4) NOT NULL	Release Quantity