| # |
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
Default Value: NEXT
Prompt Table:
NET_MANUAL_RQST
|
| 2 |
NETTING_DATE |
Date(10) |
DATE |
Netting Date. Used to Define the date that the netting will take place.
|
| 3 |
REQUEST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
To detemine Manual Request Status (Netting)
I=Work In Progress
S=Submitted
Default Value: I
|
| 4 |
NET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates the status of a given Netting Run:
Open
Approve
Cancel
Close
A=Approved
C=Closed
O=Open
X=Cancelled
Default Value: O
|
| 5 |
NET_CLOSING_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Closing Method
F=Full
P=Partial
Default Value: P
|
| 6 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 7 |
NETTING_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Holds GL Business Unit
Prompt Table:
SP_BUNGL_NONVW
|
| 8 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
TR_CONTACT_TBL
|
| 9 |
NETTING_STL_DATE |
Date(10) |
DATE |
Netting Settlement Date. This date becomes the due date of the Netting Balance for AP and AR transactions.
|
| 10 |
PAYMENT_METHOD_AR |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method - Receivable
CHK=Check
DD=Direct Debit
DR=Draft
Default Value: CHK
|
| 11 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
Prompt Table:
SP_BUNAR_NONVW
|
| 12 |
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
|
| 13 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
Prompt Table:
SP_SIRMT_NONVW
|
| 14 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
Prompt Table:
NET_RMT_VNDR_VW
|
| 15 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
VNDR_LOC_AP_VW1
|
| 16 |
BANK_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
Default Value: 1
Prompt Table:
RMT_BANK_SEQ_VW
|
| 17 |
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
|
| 18 |
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
|
| 19 |
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
|
| 20 |
NET_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Netting Bank SetID
Prompt Table:
SP_SINBK_NONVW
|
| 21 |
NET_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Netting Bank Code
Prompt Table:
NET_BANK_CD_VW
|
| 22 |
NET_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
Netting Bank Account Key
Prompt Table:
NET_BANK_ACT_VW
|
| 23 |
NETTING_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Netting Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 24 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
Prompt Table:
CURRENCY_CD_TBL
|
| 25 |
TOTAL_PAY_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
An internal work field in the settlements module that contains a summary of all outbound transact
|
| 26 |
TOTAL_PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Payment Amount - Base
|
| 27 |
PAY_DISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Payable Discount Available Amount
|
| 28 |
PAY_DISC_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Payable Discount Available Amount Base
|
| 29 |
TOTAL_RCV_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
An internal work field in the settlements module that contains a summary of all inbound transacti
|
| 30 |
TOTAL_REC_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Receivable Amount - Base
|
| 31 |
RCV_DISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Receivable Discount Available Amount
|
| 32 |
RCV_DISC_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Receivable Discount Available Amount Base
|
| 33 |
TOTAL_AR_TXNS |
Number(5,0) |
INTEGER NOT NULL |
Total Receivable Transactions
|
| 34 |
TOTAL_AP_TXNS |
Number(5,0) |
INTEGER NOT NULL |
Total Payable Transactions
|
| 35 |
NET_BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Netted Amount
|
| 36 |
NET_BAL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Netting Balance Amount Base
|
| 37 |
BAL_BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance Amount
|
| 38 |
BAL_BAL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance Amount Base
|
| 39 |
BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
|
| 40 |
CUST_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
Prompt Table:
SP_SINCST_NONVW
|
| 41 |
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
|
| 42 |
ENTRY_TYPE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Entry Type SetID
Prompt Table:
SP_SETID_NONVW
|
| 43 |
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
|
| 44 |
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:
ENTRY_REASN_TBL
|
| 45 |
DSTID_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Dist ID SetID
Prompt Table:
SP_SETID_NONVW
|
| 46 |
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
|
| 47 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
SP_BUNAP_NONVW
|
| 48 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table:
SP_SINVND_NONVW
|
| 49 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VNDR_ACTIVE_VW
|
| 50 |
DSTCD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Dist Code Setid
Prompt Table:
SP_SETID_NONVW
|
| 51 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table:
DST_CNTRL_VW
|
| 52 |
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
|
| 53 |
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
|
| 54 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
Prompt Table:
ORIGIN_AP
|
| 55 |
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
|