EFT_LAYOUT_CDPROP_CODEACT=Account
BNK=Bank
SYS=System
Default Value: BNK
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
N=Number
S=String
YN=Yes/No
Default Value: S
1=List of Values
2=All Code Map Groups
PMT_FRMT_PRP_VW(SQL View) |
Index Back |
|---|---|
Format Definition PropertiesFormat Definition Properties |
| SELECT A.FORMAT_ID , A.PROP_CODE , A.PROP_LEVEL , A.PROP_SEQ_NUM , A.DESCR254 , A.REQUIRED_FLG , A.READONLY , A.PROP_TYPE , A.PROP_MAX_LENGTH , A.PROP_DFLT_VALUE , A.LIST_OPTION FROM PS_PMT_FORMAT_PROP A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EFT_LAYOUT_CD |
Character(10) | VARCHAR2(10) NOT NULL | EFT Layout Code |
| 2 | PROP_CODE |
Character(15) | VARCHAR2(15) NOT NULL | Property code |
| 3 | PROP_LEVEL | Character(3) | VARCHAR2(3) NOT NULL |
Property Level
ACT=Account BNK=Bank SYS=System Default Value: BNK |
| 4 | PROP_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 5 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 6 | REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Required Flag
Y/N Table Edit Default Value: N |
| 7 | READONLY | Character(1) | VARCHAR2(1) NOT NULL |
Read Only
Y/N Table Edit Default Value: N |
| 8 | PROP_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Property Type
N=Number S=String YN=Yes/No Default Value: S |
| 9 | PROP_MAX_LENGTH | Number(3,0) | SMALLINT NOT NULL | Maximum Length |
| 10 | PROP_DFLT_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Default Value |
| 11 | LIST_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Code Map Group or List of Values
1=List of Values 2=All Code Map Groups |