SAC_RCV_LN_SH_V (SQL View)	Index Back
Receipt Shipping Schedule EIP Receipt Shipping Schedule EIP Msg View

SAC_RCV_LN_SH_V

(SQL View)

Receipt Shipping Schedule EIP

Receipt Shipping Schedule EIP Msg View

SELECT A.BUSINESS_UNIT ,A.RECEIVER_ID ,A.RECV_LN_NBR ,A.RECV_SHIP_SEQ_NBR ,A.AMT_ONLY_FLG ,A.ASN_SEQ_NBR ,A.BILL_OF_LADING ,A.BUSINESS_UNIT_IN ,A.BUSINESS_UNIT_PO ,A.BUSINESS_UNIT_FROM ,A.BILL_OF_ENTRY ,A.BOE_LINE_NBR ,A.BOE_TYPE ,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 ,B.PRO_NUMBER ,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 LEFT OUTER JOIN PS_RECV_LN_PRO B ON (A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RECEIVER_ID = B.RECEIVER_ID AND A.RECV_LN_NBR = B.RECV_LN_NBR AND A.RECV_SHIP_SEQ_NBR = B.RECV_SHIP_SEQ_NBR)

# 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 AMT_ONLY_FLG Character(1) VARCHAR2(1) NOT NULL Amount Only
N=No
Y=Yes
Y/N Table Edit
Default Value: N

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

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

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

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

10 BUSINESS_UNIT_FROM Character(5) VARCHAR2(5) NOT NULL Business Unit From

11 BILL_OF_ENTRY Character(10) VARCHAR2(10) NOT NULL Bill of Entry ID

12 BOE_LINE_NBR Number(5,0) INTEGER NOT NULL Bill of Entry Line Number

13 BOE_TYPE Character(1) VARCHAR2(1) NOT NULL Bill Of Entry Type
1=Home Consumption
2=Warehousing
3=Ex-Bond

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

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

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

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

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

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

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

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

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

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

24 DEVICE_TRACKING Character(1) VARCHAR2(1) NOT NULL Device Tracking Indicator
Y/N Table Edit
Default Value: N

25 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity
Default Value: Q

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

27 DUE_TIME Time(15) TIMESTAMP Due Time

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

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

30 ERS_STATUS Character(1) VARCHAR2(1) NOT NULL ERS Status
I=Invoiced
N=Not Invoiced
Default Value: N

31 INSPECT_CD Character(1) VARCHAR2(1) NOT NULL Inspection Required
N=No
Y=Yes
Y/N Table Edit
Default Value: N

32 INSPECT_DTTM DateTime(26) TIMESTAMP Inspect DateTime

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

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

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

36 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
Default Value: I

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

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

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

40 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y
Y/N Table Edit
Default Value: N

41 LOT_STATUS Character(1) VARCHAR2(1) NOT NULL Lot Assigned Status
C=Complete
I=Incomplete
Default Value: I

42 MATCH_LINE_FLG Character(1) VARCHAR2(1) NOT NULL Line Level Match Flag
Y/N Table Edit
Default Value: Y

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

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

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

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

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

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

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

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

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

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

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

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

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

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

57 PO_TYPE Character(4) VARCHAR2(4) NOT NULL PO Type
GEN=General
KAN=Kanban
Default Value: GEN

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

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

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

61 PROCESS_COMPLETE Character(1) VARCHAR2(1) NOT NULL Process Complete
Y/N Table Edit
Default Value: N

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

83 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

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

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

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

87 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
Default Value: 1

88 RECEIPT_DTTM DateTime(26) TIMESTAMP Receipt Datetime

89 RECEIPT_UM Character(3) VARCHAR2(3) NOT NULL Receiving UOM
Default Value: EA
Prompt Table: UNITS_TBL

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

91 RECV_LN_MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Receipt Match Status
F=Matched
N=No Match
P=Partial
Default Value: N

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

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

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

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

96 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y
Y/N Table Edit
Default Value: N

97 SERIAL_STATUS Character(1) VARCHAR2(1) NOT NULL Serial Status
C=Complete
I=Incomplete
Default Value: I

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

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

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

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

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

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

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

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

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

107 CUSTOM_DATE_B Date(10) DATE Custom Date

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

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

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

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

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

113 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1

114 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2

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