SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
PRODUCT_GROUPPrompt Table: PRODGP_NGCA_VW
Y/N Table Edit
Default Value: N
1=Current Date
2=Contract Sign Date
Default Value: 2
Prompt Table: DST_CODE_UAR_VW
CA_PROD_GRP_TBL(SQL Table) |
Index Back |
|---|---|
Product Group Sibling |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | PRODUCT_GROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Product Group
Prompt Table: PRODGP_NGCA_VW |
| 3 | BOOK_CA_TO_DFR | Character(1) | VARCHAR2(1) NOT NULL |
Deferred revenue accounting
Y/N Table Edit Default Value: N |
| 4 | DFR_REV_DATE_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Deferred Revenue Date Option used on Contracts Product Group table.
1=Current Date 2=Contract Sign Date Default Value: 2 |
| 5 | DST_ID | Character(10) | VARCHAR2(10) NOT NULL |
Distribution Code
Prompt Table: DST_CODE_UAR_VW |