3Com 900-0234-01 IP Phone User Manual


 
310 APPENDIX E: MANUALLY CONFIGURING THE BILLING SUPPORT SERVER
Configuring
job_export_fields
_map
The job_export_fields_map table establishes which CDR fields are
exportable for each code source ID type. To export a specific CDR field for
a specific code source ID, include an entry in this table.
To edit the table:
1 Using a text editor, open one of the following files:
To load data into an empty table, open the
/opt/3com/VCX/bss/db/cwbss/bulkload/job_export_fields_map_data.tx
t file.
To append data, open the
/opt/3com/VCX/bss/db/cwbss/bulkload/custom/job_export_fields_map
_data.txt file.
2 Add one row for each job to cdr mapping. For example:
|CODE_SOURCE_ID|DDL_FLD_ID|ORDER_IN_SRCID
259|1|1|
3 Save and close the file.
Table 113 job_export_fields_map Fields
Column Name Description Value
CODE_SOURCE_ID Source identifier code.
This field maps to the code_cdr_source_id table in
the CWCOM database.
Integer
DDL_FLD_ID Defines the CDR field ID.
This field maps to the ddl_cdr_fields table in the
CWBSS database.
Integer
ORDER_IN_SRCID The order in which the CDRs are output to file. This
order is for each CODE_SOURCE_ID.
Integer
SUB_FIELD not used. N/A