OM_EC_OUT_AET(SQL Table) |
Index Back |
|---|---|
OMEC AE CacheOMEC AE Cache Date Initials Issue Description 102301 dms D-RBADARIN-6 Add source_cd, orig_dt_timestamp, eip_dta_status |
| # | 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 | OPRCLASS | Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 4 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | 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 |
| 7 | ORDER_INT_LINE_NO | Number(5,0) | INTEGER NOT NULL | Order Line |
| 8 | SCHED_LINE_NBR | Number(6,0) | INTEGER NOT NULL | Schedule Line Number |
| 9 | BILL_BACK_AMT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Bill Back Amount |
| 10 | BILL_BACK_AMT_BASE | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Bill Back Amount Base |
| 11 | DOCUMENT_CD | Character(4) | VARCHAR2(4) NOT NULL |
Document Code
ACKN=Order Acknowledgment ASN=Advance Shipping Notification BOL=Bill of Lading CACK=Order Change Acknowledgement CREN=Buying Agreement Renewal CSTS=Buying Agreement Status INCC=Invoice Courtesy Copy INVC=Invoice INVN=Invoice Notification PACK=Packing List PICK=Picking Plan PPRC=Product Price List PRAD=Payment Remittance Advice QUOT=Quotation RMA=Return Material Authorization |
| 12 | EFFDT | Date(10) | DATE | Effective Date |
| 13 | 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 |
| 14 | OFF_INVOICE_AMT | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Off Invoice Amount |
| 15 | OFF_INVOICE_AMT_BS | Signed Number(19,4) | DECIMAL(17,4) NOT NULL | Off Invoice Amount Base |
| 16 | OM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | OM Work Flag |
| 17 | OMEC_BROKER_SQL | Character(50) | VARCHAR2(50) NOT NULL | OMEC Broker SQL |
| 18 | OMEC_BU_SQL | Character(254) | VARCHAR2(254) NOT NULL | OMEC Business Unit SQL |
| 19 | OMEC_CHUNK_SQL | Character(100) | VARCHAR2(100) NOT NULL | OMEC Chunking SQL |
| 20 | OMEC_CHUNK_TBL | Character(30) | VARCHAR2(30) NOT NULL | OMEC Chunking Table |
| 21 | OMEC_CUST_FLDNAME | Character(15) | VARCHAR2(15) NOT NULL | OMEC Customer Field Name |
| 22 | OMEC_CUST_TYPE | Character(1) | VARCHAR2(1) NOT NULL | OMEC Customer Type |
| 23 | ORDER_TYPE_CD | Character(3) | VARCHAR2(3) NOT NULL |
Order Type
QUO=Sales Quote SO=Sales Order |
| 24 | OUTBOUND_ACK | Character(1) | VARCHAR2(1) NOT NULL | Order Acknowledgement Queue |
| 25 | OUTBOUND_CHG_ACK | Character(1) | VARCHAR2(1) NOT NULL | Order Change Notice Queue |
| 26 | OUTBOUND_QUOTE | Character(1) | VARCHAR2(1) NOT NULL | Quote Notice Queue |
| 27 | SOURCE_CD | Character(6) | VARCHAR2(6) NOT NULL | Source Code |
| 28 | REQUEST_ID | Character(10) | VARCHAR2(10) NOT NULL | Request ID |
| 29 | TOTAL_EXTRACT | Number(8,0) | INTEGER NOT NULL | Extract Total |
| 30 | CR_CARD_NBR_E | Character(44) | VARCHAR2(44) NOT NULL | Credit Card Number |
| 31 | CR_CARD_NBR | Character(44) | VARCHAR2(44) NOT NULL | "See OM |
| 32 | CC_PROF_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Credit Card Profile Option
0=No Tokenization 1=Create Profiles Before 2=Create Profiles After |