PeopleSoft 9
Account Payables

Table Name AP_SESSN_DFL_DT

Table Description
AP_SESSN_DFL_DT
Columns
Name Datatype Is PK Is FK
AP_DFLT_TYPE VARCHAR(1) Yes No
OPRID VARCHAR(30) Yes No
OPRCLASS VARCHAR(30) Yes No
AP_SESSION_NAME VARCHAR(30) Yes No
SEQ_NUM SMALLINT Yes No
BUSINESS_UNIT VARCHAR(5) No No
BUSINESS_UNIT_GL VARCHAR(5) 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
ENTRY_EVENT VARCHAR(10) No No
Index
Name Type Unique Member
PS_AP_SESSN_DFL_DT PK Yes
Member(s) of "PS_AP_SESSN_DFL_DT" Index
AP_DFLT_TYPE
OPRID
OPRCLASS
AP_SESSION_NAME
SEQ_NUM

Published June 06, 2007