RPLN_INDMD_T

(SQL Table)
Index Back

# 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 SOFT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Soft Reserve
5 OFFSET_DAYS Number(4,0) SMALLINT NOT NULL The number of days to +/- from the current value date when forecasting.
6 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
7 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
8 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
9 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
10 QTY_DEMAND Number(16,4) DECIMAL(15,4) NOT NULL Qty Sourced from Demand