|
|
CONDITION REPORT
----------------
FILE - OEINVOICE
Condition Type
--------------------------------------------------------------------------------
AR/GL-UPDATED FILEFLD, STATE
where ( Status = 9 )
Is Used In No Indexes
Is Used In Rel - OEDIST
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
--------------------------------------------------------------------------------
ARICREDIT FILEFLD
where ( Status = 9
And ( Invc Source = "R"
Or Invc Source = "C" ))
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
--------------------------------------------------------------------------------
ARIOHDR FILEFLD, OTOFLDS
where ( Status = 9
And Oeinvctype->Invc Cred Fl = "N" )
Is Used In No Indexes
Is Used In Rel - AROIHDR
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
--------------------------------------------------------------------------------
AROIHDR-CM FILEFLD, OTOFLDS
where ( Status = 9
And Oeinvctype->Invc Cred Fl = "Y" )
Is Used In No Indexes
Is Used In Rel - AROIHDR-CM
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
--------------------------------------------------------------------------------
BATCH-EXISTS FILEFLD
where ( Batch Nbr != Zeroes )
Is Used In No Indexes
Is Used In Rel - INVCHDR
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
--------------------------------------------------------------------------------
BATCH-REQUIRED FILEFLD
where ( Invc Source != "S" )
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
--------------------------------------------------------------------------------
BILL-TO-ENTERD FILEFLD
where ( Bill To != Zeroes )
Is Used In No Indexes
Is Used In Rel - BILLTO
Is Used In No SubType
Is Used In No States
Is Used In CndFld - BT-ADDR1
- BT-ADDR2
- BT-ADDR3
- BT-ADDR4
- BT-CITY
- BT-COUNTRY
- BT-COUNTY
- BT-NAME
- BT-STATE
- BT-ZIP
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
CANCELLED FILEFLD, STATE
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
--------------------------------------------------------------------------------
CREDIT-MEMO OTOFLDS
where ( Oeinvctype->Invc Cred Fl = "Y" )
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
--------------------------------------------------------------------------------
CURR-CHANGED FILEFLD
where ( Old(Currency Code) != Currency Code )
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
--------------------------------------------------------------------------------
CURR-ENTERED FILEFLD
where ( Currency Code != Spaces )
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
--------------------------------------------------------------------------------
CURR-OVERRDDN FILEFLD, OTOFLDS
where ( Currency Code != Arcustomer->Currency Cd )
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
--------------------------------------------------------------------------------
CURR-RATE-CHGD FILEFLD
where ( Old(Curr Rate) != Curr Rate )
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
--------------------------------------------------------------------------------
CUST-CHANGED FILEFLD
where ( Old(Customer) != Customer )
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
--------------------------------------------------------------------------------
CUSTORDER FILEFLD
where ( Order Nbr != Zeroes )
Is Used In No Indexes
Is Used In Rel - CUSTORDER
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
--------------------------------------------------------------------------------
EDITTED FILEFLD, STATE
where ( 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
--------------------------------------------------------------------------------
FRT-CODE FILEFLD
where ( Invc Source = "S"
And Freight Code != Spaces )
Is Used In No Indexes
Is Used In Rel - OEFRTCODE
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
--------------------------------------------------------------------------------
HDR-COMM-EXIST OTOFLDS
where ( Relation: Hdr Comments Exists )
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
--------------------------------------------------------------------------------
HEADER-TAX OTOFLDS
where ( Oecompany->Tax Print Cd = "S" )
Is Used In No Indexes
Is Used In Rel - HEADER-TAX
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
--------------------------------------------------------------------------------
HOLDCODES FILEFLD
where ( Hold Code != Spaces )
Is Used In No Indexes
Is Used In Rel - HOLDCODES
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
--------------------------------------------------------------------------------
INV-EDIT-REQ OTOFLDS
where ( Oecompany->Invc Edit Opt = "Y" )
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
--------------------------------------------------------------------------------
INV-TYPE-CHG FILEFLD
where ( Old(Invc Type) != Invc Type )
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
--------------------------------------------------------------------------------
INVOICE OTOFLDS
where ( Oeinvctype->Invc Cred Fl = "N" )
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 FILEFLD
where ( 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 No CndFlds
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
NO-CURR-OVERR OTOFLDS
where ( Oecompany->Curr Ovr Fl = "N" )
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
--------------------------------------------------------------------------------
NO-RATE-OVERR OTOFLDS
where ( Oecompany->Rate Ovr Fl = "N" )
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
--------------------------------------------------------------------------------
NO-TAX-CODE FILEFLD
where ( Tax Code = Spaces )
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
--------------------------------------------------------------------------------
NON-SYSTEM-INV FILEFLD
where ( Invc Source != "S" )
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
--------------------------------------------------------------------------------
NONBASE-TRAN FILEFLD, OTOFLDS
where ( Currency Code != Oecompany->Currency Code )
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
--------------------------------------------------------------------------------
NOT-GL-UPDATED FILEFLD
where ( Status < 4 )
Is Used In Index - OEISET7
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
--------------------------------------------------------------------------------
NOT-SA-UPDATED FILEFLD
where ( Sa Invoice Fl != "Y"
And Status = 9 )
Is Used In Index - OEISET10
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
--------------------------------------------------------------------------------
OEISET2 FILEFLD
where ( Status < 9 )
Is Used In Index - OEISET2
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
--------------------------------------------------------------------------------
OEISET5 FILEFLD
where ( Hold Code != Spaces )
Is Used In Index - OEISET5
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
--------------------------------------------------------------------------------
OEISET6 FILEFLD
where((( Status = 3 )
Or ( Status = 9 ))
And ( Sa Invoice Fl = "N" ))
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
--------------------------------------------------------------------------------
OEISET9 FILEFLD
where ( Status = 1
Or Status = 2 )
Is Used In Index - OEISET9
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
--------------------------------------------------------------------------------
ONE-CURRENCY OTOFLDS
where ( Oecompany->Multi Curr Fl = "N" )
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-NE-ZERO FILEFLD
where ( Order 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
--------------------------------------------------------------------------------
ORDER-SHIP-TO FILEFLD
where ( Order Nbr != Zeroes
And Shipment Nbr != Zeroes
And Invc Source = "S" )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - ST-ADDR1
- ST-ADDR2
- ST-ADDR3
- ST-ADDR4
- ST-CITY
- ST-COUNTRY
- ST-COUNTY
- ST-NAME
- ST-STATE
- ST-ZIP
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
PL-CHANGED FILEFLD
where ( Old(Process Level) != Process Level )
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
--------------------------------------------------------------------------------
PRINTED FILEFLD, STATE
where ( Status = 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
--------------------------------------------------------------------------------
PROCESSED FILEFLD, STATE
where ( Status = 9 )
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
--------------------------------------------------------------------------------
REASON-CODE FILEFLD
where ( Reason Code != Spaces )
Is Used In No Indexes
Is Used In Rel - OEREASON
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
--------------------------------------------------------------------------------
RECURRING-INVC FILEFLD
where ( Recur Invoice != Spaces )
Is Used In No Indexes
Is Used In Rel - BLRICUST
- BRIMAST
- OECUSTSRVC
- OEMASTSRVC
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
--------------------------------------------------------------------------------
RELEASED FILEFLD, STATE
where ( Status = 1 )
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
--------------------------------------------------------------------------------
RET-AUTH-ENTRD FILEFLD
where ( Auth No != Zeroes )
Is Used In No Indexes
Is Used In Rel - RETURNHDR
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
--------------------------------------------------------------------------------
SALESMAN2 FILEFLD
where ( Salesman 2 != Zeroes )
Is Used In No Indexes
Is Used In Rel - SALESMAN2
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
--------------------------------------------------------------------------------
SHIP-TO-ENTERD FILEFLD
where ( Ship To != 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 - ST-ADDR1
- ST-ADDR2
- ST-ADDR3
- ST-ADDR4
- ST-CITY
- ST-COUNTRY
- ST-COUNTY
- ST-NAME
- ST-STATE
- ST-ZIP
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
SHIPMENT-VEND FILEFLD, OTOFLDS
where ( Invc Source = "S"
And Whshipment->Carrier != Spaces )
Is Used In No Indexes
Is Used In Rel - APCOMPANY
- APVENMAST
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
--------------------------------------------------------------------------------
SHIPMNT-METHOD FILEFLD, OTOFLDS
where ( Invc Source = "S"
And Whshipment->Method != Spaces )
Is Used In No Indexes
Is Used In Rel - OEMETHOD
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
--------------------------------------------------------------------------------
SHIPTO FILEFLD
where ( Ship To != Zeroes )
Is Used In No Indexes
Is Used In Rel - SHIPTO
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
--------------------------------------------------------------------------------
SYSTEM-INVOICE FILEFLD
where ( Shipment Nbr != Zeroes )
Is Used In No Indexes
Is Used In Rel - WHSHIPMENT
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
--------------------------------------------------------------------------------
TAX-CODE FILEFLD
where ( Tax Code != Spaces )
Is Used In No Indexes
Is Used In Rel - TXTAXCODE
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
--------------------------------------------------------------------------------
TERMS-CD FILEFLD
where ( Terms Cd != Spaces )
Is Used In No Indexes
Is Used In Rel - TERMS
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
--------------------------------------------------------------------------------
TLR-COMM-EXIST OTOFLDS
where ( Relation: Tlr Comments Exists )
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
--------------------------------------------------------------------------------
TXCODEMAST OTOFLDS
where ( Relation: Txcodemast Exists )
Is Used In No Indexes
Is Used In No Rels
Is Used In No SubType
Is Used In No States
Is Used In CndFld - TAX-DESC
Is Used In No AvfFlds
Is Used In No Rules
Condition Type
--------------------------------------------------------------------------------
TXCOMPANY OTOFLDS
where ( Relation: Txcompany Exists )
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
--------------------------------------------------------------------------------
TXTAXCODE OTOFLDS
where ( Relation: Txtaxcode Exists )
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
--------------------------------------------------------------------------------
UNRELEASED FILEFLD, STATE
where ( Status = Zeroes )
Is Used In Index - OEISET8
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
--------------------------------------------------------------------------------
ZERO-PAYMENT FILEFLD
where ( Cia Amt = 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
|
