BNK_CRD_LOC_VW

(SQL View)
Index Back

Credit Card Store Prompt View


select distinct BNK_ID_NBR, BANK_ACCOUNT_NUM, REMIT_LOCATION from PS_BNK_STMT_CRD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BNK_ID_NBR Character(20) VARCHAR2(20) NOT NULL A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
2 BANK_ACCOUNT_NUM Character(35) VARCHAR2(35) NOT NULL The literal unique identifier associated with a given bank/counterparty account.
3 REMIT_LOCATION Character(10) VARCHAR2(10) NOT NULL Represents the physical location as to where a point of sale transaction took place. The field i