PeopleSoft 9.0
Cash Management

Table Name NET_MANUAL_RQST

Table Description
NET_MANUAL_RQST
Columns
Name Datatype Is PK Is FK
NET_REF_ID CHAR(12) Yes Yes
NETTING_DATE PSDATE No No
REQUEST_STATUS CHAR(1) No No
NET_HDR_STATUS CHAR(1) No No
NET_CLOSING_METHOD CHAR(1) No No
DESCR CHAR(30) No No
NETTING_BU CHAR(5) No No
CONTACT_ID CHAR(15) No No
NETTING_STL_DATE PSDATE 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_BANK_SETID CHAR(5) No No
NET_BANK_CD CHAR(5) No No
NET_BANK_ACCT_KEY CHAR(4) No No
NETTING_CURRENCY CHAR(3) No No
BASE_CURRENCY CHAR(3) No No
TOTAL_PAY_AMT DECIMAL(26,3) No No
TOTAL_PAY_AMT_BASE DECIMAL(26,3) No No
TOTAL_RCV_AMT DECIMAL(26,3) No No
TOTAL_REC_AMT_BASE DECIMAL(26,3) No No
TOTAL_AR_TXNS INT No No
TOTAL_AP_TXNS INT No No
NET_BAL_AMT DECIMAL(26,3) No No
NET_BAL_AMT_BASE DECIMAL(26,3) No No
BAL_BAL_AMT DECIMAL(26,3) No No
BAL_BAL_AMT_BASE DECIMAL(26,3) No No
BUSINESS_UNIT_AR CHAR(5) No No
CUST_SETID CHAR(5) No No
CUST_ID CHAR(15) No No
ENTRY_TYPE_SETID CHAR(5) No No
ENTRY_TYPE CHAR(5) No No
ENTRY_REASON CHAR(5) No No
DSTID_SETID CHAR(5) No No
DST_ID_AR CHAR(10) 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_MANUAL_RQST PK Yes
PS0NET_MANUAL_RQST IE1 No
PS1NET_MANUAL_RQST IE2 No
Member(s) of "PS_NET_MANUAL_RQST" Index
NET_REF_ID
Member(s) of "PS0NET_MANUAL_RQST" Index
DESCR
NET_REF_ID
Member(s) of "PS1NET_MANUAL_RQST" Index
CONTACT_ID
NET_REF_ID

Published April 30, 2007