IN_EST_SHIP_VW4 (SQL View)	Index Back
Shipping Detail - View

IN_EST_SHIP_VW4

(SQL View)

Shipping Detail - View

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 , %DatePart(a.orig_sched_dttm) , %TimePart(a.orig_sched_dttm) , a.ship_id , a.ship_line_no , %DatePart(a.sched_dttm) , %TimePart(a.sched_dttm) , %DatePart(a.pick_dttm) , a.orig_bu , %DatePart(a.ship_dttm) , %TimePart(a.ship_dttm) , a.sched_arrv_dttm , %DatePart(a.cancel_dttm) , a.product_id , a.parent_prod_id , a.kit_line_nbr , 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.req_id , a.req_line_nbr , a.req_sched_nbr , a.req_distrib_nbr , a.charge_flag , a.cntrct_id , a.ferc_cd , a.inv_item_alias , a.tax_exempt_flg , a.exp_return_date , a.orig_oprid , a.packaging_cd , a.currency_cd , a.qty_requested , a.qty_requested_base , a.qty_allocated , a.qty_alloc_base , a.qty_picked , a.qty_shipped , a.qty_shipped_conv , a.qty_pick_base , a.qty_ship_base , a.last_qty_ship , a.last_qty_ship_base , a.qty_backorder , a.qty_backorder_base , a.fulfill_flag , a.hard_alloc_flag , a.approved_flag , a.transfer_cost , a.price_markup_pct , a.interunit_flg , a.interunit_id , a.interunit_line , a.interunit_stat , a.destin_bu , a.shipped_message , a.qty_verify_msg , 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 , %subrec(ADDRESS_SBR, adr) , a.unit_measure_wt , a.unit_measure_vol , a.unit_measure_ship , a.unit_of_measure , a.ship_uom_conv_flag , a.ship_prior_flg , a.partial_qty_flag , a.partial_order_flag , a.bckordr_cncl_flag , a.bckorder_flag , a.frozen_flg , a.custodian , a.charge_code , a.lot_alloc_flg , a.date_last_maint , a.last_maint_oprid , a.dt_timestamp , a.deplete_inv_flg , a.business_unit_bi , a.config_code , a.bill_of_lading , a.carrier_id , a.load_id , a.pro_number , a.pick_batch_id , a.picklist_line_no , a.direct_invoicing , a.backorder_created , a.business_unit_po , a.rtv_id , a.rtv_ln_nbr , a.rtv_distrib_num , a.price_po , a.hold_flag , a.ist_distrib_status , a.ship_short_wf_done , a.currency_cd_dest , a.tax_cd_vat , a.transfer_cost_dest , a.transfer_yield , a.vat_txn_type_cd , a.vat_applicability , a.route_cd , a.route_stop_nbr , a.pick_release_id , %DatePart(a.reserved_dttm) , %DatePart(a.depleted_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 , adr.cust_contact , a.allow_overpick_flg , a.max_pick_tolerance , a.qty_pack_base , b.freight_vendor , 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 FROM PS_IN_DEMAND A LEFT OUTER JOIN PS_IN_DEMAND_ADDR adr ON %Join(common_keys, in_demand a , in_demand_addr adr) , ps_carrier_id b WHERE ((a.in_fulfill_state BETWEEN '50' AND '60') OR (A.in_fulfill_state = '70' AND omb_process_date IS NOT NULL)) AND a.carrier_id = b.carrier_id AND A.DEMAND_SOURCE='OM' AND b.setid = ( SELECT c.setid FROM ps_set_cntrl_rec c WHERE c.setcntrlvalue = a.business_unit AND c.recname = 'CARRIER_ID') AND b.effdt=( SELECT MAX(effdt) FROM ps_carrier_id WHERE b.setid=setid AND b.carrier_id=carrier_id AND effdt<=%CurrentDateIn) AND b.eff_status='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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 ORIG_SCHED_DATE Date(10) DATE Orig Sched Date

13 ORIG_SCHED_TIME Time(15) TIMESTAMP Original Schedule Time

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

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

16 SCHED_DATE Date(10) DATE Schedule Date

17 SCHED_TIME Time(15) TIMESTAMP Schedule Time

18 PICK_DATE Date(10) DATE Picked Date

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

20 SHIP_DATE Date(10) DATE Item Shipping Date

21 SHIP_TIME Time(15) TIMESTAMP Ship Time

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

23 CANCEL_DATE Date(10) DATE Cancel Date

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

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

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

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

28 SHIP_EARLY_DATE Date(10) DATE Earliest Ship Date

29 SHIP_EARLY_TIME Time(15) TIMESTAMP Earliest Ship Time

30 SHIP_LATE_DATE Date(10) DATE Latest Ship Date

31 SHIP_LATE_TIME Time(15) TIMESTAMP Latest Ship Time

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

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

34 DISTRIB_TYPE Character(10) VARCHAR2(10) NOT NULL Distrib. Type

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

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

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

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

39 CHARGE_FLAG Character(1) VARCHAR2(1) NOT NULL Charged Out

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

41 FERC_CD Character(10) VARCHAR2(10) NOT NULL FERC Code

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

43 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag

44 EXP_RETURN_DATE Date(10) DATE Return Date

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

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

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

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

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

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

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

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

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

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

55 QTY_PICK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Pick Base

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

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

58 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'.

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

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

61 FULFILL_FLAG Character(1) VARCHAR2(1) NOT NULL OK to Pick

62 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate

63 APPROVED_FLAG Character(1) VARCHAR2(1) NOT NULL Approved
B=Both
N=No
Y=Yes

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

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

66 INTERUNIT_FLG Character(1) VARCHAR2(1) NOT NULL InterUnit
N=No
Y=Yes

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

68 INTERUNIT_LINE Number(5,0) INTEGER NOT NULL InterUnit Order Line

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

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

71 SHIPPED_MESSAGE Character(1) VARCHAR2(1) NOT NULL Shipped Message
Y/N Table Edit
Default Value: N

72 QTY_VERIFY_MSG Character(1) VARCHAR2(1) NOT NULL Verify Qty
Y/N Table Edit
Default Value: N

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

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

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

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

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

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

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

80 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

81 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1

82 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2

83 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3

84 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4

85 CITY Character(30) VARCHAR2(30) NOT NULL City

86 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1

87 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2

88 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer

89 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1

90 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2

91 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3

92 COUNTY Character(30) VARCHAR2(30) NOT NULL County

93 STATE Character(6) VARCHAR2(6) NOT NULL State
Prompt Table: %EDIT_STATE

94 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal

95 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code

96 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit
Y/N Table Edit

97 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
Prompt Table: UNITS_TBL

98 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
Prompt Table: UNITS_TBL

99 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
Prompt Table: INV_SHIP_UOM_VW

100 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

101 SHIP_UOM_CONV_FLAG Character(1) VARCHAR2(1) NOT NULL UOM Conversion Flag-Ship Panel
1=Enter Qty in Ordering UOM
2=Enter Qty in Shipping UOM

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

103 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship

104 PARTIAL_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Orders Can Ship
N=No
Y=Yes

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

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

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

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

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

110 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation

111 DATE_LAST_MAINT Date(10) DATE Date Last Maintained

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

113 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

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

115 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit

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

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

118 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID
Prompt Table: CARRIER_ID

119 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID
Prompt Table: LOAD_INV_OPN_VW

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

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

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

123 DIRECT_INVOICING Character(1) VARCHAR2(1) NOT NULL Direct Invoicing
Y/N Table Edit

124 BACKORDER_CREATED Character(1) VARCHAR2(1) NOT NULL Backorder Created Flag

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

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

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

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

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

130 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
N=Hold
Y=Hold
Y/N Table Edit

131 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

132 SHIP_SHORT_WF_DONE Character(1) VARCHAR2(1) NOT NULL Ship Short WF Notification

133 CURRENCY_CD_DEST Character(3) VARCHAR2(3) NOT NULL Currency Code Dest

134 TAX_CD_VAT Character(8) VARCHAR2(8) NOT NULL Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.

135 TRANSFER_COST_DEST Signed Number(16,4) DECIMAL(14,4) NOT NULL Transfer Price Dest

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

137 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.

138 VAT_APPLICABILITY Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt
N=Not Applicable
O=Outside of Scope of VAT
S=Suspended
T=Taxable
V=VAT Only
X=Exonerated

139 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.
Prompt Table: ROUTE_INV_VW

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

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

142 RESERVED_DATE Date(10) DATE Date on which a demand line was soft reserved.

143 DEPLETED_DATE Date(10) DATE Date on which a shipped demand line was depleted from on-hand inventory quantity balances.

144 BUDGET_DT Date(10) DATE Budget Date

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

146 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

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

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

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

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

151 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

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

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

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

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

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

157 CUST_CONTACT Character(40) VARCHAR2(40) NOT NULL Customer Contact

158 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
Y/N Table Edit
Default Value: N

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

160 QTY_PACK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity Packed

161 FREIGHT_VENDOR Character(1) VARCHAR2(1) NOT NULL Used by OM, INV.
E=External Freight System
I=Internal Freight System

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

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

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

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

166 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

167 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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
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: BU_ITM_INV_VW2
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	ORIG_SCHED_DATE	Date(10)	DATE	Orig Sched Date
13	ORIG_SCHED_TIME	Time(15)	TIMESTAMP	Original Schedule Time
14	SHIP_ID	Character(10)	VARCHAR2(10) NOT NULL	Shipping ID
15	SHIP_LINE_NO	Number(10,2)	DECIMAL(9,2) NOT NULL	Ship Line No
16	SCHED_DATE	Date(10)	DATE	Schedule Date
17	SCHED_TIME	Time(15)	TIMESTAMP	Schedule Time
18	PICK_DATE	Date(10)	DATE	Picked Date
19	ORIG_BU	Character(5)	VARCHAR2(5) NOT NULL	Original Business Unit
20	SHIP_DATE	Date(10)	DATE	Item Shipping Date
21	SHIP_TIME	Time(15)	TIMESTAMP	Ship Time
22	SCHED_ARRV_DTTM	DateTime(26)	TIMESTAMP	Schedule Arrival Dt/Tm
23	CANCEL_DATE	Date(10)	DATE	Cancel Date
24	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
25	PARENT_PROD_ID	Character(18)	VARCHAR2(18) NOT NULL	Parent Product Id
26	KIT_LINE_NBR	Number(3,0)	SMALLINT NOT NULL	Kit Line Number
27	SHIP_TYPE_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship Via Code Prompt Table: SHIP_METHOD
28	SHIP_EARLY_DATE	Date(10)	DATE	Earliest Ship Date
29	SHIP_EARLY_TIME	Time(15)	TIMESTAMP	Earliest Ship Time
30	SHIP_LATE_DATE	Date(10)	DATE	Latest Ship Date
31	SHIP_LATE_TIME	Time(15)	TIMESTAMP	Latest Ship Time
32	FREIGHT_TERMS	Character(10)	VARCHAR2(10) NOT NULL	Freight Terms Code Prompt Table: FREIGHT_TERMS
33	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
34	DISTRIB_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Distrib. Type
35	REQ_ID	Character(10)	VARCHAR2(10) NOT NULL	Requisition ID
36	REQ_LINE_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Line Number
37	REQ_SCHED_NBR	Number(3,0)	SMALLINT NOT NULL	Requisition Schedule Number
38	REQ_DISTRIB_NBR	Number(5,0)	INTEGER NOT NULL	Requisition Distrib Number
39	CHARGE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Charged Out
40	CNTRCT_ID	Character(25)	VARCHAR2(25) NOT NULL	Buying Agreement ID
41	FERC_CD	Character(10)	VARCHAR2(10) NOT NULL	FERC Code
42	INV_ITEM_ALIAS	Character(18)	VARCHAR2(18) NOT NULL	Item Alias
43	TAX_EXEMPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Tax Exempt Flag
44	EXP_RETURN_DATE	Date(10)	DATE	Return Date
45	ORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
46	PACKAGING_CD	Character(4)	VARCHAR2(4) NOT NULL	Packaging Code
47	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
48	QTY_REQUESTED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested
49	QTY_REQUESTED_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Requested Base
50	QTY_ALLOCATED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Allocated quantity
51	QTY_ALLOC_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity allocation
52	QTY_PICKED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Picked
53	QTY_SHIPPED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
54	QTY_SHIPPED_CONV	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
55	QTY_PICK_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Pick Base
56	QTY_SHIP_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Ship Base
57	LAST_QTY_SHIP	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Quantity Last Shipped
58	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'.
59	QTY_BACKORDER	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Qty
60	QTY_BACKORDER_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Base Qty
61	FULFILL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	OK to Pick
62	HARD_ALLOC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hard Allocate
63	APPROVED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Approved B=Both N=No Y=Yes
64	TRANSFER_COST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Transfer Price
65	PRICE_MARKUP_PCT	Signed Number(16,2)	DECIMAL(14,2) NOT NULL	Price Markup %
66	INTERUNIT_FLG	Character(1)	VARCHAR2(1) NOT NULL	InterUnit N=No Y=Yes
67	INTERUNIT_ID	Character(10)	VARCHAR2(10) NOT NULL	InterUnit Order ID
68	INTERUNIT_LINE	Number(5,0)	INTEGER NOT NULL	InterUnit Order Line
69	INTERUNIT_STAT	Character(1)	VARCHAR2(1) NOT NULL	InterUnit Status C=Cancelled I=In-Transit O=Open P=Picked R=Received
70	DESTIN_BU	Character(5)	VARCHAR2(5) NOT NULL	Destination Unit
71	SHIPPED_MESSAGE	Character(1)	VARCHAR2(1) NOT NULL	Shipped Message Y/N Table Edit Default Value: N
72	QTY_VERIFY_MSG	Character(1)	VARCHAR2(1) NOT NULL	Verify Qty Y/N Table Edit Default Value: N
73	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
74	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.
75	CUST_NAME	Character(40)	VARCHAR2(40) NOT NULL	Name
76	SHIP_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Ship To Customer
77	SHIP_CUST_NAME1	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name
78	SHIP_CUST_NAME2	Character(40)	VARCHAR2(40) NOT NULL	Ship To Name 2
79	ADDRESS_SEQ_NUM	Number(5,0)	INTEGER NOT NULL	Address Sequence Number
80	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
81	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
82	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
83	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
84	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
85	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
86	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
87	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
88	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat WW=Trailer
89	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
90	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
91	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
92	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
93	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: %EDIT_STATE
94	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
95	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
96	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
97	UNIT_MEASURE_WT	Character(3)	VARCHAR2(3) NOT NULL	Weight UOM Prompt Table: UNITS_TBL
98	UNIT_MEASURE_VOL	Character(3)	VARCHAR2(3) NOT NULL	Volume UOM Prompt Table: UNITS_TBL
99	UNIT_MEASURE_SHIP	Character(3)	VARCHAR2(3) NOT NULL	Shipment Unit of Measure Prompt Table: INV_SHIP_UOM_VW
100	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
101	SHIP_UOM_CONV_FLAG	Character(1)	VARCHAR2(1) NOT NULL	UOM Conversion Flag-Ship Panel 1=Enter Qty in Ordering UOM 2=Enter Qty in Shipping UOM
102	SHIP_PRIOR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Ship Prior to Sched Date Y/N Table Edit
103	PARTIAL_QTY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Qtys Can Ship
104	PARTIAL_ORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Partial Orders Can Ship N=No Y=Yes
105	BCKORDR_CNCL_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Cancel Backorder N=Cancel Backorder No Y=Cancel Backorder Yes Y/N Table Edit
106	BCKORDER_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Backorder Flag N=No Y=Yes
107	FROZEN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Frozen Flag B=Both N=No Y=Yes Y/N Table Edit
108	CUSTODIAN	Character(30)	VARCHAR2(30) NOT NULL	Custodian
109	CHARGE_CODE	Character(20)	VARCHAR2(20) NOT NULL	Charge Code
110	LOT_ALLOC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Allow Lot Allocation
111	DATE_LAST_MAINT	Date(10)	DATE	Date Last Maintained
112	LAST_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Last Maintained By Operator ID
113	DT_TIMESTAMP	DateTime(26)	TIMESTAMP	Date Timestamp
114	DEPLETE_INV_FLG	Character(1)	VARCHAR2(1) NOT NULL	Deplete Inventory Flag Default Value: Y
115	BUSINESS_UNIT_BI	Character(5)	VARCHAR2(5) NOT NULL	Billing Business Unit
116	CONFIG_CODE	Character(50)	VARCHAR2(50) NOT NULL	Product Configurator
117	BILL_OF_LADING	Character(30)	VARCHAR2(30) NOT NULL	Specifies a bill of lading number associated with a Receivables item.
118	CARRIER_ID	Character(10)	VARCHAR2(10) NOT NULL	Carrier ID Prompt Table: CARRIER_ID
119	LOAD_ID	Character(10)	VARCHAR2(10) NOT NULL	Load ID Prompt Table: LOAD_INV_OPN_VW
120	PRO_NUMBER	Character(40)	VARCHAR2(40) NOT NULL	Pro Number
121	PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID
122	PICKLIST_LINE_NO	Number(7,0)	INTEGER NOT NULL	Pick List Sorting Line Number
123	DIRECT_INVOICING	Character(1)	VARCHAR2(1) NOT NULL	Direct Invoicing Y/N Table Edit
124	BACKORDER_CREATED	Character(1)	VARCHAR2(1) NOT NULL	Backorder Created Flag
125	BUSINESS_UNIT_PO	Character(5)	VARCHAR2(5) NOT NULL	PO Business Unit
126	RTV_ID	Character(10)	VARCHAR2(10) NOT NULL	Return To Vendor ID
127	RTV_LN_NBR	Number(5,0)	INTEGER NOT NULL	Return To Vendor Line
128	RTV_DISTRIB_NUM	Number(5,0)	INTEGER NOT NULL	RTV Distribution Number
129	PRICE_PO	Signed Number(17,5)	DECIMAL(15,5) NOT NULL	Purchase Order Price
130	HOLD_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Hold N=Hold Y=Hold Y/N Table Edit
131	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
132	SHIP_SHORT_WF_DONE	Character(1)	VARCHAR2(1) NOT NULL	Ship Short WF Notification
133	CURRENCY_CD_DEST	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Dest
134	TAX_CD_VAT	Character(8)	VARCHAR2(8) NOT NULL	Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for.
135	TRANSFER_COST_DEST	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Transfer Price Dest
136	TRANSFER_YIELD	Number(5,1)	DECIMAL(4,1) NOT NULL	Transfer Yield
137	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
138	VAT_APPLICABILITY	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible. E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated
139	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. Prompt Table: ROUTE_INV_VW
140	ROUTE_STOP_NBR	Number(5,0)	INTEGER NOT NULL	An identifier used to sequence customer addresses/location for a given route.
141	PICK_RELEASE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Release ID
142	RESERVED_DATE	Date(10)	DATE	Date on which a demand line was soft reserved.
143	DEPLETED_DATE	Date(10)	DATE	Date on which a shipped demand line was depleted from on-hand inventory quantity balances.
144	BUDGET_DT	Date(10)	DATE	Budget Date
145	EXPORT	Character(1)	VARCHAR2(1) NOT NULL	Export Analytic Instance N=No Y=Yes Y/N Table Edit Default Value: N
146	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
147	IST_RETURN_FLG_IUT	Character(1)	VARCHAR2(1) NOT NULL	Intrastat InterUnit Returns Y/N Table Edit Default Value: N
148	IST_TXN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Intrastat Transaction Flag N=No Y=Yes Default Value: N
149	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.
150	ORIG_UOM	Character(3)	VARCHAR2(3) NOT NULL	Original Unit of Measure
151	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
152	FRT_CHRG_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Freight Charge Override
153	FRT_CHRG_METHOD	Character(2)	VARCHAR2(2) NOT NULL	Freight Charge Method 01=Order Value 02=Weight 03=Volume 04=Order Quantity
154	FRT_RULE_CD	Character(10)	VARCHAR2(10) NOT NULL	Freight Rule Code
155	SHIP_ID_EST	Character(10)	VARCHAR2(10) NOT NULL	Estimated Ship ID
156	NET_UNIT_PRICE	Signed Number(16,4)	DECIMAL(14,4) NOT NULL	Net Unit Price
157	CUST_CONTACT	Character(40)	VARCHAR2(40) NOT NULL	Customer Contact
158	ALLOW_OVERPICK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used to indicate whether or not overpicking is allowed for a customer or business unit. Y/N Table Edit Default Value: N
159	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.
160	QTY_PACK_BASE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Base Quantity Packed
161	FREIGHT_VENDOR	Character(1)	VARCHAR2(1) NOT NULL	Used by OM, INV. E=External Freight System I=Internal Freight System
162	SINGLE_SHIP_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Single Ship Flag N=No Y=Yes
163	EXT_REF_NBR	Number(10,0)	DECIMAL(10) NOT NULL	External Reference Number
164	EXT_REF_LN_NBR	Number(5,0)	INTEGER NOT NULL	External Reference Line Number
165	PUB_PROCESS_INST	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
166	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
167	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