CUST_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for CUSTOMER 022808 KPS 1744817001 Removed the defaulted value for the field FED_SHARE_PCT in the Sub Record CUSTOMER_SBR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 3 | 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.
Prompt Table: CUSTOMER |
| 4 | CUST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Customer Status
A=Active I=Inactive T=Template Default Value: A |
| 5 | CUST_STATUS_DT | Date(10) | DATE | Customer Status Date |
| 6 | STCUST_DAYS | Number(4,0) | SMALLINT NOT NULL | Days Until Expiration |
| 7 | EXPIRATION_DATE | Date(10) | DATE | Expiration Date |
| 8 | EXP_PENDING | Character(1) | VARCHAR2(1) NOT NULL |
Expiration pending flag
Default Value: N |
| 9 | TEMPLATE_ADDR | Character(1) | VARCHAR2(1) NOT NULL | Template Address Flag |
| 10 | 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 |
| 11 | SINCE_DT | Date(10) | DATE NOT NULL |
Customer Since
Default Value: %date |
| 12 | ADD_DT | Date(10) | DATE NOT NULL |
Customer Added On
Default Value: %date |
| 13 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 14 | NAMESHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Name |
| 15 | NAME2 | Character(40) | VARCHAR2(40) NOT NULL | Name 2 |
| 16 | NAME3 | Character(40) | VARCHAR2(40) NOT NULL | Name 3 |
| 17 | NAME1_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 1 Alternate Char Set |
| 18 | NAME2_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 2 Alternate Char Set |
| 19 | NAME3_AC | Character(40) | VARCHAR2(40) NOT NULL | Name 3 Alternate Char Set |
| 20 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Address Sequence Number
Prompt Table: CUST_ADDR_N_VW |
| 21 | CORPORATE_SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 22 | CORPORATE_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Corporate Customer
Prompt Table: CUST_CC_A1S_VW |
| 23 | PARENT_SETID | Character(5) | VARCHAR2(5) NOT NULL | Parent SetID |
| 24 | PARENT_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Parent Cust ID |
| 25 | REMIT_FROM_SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 26 | REMIT_FROM_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Remit From Customer
Prompt Table: CUST_REM_A1S_VW |
| 27 | CRSPD_SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 28 | CRSPD_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Correspondence Customer
Prompt Table: CUST_CR_A1S_VW |
| 29 | CONSOL_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Specifies the Billing business unit associated with a consolidated bill.
Prompt Table: BI_CONSOL_BU_VW |
| 30 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table: SP_SETID_NONVW |
| 31 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR_AR2 |
| 32 | REFER_TO_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Refer To Setid
Prompt Table: SP_SETID_NONVW |
| 33 | REFER_TO_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Refer To Customer |
| 34 | REVIEW_DAYS | Number(3,0) | SMALLINT NOT NULL | Review Days |
| 35 | FORMER_NAME_1 | Character(40) | VARCHAR2(40) NOT NULL | Former Name 1 |
| 36 | FORMER_NAME_2 | Character(40) | VARCHAR2(40) NOT NULL | Former Name 2 |
| 37 | CNTCT_SEQ_NUM | Number(5,0) | INTEGER NOT NULL |
Contact Sequence Number
Prompt Table: CUST_CONTACT |
| 38 | SUBCUST_USE | Character(1) | VARCHAR2(1) NOT NULL |
SubCustomer
Y/N Table Edit Default Value: N |
| 39 | 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.
Prompt Table: SUBCUST_Q1_TBL |
| 40 | 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.
Prompt Table: SUBCUST_Q2_TBL |
| 41 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: RT_TYPE_TBL |
| 42 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 43 | SHIP_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ship To Customer
N=No Y=Yes Y/N Table Edit Default Value: N |
| 44 | BILL_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Bill To Customer
N=No Y=Yes Y/N Table Edit Default Value: N |
| 45 | SOLD_TO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Sold To Customer
Y/N Table Edit Default Value: N |
| 46 | BROKER_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Broker Customer
Y/N Table Edit Default Value: N |
| 47 | INDIRECT_CUST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Indirect Customer
Y/N Table Edit Default Value: N |
| 48 | CUST_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Customer Level
N=New P=Prospect R=Regular S=Short-Term T=Temporary Default Value: R |
| 49 | ADDRESS_SEQ_SOLD | Number(5,0) | INTEGER NOT NULL | Primary Address - Sold To |
| 50 | CNTCT_SEQ_SOLD | Number(5,0) | INTEGER NOT NULL | Primary Contact - Sold To |
| 51 | ADDRESS_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL | Primary Address - Ship To |
| 52 | CNTCT_SEQ_SHIP | Number(5,0) | INTEGER NOT NULL | Primary Contact - Ship To |
| 53 | ADDRESS_SEQ_BRK | Number(5,0) | INTEGER NOT NULL | Primary Address - Broker |
| 54 | ADDRESS_SEQ_IND | Number(5,0) | INTEGER NOT NULL | Primary Address - Indirect |
| 55 | HOLD_UPDATE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Hold Update Switch
Y/N Table Edit Default Value: N |
| 56 | ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL |
Role User
Prompt Table: ROLEXLATOPR_VW |
| 57 | TAXPAYER_ID | Character(14) | VARCHAR2(14) NOT NULL | Taxpayer ID |
| 58 | WEB_URL | Character(130) | VARCHAR2(130) NOT NULL | Website URL |
| 59 | STOCK_SYMBOL | Character(10) | VARCHAR2(10) NOT NULL | Stock Symbol |
| 60 | REPORTS_TO_SPONSOR | Character(15) | VARCHAR2(15) NOT NULL |
Reports To Sponsor
Prompt Table: GM_CUSTOMER_VW |
| 61 | SPNSR_LEVEL | Character(4) | VARCHAR2(4) NOT NULL |
Level
Prompt Table: GM_SPNSR_LEVEL |
| 62 | SPNSR_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Sponsor Type
Prompt Table: GM_SPNSR_TYPE |
| 63 | SPNSR_PROGRAM | Character(4) | VARCHAR2(4) NOT NULL |
Program Type
Prompt Table: GM_SP_PROG_TYPE |
| 64 | COST_LIV_INCR_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Cost of Living Increase Pct |
| 65 | CFDA_NBR | Number(6,3) | DECIMAL(5,3) NOT NULL | CFDA Number |
| 66 | FOREIGN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Foreign
Y/N Table Edit Default Value: N |
| 67 | FED_SP_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Sponsor Type
Prompt Table: GM_FED_SP_TYPE |
| 68 | OFAC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
OFAC Status
B=Blocked C=Cleared R=Review V=Valid |
| 69 | REASON_CD | Character(10) | VARCHAR2(10) NOT NULL |
Reason Code
Prompt Table: FSS_REASON_VW |
| 70 | FSS_OFFSET_DAYS | Number(5,0) | INTEGER NOT NULL | 02/20/06 EGS: Created |
| 71 | GM_FEDERAL_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Federal
Y/N Table Edit Default Value: N |
| 72 | US_FLAG_CARRIER | Character(1) | VARCHAR2(1) NOT NULL |
US Flag Carrier Required
Y/N Table Edit Default Value: N |
| 73 | LOC_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Letter of Credit
Y/N Table Edit Default Value: N |
| 74 | GM_LOC_SPONSOR_ID | Character(15) | VARCHAR2(15) NOT NULL |
Letter of Credit Sponsor
Prompt Table: GM_LOC_SP_VW |
| 75 | GGOV_FLG | Character(1) | VARCHAR2(1) NOT NULL |
GGOV_FLG
Y/N Table Edit |
| 76 | FA_SPNSR_BASE_ID | Character(5) | VARCHAR2(5) NOT NULL |
Sponsor Base
Prompt Table: GM_FA_BASE_DTL |
| 77 | GM_DEL_LOC_REFS_SW | Character(1) | VARCHAR2(1) NOT NULL | Use this to "mark" parent records that need to have children records deleted. |
| 78 | GRANTS_SPONSOR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Grants Management Sponsor
N=No Y=Yes |
| 79 | SPNSR_SALARY_CAP | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | SPNSR_SALARY_CAP |
| 80 | ALLOW_COPI | Character(1) | VARCHAR2(1) NOT NULL |
Allow CO-PI's
Y/N Table Edit Default Value: N |
| 81 | MULTI_PI | Character(1) | VARCHAR2(1) NOT NULL |
Allow Multiple PI's
Y/N Table Edit Default Value: N |
| 82 | FEDERAL_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Federal Vendor Information
Y/N Table Edit Default Value: N |
| 83 | TRADING_PARTNER | Character(6) | VARCHAR2(6) NOT NULL | Trading Partner Code |
| 84 | IPAC_INTERFACE | Character(1) | VARCHAR2(1) NOT NULL |
IPAC Interface
Y/N Table Edit Default Value: N |
| 85 | 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 |
| 86 | CUSTOMER_ALC | Character(8) | VARCHAR2(8) NOT NULL |
Customer Agency Location Code
Prompt Table: AGENCY_LOC_CD |
| 87 | CUSTOMER_DO | Character(5) | VARCHAR2(5) NOT NULL | Disbursing office |
| 88 | SYMBOL_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Symbol flag required
Default Value: Y |
| 89 | SOURCE_SYSTEM | Character(3) | VARCHAR2(3) NOT NULL |
Source System
CCR=CCR EBL=eBill Contact Maintenance FED=FED PEN=Pension Customer |
| 90 | CUST_USF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
CCR Status of a Vendor
A=Active E=Expired U=Unregistered X=Exempt Default Value: X |
| 91 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 92 | FED_SHARE_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Federal Share Percentage |
| 93 | CONT_ALLOW_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Allowable Construction Pct |
| 94 | CONT_NO_ALLW_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Not allowable Construction Pct |
| 95 | CUST_FIELD_C1_A | Character(1) | VARCHAR2(1) NOT NULL | Custom Field |
| 96 | CUST_FIELD_C1_B | Character(1) | VARCHAR2(1) NOT NULL | Customer Char1 B |
| 97 | CUST_FIELD_C1_C | Character(1) | VARCHAR2(1) NOT NULL | Customer Char1 C |
| 98 | CUST_FIELD_C1_D | Character(1) | VARCHAR2(1) NOT NULL | Customer Char1 D |
| 99 | CUST_FIELD_C2 | Character(2) | VARCHAR2(2) NOT NULL | Customer Char 2 |
| 100 | CUST_FIELD_C4 | Character(4) | VARCHAR2(4) NOT NULL | Customer Char 4 |
| 101 | CUST_FIELD_C6 | Character(6) | VARCHAR2(6) NOT NULL | Customer Char 6 |
| 102 | CUST_FIELD_C8 | Character(8) | VARCHAR2(8) NOT NULL | Customer Char 8 |
| 103 | CUST_FIELD_C10_A | Character(10) | VARCHAR2(10) NOT NULL | Customer Char 10 A |
| 104 | CUST_FIELD_C10_B | Character(10) | VARCHAR2(10) NOT NULL | Customer Char 10 B |
| 105 | CUST_FIELD_C10_C | Character(10) | VARCHAR2(10) NOT NULL | Customer Char 10 C |
| 106 | CUST_FIELD_C10_D | Character(10) | VARCHAR2(10) NOT NULL | Customer Char 10 D |
| 107 | CUST_FIELD_C30_A | Character(30) | VARCHAR2(30) NOT NULL | Customer Char 30 A |
| 108 | CUST_FIELD_C30_B | Character(30) | VARCHAR2(30) NOT NULL | Customer Char 30 B |
| 109 | CUST_FIELD_C30_C | Character(30) | VARCHAR2(30) NOT NULL | Customer Char 30 C |
| 110 | CUST_FIELD_C30_D | Character(30) | VARCHAR2(30) NOT NULL | Customer Char 30 D |
| 111 | CUST_FIELD_N12_A | Number(16,3) | DECIMAL(15,3) NOT NULL | Customer Nbr 12.3 A |
| 112 | CUST_FIELD_N12_B | Number(16,3) | DECIMAL(15,3) NOT NULL | Customer Nbr 12.3 B |
| 113 | CUST_FIELD_N12_C | Number(16,3) | DECIMAL(15,3) NOT NULL | Customer Nbr 12.3 C |
| 114 | CUST_FIELD_N12_D | Number(16,3) | DECIMAL(15,3) NOT NULL | Customer Nbr 12.3 D |
| 115 | CUST_FIELD_N15_A | Number(15,0) | DECIMAL(15) NOT NULL | Cust Field Nbr 15 A |
| 116 | CUST_FIELD_N15_B | Number(15,0) | DECIMAL(15) NOT NULL | Cust Field Nbr 15 B |
| 117 | CUST_FIELD_N15_C | Number(15,0) | DECIMAL(15) NOT NULL | Cust Field Nbr 15 C |
| 118 | CUST_FIELD_N15_D | Number(15,0) | DECIMAL(15) NOT NULL | Cust Field Nbr 15 D |
| 119 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 120 | DATE_LAST_MAINT | Date(10) | DATE | Date Last Maintained |
| 121 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 122 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |