EM_AGREE_PAY_VW

#	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_SETVC_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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
7	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
8	MATCH_OPT	Character(1)	VARCHAR2(1) NOT NULL	Requires Matching Y/N Table Edit Default Value: N
9	MATCH_CNTRL_ID	Character(10)	VARCHAR2(10) NOT NULL	Match Rule Default Value: STANDARD Prompt Table: MTCH_CNTRL_VW1
10	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
11	EM_SUPPLIER_REF	Character(10)	VARCHAR2(10) NOT NULL	This field is used for the buyer to indicate his internal code for the seller.
12	EM_CASH_COL_NOT	Character(1)	VARCHAR2(1) NOT NULL	Cash Collections Access Y/N Table Edit Default Value: N
13	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).
14	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).
15	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
16	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
17	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
18	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.
19	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
20	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.
21	BANK_SETID	Character(5)	VARCHAR2(5) NOT NULL	The PeopleSoft tableset ID associated with a given bank/counterparty.
22	BANK_CD	Character(5)	VARCHAR2(5) NOT NULL	Bank Code Prompt Table: EM_SP_BKCD_BUV2
23	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: EM_SP_BKAC_BUV2
24	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
25	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.