CP_PRINTCD(SQL Table) |
Index Back |
|---|---|
CP Print CodeCP Print Code Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | CP_PRINT_CODE |
Character(4) | VARCHAR2(4) NOT NULL | Print Code Field |
| 3 | CP_PRINT_CD_DESC | Character(30) | VARCHAR2(30) NOT NULL | Print Code Description Field |
| 4 | CP_PC_REPORT1_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sales Order Report Field
Y/N Table Edit Default Value: N |
| 5 | CP_PC_REPORT2_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Production Documents Report Field
Y/N Table Edit Default Value: N |
| 6 | CP_PC_REPORT3_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Purchase Order Report Field
Y/N Table Edit Default Value: N |
| 7 | CP_PC_REPORT4_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Invoice Report Field
Y/N Table Edit Default Value: N |
| 8 | CP_PC_REPORT5_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Pick Plan Report Field
Y/N Table Edit Default Value: N |
| 9 | CP_PC_REPORT6_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Packing Slip Report Field
Y/N Table Edit Default Value: N |
| 10 | CP_PC_REPORT7_FLG | Character(1) | VARCHAR2(1) NOT NULL |
View Online Report Field
Y/N Table Edit Default Value: Y |
| 11 | CP_PC_REPORT8_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Future Report 1 Field
Y/N Table Edit Default Value: N |
| 12 | CP_PC_REPORT9_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Future Report 2 Field
Y/N Table Edit Default Value: N |