| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
EM_AGREBUSEC_VW
|
| 2 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_VS_NONVW
|
| 3 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
EM_VNREG_SEC_VW
|
| 4 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
EM_VNDR_LOC_VW
|
| 5 |
MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Matching
Y/N Table Edit
Default Value: N
|
| 6 |
MATCH_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Match Rule
Default Value: STANDARD
Prompt Table:
MTCH_CNTRL_VW1
|
| 7 |
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
|
| 8 |
EM_SUPPLIER_REF |
Character(10) |
VARCHAR2(10) NOT NULL |
This field is used for the buyer to indicate his internal code for the seller.
|
| 9 |
EM_CASH_COL_NOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Cash Collections Access
Y/N Table Edit
Default Value: N
|
| 10 |
EM_CC_LATEDAYS |
Number(3,0) |
SMALLINT NOT NULL |
This field stores the number of days after the due date the seller would like to send reminder messages to the buyer. It will be activated if EM_CASH_COL_NOT is Y (Yes).
|
| 11 |
EM_CC_REMINDER |
Number(3,0) |
SMALLINT NOT NULL |
This field stores the number of days after the first reminder to send a second reminder. Will be activated if EM_CASH_COL is Y (Yes).
|
| 12 |
EM_READY_FOR_REV |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag indicates whether a buyer is ready for an agreement to be reviewed by a seller. It triggers an e-mail for the seller.
Y/N Table Edit
Default Value: N
|
| 13 |
EM_AGREE_BUYER |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag indicates whether a buyer agrees with the contract.
Y/N Table Edit
Default Value: N
|
| 14 |
EM_AGREE_SELLER |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag indicates whether the agreement has been agreed to by the seller.
Y/N Table Edit
Default Value: N
|
| 15 |
EM_CUSTOMER_REF |
Character(15) |
VARCHAR2(15) NOT NULL |
This field is used to store the internal number the seller uses for the buyer. It is used by the EAI.
|
| 16 |
EM_EXPOSE_CFS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Expose ChartFields to Supplier
Y/N Table Edit
Default Value: N
|
| 17 |
EM_FACTOR_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This flag indicates whether a factor is to be used.
Y/N Table Edit
Default Value: N
|
| 18 |
EM_FACTOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
If EM_FACTOR_FLAG = "Y", then Factor ID is entered into this field. Factor relationship has to be established in advance. This will be used during Voucher Build to default the Remit To Vendor information.
Prompt Table:
EM_VNDR_SEC_VW
Set Control Field: VENDOR_SETID
|
| 19 |
REMIT_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit to Location
Prompt Table:
EM_FCTR_LOC_VW
|
| 20 |
EM_BUYER_COMMENTS |
Character(254) |
VARCHAR2(254) NOT NULL |
This field stores the comments made by the buyer.
|
| 21 |
EM_SELLER_COMMENTS |
Character(254) |
VARCHAR2(254) NOT NULL |
This field stores the comments made by the seller.
|
| 22 |
EM_PYMNT_TERMS_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows a user to specify whether to accept the default payment terms or specify their own. Used on the Agreement Registration.
D=Default
S=Specify
Default Value: D
|
| 23 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 24 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
%EDITTABLE
|
| 25 |
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
|
| 26 |
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
|
| 27 |
WORKFLOW_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine workflow defaulting.
D=Default
S=Specify
Default Value: D
|
| 28 |
EM_WORKFLOW_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine workflow defaulting.
D=Default
S=Specify
Default Value: D
|
| 29 |
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
|
| 30 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
GL_ACCT_BUGL_VW
|
| 31 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table:
ALT_BUGL_VW
|
| 32 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPTID_BUGL_VW
|
| 33 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table:
OPERUNT_BUGL_VW
|
| 34 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table:
PRODUCT_BUGL_VW
|
| 35 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
FUND_BUGL_VW
|
| 36 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
Prompt Table:
CLASSCF_BUGL_VW
|
| 37 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table:
PROGRAM_BUGL_VW
|
| 38 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table:
BUD_REF_BUGL_VW
|
| 39 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table:
AFFILIATE_VW
|
| 40 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDIT_INTRA01
|
| 41 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDIT_INTRA02
|
| 42 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table:
CF1_BUGL_VW
|
| 43 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
CF2_BUGL_VW
|
| 44 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
CF3_BUGL_VW
|
| 45 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDIT_BU_PC
|
| 46 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
%EDIT_PROJECT
|
| 47 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDIT_ACTIVITY
|
| 48 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
Prompt Table:
PROJ_RESTYPE_FS
Set Control Field: BUSINESS_UNIT_PC
|
| 49 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
Prompt Table:
%EDIT_RES_CAT
Set Control Field: BUSINESS_UNIT_PC
|
| 50 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
Prompt Table:
%EDIT_RES_SUB
Set Control Field: BUSINESS_UNIT_PC
|
| 51 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDIT_ANALYSIS
Set Control Field: BUSINESS_UNIT_PC
|
| 52 |
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
|
| 53 |
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
|
| 54 |
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
|
| 55 |
SPEEDCHART_KEY |
Character(10) |
VARCHAR2(10) NOT NULL |
SpeedChart Key
Prompt Table:
EMSPEEDCHART_VW
|
| 56 |
ACCOUNT_CODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Accounting Tag
Prompt Table:
TAG_SEL_DVW
|
| 57 |
EM_AGREEMENT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Agreement Id
Prompt Table:
EM_MG_VW
|
| 58 |
EM_MG_CF_COMBO |
Number(9,0) |
DECIMAL(9) NOT NULL |
Chartfield Combination ID
|