ARXPYMT_TAO(SQL Table) |
Index Back |
|---|---|
Payments |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | 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.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDS_NONVW |
| 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_ID | Character(15) | VARCHAR2(15) NOT NULL | Identifies a customer payment. This is usually a check number but may be some other identifying number. |
| 6 | PAYMENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount of a customer payment. |
| 7 | 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 |
| 8 | 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 Default Value: CHK |
| 9 | 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).
Default Value: %date |
| 10 | 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 |
| 11 | POST_DT | Date(10) | DATE | The Date a transaction was Posted. |
| 12 | SEL_CUST_ID | Character(1) | VARCHAR2(1) NOT NULL |
Select items via Customer ID
Y/N Table Edit Default Value: N |
| 13 | SEL_PO | Character(1) | VARCHAR2(1) NOT NULL |
Select items via Postal
Y/N Table Edit Default Value: N |
| 14 | SEL_REMIT | Character(1) | VARCHAR2(1) NOT NULL |
Select items via REMIT TO
Y/N Table Edit Default Value: N |
| 15 | SEL_CORP_ACCT | Character(1) | VARCHAR2(1) NOT NULL |
Select items via CORP ACCT
Y/N Table Edit Default Value: N |
| 16 | SEL_MICR | Character(1) | VARCHAR2(1) NOT NULL |
Select items via MICR ID
Y/N Table Edit Default Value: N |
| 17 | SEL_OPEN_ITEM | Character(1) | VARCHAR2(1) NOT NULL |
Select items via OPEN ITEM
Y/N Table Edit Default Value: N |
| 18 | SEL_DOCUMENT | Character(1) | VARCHAR2(1) NOT NULL |
Select items via DOCUMENT
Y/N Table Edit Default Value: N |
| 19 | SEL_REF_RANGE | Character(1) | VARCHAR2(1) NOT NULL |
Range of References
Y/N Table Edit Default Value: N |
| 20 | ID_SEQ_CUST | Number(3,0) | SMALLINT NOT NULL | Sequence control for CUST ID |
| 21 | ID_SEQ_ITEM | Number(5,0) | INTEGER NOT NULL | Sequence control for ITEM |
| 22 | AMT_SEL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount selected |
| 23 | AMT_ADJ | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Adjusted |
| 24 | AMT_REM | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount Remaining |
| 25 | DISC_TAKEN | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Taken |
| 26 | DISC_EARNED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discounts Earned |
| 27 | DISC_UNEARNED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Unearned Discounts |
| 28 | WS_COUNT | Number(5,0) | INTEGER NOT NULL | Worksheet Items |
| 29 | WS_DTTM | DateTime(26) | TIMESTAMP | Worksheet Created Date/Time |
| 30 | WS_SEQ_ITEM | Number(5,0) | INTEGER NOT NULL | Worksheet item sequence number |
| 31 | 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 |
| 32 | DST_DT | Date(10) | DATE | Distribution Date |
| 33 | 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. |
| 34 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
| 35 | 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. |
| 36 | PP_SW | Character(1) | VARCHAR2(1) NOT NULL |
Payment Predictor
Y/N Table Edit Default Value: N |
| 37 | DISC_USED_SW | Character(1) | VARCHAR2(1) NOT NULL |
Discount used switch
Y/N Table Edit Default Value: N |
| 38 | WO_USED_SW | Character(1) | VARCHAR2(1) NOT NULL |
Write Off's Used
Y/N Table Edit Default Value: N |
| 39 | WO_ITEM_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Write Off Item |
| 40 | WO_ADJ_USED_SW | Character(1) | VARCHAR2(1) NOT NULL |
Write Off Adjustmet from WS
Y/N Table Edit Default Value: N |
| 41 | WS_UPDATED_SW | Character(1) | VARCHAR2(1) NOT NULL |
Worksheet updated switch
Default Value: N |
| 42 | LOCKBOX_PYMNT_ID | Character(15) | VARCHAR2(15) NOT NULL | Lockbox Payment Id |
| 43 | PP_METHOD | Character(15) | VARCHAR2(15) NOT NULL | Payment Predictor Method |
| 44 | ALGORITHM_GROUP | Character(15) | VARCHAR2(15) NOT NULL | Algorithm Group for Payment Predictor |
| 45 | WS_REF_MATCH_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Worksheet Reference Match Type
E=Exact Match L=Like Match Default Value: E |
| 46 | ALGORITHM | Character(7) | VARCHAR2(7) NOT NULL | Algorithm Identifier |
| 47 | 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 |
| 48 | 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 |
| 49 | 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. |
| 50 | 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 |
| 51 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 52 | PP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payment Predictor Status
A=Applied N=Not Processed P=Processed W=Worksheet Generated Default Value: N |
| 53 | PP_RQ | Number(7,0) | INTEGER NOT NULL | Reference Qualifier Count |
| 54 | PP_RQ_HIT | Number(7,0) | INTEGER NOT NULL | Reference Qualifier Hits |
| 55 | APPLIED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Applied Operator |
| 56 | MISC_PAYMENT | Character(1) | VARCHAR2(1) NOT NULL |
Journal Directly
Y/N Table Edit Default Value: N |
| 57 | 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 |
| 58 | 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 |
| 59 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 60 | 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 |
| 61 | REF_LEVEL | Character(1) | VARCHAR2(1) NOT NULL | Reference Level of Detail |
| 62 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 63 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 64 | RECONCILE_DT | Date(10) | DATE | The transaction reconciliation date. |
| 65 | RECONCILE_OPRID | Character(30) | VARCHAR2(30) NOT NULL | The user ID that performed the reconciliation for a given transaction. |
| 66 | RECON_CYCLE_NBR | Number(10,0) | DECIMAL(10) NOT NULL | The bank statement ID. |
| 67 | 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 |
| 68 | 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 |
| 69 | STTLMNT_DT_ACTUAL | Date(10) | DATE | Date in which a deal transaction is actually settled with a counterparty. |
| 70 | 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 |
| 71 | 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. |
| 72 | 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. |
| 73 | 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. |
| 74 | 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 |
| 75 | CASH_CNTRL_DONE | Character(1) | VARCHAR2(1) NOT NULL |
Cash Control Complete
Y/N Table Edit Default Value: N |
| 76 | 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 |
| 77 | UNPOST_REASON | Character(10) | VARCHAR2(10) NOT NULL | Reason code for Unposted groups. For informational purposes. |
| 78 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 79 | REMIT_FROM_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 80 | REMIT_FROM_CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Remit From Customer |
| 81 | EDI_TRACE_NBR | Number(10,0) | DECIMAL(10) NOT NULL | EDI Trace Number |
| 82 | CC_AFFECTED | Character(1) | VARCHAR2(1) NOT NULL |
Indicate whether commitment control (revenue estimate) is affected.
N=No Y=Yes Default Value: N |
| 83 | 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 |
| 84 | 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 |
| 85 | KK_TRAN_OVER_DTTM | DateTime(26) | TIMESTAMP | Commitment Control source transaction override datetime |
| 86 | KK_TRAN_OVER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No Y=Yes |
| 87 | KK_TRAN_OVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Commitment Control source transaction override operator |
| 88 | 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. |
| 89 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | Entry Event |
| 90 | OPRID_APPROVED_BY | Character(30) | VARCHAR2(30) NOT NULL | Approved By |
| 91 | RECON_RUN_ID | Character(15) | VARCHAR2(15) NOT NULL | Recon Run ID |
| 92 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |