RTV_RECV_HDR_VW(SQL View) |
Index Back |
|---|---|
RTV Search Receipt Header View |
| SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.BILL_OF_LADING , A.CARRIER_ID , A.CONTAINER_ID , A.COUNTRY_SHIP_FROM , A.DFLT_PACKSLIP_NO , A.EIP_CTL_ID , A.ERS_INV_STATUS , A.HOLD_ASSET , A.HOLD_INVENTORY , A.IN_PROCESS_FLG , A.INTFC_ASSET , A.INTFC_INVENTORY , A.INTFC_MG , A.MATCH_PROCESS_FLG , A.MATCH_STATUS_RECV , A.OPRID , A.ORIGIN , A.PO_RECEIPT_FLG , A.PORT_OF_UNLOADING , A.PROCESS_INSTANCE , A.RECEIPT_DT , A.RECV_STATUS , A.SHIPMENT_NO , A.SHIPTO_ID , A.VENDOR_ID , A.VENDOR_SETID , A.VNDR_LOC , A.POST_STATUS_RECV , %subrec(LAST_UPDATE_SBR, A) FROM PS_RECV_HDR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT_RECV |
Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | BILL_OF_LADING | Character(30) | VARCHAR2(30) NOT NULL | Specifies a bill of lading number associated with a Receivables item. |
| 4 | CARRIER_ID | Character(10) | VARCHAR2(10) NOT NULL | Carrier ID |
| 5 | CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL | Container ID |
| 6 | COUNTRY_SHIP_FROM | Character(3) | VARCHAR2(3) NOT NULL | Specifies the country from which the invoice contents were shipped (for VAT processing only). |
| 7 | DFLT_PACKSLIP_NO | Character(22) | VARCHAR2(22) NOT NULL | Default Packing Slip value |
| 8 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 9 | ERS_INV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
ERS Invoice Status
I=Invoiced N=Not Invoiced P=Partially Invoiced |
| 10 | HOLD_ASSET | Character(1) | VARCHAR2(1) NOT NULL |
Hold Assets
Y/N Table Edit |
| 11 | HOLD_INVENTORY | Character(1) | VARCHAR2(1) NOT NULL |
Hold Inventory
Y/N Table Edit |
| 12 | IN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | In process flag |
| 13 | INTFC_ASSET | Character(1) | VARCHAR2(1) NOT NULL | Process Assets |
| 14 | INTFC_INVENTORY | Character(1) | VARCHAR2(1) NOT NULL | Process Inventory |
| 15 | INTFC_MG | Character(1) | VARCHAR2(1) NOT NULL | Process Manufacturing |
| 16 | MATCH_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Match In Process
I=In Process N=No |
| 17 | MATCH_STATUS_RECV | Character(1) | VARCHAR2(1) NOT NULL |
Match Status
M=Matched N=Not Matched P=Partially Matched T=To Match V=Vouchered |
| 18 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 19 | ORIGIN | Character(3) | VARCHAR2(3) NOT NULL | Origin |
| 20 | PO_RECEIPT_FLG | Character(1) | VARCHAR2(1) NOT NULL | PO Receipt Flag - identifies if the receipt is related to a purchase order |
| 21 | PORT_OF_UNLOADING | Character(10) | VARCHAR2(10) NOT NULL | Port Of Unloading |
| 22 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 23 | RECEIPT_DT | Date(10) | DATE | Received Date |
| 24 | 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 |
| 25 | SHIPMENT_NO | Character(30) | VARCHAR2(30) NOT NULL | Shipment Number |
| 26 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 27 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 28 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 29 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 30 | POST_STATUS_RECV | Character(1) | VARCHAR2(1) NOT NULL | Post Status Recv |
| 31 | OPRID_MODIFIED_BY | Character(30) | VARCHAR2(30) NOT NULL | Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase. |
| 32 | LAST_DTTM_UPDATE | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |