CUSTOMER_EVW (SQL View)	Index Back
Customer Header View Date Init. Issue # Description 07/24/01 JJM DI-EDWONG-17 Add Grants and Receivables fields 10/09/01 JJM DI-EDWONG-17 Added CNTCT_SEQ_OPAC 112202 KTW F-MULINAR-3 VAT on Services - Delete Vat fields 022808 KPS 1744817001 Removed the defaulted value for the field FED_SHARE_PCT in the Sub Record CUSTOMER_SBR

CUSTOMER_EVW

(SQL View)

Customer Header View

Date Init. Issue # Description 07/24/01 JJM DI-EDWONG-17 Add Grants and Receivables fields 10/09/01 JJM DI-EDWONG-17 Added CNTCT_SEQ_OPAC 112202 KTW F-MULINAR-3 VAT on Services - Delete Vat fields 022808 KPS 1744817001 Removed the defaulted value for the field FED_SHARE_PCT in the Sub Record CUSTOMER_SBR

SELECT C.SETID , C.CUST_ID , %subrec(CUSTOMER_SBR, C) FROM PS_CUSTOMER C WHERE C.CUST_STATUS IN ('A','I')

Related Language Record: CUSTOMER_EVWLNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

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.
Prompt Table: CUSTOMER

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
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. Prompt Table: CUSTOMER
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.