RECNAMEPrompt Table: RECDEFN_NON_VW
LED_FLD_NAMEPrompt Table: CCR_LED_FLD_VW
B=Business Unit Driven
S=Setid Driven
Prompt Table: CCR_BU_FLD_VW
A=Active
I=Inactive
Default Value: A
CCR_RENAME_REC(SQL Table) |
Index Back |
|---|---|
Ledger Analysis |
| # | 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: RECDEFN_NON_VW |
| 2 | LED_FLD_NAME |
Character(18) | VARCHAR2(18) NOT NULL |
Ledger Field Name
Prompt Table: CCR_LED_FLD_VW |
| 3 | SETID_BU_DRIVEN | Character(1) | VARCHAR2(1) NOT NULL |
Setid or BU Driven
B=Business Unit Driven S=Setid Driven |
| 4 | FIELDNAME_BU | Character(18) | VARCHAR2(18) NOT NULL |
Business Unit Field Name
Prompt Table: CCR_BU_FLD_VW |
| 5 | ACTIVE_INACT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Record?
A=Active I=Inactive Default Value: A |