| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
|
| 2 |
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.
|
| 3 |
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.
|
| 4 |
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.
|
| 5 |
FORMAT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency that controls the precision of the amount totals for a group of pending items. If CONTROL_CURRENCY is entered then the same currency code should be used here.
|
| 6 |
WC_POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a control group of pending items has been fully posted to customer accounts. The posting status also indicates whether or not there were errors encountered during posting. This field is automatically populated by the Receivables Update program.
C=Complete
E=Errors
N=Not Posted
|
| 7 |
WC_POST_ACTION |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a group of pending items is ready to be processed by the Receivable Update program. The "action" requested can be no action, priority scheduled or standard scheduled.
A=Do Not Post
G=Post Now To GL
L=Batch Standard
N=Batch Priority
P=Post Now
|
| 8 |
ASSN_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the operator ID of the person who will enter items in a group. This is used when one person enters the control totals and another person enters the actual transactions. The assigned operator is also the person who processes the group and the person who is shown on group inquiry and processing panels.
|
| 9 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 10 |
ENTRY_DT |
Date(10) |
DATE |
Specifies the date that a group of pending items was entered into the system. This date may be later or the same as the date that the items were received by the organization (See RECEIVED_DT).
|
| 11 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 12 |
BAL_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not the control totals for a deposit match the entered totals. A deposit is considered "balanced" when the two sets of totals are equal.
I=Balanced
O=Not Balanced
|
| 13 |
ENTERED_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the total currency amount of all pending items actually entered in a group and is compared with the control total amount. The Receivables Update program automatically calculates this total.
|
| 14 |
DEPOSIT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Deposit Type
A=Amount
B=Balance of Net Pay
P=Percent
|
| 15 |
DEP_POST_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Status
A=All
C=Complete
N=Not Posted
P=Partial
|
| 16 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 17 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
|
| 18 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 19 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 20 |
PAYMENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a customer payment.
|
| 21 |
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.
|
| 22 |
PAYMENT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Status
A=Applied
B=Bounced
C=Complete
E=Identified - Express
I=Identified
J=Directly Journalled
R=Unposted Direct Journal
U=Unidentified
W=Worksheet
|
| 23 |
PAY_WS_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Worksheet Type
C=Credit Card Worksheet
E=ePayment Worksheet
P=Payment Worksheet
|
| 24 |
REMIT_FROM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 25 |
REMIT_FROM_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Remit From Customer
|
| 26 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 27 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 28 |
PP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Predictor
|
| 29 |
PP_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment Predictor Method
|
| 30 |
ALGORITHM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Algorithm Group for Payment Predictor
|
| 31 |
ALGORITHM |
Character(7) |
VARCHAR2(7) NOT NULL |
Algorithm Identifier
|
| 32 |
UNPOST_REASON |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason code for Unposted groups. For informational purposes.
|
| 33 |
CONTROL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the total monetary amount of all transactions within a group of pending items using the entry currency of each item. For mixed currencies this becomes a hash total. Receivables compares the control amount to the actual amount entered and calculates the difference in order to help verify that all entries have been made correctly.
|
| 34 |
CONTROL_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency for all Receivables items in a control group. If this field is not blank the system will accept items with the specified currency only.
|
| 35 |
JOURNAL_COMPLETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Complete
|
| 36 |
KK_TRAN_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Commitment Control Foreign Key for Transaction Identification.
|
| 37 |
KK_TRAN_DT |
Date(10) |
DATE |
Commitment Control Transaction Original processing date. Primary key with KK_TRAN_ID.
|
| 38 |
KK_PROC_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 39 |
KK_PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
E=Errors Exist
I=Document in process
N=Process Unsuccessful
P=Provisionally Valid
V=No Errors or Warnings
W=Only Warnings Exist
X=Unrecorded Errors Exist
|
| 40 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 41 |
WC_CR_CARD_AUTH_ST |
Character(1) |
VARCHAR2(1) NOT NULL |
Credit Card Auth Status
D=Denied
E=Validation Errors
K=No Action
M=Manually Approved/Settled
P=Authorized and Billed
R=Processing
U=Unprocessed/Retry
V=Pending Approval
W=Deleted after Settlement
Z=Zero Payment for Maintenance
|
| 42 |
CR_CARD_AUTH_DT |
Date(10) |
DATE |
Credit Card Authorization Date
|
| 43 |
SELECTED_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Selected Flag
N=Not Selected
Y=Seleted
|
| 44 |
CONTROL_CNT |
Number(6,0) |
INTEGER NOT NULL |
Represents the number of pending items in a control group. Receivables compares the control count to the actual entry count and calculates the difference in order to help verify that all entries have been made correctly
|
| 45 |
RECEIVED_DT |
Date(10) |
DATE |
Specifies the date that a group of pending items was received by the organization. This date may be earlier or the same as the date that the items were actually entered into the system (ENTRY_DT).
|
| 46 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 47 |
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.
|
| 48 |
CC_AFFECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate whether commitment control (revenue estimate) is affected.
N=No
Y=Yes
|
| 49 |
BUDGET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
|
| 50 |
CF_EDIT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not accounting entries have been edited for valid ChartField combinations. If an edit has taken place the status indicates whether or not it was successful. The ChartField Combination Edit program populates the field as Complete Errors or Not Edited.
C=Complete
E=Errors
N=Not Edited
|