NET_CONTRACT

(SQL Table)
 Index Back

Netting Contract

Netting Contract Information

  • Related Language Record: NET_CNTRCT_LNG

  • Parent Record Of NET_CNTRCT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 NET_CONTRACT_ID Character(10) VARCHAR2(10) NOT NULL Contract ID : To identify unique contract.
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    6 PRE_APPROVAL_FLG Character(1) VARCHAR2(1) NOT NULL Pre Approval Flag

    Y/N Table Edit

    7 NET_PARTICIPANT_ID Character(12) VARCHAR2(12) NOT NULL Netting Participant ID, ID to define which Vendors/Customers//Business Units are available to be netted.

    Prompt Table: NET_PARTICIPANT

    8 NETTING_RULE_ID Character(10) VARCHAR2(10) NOT NULL Netting Selection Rule ID

    Prompt Table: NET_RULE_SELECT

    9 NET_SEQ_METHOD_AP Character(2) VARCHAR2(2) NOT NULL Netting Sequence Method AP
    01=Highest Gross Payment Amount
    02=Smallest Gross Payment Amount
    05=By Voucher
    07=By Accounting Date (FIFO)
    08=By Accounting Date (LIFO)
    09=By Due Date (FIFO)
    10=By Due Date (LIFO)
    11=By Distribution Code

    Default Value: 01

    10 NET_SORT_FIELD_AP Character(30) VARCHAR2(30) NOT NULL Sort Field AP

    Default Value: PYMNT_GROSS_AMT

    11 NET_SEQ_METHOD_AR Character(2) VARCHAR2(2) NOT NULL This fileds holds the Netting Sequencing Method
    01=By Highest Bal Amount
    02=By Smallest Bal Amount
    05=By Item
    07=By Accounting Date (FIFO)
    08=By Accounting Date (LIFO)
    09=By Due Date (FIFO)
    10=By Due Date (LIFO)
    11=By Distribution Code

    Default Value: 01

    12 NET_SORT_FIELD_AR Character(30) VARCHAR2(30) NOT NULL Sort Field AR

    Default Value: BAL_AMT

    13 STL_NETSCHED_SETID Character(5) VARCHAR2(5) NOT NULL SetID for Settlement Instructions used on other objects that don't contain setid as part of their key.

    Prompt Table: SP_SINSCD_NONVW

    14 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID

    Prompt Table: STL_SCHEDULE_VW

    15 NET_ADVICE_IND Character(1) VARCHAR2(1) NOT NULL Indicates printed advice is reuired (Y) or not (N)

    Y/N Table Edit

    16 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

    Prompt Table: TR_CONTACT_TBL

    17 NET_BANK_SETID Character(5) VARCHAR2(5) NOT NULL Netting Bank SetID

    Prompt Table: SP_SINBK_NONVW

    18 NET_BANK_CD Character(5) VARCHAR2(5) NOT NULL Netting Bank Code

    Prompt Table: NET_BANK_CD_VW

    19 NET_BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL Netting Bank Account Key

    Prompt Table: NET_BANK_ACT_VW

    20 PAYMENT_METHOD_AR Character(3) VARCHAR2(3) NOT NULL Payment Method - Receivable
    CHK=Check
    DD=Direct Debit
    DR=Draft

    Default Value: CHK

    21 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

    Prompt Table: SP_BUARDE_NONVW

    22 PAYMENT_METHOD_AP Character(3) VARCHAR2(3) NOT NULL Payment Method - Payable
    ACH=ACH
    CHK=System Check
    DD=Direct Debit
    EFT=EFT
    MAN=Manual Check
    WIR=Wire Report

    Default Value: CHK

    23 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

    Prompt Table: SP_SIRMT_NONVW

    24 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor

    Prompt Table: NET_RMT_VNDR_VW

    25 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location

    Default Value: VENDOR.DEFAULT_LOC

    Prompt Table: VNDR_LOC_AP_VW1

    26 BANK_ACCT_SEQ_NBR Number(3,0) SMALLINT NOT NULL Bank Account Sequence Number

    Default Value: 1

    Prompt Table: RMT_BANK_SEQ_VW

    27 PAY_BANK_SETID Character(5) VARCHAR2(5) NOT NULL The PeopleSoft tableset ID for a bank on the disbursing side of a settlement transaction.

    Prompt Table: SP_SINPY_NONVW

    28 PAY_BANK_CD Character(5) VARCHAR2(5) NOT NULL The bank for the disbursing side of a settlement transaction.

    Prompt Table: NET_PAY_BANK_VW

    29 PAY_BANK_ACCT_KEY Character(4) VARCHAR2(4) NOT NULL The bank account for the disbursing side of a settlement transaction.

    Prompt Table: NET_PAY_ACCT_VW

    30 NET_CLOSING_METHOD Character(1) VARCHAR2(1) NOT NULL Closing Method
    F=Full
    P=Partial

    Default Value: P

    31 BUSINESS_UNIT_AR Character(5) VARCHAR2(5) NOT NULL AR Business Unit

    Prompt Table: SP_BU_GL_NONVW

    32 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID

    Prompt Table: SP_SINCST_NONVW

    33 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

    Prompt Table: NET_CUSTOMER_VW

    34 DSTID_SETID Character(5) VARCHAR2(5) NOT NULL Dist ID SetID

    Prompt Table: SP_SETID_NONVW

    35 DST_ID_AR Character(10) VARCHAR2(10) NOT NULL Specifies the general ledger ChartField combination that is affected when subsequent activity such as a payment occurs for the item.

    Prompt Table: DST_CODE_AR_VW

    36 ENTRY_TYPE_SETID Character(5) VARCHAR2(5) NOT NULL Entry Type SetID

    Prompt Table: SP_SETID_NONVW

    37 ENTRY_TYPE Character(5) VARCHAR2(5) NOT NULL Specifies the type of transaction associated with a pending item. The entry type remains with the item after it is posted and affects many areas of Receivables processing. Some examples of entry types are Invoices Credit Memo Prepayment and Deduction.

    Prompt Table: ITEM_ENTRY_VW

    38 ENTRY_REASON Character(5) VARCHAR2(5) NOT NULL "Specifies an entry reason that further qualifies the entry type associated with a pending item. For example an entry reason for a credit memo might be ""Pricing Error"" or ""Shipping Error""."

    Prompt Table: ITEM_REASON_TBL

    39 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

    Prompt Table: SP_BU_AP_NONVW

    40 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Prompt Table: SP_SINVND_NONVW

    41 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VNDR_ACTIVE_VW

    42 DSTCD_SETID Character(5) VARCHAR2(5) NOT NULL Dist Code Setid

    Prompt Table: SP_SETID_NONVW

    43 DST_CNTRL_ID Character(10) VARCHAR2(10) NOT NULL Accounting Template

    Prompt Table: DST_CNTRL_VW

    44 ORIGIN_ID Character(5) VARCHAR2(5) NOT NULL Specifies the source or method of entry for a pending item group.

    Prompt Table: ORIGIN_B_SYS_VW

    45 GROUP_TYPE Character(1) VARCHAR2(1) NOT NULL Specifies a category of transactions included in a group of receivables pending items. The group type affects processing of the transactions and is useful for as a sort/selection option for reports and inquiries. Examples of group type are Billing (for invoices) Payments and Transfers.

    Prompt Table: GROUP_TYPE_I_VW

    46 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin

    Prompt Table: ORIGIN_AP

    47 NET_APPLY_DSCNT Character(1) VARCHAR2(1) NOT NULL Indicates whether to apply AP/AR discount amounts to the netted transactions.

    Y/N Table Edit

    Default Value: N