BUSINESS_UNITTR_SOURCE_IDREV_LC_FEE_VW(SQL View) |
Index Back |
|---|---|
Reversal Acctg LC Fee ViewPrompt for LC Fee accounting entries. Used by Reverse Accounting Request run control. PeopleCode: REV_ACCTG_REQ.TRA_SOURCE_CD - FieldChange and RowInit |
| SELECT DISTINCT BUSINESS_UNIT , %Substring(EVENT_ID,1,12) FROM PS_TRA_ACCTG_HDR WHERE TRA_SOURCE_CD = 'T' AND ERROR_STATUS = '1' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | TR_SOURCE_ID |
Character(12) | VARCHAR2(12) NOT NULL | An internal work field that represents a unique identifier for records depicting a given treasury po |