OM_HOLDING_AREA

(SQL Table)
Index Back

OM Batch Holding Area

This is used for all OM batch processes to hold order numbers while the batch process is running. This will prevent contention with other OM batch processes to process the same OMBU/Order numbers.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 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
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name