PeopleSoft 9
Account Payables

Table Name BANK_STATIN2_EC

Table Description
BANK_STATIN2_EC
Columns
Name Datatype Is PK Is FK
ECQUEUEINSTANCE int Yes Yes
ECTRANSID VARCHAR(15) Yes Yes
ECTRANSINOUTSW VARCHAR(1) Yes Yes
DRAWEE_BRANCH_ID VARCHAR(5) Yes No
DRAWEE_ACCT_NUM VARCHAR(11) Yes No
DRAWER_REF VARCHAR(10) Yes No
BANK_SEQ_NUM int Yes No
BANK_OPER_NUM VARCHAR(2) No No
PYMNT_DT PSDATE No No
CURRENCY_INDEX VARCHAR(1) No No
ISSUER_BANK_ID_NUM VARCHAR(5) No No
ISSUER_BRANCH_ID VARCHAR(5) No No
DRAWER_ACCT_NUM VARCHAR(11) No No
DRAWER_NAME VARCHAR(24) No No
DRAFT_DUE_DT PSDATE No No
RECV_CHIEF_CODE VARCHAR(5) No No
RECV_BANK_ID_NUM VARCHAR(5) No No
DRAWEE_NAME VARCHAR(24) No No
REMIT_PERSON_REF VARCHAR(8) No No
BRIEF_DESCR VARCHAR(24) No No
DRAFT_CREATE_DT PSDATE No No
ACCEPT_CODE VARCHAR(1) No No
DRAWEE_REF VARCHAR(10) No No
BANK_ORDER_NUM VARCHAR(8) No No
DRAFT_AMT decimal(26,3) No No
REJECT_CODE VARCHAR(2) No No
NEW_AMT_REM decimal(26,3) No No
Index
Name Type Unique Member
PS_BANK_STATIN2_EC PK Yes
Member(s) of "PS_BANK_STATIN2_EC" Index
ECQUEUEINSTANCE
ECTRANSID
ECTRANSINOUTSW
DRAWEE_BRANCH_ID
DRAWEE_ACCT_NUM
DRAWER_REF
BANK_SEQ_NUM

Published June 06, 2007