IN_KXPL_RC_AET (SQL Table)	Index Back
IN_KIT_EXPL run cntl state rec State record for IN_KIT_EXPL (Kit Re-Explode) App Engine library; holds copy of run control processing options

IN_KXPL_RC_AET

(SQL Table)

IN_KIT_EXPL run cntl state rec

State record for IN_KIT_EXPL (Kit Re-Explode) App Engine library; holds copy of run control processing options

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 SELECT_UNFULFILLED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state.
Y/N Table Edit

3 SELECT_RELEASABLE Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in a releasable state.
Y/N Table Edit

4 SELECT_RELEASED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in an Released state.
Y/N Table Edit

5 SELECT_CONFIRMED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in a confirmed state.
Y/N Table Edit

6 SELECT_DEPLETED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the RFID Tag Generation should include data in a Depleted state.
Y/N Table Edit

7 SELECT_SHIPPED Character(1) VARCHAR2(1) NOT NULL Indicates requests fed to the Fulfillment Engine should include data in an Picked state.
Y/N Table Edit

8 IN_KIT_EXPL_DATE Character(1) VARCHAR2(1) NOT NULL Kit Effective Date to be used by the Kit Re-Explode program
1=Schedule Date
2=Order Date
3=Ship Early Date
4=Today's Date

9 IN_KIT_EXEC_MODE Character(1) VARCHAR2(1) NOT NULL Execution Mode for the Kit Re-Explode program
1=Report and Re-Explode
2=Report Only

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SELECT_UNFULFILLED	Character(1)	VARCHAR2(1) NOT NULL	Indicates requests fed to the Fulfillment Engine should include data in an unfulfilled state. Y/N Table Edit
3	SELECT_RELEASABLE	Character(1)	VARCHAR2(1) NOT NULL	Indicates requests fed to the Fulfillment Engine should include data in a releasable state. Y/N Table Edit
4	SELECT_RELEASED	Character(1)	VARCHAR2(1) NOT NULL	Indicates requests fed to the Fulfillment Engine should include data in an Released state. Y/N Table Edit
5	SELECT_CONFIRMED	Character(1)	VARCHAR2(1) NOT NULL	Indicates requests fed to the Fulfillment Engine should include data in a confirmed state. Y/N Table Edit
6	SELECT_DEPLETED	Character(1)	VARCHAR2(1) NOT NULL	Indicates requests fed to the RFID Tag Generation should include data in a Depleted state. Y/N Table Edit
7	SELECT_SHIPPED	Character(1)	VARCHAR2(1) NOT NULL	Indicates requests fed to the Fulfillment Engine should include data in an Picked state. Y/N Table Edit
8	IN_KIT_EXPL_DATE	Character(1)	VARCHAR2(1) NOT NULL	Kit Effective Date to be used by the Kit Re-Explode program 1=Schedule Date 2=Order Date 3=Ship Early Date 4=Today's Date
9	IN_KIT_EXEC_MODE	Character(1)	VARCHAR2(1) NOT NULL	Execution Mode for the Kit Re-Explode program 1=Report and Re-Explode 2=Report Only