Is Collector File a Duplicate?

Owned by Kathleen Avery (Deactivated)
Last updated: Aug 17, 2021
1 min read

To determine when a collector file is a duplicate (already been processed), several fields are compared to related fields in the FS_CLCTR_HDR_T.


Header RecordTrailer RecordRecord Type (position 26-27)Field positionFS_CLCTR_HDR_T
ChartOfAccountsCode
HD5-6FIN_COA_CD
OrganizationCode
HD7-10ORG_CD
TransmissionDate
HD16-25PROC_TRNS_DT
BatchSequenceNumber
HD28PROC_BATCH_SEQ_NBR

TotalRecordCountTL47-51PROC_TOT_REC_CNT

TotalAmountTL93-112PROC_TOT_AMT