EM_MG_DUP_VW (SQL View)	Index Back
Master Agreements Master Agreements

EM_MG_DUP_VW

(SQL View)

Master Agreements

SELECT a.setid , 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_allow_ptrms_ovr , a.em_use_ptrms_from , a.pymnt_terms_cd , a.em_agreement_id 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
Prompt Table: EM_MG_SETID_VW

2 MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Requires Matching
Y/N Table Edit

3 MATCH_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Match Rule
Prompt Table: MTCH_CNTRL_VW1

4 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

5 EM_EXPOSE_CFS_FLG Character(1) VARCHAR2(1) NOT NULL Expose ChartFields to Supplier
Y/N Table Edit

6 BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID associated with a given bank/counterparty.

7 BANK_CD Character(5) VARCHAR2(5) NOT NULL Bank Code
Prompt Table: %EDITTABLE

8 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

9 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

10 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

11 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

12 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

13 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

14 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

15 EM_AGREEMENT_ID Character(10) VARCHAR2(10) NOT NULL Agreement Id
Prompt Table: EM_MG_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: EM_MG_SETID_VW
2	MATCH_OPT	Character(1)	VARCHAR2(1) NOT NULL	Requires Matching Y/N Table Edit
3	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule Prompt Table: MTCH_CNTRL_VW1
4	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
5	EM_EXPOSE_CFS_FLG	Character(1)	VARCHAR2(1) NOT NULL	Expose ChartFields to Supplier Y/N Table Edit
6	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
7	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: %EDITTABLE
8	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
9	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
10	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
11	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
12	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
13	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
14	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
15	EM_AGREEMENT_ID	Character(10)	VARCHAR2(10) NOT NULL	Agreement Id Prompt Table: EM_MG_TBL