DEMAND_CNSHP_VW (SQL View)	Index Back
Demand Cancel Ship View 08/30/04 tw Updated to use IN_DEMAND.

DEMAND_CNSHP_VW

(SQL View)

Demand Cancel Ship View

08/30/04 tw Updated to use IN_DEMAND.

SELECT A.BUSINESS_UNIT , A.DEMAND_SOURCE , A.SOURCE_BUS_UNIT , A.ORDER_NO , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.INV_ITEM_ID , A.DEMAND_LINE_NO , A.AUTO_TYPE , A.DEMAND_DATE , A.REQUEST_DATE , A.CANCEL_DTTM , %DatePart(A.SCHED_DTTM) , %TimePart(A.SCHED_DTTM) , %DatePart(A.ORIG_SCHED_DTTM) , %TimePart(A.ORIG_SCHED_DTTM) , A.SCHED_ARRV_DTTM , A.SHIP_ID , A.SHIP_LINE_NO , A.PICK_DTTM , A.ORIG_BU , A.DESTIN_BU , A.TRANSFER_YIELD , A.DATE_LAST_MAINT , A.LAST_MAINT_OPRID , A.SHIP_TYPE_ID , %DatePart(A.SHIP_EARLY_DTTM) , %TimePart(A.SHIP_EARLY_DTTM) , %DatePart(A.SHIP_LATE_DTTM) , %TimePart(A.SHIP_LATE_DTTM) , A.FREIGHT_TERMS , A.PRIORITY_NBR , A.DISTRIB_TYPE , A.PICK_BATCH_ID , A.PICKLIST_LINE_NO , A.REQ_ID , A.REQ_LINE_NBR , A.REQ_SCHED_NBR , A.REQ_DISTRIB_NBR , A.PRODUCT_ID , A.PARENT_PROD_ID , A.KIT_LINE_NBR , A.CNTRCT_ID , A.INTERUNIT_ID , A.INTERUNIT_FLG , A.INTERUNIT_STAT , A.INV_ITEM_ALIAS , A.PRICE_MARKUP_PCT , A.LOCATION , A.CUST_ID , A.CUST_NAME , A.SHIP_TO_CUST_ID , A.SHIP_CUST_NAME1 , A.SHIP_CUST_NAME2 , A.ADDRESS_SEQ_NUM , A.TAX_EXEMPT_FLG , A.EXP_RETURN_DATE , A.ORIG_OPRID , A.TRANSFER_COST , A.PACKAGING_CD , A.CURRENCY_CD , A.QTY_REQUESTED , A.QTY_REQUESTED_BASE , A.QTY_ALLOCATED , A.QTY_PICKED , A.QTY_BACKORDER , A.QTY_BACKORDER_BASE , A.QTY_SHIPPED , A.QTY_SHIP_BASE , A.QTY_SHIPPED_CONV , A.UNIT_MEASURE_SHIP , A.PRO_NUMBER , A.FULFILL_FLAG , A.RESERVE_STATUS , A.APPROVED_FLAG , A.SHIP_PRIOR_FLG , A.BCKORDR_CNCL_FLAG , A.BCKORDER_FLAG , A.CHARGE_FLAG , A.FERC_CD , A.QTY_ALLOC_BASE , A.CONFIRMED_FLAG , A.CHARGE_CODE , A.HARD_ALLOC_FLAG , A.LOT_ALLOC_FLG , A.LAST_PROCESS_INST , A.CUSTODIAN , A.PARTIAL_QTY_FLAG , A.PARTIAL_ORDER_FLAG , A.DEPLETE_INV_FLG , A.FROZEN_FLG , A.UNIT_OF_MEASURE , A.DT_TIMESTAMP , A.CONFIG_CODE , A.HOLD_FLAG , A.HOLD_CD , A.CARTON_PRINTED , A.SHIPPING_PRINTED , A.ROUTE_CD , A.ROUTE_STOP_NBR , A.PICK_RELEASE_ID , A.RESERVED_DTTM , A.BUDGET_DT , A.EXPORT , A.REPLACEMENT_FLG , A.IST_RETURN_FLG_IUT , A.IST_TXN_FLG , A.ORIG_INV_ITEM_ID , A.ORIG_UOM , A.ALLOW_SUB_ITEM_FLG , A.FRT_CHRG_OVERRIDE , A.FRT_CHRG_METHOD , A.FRT_RULE_CD , A.SHIP_ID_EST , A.NET_UNIT_PRICE , A.ALLOW_OVERPICK_FLG , A.MAX_PICK_TOLERANCE , A.BUSINESS_UNIT_PO , A.RTV_ID , A.RTV_LN_NBR , A.RTV_DISTRIB_NUM , %DatePart(A.SHIP_DTTM) , %TimePart(A.SHIP_DTTM) , A.LAST_QTY_SHIP , A.LAST_QTY_SHIP_BASE , A.SINGLE_SHIP_FLAG , A.EXT_REF_NBR , A.EXT_REF_LN_NBR , A.PUB_PROCESS_INST , A.TRANSFER_CALC_TYPE , A.IN_FULFILL_STATE , A.SCHED_DTTM , A.SHIP_DTTM , A.IN_PRIOR_STATE , A.IN_PROCESS_DATE , A.FSS_ACTIVITY_DT FROM PS_IN_DEMAND A WHERE A.IN_FULFILL_STATE >= '50'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUIN_NONVW

2 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order

3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit

4 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
Prompt Table: DEMAND_PICK_VW

5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line

6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number

7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
Prompt Table: MST_ITM_PRPT_VW

8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No

9 AUTO_TYPE Character(3) VARCHAR2(3) NOT NULL Number Type

10 DEMAND_DATE Date(10) DATE Demand Date

11 REQUEST_DATE Date(10) DATE Requested

12 CANCEL_DTTM DateTime(26) TIMESTAMP Dttm demand line was canceled

13 SCHED_DATE Date(10) DATE Schedule Date

14 SCHED_TIME Time(15) TIMESTAMP Schedule Time

15 ORIG_SCHED_DATE Date(10) DATE Orig Sched Date

16 ORIG_SCHED_TIME Time(15) TIMESTAMP Original Schedule Time

17 SCHED_ARRV_DTTM DateTime(26) TIMESTAMP Schedule Arrival Dt/Tm

18 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID

19 SHIP_LINE_NO Number(10,2) DECIMAL(9,2) NOT NULL Ship Line No

20 PICK_DTTM DateTime(26) TIMESTAMP Picked Date/Time

21 ORIG_BU Character(5) VARCHAR2(5) NOT NULL Original Business Unit

22 DESTIN_BU Character(5) VARCHAR2(5) NOT NULL Destination Unit

23 TRANSFER_YIELD Number(5,1) DECIMAL(4,1) NOT NULL Transfer Yield

24 DATE_LAST_MAINT Date(10) DATE Date Last Maintained

25 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID

26 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
Prompt Table: SHIP_METHOD

27 SHIP_EARLY_DATE Date(10) DATE Earliest Ship Date

28 SHIP_EARLY_TIME Time(15) TIMESTAMP Earliest Ship Time

29 SHIP_LATE_DATE Date(10) DATE Latest Ship Date

30 SHIP_LATE_TIME Time(15) TIMESTAMP Latest Ship Time

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

32 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

33 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type
Prompt Table: CM_DISTR_TYPE

34 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID

35 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number

36 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID

37 REQ_LINE_NBR Number(5,0) INTEGER NOT NULL Requisition Line Number

38 REQ_SCHED_NBR Number(3,0) SMALLINT NOT NULL Requisition Schedule Number

39 REQ_DISTRIB_NBR Number(5,0) INTEGER NOT NULL Requisition Distrib Number

40 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

41 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id

42 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number

43 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

44 INTERUNIT_ID Character(10) VARCHAR2(10) NOT NULL InterUnit Order ID

45 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes
Y/N Table Edit
Default Value: N

46 INTERUNIT_STAT Character(1) VARCHAR2(1) NOT NULL InterUnit Status
C=Cancelled
I=In-Transit
O=Open
P=Picked
R=Received

47 INV_ITEM_ALIAS Character(18) VARCHAR2(18) NOT NULL Item Alias

48 PRICE_MARKUP_PCT Signed Number(16,2) DECIMAL(14,2) NOT NULL Price Markup %

49 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

50 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

51 CUST_NAME Character(40) VARCHAR2(40) NOT NULL Name

52 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

53 SHIP_CUST_NAME1 Character(40) VARCHAR2(40) NOT NULL Ship To Name

54 SHIP_CUST_NAME2 Character(40) VARCHAR2(40) NOT NULL Ship To Name 2

55 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

56 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
Y/N Table Edit

57 EXP_RETURN_DATE Date(10) DATE Return Date

58 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

59 TRANSFER_COST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price

60 PACKAGING_CD Character(4) VARCHAR2(4) NOT NULL Packaging Code

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

62 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested

63 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base

64 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity

65 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked

66 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty

67 QTY_BACKORDER_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Base Qty

68 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped

69 QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Ship Base

70 QTY_SHIPPED_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped

71 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure

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

73 FULFILL_FLAG Character(1) VARCHAR2(1) NOT NULL OK to Pick
Default Value: N

74 RESERVE_STATUS Character(2) VARCHAR2(2) NOT NULL Reservation Status
10=Pending
11=Unreserved
12=Shortage, Rules Not Met
15=Reserved, Rules Not Met
21=Shortage, Line Rule Met
22=Reserved, Line Rule Met
31=Shortage, All Rules Met
32=Reserved, All Rules Met
40=Reserve Run
99=Invalid

75 APPROVED_FLAG Character(1) VARCHAR2(1) NOT NULL Approved
B=Both
N=No
Y=Yes
Default Value: N

76 SHIP_PRIOR_FLG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Sched Date
Y/N Table Edit

77 BCKORDR_CNCL_FLAG Character(1) VARCHAR2(1) NOT NULL Cancel Backorder
N=Cancel Backorder No
Y=Cancel Backorder Yes
Y/N Table Edit

78 BCKORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Backorder Flag
N=No
Y=Yes

79 CHARGE_FLAG Character(1) VARCHAR2(1) NOT NULL Charged Out
Y/N Table Edit

80 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code
Prompt Table: FERC_CD_TBL

81 QTY_ALLOC_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity allocation

82 CONFIRMED_FLAG Character(1) VARCHAR2(1) NOT NULL Confirm
Y/N Table Edit

83 CHARGE_CODE Character(20) VARCHAR2(20) NOT NULL Charge Code

84 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate
Y/N Table Edit

85 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation
Y/N Table Edit
Default Value: N

86 LAST_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance

87 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian

88 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship
Default Value: N

89 PARTIAL_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Orders Can Ship
N=No
Y=Yes
Default Value: N

90 DEPLETE_INV_FLG Character(1) VARCHAR2(1) NOT NULL Deplete Inventory Flag
Default Value: Y

91 FROZEN_FLG Character(1) VARCHAR2(1) NOT NULL Frozen Flag
B=Both
N=No
Y=Yes
Y/N Table Edit

92 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: INV_ORDR_UOM_VW

93 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

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

95 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold
Y/N Table Edit
Default Value: N

96 HOLD_CD Character(6) VARCHAR2(6) NOT NULL Hold Code
Prompt Table: HOLD_CD

97 CARTON_PRINTED Character(1) VARCHAR2(1) NOT NULL Carton Print Flag
Y/N Table Edit
Default Value: N

98 SHIPPING_PRINTED Character(1) VARCHAR2(1) NOT NULL Shipping Container Print Flag
Y/N Table Edit
Default Value: N

99 ROUTE_CD Character(6) VARCHAR2(6) NOT NULL A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.

100 ROUTE_STOP_NBR Number(5,0) INTEGER NOT NULL An identifier used to sequence customer addresses/location for a given route.

101 PICK_RELEASE_ID Number(10,0) DECIMAL(10) NOT NULL Pick Release ID

102 RESERVED_DTTM DateTime(26) TIMESTAMP Reserved Date/Time

103 BUDGET_DT Date(10) DATE Budget Date

104 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes
Y/N Table Edit
Default Value: N

105 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

106 IST_RETURN_FLG_IUT Character(1) VARCHAR2(1) NOT NULL Intrastat InterUnit Returns
Y/N Table Edit
Default Value: N

107 IST_TXN_FLG Character(1) VARCHAR2(1) NOT NULL Intrastat Transaction Flag
N=No
Y=Yes
Default Value: N

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

109 ORIG_UOM Character(3) VARCHAR2(3) NOT NULL Original Unit of Measure

110 ALLOW_SUB_ITEM_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether item substitutions are allowed on the order schedule.
Y/N Table Edit
Default Value: N

111 FRT_CHRG_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Freight Charge Override

112 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity

113 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code

114 SHIP_ID_EST Character(10) VARCHAR2(10) NOT NULL Estimated Ship ID

115 NET_UNIT_PRICE Signed Number(16,4) DECIMAL(14,4) NOT NULL Net Unit Price

116 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.

117 MAX_PICK_TOLERANCE Number(6,2) DECIMAL(5,2) NOT NULL Used to indicate the allowable percentage of overshipment for a customer or business unit.

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

119 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID

120 RTV_LN_NBR Number(5,0) INTEGER NOT NULL Return To Vendor Line

121 RTV_DISTRIB_NUM Number(5,0) INTEGER NOT NULL RTV Distribution Number

122 SHIP_DATE Date(10) DATE Item Shipping Date

123 SHIP_TIME Time(15) TIMESTAMP Ship Time

124 LAST_QTY_SHIP Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Last Shipped

125 LAST_QTY_SHIP_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Used to save the last value of quantity shipped from the Shipping Issues Panel in Standard UOM at the DEMAND_PHYS_INV and SHIP_INF_INV level. Default to the quantity picked from the Express Issues Panel or for cases where auto ship equals 'Y'.

126 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes

127 EXT_REF_NBR Number(10,0) DECIMAL(10) NOT NULL External Reference Number

128 EXT_REF_LN_NBR Number(5,0) INTEGER NOT NULL External Reference Line Number

129 PUB_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance

130 TRANSFER_CALC_TYPE Character(1) VARCHAR2(1) NOT NULL Holds information regarding when the transfer price is calculated.
0=Calculate Cost at Depletions
1=Transfer at Zero Cost
Default Value: 0

131 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled

132 SCHED_DTTM DateTime(26) TIMESTAMP 08/16/01 JNW (CN#PL900-1.0): Added

133 SHIP_DTTM DateTime(26) TIMESTAMP Ship Date/Time

134 IN_PRIOR_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State at the time the demand line was cancelled
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Picking Confirmed
60=Shipped
70=Depleted
90=Canceled

135 IN_PROCESS_DATE Date(10) DATE Process Date

136 FSS_ACTIVITY_DT Date(10) DATE EGS 03/02/06: Created

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUIN_NONVW
2	DEMAND_SOURCE	Character(2)	VARCHAR2(2) NOT NULL	Demand Source IN=Material Request OM=Sales Order PL=Planning Requisition PO=Purchase Order PR=Purchasing Requisition RT=Material Return SF=Production Request WM=Work Order
3	SOURCE_BUS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Source Bus Unit
4	ORDER_NO	Character(10)	VARCHAR2(10) NOT NULL	Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop Prompt Table: DEMAND_PICK_VW
5	ORDER_INT_LINE_NO	Number(5,0)	INTEGER NOT NULL	Order Line
6	SCHED_LINE_NBR	Number(6,0)	INTEGER NOT NULL	Schedule Line Number
7	INV_ITEM_ID	Character(18)	VARCHAR2(18) NOT NULL	Item ID Prompt Table: MST_ITM_PRPT_VW
8	DEMAND_LINE_NO	Number(4,0)	SMALLINT NOT NULL	Demand Line No
9	AUTO_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Number Type
10	DEMAND_DATE	Date(10)	DATE	Demand Date
11	REQUEST_DATE	Date(10)	DATE	Requested
12	CANCEL_DTTM	DateTime(26)	TIMESTAMP	Dttm demand line was canceled
13	SCHED_DATE	Date(10)	DATE	Schedule Date
14	SCHED_TIME	Time(15)	TIMESTAMP	Schedule Time
15	ORIG_SCHED_DATE	Date(10)	DATE	Orig Sched Date
16	ORIG_SCHED_TIME	Time(15)	TIMESTAMP	Original Schedule Time
17	SCHED_ARRV_DTTM	DateTime(26)	TIMESTAMP	Schedule Arrival Dt/Tm
18	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID
19	SHIP_LINE_NO	Number(10,2)	DECIMAL(9,2) NOT NULL	Ship Line No
20	PICK_DTTM	DateTime(26)	TIMESTAMP	Picked Date/Time
21	ORIG_BU	Character(5)	VARCHAR2(5) NOT NULL	Original Business Unit
22	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
23	TRANSFER_YIELD	Number(5,1)	DECIMAL(4,1) NOT NULL	Transfer Yield
24	DATE_LAST_MAINT	Date(10)	DATE	Date Last Maintained
25	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
26	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD
27	SHIP_EARLY_DATE	Date(10)	DATE	Earliest Ship Date
28	SHIP_EARLY_TIME	Time(15)	TIMESTAMP	Earliest Ship Time
29	SHIP_LATE_DATE	Date(10)	DATE	Latest Ship Date
30	SHIP_LATE_TIME	Time(15)	TIMESTAMP	Latest Ship Time
31	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: FREIGHT_TERMS
32	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
33	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type Prompt Table: CM_DISTR_TYPE
34	PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID
35	PICKLIST_LINE_NO	Number(7,0)	INTEGER NOT NULL	Pick List Sorting Line Number
36	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
37	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
38	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
39	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
40	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
41	PARENT_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Parent Product Id
42	KIT_LINE_NBR	Number(3,0)	SMALLINT NOT NULL	Kit Line Number
43	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
44	INTERUNIT_ID	Character(10)	VARCHAR2(10) NOT NULL	InterUnit Order ID
45	INTERUNIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	InterUnit N=No Y=Yes Y/N Table Edit Default Value: N
46	INTERUNIT_STAT	Character(1)	VARCHAR2(1) NOT NULL	InterUnit Status C=Cancelled I=In-Transit O=Open P=Picked R=Received
47	INV_ITEM_ALIAS	Character(18)	VARCHAR2(18) NOT NULL	Item Alias
48	PRICE_MARKUP_PCT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Price Markup %
49	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
50	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
51	CUST_NAME	Character(40)	VARCHAR2(40) NOT NULL	Name
52	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
53	SHIP_CUST_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name
54	SHIP_CUST_NAME2	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name 2
55	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
56	TAX_EXEMPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag Y/N Table Edit
57	EXP_RETURN_DATE	Date(10)	DATE	Return Date
58	ORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
59	TRANSFER_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Transfer Price
60	PACKAGING_CD	Character(4)	VARCHAR2(4) NOT NULL	Packaging Code
61	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
62	QTY_REQUESTED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested
63	QTY_REQUESTED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested Base
64	QTY_ALLOCATED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Allocated quantity
65	QTY_PICKED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Picked
66	QTY_BACKORDER	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Qty
67	QTY_BACKORDER_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Base Qty
68	QTY_SHIPPED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
69	QTY_SHIP_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Ship Base
70	QTY_SHIPPED_CONV	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
71	UNIT_MEASURE_SHIP	Character(3)	VARCHAR2(3) NOT NULL	Shipment Unit of Measure
72	PRO_NUMBER	Character(40)	VARCHAR2(40) NOT NULL	Pro Number
73	FULFILL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	OK to Pick Default Value: N
74	RESERVE_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Reservation Status 10=Pending 11=Unreserved 12=Shortage, Rules Not Met 15=Reserved, Rules Not Met 21=Shortage, Line Rule Met 22=Reserved, Line Rule Met 31=Shortage, All Rules Met 32=Reserved, All Rules Met 40=Reserve Run 99=Invalid
75	APPROVED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Approved B=Both N=No Y=Yes Default Value: N
76	SHIP_PRIOR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Ship Prior to Sched Date Y/N Table Edit
77	BCKORDR_CNCL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cancel Backorder N=Cancel Backorder No Y=Cancel Backorder Yes Y/N Table Edit
78	BCKORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Backorder Flag N=No Y=Yes
79	CHARGE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Charged Out Y/N Table Edit
80	FERC_CD	Character(10)	VARCHAR2(10) NOT NULL	FERC Code Prompt Table: FERC_CD_TBL
81	QTY_ALLOC_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity allocation
82	CONFIRMED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Confirm Y/N Table Edit
83	CHARGE_CODE	Character(20)	VARCHAR2(20) NOT NULL	Charge Code
84	HARD_ALLOC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hard Allocate Y/N Table Edit
85	LOT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow Lot Allocation Y/N Table Edit Default Value: N
86	LAST_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
87	CUSTODIAN	Character(30)	VARCHAR2(30) NOT NULL	Custodian
88	PARTIAL_QTY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Qtys Can Ship Default Value: N
89	PARTIAL_ORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Orders Can Ship N=No Y=Yes Default Value: N
90	DEPLETE_INV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Deplete Inventory Flag Default Value: Y
91	FROZEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Frozen Flag B=Both N=No Y=Yes Y/N Table Edit
92	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: INV_ORDR_UOM_VW
93	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
94	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
95	HOLD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hold N=Hold Y=Hold Y/N Table Edit Default Value: N
96	HOLD_CD	Character(6)	VARCHAR2(6) NOT NULL	Hold Code Prompt Table: HOLD_CD
97	CARTON_PRINTED	Character(1)	VARCHAR2(1) NOT NULL	Carton Print Flag Y/N Table Edit Default Value: N
98	SHIPPING_PRINTED	Character(1)	VARCHAR2(1) NOT NULL	Shipping Container Print Flag Y/N Table Edit Default Value: N
99	ROUTE_CD	Character(6)	VARCHAR2(6) NOT NULL	A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles.
100	ROUTE_STOP_NBR	Number(5,0)	INTEGER NOT NULL	An identifier used to sequence customer addresses/location for a given route.
101	PICK_RELEASE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Release ID
102	RESERVED_DTTM	DateTime(26)	TIMESTAMP	Reserved Date/Time
103	BUDGET_DT	Date(10)	DATE	Budget Date
104	EXPORT	Character(1)	VARCHAR2(1) NOT NULL	Export Analytic Instance N=No Y=Yes Y/N Table Edit Default Value: N
105	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
106	IST_RETURN_FLG_IUT	Character(1)	VARCHAR2(1) NOT NULL	Intrastat InterUnit Returns Y/N Table Edit Default Value: N
107	IST_TXN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Transaction Flag N=No Y=Yes Default Value: N
108	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.
109	ORIG_UOM	Character(3)	VARCHAR2(3) NOT NULL	Original Unit of Measure
110	ALLOW_SUB_ITEM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether item substitutions are allowed on the order schedule. Y/N Table Edit Default Value: N
111	FRT_CHRG_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Freight Charge Override
112	FRT_CHRG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Freight Charge Method 01=Order Value 02=Weight 03=Volume 04=Order Quantity
113	FRT_RULE_CD	Character(10)	VARCHAR2(10) NOT NULL	Freight Rule Code
114	SHIP_ID_EST	Character(10)	VARCHAR2(10) NOT NULL	Estimated Ship ID
115	NET_UNIT_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price
116	ALLOW_OVERPICK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether or not overpicking is allowed for a customer or business unit.
117	MAX_PICK_TOLERANCE	Number(6,2)	DECIMAL(5,2) NOT NULL	Used to indicate the allowable percentage of overshipment for a customer or business unit.
118	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
119	RTV_ID	Character(10)	VARCHAR2(10) NOT NULL	Return To Vendor ID
120	RTV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Return To Vendor Line
121	RTV_DISTRIB_NUM	Number(5,0)	INTEGER NOT NULL	RTV Distribution Number
122	SHIP_DATE	Date(10)	DATE	Item Shipping Date
123	SHIP_TIME	Time(15)	TIMESTAMP	Ship Time
124	LAST_QTY_SHIP	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Last Shipped
125	LAST_QTY_SHIP_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Used to save the last value of quantity shipped from the Shipping Issues Panel in Standard UOM at the DEMAND_PHYS_INV and SHIP_INF_INV level. Default to the quantity picked from the Express Issues Panel or for cases where auto ship equals 'Y'.
126	SINGLE_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Single Ship Flag N=No Y=Yes
127	EXT_REF_NBR	Number(10,0)	DECIMAL(10) NOT NULL	External Reference Number
128	EXT_REF_LN_NBR	Number(5,0)	INTEGER NOT NULL	External Reference Line Number
129	PUB_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
130	TRANSFER_CALC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Holds information regarding when the transfer price is calculated. 0=Calculate Cost at Depletions 1=Transfer at Zero Cost Default Value: 0
131	IN_FULFILL_STATE	Character(2)	VARCHAR2(2) NOT NULL	Inventory Fulfillment State 10=Pending 20=Unfulfilled 30=Releasable 40=Released 50=Confirmed 60=Shipped 70=Depleted 90=Canceled
132	SCHED_DTTM	DateTime(26)	TIMESTAMP	08/16/01 JNW (CN#PL900-1.0): Added
133	SHIP_DTTM	DateTime(26)	TIMESTAMP	Ship Date/Time
134	IN_PRIOR_STATE	Character(2)	VARCHAR2(2) NOT NULL	Inventory Fulfillment State at the time the demand line was cancelled 10=Pending 20=Unfulfilled 30=Releasable 40=Released 50=Picking Confirmed 60=Shipped 70=Depleted 90=Canceled
135	IN_PROCESS_DATE	Date(10)	DATE	Process Date
136	FSS_ACTIVITY_DT	Date(10)	DATE	EGS 03/02/06: Created