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

OMBI_EST_FRT_VW

(SQL View)

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.FREIGHT_CHARGE_CNV , IDO.CURRENCY_CD , IDO.FREIGHT_CHARGE_BSE , IDO.CURRENCY_CD_BASE , IDO.FREIGHT_CHARGE , IDO.FREIGHT_CURRNCY_CD , IDO.BILLING_STATUS , IDO.FREIGHT_TAX_AMT , IDO.INVOICE , IDO.VAT_AMT , IDO.FREIGHT_CALC_FLAG 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 = 'F' AND ((D.FREIGHT_BILL_TYPE = 'OE' AND IDO.FREIGHT_APP = 'OM') OR (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 FREIGHT_CHARGE_CNV Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge (base)

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

10 FREIGHT_CHARGE_BSE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge (base)

11 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency

12 FREIGHT_CHARGE Signed Number(17,4) DECIMAL(15,4) NOT NULL Freight Charge

13 FREIGHT_CURRNCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

14 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

15 FREIGHT_TAX_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Freight Tax Amount

16 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice

17 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.

18 FREIGHT_CALC_FLAG Character(1) VARCHAR2(1) NOT NULL Freight Calculate Flag

#	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	FREIGHT_CHARGE_CNV	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge (base)
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	FREIGHT_CHARGE_BSE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge (base)
11	CURRENCY_CD_BASE	Character(3)	VARCHAR2(3) NOT NULL	Business Unit Base Currency
12	FREIGHT_CHARGE	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Freight Charge
13	FREIGHT_CURRNCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	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
15	FREIGHT_TAX_AMT	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Freight Tax Amount
16	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
17	VAT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.
18	FREIGHT_CALC_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Freight Calculate Flag