| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
|
| 3 |
DEPOSIT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a deposit of customer payments. The deposit ID can be manually assigned or system-generated.
|
| 4 |
PAYMENT_SEQ_NUM |
Number(6,0) |
INTEGER NOT NULL |
Specifies the system-generated sequence number assigned to each payment as it is entered in a deposit.
|
| 5 |
PAYMENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a customer payment.
|
| 6 |
PAYMENT_DT |
Date(10) |
DATE |
Payment Date
|
| 7 |
PP_MICR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Customers Identified
I=Doesn't Matter
M=More Than One
N=None
S=One
Default Value: N
|
| 8 |
PP_REF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
References Supplied
D=Detail
I=Doesn't Matter
N=No
Y=Summary
Default Value: N
|
| 9 |
ALGORITHM |
Character(7) |
VARCHAR2(7) NOT NULL |
Algorithm Identifier
|
| 10 |
PP_APPL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Application Status
C=Completely Applied
N=Not Applied
O=Over Applied
U=Under Applied
|
| 11 |
PP_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment Predictor Method
|
| 12 |
PP_DISPOSITION |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Disposition
N=Do Nothing
P=Post
W=Generate Worksheet
Default Value: N
|
| 13 |
ALGORITHM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Algorithm Group for Payment Predictor
|
| 14 |
GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Uniquely identifies a collection of pending items that are to be posted to accounts receivable. The identifier is manually entered or automatically generated by the system.
|
| 15 |
PAYMENT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the currency of a customer payment. This is generally the same as the currency specified for the deposit but it can be different.
|
| 16 |
PYMT_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the type of exchange rate to be used when the currency of a customer payment is converted to the base currency of a business unit. The exchange rate type is also called the market rate type. Examples are spot rate current rate and official rate.
|
| 17 |
PYMT_RATE_MULT |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Specifies the number (the multiplier) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_ RATE_DIV. Refer to documentation on the Triangulation Process for the exact calculation.
|
| 18 |
PYMT_RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Specifies the number (the divisor) required to convert a payment amount from its entry currency to the business unit base currency. The number is based on the exchange rate specified for the transaction. It is used in conjunction with PYMT_RATE_MULT. Refer to documentation on the Triangulation Process for the exact calculation.
Default Value: 1
|
| 19 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 20 |
PP_GENITM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Generate Item Switch
Y/N Table Edit
Default Value: N
|
| 21 |
PAYMENT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Identifies a customer payment. This is usually a check number but may be some other identifying number.
|
| 22 |
PP_MET_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Method Setid
|
| 23 |
CASH_CNTRL_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) a payment group created by a payment worksheet or by Payment Predictor includes a cash control entry debiting cash.
|
| 24 |
REF_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Reference Level of Detail
|
| 25 |
DOC_TYPE |
Character(8) |
VARCHAR2(8) NOT NULL |
Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
|
| 26 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 27 |
DOC_SEQ_DATE |
Date(10) |
DATE |
Specifies the date that a document sequence number is assigned to a document or the date the document was created.
|
| 28 |
DOC_SEQ_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status
|
| 29 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 30 |
RUN_DT |
Date(10) |
DATE |
Run Date
|
| 31 |
NULL_DATE |
Date(10) |
DATE |
Date field with NULL value
|
| 32 |
PAY_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Payment Amt - Base Curr
|
| 33 |
TOTAL_CREDIT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The total credit amount for a given accounting entry build.
|
| 34 |
TOTAL_DEBIT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
The total debit amount for a given accounting entry build.
|
| 35 |
GROUP_ID_SEQ_NUM |
Number(15,0) |
DECIMAL(15) NOT NULL |
Group ID
|
| 36 |
PROCESS_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Flag
A=Purge All
S=Only purge items with at least
Default Value: N
|