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 |