BAX_TEMPLATE_VW

(SQL View)
Index Back

Bank Transfer Template View


SELECT BUSINESS_UNIT ,TRANSFER_TYPE ,BAX_TRANSFER_ID ,DESCR FROM PS_BAX_HEADER_TR WHERE TEMPLATE_SW='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 TRANSFER_TYPE Character(2) VARCHAR2(2) NOT NULL Transfer Type
00=Internal Transfer
01=External Transfer
3 BAX_TEMPLATE_ID Character(12) VARCHAR2(12) NOT NULL An unique key identifier that represents a bank transfer transaction template.
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description