OM_EXTFRDT_TAO (SQL Table)	Index Back
External Freight Ship date This table is used to extract only the schedule datetime field. Later, only the datepart will be used for the external freight calculation.

OM_EXTFRDT_TAO

(SQL Table)

External Freight Ship date

This table is used to extract only the schedule datetime field. Later, only the datepart will be used for the external freight calculation.

# 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 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

4 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID

5 SOURCE_CODE Character(2) VARCHAR2(2) NOT NULL 8/5/97 lee - inactivated source code 4 - service
1=Make
2=Buy
3=Expense
4=Service
5=Floor Stock
6=Planning

6 SCHED_SHIP_DTTM DateTime(26) TIMESTAMP Schedule Ship Datetime

#	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	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
4	DELIVERY_ID	Character(10)	VARCHAR2(10) NOT NULL	Delivery ID
5	SOURCE_CODE	Character(2)	VARCHAR2(2) NOT NULL	8/5/97 lee - inactivated source code 4 - service 1=Make 2=Buy 3=Expense 4=Service 5=Floor Stock 6=Planning
6	SCHED_SHIP_DTTM	DateTime(26)	TIMESTAMP	Schedule Ship Datetime