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 |