SAC_RCV_HD_V (SQL View)	Index Back
Recipt Header EIP Msg View Recipt Header EIP Msg View

SAC_RCV_HD_V

(SQL View)

Recipt Header EIP Msg 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.DRIVER_ID ,A.EIP_CTL_ID ,A.ERS_FLAG ,A.ERS_INV_DT_OPT ,A.ERS_INV_STATUS ,A.FREIGHT_TERMS ,A.HOLD_ASSET ,A.HOLD_INVENTORY ,A.IN_PROCESS_FLG ,A.INTFC_ASSET ,A.INTFC_INVENTORY ,A.INTFC_MG ,A.INVOICE_ID ,A.MATCH_CNTRL_ID ,A.MATCH_PROCESS_FLG ,A.MATCH_STATUS_RECV ,A.NUM_OF_CARTONS ,A.OPRID ,A.ORIGIN ,A.PALLETS_RECV ,A.PALLETS_RTN ,A.PO_RECEIPT_FLG ,A.PORT_OF_UNLOADING ,A.PRO_NUMBER ,A.PROCESS_INSTANCE ,A.RECEIPT_DT ,A.RECEIPT_TM ,A.RECV_SOURCE ,A.RECV_STATUS ,A.SETID ,A.SHIP_DATE ,A.SHIP_FROM_LOC ,A.SHIPMENT_NO ,A.SHIPTO_ID ,A.VEHICLE_ID ,A.VENDOR_ID ,A.VENDOR_SETID ,A.VNDR_LOC ,A.POST_STATUS_RECV ,%subrec(LAST_UPDATE_SBR, A) ,%subrec(PUR_USR_HDR_SBR, A) FROM PS_RECV_HDR A

# 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 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
Prompt Table: CARRIER_ID_VW

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).
Prompt Table: COUNTRY_TBL

7 DFLT_PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Default Packing Slip value

8 DRIVER_ID Character(10) VARCHAR2(10) NOT NULL Driver ID

9 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field

10 ERS_FLAG Character(1) VARCHAR2(1) NOT NULL Allow Eval Rcpt Settlement
Y/N Table Edit
Default Value: N

11 ERS_INV_DT_OPT Character(1) VARCHAR2(1) NOT NULL ERS Invoice Date Option
F=Frt Terms
R=Recv Date

12 ERS_INV_STATUS Character(1) VARCHAR2(1) NOT NULL ERS Invoice Status
I=Invoiced
N=Not Invoiced
P=Partially Invoiced
Default Value: N

13 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code
Prompt Table: FREIGHT_TERMS

14 HOLD_ASSET Character(1) VARCHAR2(1) NOT NULL Hold Assets
Y/N Table Edit
Default Value: N

15 HOLD_INVENTORY Character(1) VARCHAR2(1) NOT NULL Hold Inventory
Y/N Table Edit
Default Value: N

16 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
Y/N Table Edit
Default Value: N

17 INTFC_ASSET Character(1) VARCHAR2(1) NOT NULL Process Assets
Y/N Table Edit
Default Value: Y

18 INTFC_INVENTORY Character(1) VARCHAR2(1) NOT NULL Process Inventory
Y/N Table Edit
Default Value: Y

19 INTFC_MG Character(1) VARCHAR2(1) NOT NULL Process Manufacturing
Y/N Table Edit
Default Value: Y

20 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number

21 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
Prompt Table: MTCH_CNTRL

22 MATCH_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Match In Process
I=In Process
N=No
Default Value: N

23 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

24 NUM_OF_CARTONS Signed Number(12,0) DECIMAL(11) NOT NULL Nbr of Cartons

25 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

26 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
Default Value: OPR_DEF_TBL_PM.ORIGIN

27 PALLETS_RECV Signed Number(10,0) DECIMAL(9) NOT NULL Pallets Received

28 PALLETS_RTN Signed Number(10,0) DECIMAL(9) NOT NULL Pallets Returned

29 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

30 PORT_OF_UNLOADING Character(10) VARCHAR2(10) NOT NULL Port Of Unloading
Prompt Table: PORT_AIRPRT_VW3

31 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number

32 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

33 RECEIPT_DT Date(10) DATE NOT NULL Received Date
Default Value: %date

34 RECEIPT_TM Time(15) TIMESTAMP Receipt Time
Default Value: %time

35 RECV_SOURCE Character(1) VARCHAR2(1) NOT NULL Receive Source
1=On-line
2=ASN
3=Data Cllct
4=Mobile
Default Value: 1

36 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

37 SETID Character(5) VARCHAR2(5) NOT NULL SetID

38 SHIP_DATE Date(10) DATE Item Shipping Date

39 SHIP_FROM_LOC Character(10) VARCHAR2(10) NOT NULL Ship From Location
Prompt Table: SHIPFROM_RCV_VW

40 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number

41 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
Prompt Table: SHIPTO_VW

42 VEHICLE_ID Character(10) VARCHAR2(10) NOT NULL Vehicle ID

43 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
Prompt Table: VENDOR_POVW1

44 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

45 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
Prompt Table: VNDR_LOC_VW1

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

47 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.

48 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.

49 USER_HDR_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1

50 CUSTOM_C100_A1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1

51 CUSTOM_C100_A2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2

52 CUSTOM_C100_A3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3

53 CUSTOM_C100_A4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4

54 CUSTOM_DATE_A Date(10) DATE Custom Date

55 CUSTOM_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Character 2

#	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	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 Prompt Table: CARRIER_ID_VW
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). Prompt Table: COUNTRY_TBL
7	DFLT_PACKSLIP_NO	Character(22)	VARCHAR2(22) NOT NULL	Default Packing Slip value
8	DRIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Driver ID
9	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
10	ERS_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Allow Eval Rcpt Settlement Y/N Table Edit Default Value: N
11	ERS_INV_DT_OPT	Character(1)	VARCHAR2(1) NOT NULL	ERS Invoice Date Option F=Frt Terms R=Recv Date
12	ERS_INV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	ERS Invoice Status I=Invoiced N=Not Invoiced P=Partially Invoiced Default Value: N
13	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: FREIGHT_TERMS
14	HOLD_ASSET	Character(1)	VARCHAR2(1) NOT NULL	Hold Assets Y/N Table Edit Default Value: N
15	HOLD_INVENTORY	Character(1)	VARCHAR2(1) NOT NULL	Hold Inventory Y/N Table Edit Default Value: N
16	IN_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	In process flag Y/N Table Edit Default Value: N
17	INTFC_ASSET	Character(1)	VARCHAR2(1) NOT NULL	Process Assets Y/N Table Edit Default Value: Y
18	INTFC_INVENTORY	Character(1)	VARCHAR2(1) NOT NULL	Process Inventory Y/N Table Edit Default Value: Y
19	INTFC_MG	Character(1)	VARCHAR2(1) NOT NULL	Process Manufacturing Y/N Table Edit Default Value: Y
20	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
21	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule Prompt Table: MTCH_CNTRL
22	MATCH_PROCESS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Match In Process I=In Process N=No Default Value: N
23	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
24	NUM_OF_CARTONS	Signed Number(12,0)	DECIMAL(11) NOT NULL	Nbr of Cartons
25	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
26	ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Origin Default Value: OPR_DEF_TBL_PM.ORIGIN
27	PALLETS_RECV	Signed Number(10,0)	DECIMAL(9) NOT NULL	Pallets Received
28	PALLETS_RTN	Signed Number(10,0)	DECIMAL(9) NOT NULL	Pallets Returned
29	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
30	PORT_OF_UNLOADING	Character(10)	VARCHAR2(10) NOT NULL	Port Of Unloading Prompt Table: PORT_AIRPRT_VW3
31	PRO_NUMBER	Character(40)	VARCHAR2(40) NOT NULL	Pro Number
32	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
33	RECEIPT_DT	Date(10)	DATE NOT NULL	Received Date Default Value: %date
34	RECEIPT_TM	Time(15)	TIMESTAMP	Receipt Time Default Value: %time
35	RECV_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Receive Source 1=On-line 2=ASN 3=Data Cllct 4=Mobile Default Value: 1
36	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
37	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
38	SHIP_DATE	Date(10)	DATE	Item Shipping Date
39	SHIP_FROM_LOC	Character(10)	VARCHAR2(10) NOT NULL	Ship From Location Prompt Table: SHIPFROM_RCV_VW
40	SHIPMENT_NO	Character(30)	VARCHAR2(30) NOT NULL	Shipment Number
41	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location Prompt Table: SHIPTO_VW
42	VEHICLE_ID	Character(10)	VARCHAR2(10) NOT NULL	Vehicle ID
43	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier Prompt Table: VENDOR_POVW1
44	VENDOR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Vendor SetID
45	VNDR_LOC	Character(10)	VARCHAR2(10) NOT NULL	Vendor Location Prompt Table: VNDR_LOC_VW1
46	POST_STATUS_RECV	Character(1)	VARCHAR2(1) NOT NULL	Post Status Recv
47	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.
48	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.
49	USER_HDR_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
50	CUSTOM_C100_A1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
51	CUSTOM_C100_A2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
52	CUSTOM_C100_A3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
53	CUSTOM_C100_A4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
54	CUSTOM_DATE_A	Date(10)	DATE	Custom Date
55	CUSTOM_C1_A	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2