PSARCH_IDPSARCH_BATCHNUMBNK_ID_NBRBANK_ACCOUNT_NUMPYMNT_IDCREATE_DTTMPYMNT_ID_REFA=Automatically Reconciled
B=Balance System(s) to BankTran
F=Forced to Reconcile
M=Manually Reconciled
S=Semi Manual
U=Unreconciled
AP_ARC_PYM_RC_H(SQL Table) |
Index Back |
|---|---|
Payment Recon Statistics |
| # | 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 | BNK_ID_NBR |
Character(20) | VARCHAR2(20) NOT NULL | A literal alphanumeric attribute that uniquely identifies a given bank or counterparty. |
| 4 | BANK_ACCOUNT_NUM |
Character(35) | VARCHAR2(35) NOT NULL | The literal unique identifier associated with a given bank/counterparty account. |
| 5 | PYMNT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Payment Number |
| 6 | CREATE_DTTM |
DateTime(26) | TIMESTAMP | Creation Datetime |
| 7 | PYMNT_ID_REF |
Character(20) | VARCHAR2(20) NOT NULL | Payment Reference |
| 8 | PYMNT_CLEAR_DT | Date(10) | DATE | Payment Clear Date |
| 9 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
| 10 | RECON_DIFF_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Recon Difference Amount |
| 11 | RECON_PAYEE_ID | Character(40) | VARCHAR2(40) NOT NULL | The payee ID on the inbound bank statement. |
| 12 | 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 |
| 13 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 14 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 15 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |