OM_HOLDING_AREA(SQL Table) |
Index Back |
---|---|
OM Batch Holding AreaThis 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 |