SETIDCUST_CPY_ID1=User 1
2=User 2
3=User 3
4=User 4
F=Foreign
M=Commercial
N=Consumer
S=State and Local
X=Excluded Foreign Customer
N=No
Y=Yes
N=No
Y=Yes
N=New
P=Prospect
R=Regular
S=Short-Term
T=Temporary
N=No
Y=Yes
CUSTCPY_VW(SQL View) |
Index Back |
|---|---|
Cust Copy VW - General DataView of General Date on the customer record for copy function. Date Init. Issue # Description 03/29/01 JJM SP2 DI-EDWONG-3 Gromit 6446201; Changed SQL to set zero values for CNTCT_SEQ_NUM, CNTCT_SEQ_SOLD, and CNTC_SEQ_SHIP fields. 10/09/01 JJM DI-EDWONG-17 Added CNTCT_SEQ_OPAC |
| SELECT SETID , CUST_ID , CUSTOMER_TYPE , CORPORATE_SETID , CORPORATE_CUST_ID , REMIT_FROM_SETID , REMIT_FROM_CUST_ID , CRSPD_SETID , CRSPD_CUST_ID , CONSOL_BUS_UNIT , VENDOR_SETID , VENDOR_ID , REFER_TO_SETID , REFER_TO_CUST_ID , REVIEW_DAYS , SUBCUST_USE , SUBCUST_QUAL1 , SUBCUST_QUAL2 , CUR_RT_TYPE , CURRENCY_CD , SHIP_TO_FLG , BILL_TO_FLG , SOLD_TO_FLG , BROKER_FLG , INDIRECT_CUST_FLG , CUST_LEVEL , HOLD_UPDATE_SW , ADDRESS_SEQ_NUM , ADDRESS_SEQ_SHIP , ADDRESS_SEQ_SOLD , ADDRESS_SEQ_BRK , ADDRESS_SEQ_IND , 0 , 0 , 0 , WEB_URL , STOCK_SYMBOL , REPORTS_TO_SPONSOR , SPNSR_LEVEL , SPNSR_TYPE , SPNSR_PROGRAM , COST_LIV_INCR_PCT , CFDA_NBR , FOREIGN_FLAG , GM_FEDERAL_FLAG , US_FLAG_CARRIER , LOC_INDICATOR , GM_LOC_SPONSOR_ID , FA_SPNSR_BASE_ID , GM_DEL_LOC_REFS_SW , GRANTS_SPONSOR_FLG , FEDERAL_INDICATOR , TRADING_PARTNER , IPAC_INTERFACE , 0 , CUSTOMER_ALC FROM PS_CUSTOMER WHERE CUST_STATUS IN ('A','I') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CUST_CPY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Customer Copy ID |
| 3 | CUSTOMER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Customer Type
1=User 1 2=User 2 3=User 3 4=User 4 F=Foreign M=Commercial N=Consumer S=State and Local X=Excluded Foreign Customer |
| 4 | CORPORATE_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | CORPORATE_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Corporate Customer |
| 6 | REMIT_FROM_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 7 | REMIT_FROM_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Remit From Customer |
| 8 | CRSPD_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 9 | CRSPD_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Correspondence Customer |
| 10 | CONSOL_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Specifies the Billing business unit associated with a consolidated bill. |
| 11 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 12 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 13 | REFER_TO_SETID | Character(5) | VARCHAR2(5) NOT NULL | Refer To Setid |
| 14 | REFER_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Refer To Customer |
| 15 | REVIEW_DAYS | Number(3,0) | SMALLINT NOT NULL | Review Days |
| 16 | SUBCUST_USE | Character(1) | VARCHAR2(1) NOT NULL | SubCustomer |
| 17 | SUBCUST_QUAL1 | Character(15) | VARCHAR2(15) NOT NULL | Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2. |
| 18 | SUBCUST_QUAL2 | Character(15) | VARCHAR2(15) NOT NULL | Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2. |
| 19 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 20 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 21 | SHIP_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ship To Customer
N=No Y=Yes |
| 22 | BILL_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Bill To Customer
N=No Y=Yes |
| 23 | SOLD_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Sold To Customer |
| 24 | BROKER_FLG | Character(1) | VARCHAR2(1) NOT NULL | Broker Customer |
| 25 | INDIRECT_CUST_FLG | Character(1) | VARCHAR2(1) NOT NULL | Indirect Customer |
| 26 | CUST_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Customer Level
N=New P=Prospect R=Regular S=Short-Term T=Temporary |
| 27 | HOLD_UPDATE_SW | Character(1) | VARCHAR2(1) NOT NULL | Hold Update Switch |
| 28 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 29 | ADDRESS_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL | Primary Address - Ship To |
| 30 | ADDRESS_SEQ_SOLD | Number(5,0) | INTEGER NOT NULL | Primary Address - Sold To |
| 31 | ADDRESS_SEQ_BRK | Number(5,0) | INTEGER NOT NULL | Primary Address - Broker |
| 32 | ADDRESS_SEQ_IND | Number(5,0) | INTEGER NOT NULL | Primary Address - Indirect |
| 33 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 34 | CNTCT_SEQ_SOLD | Number(5,0) | INTEGER NOT NULL | Primary Contact - Sold To |
| 35 | CNTCT_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL | Primary Contact - Ship To |
| 36 | WEB_URL | Character(130) | VARCHAR2(130) NOT NULL | Website URL |
| 37 | STOCK_SYMBOL | Character(10) | VARCHAR2(10) NOT NULL | Stock Symbol |
| 38 | REPORTS_TO_SPONSOR | Character(15) | VARCHAR2(15) NOT NULL | Reports To Sponsor |
| 39 | SPNSR_LEVEL | Character(4) | VARCHAR2(4) NOT NULL | Level |
| 40 | SPNSR_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Sponsor Type |
| 41 | SPNSR_PROGRAM | Character(4) | VARCHAR2(4) NOT NULL | Program Type |
| 42 | COST_LIV_INCR_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Cost of Living Increase Pct |
| 43 | CFDA_NBR | Number(6,3) | DECIMAL(5,3) NOT NULL | CFDA Number |
| 44 | FOREIGN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Foreign |
| 45 | GM_FEDERAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Federal |
| 46 | US_FLAG_CARRIER | Character(1) | VARCHAR2(1) NOT NULL | US Flag Carrier Required |
| 47 | LOC_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL | Letter of Credit |
| 48 | GM_LOC_SPONSOR_ID | Character(15) | VARCHAR2(15) NOT NULL | Letter of Credit Sponsor |
| 49 | FA_SPNSR_BASE_ID | Character(5) | VARCHAR2(5) NOT NULL | Sponsor Base |
| 50 | GM_DEL_LOC_REFS_SW | Character(1) | VARCHAR2(1) NOT NULL | Use this to "mark" parent records that need to have children records deleted. |
| 51 | GRANTS_SPONSOR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Grants Management Sponsor
N=No Y=Yes |
| 52 | FEDERAL_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL | Federal Vendor Information |
| 53 | TRADING_PARTNER | Character(6) | VARCHAR2(6) NOT NULL | Trading Partner Code |
| 54 | IPAC_INTERFACE | Character(1) | VARCHAR2(1) NOT NULL | IPAC Interface |
| 55 | CNTCT_SEQ_IPAC | Number(5,0) | INTEGER NOT NULL | Date Init. Issue # Description 10/09/01 JJM DI-EDWONG-17 Project Gemini enhancements 10/29/02 JJM F-C1ABANOS-25 Added IPAC label as default |
| 56 | CUSTOMER_ALC | Character(8) | VARCHAR2(8) NOT NULL | Customer Agency Location Code |