OMBI_INTFC4_AET

(SQL Table)
Index Back

OMBI_INTFC4_AET

This 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 PROCESS_INSTANCE 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