OM_EXTFRDT_TAO(SQL Table) |
Index Back |
---|---|
External Freight Ship dateThis 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 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
3 | 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 | Character(10) | VARCHAR2(10) NOT NULL | Delivery ID | |
5 | 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 |