CUSTTMP_MAIN_VW

(SQL View)
Index Back

Short Term Customer Templates

022808 KPS 1744817001 Removed the defaulted value for the field FED_SHARE_PCT in the Sub Record CUSTOMER_SBR

SELECT A.SETID , A.CUST_ID , %subrec(CUSTOMER_SBR, A) FROM PS_CUSTOMER A WHERE A.CUST_STATUS = 'T'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
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 STCUST_DAYS Number(4,0) SMALLINT NOT NULL Days Until Expiration
6 EXPIRATION_DATE Date(10) DATE Expiration Date
7 EXP_PENDING Character(1) VARCHAR2(1) NOT NULL Expiration pending flag

Default Value: N

8 TEMPLATE_ADDR Character(1) VARCHAR2(1) NOT NULL Template Address Flag
9 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

10 SINCE_DT Date(10) DATE NOT NULL Customer Since

Default Value: %date

11 ADD_DT Date(10) DATE NOT NULL Customer Added On

Default Value: %date

12 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
13 NAMESHORT Character(10) VARCHAR2(10) NOT NULL Short Name
14 NAME2 Character(40) VARCHAR2(40) NOT NULL Name 2
15 NAME3 Character(40) VARCHAR2(40) NOT NULL Name 3
16 NAME1_AC Character(40) VARCHAR2(40) NOT NULL Name 1 Alternate Char Set
17 NAME2_AC Character(40) VARCHAR2(40) NOT NULL Name 2 Alternate Char Set
18 NAME3_AC Character(40) VARCHAR2(40) NOT NULL Name 3 Alternate Char Set
19 ADDRESS_SEQ_NUM Number(5,0) INTEGER NOT NULL Address Sequence Number

Prompt Table: CUST_ADDR_N_VW

20 CORPORATE_SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

21 CORPORATE_CUST_ID Character(15) VARCHAR2(15) NOT NULL Corporate Customer

Prompt Table: CUST_CC_A1S_VW

22 PARENT_SETID Character(5) VARCHAR2(5) NOT NULL Parent SetID
23 PARENT_CUST_ID Character(15) VARCHAR2(15) NOT NULL Parent Cust ID
24 REMIT_FROM_SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

25 REMIT_FROM_CUST_ID Character(15) VARCHAR2(15) NOT NULL Remit From Customer

Prompt Table: CUST_REM_A1S_VW

26 CRSPD_SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

27 CRSPD_CUST_ID Character(15) VARCHAR2(15) NOT NULL Correspondence Customer

Prompt Table: CUST_CR_A1S_VW

28 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

29 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Prompt Table: SP_SETID_NONVW

30 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR_AR2

31 REFER_TO_SETID Character(5) VARCHAR2(5) NOT NULL Refer To Setid

Prompt Table: SP_SETID_NONVW

32 REFER_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Refer To Customer
33 REVIEW_DAYS Number(3,0) SMALLINT NOT NULL Review Days
34 FORMER_NAME_1 Character(40) VARCHAR2(40) NOT NULL Former Name 1
35 FORMER_NAME_2 Character(40) VARCHAR2(40) NOT NULL Former Name 2
36 CNTCT_SEQ_NUM Number(5,0) INTEGER NOT NULL Contact Sequence Number

Prompt Table: CUST_CONTACT

37 SUBCUST_USE Character(1) VARCHAR2(1) NOT NULL SubCustomer

Y/N Table Edit

Default Value: N

38 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

39 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

40 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

Prompt Table: RT_TYPE_TBL

41 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

42 SHIP_TO_FLG Character(1) VARCHAR2(1) NOT NULL Ship To Customer
N=No
Y=Yes

Y/N Table Edit

Default Value: N

43 BILL_TO_FLG Character(1) VARCHAR2(1) NOT NULL Bill To Customer
N=No
Y=Yes

Y/N Table Edit

Default Value: N

44 SOLD_TO_FLG Character(1) VARCHAR2(1) NOT NULL Sold To Customer

Y/N Table Edit

Default Value: N

45 BROKER_FLG Character(1) VARCHAR2(1) NOT NULL Broker Customer

Y/N Table Edit

Default Value: N

46 INDIRECT_CUST_FLG Character(1) VARCHAR2(1) NOT NULL Indirect Customer

Y/N Table Edit

Default Value: N

47 CUST_LEVEL Character(1) VARCHAR2(1) NOT NULL Customer Level
N=New
P=Prospect
R=Regular
S=Short-Term
T=Temporary

Default Value: R

48 ADDRESS_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Address - Sold To
49 CNTCT_SEQ_SOLD Number(5,0) INTEGER NOT NULL Primary Contact - Sold To
50 ADDRESS_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Address - Ship To
51 CNTCT_SEQ_SHIP Number(5,0) INTEGER NOT NULL Primary Contact - Ship To
52 ADDRESS_SEQ_BRK Number(5,0) INTEGER NOT NULL Primary Address - Broker
53 ADDRESS_SEQ_IND Number(5,0) INTEGER NOT NULL Primary Address - Indirect
54 HOLD_UPDATE_SW Character(1) VARCHAR2(1) NOT NULL Hold Update Switch

Y/N Table Edit

Default Value: N

55 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User

Prompt Table: ROLEXLATOPR_VW

56 TAXPAYER_ID Character(14) VARCHAR2(14) NOT NULL Taxpayer ID
57 WEB_URL Character(130) VARCHAR2(130) NOT NULL Website URL
58 STOCK_SYMBOL Character(10) VARCHAR2(10) NOT NULL Stock Symbol
59 REPORTS_TO_SPONSOR Character(15) VARCHAR2(15) NOT NULL Reports To Sponsor

Prompt Table: GM_CUSTOMER_VW

60 SPNSR_LEVEL Character(4) VARCHAR2(4) NOT NULL Level

Prompt Table: GM_SPNSR_LEVEL

61 SPNSR_TYPE Character(4) VARCHAR2(4) NOT NULL Sponsor Type

Prompt Table: GM_SPNSR_TYPE

62 SPNSR_PROGRAM Character(4) VARCHAR2(4) NOT NULL Program Type

Prompt Table: GM_SP_PROG_TYPE

63 COST_LIV_INCR_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Cost of Living Increase Pct
64 CFDA_NBR Number(6,3) DECIMAL(5,3) NOT NULL CFDA Number
65 FOREIGN_FLAG Character(1) VARCHAR2(1) NOT NULL Foreign

Y/N Table Edit

Default Value: N

66 FED_SP_TYPE Character(4) VARCHAR2(4) NOT NULL Sponsor Type

Prompt Table: GM_FED_SP_TYPE

67 OFAC_STATUS Character(1) VARCHAR2(1) NOT NULL OFAC Status
B=Blocked
C=Cleared
R=Review
V=Valid
68 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

Prompt Table: FSS_REASON_VW

69 FSS_OFFSET_DAYS Number(5,0) INTEGER NOT NULL 02/20/06 EGS: Created
70 GM_FEDERAL_FLAG Character(1) VARCHAR2(1) NOT NULL Federal

Y/N Table Edit

Default Value: N

71 US_FLAG_CARRIER Character(1) VARCHAR2(1) NOT NULL US Flag Carrier Required

Y/N Table Edit

Default Value: N

72 LOC_INDICATOR Character(1) VARCHAR2(1) NOT NULL Letter of Credit

Y/N Table Edit

Default Value: N

73 GM_LOC_SPONSOR_ID Character(15) VARCHAR2(15) NOT NULL Letter of Credit Sponsor

Prompt Table: GM_LOC_SP_VW

74 GGOV_FLG Character(1) VARCHAR2(1) NOT NULL GGOV_FLG

Y/N Table Edit

75 FA_SPNSR_BASE_ID Character(5) VARCHAR2(5) NOT NULL Sponsor Base

Prompt Table: GM_FA_BASE_DTL

76 GM_DEL_LOC_REFS_SW Character(1) VARCHAR2(1) NOT NULL Use this to "mark" parent records that need to have children records deleted.
77 GRANTS_SPONSOR_FLG Character(1) VARCHAR2(1) NOT NULL Grants Management Sponsor
N=No
Y=Yes
78 SPNSR_SALARY_CAP Signed Number(15,2) DECIMAL(13,2) NOT NULL SPNSR_SALARY_CAP
79 ALLOW_COPI Character(1) VARCHAR2(1) NOT NULL Allow CO-PI's

Y/N Table Edit

Default Value: N

80 MULTI_PI Character(1) VARCHAR2(1) NOT NULL Allow Multiple PI's

Y/N Table Edit

Default Value: N

81 FEDERAL_INDICATOR Character(1) VARCHAR2(1) NOT NULL Federal Vendor Information

Y/N Table Edit

Default Value: N

82 TRADING_PARTNER Character(6) VARCHAR2(6) NOT NULL Trading Partner Code
83 IPAC_INTERFACE Character(1) VARCHAR2(1) NOT NULL IPAC Interface

Y/N Table Edit

Default Value: N

84 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
85 CUSTOMER_ALC Character(8) VARCHAR2(8) NOT NULL Customer Agency Location Code

Prompt Table: AGENCY_LOC_CD

86 CUSTOMER_DO Character(5) VARCHAR2(5) NOT NULL Disbursing office
87 SYMBOL_REQ Character(1) VARCHAR2(1) NOT NULL Symbol flag required

Default Value: Y

88 SOURCE_SYSTEM Character(3) VARCHAR2(3) NOT NULL Source System
CCR=CCR
EBL=eBill Contact Maintenance
FED=FED
PEN=Pension Customer
89 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

90 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
91 FED_SHARE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Federal Share Percentage
92 CONT_ALLOW_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Allowable Construction Pct
93 CONT_NO_ALLW_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Not allowable Construction Pct
94 CUST_FIELD_C1_A Character(1) VARCHAR2(1) NOT NULL Custom Field
95 CUST_FIELD_C1_B Character(1) VARCHAR2(1) NOT NULL Customer Char1 B
96 CUST_FIELD_C1_C Character(1) VARCHAR2(1) NOT NULL Customer Char1 C
97 CUST_FIELD_C1_D Character(1) VARCHAR2(1) NOT NULL Customer Char1 D
98 CUST_FIELD_C2 Character(2) VARCHAR2(2) NOT NULL Customer Char 2
99 CUST_FIELD_C4 Character(4) VARCHAR2(4) NOT NULL Customer Char 4
100 CUST_FIELD_C6 Character(6) VARCHAR2(6) NOT NULL Customer Char 6
101 CUST_FIELD_C8 Character(8) VARCHAR2(8) NOT NULL Customer Char 8
102 CUST_FIELD_C10_A Character(10) VARCHAR2(10) NOT NULL Customer Char 10 A
103 CUST_FIELD_C10_B Character(10) VARCHAR2(10) NOT NULL Customer Char 10 B
104 CUST_FIELD_C10_C Character(10) VARCHAR2(10) NOT NULL Customer Char 10 C
105 CUST_FIELD_C10_D Character(10) VARCHAR2(10) NOT NULL Customer Char 10 D
106 CUST_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL Customer Char 30 A
107 CUST_FIELD_C30_B Character(30) VARCHAR2(30) NOT NULL Customer Char 30 B
108 CUST_FIELD_C30_C Character(30) VARCHAR2(30) NOT NULL Customer Char 30 C
109 CUST_FIELD_C30_D Character(30) VARCHAR2(30) NOT NULL Customer Char 30 D
110 CUST_FIELD_N12_A Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 A
111 CUST_FIELD_N12_B Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 B
112 CUST_FIELD_N12_C Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 C
113 CUST_FIELD_N12_D Number(16,3) DECIMAL(15,3) NOT NULL Customer Nbr 12.3 D
114 CUST_FIELD_N15_A Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 A
115 CUST_FIELD_N15_B Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 B
116 CUST_FIELD_N15_C Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 C
117 CUST_FIELD_N15_D Number(15,0) DECIMAL(15) NOT NULL Cust Field Nbr 15 D
118 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
119 DATE_LAST_MAINT Date(10) DATE Date Last Maintained
120 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.