RECV_LN_INSP

(SQL Table)
Index Back

Inspection Operations (relsd)

Inspection Operations (relsd)

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

Default Value: RECV_LN_SHIP.BUSINESS_UNIT

2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

Default Value: RECV_LN_SHIP.RECEIVER_ID

3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 OP_SEQ Number(3,0) SMALLINT NOT NULL Op Seq
5 ROUTING_SETID Character(5) VARCHAR2(5) NOT NULL Routing SetID
6 ROUTING_ID Character(10) VARCHAR2(10) NOT NULL Inspection Routing ID

Prompt Table: ROUTING_HDR

7 OP_TIME_STD Number(6,2) DECIMAL(5,2) NOT NULL Standard Operation Run Time
8 OP_TIME_CD Character(1) VARCHAR2(1) NOT NULL Operation Time Type
O=Per Batch
P=Per Unit

Default Value: P

9 OP_TIME_STD_TTL Number(16,2) DECIMAL(15,2) NOT NULL Operation Time Std Total
10 OP_TIME_ACT_TTL Number(16,2) DECIMAL(15,2) NOT NULL Operation Time Actual Total
11 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
12 OP_INSTRUCTIONS Long Character CLOB Operation Instructions