EM_AGMT_PAY_TBL

(SQL Table)
Index Back

EBPP Agreement Payment Terms.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

2 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Prompt Table: SETID_TBL

3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: EM_VENDOR_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
6 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