CONTRACT_NUMPrompt Table: CA_CNTR_SRCH_VW
Default Value: GM_AWARD.BUSINESS_UNIT
Prompt Table: SP_BU_CA_NONVW
CNTCT_SEQ_NUMPrompt Table: GM_CNTCT_SH_VW
GM_AWD_CUST_CT(SQL Table) |
Index Back |
|---|---|
Customer Contact Information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL |
Contract
Prompt Table: CA_CNTR_SRCH_VW |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: GM_AWARD.BUSINESS_UNIT Prompt Table: SP_BU_CA_NONVW |
| 3 | CNTCT_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL |
Contact Sequence Number
Prompt Table: GM_CNTCT_SH_VW |