IN_TMS_L_EVW

(SQL View)
 Index Back

TMS Load Line

Transportation Management System (TMS) Load Notification Line

SELECT A.PROCESS_INSTANCE , A.BUSINESS_UNIT , A.TMS_EXT_REF_ID , A.TMS_EXT_REF_LN_NBR , A.ORDER_INT_LINE_NO , A.SCHED_LINE_NBR , A.INV_ITEM_ID , A.DEMAND_LINE_NO , A.IN_PROCESS_FLG , A.AUDIT_ACTN , A.REQ_SHIP_DTTM , A.REQ_ARRIVAL_DTTM , A.SCHED_SHIP_DTTM , A.SHIP_PRIOR_FLG , A.ALLOW_OVERPICK_FLG , A.CCI_REQ_EXP , A.CNTRCT_ID , A.CNTRCT_LINE_NBR , A.CONFIG_CODE , A.COO_REQ_EXP , A.CURRENCY_CD , A.CUSTOMER_ITEM_NBR , A.CUSTOMER_PO , A.CUSTOMER_PO_SCHED , A.EXPORT , A.EXPORT_LIC_EXPIRE , A.EXPORT_LIC_NBR , A.EXPORT_LIC_REQ , A.EXPORT_LIC_TYPE , A.HARD_ALLOC_FLAG , A.IMPORT_CERT_NBR , A.IMPORT_LIC_EXP , A.IMPORT_LIC_REQ , A.DEMAND_DATE , A.ITEM_DESCR , A.RELATE_DESCR , A.KIT_LINE_NBR , A.LOT_ALLOC_FLG , A.LOT_CONTROL , A.MAX_PICK_TOLERANCE , A.NAFTA_REQ_EXP , A.PARENT_PROD_ID , A.PARTIAL_ORDER_FLAG , A.PARTIAL_QTY_FLAG , A.PICK_BATCH_ID , A.PICKLIST_LINE_NO , A.PRIORITY_NBR , A.PRODUCT_ID , A.QTY_PICKED , A.QTY_PICK_BASE , A.QTY_REQUESTED , A.QTY_REQUESTED_BASE , A.CARRIER_ID_EXP , A.FREIGHT_TERMS_EXP , A.SHIP_TYPE_ID_EXP , A.SED_REQ_EXP , A.SERIAL_CONTROL , A.SHIP_PRIORITY_EXP , A.SHIP_SERIAL_CNTRL , A.SINGLE_SHIP_FLAG , A.STAGED_DATE_FLAG , A.UNIT_MEASURE_STD , A.QTY_PREC_STD , A.ROUND_RULE_STD , A.UNIT_OF_MEASURE , A.ORDER_UOM_RATE , A.QTY_PREC_ORDR , A.ROUND_RULE_ORDR , A.UNIT_MEASURE_PACK , A.SHIP_UOM_RATE , A.QTY_PRCSN_TRN , A.ROUND_RULE_TRN , A.COMMODITY_CD , A.UPC_ID , A.HAZ_CLASS_CD , A.UOM_WEIGHT , A.UOM_VOLUME , A.SHIPPING_WEIGHT , A.SHIPPING_VOLUME , A.TOTAL_PIECES , A.TOTAL_WEIGHT , A.TOTAL_VOLUME FROM PS_IN_TMS_L_TBL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID
4 TMS_EXT_REF_LN_NBR Number(7,0) INTEGER NOT NULL TMS Line Number
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
8 DEMAND_LINE_NO Number(4,0) SMALLINT NOT NULL Demand Line No
9 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag
10 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
11 REQ_SHIP_DTTM DateTime(26) TIMESTAMP Requested Ship
12 REQ_ARRIVAL_DTTM DateTime(26) TIMESTAMP Requested Arrival
13 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime
14 SHIP_PRIOR_FLG Character(1) VARCHAR2(1) NOT NULL Ship Prior to Sched Date

Y/N Table Edit

15 ALLOW_OVERPICK_FLG Character(1) VARCHAR2(1) NOT NULL Used to indicate whether or not overpicking is allowed for a customer or business unit.
16 CCI_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Canadian Customs Invoice
N=No
Y=Yes
17 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
18 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
19 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
20 COO_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Certificate of Origin
N=No
Y=Yes
21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
22 CUSTOMER_ITEM_NBR Character(18) VARCHAR2(18) NOT NULL Customer Item Number
23 CUSTOMER_PO Character(25) VARCHAR2(25) NOT NULL Customer PO
24 CUSTOMER_PO_SCHED Character(11) VARCHAR2(11) NOT NULL Customer PO Schedule
25 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

Y/N Table Edit

26 EXPORT_LIC_EXPIRE Date(10) DATE Expiration Date
27 EXPORT_LIC_NBR Character(18) VARCHAR2(18) NOT NULL Export License Nbr
28 EXPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Export License Required
NO=No
YES=Yes
29 EXPORT_LIC_TYPE Character(4) VARCHAR2(4) NOT NULL License Type
GDST=General
SPEC=Specific
30 HARD_ALLOC_FLAG Character(1) VARCHAR2(1) NOT NULL Hard Allocate

Y/N Table Edit

31 IMPORT_CERT_NBR Character(18) VARCHAR2(18) NOT NULL Import License Nbr
32 IMPORT_LIC_EXP Date(10) DATE Expiration Date
33 IMPORT_LIC_REQ Character(3) VARCHAR2(3) NOT NULL Import License Required
NO=No
YES=Yes
34 DEMAND_DATE Date(10) DATE Demand Date
35 ITEM_DESCR Character(30) VARCHAR2(30) NOT NULL Item Description
36 RELATE_DESCR Character(30) VARCHAR2(30) NOT NULL Relationship Description
37 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number
38 LOT_ALLOC_FLG Character(1) VARCHAR2(1) NOT NULL Allow Lot Allocation
39 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y
40 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.
41 NAFTA_REQ_EXP Character(1) VARCHAR2(1) NOT NULL North American Free Trade Agmt
N=No
Y=Yes
42 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
43 PARTIAL_ORDER_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Orders Can Ship
N=No
Y=Yes
44 PARTIAL_QTY_FLAG Character(1) VARCHAR2(1) NOT NULL Partial Qtys Can Ship
45 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID
46 PICKLIST_LINE_NO Number(7,0) INTEGER NOT NULL Pick List Sorting Line Number
47 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority
48 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
49 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
50 QTY_PICK_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Pick Base
51 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
52 QTY_REQUESTED_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested Base
53 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
54 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
55 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
56 SED_REQ_EXP Character(1) VARCHAR2(1) NOT NULL Shippers Export Declaration
N=No
Y=Yes
57 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y
58 SHIP_PRIORITY_EXP Character(6) VARCHAR2(6) NOT NULL Export Shipping Priority
59 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control
60 SINGLE_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Single Ship Flag
N=No
Y=Yes
61 STAGED_DATE_FLAG Character(1) VARCHAR2(1) NOT NULL Staged Date Control
N=Staged Date Tracking OFF
Y=Staged Date Tracking ON
62 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
63 QTY_PREC_STD Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number
64 ROUND_RULE_STD Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up
65 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
66 ORDER_UOM_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Order UOM Conversion Rate
67 QTY_PREC_ORDR Character(1) VARCHAR2(1) NOT NULL Quantity Precision
D=Decimal Number
W=Whole Number
68 ROUND_RULE_ORDR Character(1) VARCHAR2(1) NOT NULL Rounding Rule
N=Natural Round
U=Round Up
69 UNIT_MEASURE_PACK Character(3) VARCHAR2(3) NOT NULL Packing UOM
70 SHIP_UOM_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Order UOM Conversion Rate
71 QTY_PRCSN_TRN Character(1) VARCHAR2(1) NOT NULL Quantity Precision
72 ROUND_RULE_TRN Character(1) VARCHAR2(1) NOT NULL Rounding Rule
73 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code
74 UPC_ID Character(18) VARCHAR2(18) NOT NULL Uniform Product Code ID
75 HAZ_CLASS_CD Character(4) VARCHAR2(4) NOT NULL Hazard Code
76 UOM_WEIGHT Character(3) VARCHAR2(3) NOT NULL Weight UOM
77 UOM_VOLUME Character(3) VARCHAR2(3) NOT NULL Volume UOM
78 SHIPPING_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Weight
79 SHIPPING_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Shipping Volume
80 TOTAL_PIECES Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Pieces
81 TOTAL_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Weight
82 TOTAL_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Volume