PeopleSoft 9
Account Payables

Table Name PAYMENT_TBL

Table Description
PAYMENT_TBL
Columns
Name Datatype Is PK Is FK
BANK_SETID VARCHAR(5) Yes No
BANK_CD VARCHAR(5) Yes Yes
BANK_ACCT_KEY VARCHAR(4) Yes Yes
PYMNT_ID VARCHAR(10) Yes No
PYMNT_ID_REF VARCHAR(20) No No
SCHEDULE_ID VARCHAR(10) No No
BANK_ACCOUNT_NUM VARCHAR(17) No No
BRANCH_ID VARCHAR(10) No No
CHECK_DIGIT VARCHAR(2) No No
REMIT_SETID VARCHAR(5) No No
REMIT_VENDOR VARCHAR(10) No No
VNDR_LOC VARCHAR(10) No No
EMPLID VARCHAR(11) No No
NAME1 VARCHAR(40) No No
NAME2 VARCHAR(40) No No
COUNTRY VARCHAR(3) No No
ADDRESS1 VARCHAR(55) No No
ADDRESS2 VARCHAR(55) No No
ADDRESS3 VARCHAR(55) No No
ADDRESS4 VARCHAR(55) No No
CITY VARCHAR(30) No No
NUM1 VARCHAR(6) No No
NUM2 VARCHAR(4) No No
HOUSE_TYPE VARCHAR(2) No No
ADDR_FIELD1 VARCHAR(2) No No
ADDR_FIELD2 VARCHAR(4) No No
ADDR_FIELD3 VARCHAR(4) No No
COUNTY VARCHAR(30) No No
STATE VARCHAR(6) No No
POSTAL VARCHAR(12) No No
GEO_CODE VARCHAR(11) No No
IN_CITY_LIMIT VARCHAR(1) No No
PYMNT_DT PSDATE No No
CREATION_DT PSDATE No No
OPRID VARCHAR(30) No No
PYMNT_AMT decimal(26,3) No No
CURRENCY_PYMNT VARCHAR(3) No Yes
PYMNT_METHOD VARCHAR(3) No No
PYMNT_HANDLING_CD VARCHAR(2) No No
PYMNT_STATUS VARCHAR(1) No No
PYMNT_RECONCILE_DT PSDATE No No
CANCEL_ACTION VARCHAR(1) No No
CANCEL_DT PSDATE No No
DFT_STATUS VARCHAR(1) No No
ACCOUNTING_DT PSDATE No No
POST_STATUS_AP VARCHAR(1) No No
PROCESS_INSTANCE decimal(10) No No
PAY_CYCLE VARCHAR(6) No No
PAY_CYCLE_SEQ_NUM int No No
RECON_TYPE VARCHAR(1) No No
RECON_CYCLE_NBR decimal(10) No No
RECONCILE_OPRID VARCHAR(30) No No
BNK_ID_NBR VARCHAR(20) No No
RECON_STATUS VARCHAR(3) No No
DFI_ID_NUM VARCHAR(12) No No
DFI_ID_QUAL VARCHAR(2) No No
EFT_PYMNT_FMT_CD VARCHAR(3) No Yes
STTLMNT_DT_EST PSDATE No No
STTLMNT_DT_ACTUAL PSDATE No No
EFT_TRANS_HANDLING VARCHAR(1) No No
REMIT_BANK_ACCOUNT VARCHAR(17) No No
REMIT_BRANCH_ID VARCHAR(10) No No
REMIT_CHECK_DIGIT VARCHAR(2) No No
REP_RTNG_NUM VARCHAR(10) No No
FORM_NBR_CONFIRMED VARCHAR(1) No No
IN_PROCESS_FLG VARCHAR(1) No No
POSITIVE_PAY_DT PSDATE No No
POSITIVE_PAY_STAT VARCHAR(1) No No
MICR_LINE VARCHAR(50) No No
CASH_CLEARED_FLG VARCHAR(1) No No
CASH_CLEARED_DT PSDATE No No
REPLACED_DT PSDATE No No
PYMNT_TYPE VARCHAR(1) No No
PREFERRED_LANGUAGE VARCHAR(3) No No
DOC_TYPE VARCHAR(8) No No
DOC_SEQ_DATE PSDATE No No
DOC_SEQ_NBR VARCHAR(12) No No
DOC_SEQ_STATUS VARCHAR(1) No No
SOURCE_TXN VARCHAR(4) No No
BRANCH_NAME VARCHAR(10) No No
LC_ID VARCHAR(12) No No
BUSINESS_UNIT_GL VARCHAR(5) No No
DFT_MASTER_ID VARCHAR(10) No No
DFT_CONTROL_ID VARCHAR(20) No No
DFT_STMP_TAX_AMT decimal(26,3) No No
DFT_DRAWEE VARCHAR(40) No No
DFT_APPROVAL_DT PSDATE No No
DFT_MAT_DT PSDATE No No
DFT_WO_ACCT VARCHAR(10) No No
DFT_WO_DT PSDATE No No
DFT_OPT_FLG VARCHAR(1) No No
DFT_APPROVE_FLAG VARCHAR(1) No No
ACHIEVE_DT PSDATE No No
DFT_TYPE VARCHAR(1) No No
ESCHEATED_DT PSDATE No No
USER_PYMNT_CHAR1 VARCHAR(1) No No
USER_PYMNT_CHAR2 VARCHAR(1) No No
USER_PYMNT_DATE PSDATE No No
USER_PYMNT_DEC decimal(26,3) No No
USER_PYMNT_NUM SMALLINT No No
VALUE_DT PSDATE No No
DFT_WO_ALTACCT VARCHAR(10) No No
CANCEL_POST_STATUS VARCHAR(1) No No
TREASURY_PMT_NBR decimal(11) No No
SINGLE_PYMNT_FLG VARCHAR(1) No No
IPAC_PYMNT_FLG VARCHAR(1) No No
BANK_ACCT_RVL_AMT decimal(26,3) No No
RECON_RUN_ID VARCHAR(15) No No
EFT_LAYOUT_CD VARCHAR(10) No No
PMT_ID VARCHAR(15) No No
BANK_REF_ID VARCHAR(16) No No
STL_THROUGH VARCHAR(2) No No
PMT_PYMNT_STATUS VARCHAR(1) No No
BATCH_ID VARCHAR(18) No No
RECORD_SEQ_NUMBER DECIMAL(10) No No
PYMNT_HOLD_REASON VARCHAR(3) No No
DESCRLONG CLOB No No
Index
Name Type Unique Member
PS_PAYMENT_TBL PK Yes
PS0PAYMENT_TBL IE13 No
PSAPAYMENT_TBL IE14 No
PSBPAYMENT_TBL IE15 No
PSDPAYMENT_TBL IE16 No
Member(s) of "PS_PAYMENT_TBL" Index
BANK_SETID
BANK_CD
BANK_ACCT_KEY
PYMNT_ID
Member(s) of "PS0PAYMENT_TBL" Index
PYMNT_ID_REF
BANK_SETID
BANK_CD
BANK_ACCT_KEY
PYMNT_ID
Member(s) of "PSAPAYMENT_TBL" Index
BANK_SETID
BANK_CD
BANK_ACCT_KEY
PYMNT_ID_REF
PYMNT_STATUS
Member(s) of "PSBPAYMENT_TBL" Index
PYMNT_ID_REF
PYMNT_STATUS
RECON_TYPE
Member(s) of "PSDPAYMENT_TBL" Index
BNK_ID_NBR
BANK_ACCOUNT_NUM
PYMNT_ID_REF
PYMNT_METHOD

Published June 06, 2007