EM_RECV_LSHP_VW (SQL View)	Index Back
Receipt Shipping Schedule View Used by MarketPay

EM_RECV_LSHP_VW

(SQL View)

Receipt Shipping Schedule View

Used by MarketPay

SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , B.MATCH_STATUS_RECV , A.AMT_ONLY_FLG , A.ASN_SEQ_NBR , A.BILL_OF_LADING , A.BUSINESS_UNIT_IN , A.BUSINESS_UNIT_PO , A.CATEGORY_ID , A.CONFIG_CODE , A.CONVERSION_RATE , A.CONVERT_TO_STK , A.CONVERT_TO_PO , A.CONVERT_STK_TO_STD , A.COUNTRY_IST_ORIGIN , A.CURRENCY_CD , A.CURRENCY_CD_BASE , A.DESCR254_MIXED , A.DEVICE_TRACKING , A.DISTRIB_MTHD_FLG , A.DUE_DT , A.DUE_TIME , A.EIP_CTL_ID , A.ERS_INV_SEQ , A.ERS_STATUS , A.INSPECT_CD , A.INSPECT_DTTM , A.INSPECT_STATUS , A.INV_ITEM_ID , A.INVOICE_ID , A.IST_DISTRIB_STATUS , A.ITM_ID_VNDR , A.ITM_SETID , A.LINE_NBR , A.LOT_CONTROL , A.LOT_STATUS , A.MATCH_LINE_FLG , A.MATCH_STATUS_LC , A.MERCH_AMT_BSE , A.MERCH_AMT_PO_BSE , A.MERCHANDISE_AMT , A.MERCHANDISE_AMT_PO , A.MFG_ID , A.MFG_ITM_ID , A.MOVE_STAT_AM , A.MOVE_STAT_INV , A.MOVE_STAT_MFG , A.OP_SEQUENCE , A.OPRID , A.PACKSLIP_NO , A.PO_ID , A.PO_TYPE , A.PRICE_PO , A.PRICE_PO_BSE , A.PROCESS_COMPLETE , A.PROCESS_INSTANCE , A.PRODUCTION_ID , A.QTY_LN_ASSET_SUOM , A.QTY_LN_INV_SUOM , A.QTY_SH_ACCPT , A.QTY_SH_ACCPT_SUOM , A.QTY_SH_ACCPT_VUOM , A.QTY_SH_INSPD , A.QTY_SH_INSPD_SUOM , A.QTY_SH_INSPD_VUOM , A.QTY_SH_NETRCV_VUOM , A.QTY_SH_RECVD , A.QTY_SH_RECVD_SUOM , A.QTY_SH_RECVD_VUOM , A.QTY_SH_REJCT , A.QTY_SH_REJCT_SUOM , A.QTY_SH_REJCT_VUOM , A.QTY_SH_RTN , A.QTY_SH_RTN_SUOM , A.QTY_SH_RTN_VUOM , A.REJECT_ACTION , A.REJECT_REASON , A.REVISION , A.RMA_ID , A.RMA_LINE_NBR , A.RECEIPT_ALLOC_TYPE , A.RECEIPT_DTTM , A.RECEIPT_UM , A.RECEIVE_UOM , A.RECV_LN_MATCH_OPT , A.RECV_SHIP_STATUS , A.RECV_STOCK_UOM , A.REPLACEMENT_FLG , A.SCHED_NBR , A.SERIAL_CONTROL , A.SERIAL_STATUS , A.SHIP_DATE_STATUS , A.SHIP_QTY_STATUS , A.SHIPTO_ID , A.UNIT_MEASURE_STD , %subrec(PUR_USR_LIN_SBR, A) , %subrec(PUR_USR_SHP_SBR, A) FROM PS_RECV_LN_SHIP A , PS_RECV_HDR B WHERE %Join(COMMON_KEYS, RECV_LN_SHIP A, RECV_HDR B)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line

4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence

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

6 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes
Y/N Table Edit

7 ASN_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL ASR Key sequence number

8 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.

9 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

10 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

11 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID

12 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

13 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate

14 CONVERT_TO_STK Signed Number(17,8) DECIMAL(15,8) NOT NULL Convert to Stock

15 CONVERT_TO_PO Signed Number(17,8) DECIMAL(15,8) NOT NULL Convert to PO

16 CONVERT_STK_TO_STD Signed Number(17,8) DECIMAL(15,8) NOT NULL Convert Stock To Standard

17 COUNTRY_IST_ORIGIN Character(3) VARCHAR2(3) NOT NULL Intrastat Country of Origin
Prompt Table: COUNTRY_TBL

18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

19 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

20 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description

21 DEVICE_TRACKING Character(1) VARCHAR2(1) NOT NULL Device Tracking Indicator
Y/N Table Edit

22 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity

23 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.

24 DUE_TIME Time(15) TIMESTAMP Due Time

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

26 ERS_INV_SEQ Number(5,0) INTEGER NOT NULL ERS Invoice Sequence

27 ERS_STATUS Character(1) VARCHAR2(1) NOT NULL ERS Status
I=Invoiced
N=Not Invoiced

28 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=No
Y=Yes
Y/N Table Edit

29 INSPECT_DTTM DateTime(26) TIMESTAMP Inspect DateTime

30 INSPECT_STATUS Character(1) VARCHAR2(1) NOT NULL Inspection Status
C=Complete
I=Incomplete

31 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: ITM_PURCH_VW

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

33 IST_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL Intrastat Distribution Status
A=Awaiting Arrival Processing
D=Distributed
I=Ignored
M=Archival Entry
N=Not Distributed
R=Reversal Entry
S=Awaiting Dispatch Processing
U=Undefined

34 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID

35 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID

36 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

37 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y

38 LOT_STATUS Character(1) VARCHAR2(1) NOT NULL Lot Assigned Status
C=Complete
I=Incomplete

39 MATCH_LINE_FLG Character(1) VARCHAR2(1) NOT NULL Line Level Match Flag
Y/N Table Edit

40 MATCH_STATUS_LC Number(1,0) SMALLINT NOT NULL 03/14/99 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement

41 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount

42 MERCH_AMT_PO_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt PO Base

43 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label

44 MERCHANDISE_AMT_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Merchandise Amount

45 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

46 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

47 MOVE_STAT_AM Character(1) VARCHAR2(1) NOT NULL AM Move Status
M=Moved
N=N/A
P=Pending

48 MOVE_STAT_INV Character(1) VARCHAR2(1) NOT NULL MOVE_STAT_INV
M=Moved
N=N/A
P=Pending

49 MOVE_STAT_MFG Character(1) VARCHAR2(1) NOT NULL Mfg Move Status
M=Moved
N=N/A
P=Pending

50 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

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

52 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number

53 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

54 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban

55 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price

56 PRICE_PO_BSE Signed Number(17,5) DECIMAL(15,5) NOT NULL Price Base

57 PROCESS_COMPLETE Character(1) VARCHAR2(1) NOT NULL Process Complete
Y/N Table Edit

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

59 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

60 QTY_LN_ASSET_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Quantity to be Asset Tracked

61 QTY_LN_INV_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Line Inv Qty

62 QTY_SH_ACCPT Number(16,4) DECIMAL(15,4) NOT NULL Qty Accepted in Receipt UOM

63 QTY_SH_ACCPT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Accepted Quantity

64 QTY_SH_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Accept QTY in Supplier UOM

65 QTY_SH_INSPD Number(16,4) DECIMAL(15,4) NOT NULL Qty Inspected in Receipt UOM

66 QTY_SH_INSPD_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Inspected Quantity

67 QTY_SH_INSPD_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Inspected Qty in Supplier UOM

68 QTY_SH_NETRCV_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Net Receipt Quantity

69 QTY_SH_RECVD Number(16,4) DECIMAL(15,4) NOT NULL F_KDHIL_R87H8 062804 MLM: Added new Line Quantity Received Label

70 QTY_SH_RECVD_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Receipt Quantity

71 QTY_SH_RECVD_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Receipt QTY in Supplier UOM

72 QTY_SH_REJCT Number(16,4) DECIMAL(15,4) NOT NULL Qty Rejected in Receipt UOM

73 QTY_SH_REJCT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Rejected Quantity

74 QTY_SH_REJCT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Reject QTY in Supplier UOM

75 QTY_SH_RTN Number(16,4) DECIMAL(15,4) NOT NULL Qty Returned in Receipt UOM

76 QTY_SH_RTN_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Qty Returned in Std UOM

77 QTY_SH_RTN_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Qty Returned in PO UOM

78 REJECT_ACTION Character(1) VARCHAR2(1) NOT NULL Action On Rejection
C=Return for Credit
R=Return For Replacement

79 REJECT_REASON Character(10) VARCHAR2(10) NOT NULL Reject Reason Code
DAM=Damaged Goods
FAL=Failed Inspection
INC=Incomplete Shipment
LAT=Late Shipment
RLY=Early Shipment
WRG=Wrong Goods or Service
Prompt Table: REJECT_REASONS

80 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
Prompt Table: EN_REV_PO_VW

81 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number

82 RMA_LINE_NBR Number(5,0) INTEGER NOT NULL RMA Line Number

83 RECEIPT_ALLOC_TYPE Character(1) VARCHAR2(1) NOT NULL F-KDHIL-R87H8 060304 MLM: Added Specify Allocation Type translate value to allow manual allocations for receiving related enhancements.
1=First In First Out
2=Prorate
3=Specify
4=Split Distributions

84 RECEIPT_DTTM DateTime(26) TIMESTAMP Receipt Datetime

85 RECEIPT_UM Character(3) VARCHAR2(3) NOT NULL Receiving UOM
Prompt Table: UNITS_TBL

86 RECEIVE_UOM Character(3) VARCHAR2(3) NOT NULL Receipt Unit of Measure
Prompt Table: UNITS_TBL

87 RECV_LN_MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Receipt Match Status
F=Matched
N=No Match
P=Partial

88 RECV_SHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Schedule Status
C=Closed
H=Hold
O=Open
R=Received
X=Canceled

89 RECV_STOCK_UOM Character(3) VARCHAR2(3) NOT NULL Stock UOM
Prompt Table: RECV_STK_UOM_VW

90 REPLACEMENT_FLG Character(2) VARCHAR2(2) NOT NULL Replacement Flag
NA=Not Applicable
RN=Replace Goods Not Returned
RR=Replacement of Returned Goods

91 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number

92 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y
Y/N Table Edit

93 SERIAL_STATUS Character(1) VARCHAR2(1) NOT NULL Serial Status
C=Complete
I=Incomplete

94 SHIP_DATE_STATUS Character(1) VARCHAR2(1) NOT NULL Ship Date Status
1=Passes Date Check
2=Early Shipment
3=Late Shipment

95 SHIP_QTY_STATUS Character(1) VARCHAR2(1) NOT NULL Quantity Status
1=Passes Quantity Check
2=Over Shipment
3=Under Shipment

96 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

97 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure

98 USER_LINE_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1

99 CUSTOM_C100_B1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1

100 CUSTOM_C100_B2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2

101 CUSTOM_C100_B3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3

102 CUSTOM_C100_B4 Character(100) VARCHAR2(100) NOT NULL Custom Field 4

103 CUSTOM_DATE_B Date(10) DATE Custom Date

104 CUSTOM_C1_B Character(1) VARCHAR2(1) NOT NULL Custom Character 2

105 USER_SCHED_CHAR1 Character(1) VARCHAR2(1) NOT NULL Custom Character 1

106 CUSTOM_C100_C1 Character(100) VARCHAR2(100) NOT NULL Custom Field 1

107 CUSTOM_C100_C2 Character(100) VARCHAR2(100) NOT NULL Custom Field 2

108 CUSTOM_C100_C3 Character(100) VARCHAR2(100) NOT NULL Custom Field 3

109 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1

110 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2

111 CUSTOM_C1_C 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
2	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
3	RECV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Receipt Line
4	RECV_SHIP_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Receiver Shipping Sequence
5	MATCH_STATUS_RECV	Character(1)	VARCHAR2(1) NOT NULL	Match Status M=Matched N=Not Matched P=Partially Matched T=To Match V=Vouchered
6	AMT_ONLY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Amount Only N=No Y=Yes Y/N Table Edit
7	ASN_SEQ_NBR	Number(9,0)	DECIMAL(9) NOT NULL	ASR Key sequence number
8	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
9	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit
10	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
11	CATEGORY_ID	Character(5)	VARCHAR2(5) NOT NULL	Category ID
12	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
13	CONVERSION_RATE	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Conversion Rate
14	CONVERT_TO_STK	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Convert to Stock
15	CONVERT_TO_PO	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Convert to PO
16	CONVERT_STK_TO_STD	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Convert Stock To Standard
17	COUNTRY_IST_ORIGIN	Character(3)	VARCHAR2(3) NOT NULL	Intrastat Country of Origin Prompt Table: COUNTRY_TBL
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
19	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
20	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
21	DEVICE_TRACKING	Character(1)	VARCHAR2(1) NOT NULL	Device Tracking Indicator Y/N Table Edit
22	DISTRIB_MTHD_FLG	Character(1)	VARCHAR2(1) NOT NULL	Distribute by A=Amount Q=Quantity
23	DUE_DT	Date(10)	DATE	Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
24	DUE_TIME	Time(15)	TIMESTAMP	Due Time
25	EIP_CTL_ID	Character(25)	VARCHAR2(25) NOT NULL	Enterprise Components EIP (enterprise integration point) control field
26	ERS_INV_SEQ	Number(5,0)	INTEGER NOT NULL	ERS Invoice Sequence
27	ERS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	ERS Status I=Invoiced N=Not Invoiced
28	INSPECT_CD	Character(1)	VARCHAR2(1) NOT NULL	Inspection Required N=No Y=Yes Y/N Table Edit
29	INSPECT_DTTM	DateTime(26)	TIMESTAMP	Inspect DateTime
30	INSPECT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Inspection Status C=Complete I=Incomplete
31	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: ITM_PURCH_VW
32	INVOICE_ID	Character(30)	VARCHAR2(30) NOT NULL	Invoice Number
33	IST_DISTRIB_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Distribution Status A=Awaiting Arrival Processing D=Distributed I=Ignored M=Archival Entry N=Not Distributed R=Reversal Entry S=Awaiting Dispatch Processing U=Undefined
34	ITM_ID_VNDR	Character(50)	VARCHAR2(50) NOT NULL	Vendor Item ID
35	ITM_SETID	Character(5)	VARCHAR2(5) NOT NULL	Item SetID
36	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
37	LOT_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Lot Control N=N Y=Y
38	LOT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Lot Assigned Status C=Complete I=Incomplete
39	MATCH_LINE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Line Level Match Flag Y/N Table Edit
40	MATCH_STATUS_LC	Number(1,0)	SMALLINT NOT NULL	03/14/99 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
41	MERCH_AMT_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Base Merchandise Amount
42	MERCH_AMT_PO_BSE	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt PO Base
43	MERCHANDISE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
44	MERCHANDISE_AMT_PO	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	PO Merchandise Amount
45	MFG_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer ID
46	MFG_ITM_ID	Character(50)	VARCHAR2(50) NOT NULL	Manufacturer's Item ID
47	MOVE_STAT_AM	Character(1)	VARCHAR2(1) NOT NULL	AM Move Status M=Moved N=N/A P=Pending
48	MOVE_STAT_INV	Character(1)	VARCHAR2(1) NOT NULL	MOVE_STAT_INV M=Moved N=N/A P=Pending
49	MOVE_STAT_MFG	Character(1)	VARCHAR2(1) NOT NULL	Mfg Move Status M=Moved N=N/A P=Pending
50	OP_SEQUENCE	Number(4,0)	SMALLINT NOT NULL	Operation Sequence
51	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
52	PACKSLIP_NO	Character(22)	VARCHAR2(22) NOT NULL	Packing Slip Number
53	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
54	PO_TYPE	Character(4)	VARCHAR2(4) NOT NULL	PO Type GEN=General KAN=Kanban
55	PRICE_PO	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Purchase Order Price
56	PRICE_PO_BSE	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Price Base
57	PROCESS_COMPLETE	Character(1)	VARCHAR2(1) NOT NULL	Process Complete Y/N Table Edit
58	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
59	PRODUCTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Production ID
60	QTY_LN_ASSET_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Quantity to be Asset Tracked
61	QTY_LN_INV_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Line Inv Qty
62	QTY_SH_ACCPT	Number(16,4)	DECIMAL(15,4) NOT NULL	Qty Accepted in Receipt UOM
63	QTY_SH_ACCPT_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Accepted Quantity
64	QTY_SH_ACCPT_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Accept QTY in Supplier UOM
65	QTY_SH_INSPD	Number(16,4)	DECIMAL(15,4) NOT NULL	Qty Inspected in Receipt UOM
66	QTY_SH_INSPD_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Inspected Quantity
67	QTY_SH_INSPD_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Inspected Qty in Supplier UOM
68	QTY_SH_NETRCV_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Net Receipt Quantity
69	QTY_SH_RECVD	Number(16,4)	DECIMAL(15,4) NOT NULL	F_KDHIL_R87H8 062804 MLM: Added new Line Quantity Received Label
70	QTY_SH_RECVD_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Receipt Quantity
71	QTY_SH_RECVD_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Receipt QTY in Supplier UOM
72	QTY_SH_REJCT	Number(16,4)	DECIMAL(15,4) NOT NULL	Qty Rejected in Receipt UOM
73	QTY_SH_REJCT_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Rejected Quantity
74	QTY_SH_REJCT_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Reject QTY in Supplier UOM
75	QTY_SH_RTN	Number(16,4)	DECIMAL(15,4) NOT NULL	Qty Returned in Receipt UOM
76	QTY_SH_RTN_SUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Qty Returned in Std UOM
77	QTY_SH_RTN_VUOM	Number(16,4)	DECIMAL(15,4) NOT NULL	Qty Returned in PO UOM
78	REJECT_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Action On Rejection C=Return for Credit R=Return For Replacement
79	REJECT_REASON	Character(10)	VARCHAR2(10) NOT NULL	Reject Reason Code DAM=Damaged Goods FAL=Failed Inspection INC=Incomplete Shipment LAT=Late Shipment RLY=Early Shipment WRG=Wrong Goods or Service Prompt Table: REJECT_REASONS
80	REVISION	Character(4)	VARCHAR2(4) NOT NULL	01/27/2000 RML Added "As of" label Prompt Table: EN_REV_PO_VW
81	RMA_ID	Character(10)	VARCHAR2(10) NOT NULL	RMA Number
82	RMA_LINE_NBR	Number(5,0)	INTEGER NOT NULL	RMA Line Number
83	RECEIPT_ALLOC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	F-KDHIL-R87H8 060304 MLM: Added Specify Allocation Type translate value to allow manual allocations for receiving related enhancements. 1=First In First Out 2=Prorate 3=Specify 4=Split Distributions
84	RECEIPT_DTTM	DateTime(26)	TIMESTAMP	Receipt Datetime
85	RECEIPT_UM	Character(3)	VARCHAR2(3) NOT NULL	Receiving UOM Prompt Table: UNITS_TBL
86	RECEIVE_UOM	Character(3)	VARCHAR2(3) NOT NULL	Receipt Unit of Measure Prompt Table: UNITS_TBL
87	RECV_LN_MATCH_OPT	Character(1)	VARCHAR2(1) NOT NULL	Receipt Match Status F=Matched N=No Match P=Partial
88	RECV_SHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Receipt Schedule Status C=Closed H=Hold O=Open R=Received X=Canceled
89	RECV_STOCK_UOM	Character(3)	VARCHAR2(3) NOT NULL	Stock UOM Prompt Table: RECV_STK_UOM_VW
90	REPLACEMENT_FLG	Character(2)	VARCHAR2(2) NOT NULL	Replacement Flag NA=Not Applicable RN=Replace Goods Not Returned RR=Replacement of Returned Goods
91	SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Schedule Number
92	SERIAL_CONTROL	Character(1)	VARCHAR2(1) NOT NULL	Serial Control N=N Y=Y Y/N Table Edit
93	SERIAL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Serial Status C=Complete I=Incomplete
94	SHIP_DATE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Ship Date Status 1=Passes Date Check 2=Early Shipment 3=Late Shipment
95	SHIP_QTY_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Quantity Status 1=Passes Quantity Check 2=Over Shipment 3=Under Shipment
96	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
97	UNIT_MEASURE_STD	Character(3)	VARCHAR2(3) NOT NULL	Standard Unit of Measure
98	USER_LINE_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
99	CUSTOM_C100_B1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
100	CUSTOM_C100_B2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
101	CUSTOM_C100_B3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
102	CUSTOM_C100_B4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
103	CUSTOM_DATE_B	Date(10)	DATE	Custom Date
104	CUSTOM_C1_B	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
105	USER_SCHED_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
106	CUSTOM_C100_C1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
107	CUSTOM_C100_C2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
108	CUSTOM_C100_C3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
109	CUSTOM_DATE_C1	Date(10)	DATE	Custom Date 1
110	CUSTOM_DATE_C2	Date(10)	DATE	Custom Date 2
111	CUSTOM_C1_C	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2