| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EM_AGREEMENT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Agreement Id
Default Value: NEXT
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
EM_MG_SETID_VW
|
| 3 |
AGREEMENT_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Master Agreement Name
|
| 4 |
MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Matching
Y/N Table Edit
Default Value: N
|
| 5 |
MATCH_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Match Rule
Default Value: STANDARD
Prompt Table:
MTCH_CNTRL_VW1
|
| 6 |
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
|
| 7 |
EM_EXPOSE_CFS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Expose ChartFields to Supplier
Y/N Table Edit
Default Value: N
|
| 8 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 9 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
%EDITTABLE
|
| 10 |
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
|
| 11 |
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
|
| 12 |
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
|
| 13 |
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
|
| 14 |
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
|
| 15 |
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
|
| 16 |
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.
Prompt Table:
PYMT_TR_EFF_VW
Set Control Field: SETID
|
| 17 |
EM_WORKFLOW_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to determine workflow defaulting.
D=Default
S=Specify
Default Value: D
|
| 18 |
EM_MG_CF_COMBO |
Number(9,0) |
DECIMAL(9) NOT NULL |
Chartfield Combination ID
|
| 19 |
EM_MG_COMMENTS |
Character(254) |
VARCHAR2(254) NOT NULL |
This field stores the comments made by the buyer.
|
| 20 |
CREATED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 21 |
CREATE_DATE |
Date(10) |
DATE |
Creation Date
|
| 22 |
LAST_UPDATED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
LastUpdatedUser
|
| 23 |
LAST_UPDATE_DATE |
Date(10) |
DATE |
Date of last update
|