PL_OCAL_INS_AET

(SQL Table)
Index Back

PL Ship/Recv AET

09/14/01 EGS (CN#PL900-1): Added

# 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 SHIP_DAY Character(1) VARCHAR2(1) NOT NULL Day of Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
4 TIME_FROM Time(15) TIMESTAMP From Time
5 TIME_TO Time(15) TIMESTAMP To Time
6 ENTIRE_DAY Character(1) VARCHAR2(1) NOT NULL Entire Day

Y/N Table Edit

Default Value: N

7 USE_FOR_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Use for Shipments

Y/N Table Edit

Default Value: Y

8 USE_FOR_RECV_FLG Character(1) VARCHAR2(1) NOT NULL Use For Receiving

Y/N Table Edit

Default Value: Y