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 |