CHNG_MAP_TMPLT_IDRECNAME_TARGETFIELDTYPEDefault Value: 0
FIELDNUMFIELDNAME_TARGETPrompt Table: PO_RCFLD_TAR_VW
Prompt Table: PO_RCFLD_SRC_VW
CHNG_MAP_RECFLD(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHNG_MAP_TMPLT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Change Template ID |
| 2 | RECNAME_TARGET |
Character(15) | VARCHAR2(15) NOT NULL | Target Recname |
| 3 | FIELDTYPE |
Number(2,0) | SMALLINT NOT NULL |
Field Type (from PSST0101 Ref.)
Default Value: 0 |
| 4 | FIELDNUM |
Number(4,0) | SMALLINT NOT NULL | Field Number |
| 5 | FIELDNAME_TARGET |
Character(18) | VARCHAR2(18) NOT NULL |
Allocations Target amount field
Prompt Table: PO_RCFLD_TAR_VW |
| 6 | RECNAME_SOURCE | Character(15) | VARCHAR2(15) NOT NULL | Source Recname |
| 7 | FIELDNAME_SOURCE | Character(18) | VARCHAR2(18) NOT NULL |
Source Fieldname
Prompt Table: PO_RCFLD_SRC_VW |