PeopleSoft 9
Account Payables

Table Name AP_SESSN_DFL_HD

Table Description
AP_SESSN_DFL_HD
Columns
Name Datatype Is PK Is FK
AP_DFLT_TYPE VARCHAR(1) Yes No
OPRCLASS VARCHAR(30) Yes No
OPRID VARCHAR(30) Yes No
AP_SESSION_NAME VARCHAR(30) Yes No
ACTIVE_FLAG VARCHAR(1) No No
BUSINESS_UNIT VARCHAR(5) No No
VENDOR_ID VARCHAR(10) No No
VNDR_LOC VARCHAR(10) No No
ADDRESS_SEQ_NUM INT No No
GRP_AP_ID VARCHAR(10) No No
ORIGIN VARCHAR(3) No No
ACCOUNTING_DT datetime No No
PYMNT_TERMS_CD VARCHAR(5) No No
TXN_CURRENCY_CD VARCHAR(3) No No
RT_TYPE VARCHAR(5) No No
BUSINESS_UNIT_PO VARCHAR(5) No No
BUSINESS_UNIT_RECV VARCHAR(5) No No
VCHR_BLD_CODE VARCHAR(6) No No
VCHR_DFLT_OPT VARCHAR(1) No No
DST_CNTRL_ID VARCHAR(10) No No
MISC_CHARGE_CODE VARCHAR(10) No No
SALETX_CHARGE_CODE VARCHAR(10) No No
FRGHT_CHARGE_CODE VARCHAR(10) No No
VCHR_QV_TEMPLATE VARCHAR(1) No No
CONF_MISC_OPTION VARCHAR(1) No No
CONF_FRGT_OPTION VARCHAR(1) No No
CONF_SLTX_OPT VARCHAR(1) No No
CONF_VAT_OPT VARCHAR(1) No No
CONF_PO_OPTION VARCHAR(1) No No
CONF_RECV_OPTION VARCHAR(1) No No
VCHR_TTL_LINES INT No No
TOTAL_DISTRIBS INT No No
Index
Name Type Unique Member
PS_AP_SESSN_DFL_HD PK Yes
Member(s) of "PS_AP_SESSN_DFL_HD" Index
AP_DFLT_TYPE
OPRCLASS
OPRID
AP_SESSION_NAME

Published June 06, 2007