| # |
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 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PM_NONVW
|
| 5 |
INVOICE_DT |
Date(10) |
DATE |
Invoice Date
|
| 6 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 7 |
VMS_SUPPLIER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
VMS Supplier ID
|
| 8 |
CONTRACTOR |
Character(15) |
VARCHAR2(15) NOT NULL |
Contractor
|
| 9 |
HIRING_MANAGER |
Character(30) |
VARCHAR2(30) NOT NULL |
Hiring Manager
|
| 10 |
PROVIDER_CONTACT |
Character(15) |
VARCHAR2(15) NOT NULL |
PROVIDER CONTACT
|
| 11 |
START_DATE |
Date(10) |
DATE |
Start Date for Gen Standing PO
|
| 12 |
END_DATE |
Date(10) |
DATE |
End Date
|
| 13 |
PO_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
From/To
|
| 14 |
PO_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
PO_ID in a range
|
| 15 |
WORK_ORD_FROM |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Order Id
|
| 16 |
WORK_ORD_TO |
Character(15) |
VARCHAR2(15) NOT NULL |
Work Order Id
|
| 17 |
INVOICE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Invoice Number
|
| 18 |
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
|
| 19 |
SP_SERVICE_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Service Type classified as Resource Based or Service Based
D=Deliverable
R=Resource
|
| 20 |
SP_INVOICE_ACTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Flag to indicate whether invoices are to be generated or generate and submit. The translate value should correspond to those on the INVOICE STATUS field of SPF_INVOICE_HDR record. This flag is used on the Create Batch Invoice Run Control.
1=Generate Only
5=Generate and Submit
|
| 21 |
INVOICE_LINE |
Number(5,0) |
INTEGER NOT NULL |
Invoice Line
|
| 22 |
TIME_SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
|
| 23 |
PLOG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Time Sheet Unique Identifier (System Generated)
|
| 24 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 25 |
VMS_LOCATION |
Character(10) |
VARCHAR2(10) NOT NULL |
VMS Location - This is the Vendor Managed Service Supplier's office location
|
| 26 |
SP_SUP_INVAPPROVER |
Character(15) |
VARCHAR2(15) NOT NULL |
Supplier Proforma Invoice Approver
|
| 27 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 28 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 29 |
TEMPORARY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary
|
| 30 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
|
| 31 |
PYMT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Payment Terms Code
30=Due in 30 days after invoice
45=Due in 45 days after invoice
IMM=Due Immediately
|
| 32 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Default Value: MHR
Prompt Table:
UNITS_TBL
|
| 33 |
DATE_REPORT |
Date(10) |
DATE |
Report Date
|
| 34 |
SHEET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Report ID
|
| 35 |
SPA_TE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Time/Expense/Incident type
EXP=Expense Transaction
INC=Incident Transaction
INV=Invoice Transaction
TIM=Time Transaction
|
| 36 |
SPF_CURRENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Currency Selection
B=Base Currency
S=Work Order Currency
|
| 37 |
CURRENCY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Information Flag
D=Default from Higher Level
S=Specify at this Level
|
| 38 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 39 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 40 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 41 |
RATE_DATE |
Date(10) |
DATE |
Exchange Rate Date
|
| 42 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 43 |
CURRENCY_CD_BASE |
Character(3) |
VARCHAR2(3) NOT NULL |
Business Unit Base Currency
|
| 44 |
SEQ_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Sequence
|
| 45 |
LINE_NBR_WRK |
Number(5,0) |
INTEGER NOT NULL |
Work Line Number
|
| 46 |
SEQ_NUMBER |
Number(3,0) |
SMALLINT NOT NULL |
Expense Sequence Number
|
| 47 |
SP_SEQ_NUM |
Number(7,0) |
INTEGER NOT NULL |
Sequence Number
|
| 48 |
SUT_APPLICABILITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales/Use Tax Applicability
D=Direct Pay
E=Item is Exempt
S=Sales Tax Applicable
U=Use Tax Applicable
X=Purchaser Is Exonerated
|
| 49 |
TAX_VAT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Include VAT
N=No
Y=Yes
|
| 50 |
CHECK_ROWS_EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Check For Rows
|
| 51 |
SP_MSP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
MSP installation flag is used on the INSTALLATION_SP table to determine if this is an MSP installation of sPro
|
| 52 |
SP_VNDR_INTERNAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Vendor Internal or External type
N=N
Y=Yes
|
| 53 |
VMS_MANAGED |
Character(1) |
VARCHAR2(1) NOT NULL |
VMS Managed flag indicating if the work order is being managed by a Vendor Managed Service provider
B=Default from Business Unit
N=No
Y=Yes
|
| 54 |
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:
|
| 55 |
SPF_SPECIFIC_DATE |
Date(10) |
DATE |
Specifies a fixed date for the invoice date
|
| 56 |
SP_DAYS_CODE |
Character(2) |
VARCHAR2(2) NOT NULL |
Captures the days in a month
|
| 57 |
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
|
| 58 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|
| 59 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
|
| 60 |
REMIT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit to Location
|
| 61 |
REMIT_ADDR_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Remitting Location
|
| 62 |
NAME1_VNDR |
Character(40) |
VARCHAR2(40) NOT NULL |
Vendor Name
|
| 63 |
ADDRESS1_VNDR |
Character(55) |
VARCHAR2(55) NOT NULL |
Vendor Address Line 1
|
| 64 |
ADDRESS2_VNDR |
Character(55) |
VARCHAR2(55) NOT NULL |
Vendor Address Line 2
|
| 65 |
ADDRESS3_VNDR |
Character(55) |
VARCHAR2(55) NOT NULL |
Vendor Address Line 3
|
| 66 |
ADDRESS4_VNDR |
Character(55) |
VARCHAR2(55) NOT NULL |
Vendor Address Line 4
|
| 67 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 68 |
CITY_VNDR |
Character(30) |
VARCHAR2(30) NOT NULL |
Vendor City
|
| 69 |
STATE_VNDR |
Character(6) |
VARCHAR2(6) NOT NULL |
Vendor State
|
| 70 |
POSTAL_VNDR |
Character(12) |
VARCHAR2(12) NOT NULL |
Vendor Postal Code
|
| 71 |
COUNTRY_VNDR |
Character(3) |
VARCHAR2(3) NOT NULL |
Vendor Country
|
| 72 |
WHERE_VNDR |
Character(20) |
VARCHAR2(20) NOT NULL |
Where Clause for either VMS Supplier ID or Vendor ID
|
| 73 |
WHERE_FIELD1 |
Character(50) |
VARCHAR2(50) NOT NULL |
SQL Where field
|
| 74 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 75 |
COUNT_1 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|
| 76 |
COUNT_2 |
Number(3,0) |
SMALLINT NOT NULL |
Count Work Field
|