IN_DELIVERY_VW2

(SQL View)
Index Back

IN view of IN_DELIVERY


SELECT D.BUSINESS_UNIT , D.DELIVERY_ID , F.FREIGHT_APP , %subrec(IN_DELIVERY_SBR, D) , %subrec(IN_DEL_FRT_SBR, F) , %subrec(IN_DTTIME_SBR, D) FROM PS_IN_DELIVERY D , PS_IN_DELIVERY_FRT F WHERE %Join(COMMON_KEYS, IN_DELIVERY D, IN_DELIVERY_FRT F)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
3 FREIGHT_APP Character(2) VARCHAR2(2) NOT NULL Identifier with regards to which product calculated freight for a delivery
IN=Inventory
OM=Order Management
4 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
5 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: CUST_ADDR_IN_VW

6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
11 CITY Character(30) VARCHAR2(30) NOT NULL City
12 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
13 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
14 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat
WW=Trailer
15 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
16 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
17 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
18 COUNTY Character(30) VARCHAR2(30) NOT NULL County
19 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

20 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
21 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
22 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

23 CARRIER_ID Character(10) VARCHAR2(10) NOT NULL Carrier ID

Prompt Table: CARRIER_ID

24 COMMODITY_CD Character(10) VARCHAR2(10) NOT NULL Commodity Code

Prompt Table: COMMOD_CODE

25 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
26 DOC_REFNUM Character(20) VARCHAR2(20) NOT NULL Counter sale document reference number
27 FREIGHT_BILL_TYPE Character(2) VARCHAR2(2) NOT NULL Freight Bill Type
OE=Order Entry
SH=Shipping
28 FREIGHT_TERMS Character(10) VARCHAR2(10) NOT NULL Freight Terms Code

Prompt Table: FREIGHT_TERMS

29 FRT_CHRG_METHOD Character(2) VARCHAR2(2) NOT NULL Freight Charge Method
01=Order Value
02=Weight
03=Volume
04=Order Quantity
30 HARMONIZED_CD Character(14) VARCHAR2(14) NOT NULL Harmonized Code

Prompt Table: HRMN_TARIFF_CD

31 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: MST_ITM_PRPT_VW

32 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

Prompt Table: INV_ITEM_GROUP

33 LOAD_ID Character(10) VARCHAR2(10) NOT NULL Load ID

Prompt Table: LOAD_INV

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

Prompt Table: LOCATION_SBU_VW

35 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: IN_DLV_ORD_VW

36 ORDER_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Order Type
QUO=Sales Quote
SO=Sales Order
37 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

Prompt Table: PROD_VW_BU

38 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

39 SCHED_SHIP_DATE Date(10) DATE Scheduled Ship Date
40 SHIP_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Ship To Customer

Prompt Table: CUST_SHP_INV_VW

41 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code

Prompt Table: SHIP_METHOD

42 TMS_LOAD_STP_NBR Number(5,0) INTEGER NOT NULL Load Stop Number
43 VAT_ENTITY Character(20) VARCHAR2(20) NOT NULL Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
44 BILL_ONLY Character(1) VARCHAR2(1) NOT NULL Indicates a sales order is to be billed only, and not fulfilled through Inventory.

Default Value: N

45 DEL_PKG_STATUS Character(1) VARCHAR2(1) NOT NULL Delivery Contains Packages

Y/N Table Edit

Default Value: N

46 DEL_ORD_RESTRICTED Character(1) VARCHAR2(1) NOT NULL Deliveries restricted to order
N=Deliveries Not Restricted
Y=Deliveries Restricted to Order

Y/N Table Edit

Default Value: N

47 DELIVERY_ERROR Character(1) VARCHAR2(1) NOT NULL Delivery Error

Y/N Table Edit

Default Value: N

48 DELIVERY_STATUS Character(2) VARCHAR2(2) NOT NULL Delivery Status
00=Pending for Demand
10=Pending for Quote
20=Open
60=Closed for Shipment
70=Delivery Completed
90=Canceled
99=Unassigned

Default Value: 20

49 DEPLETED_FLAG Character(1) VARCHAR2(1) NOT NULL Determines whether a reserved order line has already a pick batch id assigned.

Default Value: N

50 FRT_COMMIT_BILLING Character(1) VARCHAR2(1) NOT NULL Freight Committed for Billing

Y/N Table Edit

Default Value: N

51 FRT_RATE_STATUS Character(2) VARCHAR2(2) NOT NULL Rate Status
00=None
10=Requested
20=Received

Default Value: 00

52 FRT_RULE_CD Character(10) VARCHAR2(10) NOT NULL Freight Rule Code
53 FRT_BY_QTY Character(1) VARCHAR2(1) NOT NULL Freight by Order Quantity

Y/N Table Edit

Default Value: N

54 FRT_BY_VALUE Character(1) VARCHAR2(1) NOT NULL Freight by Order Value

Y/N Table Edit

Default Value: Y

55 FRT_BY_VOL Character(1) VARCHAR2(1) NOT NULL Freight by Shipping Volume

Y/N Table Edit

Default Value: Y

56 FRT_BY_WT Character(1) VARCHAR2(1) NOT NULL Freight by Shipping Weight

Y/N Table Edit

Default Value: Y

57 CARRIER_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Carrier ID
58 FREIGHT_TERMS_EXP Character(10) VARCHAR2(10) NOT NULL Export Freight Terms Code
59 SHIP_TYPE_ID_EXP Character(10) VARCHAR2(10) NOT NULL Export Shipping Method
60 FREIGHT_ERROR Character(1) VARCHAR2(1) NOT NULL Freight Error

Y/N Table Edit

Default Value: N

61 FREIGHT_APPLY_APP Character(2) VARCHAR2(2) NOT NULL Identifier with regards to which product calculated freight for a delivery
IN=Inventory
OM=Order Management
62 MANIFEST_STATUS Character(2) VARCHAR2(2) NOT NULL Manifest Status
00=None
10=Requested
20=Received

Default Value: 00

63 PREF_CARRIER_FLAG Character(1) VARCHAR2(1) NOT NULL Preferred Carrier flag
N=No Preferred Carrier
Y=Preferred Carrier

Default Value: N

64 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
65 UNIT_MEASURE_SHIP Character(3) VARCHAR2(3) NOT NULL Shipment Unit of Measure
66 UNIT_MEASURE_VOL Character(3) VARCHAR2(3) NOT NULL Volume UOM
67 UNIT_MEASURE_WT Character(3) VARCHAR2(3) NOT NULL Weight UOM
68 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

Default Value: 0

69 COMM_ARRV_DTTM DateTime(26) TIMESTAMP Communicated Arrival Datetime
70 COMM_SHIP_DTTM DateTime(26) TIMESTAMP Communicated Ship Datetime
71 FREIGHT_CALC_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Calculate Flag

Default Value: N

72 FREIGHT_CHARGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
73 FREIGHT_CURRNCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
74 FRT_CHRG_AUDIT Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge
75 FRT_CHRG_OPEN Character(1) VARCHAR2(1) NOT NULL Freight can be modified

Y/N Table Edit

Default Value: Y

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

Y/N Table Edit

Default Value: N

77 FRT_ROLLUP_IND Character(1) VARCHAR2(1) NOT NULL Freight Rollup Flag
1=Delivery
2=Rollup

Default Value: 1

78 FRT_REF_NO Character(30) VARCHAR2(30) NOT NULL Freight Reference Number
79 EXT_SHIP_ID Character(30) VARCHAR2(30) NOT NULL External Shipment Identifier
80 FRT_SRVC_DEFN Character(50) VARCHAR2(50) NOT NULL Freight Service Definition

Prompt Table: %EDITTABLE10

81 FRT_TYPE_CODE Character(10) VARCHAR2(10) NOT NULL Freight Type Code

Prompt Table: IN_FRT_DFLT

82 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number
83 IN_FRT_USAGE Character(2) VARCHAR2(2) NOT NULL Indicator of internal or external freight
10=Internal
20=External
30=None
40=Both
84 RATE_SHOPPED Character(1) VARCHAR2(1) NOT NULL Delivery is Rate Shopped

Y/N Table Edit

Default Value: N

85 FREIGHT_NET_PRC Signed Number(29,4) DECIMAL(27,4) NOT NULL Freight Net Value
86 FREIGHT_PRC_BASE Signed Number(29,4) DECIMAL(27,4) NOT NULL Freight Net Value (base)
87 FREIGHT_QUANTITY Number(17,4) DECIMAL(16,4) NOT NULL Freight Quantity
88 FREIGHT_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Volume
89 FREIGHT_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Weight
90 OVERRIDE_VOLUME Signed Number(17,4) DECIMAL(15,4) NOT NULL Override Volume
91 OVERRIDE_WEIGHT Signed Number(17,4) DECIMAL(15,4) NOT NULL Override Weight
92 TOTAL_NBR_PIECES Number(6,0) INTEGER NOT NULL Total Number of Pieces
93 DTTIME_ADDED DateTime(26) TIMESTAMP Date Time Added
94 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
95 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID