PeopleSoft 9.0
Cash Management

Table Name NET_STG_AP

Table Description
NET_STG_AP
Columns
Name Datatype Is PK Is FK
NET_REF_ID CHAR(12) Yes Yes
NETTING_SEQ_NO DECIMAL(10) Yes No
BUSINESS_UNIT CHAR(5) Yes Yes
VOUCHER_ID CHAR(8) Yes No
PYMNT_CNT INT Yes No
NETTING_CURRENCY CHAR(3) No No
PYMNT_GROSS_AMT DECIMAL(26,3) No No
DSLCT_BAL_AMT DECIMAL(26,3) No No
NET_PYMNT_AMT DECIMAL(26,3) No No
BAL_PYMNT_AMT DECIMAL(26,3) No No
NET_TXN_STATUS CHAR(2) No No
Index
Name Type Unique Member
PS_NET_STG_AP PK Yes
Member(s) of "PS_NET_STG_AP" Index
NET_REF_ID
NETTING_SEQ_NO
BUSINESS_UNIT
VOUCHER_ID
PYMNT_CNT

Published April 30, 2007