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.