OM_EC_DB2_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | 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 |
| 3 | EIP_CTL_ID | Character(25) | VARCHAR2(25) NOT NULL | Enterprise Components EIP (enterprise integration point) control field |
| 4 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 5 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 6 | CUST_ADDR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Customer Address Type
H=Ship To Customer S=Sold To Customer |
| 7 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 8 | CP_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Rule Processing Modes Field
A=CRM Internal C=Model Tester M=Direct Production Order R=Direct Requisition Order S=Sales Order W=CRM External |
| 9 | CP_COMP_SEQ | Number(3,0) | SMALLINT NOT NULL | Component Sequence Field |
| 10 | OPTION_NAME | Character(18) | VARCHAR2(18) NOT NULL | Option Name |
| 11 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 12 | COMMSN_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Commissions Level
0=No Commissions 1=By Header 2=By Schedule |
| 13 | CONFIG_CODE | Character(50) | VARCHAR2(50) NOT NULL | Product Configurator |
| 14 | CUSTOMER_ITEM_NBR | Character(18) | VARCHAR2(18) NOT NULL | Customer Item Number |
| 15 | EIP_DTA_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
EIP Dta status
0=New 1=Error 2=Complete 3=In Process 4=Reprocess 5=Incomplete 6=Cancelled 7=Hold |
| 16 | INVALID_ARRV_DT | Character(1) | VARCHAR2(1) NOT NULL | Invalid arrival date indicator |
| 17 | LOAD_ID | Character(10) | VARCHAR2(10) NOT NULL | Load ID |
| 18 | PROD_ID_ENTERED | Character(20) | VARCHAR2(20) NOT NULL | Product ID Entered |
| 19 | PROD_ID_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Product Source
C=Customer P=UPC S=System U=Universal |
| 20 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 21 | ROUTE_CD | Character(6) | VARCHAR2(6) NOT NULL | A unique identifier assigned to a delivery route. Route codes can be associated with customer addresses for external orders or locations for internal orders. Route codes can be used to identify the appropriate delivery schedule for a customer/location if you are managing product shipments with your own vehicles. |
| 22 | ROUTE_STOP_NBR | Number(5,0) | INTEGER NOT NULL | An identifier used to sequence customer addresses/location for a given route. |
| 23 | SCHED_ARRV_DTTM | DateTime(26) | TIMESTAMP | Schedule Arrival Dt/Tm |
| 24 | SCHED_SHIP_DTTM | DateTime(26) | TIMESTAMP | Schedule Ship Datetime |
| 25 | TRNSPT_LEAD_DAYS | Number(3,0) | SMALLINT NOT NULL | Transportation Lead Tm (days) |
| 26 | TRNSPT_LEAD_HOURS | Number(2,0) | SMALLINT NOT NULL | Transportation Lead Tm (Hours) |
| 27 | TRNSPT_LEAD_MIN | Number(2,0) | SMALLINT NOT NULL | Transportation Lead Tm (Min) |
| 28 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 29 | UPC_ID | Character(18) | VARCHAR2(18) NOT NULL | Uniform Product Code ID |
| 30 | UPN_ID | Character(20) | VARCHAR2(20) NOT NULL | Universal Product Number |