NET_STG_AP(SQL Table) |
Index Back |
---|---|
Netting Staging 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 | NETTING_SEQ_NO | Number(10,0) | DECIMAL(10) NOT NULL | Netting Sequence Number |
3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_AP_NONVW |
4 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL |
Voucher ID
Prompt Table: NET_VCHR_VN_VW |
5 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL |
Payments
Prompt Table: NET_XREF_VW |
6 | NETTING_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Netting Currency |
7 | PYMNT_GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Payment Amount |
8 | DISC_AVAIL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Discount Applied Amount |
9 | DISC_APPL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bi-Lateral Netting - Discount Applied Amount |
10 | DSLCT_BAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | DeSelected Amount |
11 | NET_PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Netting Payment Amount |
12 | BAL_PYMNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Balance Payment Amount |
13 | NET_TXN_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Transaction Status
B=Balance D=DeSelect - Full DB=DeSelect Split - Balance DF=DeSelect - Full DN=DeSelect Split - Net N=Net NA=Not Applicable S=Split - Net / Balance |