Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ADMINISTRATIVE_GROUP
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
AMOUNT
|
Total value of the encumbrance being recorded.
|
NUMBER
|
FGBENCH
|
FGBENCH_DOC_AMT
|
APPROVAL_IND
|
Indicates the document has met final approval.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_APPR_IND
|
CHANGE_DESC
|
Title or a brief description of any change made to an existing encumbrance.
|
VARCHAR2(255)
|
FGBENCH
|
FGBENCH_CHANGE_DESC
|
CHANGE_NUMBER
|
User-defined code identifies and provides an audit trail of any changes made to the original document. This code is actually used as the document code to post the encumbrance change to the ledgers.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_DOC_CHANGE_NUM
|
COMPLETE_IND
|
Indicates if the encumbrance document is complete.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(FGBENCH_STATUS)
|
DOCUMENT_REFERENCE_NUMBER
|
User-defined identification number further identifying this document and linking it to an external reference number.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_DOC_REF_NUM
|
ENCUMBRANCE_DESC
|
Encumbrance description or title.
|
VARCHAR2(255)
|
FGBENCH
|
FGBENCH_DESC
|
ENCUMBRANCE_NUMBER
|
Unique encumbrance code of a document.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_NUM
|
ENCUMBRANCE_SOURCE
|
Deciphers document type source for the encumbrance as requisition, purchase order, or neither.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(FGBENCH_SOURCE_IND)
|
ENCUMBRANCE_STATUS
|
Deciphers encumbrance document as open or closed.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(FGBENCH_STATUS_IND)
|
ENCUMBRANCE_TYPE
|
Indicates the type of encumbrance as either general encumbrance, labor, purchase order or requisition.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_TYPE
|
ESTABLISHED_DATE
|
Date the encumbrance was originally established.
|
DATE
|
FGBENCH
|
FGBENCH_ESTAB_DATE
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
TEXT_IND
|
Indicates if the document has associated text.
|
VARCHAR2(63)
|
FGBENCH
|
FGBENCH_TEXT_IND
|
TRANSACTION_DATE
|
Date used by the finance system to control posting to the ledgers.
|
DATE
|
FGBENCH
|
FGBENCH_TRANS_DATE
|
VENDOR_ID
|
User-defined or system generated one-up number of the vendor.
|
VARCHAR2(63)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
VENDOR_NAME
|
Vendor Name
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
VENDOR_UID
|
System generated unique internal identification number used to access the vendor.
|
NUMBER
|
FGBENCH
|
FGBENCH_VENDOR_PIDM
|