QUICK_SPLITCHRG

(SQL Table)
Index Back

Quick Post Charges to Pay

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 GRP_TIMESTAMP DateTime(26) TIMESTAMP Group Line Time Stamp
4 LINE_SEQ_NBR Number(3,0) SMALLINT NOT NULL Line Sequence Nbr
5 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 ITEM_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Amount
8 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type
9 ITEM_TERM Character(4) VARCHAR2(4) NOT NULL Item Term
10 ACCOUNT_NBR Character(10) VARCHAR2(10) NOT NULL Account Nbr
11 ACCOUNT_TERM Character(4) VARCHAR2(4) NOT NULL Account Term
12 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
13 REFUND_NBR Number(12,0) DECIMAL(12) NOT NULL Refund Nbr
14 ITEM_BALANCE Signed Number(18,2) DECIMAL(16,2) NOT NULL Item Balance
15 APPLIED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Applied Amount
16 PAYOUT_AMT Number(17,2) DECIMAL(16,2) NOT NULL Pay Out Amt
17 ACCOUNT_TYPE_SF Character(3) VARCHAR2(3) NOT NULL Account Type
18 REF1_DESCR Character(30) VARCHAR2(30) NOT NULL Reference Nbr
19 ROWS_INSERT Character(1) VARCHAR2(1) NOT NULL Rows Already Inserted

Y/N Table Edit

Default Value: N

20 CHRG_ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Charge Item Type