| # |
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:
FO_CST_ALL_A1_V
|
| 3 |
CUST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Status
A=Active
I=Inactive
T=Template
Default Value: A
|
| 4 |
USER_STATUS |
Character(6) |
VARCHAR2(6) NOT NULL |
User Status
Prompt Table:
CUST_STATUS_VW
|
| 5 |
CUST_STATUS_DT |
Date(10) |
DATE |
Customer Status Date
|
| 6 |
NAMESHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Name
|
| 7 |
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
|
| 8 |
SINCE_DT |
Date(10) |
DATE NOT NULL |
Customer Since
Default Value: %date
|
| 9 |
ADD_DT |
Date(10) |
DATE NOT NULL |
Customer Added On
Default Value: %date
|
| 10 |
NAME1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1
|
| 11 |
NAME2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 2
|
| 12 |
NAME3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 3
|
| 13 |
NAME1_AC |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 1 Alternate Char Set
|
| 14 |
NAME2_AC |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 2 Alternate Char Set
|
| 15 |
NAME3_AC |
Character(40) |
VARCHAR2(40) NOT NULL |
Name 3 Alternate Char Set
|
| 16 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
CUST_ADDR_N_VW
|
| 17 |
SALES_PERSON |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the personnel code for the person who works with a customer as a sales representative. This field is required for a customer that functions as a bill-to customer.
|
| 18 |
CORPORATE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 19 |
CORPORATE_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Corporate Customer
Prompt Table:
FO_CST_C_A1_VW
|
| 20 |
REMIT_FROM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 21 |
REMIT_FROM_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Remit From Customer
|
| 22 |
CRSPD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 23 |
CRSPD_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Correspondence Customer
|
| 24 |
CONSOL_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Billing business unit associated with a consolidated bill.
|
| 25 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
|
| 26 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
|
| 27 |
REFER_TO_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Refer To Setid
|
| 28 |
REFER_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Refer To Customer
|
| 29 |
REVIEW_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Review Days
|
| 30 |
FORMER_NAME_1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Former Name 1
|
| 31 |
FORMER_NAME_2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Former Name 2
|
| 32 |
SUBCUST_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
SubCustomer
Y/N Table Edit
Default Value: N
|
| 33 |
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.
|
| 34 |
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.
|
| 35 |
CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Currency Rate Type
Default Value: CRRNT
Prompt Table:
RTTYPETBL_UPG
|
| 36 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: USD
Prompt Table:
CURRENCY_CD_TBL
|
| 37 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
|
| 38 |
SHIP_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship To Customer
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 39 |
BILL_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill To Customer
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 40 |
SOLD_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sold To Customer
Y/N Table Edit
Default Value: N
|
| 41 |
BROKER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Broker Customer
Y/N Table Edit
Default Value: N
|
| 42 |
INDIRECT_CUST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Indirect Customer
Y/N Table Edit
Default Value: N
|
| 43 |
CUST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Level
N=New
P=Prospect
R=Regular
S=Short-Term
T=Temporary
Default Value: R
|
| 44 |
HOLD_UPDATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Update Switch
Y/N Table Edit
Default Value: N
|
| 45 |
ROLEUSER |
Character(30) |
VARCHAR2(30) NOT NULL |
Role User
|
| 46 |
TAXPAYER_ID |
Character(14) |
VARCHAR2(14) NOT NULL |
Taxpayer ID
|
| 47 |
WEB_URL |
Character(130) |
VARCHAR2(130) NOT NULL |
Website URL
Default Value: http://
|
| 48 |
STOCK_SYMBOL |
Character(10) |
VARCHAR2(10) NOT NULL |
Stock Symbol
|
| 49 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 50 |
DATE_LAST_MAINT |
Date(10) |
DATE |
Date Last Maintained
|
| 51 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Default Value: OPRDEFTBL_UPG.DEPTID
Prompt Table:
DEPTTBL_UPG
|
| 52 |
SALES_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Sales Operator
Default Value: PSOPRDEFN.OPRID
Prompt Table:
OPRID_VW
|
| 53 |
SERVICE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Service Operator
Default Value: PSOPRDEFN.OPRID
Prompt Table:
OPRID_VW
|
| 54 |
YEAR_START_DT |
Date(10) |
DATE |
Year Start Date
|
| 55 |
FEDERAL_EIN |
Number(9,0) |
DECIMAL(9) NOT NULL |
Federal EIN
|
| 56 |
INDUSTRY |
Character(4) |
VARCHAR2(4) NOT NULL |
Industry
CORE=Core
EDUC=Education
FNSV=Financial Services
GOVT=Government
HLTH=Health Care
RETL=Retail
TRAN=Transportation
UTIL=Utilities
Prompt Table:
SIC_CD_VW1
|
| 57 |
SALES_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Sales Level
1=Over 1,000,000
2=500,000 - 999,999
3=100,000 - 499,999
4=30,000 - 99,999
5=0 - 29,000
9=Not Investigated
|
| 58 |
WORKFORCE_SIZE |
Character(1) |
VARCHAR2(1) NOT NULL |
Workforce Size
1=1 - 4
2=5 - 9
3=10 - 19
4=20 - 49
5=50 - 99
6=100 - 499
7=500 - 999
8=Over 1,000
|
| 59 |
OT_PERCENT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Overtime Percentage
|
| 60 |
PROSPECT_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer/Prospect Flag
Y/N Table Edit
|
| 61 |
EMAIL_ADDR |
Character(70) |
VARCHAR2(70) NOT NULL |
Email Address
|
| 62 |
RECV_BALANCE |
Signed Number(14,2) |
DECIMAL(12,2) NOT NULL |
Receivables Balance
|
| 63 |
FO_CONTRACT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Contract Type
BRAN=Branch
NATL=National
REGN=Regional
RETA=Retail
|
| 64 |
FO_SERVICE_LEVEL |
Character(4) |
VARCHAR2(4) NOT NULL |
Service Level
MGD=Managed Services
NMGD=Non Managed Services
|
| 65 |
FO_MARKUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Markup
NSTD=Non Standard Markup
STD=Standard Markup
|
| 66 |
MARKUP_MULTIPLIER |
Signed Number(11,6) |
DECIMAL(9,6) NOT NULL |
Markup Multiplier
|