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 |