FF_FILE_NAMEFF_VERSIONFF_SECTIONID1=Header
2=Detail
3=Group
4=Trailer
Prompt Table: %EDITTABLE
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
FF_SECTIONS(SQL Table) |
Index Back |
|---|---|
Flat file query settingsFlat file query settings |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FF_FILE_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Flat file name |
| 2 | FF_VERSION |
Character(30) | VARCHAR2(30) NOT NULL | Message Version |
| 3 | FF_SECTIONID |
Character(30) | VARCHAR2(30) NOT NULL | Flat file section type |
| 4 | FF_SECTIONTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Flat file section type
1=Header 2=Detail 3=Group 4=Trailer |
| 5 | FF_SECTIONSEQ | Number(3,0) | SMALLINT NOT NULL | Flat file section |
| 6 | FF_DSVALUE | Character(30) | VARCHAR2(30) NOT NULL |
Flat file data source value
Prompt Table: %EDITTABLE |
| 7 | DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data S=Sample Data Y=System Data Default Value: N |