Is Collector File a Duplicate?
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 Record | Trailer Record | Record Type (position 26-27) | Field position | FS_CLCTR_HDR_T |
---|---|---|---|---|
ChartOfAccountsCode | HD | 5-6 | FIN_COA_CD | |
OrganizationCode | HD | 7-10 | ORG_CD | |
TransmissionDate | HD | 16-25 | PROC_TRNS_DT | |
BatchSequenceNumber | HD | 28 | PROC_BATCH_SEQ_NBR | |
TotalRecordCount | TL | 47-51 | PROC_TOT_REC_CNT | |
TotalAmount | TL | 93-112 | PROC_TOT_AMT |
, multiple selections available,
Related content
Collector File Format
Collector File Format
More like this
Collector Flat File Directories
Collector Flat File Directories
More like this
Collector File Document Numbers
Collector File Document Numbers
More like this
FRS Bank Reconciliation Jobs
FRS Bank Reconciliation Jobs
More like this
Sample Billing email reports
Sample Billing email reports
More like this
KFS Integrations - Concur
KFS Integrations - Concur
More like this