| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PSARCH_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
|
| 2 |
PSARCH_BATCHNUM |
Number(30,0) |
DECIMAL(30) NOT NULL |
Archive Batch Number
|
| 3 |
DEPOSIT_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Identifies the business unit to which a deposit is posted.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table:
SP_BUARDE_NONVW
|
| 4 |
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.
|
| 5 |
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.
|
| 6 |
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.
|
| 7 |
PAYMENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a customer payment.
|
| 8 |
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
Default Value: U
|
| 9 |
AR_WOAPPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Status
A=Approved Write-Off
D=Denied Write-Off
I=Initial
P=Pending Write-Off Approval
|
| 10 |
PAYMENT_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the preferred method of payment by a customer. Examples of payment method are check direct debit and draft.
10/28/2003 edw 655070000 - Removed LTC and CSH xlats.
ACH=ACH
CC=Credit Card
CHK=Check
CSH=Cash
DD=Direct Debit
DR=Draft
EC=Electronic Check
EFT=Electronic Fund Transfer
GE=Giro - EFT
PL=PayPal
WIR=Wire Report
|
| 11 |
ENTRY_DT |
Date(10) |
DATE NOT NULL |
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).
|
| 12 |
ACCOUNTING_DT |
Date(10) |
DATE NOT NULL |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: DEPOSIT_CONTROL.ACCOUNTING_DT
|
| 13 |
POST_DT |
Date(10) |
DATE |
The Date a transaction was Posted.
|
| 14 |
SEL_CUST_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via Customer ID
Y/N Table Edit
Default Value: N
|
| 15 |
SEL_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via Postal
Y/N Table Edit
Default Value: N
|
| 16 |
SEL_REMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via REMIT TO
Y/N Table Edit
Default Value: N
|
| 17 |
SEL_CORP_ACCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via CORP ACCT
Y/N Table Edit
Default Value: N
|
| 18 |
SEL_MICR |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via MICR ID
Y/N Table Edit
Default Value: N
|
| 19 |
SEL_OPEN_ITEM |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via OPEN ITEM
Y/N Table Edit
Default Value: N
|
| 20 |
SEL_DOCUMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Select items via DOCUMENT
Y/N Table Edit
Default Value: N
|
| 21 |
SEL_REF_RANGE |
Character(1) |
VARCHAR2(1) NOT NULL |
Range of References
Y/N Table Edit
Default Value: N
|
| 22 |
ID_SEQ_CUST |
Number(3,0) |
SMALLINT NOT NULL |
Sequence control for CUST ID
|
| 23 |
ID_SEQ_ITEM |
Number(5,0) |
INTEGER NOT NULL |
Sequence control for ITEM
|
| 24 |
AMT_SEL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount selected
|
| 25 |
AMT_ADJ |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Adjusted
|
| 26 |
AMT_REM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount Remaining
|
| 27 |
DISC_TAKEN |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discount Taken
|
| 28 |
DISC_EARNED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Discounts Earned
|
| 29 |
DISC_UNEARNED |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Unearned Discounts
|
| 30 |
WS_COUNT |
Number(5,0) |
INTEGER NOT NULL |
Worksheet Items
|
| 31 |
WS_DTTM |
DateTime(26) |
TIMESTAMP |
Worksheet Created Date/Time
|
| 32 |
WS_SEQ_ITEM |
Number(5,0) |
INTEGER NOT NULL |
Worksheet item sequence number
|
| 33 |
GL_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal
Default Value: N
|
| 34 |
DST_DT |
Date(10) |
DATE |
Distribution Date
|
| 35 |
JOURNAL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
|
| 36 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 37 |
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.
|
| 38 |
PP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Predictor
Y/N Table Edit
Default Value: N
|
| 39 |
DISC_USED_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount used switch
Y/N Table Edit
Default Value: N
|
| 40 |
WO_USED_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Write Off's Used
Y/N Table Edit
Default Value: N
|
| 41 |
WO_ITEM_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Write Off Item
|
| 42 |
WO_ADJ_USED_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Write Off Adjustmet from WS
Y/N Table Edit
Default Value: N
|
| 43 |
WS_UPDATED_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Worksheet updated switch
Default Value: N
|
| 44 |
LOCKBOX_PYMNT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Lockbox Payment Id
|
| 45 |
PP_METHOD |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment Predictor Method
|
| 46 |
ALGORITHM_GROUP |
Character(15) |
VARCHAR2(15) NOT NULL |
Algorithm Group for Payment Predictor
|
| 47 |
WS_REF_MATCH_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Worksheet Reference Match Type
E=Exact Match
L=Like Match
Default Value: E
|
| 48 |
ALGORITHM |
Character(7) |
VARCHAR2(7) NOT NULL |
Algorithm Identifier
|
| 49 |
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.
Prompt Table:
AR_PAY_CUR_VW
|
| 50 |
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.
Prompt Table:
PYMT_RT_TYPE_VW
|
| 51 |
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.
|
| 52 |
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
|
| 53 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 54 |
PP_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Payment Predictor Status
A=Applied
N=Not Processed
P=Processed
W=Worksheet Generated
Default Value: N
|
| 55 |
PP_RQ |
Number(7,0) |
INTEGER NOT NULL |
Reference Qualifier Count
|
| 56 |
PP_RQ_HIT |
Number(7,0) |
INTEGER NOT NULL |
Reference Qualifier Hits
|
| 57 |
APPLIED_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Applied Operator
|
| 58 |
MISC_PAYMENT |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Directly
Y/N Table Edit
Default Value: N
|
| 59 |
MISC_DST_BAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Non Customer Dist Balanced
C=Journal Complete
I=Balanced
N=No Distribution
O=Out of Balance
|
| 60 |
CREATE_PEND_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Pending Items
A=Do Not Post
L=Batch Standard
N=Batch Priority
Default Value: A
|
| 61 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 62 |
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.
Y/N Table Edit
Default Value: N
|
| 63 |
REF_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Reference Level of Detail
Default Value: S
|
| 64 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
|
| 65 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 66 |
RECONCILE_DT |
Date(10) |
DATE |
The transaction reconciliation date.
|
| 67 |
RECONCILE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The user ID that performed the reconciliation for a given transaction.
|
| 68 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
|
| 69 |
RECON_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
Reconciliation Status
ALG=Alignment Check
AMB=Ambiguous Match
AMT=Amounts Not Equal
CUR=Currency not Defined
DAT=Tran Date <> Value Date
DPI=Duplicate Input Transactions
DUP=Duplicate Transaction
MSC=Miscellaneous Transaction
NAM=Payee Names Not Equal
NTB=Not Found in Statement
NTF=Not Found In System
NTP=Not Found in POS Data
NUL=Null Transaction ID Ref
OVR=Overflow
PND=Pending Reconciliation
REC=Reconciled
RPR=Reprinted Check
RR=Requires Review - BSAC
STP=Stop Payment
TYP=Wrong Transaction Type
UNR=Unreconciled
VOI=Voided Check
Default Value: UNR
|
| 70 |
RECON_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Represents a series of options as to how a treasury wishes to perform reconciliation for a given bank
A=Automatically Reconciled
B=Balance System(s) to BankTran
F=Forced to Reconcile
M=Manually Reconciled
S=Semi Manual
U=Unreconciled
Default Value: U
|
| 71 |
STTLMNT_DT_ACTUAL |
Date(10) |
DATE |
Date in which a deal transaction is actually settled with a counterparty.
|
| 72 |
STTLMNT_DT_EST |
Date(10) |
DATE |
Date in which a deal transaction is estimated to be settled with a counterparty.
Default Value: PAYMENT.ACCOUNTING_DT
|
| 73 |
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.
|
| 74 |
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.
|
| 75 |
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.
|
| 76 |
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
|
| 77 |
CASH_CNTRL_DONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cash Control Complete
Y/N Table Edit
Default Value: N
|
| 78 |
DATA_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Data Source
820=820 ANSI-X12
APP=Accounts Payable Payment
BST=Bank Statement
CDR=Cash Drawer Receipts
CRX=EDIFACT CREEXT
LBX=Lockbox
ONL=Online
XEL=Excel Upload
Default Value: ONL
|
| 79 |
UNPOST_REASON |
Character(10) |
VARCHAR2(10) NOT NULL |
Reason code for Unposted groups. For informational purposes.
|
| 80 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 81 |
REMIT_FROM_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 82 |
REMIT_FROM_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Remit From Customer
|
| 83 |
EDI_TRACE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
EDI Trace Number
|
| 84 |
CC_AFFECTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicate whether commitment control (revenue estimate) is affected.
N=No
Y=Yes
Default Value: N
|
| 85 |
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
|
| 86 |
KK_AMOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
|
| 87 |
KK_TRAN_OVER_DTTM |
DateTime(26) |
TIMESTAMP |
Commitment Control source transaction override datetime
|
| 88 |
KK_TRAN_OVER_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No
Y=Yes
|
| 89 |
KK_TRAN_OVER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Commitment Control source transaction override operator
|
| 90 |
BANK_ACCT_RVL_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Field used to store the amount on a transaction revalued in the base currency of the transactions bank account.
|
| 91 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_AR_CODE2_VW
|
| 92 |
OPRID_APPROVED_BY |
Character(30) |
VARCHAR2(30) NOT NULL |
Approved By
|
| 93 |
RECON_RUN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Recon Run ID
|
| 94 |
BILL_TO_CUST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Customer
|
| 95 |
RECORD_SEQ_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
An internal work field utilized to enumerate database records in bank statement processing.
|
| 96 |
REQ_WO_COMMENTS |
Long Character |
CLOB |
Requestor Write-off Comments
|
| 97 |
ENTERED_DTTM |
DateTime(26) |
TIMESTAMP |
Entered Datetime
|
| 98 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 99 |
LAST_UPDATE_DTTM |
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.
|
| 100 |
OPRID_LAST_UPDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Last User to Update
|
| 101 |
AR_INBOUND_IPAC |
Character(1) |
VARCHAR2(1) NOT NULL |
AR Inbound IPAC flag, used to indicate that the item is waiting for an inbound IPAC record to be tied to it.
|