IN_PAR_REPL_AET

(SQL Table)
Index Back

AET record for the par repln.

State record for Par replenishment application engine which invokes requisition loader process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 LOADER_BU Character(5) VARCHAR2(5) NOT NULL Requesting Loader Bus Unit
5 INV_CART_ID Character(15) VARCHAR2(15) NOT NULL Par Location ID
6 CART_COUNT_ID2 Character(10) VARCHAR2(10) NOT NULL Field to hole cart count id retrieved from par replenishment process
7 CART_COUNT_ID Number(10,0) DECIMAL(10) NOT NULL Par Location Count ID
8 RUN_CNTL_ID2 Character(30) VARCHAR2(30) NOT NULL Run Control ID
9 CART_OPTION Character(3) VARCHAR2(3) NOT NULL Par Location Option
01=All Par Locations for Unit
02=Specific Par Location for Unit
03=All for Par Location Group
04=All Par Locations
10 RETURN_CD Character(1) VARCHAR2(1) NOT NULL Return Code
0=Return OK
1=Return error