CONDITION REPORT
----------------
FILE - COMISC
Condition Type
--------------------------------------------------------------------------------
AOC-CODE FILEFLD
where ( Aoc Code != Spaces
And Status != 8 )
Is Used In Index - CMCSET3
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CGS-ACCOUNT FILEFLD
where ( Cgs Acct Unit != Spaces
Or Cgs Account != Zeroes
Or Cgs Sub Acct != Zeroes )
Is Used In No Indexes
Is Used In Rel - CGS-ACCOUNT
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
COLINE FILEFLD
where ( Line Nbr != Zeroes )
Is Used In No Indexes
Is Used In Rel - COLINE
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
COMMITTED FILEFLD
where ( Atn Obj Id != Zeroes )
Is Used In Index - CMCSET4
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
COMMITTED-C FILEFLD
where ( Atn Obj Id C != Zeroes )
Is Used In Index - CMCSET5
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
FLAT-AMOUNT FILEFLD
where ( Charge Type = 1 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - PRT-PRC-CURR
- PRT-PRICE
Is Used In No AvfFlds
Is Used In 1 Rule
Condition Type
--------------------------------------------------------------------------------
LINE-ADD-ON FILEFLD
where ( Line Nbr != Zeroes )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
LINE-PCT FILEFLD
where ( Line Nbr != Zeroes
And Charge Type = 3 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
LINE-UNIT-PRC FILEFLD
where ( Line Nbr != Zeroes
And Charge Type = 2 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
MULT-RATE OTOFLDS
where ( Custorder->Curr Mudv = "M" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - BILLED-BASE
- TAX-AMT-BASE
- TAXABLE-BASE
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
NOT-CANCELLED FILEFLD
where ( Status != 8 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
OFF-ACCOUNT FILEFLD
where ( Off Acct Unit != Spaces
Or Off Account != Zeroes
Or Off Sub Acct != Zeroes )
Is Used In No Indexes
Is Used In Rel - OFF-ACCOUNT
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
OPEN FILEFLD
where ( Status = 1
Or Status = 2 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ORDER-AOC FILEFLD
where ( Line Nbr = Zeroes )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - PRT-PRC-CURR
- PRT-PRICE
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
ORDER-PCT FILEFLD
where ( Line Nbr = Zeroes
And Charge Type = 3 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
PER-UNIT FILEFLD
where ( Charge Type = 2 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - PER-UNIT-FL
- PRT-PRC-CURR
- PRT-PRICE
- SCREEN-PRICE
Is Used In No AvfFlds
Is Used In 1 Rule
Condition Type
--------------------------------------------------------------------------------
PERCENTAGE FILEFLD
where ( Charge Type = 3 )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In 1 Rule
Condition Type
--------------------------------------------------------------------------------
SALES-ACCOUNT FILEFLD
where ( Sls Acct Unit != Spaces
Or Sls Account != Zeroes
Or Sls Sub Acct != Zeroes )
Is Used In No Indexes
Is Used In Rel - SALES-ACCOUNT
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SHIPPED FILEFLD
where ( Shipment Nbr != Zeroes
And Line Nbr = Zeroes )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SHIPPED-LINE FILEFLD
where ( Shipment Nbr != Zeroes
And Line Nbr != Zeroes )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
|
