Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 

Field Name

 

Format

 

Len

Beg Col

End Col

 

Comments/Values

 PAYEE_ID

AlphaNumeric

25

1

25

Student ID #, Employee ID, or Vendor ID

SOURCE_DOCUMENT_NO

(Customer Payment Document Number in KFS)

AlphaNumeric

14

26

39

Unique identifier sent to KFS via Source Document Number

 REQ_NO

(Requisition Number in KFS)

AlphaNumeric

8

40

47

Requisition number, optional for students.

 TRANS_AMOUNT

(Net Payment Amount in KFS)

 

Numeric

9(12).99

15

48

62

Check Amount

 CHECK_NUMBER

(Disbursement Number in KFS)

AlphaNumeric

8

63

70

KFS Check Number

 CHECK_DATE

(Disbursement Timestamp in KFS)

AlphaNumeric

8

71

78

YYYYMMDD

Depending on the TRANSACTION_TYPE this date may have different meanings:

Check Creation Date (For ACH, this is also the cleared date)

Check Cleared Date (For Checks, ACH gets cleared when created)

Check Canceled Date

Check Stale Date

Stop Pay Date

Check Voided Date

 

 EFFECTIVE_DATE

(Posting Date on the GL side)

AlphaNumeric

8

79

86

YYYYMMDD

TRANSACTION_TYPE

(Payment Status Code in KFS)

 

 

 

 

 

AlphaNumeric

    4

87

90

EXTR – Check Created

CLRD – Check Cleared

CDIS – Cancel Disbursement

STAL – Check Stale

STOP – Check Stop

VOID – Check Voided

 PAYMENT_TYPE

(Disbursement Type Code in KFS)

 

AlphaNumeric

    4

91

94

  CHCK -  Check

  ACH – EFT/ACH

 DISTRIBUTION_TYPE

(Payment Special Handling Indicator in KFS)

AlphaNumeric

1

95

95

Y – Pick up check

PAYMENT_CHG_CD

(Payment Change Code in KFS)

AlphaNumeric

4

96

99

Payment Change Code:

CRD – Stop with Reissue

Ignore all other values

PREV_CHECK_NUMBER

(Original Check Number in KFS)

AlphaNumeric

8

100

107

Previous Check Number for Reissued checks.

ORG_DOC_NUMBERAlphaNumeric10108117

Identifier sent to KFS via Org Document Number in the Payment file.  This was requested by the Medical Center.

All other Departments receiving a file do not need to use it.

...