RS_CUST_ACTIVE(SQL View) |
Index Back |
|---|---|
Customer Header Information |
| SELECT SETID , CUST_ID , CUST_STATUS , CUST_STATUS_DT , NAMESHORT , CUSTOMER_TYPE , SINCE_DT , ADD_DT , NAME1 , NAME2 , NAME3 , NAME1_AC , NAME2_AC , ADDRESS_SEQ_NUM , CORPORATE_SETID , CORPORATE_CUST_ID , REMIT_FROM_SETID , REMIT_FROM_CUST_ID , CRSPD_SETID , CRSPD_CUST_ID , VENDOR_SETID , VENDOR_ID , REFER_TO_SETID , REFER_TO_CUST_ID , REVIEW_DAYS , FORMER_NAME_1 , FORMER_NAME_2 , CNTCT_SEQ_NUM , SUBCUST_USE , SUBCUST_QUAL1 , SUBCUST_QUAL2 , CUR_RT_TYPE , CURRENCY_CD , SHIP_TO_FLG , BILL_TO_FLG , SOLD_TO_FLG , CUST_LEVEL , ADDRESS_SEQ_SOLD , CNTCT_SEQ_SOLD , ADDRESS_SEQ_SHIP , CNTCT_SEQ_SHIP , HOLD_UPDATE_SW , ROLEUSER , LAST_MAINT_OPRID , DATE_LAST_MAINT FROM PS_CUSTOMER WHERE CUST_STATUS='A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 3 | CUST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Customer Status
A=Active I=Inactive T=Template Default Value: A |
| 4 | CUST_STATUS_DT | Date(10) | DATE | Customer Status Date |
| 5 | NAMESHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Name |
| 6 | 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 Default Value: 1 |
| 7 | SINCE_DT | Date(10) | DATE NOT NULL |
Customer Since
Default Value: %date |
| 8 | ADD_DT | Date(10) | DATE NOT NULL |
Customer Added On
Default Value: %date |
| 9 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 10 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 11 | NAME3 | Character(40) | VARCHAR2(40) NOT NULL | Name 3 |
| 12 | NAME1_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 1 Alternate Char Set |
| 13 | NAME2_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 2 Alternate Char Set |
| 14 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 15 | CORPORATE_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 16 | CORPORATE_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Corporate Customer |
| 17 | REMIT_FROM_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 18 | REMIT_FROM_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Remit From Customer |
| 19 | CRSPD_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 20 | CRSPD_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Correspondence Customer |
| 21 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 22 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 23 | REFER_TO_SETID | Character(5) | VARCHAR2(5) NOT NULL | Refer To Setid |
| 24 | REFER_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Refer To Customer |
| 25 | REVIEW_DAYS | Number(3,0) | SMALLINT NOT NULL | Review Days |
| 26 | FORMER_NAME_1 | Character(40) | VARCHAR2(40) NOT NULL | Former Name 1 |
| 27 | FORMER_NAME_2 | Character(40) | VARCHAR2(40) NOT NULL | Former Name 2 |
| 28 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 29 | SUBCUST_USE | Character(1) | VARCHAR2(1) NOT NULL |
SubCustomer
Y/N Table Edit Default Value: N |
| 30 | 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. |
| 31 | 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. |
| 32 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 33 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 34 | SHIP_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ship To Customer
N=No Y=Yes Y/N Table Edit Default Value: N |
| 35 | BILL_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Bill To Customer
N=No Y=Yes Y/N Table Edit Default Value: N |
| 36 | SOLD_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sold To Customer
Y/N Table Edit Default Value: N |
| 37 | CUST_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Customer Level
N=New P=Prospect R=Regular S=Short-Term T=Temporary Default Value: R |
| 38 | ADDRESS_SEQ_SOLD | Number(5,0) | INTEGER NOT NULL | Primary Address - Sold To |
| 39 | CNTCT_SEQ_SOLD | Number(5,0) | INTEGER NOT NULL | Primary Contact - Sold To |
| 40 | ADDRESS_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL | Primary Address - Ship To |
| 41 | CNTCT_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL | Primary Contact - Ship To |
| 42 | HOLD_UPDATE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Hold Update Switch
Y/N Table Edit |
| 43 | ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | Role User |
| 44 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 45 | DATE_LAST_MAINT | Date(10) | DATE | Date Last Maintained |