DEP_CNTL_ARCH

(SQL Table)
Index Back

Group Control Archive Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
2 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.
3 ARCHIVE_ID Character(8) VARCHAR2(8) NOT NULL Archive ID
4 ARCHIVE_DT Date(10) DATE Archive Date
5 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
6 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
7 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID