File Field Analysis

File Index Menu Scheduled Jobs Top level Programs
File: IS926P1
Library: FASTBREED
Description: Expense Code Master File
Format: R926P1
Fields: 14
Created:
Retrieved:

Fields

Field Long Name Description Type Len,Dec Column Headings Ref File
CMPUNQ CMPUNQ Company Unique Number Zoned Decimal 5,0 CMPUNQ// /
EXPUNQ EXPUNQ Expense Unique Number Zoned Decimal 5,0 EXPUNQ// /
EXPCDE EXPCDE Expense Code Zoned Decimal 3,0 EXPCDE// /
EXPTYP EXPTYP Expense Short Description Alpha 20 EXPTYP// /
EXPMLT EXPMLT Expense Multiplier Zoned Decimal 4,2 EXPMLT// /
EXPLIN EXPLIN Expense Extended To Code Zoned Decimal 3,0 EXPLIN// /
EXPSUB EXPSUB Expense Subtotal Code Zoned Decimal 3,0 EXPSUB// /
EXPDES EXPDES Expense Long Description Alpha 40 EXPDES// /
EXPCAT EXPCAT Expense G/L Ref# Alpha 20 EXPCAT// /
EXPDET EXPDET Expense Details Required Alpha 1 EXPDET// /
EXPDEM EXPDEM Expense Type Per Diem Zoned Decimal 8,2 EXPDEM// /
EXPFRM EXPFRM Expense Per Diem Firm Flag Alpha 1 EXPFRM// /
EXPADV EXPADV Expense Cash Advance Flag Alpha 1 EXPADV// /
EXPDSP EXPDSP Expense Dsp Flag Alpha 1 EXPDSP// /

Logical Files using IS926P1

Logical File Description Library Member Access Path Keys
IS926L1 Expense Code by Unique Number FASTBREED
CMPUNQ - Company Unique Number Zoned Decimal 5,0 ASC

EXPUNQ - Expense Unique Number Zoned Decimal 5,0 ASC