PROCESS_INSTANCEBUSINESS_UNITDEF=OM Background Defaulting
END=OM Background Calc
PRC=OM Background Pricing Required
Y/N Table Edit
OMBCK_BU_LIST(SQL Table) |
Index Back |
|---|---|
OM Business Unit ListOM Business Unit List |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | OM_RUN_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
OM Background Run Control Type
DEF=OM Background Defaulting END=OM Background Calc PRC=OM Background Pricing Required |
| 4 | PROCESS_COMPLETE | Character(1) | VARCHAR2(1) NOT NULL |
Process Complete
Y/N Table Edit |
| 5 | DATE_BEGIN | Date(10) | DATE | Start Date |
| 6 | DATE_END | Date(10) | DATE | End Date |
| 7 | GRACE_PRICE_DAYS | Number(3,0) | SMALLINT NOT NULL | Grace Pricing Discount Days |
| 8 | SCHED_SHIP_DTTM | DateTime(26) | TIMESTAMP | Schedule Ship Datetime |
| 9 | REQ_ARRIVAL_DTTM | DateTime(26) | TIMESTAMP | Requested Arrival |