SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
CUST_IDPrompt Table: CUSTOMER
Y/N Table Edit
Default Value: N
1=User 1
Default Value: 1
Default Value: %date
Default Value: %date
Prompt Table: %EDITTABLE3
CUSTOMER(SQL Table) |
Index Back |
|---|---|
Customer Header InformationNote: Any field changes made to this record should also be made to CUSTOMER_SBR and the affected tables will need to be rebuilt. Date Init. Issue # Description 092697 Carina B. Made changes for related language display. 102000 Dino 5411901 Gromit 072401 JJM DI-EDWONG-17 Add Grants and Receivables fields 100901 JJM DI-EDWONG-17 Added CNTCT_SEQ_OPAC 102302 JJM F-C1ABANOS-25 Added FEDERAL_INDICATOR and TRADING_PARTNER fields 112202 KTW F-MULINAR-3 VAT on Services - Delete Vat fields |
| # | 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 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Customer ID
Prompt Table: CUSTOMER |
| 3 | CUST_STATUS | Character(1) | VARCHAR2(1) NOT NULL | Customer Status |
| 4 | CUST_STATUS_DT | Date(10) | DATE | Customer Status Date |
| 5 | STCUST_DAYS | Number(4,0) | SMALLINT NOT NULL | Used to capture Day unit Expiration |
| 6 | EXPIRATION_DATE | Date(10) | DATE | Expiration Date |
| 7 | TEMPLATE_ADDR | Character(1) | VARCHAR2(1) NOT NULL |
TEMPLATE_ADDR
Y/N Table Edit Default Value: N |
| 8 | CUSTOMER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Customer Type
1=User 1 Default Value: 1 |
| 9 | SINCE_DT | Date(10) | DATE NOT NULL |
Customer Since
Default Value: %date |
| 10 | ADD_DT | Date(10) | DATE NOT NULL |
Customer Added On
Default Value: %date |
| 11 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 12 | NAMESHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Name |
| 13 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 14 | NAME3 | Character(40) | VARCHAR2(40) NOT NULL | Name 3 |
| 15 | NAME1_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 1 Alternate Char Set |
| 16 | NAME2_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 2 Alternate Char Set |
| 17 | NAME3_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 3 Alternate Char Set |
| 18 | ADDRESS_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Address Sequence Number
Prompt Table: %EDITTABLE3 |