| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TEST_CASE |
Character(30) |
VARCHAR2(30) NOT NULL |
BTF Test Case
|
| 2 |
COMPARE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Compare report type
1=Delta (Results v.s Expected)
2=Expected data not in Results
3=Unexpected data in Results
|
| 3 |
COMPARE_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Compare data source (Actuals or Expected results).
A=Actuals
E=Expected
|
| 4 |
BNK_ID_NBR |
Character(20) |
VARCHAR2(20) NOT NULL |
A literal alphanumeric attribute that uniquely identifies a given bank or counterparty.
Prompt Table:
BANK_ID_VW
|
| 5 |
BANK_ACCOUNT_NUM |
Character(35) |
VARCHAR2(35) NOT NULL |
The literal unique identifier associated with a given bank/counterparty account.
Prompt Table:
BANK_ACCTNUM_VW
|
| 6 |
RECON_CYCLE_NBR |
Number(10,0) |
DECIMAL(10) NOT NULL |
The bank statement ID.
|
| 7 |
BNK_LOAD_DTTM |
DateTime(26) |
TIMESTAMP |
The time and date a bank statement is loaded into the system.
Default Value: %Datetime
|
| 8 |
CYCLE_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Cycle Status
C=Complete
E=Load Failed
F=Fatal Error
I=EDI Loaded
L=Loading
N=Ready
P=Selected
R=Ready
X=Reconciling
Default Value: R
|
| 9 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 10 |
ASOFDATE |
Date(10) |
DATE |
As of Date
Default Value: %date
|
| 11 |
ASOFTIME |
Time(15) |
TIMESTAMP |
As of Time
Default Value: %Time
|
| 12 |
RECEIVER |
Character(20) |
VARCHAR2(20) NOT NULL |
Receiver is used in bank reconciliation
|
| 13 |
SENDER |
Character(20) |
VARCHAR2(20) NOT NULL |
Sender will be used in bank statements
|
| 14 |
BTB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Book to Bank ready flag.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 15 |
BTB_RECON_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Book to bank Reconciliation Status
1=Confirmed
2=Awaiting Confirmation
3=Calculating
4=New
Default Value: 4
|
| 16 |
AR_LOADED_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Loaded to A/R
Y/N Table Edit
Default Value: N
|
| 17 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 18 |
BNK_STMT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Bank statement type
1=Current Day
2=Previous Day
3=Statement Analysis
|
| 19 |
EVENT_TRACKING_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
The event tracking ID is used in order to correlate objects with an event. Each object (i.e. Payment) will store the tracking ID with a given payment. That way the system can obtain all the events for a given payment via the tracking ID.
|
| 20 |
FILE_CREATE_DT |
Date(10) |
DATE |
File Creation Date
|