PeopleSoft 9.0 Cash Management |
Table Name | NET_STG_AR |
Table Description |
NET_STG_AR |
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 |
CUST_ID | CHAR(15) | Yes | No |
ITEM | CHAR(30) | Yes | No |
ITEM_LINE | INT | Yes | No |
NETTING_CURRENCY | CHAR(3) | No | No |
BAL_AMT | DECIMAL(26,3) | No | No |
DSLCT_BAL_AMT | DECIMAL(26,3) | No | No |
NET_BAL_AMT | DECIMAL(26,3) | No | No |
BAL_BAL_AMT | DECIMAL(26,3) | No | No |
NET_TXN_STATUS | CHAR(2) | No | No |
Index |
Name | Type | Unique | Member |
PS_NET_STG_AR | PK | Yes |
![]() |
PSANET_STG_AR | IE1 | No |
![]() |
Member(s) of "PS_NET_STG_AR" Index |
NET_REF_ID |
NETTING_SEQ_NO |
BUSINESS_UNIT |
CUST_ID |
ITEM |
ITEM_LINE |
Member(s) of "PSANET_STG_AR" Index |
BUSINESS_UNIT |
CUST_ID |
ITEM |
ITEM_LINE |
Published April 30, 2007 |