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 |