| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
LC_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Treasury Letter of Credit Number Assigned by the System
|
| 3 |
LC_AMEND_DT |
Date(10) |
DATE |
L/C Amendment Date is used to identify the date a critical contractural item is changed.
|
| 4 |
LC_AMEND_NBR |
Character(10) |
VARCHAR2(10) NOT NULL |
Letter of Credit amendment number from the bank.
|
| 5 |
LC_FIELD_NM |
Character(20) |
VARCHAR2(20) NOT NULL |
Name of L/C significant field being amended.
|
| 6 |
LC_FIELD_BFR |
Character(20) |
VARCHAR2(20) NOT NULL |
Content of L/C significant field before amendment.
|
| 7 |
LC_FIELD_AFT |
Character(20) |
VARCHAR2(20) NOT NULL |
Content of L/C significant field after amendment.
|
| 8 |
USER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
|
| 9 |
DATE_PROCESSED |
DateTime(26) |
TIMESTAMP |
Date Processed
|
| 10 |
DESCR20_MIXED |
Character(20) |
VARCHAR2(20) NOT NULL |
Description 20 characters, mixed case
|