PYCYCL_MAP_DTL(SQL Table) |
Index Back |
|---|---|
Payment mapping details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SOURCE_TXN |
Character(4) | VARCHAR2(4) NOT NULL |
Source Transaction
Prompt Table: PYMNT_SOURCE |
| 2 | MAP_TYPE |
Character(2) | VARCHAR2(2) NOT NULL |
Map Type
D1=Pay Cycle Data D2=Payment Data (Child) V1=Prenote Data W1=Withholding Data W2=Withholding Data (Child) Default Value: PYCYCL_MAP_HDR.MAP_TYPE |
| 3 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 4 | MAP_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Mapping Action
B=Both I=Input N=None O=Output Default Value: N |
| 5 | MAP_TYPE_IN | Character(1) | VARCHAR2(1) NOT NULL |
Input Map Type
C=Constant F=Field Default Value: F |
| 6 | CONST_TYPE_IN | Character(1) | VARCHAR2(1) NOT NULL |
Input Constant Type
C=Character N=Numeric Default Value: C |
| 7 | FIELDNAME_IN | Character(18) | VARCHAR2(18) NOT NULL |
Input Fieldname
Prompt Table: PYCYCL_MAP_VW |
| 8 | CONSTANT_IN | Character(18) | VARCHAR2(18) NOT NULL | Input Constant |
| 9 | FIELDNAME_OUT | Character(18) | VARCHAR2(18) NOT NULL |
Output Fieldname
Prompt Table: PYCYCL_MAP_VW4 |
| 10 | KEY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Key Field
Y/N Table Edit Default Value: N |