| # |
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 |
PROCESS_AMPS_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Options Requests for the Payables/Purchasing Interface
A=Process All Pending Entries
B=Process Business Unit
C=Process Purchase Order
D=Process Receiver
E=Process Voucher
F=Process Asset Profile
G=Process Pre Interface ID
H=Process System Source
P=Procurement Group Id
R=Streamline Reserved for Receiv
V=Streamline Reserved for Vouche
W=Streamline Reserved for WrkCen
X=Streamline Reserved for WrkCen
|
| 6 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table:
AM_PREAM_BU_VW
|
| 7 |
BUSINESS_UNIT_PO |
Character(5) |
VARCHAR2(5) NOT NULL |
PO Business Unit
Prompt Table:
AM_PREAM_PO1_VW
|
| 8 |
PO_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Purchase Order
Prompt Table:
AM_PREAM_PO2_VW
|
| 9 |
PO_LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Purchase Order Line Number
Prompt Table:
AM_PREAM_PO3_VW
|
| 10 |
SCHED_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Schedule Number
Prompt Table:
AM_PREAM_PO4_VW
|
| 11 |
PO_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
PO Distribution Line Number
Prompt Table:
AM_PREAM_PO5_VW
|
| 12 |
BUSINESS_UNIT_RECV |
Character(5) |
VARCHAR2(5) NOT NULL |
Receiving Business Unit
Prompt Table:
AM_PREAM_RE1_VW
|
| 13 |
RECEIVER_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Receiver number
Prompt Table:
AM_PREAM_RE2_VW
|
| 14 |
RECV_LN_NBR |
Number(5,0) |
INTEGER NOT NULL |
Receipt Line
Prompt Table:
AM_PREAM_RE3_VW
|
| 15 |
RECV_SHIP_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Receiver Shipping Sequence
Prompt Table:
AM_PREAM_RE4_VW
|
| 16 |
RECV_DIST_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Receiver Distrib Line
Prompt Table:
AM_PREAM_RE5_VW
|
| 17 |
DISTRIB_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Sequence
Prompt Table:
AM_PREAM_RE6_VW
|
| 18 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
AM_PREAM_AP1_VW
|
| 19 |
VOUCHER_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table:
AM_PREAM_AP2_VW
|
| 20 |
VOUCHER_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Voucher Line Number
Prompt Table:
AM_PREAM_AP3_VW
|
| 21 |
DISTRIB_LINE_NUM |
Number(5,0) |
INTEGER NOT NULL |
Distribution Line
Prompt Table:
AM_PREAM_AP4_VW
|
| 22 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table:
AM_PREAM_PRF_VW
|
| 23 |
PRE_INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Pre-Interface ID
Prompt Table:
AM_PREAM_ID_VW
|
| 24 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 25 |
SOURCE_PAYABLES |
Character(3) |
VARCHAR2(3) NOT NULL |
System Source
|
| 26 |
SOURCE_PURCHASING |
Character(3) |
VARCHAR2(3) NOT NULL |
System Source
PPO=PO Online Entry Panel
|
| 27 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|
| 28 |
MULTICURRENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Multi-Currency
|
| 29 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 30 |
BASE_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
|
| 31 |
FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag
N=No
Y=Yes
|
| 32 |
AM_COST_FOUND |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Found
Y/N Table Edit
|
| 33 |
AM_SFA_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Split Funded Asset Exists
Y/N Table Edit
Default Value: N
|
| 34 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
|
| 35 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
|
| 36 |
BUSINESS_UNIT_AMTO |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Business Unit To
|
| 37 |
ASSET_ID_TO |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset ID to
|
| 38 |
LEGAL_DESCR |
Long Character |
CLOB |
Legal Description
|
| 39 |
PO_GROUP_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
GroupID
|
| 40 |
AM_PROCGRP_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Procurement Group Exists
|