FAMIS Outbound from KFS

Owned by Kathleen Avery (Deactivated)
Oct 22, 2014

FAMIS Interfaces - Outbound from KFS

Chart of Accounts KFS ---> FAMIS 

View

Columns

Size

Comments

COA

ACCOUNT_NBR,

VARCHAR2(7 BYTE)

 
 

FUND_SID_CD,

VARCHAR2(7 BYTE)

 
 

ACCOUNT_NM,

VARCHAR2(40 BYTE)

 
 

ACCT_EXPIRATION_DT,

DATE(mmddyyyy)

 
 

ACCT_CLOSED_IND,

VARCHAR2(1 BYTE)

 
 

ACCT_CREATE_DT,

DATE(mmddyyyy)

 
 

ACCT_EFFECT_DT

DATE(mmddyyyy)

 
 

FRS_LEDGER

2 Chars

Crosswalk data

 

FRS_ACCOUNT

6 Chars

Crosswalk data

 

FRS_DESCRIPTION

40 Chars

Crosswalk data

 

FRS_LEDGER

2 Chars

Crosswalk data

 

FRS_SUBCODE

 4 Chars

Crosswalk data


Vendor Name & Address KFS ---> FAMIS  

View

Columns

Size

Comments

Vendor

VNDR_HDR_GNRTD_ID,

NUMBER(10,0)

 
 

VNDR_TYP_CD,

VARCHAR2(4 BYTE)

 
 

VNDR_DTL_ASND_ID,

NUMBER(10,0)

 
 

VNDR_NM,

VARCHAR2(45 BYTE)

 
 

VNDR_CUST_NBR,

VARCHAR2(30 BYTE)

 
 

VNDR_ADDR_GNRTD_ID,

NUMBER(10,0)

 
 

VNDR_LN1_ADDR,

VARCHAR2(45 BYTE)

 
 

VNDR_LN2_ADDR,

VARCHAR2(45 BYTE)

 
 

VNDR_CTY_NM,

VARCHAR2(45 BYTE)

 
 

VNDR_ST_CD,

VARCHAR2(2 BYTE)

 
 

VNDR_ZIP_CD,

VARCHAR2(20 BYTE)

 
 

VNDR_CNTRY_CD

VARCHAR2(2 BYTE)

 
 

VENDOR_CODE

NUMBER(10,0)

Crosswalk data

    

Requisition

REQS_ID,

NUMBER(8,0)

 
 

REQS_STAT_CD,

VARCHAR2(4 BYTE)

 
 

REQS_STAT_DESC,

VARCHAR2(45 BYTE)

 
 

PUR_COMM_CD,

VARCHAR2(40 BYTE)

 
 

ITM_DESC,

VARCHAR2(4000 BYTE)

 
 

ITM_LN_NBR,

NUMBER(3,0)

 
 

ITM_QTY,

NUMBER(11,2)

 
 

ITM_UOM_CD,

VARCHAR2(4 BYTE)

 
 

ITM_UNIT_PRC,

NUMBER(19,4)

 
 

VNDR_HDR_GNRTD_ID,

NUMBER(10,0)

 
 

VNDR_DTL_ASND_ID

NUMBER(10,0)

Â