Accounting Extract has been modified to include additional fields
The Accounting Extract will include 5 additional fields, added to the end of the previous file layout. The new field details are below:
| Advantage ERP/Other Systems | |||||||||
| Source Table |
UI Caption |
Attribute | Description | Data Type | Length | Start | End | Data Classification |
Comments |
| JRNL_ACTG JRNL_CA JRNL_BUD R_OBJ |
1099 Income Code | INC_TYP_ID | 1099 Income Code | Big Int | 16 | 2148 | 2163 | ||
| JRNL_ACTG JRNL_CA JRNL_BUD R_FLINE R_PPC |
CFDA | CFDA_NO | CFDA Number | Varchar | 20 | 2164 | 2183 | This is a composite element obtained by concatenating the fields FED_CTLG_NO_PFX (prefix) and FED_CTLG_NO_SFX (suffix) with a period in between : FED_CTLG_NO_PFX + '.' + FED_CTLG_NO_SFX . The fields are obtained from R_PPC and F_FLINE (funding line) tables. | |
| JRNL_ACTG JRNL_CA JRNL_BUD R_PSCD |
Closing Classification | PSCD_CLOS_CL_CD | Closing Classification | Varchar | 2 | 2184 | 2185 | ||
| JRNL_ACTG JRNL_CA JRNL_BUD CR_DOC_HDR |
Bank Deposit Date | BANK_DPS_DT | Bank Deposit Date | Varchar | 23 | 2186 | 2208 | ||
| DOC_VEND JRNL_ACTG JRNL_CA |
Address Id | AD_ID | Address Id | varchar | 20 | 2209 | 2228 | ||
The additional fields will be reflected in the Accouningt Extract files beginning, Tuesday, April 19, 2016.
Date