| |
ACAD_CAREER - Academic Career |
Char4 |
N |
Career |
| |
ACCOUNT_NBR - Account Nbr |
Char10 |
|
Acct Nbr |
| |
ACCOUNT_TERM - Account Term |
Char4 |
|
Acct Term |
| |
ACTUAL_BILLING_DT - Actual Billing Date |
Date |
|
Billing Date |
| |
AGING2_FLAG - Aging Flag |
Char1 |
|
Aging |
| |
AGING_DT - Aging Date |
Date |
|
Aging Dt |
| |
AGING_FLG - Aging Flag |
Char1 |
|
Aging |
| |
AGING_LATE_FEES_DT - Late Fees Last Aging Aging Dt |
Date |
|
Last Aging Dt |
| |
BILLING_DT - Billing Date |
Date |
|
Billing Date |
| |
BILLING_FLAG - Billing Flag |
Char1 |
|
Billing |
| Key |
BUSINESS_UNIT - Business Unit |
Char5 |
|
Unit |
| |
CLASS_NBR - Class Nbr |
Num5.0 |
|
Class Nbr |
| |
CLASS_PRICE_DTTM - Class Price Date Time |
DateTm |
|
Date Time |
| |
COLLECTION_ID - Collection ID |
Num12.0 |
|
Collection |
| Key |
COMMON_ID - ID |
Char11 |
|
ID |
| |
COMPANY - Company |
Char3 |
|
Co |
| |
CONTRACT_NUM - Contract Number |
Char25 |
|
Contract # |
| |
DEPOSIT_NBR - Deposit Nbr |
Num12.0 |
|
Depos Nbr |
| |
DESCR - Description |
Char30 |
|
Descr |
| |
DISPUTE_AMT - Dispute Amount |
SNm16.2 |
|
Dispute |
| |
DISPUTE_DT - Dispute Date |
Date |
|
Dispute Dt |
| |
DUE_AMT - Due Amount |
SNm16.2 |
|
Due Amt |
| |
DUE_DATE_BY - Due Date Enter By |
Char3 |
N |
Enter By |
| |
DUE_DT - Due Date |
Date |
|
Due Date |
| |
EMPLID - Empl ID |
Char11 |
|
ID |
| |
ENCUMBERED_AMT - Amount Encumbered |
SNm16.2 |
|
Encumbered |
| |
ENCUMBRANCE_DT - Encumbrance Date |
Date |
|
Encum Dt |
| |
EXT_ORG_ID - External Org ID |
Char11 |
|
Org ID |
| |
FEE_CD - Fee Code |
Char6 |
|
Fee Code |
| |
FINANCE_CHARGE - Finance Charge |
Char8 |
|
Fin Chrge |
| |
GL_POSTING_DTTM - GL Posting Date Time |
DateTm |
|
GL Post DTTM |
| |
GRP_TIMESTAMP - Group Line Time Stamp |
DateTm |
|
Group Line |
| |
ITEM_EFFECTIVE_DT - Item Effective Date |
Date |
|
Itm Eff Dt |
| Key |
ITEM_NBR - Item Nbr |
Char15 |
|
Item Nbr |
| |
ITEM_TERM - Item Term |
Char4 |
|
Item Term |
| |
ITEM_TYPE_CD - Item Type Code |
Char1 |
N |
Item Code |
| |
LINE_ACTION - Line Action |
Char3 |
|
Action |
| |
LINE_AMT - Line Amount |
SNm16.2 |
|
Line Amt |
| |
LINE_NUM - Line # |
Num2.0 |
|
Line # |
| |
LINE_REASON_CD - Line Reason Code |
Char4 |
|
Reason |
| |
LINE_REVERSAL_IND - Line Reversal Indicator |
Char1 |
|
Reversal Ind. |
| Key |
LINE_SEQ_NBR - Line Sequence Nbr |
Num3.0 |
|
Ln Seq Nbr |
| |
LINE_STATUS - Line Status |
Char1 |
|
Status |
| |
OFF_CYCLE - Off Cycle ? |
Char1 |
|
Off Cycle |
| |
OPRID - User ID |
Char30 |
|
User |
| |
ORG_GROUP_ID_SF - Original Group ID |
Char15 |
|
Grp ID |
| |
ORG_GROUP_LINE_NBR - Original Group Line Nbr |
Num6.0 |
|
Line Nbr |
| |
ORIGINAL_ACCT_TERM - Original Account Term |
Char4 |
|
Term |
| |
ORIG_DUE_DATE - Original Due Date |
Date |
|
Orig Due DT |
| |
PAGE_NUM - Page # |
Num4.0 |
|
Page |
| |
PAYCHECK_NBR - Paycheck Number |
Num15.0 |
|
Check # |
| |
PAYGROUP - Pay Group |
Char3 |
|
Group |
| |
PAYMENT_ID_NBR - Payment ID Nbr |
Num12.0 |
|
Payment ID |
| |
PAY_END_DT - Pay Period End Date |
Date |
|
Pay Period End |
| |
POSTED_DATE - Date Posted |
Date |
|
Posted |
| |
POSTED_DATETIME - Posted Date & Time |
DateTm |
|
Postd DtTm |
| |
REF1_DESCR - Reference Nbr |
Char30 |
|
Ref Nbr |
| |
REFUND_EMPLID - Refund ID |
Char11 |
|
ID |
| |
REFUND_NBR - Refund Nbr |
Num12.0 |
|
Nbr |
| Key |
SA_ID_TYPE - ID Type |
Char1 |
N |
ID Type |
| |
SCC_ROW_ADD_DTTM - Created |
DateTm |
|
Created |
| |
SCC_ROW_ADD_OPRID - Created By |
Char30 |
|
Created By |
| |
SCC_ROW_UPD_DTTM - Last Update Date/Time |
DateTm |
|
Updated |
| |
SCC_ROW_UPD_OPRID - Updated By |
Char30 |
|
By |
| |
SEL_GROUP - Tuition Group |
Char10 |
|
Group |
| |
SENT_HRNRA_FLAG - Sent/Calculated fro HR NRA |
Char1 |
|
Sent HR-NRA |
| |
SESSION_CODE - Session |
Char3 |
N |
Session |
| |
SSF_ITEM_NBR_STCHG - Contract Emplid Charge |
Char15 |
|
Student Charge |
| |
STDNT_CAR_NBR - Student Career Nbr |
Num3.0 |
|
Career Nbr |
| |
T4_SENT_FLG - T4 Sent Flag |
Char1 |
|
T4 Sent Flg |
| |
TRACER_NBR - Bank Tracer Nbr |
Char30 |
|
Tracer |