BUIN_SHEX_DT(SQL Table) |
Index Back |
|---|---|
Inv Ship Exception Date/TimeThis table is used to store the standing exception days and times that an Inventory Business Unit (warehouse) would not be open for shipping. It is consulted when users of the Order Management system are entering lines on orders to come up with a valid scheduled shipment date. No shipments would be scheduled on a date and time that was indicated as blocked on this table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_FS_NONVW |
| 2 | 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 |
| 3 | TIME_FROM |
Time(15) | TIMESTAMP NOT NULL | From Time |
| 4 | TIME_TO |
Time(15) | TIMESTAMP NOT NULL | To Time |
| 5 | ENTIRE_DAY | Character(1) | VARCHAR2(1) NOT NULL |
Entire Day
Y/N Table Edit Default Value: N |
| 6 | USE_FOR_SHIP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use for Shipments
Y/N Table Edit Default Value: Y |
| 7 | USE_FOR_RECV_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Use For Receiving
Y/N Table Edit Default Value: Y |
| 8 | USE_FOR_MATRL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Use for Materials
Y/N Table Edit Default Value: Y |