| # |
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
Prompt Table:
NET_STG_HDR
|
| 2 |
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
|
| 3 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 4 |
NET_CONTRACT_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Contract ID : To identify unique contract.
Prompt Table:
NET_CONTRACT_VW
|
| 5 |
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
|
| 6 |
NETTING_RULE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Netting Selection Rule ID
Prompt Table:
NET_RULE_SELECT
|
| 7 |
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
|
| 8 |
NET_SORT_FIELD_AP |
Character(30) |
VARCHAR2(30) NOT NULL |
Sort Field AP
|
| 9 |
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
|
| 10 |
NET_SORT_FIELD_AR |
Character(30) |
VARCHAR2(30) NOT NULL |
Sort Field AR
|
| 11 |
CONTACT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Contact Identifier for Treasury Contacts
Prompt Table:
TR_CONTACT_TBL
|
| 12 |
NETTING_DATE |
Date(10) |
DATE |
Netting Date. Used to Define the date that the netting will take place.
|
| 13 |
NETTING_STL_DATE |
Date(10) |
DATE |
Netting Settlement Date. This date becomes the due date of the Netting Balance for AP and AR transactions.
|
| 14 |
PAYMENT_METHOD_AR |
Character(3) |
VARCHAR2(3) NOT NULL |
Payment Method - Receivable
CHK=Check
DD=Direct Debit
DR=Draft
|
| 15 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
Prompt Table:
SP_BUNAR_NONVW
|
| 16 |
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
|
| 17 |
REMIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Remit SetID
Prompt Table:
SP_SIRMT_NONVW
|
| 18 |
REMIT_VENDOR |
Character(10) |
VARCHAR2(10) NOT NULL |
Remit Vendor
Prompt Table:
NET_RMT_VNDR_VW
|
| 19 |
VNDR_LOC |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Location
Prompt Table:
VNDR_LOC_AP_VW1
|
| 20 |
BANK_ACCT_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Bank Account Sequence Number
Prompt Table:
RMT_BANK_SEQ_VW
|
| 21 |
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
|
| 22 |
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
|
| 23 |
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
|
| 24 |
NET_BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Netting Bank SetID
Prompt Table:
SP_SINBK_NONVW
|
| 25 |
NET_BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Netting Bank Code
Prompt Table:
NET_BANK_CD_VW
|
| 26 |
NET_BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
Netting Bank Account Key
Prompt Table:
NET_BANK_ACT_VW
|
| 27 |
NETTING_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Netting Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 28 |
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
|
| 29 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 30 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 31 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 32 |
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
|
| 33 |
TOTAL_PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Payment Amount - Base
|
| 34 |
PAY_DISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Payable Discount Available Amount
|
| 35 |
PAY_DISC_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Payable Discount Available Amount Base
|
| 36 |
PAY_DISC_APPL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Payable Discount Paid Amount
|
| 37 |
PAY_DISC_APPL_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Payable Discount Paid Amount Base
|
| 38 |
TOTAL_AP_TXNS |
Number(5,0) |
INTEGER NOT NULL |
Total Payable Transactions
|
| 39 |
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
|
| 40 |
TOTAL_REC_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Receivable Amount - Base
|
| 41 |
RCV_DISC_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Receivable Discount Available Amount
|
| 42 |
RCV_DISC_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Receivable Discount Available Amount Base
|
| 43 |
RCV_DISC_APPL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Receivable Discount Paid Amount
|
| 44 |
RCV_DISC_APPL_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Bi-Lateral Netting - Receivable Discount Paid Amount Base
|
| 45 |
TOTAL_AR_TXNS |
Number(5,0) |
INTEGER NOT NULL |
Total Receivable Transactions
|
| 46 |
NET_BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Netted Amount
|
| 47 |
NET_BAL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Netting Balance Amount Base
|
| 48 |
BAL_BAL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance Amount
|
| 49 |
BAL_BAL_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Balance Amount Base
|
| 50 |
PRE_APPROVAL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Pre Approval Flag
|
| 51 |
NET_ADJUST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjust Type
N=No Adjust
Y=Adjust
|
| 52 |
NET_PROCESS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Type
A=Automatic Netting
M=Manual Netting
|
| 53 |
NET_CLOSING_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Closing Method
F=Full
P=Partial
|
| 54 |
BUSINESS_UNIT_AR |
Character(5) |
VARCHAR2(5) NOT NULL |
AR Business Unit
|
| 55 |
CUST_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Customer SetID
Prompt Table:
NET_CUST_SET_VW
|
| 56 |
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
|
| 57 |
ENTRY_TYPE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Entry Type SetID
Prompt Table:
SP_SETID_NONVW
|
| 58 |
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
|
| 59 |
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
|
| 60 |
DSTID_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Dist ID SetID
Prompt Table:
SP_SETID_NONVW
|
| 61 |
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
|
| 62 |
BUSINESS_UNIT_AP |
Character(5) |
VARCHAR2(5) NOT NULL |
AP Business Unit
Prompt Table:
SP_BUNAP_NONVW
|
| 63 |
VENDOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table:
NET_VNDR_SET_VW
|
| 64 |
VENDOR_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table:
VNDR_ACTIVE_VW
|
| 65 |
DSTCD_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Dist Code Setid
Prompt Table:
SP_SETID_NONVW
|
| 66 |
DST_CNTRL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Accounting Template
Prompt Table:
DST_CNTRL_VW
|
| 67 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 68 |
RUN_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control Operator ID
|
| 69 |
RUN_DTTM |
DateTime(26) |
TIMESTAMP |
Run Date and Time
|
| 70 |
APPROVAL_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A system generated value that reflects the operator that approved a given transaction.
|
| 71 |
APPROVAL_DTTM |
DateTime(26) |
TIMESTAMP |
A system generated value that reflects the date and time a given transaction is approved by an oper
|
| 72 |
OPRID_ENTERED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Entered By
07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase.
03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!!
FYI - The alternatives to use a User ID as uppercase:
1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID
2) Use %Upper meta-SQL in SQL statements
3) Use Upper function in peoplecodes
|
| 73 |
DTTM_ENTERED |
DateTime(26) |
TIMESTAMP |
Date Time Stamp for Entry
|
| 74 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
|
| 75 |
LAST_DTTM_UPDATE |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 76 |
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
|
| 77 |
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
|
| 78 |
VAT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements.
|
| 79 |
VAT_CALC_GROSS_NET |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether VAT calculation should be done on the Gross (G) amount or on the Net (N) amount of sales or purchase transaction. When calculating VAT at net the early payment discount is applied to the goods amount before calculating the VAT. When calculating VAT at gross the VAT is initially calculated based on the gross transaction amount.
G=Calculate at Gross
N=Calculate at Net
|
| 80 |
VAT_EXCPTN_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies the reason for a VAT exemption for a customer. Suspension (S) and Exoneration (X) are examples of Exception Type.
N=None
S=Suspended
X=Exonerated
|
| 81 |
VAT_DCLRTN_POINT |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that specifies when VAT information for sales or purchase transaction is recognized for reporting to the appropriate VAT authority. VAT is declared at invoice time, delivery time, accounting date or the time of payment.
A=At Accounting Date
D=At Delivery Time
I=At Invoice Time
P=At Payment Time
|
| 82 |
VAT_RECALC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the VAT discount amount is recalculated at payment time. This field is only used if the VAT Calculation Type (VAT_CAL_GROSS_NET) is gross.
|
| 83 |
COUNTRY_VAT_BILLFR |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country where an invoice is generated (for VAT processing only).
|
| 84 |
COUNTRY_SHIP_TO |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country to which the invoice contents were shipped (for VAT processing only).
|
| 85 |
COUNTRY_SHIP_FROM |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the country from which the invoice contents were shipped (for VAT processing only).
|
| 86 |
VAT_ROUND_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
" Rounding rule to be applied to VAT calculations. Options are 'Natural'
D=Round Down
N=Natural Round
U=Round Up
|
| 87 |
VAT_ADVPAY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
VAT prepayment flag is to indicate if the VAT amount should be calculated on the advance payments
|
| 88 |
VAT_TRANS_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the sale or purchase amount against which the VAT is applicable.
|
| 89 |
VAT_TXN_TYPE_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
|
| 90 |
VAT_CALC_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive
I=Inclusive
|
| 91 |
ORIGIN |
Character(3) |
VARCHAR2(3) NOT NULL |
Origin
Prompt Table:
ORIGIN_AP
|
| 92 |
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
|