PL_BU_LOCK

(SQL Table)
Index Back

PL AE Post BU Locks

02/27/02 EGS (CN#PL900-1): Added

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BUIN_NONVW

2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 PROCESS_DTTM DateTime(26) TIMESTAMP Process Date Time
4 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process

Y/N Table Edit

5 LOCK_SO Character(1) VARCHAR2(1) NOT NULL 01/02/02 EGS (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

6 LOCK_QUO Character(1) VARCHAR2(1) NOT NULL 02/25/02 EGS (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

7 LOCK_BA Character(1) VARCHAR2(1) NOT NULL 05/02/02 JNW (CN#PL900-1): Added

Y/N Table Edit

Default Value: N

8 LOCK_PURCH Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

9 LOCK_PRDN Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

10 LOCK_PLNXFER Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

11 LOCK_PLNPUR Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

12 LOCK_PLNPRDN Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

13 LOCK_MSR Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

14 LOCK_XFER Character(1) VARCHAR2(1) NOT NULL 12/24/01 EGS (CN#PL900-1): Merry Christmas

Y/N Table Edit

Default Value: N

15 LOCK_USEUP Character(1) VARCHAR2(1) NOT NULL 10/29/02 EGS (CN#PL880-1): Added

Y/N Table Edit

Default Value: N