PRE_AR_CHG_CRC
Description:
This table holds the CRC information for a given charge line of a single transaction record. CRC stands for Condition Indicator, and in this case it is specifically vision-related CRC. Note: temporary accounts receivable (TAR) records in Chronicles are purged periodically depending on your system setting. Be aware that old data in this table might be lost if you truncate the table.

Primary Key
Column Name Ordinal Position
TAR_ID 1
CHARGE_LINE 2

Column Information
Name Type Discontinued?
1 TAR_ID NUMERIC No
The unique identifier for the transaction record.
2 CHARGE_LINE INTEGER No
The line number for the information associated with this transaction record. This represents a single charge procedure in the transaction.
3 CODE_C INTEGER No
What sort of vision-related hardware was given. 1 = E1 - Spectacle Lenses 2 = E2 - Contact Lenses 3 = E3 - Spectacle Frames
4 CONDITION_1_C INTEGER No
The condition indicator code category ID. 1 = L1 - General Standard of 20 Degree or .5 Diopter Sphere or Cylinder Change Met 2 = L2 - Replacement Due to Loss or Theft 3 = L3 - Replacement Due to Breakage or Damage.
5 CONDITION_2_C INTEGER No
The condition indicator code category ID. 1 = L1 - General Standard of 20 Degree or .5 Diopter Sphere or Cylinder Change Met 2 = L2 - Replacement Due to Loss or Theft 3 = L3 - Replacement Due to Breakage or Damage.
6 CONDITION_3_C INTEGER No
The condition indicator code category ID. 1 = L1 - General Standard of 20 Degree or .5 Diopter Sphere or Cylinder Change Met 2 = L2 - Replacement Due to Loss or Theft 3 = L3 - Replacement Due to Breakage or Damage.
7 CONDITION_4_C INTEGER No
The condition indicator code category ID. 1 = L1 - General Standard of 20 Degree or .5 Diopter Sphere or Cylinder Change Met 2 = L2 - Replacement Due to Loss or Theft 3 = L3 - Replacement Due to Breakage or Damage.
8 CONDITION_5_C INTEGER No
The condition indicator code category ID. 1 = L1 - General Standard of 20 Degree or .5 Diopter Sphere or Cylinder Change Met 2 = L2 - Replacement Due to Loss or Theft 3 = L3 - Replacement Due to Breakage or Damage.