BUSINESS_UNIT_GLREQUIRED_FLDAMT=Amount and Currency
DAT=Date
DEC=Description
EXP=Expense Type
MAR=Merchant
PAY=Payment Method
Y/N Table Edit
EX_TXT_FIELDS(SQL Table) |
Index Back |
|---|---|
Required Text FieldsRequired Text Fields for Message Send |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_GL |
Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 2 | REQUIRED_FLD |
Character(3) | VARCHAR2(3) NOT NULL |
Required Field
AMT=Amount and Currency DAT=Date DEC=Description EXP=Expense Type MAR=Merchant PAY=Payment Method |
| 3 | REQ_FLD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Required Field Flag
Y/N Table Edit |
| 4 | SEQ_NBR1 | Number(4,0) | SMALLINT NOT NULL | Sequence Number |