PeopleSoft 9
Account Payables

Table Name EM_AGREEMENT

Table Description
EM_AGREEMENT
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
VENDOR_SETID VARCHAR(5) Yes No
VENDOR_ID VARCHAR(10) Yes Yes
VNDR_LOC VARCHAR(10) Yes No
MATCH_OPT VARCHAR(1) No No
MATCH_CNTRL_ID VARCHAR(10) No No
EM_STD_VCH_FLG VARCHAR(1) No No
EM_SUPPLIER_REF VARCHAR(10) No No
EM_CASH_COL_NOT VARCHAR(1) No No
EM_CC_LATEDAYS SMALLINT No No
EM_CC_REMINDER SMALLINT No No
EM_READY_FOR_REV VARCHAR(1) No No
EM_AGREE_BUYER VARCHAR(1) No No
EM_AGREE_SELLER VARCHAR(1) No No
EM_CUSTOMER_REF VARCHAR(15) No No
EM_EXPOSE_CFS_FLG VARCHAR(1) No No
EM_FACTOR_FLAG VARCHAR(1) No No
EM_FACTOR_ID VARCHAR(10) No No
REMIT_LOC VARCHAR(10) No No
EM_BUYER_COMMENTS VARCHAR(254) No No
EM_SELLER_COMMENTS VARCHAR(254) No No
EM_PYMNT_TERMS_OPT VARCHAR(1) No No
BANK_SETID VARCHAR(5) No No
BANK_CD VARCHAR(5) No No
BANK_ACCT_KEY VARCHAR(4) No No
PYMNT_METHOD VARCHAR(3) No No
WORKFLOW_OPT VARCHAR(1) No No
EM_WORKFLOW_OPT VARCHAR(1) No No
EM_INV_VERIFY_OPT VARCHAR(1) No No
ACCOUNT VARCHAR(10) No No
ALTACCT VARCHAR(10) No No
DEPTID VARCHAR(10) No No
OPERATING_UNIT VARCHAR(8) No No
PRODUCT VARCHAR(6) No No
FUND_CODE VARCHAR(5) No No
CLASS_FLD VARCHAR(5) No No
PROGRAM_CODE VARCHAR(5) No No
BUDGET_REF VARCHAR(8) No No
AFFILIATE VARCHAR(5) No No
AFFILIATE_INTRA1 VARCHAR(10) No No
AFFILIATE_INTRA2 VARCHAR(10) No No
CHARTFIELD1 VARCHAR(10) No No
CHARTFIELD2 VARCHAR(10) No No
CHARTFIELD3 VARCHAR(10) No No
BUSINESS_UNIT_PC VARCHAR(5) No No
PROJECT_ID VARCHAR(15) No No
ACTIVITY_ID VARCHAR(15) No No
RESOURCE_TYPE VARCHAR(5) No No
RESOURCE_CATEGORY VARCHAR(5) No No
RESOURCE_SUB_CAT VARCHAR(5) No No
ANALYSIS_TYPE VARCHAR(3) No No
Index
Name Type Unique Member
PS_EM_AGREEMENT PK Yes
Member(s) of "PS_EM_AGREEMENT" Index
SETID
VENDOR_SETID
VENDOR_ID
VNDR_LOC

Published June 06, 2007