OMBI_INTFC4_AET(SQL Table) |
Index Back |
|---|---|
OMBI_INTFC4_AETThis record is used as a state record in AE program OM_OMBILL. This stores a field with shipfm additional sql. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | SHIPFM_SQL | Long Character | CLOB | Shipfm_additional_sql |
| 3 | BUSINESS_UNIT_LAST | Character(5) | VARCHAR2(5) NOT NULL | Last Business_Unit |
| 4 | ORDER_NO_TO | Character(10) | VARCHAR2(10) NOT NULL | To Order No |
| 5 | ORD_LINE_TAG | Number(5,0) | INTEGER NOT NULL | Order Line tag line nbr |
| 6 | SCHED_LINE_TO | Number(6,0) | INTEGER NOT NULL | Date Init. Issue # Description 092804 JJM F-CJORG-L1CX3 Sprinklebacks |
| 7 | DEMAND_LINE_NO_TO | Number(4,0) | SMALLINT NOT NULL | Demand line |
| 8 | DEMAND_LINE_NO | Number(4,0) | SMALLINT NOT NULL | Demand Line No |