OM_PPRC_AET(SQL Table) |
Index Back |
|---|---|
OMEC AE CacheOMEC AE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 7 | OM_PARM_SEL_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Selection Type
A=All Customers C=Specific Customer G=Specific Customer Group |
| 8 | OM_PARM_SEL_OPT | Character(3) | VARCHAR2(3) NOT NULL |
Selection Options
CAT=Catalog Number IBU=Inventory Business Unit NON=None PRG=Product Group PRL=Price List |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | SETID_CUSTOMER | Character(5) | VARCHAR2(5) NOT NULL | Customer SetID |
| 11 | SETID_PPRC_LIST | Character(5) | VARCHAR2(5) NOT NULL | SETID PPRC LIST |
| 12 | SETID_PROD_PRICE | Character(5) | VARCHAR2(5) NOT NULL | Setid product price |
| 13 | SETID_PRODUCT | Character(5) | VARCHAR2(5) NOT NULL | Product SetID |
| 14 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 15 | CUSTOMER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Customer Group |
| 16 | SOLD_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Sold To Customer |
| 17 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 18 | SETID_CATALOG | Character(5) | VARCHAR2(5) NOT NULL | Catalog SetID |
| 19 | SETID_CUST_GRP | Character(5) | VARCHAR2(5) NOT NULL | Customer Group SetID |
| 20 | PRICE_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL | Price List ID |
| 21 | CATALOG_NBR | Character(18) | VARCHAR2(18) NOT NULL | Catalog Number |
| 22 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Product Group |
| 23 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 24 | ACK_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Acknowledgement Status
AC=Ack - With Detail and Change AD=Ack - With Detail, No Change AE=Ack - Exception Detail Only AH=Acknowledge - Hold Status AK=Ack - No Detail or Change AT=Accepted BP=Accepted - Partial Shipment DR=Accepted - Date Rescheduled IA=Accepted - Price Pending IB=Backordered IC=Accepted - Changes Made ID=Deleted IF=On Hold-Incomplete Description IH=On Hold IP=Accepted - Price Changed IQ=Accepted - Quantity Changed IS=Accepted - Substitution Made IW=On Hold - Waiver Required RD=Rejected With Detail RF=Rej - Exception Detail Only RJ=Rejected - No Detail RO=Rejected With Counter Offer SP=Accpted-Schedule Date Pending ZZ=Mutually Defined Value |
| 25 | EIP_PROGRAM | Character(10) | VARCHAR2(10) NOT NULL |
Enterprise Components EIP (enterprise integration point) program field
601=Consumer Sync 701=BOM Sync 801=Item Revision 901=Item Bus Unit Sync 902=Item Sync |
| 26 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 27 | OM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | OM Work Flag |