PeopleSoft 9
Account Payables

Table Name SMT_SPLIT_HDR

Table Description
SMT_SPLIT_HDR
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
SMT_SPLIT_ID VARCHAR(5) Yes No
CURRENCY_CD VARCHAR(3) Yes No
EFFDT datetime Yes No
EFF_STATUS VARCHAR(1) No No
DESCR50 VARCHAR(50) No No
DESCRSHORT VARCHAR(10) No No
AMOUNT DECIMAL(26,3) 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
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_HDR PK Yes
Member(s) of "PS_SMT_SPLIT_HDR" Index
SETID
SMT_SPLIT_ID
CURRENCY_CD
EFFDT

Published June 06, 2007