| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
|
| 3 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
|
| 4 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 5 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 6 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 7 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 8 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 9 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 10 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 11 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 12 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 13 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 14 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 15 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 16 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 17 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 18 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDIT_PROJECT
|
| 19 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 20 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC
|
| 21 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 22 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 23 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|
| 24 |
SPEEDCHART_KEY |
Character(10) |
VARCHAR2(10) NOT NULL |
SpeedChart Key
|
| 25 |
ACCOUNT_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Accounting Tag
|
| 26 |
EM_AGREEMENT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Agreement Id
|
| 27 |
AGREEMENT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Master Agreement Name
|
| 28 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 29 |
EM_MG_CF_COMBO |
Number(9,0) |
DECIMAL(9) NOT NULL |
Chartfield Combination ID
|
| 30 |
EM_MG_NBR_DTL |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of Detail Agreements
|
| 31 |
EM_MG_NBR_MG |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of Master Agreements
|
| 32 |
EM_MG_NBR_SKP |
Number(9,0) |
DECIMAL(9) NOT NULL |
Number of Agreements Bypassed
|
| 33 |
MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Matching
Y/N Table Edit
Default Value: N
|
| 34 |
MATCH_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Match Rule
Default Value: STANDARD
Prompt Table:
MTCH_CNTRL_VW1
|
| 35 |
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.
Y/N Table Edit
Default Value: N
|
| 36 |
EM_EXPOSE_CFS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Expose ChartFields to Supplier
Y/N Table Edit
Default Value: N
|
| 37 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 38 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
%EDITTABLE
|
| 39 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table:
%EDITTABLE2
|
| 40 |
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
Prompt Table:
EM_BANK_MTHD_V2
|
| 41 |
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
Default Value: 0
|
| 42 |
EM_CPY_ONE_PO_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
If option is selected allows the Buyer/Supplier agreement to restrict a supplier to copy from one and only one PO.
Y/N Table Edit
Default Value: N
|
| 43 |
EM_ALLOW_PTRMS_OVR |
Character(1) |
VARCHAR2(1) NOT NULL |
If selected, the Supplier can modify the payment terms on the Agreement sent from the Buyer. If not selected than the Payment Terms on the agreement is set to display only for the supplier.
Y/N Table Edit
Default Value: Y
|
| 44 |
EM_USE_PTRMS_FROM |
Character(1) |
VARCHAR2(1) NOT NULL |
Defines if the default payment terms of the agreement are defaulted from the agreement (default) , from the PO or defaulted from hierarchy
A=Agreement
D=Default from higher level
P=Purchase Order
Default Value: D
|
| 45 |
PYMNT_TERMS_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
|
| 46 |
EM_WORKFLOW_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine workflow defaulting.
D=Default
S=Specify
|
| 47 |
EM_MG_COMMENTS |
Character(254) |
VARCHAR2(254) NOT NULL |
This field stores the comments made by the buyer.
|
| 48 |
CREATED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 49 |
CREATE_DATE |
Date(10) |
DATE |
Creation Date
|
| 50 |
LAST_UPDATED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
LastUpdatedUser
|
| 51 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
|
| 52 |
COUNTER |
Number(10,0) |
DECIMAL(10) NOT NULL |
Counter
|
| 53 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 54 |
EM_NEW_AGREEMENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Agreement Id
|
| 55 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 56 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 57 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 58 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 59 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
|