FAMIS Outbound from KFS
- Kathleen Avery (Deactivated)
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) |