NET_STG_AP

(SQL Table)
Index Back

Netting Staging AP

  • Parent record: NET_STG_HDR
  • # 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