ORDENT_CUST_VW(SQL View) |
Index Back |
|---|---|
OM - Order entry customer dataGeneral customer information for order entry. Date Initials Issue Description 081701 dms DI-MVANWINK-3 Add cal_lookup_done 082901 dms F-CJORGENS-11 Add vat_dclrtn_point 101001 dms F-CJOHNSON-173 New price-by fields from cust 112202 KTW F-MULINAR-3 VAT on Services - Delete Vat fields |
| SELECT SETID ,CUST_ID ,NAME1 ,NAME2 ,SUBCUST_QUAL1 ,SUBCUST_QUAL2 ,SUBCUST_USE ,ADDRESS_SEQ_NUM ,CNTCT_SEQ_SOLD ,CNTCT_SEQ_NUM ,CNTCT_SEQ_SHIP ,ADDRESS_SEQ_SHIP ,ADDRESS_SEQ_SOLD ,CURRENCY_CD ,CUR_RT_TYPE ,CORPORATE_SETID ,CORPORATE_CUST_ID ,PARENT_SETID ,PARENT_CUST_ID ,BILL_TO_FLG ,SHIP_TO_FLG ,SOLD_TO_FLG ,CRSPD_CUST_ID ,CRSPD_SETID ,CUST_LEVEL , 'N' ,CUSTOMER_TYPE ,CUST_FIELD_C10_A ,CUST_FIELD_C10_B ,CUST_FIELD_C10_C ,CUST_FIELD_C10_D ,CUST_FIELD_C1_A ,CUST_FIELD_C1_B ,CUST_FIELD_C1_C ,CUST_FIELD_C1_D ,CUST_FIELD_C2 ,CUST_FIELD_C30_A ,CUST_FIELD_C30_B ,CUST_FIELD_C30_C ,CUST_FIELD_C30_D ,CUST_FIELD_C4 ,CUST_FIELD_C6 ,CUST_FIELD_C8 ,CUST_FIELD_N12_A ,CUST_FIELD_N12_B ,CUST_FIELD_N12_C ,CUST_FIELD_N12_D ,CUST_FIELD_N15_A ,CUST_FIELD_N15_B ,CUST_FIELD_N15_C ,CUST_FIELD_N15_D ,%DateNull ,' ' ,0 ,0 FROM PS_CUSTOMER 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 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 4 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 5 | 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. |
| 6 | 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. |
| 7 | SUBCUST_USE | Character(1) | VARCHAR2(1) NOT NULL | SubCustomer |
| 8 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 9 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Contact Sequence Number |
| 10 | CNTCT_SEQ_BILL | Number(5,0) | INTEGER NOT NULL | Contact Sequence - Bill To |
| 11 | CNTCT_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL | Primary Contact - Ship To |
| 12 | ADDRESS_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL | Primary Address - Ship To |
| 13 | ADDRESS_SEQ_SOLD | Number(5,0) | INTEGER NOT NULL | Primary Address - Sold To |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 15 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 16 | CORPORATE_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 17 | CORPORATE_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Corporate Customer |
| 18 | PARENT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Parent SetID |
| 19 | PARENT_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Parent Cust ID |
| 20 | BILL_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Bill To Customer
N=No Y=Yes Default Value: N |
| 21 | SHIP_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ship To Customer
N=No Y=Yes Default Value: N |
| 22 | SOLD_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sold To Customer
Default Value: N |
| 23 | CRSPD_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Correspondence Customer |
| 24 | CRSPD_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 25 | CUST_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Customer Level
N=New P=Prospect R=Regular S=Short-Term T=Temporary |
| 26 | CAL_LOOKUP_DONE | Character(1) | VARCHAR2(1) NOT NULL | Calendar Lookup Done |
| 27 | 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 |
| 28 | CUST_FIELD_C10_A | Character(10) | VARCHAR2(10) NOT NULL | Customer Char 10 A |
| 29 | CUST_FIELD_C10_B | Character(10) | VARCHAR2(10) NOT NULL | Customer Char 10 B |
| 30 | CUST_FIELD_C10_C | Character(10) | VARCHAR2(10) NOT NULL | Customer Char 10 C |
| 31 | CUST_FIELD_C10_D | Character(10) | VARCHAR2(10) NOT NULL | Customer Char 10 D |
| 32 | CUST_FIELD_C1_A | Character(1) | VARCHAR2(1) NOT NULL | Custom Field |
| 33 | CUST_FIELD_C1_B | Character(1) | VARCHAR2(1) NOT NULL | Customer Char1 B |
| 34 | CUST_FIELD_C1_C | Character(1) | VARCHAR2(1) NOT NULL | Customer Char1 C |
| 35 | CUST_FIELD_C1_D | Character(1) | VARCHAR2(1) NOT NULL | Customer Char1 D |
| 36 | CUST_FIELD_C2 | Character(2) | VARCHAR2(2) NOT NULL | Customer Char 2 |
| 37 | CUST_FIELD_C30_A | Character(30) | VARCHAR2(30) NOT NULL | Customer Char 30 A |
| 38 | CUST_FIELD_C30_B | Character(30) | VARCHAR2(30) NOT NULL | Customer Char 30 B |
| 39 | CUST_FIELD_C30_C | Character(30) | VARCHAR2(30) NOT NULL | Customer Char 30 C |
| 40 | CUST_FIELD_C30_D | Character(30) | VARCHAR2(30) NOT NULL | Customer Char 30 D |
| 41 | CUST_FIELD_C4 | Character(4) | VARCHAR2(4) NOT NULL | Customer Char 4 |
| 42 | CUST_FIELD_C6 | Character(6) | VARCHAR2(6) NOT NULL | Customer Char 6 |
| 43 | CUST_FIELD_C8 | Character(8) | VARCHAR2(8) NOT NULL | Customer Char 8 |
| 44 | CUST_FIELD_N12_A | Number(16,3) | DECIMAL(15,3) NOT NULL | Customer Nbr 12.3 A |
| 45 | CUST_FIELD_N12_B | Number(16,3) | DECIMAL(15,3) NOT NULL | Customer Nbr 12.3 B |
| 46 | CUST_FIELD_N12_C | Number(16,3) | DECIMAL(15,3) NOT NULL | Customer Nbr 12.3 C |
| 47 | CUST_FIELD_N12_D | Number(16,3) | DECIMAL(15,3) NOT NULL | Customer Nbr 12.3 D |
| 48 | CUST_FIELD_N15_A | Number(15,0) | DECIMAL(15) NOT NULL | Cust Field Nbr 15 A |
| 49 | CUST_FIELD_N15_B | Number(15,0) | DECIMAL(15) NOT NULL | Cust Field Nbr 15 B |
| 50 | CUST_FIELD_N15_C | Number(15,0) | DECIMAL(15) NOT NULL | Cust Field Nbr 15 C |
| 51 | CUST_FIELD_N15_D | Number(15,0) | DECIMAL(15) NOT NULL | Cust Field Nbr 15 D |
| 52 | ASOFDATE | Date(10) | DATE | As of Date |
| 53 | ACTIVE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Active Flag
A=Active I=Inactive |
| 54 | DAY_ROW | Number(5,0) | INTEGER NOT NULL | Day Row |
| 55 | BLOCK_ROW | Number(5,0) | INTEGER NOT NULL | Block Row |