PROCESS_INSTANCE1=Weekly
2=Monthly
3=Yearly
4=Specify Dates
5=Daily
6=Bi Weekly
AP=Approved
MA=Matched and Approved
MP=Matched and Pending Approval
PA=Pending Approval
PD=Paid
X=Any Status Change
F=Fixed Format
X=XML File
Default Value: X
EM_VCHR_EXT_AET(SQL Table) |
Index Back |
|---|---|
MP - Voucher Extract State RecMP - Voucher Extract State Record |
| # | 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 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 7 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 8 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 9 | EM_PERIOD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Period Type
1=Weekly 2=Monthly 3=Yearly 4=Specify Dates 5=Daily 6=Bi Weekly |
| 10 | DATE_FROM | Date(10) | DATE | Date From |
| 11 | DATE_TO | Date(10) | DATE | Date To |
| 12 | EM_VCHR_EXT_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Invoice Extract Status
AP=Approved MA=Matched and Approved MP=Matched and Pending Approval PA=Pending Approval PD=Paid X=Any Status Change |
| 13 | EM_REPORT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Report Type
F=Fixed Format X=XML File Default Value: X |
| 14 | URL | Character(254) | VARCHAR2(254) NOT NULL | Internet URL (Universal Resource Locator) |