BUSINESS_UNITBAX_TEMPLATE_ID00=Internal Transfer
01=External Transfer
BAX_TEMPLATE_V2(SQL View) |
Index Back |
|---|---|
Bank Transfer Template View |
| SELECT BUSINESS_UNIT ,BAX_TRANSFER_ID ,TRANSFER_TYPE ,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 | BAX_TEMPLATE_ID |
Character(12) | VARCHAR2(12) NOT NULL | An unique key identifier that represents a bank transfer transaction template. |
| 3 | TRANSFER_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Transfer Type
00=Internal Transfer 01=External Transfer |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |