| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPR_DEF_TBL_FS
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
INV_PROCESS_INS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Invoice process Instance
|
| 4 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_SP_NONVW
|
| 5 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 6 |
SP_SUP_INVAPPROVER |
Character(15) |
VARCHAR2(15) NOT NULL |
Supplier Proforma Invoice Approver
|
| 7 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPT_TBL
|
| 8 |
HIRING_MANAGER |
Character(30) |
VARCHAR2(30) NOT NULL |
Requester
Prompt Table:
REQUESTOR_TBL
|
| 9 |
START_DATE |
Date(10) |
DATE NOT NULL |
Start Date for Gen Standing PO
|
| 10 |
END_DATE |
Date(10) |
DATE NOT NULL |
End Date
|
| 11 |
PO_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order ID From
Prompt Table:
SPF_PO_SRCH_VW
|
| 12 |
PO_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
PO_ID in a range
Prompt Table:
SPF_PO_SRCH_VW
|
| 13 |
WORK_ORD_FROM |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Order ID From
Prompt Table:
SPF_WO_SRCH2_V
|
| 14 |
WORK_ORD_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Order ID To
Prompt Table:
SPF_WO_SRCH2_V
|
| 15 |
SPF_CURRENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Currency Selection
B=Base Currency
S=Work Order Currency
|
| 16 |
INVOICE_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Invoice Status
0=Submitted to Enterprise
1=Generated
10=Canceled
11=Adjusted
2=Approved
3=Processed
4=Paid
5=Submitted
6=Denied
7=Submitted to Supplier
8=Approved by Supplier
9=Denied by Supplier
|
| 17 |
SPF_RUN_DT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate if the current date when a batch process is scheduled to run is used as the invoice date.
F=Use Flexible Date:
R=Use Run Date
S=Use Specific Date:
Default Value: R
|
| 18 |
SPF_SPECIFIC_DATE |
Date(10) |
DATE |
Specifies a fixed date for the invoice date
|
| 19 |
SP_DAYS_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Captures the days in a month
|
| 20 |
DAYS_BEFORE_AFTER |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether the number of days specified is before or after the run date that will be used as the invoice date
A=After
B=Before
|