RO_GEN_ORDERS (SQL Table)	Index Back
Order Generator Orders Orders generated through the order generator.

RO_GEN_ORDERS

(SQL Table)

Order Generator Orders

Orders generated through the order generator.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RO_GENERATOR_ID Character(20) VARCHAR2(20) NOT NULL Unique key used by the Order Generator.

2 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

3 BO_ID_SOLD Number(31,0) DECIMAL(31) NOT NULL Sole To Business Object ID
Prompt Table: BO

4 RO_GEN_ORDER_TYPE Character(4) VARCHAR2(4) NOT NULL Available order types that can be used to generate orders.
LATE=Late Order
MSHP=Multiple Shipments
NOBL=No Bill To Customer
NOPR=No Products
NOSH=No Ship To Customer
NOSL=No Sold To Customer
REG=Regular Order

5 STATUS_CODE Number(5,0) INTEGER NOT NULL Status Code
Prompt Table: RO_DEFN_HDSTAT

6 RO_GEN_NBR_OF_PROD Number(4,0) SMALLINT NOT NULL Tracks the total number of products that were added to each order.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RO_GENERATOR_ID	Character(20)	VARCHAR2(20) NOT NULL	Unique key used by the Order Generator.
2	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
3	BO_ID_SOLD	Number(31,0)	DECIMAL(31) NOT NULL	Sole To Business Object ID Prompt Table: BO
4	RO_GEN_ORDER_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Available order types that can be used to generate orders. LATE=Late Order MSHP=Multiple Shipments NOBL=No Bill To Customer NOPR=No Products NOSH=No Ship To Customer NOSL=No Sold To Customer REG=Regular Order
5	STATUS_CODE	Number(5,0)	INTEGER NOT NULL	Status Code Prompt Table: RO_DEFN_HDSTAT
6	RO_GEN_NBR_OF_PROD	Number(4,0)	SMALLINT NOT NULL	Tracks the total number of products that were added to each order.