OMBI_EST_MSC_VW

(SQL View)
 Index Back

Unbilled Estimated OM Freight

Unbilled Estimated Freight. Displays either the Freight Charge or the Override Freight Charge that has not been billed.

SELECT IDO.ORDER_NO , IDO.BUSINESS_UNIT , IDO.DELIVERY_ID , IDO.SHIP_ID , IDO.SOURCE_BUS_UNIT , IDO.SEQ_NUM , IDO.FREIGHT_APP , IDO.UNIT_AMT_CONV , IDO.CURRENCY_CD , IDO.UNIT_AMT , IDO.CURRENCY_CD_BASE , IDO.BILLING_STATUS , IDO.INVOICE FROM PS_IN_DELIVERY_ORD IDO , PS_IN_DELIVERY D WHERE %Join(COMMON_KEYS, IN_DELIVERY_ORD IDO, IN_DELIVERY D) AND IDO.BILLING_STATUS = 'A' AND IDO.CHARGE_TYPE = 'M' AND D.FREIGHT_BILL_TYPE = 'SH' AND IDO.FREIGHT_APP = 'IN'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID
4 SHIP_ID Character(10) VARCHAR2(10) NOT NULL Shipping ID
5 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
6 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
7 FREIGHT_APP Character(2) VARCHAR2(2) NOT NULL Identifier with regards to which product calculated freight for a delivery
IN=Inventory
OM=Order Management
8 UNIT_AMT_CONV Signed Number(17,4) DECIMAL(15,4) NOT NULL Unit Price
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
10 UNIT_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Unit Price
11 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency
12 BILLING_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Status
A=Available
B=In Billing
C=Contract
I=Invoiced
N=Not Avail
P=In Process
S=Staged
13 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice