EM_MG_VW3 (SQL View)	Index Back
View of Master Agreements View of Master Agreements

EM_MG_VW3

(SQL View)

View of Master Agreements

SELECT a.setid , a.em_agreement_id , a.agreement_name , a.match_opt , a.match_cntrl_id , a.em_std_vch_flg , a.em_expose_cfs_flg , a.bank_setid , a.bank_cd , a.bank_acct_key , a.pymnt_method , a.em_inv_verify_opt , a.em_cpy_one_po_only , a.em_use_ptrms_from , a.pymnt_terms_cd , a.em_allow_ptrms_ovr FROM PS_EM_MG_TBL a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 EM_AGREEMENT_ID Character(10) VARCHAR2(10) NOT NULL Agreement Id

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_FLGX 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.
N=No
Y=Yes
Default Value: N

7 EM_EXPOSE_CFS_FLGX Character(1) VARCHAR2(1) NOT NULL Expose ChartFields to Supplier
N=No
Y=Yes
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_ONLX 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.
N=No
Y=Yes
Default Value: N

14 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

15 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

16 EM_ALLOW_PTRMS_OVX 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.
N=No
Y=Yes
Default Value: N

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	EM_AGREEMENT_ID	Character(10)	VARCHAR2(10) NOT NULL	Agreement Id
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_FLGX	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. N=No Y=Yes Default Value: N
7	EM_EXPOSE_CFS_FLGX	Character(1)	VARCHAR2(1) NOT NULL	Expose ChartFields to Supplier N=No Y=Yes 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_ONLX	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. N=No Y=Yes Default Value: N
14	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
15	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
16	EM_ALLOW_PTRMS_OVX	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. N=No Y=Yes Default Value: N