PeopleSoft 9
Account Payables

Table Name BANK_STATIN_EC

Table Description
BANK_STATIN_EC
Columns
Name Datatype Is PK Is FK
ECQUEUEINSTANCE int Yes Yes
ECTRANSID VARCHAR(15) Yes Yes
ECTRANSINOUTSW VARCHAR(1) Yes Yes
CREATE_DATE PSDATE Yes No
CURRENCY_INDEX VARCHAR(1) No No
RECV_CHIEF_CODE VARCHAR(5) No No
RECV_BANK_ID_NUM VARCHAR(5) No No
DRAWEE_BRANCH_ID VARCHAR(5) No No
DRAWEE_ACCT_NUM VARCHAR(11) No No
DRAWEE_NAME VARCHAR(24) No No
PROC_CENTER VARCHAR(6) No No
Index
Name Type Unique Member
PS_BANK_STATIN_EC PK Yes
PS0BANK_STATIN_EC IE1 No
PS1BANK_STATIN_EC IE2 No
PS2BANK_STATIN_EC IE3 No
Member(s) of "PS_BANK_STATIN_EC" Index
ECQUEUEINSTANCE
ECTRANSID
ECTRANSINOUTSW
CREATE_DATE
Member(s) of "PS0BANK_STATIN_EC" Index
RECV_BANK_ID_NUM
ECQUEUEINSTANCE
ECTRANSID
ECTRANSINOUTSW
CREATE_DATE
Member(s) of "PS1BANK_STATIN_EC" Index
DRAWEE_BRANCH_ID
ECQUEUEINSTANCE
ECTRANSID
ECTRANSINOUTSW
CREATE_DATE
Member(s) of "PS2BANK_STATIN_EC" Index
DRAWEE_ACCT_NUM
ECQUEUEINSTANCE
ECTRANSID
ECTRANSINOUTSW
CREATE_DATE

Published June 06, 2007