RO_GEN_ORD_TYPE (SQL Table)	Index Back
Order Generator Order Types Record to keep track of how many orders will be created for each order type.

RO_GEN_ORD_TYPE

(SQL Table)

Order Generator Order Types

Record to keep track of how many orders will be created for each order type.

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

3 RO_GEN_NBR_OF_ORDR Number(4,0) SMALLINT NOT NULL Tracks the total number of orders that were generated.

#	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	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
3	RO_GEN_NBR_OF_ORDR	Number(4,0)	SMALLINT NOT NULL	Tracks the total number of orders that were generated.