PeopleSoft 9
Account Payables

Table Name AP_ASSTN_ALGTHM

Table Description
AP_ASSTN_ALGTHM
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
ASSTN_ALG_NAME VARCHAR(15) Yes Yes
LINE_NBR INT Yes No
SEQ_NUM SMALLINT No No
STEP_NAME VARCHAR(40) No No
AMT_ONLY_FLG VARCHAR(1) No No
DRIVER_FLDNAME VARCHAR(18) No No
ASSTN_FLDNAME VARCHAR(18) No No
ALGTHM_BEHAVIOR VARCHAR(4) No No
JOIN_CRIT_SQLID VARCHAR(30) No No
HAVING_SQLID VARCHAR(30) No No
Index
Name Type Unique Member
PS_AP_ASSTN_ALGTHM PK Yes
Member(s) of "PS_AP_ASSTN_ALGTHM" Index
SETID
ASSTN_ALG_NAME
LINE_NBR

Published June 06, 2007