| # |
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 |
DD_BU |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the business unit to which a direct debit is posted. This field is maintained by the Direct debit generation process.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table:
SP_BUARDS_NONVW
|
| 4 |
DD_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Specifies a sequence number assigned to a Direct Debit by the Direct Debit generation process.
Prompt Table:
DD_CONTROL
|
| 5 |
DD_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates the stage of processing of a direct debit payment in receivables. This field is maintained by the Direct Debit generation process.
A=Accepted
C=Complete
E=Rejected
N=No Action
P=Pending
R=Remitted
Z=All
|
| 6 |
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.
|
| 7 |
DD_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a direct debit in its entry currency (DD_CURRENCY). This field is maintained by the Direct debit generation process.
|
| 8 |
DD_CNT |
Number(5,0) |
INTEGER NOT NULL |
Total Number of Direct Debits
|
| 9 |
DD_DUE_DT |
Date(10) |
DATE |
Direct Debit Due Date
|
| 10 |
CREATE_DATE |
Date(10) |
DATE |
Creation Date
|
| 11 |
DD_AS_OF_DT |
Date(10) |
DATE |
Pending Item As of Date
|
| 12 |
DD_REMIT_POST_DT |
Date(10) |
DATE |
Remittance Post Date
|
| 13 |
DD_REMIT_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Remittance Group Id
|
| 14 |
TRANSIT_POST_DT |
Date(10) |
DATE |
Cash-in-Transit Post Date
|
| 15 |
TRANSIT_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Cash-in-Transit Group ID
|
| 16 |
CASH_POST_DT |
Date(10) |
DATE |
Cash Posted Date
|
| 17 |
CASH_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Cash Group ID
|
| 18 |
DD_CANCEL_POST_DT |
Date(10) |
DATE |
Cancellation Post Date
|
| 19 |
DD_CANCEL_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Cancellation Group Id
|
| 20 |
VAT_POST_DT |
Date(10) |
DATE |
VAT Post Date
|
| 21 |
VAT_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
VAT Group ID
|
| 22 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 23 |
DD_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Specifies the currency in which a direct debit is created. This field is maintained by the Direct Debit generation process.
|
| 24 |
ENTRY_USE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the System Function or type of processing associated with an entry type.
|
| 25 |
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.
|
| 26 |
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""."
|
| 27 |
ENTRY_EVENT |
Character(10) |
VARCHAR2(10) NOT NULL |
Entry Event
Prompt Table:
EE_AR_CODE1_VW
|
| 28 |
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
B=Balance Only Now
D=Delete This Group Now
E=Delete ALL Accounting Entries
G=Generate GL Distribution
I=Balance and Post Later
L=Batch Standard
N=Batch Priority
V=View
|
| 29 |
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.
|
| 30 |
ITM_MULTIPLIER |
Signed Number(2,0) |
DECIMAL(1) NOT NULL |
Posting Item Multiplier
|
| 31 |
CREATE_PEND_ITEMS |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Pending Items
A=Do Not Post
L=Batch Standard
N=Batch Priority
|
| 32 |
HOLD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Hold Switch
N=No Hold
Y=On Hold
|
| 33 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 34 |
DD_AMT_BASE |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the amount of a direct debit in the base currency of the business unit to which it is posted. This field is maintained by the Direct debit generation process.
|
| 35 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 36 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 37 |
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
|
| 38 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
|
| 39 |
DEPOSIT_ACCT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
Deposit Bank Account #
|
| 40 |
DEPOSIT_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Deposit Currency
|
| 41 |
DD_NOTICE_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Direct Debit Notice Period
|
| 42 |
DD_CLEARING_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Clearing Method
B=Bank Recon
D=Due Date
N=None
|
| 43 |
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
|
| 44 |
RECONCILE_DT |
Date(10) |
DATE |
The transaction reconciliation date.
|
| 45 |
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
|
| 46 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
|
| 47 |
RECONCILE_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
The user ID that performed the reconciliation for a given transaction.
|
| 48 |
STTLMNT_DT_EST |
Date(10) |
DATE |
Date in which a deal transaction is estimated to be settled with a counterparty.
|
| 49 |
STTLMNT_DT_ACTUAL |
Date(10) |
DATE |
Date in which a deal transaction is actually settled with a counterparty.
|
| 50 |
DISCOUNT_PROCESSED |
Character(1) |
VARCHAR2(1) NOT NULL |
Discount Processed Switch
Y/N Table Edit
|
| 51 |
MICR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
MICR ID
Prompt Table:
REMIT_MICR_VW_C
Set Control Field: CUST_ID
|
| 52 |
DD_WORKSHEET_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
DD Worksheet Id
|
| 53 |
DD_RQST_SEQUENCE |
Number(5,0) |
INTEGER NOT NULL |
Request Sequence Number
|
| 54 |
DD_APPROVAL_CR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Credit Approval Limit
|
| 55 |
DD_APPROVAL_DR_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Debit Approval Limit
|
| 56 |
DD_APPROV_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Approval Currency
|
| 57 |
DD_CUR_RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Exchange Rate Type
|
| 58 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 59 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 60 |
LAST_RUN_DTM |
DateTime(26) |
TIMESTAMP |
Last Run On
|
| 61 |
DD_CANCEL_REASON |
Character(60) |
VARCHAR2(60) NOT NULL |
Cancel Reason
|
| 62 |
DD_PROFILE_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Profile ID for a Direct Debit
|
| 63 |
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.
|
| 64 |
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.
|
| 65 |
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.
|
| 66 |
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
|
| 67 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date
|
| 68 |
BUSINESS_UNIT_GL |
Character(5) |
VARCHAR2(5) NOT NULL |
GL Business Unit
|
| 69 |
EFT_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
EFT Process Instance
|
| 70 |
DD_EXCP_C_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Exceeds Credit Approval Limit
Y/N Table Edit
Default Value: N
|
| 71 |
DD_EXCP_D_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Exceeds Debit Approval Limit
Y/N Table Edit
Default Value: N
|
| 72 |
DD_EXCP_F_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Foreign Currency
Y/N Table Edit
Default Value: N
|
| 73 |
DD_EXCP_N_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Due Date within Notice Period
Y/N Table Edit
Default Value: N
|
| 74 |
DD_EXCP_P_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Missing Customer Bank Details
Y/N Table Edit
Default Value: N
|
| 75 |
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.
|
| 76 |
MAX_RESUBMIT_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Number of Resubmissions
|
| 77 |
RECON_RUN_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Recon Run ID
|
| 78 |
EFT_LAYOUT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
EFT Layout Code
|
| 79 |
STL_THROUGH |
Character(2) |
VARCHAR2(2) NOT NULL |
Settle through
01=Financial Gateway
02=Pay Cycle
|
| 80 |
PMT_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Payment status
C=Canceled
CM=Cancelled with Message
E=Error
H=Flagged for Hold
L=Awaiting Dispatch
N=Not Processed
P=Paid
PC=Pending Cancellation
PR=Pending Reversal
R=Received by Bank
RM=Reversed with Message
S=Dispatched to Bank
SC=In Process
|
| 81 |
PMT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Payment id
|
| 82 |
RECORD_SEQ_NUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
An internal work field utilized to enumerate database records in bank statement processing.
|
| 83 |
PRENOTE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Prenotification Flag
|
| 84 |
ORG_PMT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Original Transaction / Payment ID - used for reversal process.
Prompt Table:
AR_DD_ORGPMT_VW
|
| 85 |
RVL_REASON |
Character(34) |
VARCHAR2(34) NOT NULL |
Reversal Reason - used when payments are reversed. Will store Reversal Reason Code.
Reason Codes:
AC04 - ClosedAccountNumber
AG02 - InvalidBankOperationCode
AM05 - Duplication
MD01 - NoMandate
MD05 - CollectionNotDue
Prompt Table:
AR_TR_REASON_VW
|