DPT_CNTRL_TEO3(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for DEPOSIT_CONTROL |
| # | 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.
Default Value: NEXT Prompt Table: DEPOSIT_CONTROL |
| 4 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW |
| 5 | 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.
Default Value: DEPOSIT_CONTROL.OPRID Prompt Table: OPRID_VW |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: DEPOSIT_CONTROL.DEPOSIT_BU Prompt Table: SP_BUARED_NONVW |
| 7 | DEPOSIT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Deposit Type
A=Amount B=Balance of Net Pay P=Percent Prompt Table: DEPOST_TYPE_TBL |
| 8 | BANK_SETID | Character(5) | VARCHAR2(5) NOT NULL | The PeopleSoft tableset ID associated with a given bank/counterparty. |
| 9 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table: BANK_AR_BD_VW |
| 10 | BNK_ID_NBR | Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 11 | 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
Prompt Table: BANK_AR_D_VW |
| 12 | BANK_ACCOUNT_NUM | Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 13 | 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 Default Value: O |
| 14 | DEP_POST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Posting Status
A=All C=Complete N=Not Posted P=Partial Default Value: N |
| 15 | 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. |
| 16 | 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 |
| 17 | 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. |
| 18 | ENTERED_CNT | Number(6,0) | INTEGER NOT NULL | Represents the number of pending items actually entered in a group and is compared with the control total count. The Receivables Update program automatically calculates this total. |
| 19 | POSTED_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the total monetary amount of all pending items in a group that have been posted to customer accounts. The Receivables Update program automatically calculates this total. |
| 20 | POSTED_COUNT | Number(6,0) | INTEGER NOT NULL | Represents the total number of pending items in a group that have been posted to customer accounts. The Receivables Update program automatically calculates this total. |
| 21 | MISC_DST_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Journalled Dist Total |
| 22 | MISC_DST_COUNT | Number(5,0) | INTEGER NOT NULL | Miscellaneous Dist Count |
| 23 | GROUP_SEQ_NUM | Number(6,0) | INTEGER NOT NULL | Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated. |
| 24 | RECEIVED_DT | Date(10) | DATE NOT NULL |
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).
Default Value: %date |
| 25 | 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 |
| 26 | POST_DT | Date(10) | DATE | The Date a transaction was Posted. |
| 27 | ACCOUNTING_DT | Date(10) | DATE NOT NULL |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
Default Value: %date |
| 28 | 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 |
| 29 | DEPOSIT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Deposit Status
A=Fully Applied C=Complete N=None Applied P=Partially Applied Default Value: N |
| 30 | LB_FORMAT_ERROR | Character(1) | VARCHAR2(1) NOT NULL |
Lockbox Format Error
D=Duplicate Deposit N=No Errors O=Out of Balance Y=Error - Blank Payment ID Default Value: N |
| 31 | LOCKBOX_BATCH_ID | Character(5) | VARCHAR2(5) NOT NULL | Lockbox Batch Id |
| 32 | LOCKBOX_RUN_ID | Number(10,0) | DECIMAL(10) NOT NULL | Lockbox Run Id |
| 33 | 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.
Prompt Table: AR_CNTL_CUR_VW |
| 34 | 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.
Default Value: OPR_DEF_TBL_AR.FORMAT_CURRENCY Prompt Table: AR_CNTL_CUR_VW |
| 35 | 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. |
| 36 | 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. |
| 37 | 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 |
| 38 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 39 | 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 |
| 40 | RECONCILE_DT | Date(10) | DATE | The transaction reconciliation date. |
| 41 | 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 |
| 42 | RECON_CYCLE_NBR | Number(10,0) | DECIMAL(10) NOT NULL | The bank statement ID. |
| 43 | RECONCILE_OPRID | Character(30) | VARCHAR2(30) NOT NULL | The user ID that performed the reconciliation for a given transaction. |
| 44 | STTLMNT_DT_ACTUAL | Date(10) | DATE | Date in which a deal transaction is actually settled with a counterparty. |
| 45 | CASH_CNTRL | Character(1) | VARCHAR2(1) NOT NULL |
Cash Control
Y/N Table Edit Default Value: N Prompt Table: PSXLATITEM |
| 46 | 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. |
| 47 | ITEM_IN_EXCLUSION | Character(1) | VARCHAR2(1) NOT NULL |
Include Exclude Items
A=All Items D=Deduction Items Only I=Items in Dispute Only |
| 48 | EXCLUDE_COLLECTION | Character(1) | VARCHAR2(1) NOT NULL | Exclude Collection Items |
| 49 | EXCLUDE_DEDUCTIONS | Character(1) | VARCHAR2(1) NOT NULL | Exclude Deduction Items |
| 50 | EXCLUDE_DISPUTES | Character(1) | VARCHAR2(1) NOT NULL | Exclude Dispute Items |
| 51 | RECON_RUN_ID | Character(15) | VARCHAR2(15) NOT NULL | Recon Run ID |
| 52 | PAY_WS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Payment Worksheet Type
C=Credit Card Worksheet E=ePayment Worksheet P=Payment Worksheet Default Value: P |
| 53 | RECORD_SEQ_NUMBER | Number(10,0) | DECIMAL(10) NOT NULL | An internal work field utilized to enumerate database records in bank statement processing. |
| 54 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |