EM_PV_SHR_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 | 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 | MPA | Character(1) | VARCHAR2(1) NOT NULL | eSettlements |
| 5 | PO | Character(1) | VARCHAR2(1) NOT NULL | Purchasing |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 7 | EM_AGREE_BUYER | Character(1) | VARCHAR2(1) NOT NULL | This flag indicates whether a buyer agrees with the contract. |
| 8 | EM_AGREE_SELLER | Character(1) | VARCHAR2(1) NOT NULL | This flag indicates whether the agreement has been agreed to by the seller. |
| 9 | PYMNT_METHOD | Character(3) | VARCHAR2(3) NOT NULL |
Payment Method
ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer |
| 10 | EM_FACTOR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | This flag indicates whether a factor is to be used. |
| 11 | EM_FACTOR_ID | Character(10) | VARCHAR2(10) NOT NULL | If EM_FACTOR_FLAG = "Y", then Factor ID is entered into this field. Factor relationship has to be established in advance. This will be used during Voucher Build to default the Remit To Vendor information. |
| 12 | REMIT_LOC | Character(10) | VARCHAR2(10) NOT NULL | Remit to Location |
| 13 | MATCH_OPT | Character(1) | VARCHAR2(1) NOT NULL | Requires Matching |
| 14 | EM_STD_VCH_FLG | Character(1) | VARCHAR2(1) NOT NULL | This will allow vouchers without a PO number to be accepted into the database. This flag will be referenced during Voucher Build. |
| 15 | EM_INV_VERIFY_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Field used on the Agreement to specify the Invoice types to set for verification/review.
0=No Invoices 1=All Invoices 2=non-PO Invoices |
| 16 | EM_EXPOSE_CFS_FLG | Character(1) | VARCHAR2(1) NOT NULL | Expose ChartFields to Supplier |
| 17 | CUST_FLG1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Flag |
| 18 | CUST_FLG2 | Character(1) | VARCHAR2(1) NOT NULL | Custom Flag |
| 19 | CUST_FLG3 | Character(1) | VARCHAR2(1) NOT NULL | Custom Flag |
| 20 | CUST_FLG4 | Character(1) | VARCHAR2(1) NOT NULL | Custom Flag |
| 21 | CUST_FLG5 | Character(1) | VARCHAR2(1) NOT NULL | Custom Flag |
| 22 | CUST_UPPER1 | Character(30) | VARCHAR2(30) NOT NULL | Custom Uppercase String |
| 23 | CUST_UPPER2 | Character(30) | VARCHAR2(30) NOT NULL | Custom Uppercase String |
| 24 | CUST_UPPER3 | Character(30) | VARCHAR2(30) NOT NULL | Custom Uppercase String |
| 25 | CUST_UPPER4 | Character(30) | VARCHAR2(30) NOT NULL | Custom Uppercase String |
| 26 | CUST_UPPER5 | Character(30) | VARCHAR2(30) NOT NULL | Custom Uppercase String |
| 27 | CUST_UPPER6 | Character(30) | VARCHAR2(30) NOT NULL | Custom Uppercase String |
| 28 | CUST_UPPER7 | Character(30) | VARCHAR2(30) NOT NULL | Custom Uppercase String |
| 29 | CUST_UPPER8 | Character(30) | VARCHAR2(30) NOT NULL | Custom Uppercase String |
| 30 | CUST_UPPER9 | Character(30) | VARCHAR2(30) NOT NULL | Custom Uppercase String |
| 31 | CUST_UPPER10 | Character(30) | VARCHAR2(30) NOT NULL | Custom Uppercase String |
| 32 | CUST_NUMBER1 | Number(20,0) | DECIMAL(20) NOT NULL | Custom Number |
| 33 | CUST_NUMBER2 | Number(20,0) | DECIMAL(20) NOT NULL | Custom Number |
| 34 | CUST_NUMBER3 | Number(20,0) | DECIMAL(20) NOT NULL | Custom Number |
| 35 | CUST_NUMBER4 | Number(20,0) | DECIMAL(20) NOT NULL | Custom Number |
| 36 | CUST_NUMBER5 | Number(20,0) | DECIMAL(20) NOT NULL | Custom Number |
| 37 | CUST_DATE1 | Date(10) | DATE | Custom Date |
| 38 | CUST_DATE2 | Date(10) | DATE | Custom Date |
| 39 | CUST_DATE3 | Date(10) | DATE | Custom Date |
| 40 | CUST_DATE4 | Date(10) | DATE | Custom Date |
| 41 | CUST_DATE5 | Date(10) | DATE | Custom Date |
| 42 | CUST_AMT1 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 43 | CUST_AMT2 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 44 | CUST_AMT3 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 45 | CUST_AMT4 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 46 | CUST_AMT5 | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |