SETIDCUST_IDADDRESS_SEQ_NUMBCL=B. Casual
CAS=Casual
FML=Formal
Y/N Table Edit
Default Value: N
RS_CUSTOMER_DTL(SQL Table) |
Index Back |
|---|---|
Customer informationA resource management table for customer information. |
| # | 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 | ADDRESS_SEQ_NUM |
Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 4 | DRESS_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Dress Code
BCL=B. Casual CAS=Casual FML=Formal |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 6 | NONBILLABLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Shadow Consultants Allowed
Y/N Table Edit Default Value: N |
| 7 | HOUSING_INFO | Character(254) | VARCHAR2(254) NOT NULL | Housing Information |
| 8 | TRAVEL_INFO | Character(254) | VARCHAR2(254) NOT NULL | Travel Information |
| 9 | LONGITUDE | Signed Number(12,7) | DECIMAL(10,7) NOT NULL | Longitude |
| 10 | LONG_COMPASS | Character(1) | VARCHAR2(1) NOT NULL | Longitude Compass |
| 11 | LATITUDE | Signed Number(12,7) | DECIMAL(10,7) NOT NULL | Latitude |
| 12 | LAT_COMPASS | Character(1) | VARCHAR2(1) NOT NULL | Latitude Compass |
| 13 | DISTANCE | Number(8,2) | DECIMAL(7,2) NOT NULL | Distance Traveled |