SHIP_DTL_INV_VW (SQL View)	Index Back
Shipping Detail - View /* mmt 04/05/04 Data model changes */

SHIP_DTL_INV_VW

(SQL View)

Shipping Detail - View

/* mmt 04/05/04 Data model changes */

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 , a.fulfillment_dttm , a.sched_dttm , a.orig_sched_dttm , %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) , a.pick_dttm , a.orig_bu , a.ship_dttm , a.ship_early_dttm , a.ship_late_dttm , a.sched_arrv_dttm , a.stock_dttm , %DatePart(a.cancel_dttm) , a.product_id , a.parent_prod_id , a.dp_kit_parent_qty , a.dp_kit_parent_uom , a.kit_line_nbr , a.in_kit_protected , 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_pick_ovride , a.qty_ship_base , a.last_qty_ship , a.last_qty_ship_base , a.qty_backorder , a.qty_backorder_base , a.fulfill_flag , a.reserve_status , a.reserved_dttm , 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.interunit_insert , a.destin_bu , a.in_fulfill_state , a.in_prior_state , 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 , 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.storage_area , a.stor_level_1 , a.stor_level_2 , a.stor_level_3 , a.stor_level_4 , a.last_process_inst , 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.picklist_printed , a.direct_invoicing , a.backorder_created , a.edi_dt_time , a.business_unit_po , a.rtv_id , a.rtv_ln_nbr , a.rtv_distrib_num , a.price_po , a.hold_flag , a.hold_cd , a.ist_distrib_status , a.carton_printed , a.shipping_printed , 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 , a.allow_overpick_flg , a.max_pick_tolerance , a.qty_pack_base , A.SINGLE_SHIP_FLAG , A.EXT_REF_NBR , A.EXT_REF_LN_NBR , A.PUB_PROCESS_INST , A.RECV_SHIP_SEQ_NBR , A.ADDR_OVRD_LEVEL , A.REASON_CD , A.TRANSFER_CALC_TYPE , A.DESTIN_GL_BU , A.COSTED_FLAG , A.DISTRIB_FLAG , A.IN_ZERO_PICKED_FLG , a.release_instance , A.QTY_PER , A.QTY_CODE , A.OPTIONAL_SHIP , A.IN_LINE_BO_RULE , a.in_line_resv_rule , A.IN_LN_RESV_BO_RULE , a.in_order_resv_rule , a.form_distrib_stat , A.TMS_EXT_REF_ID , a.tms_ext_ref_ln_nbr , a.tms_process_flg , a.tms_load_stp_nbr , a.update_restrct_lvl , a.ship_process_typ , a.om_flg , a.pssh_nonown_flag , A.PICK_CONFIRM_DTTM , a.depleted_dttm , A.CONFIRMED_FLAG , a.post_ship_instance , a.vmi_destin_shipto , a.vmi_om_bu , a.vmi_order_link , a.priority_ship_from , A.PEG_STATUS , A.SUP_PEG_STATUS , A.CNTCT_SEQ_SHIP , A.QTY_PROMISED_BASE , A.QTY_PICK_OVR_BASE , A.IN_PROCESS_DATE , A.FSS_ACTIVITY_DT , A.SDN_PUBLISH_DATE , A.IN_DEFER_DEPLETION , A.DELIVERY_ID , %subrec(deliv_volwt_sbr, a) , a.deliv_use_uom_ship , a.pref_carrier_Flag , a.TARGET_INVOICE , a.IN_ADDL_FEE , a.IN_ADDL_FEE_DEST , a.IN_TPRC_OVRD_FLAG , a.claim_id , %subrec(IN_DMD_USER_SBR, a) , a.speedtype_key , a.ACCOUNT , a.ALTACCT , a.DEPTID , %subrec(CF16_AN_SBR, A) , %subrec(PC_CF1_N_SBR, A) , a.combo_valid_flg , a.omb_process_date FROM PS_IN_DEMAND a WHERE a.in_fulfill_state BETWEEN '50' AND '70'

# 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 CANCEL_DTTM DateTime(26) TIMESTAMP Dttm demand line was canceled

13 FULFILLMENT_DTTM DateTime(26) TIMESTAMP Fulfillment Datetime

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

15 ORIG_SCHED_DTTM DateTime(26) TIMESTAMP Original Schedule Date/Time

16 ORIG_SCHED_DATE Date(10) DATE Orig Sched Date

17 ORIG_SCHED_TIME Time(15) TIMESTAMP Original Schedule Time

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 SCHED_DATE Date(10) DATE Schedule Date

21 SCHED_TIME Time(15) TIMESTAMP Schedule Time

22 PICK_DTTM DateTime(26) TIMESTAMP Picked Date/Time

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

24 SHIP_DTTM DateTime(26) TIMESTAMP Ship Date/Time

25 SHIP_EARLY_DTTM DateTime(26) TIMESTAMP Earliest Ship Date/Time

26 SHIP_LATE_DTTM DateTime(26) TIMESTAMP Latest Ship Date/Time

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

28 STOCK_DTTM DateTime(26) TIMESTAMP Stock Date/Time

29 CANCEL_DATE Date(10) DATE Cancel Date

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

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

32 DP_KIT_PARENT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Demand Planning Kit Parent Qty

33 DP_KIT_PARENT_UOM Character(3) VARCHAR2(3) NOT NULL DP Kit Parent Unit of Measure

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

35 IN_KIT_PROTECTED Character(1) VARCHAR2(1) NOT NULL Kit protected flag
Y/N Table Edit
Default Value: N

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

37 SHIP_EARLY_DATE Date(10) DATE Earliest Ship Date

38 SHIP_EARLY_TIME Time(15) TIMESTAMP Earliest Ship Time

39 SHIP_LATE_DATE Date(10) DATE Latest Ship Date

40 SHIP_LATE_TIME Time(15) TIMESTAMP Latest Ship Time

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

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

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

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

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

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

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

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

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

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

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

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

53 EXP_RETURN_DATE Date(10) DATE Return Date

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

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

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

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

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

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

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

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

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

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

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

65 QTY_PICK_OVRIDE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity when printing the pick play for non-soft reservation items.

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

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

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

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

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

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

72 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

73 RESERVED_DTTM DateTime(26) TIMESTAMP Reserved Date/Time

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

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

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

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

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

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

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

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

82 INTERUNIT_INSERT Character(1) VARCHAR2(1) NOT NULL Interunit Insert
Y/N Table Edit
Default Value: N

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

84 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

85 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

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

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

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

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

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

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

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

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

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

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

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

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

98 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

99 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

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

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

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

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

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

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

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

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

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

109 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area

110 STOR_LEVEL_1 Character(4) VARCHAR2(4) NOT NULL Storage Level 1

111 STOR_LEVEL_2 Character(4) VARCHAR2(4) NOT NULL Storage Level 2

112 STOR_LEVEL_3 Character(4) VARCHAR2(4) NOT NULL Storage Level 3

113 STOR_LEVEL_4 Character(4) VARCHAR2(4) NOT NULL Storage Level 4

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

115 DATE_LAST_MAINT Date(10) DATE Date Last Maintained

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

117 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp

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

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

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

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

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

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

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

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

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

127 PICKLIST_PRINTED Character(1) VARCHAR2(1) NOT NULL Picklist Printed

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

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

130 EDI_DT_TIME DateTime(26) TIMESTAMP EDI DATE TIME STAMP

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

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

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

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

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

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

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

138 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

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

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

141 SHIP_SHORT_WF_DONE Character(1) VARCHAR2(1) NOT NULL Ship Short WF Notification
Y/N Table Edit
Default Value: N

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

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

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

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

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

147 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

148 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

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

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

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

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

153 BUDGET_DT Date(10) DATE Budget Date

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

155 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

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

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

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

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

160 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

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

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

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

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

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

166 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

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

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

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

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

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

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

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

174 ADDR_OVRD_LEVEL Character(1) VARCHAR2(1) NOT NULL Address Override Level
D=Demand Line
H=Header
L=Line
S=Schedule

175 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code
Prompt Table: REASON_SHIP_VW

176 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

177 DESTIN_GL_BU Character(5) VARCHAR2(5) NOT NULL Destination GL Business Unit

178 COSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Cost status of the transaction. Contains two values: 'N' cost have not been calculated for the transaction and 'Y' cost have been calculated for the transaction
E=Error; Cannot process
N=Transaction is Not Costed
P=Qualified for Purging
X=Transaction Won't be Costed
Y=Transaction is Costed

179 DISTRIB_FLAG Character(1) VARCHAR2(1) NOT NULL GL Distribution

180 IN_ZERO_PICKED_FLG Character(1) VARCHAR2(1) NOT NULL Zero Picked

181 RELEASE_INSTANCE Number(10,0) DECIMAL(10) NOT NULL 08/2004 rcw: Order Release Instance

182 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity

183 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order

184 OPTIONAL_SHIP Character(1) VARCHAR2(1) NOT NULL OK to Ship Without

185 IN_LINE_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Backorder Rule
Prompt Table: IN_RULE_B_VW

186 IN_LINE_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation Rule
Prompt Table: IN_RULE_R_VW

187 IN_LN_RESV_BO_RULE Character(10) VARCHAR2(10) NOT NULL Line Reservation - Backorder
Prompt Table: IN_RULE_R_VW

188 IN_ORDER_RESV_RULE Character(10) VARCHAR2(10) NOT NULL Order Reservation Rule
Prompt Table: IN_RULE_O_VW

189 FORM_DISTRIB_STAT Character(1) VARCHAR2(1) NOT NULL Used for Sales Tax Forms tracking
D=Distributed
I=Ignore
N=Not Distributed
U=Undefined
Default Value: U

190 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID

191 TMS_EXT_REF_LN_NBR Number(7,0) INTEGER NOT NULL TMS Line Number

192 TMS_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL TMS Process Flag
Default Value: N

193 TMS_LOAD_STP_NBR Number(5,0) INTEGER NOT NULL Load Stop Number

194 UPDATE_RESTRCT_LVL Character(1) VARCHAR2(1) NOT NULL This is a translate field that indicates the restriction level and is checked by online processes when the row is being updated by a background process.

195 SHIP_PROCESS_TYP Character(1) VARCHAR2(1) NOT NULL This is a translate field that indicates the restriction level and is checked by online processes when the row is being updated by a background process.
0=Front End Shipping
1=Background Shipping
2=On-Line Shipping

196 OM_FLG Character(1) VARCHAR2(1) NOT NULL Order Management Extract Flag
Y/N Table Edit
Default Value: N

197 PSSH_NONOWN_FLAG Character(1) VARCHAR2(1) NOT NULL Non Own Flag
Y/N Table Edit
Default Value: N

198 PICK_CONFIRM_DTTM DateTime(26) TIMESTAMP Pick Confirm Date/Time

199 DEPLETED_DTTM DateTime(26) TIMESTAMP Dttm Demand Line was Depleted

200 CONFIRMED_FLAG Character(1) VARCHAR2(1) NOT NULL Confirm

201 POST_SHIP_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Cancel Instance

202 VMI_DESTIN_SHIPTO Character(15) VARCHAR2(15) NOT NULL Ship To Customer

203 VMI_OM_BU Character(5) VARCHAR2(5) NOT NULL OM Business Unit Related to VMI

204 VMI_ORDER_LINK Character(28) VARCHAR2(28) NOT NULL VMI Order Link

205 PRIORITY_SHIP_FROM Character(5) VARCHAR2(5) NOT NULL PRIORITY SHIP FROM BUSINESS UNIT

206 PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Not Pegged

207 SUP_PEG_STATUS Character(2) VARCHAR2(2) NOT NULL 07/21/04 EGS: Created
10=Open
20=Completed
30=Canceled
40=Unpegged

208 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To

209 QTY_PROMISED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Promised Base

210 QTY_PICK_OVR_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Field used to override the net requested quantity in standard uom when printing the pick play for non-soft reservation items.

211 IN_PROCESS_DATE Date(10) DATE Process Date

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

213 SDN_PUBLISH_DATE Date(10) DATE Publish date given on the loaded Financial Sanction list.

214 IN_DEFER_DEPLETION Character(1) VARCHAR2(1) NOT NULL Defer Depletions

215 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID

216 DELIV_UNIT_VOL Number(16,4) DECIMAL(15,4) NOT NULL Delivery Unit Volume

217 DELIV_UNIT_WT Number(16,4) DECIMAL(15,4) NOT NULL Delivery Unit Weight

218 DELIV_UOM_VOL Character(3) VARCHAR2(3) NOT NULL Delivery Volume UOM

219 DELIV_UOM_WT Character(3) VARCHAR2(3) NOT NULL Delivery Weight UOM

220 DELIV_UOM_SHIP_VOL Character(3) VARCHAR2(3) NOT NULL Ship UOM for volume conversion

221 DELIV_UOM_SHIP_WT Character(3) VARCHAR2(3) NOT NULL Ship UOM for weight conversion

222 DELIV_UNIT_VOL_CNV Number(16,8) DECIMAL(15,8) NOT NULL Unit volume conversion rate

223 DELIV_UNIT_WT_CNV Number(16,8) DECIMAL(15,8) NOT NULL Unit weight conversion rate

224 DELIV_USE_UOM_SHIP Character(1) VARCHAR2(1) NOT NULL Use UNIT_MEASURE_SHIP
Default Value: N

225 PREF_CARRIER_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Carrier flag
N=No Preferred Carrier
Y=Preferred Carrier
Default Value: N

226 TARGET_INVOICE Character(22) VARCHAR2(22) NOT NULL Target Invoice

227 IN_ADDL_FEE Signed Number(16,4) DECIMAL(14,4) NOT NULL Additional Fee

228 IN_ADDL_FEE_DEST Signed Number(16,4) DECIMAL(14,4) NOT NULL Additional Fee Dest

229 IN_TPRC_OVRD_FLAG Character(1) VARCHAR2(1) NOT NULL Override Transfer Prices flag
Y/N Table Edit
Default Value: N

230 CLAIM_ID Character(15) VARCHAR2(15) NOT NULL Claim ID

231 LINE_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL User Defined C1 A

232 LINE_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL User Defined C1 B

233 LINE_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL User Defined C1 C

234 LINE_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL User Defined C1 D

235 LINE_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL User Defined C2

236 LINE_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL User Defined C4

237 LINE_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL User Defined C6

238 LINE_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL User Defined C8

239 LINE_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL User Defined C10 A

240 LINE_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL User Defined C10 B

241 LINE_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL User Defined C10 C

242 LINE_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Line Fld C10 D

243 LINE_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User Defined C30 A

244 LINE_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL User Defined C30 B

245 LINE_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL User Defined C30 C

246 LINE_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL User Defined C30 D

247 LINE_FIELD_DTTM_A DateTime(26) TIMESTAMP User Defined DTTM A

248 LINE_FIELD_DTTM_B DateTime(26) TIMESTAMP User Defined DTTM B

249 LINE_FIELD_DTTM_C DateTime(26) TIMESTAMP User Defined DTTM C

250 LINE_FIELD_DTTM_D DateTime(26) TIMESTAMP User Defined DTTM D

251 LINE_FIELD_N11_A Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 A

252 LINE_FIELD_N11_B Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 B

253 LINE_FIELD_N11_C Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 C

254 LINE_FIELD_N11_D Signed Number(17,4) DECIMAL(15,4) NOT NULL User Defined N11.4 D

255 LINE_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 A

256 LINE_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 B

257 LINE_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 C

258 LINE_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL User Defined N15.0 D

259 SPEEDTYPE_KEY Character(10) VARCHAR2(10) NOT NULL SpeedType Key

260 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

261 ALTACCT Character(10) VARCHAR2(10) NOT NULL Alternate Account

262 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

263 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW

264 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField
Prompt Table: PRODUCT_BUGL_VW

265 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code
Prompt Table: FUND_BUGL_VW

266 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field
Prompt Table: CLASSCF_BUGL_VW

267 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW

268 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference
Prompt Table: BUD_REF_BUGL_VW

269 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate
Prompt Table: AFFILIATE_VW

270 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01

271 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02

272 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1
Prompt Table: CF1_BUGL_VW

273 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW

274 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW

275 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
Prompt Table: %EDIT_BU_PC

276 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: %EDIT_PROJECT

277 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: %EDIT_ACTIVITY

278 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
Prompt Table: PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC

279 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
Prompt Table: %EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC

280 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
Prompt Table: %EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC

281 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
Prompt Table: %EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC

282 COMBO_VALID_FLG Character(1) VARCHAR2(1) NOT NULL ChartField Combinatn Valid Flg
?=Validation in Progress
V=Valid ChartField Combination
X=Invalid ChartField Combo

283 OMB_PROCESS_DATE Date(10) DATE Process Date