NET_STG_AP_VW(SQL View) |
Index Back |
|---|---|
Netting Stage AP ViewNetting Stage AP View |
| SELECT NET_REF_ID , BUSINESS_UNIT , VOUCHER_ID , PYMNT_CNT FROM PS_NET_STG_AP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NET_REF_ID | Character(12) | VARCHAR2(12) NOT NULL | A reference identifier associated with a cash transaction subject to netting with a given bank/count |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 4 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |