RECVHDR_DIAG_VW

(SQL View)
Index Back

SELECT BUSINESS_UNIT , RECEIVER_ID , DFLT_PACKSLIP_NO , ERS_FLAG , ERS_INV_DT_OPT , ERS_INV_STATUS , IN_PROCESS_FLG , MATCH_CNTRL_ID , MATCH_PROCESS_FLG , MATCH_STATUS_RECV , ORIGIN , PO_RECEIPT_FLG , PROCESS_INSTANCE , RECEIPT_DT , RECV_STATUS , VENDOR_ID , VENDOR_SETID , VNDR_LOC , POST_STATUS_RECV FROM PS_RECV_HDR

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

Default Value: OPR_DEF_TBL_PM.BUSINESS_UNIT_RECV

Prompt Table: SP_BU_PM_NONVW

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

Default Value: NEXT

3 DFLT_PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Default Packing Slip value
4 ERS_FLAG Character(1) VARCHAR2(1) NOT NULL Allow Eval Rcpt Settlement

Y/N Table Edit

Default Value: N

5 ERS_INV_DT_OPT Character(1) VARCHAR2(1) NOT NULL ERS Invoice Date Option
F=Frt Terms
R=Recv Date
6 ERS_INV_STATUS Character(1) VARCHAR2(1) NOT NULL ERS Invoice Status
I=Invoiced
N=Not Invoiced
P=Partially Invoiced

Default Value: N

7 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag

Y/N Table Edit

Default Value: N

8 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule

Prompt Table: MTCH_CNTRL

9 MATCH_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Match In Process
I=In Process
N=No

Default Value: N

10 MATCH_STATUS_RECV Character(1) VARCHAR2(1) NOT NULL Match Status
M=Matched
N=Not Matched
P=Partially Matched
T=To Match
V=Vouchered

Default Value: N

11 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

Default Value: OPR_DEF_TBL_PM.ORIGIN

12 PO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL PO Receipt Flag - identifies if the receipt is related to a purchase order

Y/N Table Edit

Default Value: Y

13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
14 RECEIPT_DT Date(10) DATE NOT NULL Received Date

Default Value: %date

15 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled

Default Value: O

16 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_POVW1

17 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
18 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

Prompt Table: VNDR_LOC_VW1

19 POST_STATUS_RECV Character(1) VARCHAR2(1) NOT NULL Post Status Recv