Accounting Extract has been modified to include additional fields
The Accounting Extract will include changes to pull the CFDA from both the PPC and FLINE, beginning Tuesday, July 5th, 2016. This will create an additional line in the Accounting Extract of “CFDA 2” and change the name of the original CFDA line to “CFDA 1”. See the below table for a revised view of the last 6 fields of the extract.
The revised/new field details are below:
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_PPC |
CFDA 1 | CFDA_NO | CFDA from PPC | Varchar | 20 | 2164 | 2183 | |
JRNL_ACTG JRNL_CA JRNL_BUD R_FLINE |
CFDA 2 | CFDA_NO | CFDA from FLINE | Varchar | 20 | 2184 | 2203 | |
JRNL_ACTG JRNL_CA JRNL_BUD R_PSCD |
Closing Classification | PSCD_CLOS_CL_CD | Closing Classification | Varchar | 2 | 2204 | 2205 | |
JRNL_ACTG JRNL_CA JRNL_BUD CR_DOC_HDR |
Bank Deposit Date | BANK_DPS_DT | Bank Deposit Date | Varchar | 23 | 2206 | 2228 | |
JRNL_ACTG JRNL_CA JRNL_BUD DOC_VEND |
Address Id | AD_ID | Address Id | Varchar | 20 | 2229 | 2248 |
Date