Alias: PBS#

(P2K_PR_BANK_STATEMENTS)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-PR80


Bank Statements

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
PBA_IDNumber(10)IDYlink to P2K_PR_PAYROLL_BANK_ACCOUNTS
FROM_DATE(Field)Date()DATEY
TO_DATE(Oracle_Function)Date()DATEY
TRANSACTION_STATUSVarchar2(2)X_TRANSACTION_STATUSY
OPENING_BALANCENumber(18)AMT12V6
CLOSING_BALANCENumber(18)AMT12V6
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y

Derived Fields#

Column Name
DRV_CREDIT
DRV_DEBIT
DRV_DIFFERENCE

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page