RCN_FIELD_TBL(SQL Table) |
Index Back |
|---|---|
Recon column recordThis record is used in Reconciliation to define the type of columns that will be used in the reconciliation. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RCN_RECORD_TBL |
| 2 | RCN_FIELD_ALIAS |
Character(30) | VARCHAR2(30) NOT NULL | Reconciliation field/record alias name -- user or system defined |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: RCN_RECFIELD_VW |
| 4 | RCN_FIELD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
For reconciliation, this is either a transaction or a statement line
0=Statement 1=Transaction 2=BnkStmtWork 4=Work Statement Table 5=AE Temporary Table |
| 5 | RCN_FLD_TOLERANCE | Character(1) | VARCHAR2(1) NOT NULL |
For reconciliation, this field determines if a column has either a date or amount tolerance.
0=Not Applicable 1=Amount Tolerance 2=Date Tolerance Default Value: 0 |
| 6 | RCN_ATTR_AMT | Character(1) | VARCHAR2(1) NOT NULL |
Allow amount tolerances in performing reconciliation
Y/N Table Edit Default Value: N |
| 7 | RCN_ATTR_DT | Character(1) | VARCHAR2(1) NOT NULL |
Allow Date tolerances in performing reconciliation
Y/N Table Edit Default Value: N |
| 8 | RCN_REQUIRED_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Reconciliation flag to determine if the field is system defined (required) or defined by the user
Y/N Table Edit Default Value: N |