FORMAT_IDPROP_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_FORMAT_PROP(SQL Table) |
Index Back |
|---|---|
Format Definition PropertiesFormat Definition Properties |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FORMAT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Format ID |
| 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 |