COMBO_EDIT_TMPL(SQL Table) | 
Index Back | 
|---|---|
Combination Editing Templates | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | 
Record Template
 Prompt Table: COMBO_EDIT_TMPL  | 
|
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description | 
| 3 | RECNAME_HEADER | Character(15) | VARCHAR2(15) NOT NULL | 
Header Record
 Prompt Table: RECDEFN_VW  | 
| 4 | RECNAME_LINE | Character(15) | VARCHAR2(15) NOT NULL | 
Line Record
 Prompt Table: RECDEFN_VW  | 
| 5 | RECNAME_UPD_HEADER | Character(15) | VARCHAR2(15) NOT NULL | 
Update Header Record
 Prompt Table: RECDEFN_VW  | 
| 6 | RECNAME_UPD_LINE | Character(15) | VARCHAR2(15) NOT NULL | 
Update Line Record
 Prompt Table: RECDEFN_VW  | 
| 7 | FIELDNAME_TRN_DATE | Character(18) | VARCHAR2(18) NOT NULL | 
Transaction Date
 Prompt Table: RECFIELD_HDR_VW  | 
| 8 | FIELDNAME_BU_GL | Character(18) | VARCHAR2(18) NOT NULL | 
Business Unit GL Field Name
 Prompt Table: RECFIELD_LN_VW  | 
| 9 | FIELDNAME_FRN_CUR | Character(18) | VARCHAR2(18) NOT NULL | 
Foreign Currency
 Prompt Table: RECFIELD_LN_VW  | 
| 10 | RECNAME_HDR_ERRLOG | Character(15) | VARCHAR2(15) NOT NULL | 
Header Error Log
 Prompt Table: TSE_RECFLD_VW  | 
| 11 | RECNAME_LN_ERRLOG | Character(15) | VARCHAR2(15) NOT NULL | 
Line Error Log
 Prompt Table: TSE_RECFLD_VW  | 
| 12 | MAP_OPTN | Character(1) | VARCHAR2(1) NOT NULL | 
Map Option
 B=PS/BI C=PS/PC E=PS/EXP G=PS/GL H=PS/HR I=PS/IN M=PS/AM N=PS/CA P=PS/AP R=PS/AR T=PS/TR U=PS/PO X=PS/GM  |