| # |
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
|
| 2 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
|
| 3 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 4 |
CUSTOMER_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
Default Value: CONTACT.SETID
Prompt Table:
SP_SETID_NONVW
|
| 5 |
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:
CUST_ALL_CNT_VW
|
| 6 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 7 |
CNTCT_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Contact Sequence Number
|
| 8 |
ADDRESS_SEQ_NUM |
Number(5,0) |
INTEGER NOT NULL |
Address Sequence Number
Prompt Table:
CUST_ADDR_CNE_V
|
| 9 |
BILL_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Bill To Customer
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 10 |
SOLD_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sold To Customer
Y/N Table Edit
Default Value: N
|
| 11 |
SHIP_TO_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ship To Customer
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 12 |
BROKER_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Broker Customer
Y/N Table Edit
Default Value: N
|
| 13 |
CRSPD_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Correspondence Customer
Y/N Table Edit
Default Value: N
|
| 14 |
VIEW_STMT_IMAGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Init Issue Description
040209 JJM eBill Stmt Img Added VIEW_STMT_IMAGE field
Y/N Table Edit
Default Value: N
|
| 15 |
ADDRESS_MAINT |
Character(1) |
VARCHAR2(1) NOT NULL |
Maintain Addresses
Y/N Table Edit
Default Value: N
|
| 16 |
ORDER_SAVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Order Save
Y/N Table Edit
Default Value: N
|
| 17 |
ALL_ORDERS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
All Orders Flag
N=No
Y=Yes
Default Value: N
|
| 18 |
CONTACT_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Contact Type Code
Prompt Table:
CUST_CNTCT_CODE
|
| 19 |
PRIMARY_CUST |
Character(1) |
VARCHAR2(1) NOT NULL |
Primary Customer
Y/N Table Edit
Default Value: N
|
| 20 |
LAST_MAINT_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Maintained By Operator ID
|
| 21 |
DATE_LAST_MAINT |
Date(10) |
DATE |
Date Last Maintained
|