PeopleSoft 9
Account Payables

Table Name SMT_SPLIT_DTL

Table Description
SMT_SPLIT_DTL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes Yes
SMT_SPLIT_ID VARCHAR(5) Yes Yes
CURRENCY_CD VARCHAR(3) Yes Yes
EFFDT datetime Yes Yes
SEQ_NUM SMALLINT Yes No
ROW_NUMBER SMALLINT Yes No
SMT_SPLIT_PERCENT DECIMAL(11,8) No No
PYMNT_METHOD VARCHAR(3) No No
SMT_TERMS_SETID VARCHAR(5) No No
PYMNT_TERMS_CD VARCHAR(5) No No
SMT_SIGHT_SETID VARCHAR(5) No No
DFT_SIGHT_CD VARCHAR(5) No No
REUSABLE_FLAG VARCHAR(1) No No
BANK_SETID VARCHAR(5) No No
BANK_CD VARCHAR(5) No No
BANK_ACCT_KEY VARCHAR(4) No No
Index
Name Type Unique Member
PS_SMT_SPLIT_DTL PK Yes
Member(s) of "PS_SMT_SPLIT_DTL" Index
SETID
SMT_SPLIT_ID
CURRENCY_CD
EFFDT
SEQ_NUM
ROW_NUMBER

Published June 06, 2007