PeopleSoft 9.0
Cash Management

Table Name NET_CONTRACT

Table Description
NET_CONTRACT
Columns
Name Datatype Is PK Is FK
NET_CONTRACT_ID CHAR(10) Yes No
EFFDT datetime Yes No
EFF_STATUS CHAR(1) No No
DESCR CHAR(30) No No
DESCR254 CHAR(254) No No
PRE_APPROVAL_FLG CHAR(1) No No
NET_PARTICIPANT_ID CHAR(12) No Yes
NETTING_RULE_ID char(10) No Yes
NET_SEQ_METHOD_AP CHAR(2) No No
NET_SORT_FIELD_AP CHAR(30) No No
NET_SEQ_METHOD_AR CHAR(2) No No
NET_SORT_FIELD_AR CHAR(30) No No
STL_NETSCHED_SETID CHAR(5) No No
SCHEDULE CHAR(10) No No
NET_ADVICE_IND CHAR(1) No No
CONTACT_ID CHAR(15) No No
NET_BANK_SETID CHAR(5) No No
NET_BANK_CD CHAR(5) No No
NET_BANK_ACCT_KEY CHAR(4) No No
PAYMENT_METHOD_AR CHAR(3) No No
DEPOSIT_BU CHAR(5) No No
PAYMENT_METHOD_AP CHAR(3) No No
REMIT_SETID CHAR(5) No No
REMIT_VENDOR CHAR(10) No No
VNDR_LOC CHAR(10) No No
BANK_ACCT_SEQ_NBR SMALLINT No No
PAY_BANK_SETID CHAR(5) No No
PAY_BANK_CD CHAR(5) No No
PAY_BANK_ACCT_KEY CHAR(4) No No
NET_CLOSING_METHOD CHAR(1) No No
BUSINESS_UNIT_AR CHAR(5) No No
CUST_SETID CHAR(5) No No
CUST_ID CHAR(15) No No
DSTID_SETID CHAR(5) No No
DST_ID_AR CHAR(10) No No
ENTRY_TYPE_SETID CHAR(5) No No
ENTRY_TYPE CHAR(5) No No
ENTRY_REASON CHAR(5) No No
BUSINESS_UNIT_AP CHAR(5) No No
VENDOR_SETID CHAR(5) No No
VENDOR_ID CHAR(10) No No
DSTCD_SETID CHAR(5) No No
DST_CNTRL_ID CHAR(10) No No
ORIGIN_ID CHAR(5) No No
GROUP_TYPE CHAR(1) No No
ORIGIN CHAR(3) No No
Index
Name Type Unique Member
PS_NET_CONTRACT PK Yes
PS0NET_CONTRACT IE1 No
PS1NET_CONTRACT IE2 No
PS2NET_CONTRACT IE3 No
PS3NET_CONTRACT IE4 No
Member(s) of "PS_NET_CONTRACT" Index
NET_CONTRACT_ID
EFFDT
Member(s) of "PS0NET_CONTRACT" Index
DESCR
NET_CONTRACT_ID
EFFDT
Member(s) of "PS1NET_CONTRACT" Index
NET_PARTICIPANT_ID
NET_CONTRACT_ID
EFFDT
Member(s) of "PS2NET_CONTRACT" Index
SCHEDULE
NET_CONTRACT_ID
EFFDT
Member(s) of "PS3NET_CONTRACT" Index
CONTACT_ID
NET_CONTRACT_ID
EFFDT

Published April 30, 2007