RECV_LN_SHIP_FS (SQL View)	Index Back
Receipt Schedule View Receipt Schedule View

RECV_LN_SHIP_FS

(SQL View)

Receipt Schedule 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 , BUSINESS_UNIT_FROM , BILL_OF_ENTRY , BOE_LINE_NBR , 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 , A.PRICE_RECV , 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.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.REJECT_ACTION , A.REJECT_REASON , A.REPLACEMENT_FLG , A.REVISION , A.RMA_ID , A.RMA_LINE_NBR , A.SCHED_NBR , A.SERIAL_CONTROL , A.SERIAL_STATUS , A.SHIP_DATE_STATUS , A.SHIP_QTY_STATUS , A.SHIPTO_ID , A.UNIT_MEASURE_STD , A.ORIG_INV_ITEM_ID , A.DESCR254_MIXED2 , A.PO_GROUP_ID , A.PRIMARY_UNIT , A.UNIT_ALLOC_QTY , A.UNIT_ALLOC_AMT , UPN_TYPE_CD , UPN_ID , %subrec(PUR_USR_LIN_SBR, A) , %subrec(PUR_USR_SHP_SBR, A) FROM PS_RECV_LN_SHIP A

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

17 CONVERT_TO_STK Signed Number(17,8) DECIMAL(15,8) NOT NULL Convert to Stock
Default Value: 1

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

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

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

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

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

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

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

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 PRICE_RECV Signed Number(17,5) DECIMAL(15,5) NOT NULL Price Per Receipt UOM

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

83 RECEIPT_DTTM DateTime(26) TIMESTAMP Receipt Datetime

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

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

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

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

88 RECV_STOCK_UOM Character(3) VARCHAR2(3) NOT NULL Stock UOM
Prompt Table: UNITS_TBL

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

90 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

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

92 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label

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

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

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 ORIG_INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Used to identify the original item ordered, in case an item substitution has taken place.

103 DESCR254_MIXED2 Character(254) VARCHAR2(254) NOT NULL Long Description

104 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID

105 PRIMARY_UNIT Character(1) VARCHAR2(1) NOT NULL Primary Unit
N=No
Y=Yes
Y/N Table Edit

106 UNIT_ALLOC_QTY Number(16,4) DECIMAL(15,4) NOT NULL Unit Allocation Qty

107 UNIT_ALLOC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unit Allocation Amt

108 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type

109 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number

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

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

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

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

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

115 CUSTOM_DATE_B Date(10) DATE Custom Date

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

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

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

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

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

121 CUSTOM_DATE_C1 Date(10) DATE Custom Date 1

122 CUSTOM_DATE_C2 Date(10) DATE Custom Date 2

123 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 Default Value: 1
17	CONVERT_TO_STK	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Convert to Stock Default Value: 1
18	CONVERT_TO_PO	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Convert to PO Default Value: 1
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
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
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
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
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 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
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
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	PRICE_RECV	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Price Per Receipt UOM
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	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
83	RECEIPT_DTTM	DateTime(26)	TIMESTAMP	Receipt Datetime
84	RECEIPT_UM	Character(3)	VARCHAR2(3) NOT NULL	Receiving UOM Default Value: EA Prompt Table: UNITS_TBL
85	RECEIVE_UOM	Character(3)	VARCHAR2(3) NOT NULL	Receipt Unit of Measure Prompt Table: UNITS_TBL
86	RECV_LN_MATCH_OPT	Character(1)	VARCHAR2(1) NOT NULL	Receipt Match Status F=Matched N=No Match P=Partial
87	RECV_SHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Receipt Schedule Status C=Closed H=Hold O=Open R=Received X=Canceled
88	RECV_STOCK_UOM	Character(3)	VARCHAR2(3) NOT NULL	Stock UOM Prompt Table: UNITS_TBL
89	REJECT_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Action On Rejection C=Return for Credit R=Return For Replacement
90	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
91	REPLACEMENT_FLG	Character(2)	VARCHAR2(2) NOT NULL	Replacement Flag NA=Not Applicable RN=Replace Goods Not Returned RR=Replacement of Returned Goods
92	REVISION	Character(4)	VARCHAR2(4) NOT NULL	01/27/2000 RML Added "As of" label
93	RMA_ID	Character(10)	VARCHAR2(10) NOT NULL	RMA Number
94	RMA_LINE_NBR	Number(5,0)	INTEGER NOT NULL	RMA Line Number
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	ORIG_INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Used to identify the original item ordered, in case an item substitution has taken place.
103	DESCR254_MIXED2	Character(254)	VARCHAR2(254) NOT NULL	Long Description
104	PO_GROUP_ID	Character(18)	VARCHAR2(18) NOT NULL	GroupID
105	PRIMARY_UNIT	Character(1)	VARCHAR2(1) NOT NULL	Primary Unit N=No Y=Yes Y/N Table Edit
106	UNIT_ALLOC_QTY	Number(16,4)	DECIMAL(15,4) NOT NULL	Unit Allocation Qty
107	UNIT_ALLOC_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unit Allocation Amt
108	UPN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Universal Product Number Format Type
109	UPN_ID	Character(20)	VARCHAR2(20) NOT NULL	Universal Product Number
110	USER_LINE_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
111	CUSTOM_C100_B1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
112	CUSTOM_C100_B2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
113	CUSTOM_C100_B3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
114	CUSTOM_C100_B4	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 4
115	CUSTOM_DATE_B	Date(10)	DATE	Custom Date
116	CUSTOM_C1_B	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2
117	USER_SCHED_CHAR1	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 1
118	CUSTOM_C100_C1	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 1
119	CUSTOM_C100_C2	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 2
120	CUSTOM_C100_C3	Character(100)	VARCHAR2(100) NOT NULL	Custom Field 3
121	CUSTOM_DATE_C1	Date(10)	DATE	Custom Date 1
122	CUSTOM_DATE_C2	Date(10)	DATE	Custom Date 2
123	CUSTOM_C1_C	Character(1)	VARCHAR2(1) NOT NULL	Custom Character 2